☰
Login
Signup
Home
›
Market data (WebSockets)
Howdy, Stranger!
It looks like you're new here. If you want to get involved, click one of these buttons!
Sign In
Register
Categories
Recent Discussions
Activity
Categories
13.2K
All Categories
0
Incidents
126
Node JS client
36
Go client
765
.Net API client
360
Kite Publisher
532
.Net / VBA / Excel (3rd party)
433
Algorithms and Strategies
964
Java client
1K
API clients
400
PHP client
3.8K
Python client
331
Mobile and Desktop apps
1.3K
Market data (WebSockets)
3.1K
General
In this Discussion
February 2018
tonystark
Tick Data Format and pd Converstion
babansfolio
February 2018
in
Market data (WebSockets)
@sujith
: Need your help again
Question:1
Does your Full Mode Tick data is on Jason Format? Below is one sample Format.
[
{
'tradable': True,
'mode': 'full',
'instrument_token': 128083204,
'last_price': 932.75,
'last_quantity': 10,
'average_price': 932.01,
'volume': 184931,
'buy_quantity': 160578,
'sell_quantity': 225589,
'ohlc': {'open': 924.2, 'high': 937.0, 'low': 923.75, 'close': 923.9},
'change': 0.9578958761770779,
'last_trade_time': datetime.datetime(2018, 2, 23, 15, 17, 40),
'oi': 0,
'oi_day_high': 0,
'oi_day_low': 0,
'timestamp': datetime.datetime(2018, 2, 23, 15, 17, 42),
'depth':
{
'buy':
[{'quantity': 205, 'price': 932.6, 'orders': 131074},
{'quantity': 214, 'price': 932.55, 'orders': 131074},
{'quantity': 128, 'price': 932.5, 'orders': 131074},
{'quantity': 108, 'price': 932.25, 'orders': 65537},
{'quantity': 177, 'price': 932.0, 'orders': 393222}],
'sell':
[{'quantity': 1008, 'price': 933.0, 'orders': 131074},
{'quantity': 25, 'price': 933.1, 'orders': 65537},
{'quantity': 90, 'price': 933.2, 'orders': 65537},
{'quantity': 108, 'price': 933.25, 'orders': 65537},
{'quantity': 250, 'price': 933.3, 'orders': 65537}]
}
}
]
Q2. If possible please share any idea/hints, how to converts it's on Pandas data frame?
Q3. Does "json.load" , "json_normalize" will help?
Q4. Any other efficient process in your mind?
tonystark
February 2018
Check out this
thread
.
Sign In
or
Register
to comment.