☰
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.3K
All Categories
0
Incidents
129
Node JS client
39
Go client
770
.Net API client
364
Kite Publisher
532
.Net / VBA / Excel (3rd party)
439
Algorithms and Strategies
973
Java client
1K
API clients
401
PHP client
3.8K
Python client
331
Mobile and Desktop apps
1.3K
Market data (WebSockets)
3.2K
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.