PREVIEW / stock_30min / 2019-04-18

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-04-18.parquet
  size:    1.7 MB
  rows:    83,690
  symbols: 2,622

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2019-04-18 04:00:00	AAPL	Stock	50.4925	50.5025	50.48	50.48	17668.0
2019-04-18 04:30:00	AAPL	Stock	50.4975	50.51	50.4975	50.51	13168.0
2019-04-18 05:00:00	AAPL	Stock	50.5275	50.5425	50.5275	50.5425	1068.0
2019-04-18 05:30:00	AAPL	Stock	50.55	50.6725	50.5425	50.6375	6800.0
2019-04-18 06:00:00	AAPL	Stock	50.58	50.6375	50.58	50.6375	6140.0
2019-04-18 06:30:00	AAPL	Stock	50.6325	50.65	50.565	50.565	2340.0
2019-04-18 07:00:00	AAPL	Stock	50.5875	50.6875	50.58	50.6375	56176.0
2019-04-18 07:30:00	AAPL	Stock	50.65	50.7875	50.625	50.75	95044.0
2019-04-18 08:00:00	AAPL	Stock	50.65	50.8375	50.6025	50.7825	258512.0
2019-04-18 08:30:00	AAPL	Stock	50.7925	50.85	50.6275	50.6625	226564.0
2019-04-18 09:00:00	AAPL	Stock	50.6725	50.975	50.6175	50.78	1089556.0
2019-04-18 09:30:00	AAPL	Stock	50.78	50.9625	50.6825	50.7712	20717320.0
2019-04-18 10:00:00	AAPL	Stock	50.7725	50.8425	50.63	50.8	7031696.0
2019-04-18 10:30:00	AAPL	Stock	50.795	50.875	50.7175	50.8725	5627292.0
2019-04-18 11:00:00	AAPL	Stock	50.8725	50.985	50.78	50.8125	5780220.0
2019-04-18 11:30:00	AAPL	Stock	50.815	50.8725	50.76	50.8075	3246880.0
2019-04-18 12:00:00	AAPL	Stock	50.8075	50.8725	50.785	50.8225	2287564.0
2019-04-18 12:30:00	AAPL	Stock	50.8225	50.915	50.7925	50.8188	2592648.0
2019-04-18 13:00:00	AAPL	Stock	50.82	50.91	50.7875	50.8875	2443324.0
2019-04-18 13:30:00	AAPL	Stock	50.8875	50.95	50.8675	50.93	2253616.0
2019-04-18 14:00:00	AAPL	Stock	50.935	51.0	50.9225	50.9875	3161800.0
2019-04-18 14:30:00	AAPL	Stock	50.9875	51.0125	50.935	50.9725	2941028.0
2019-04-18 15:00:00	AAPL	Stock	50.9725	51.015	50.95	51.01	2527568.0
2019-04-18 15:30:00	AAPL	Stock	51.0075	51.0375	50.9025	50.965	7346160.0
2019-04-18 16:00:00	AAPL	Stock	50.9662	50.9662	50.935	50.9575	12367524.0
2019-04-18 16:30:00	AAPL	Stock	50.9572	50.9825	50.9425	50.9525	45008.0
2019-04-18 17:00:00	AAPL	Stock	50.9575	50.9575	50.9375	50.9375	19276.0
2019-04-18 17:30:00	AAPL	Stock	50.945	50.9575	50.9375	50.94	6432.0
2019-04-18 18:00:00	AAPL	Stock	50.94	50.9425	50.94	50.9425	904.0
2019-04-18 18:30:00	AAPL	Stock	50.94	50.955	50.94	50.955	1200.0
2019-04-18 19:00:00	AAPL	Stock	50.955	50.955	50.9425	50.9425	6944.0
2019-04-18 19:30:00	AAPL	Stock	50.94	50.9575	50.94	50.9575	8740.0
2019-04-18 04:00:00	MSFT	Stock	121.2	121.2	120.99	120.99	731.0
2019-04-18 04:30:00	MSFT	Stock	121.05	121.05	121.04	121.04	200.0
2019-04-18 05:00:00	MSFT	Stock	121.04	121.04	121.04	121.04	200.0
2019-04-18 05:30:00	MSFT	Stock	121.04	121.38	121.04	121.38	600.0
2019-04-18 06:00:00	MSFT	Stock	121.16	121.16	121.16	121.16	100.0
2019-04-18 07:00:00	MSFT	Stock	121.36	121.38	121.23	121.38	4694.0
2019-04-18 07:30:00	MSFT	Stock	121.34	121.34	121.32	121.32	674.0
2019-04-18 08:00:00	MSFT	Stock	121.3	121.47	121.23	121.39	5798.0
2019-04-18 08:30:00	MSFT	Stock	121.43	121.7	121.43	121.59	8426.0
2019-04-18 09:00:00	MSFT	Stock	121.54	123.14	121.49	122.15	325668.0
2019-04-18 09:30:00	MSFT	Stock	122.16	122.58	121.302	121.56	5770086.0
2019-04-18 10:00:00	MSFT	Stock	121.57	122.25	121.48	121.905	1696643.0
2019-04-18 10:30:00	MSFT	Stock	121.905	122.3	121.68	122.16	1224617.0
2019-04-18 11:00:00	MSFT	Stock	122.155	122.4	122.01	122.04	948268.0
2019-04-18 11:30:00	MSFT	Stock	122.05	122.47	122.04	122.445	1033883.0
2019-04-18 12:00:00	MSFT	Stock	122.44	122.51	122.32	122.408	866142.0
2019-04-18 12:30:00	MSFT	Stock	122.4	122.99	122.37	122.876	2069497.0
2019-04-18 13:00:00	MSFT	Stock	122.875	122.937	122.8	122.879	769163.0

> showing 50 of 83,690 rows — these rows as CSV

> unlock the full archive -- $79 one-time