PREVIEW / stock_30min / 2018-03-28

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-03-28.parquet
  size:    1.7 MB
  rows:    83,430
  symbols: 2,873

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
2018-03-28 04:00:00	AAPL	Stock	41.975	41.975	41.6525	41.8625	8260.0
2018-03-28 04:30:00	AAPL	Stock	41.815	41.935	41.775	41.795	13140.0
2018-03-28 05:00:00	AAPL	Stock	41.85	41.85	41.77	41.8375	45468.0
2018-03-28 05:30:00	AAPL	Stock	41.8875	42.01	41.8875	41.9025	18192.0
2018-03-28 06:00:00	AAPL	Stock	41.9075	42.0	41.8	41.935	47100.0
2018-03-28 06:30:00	AAPL	Stock	41.905	42.0875	41.905	42.0225	18468.0
2018-03-28 07:00:00	AAPL	Stock	42.0275	42.315	42.0275	42.2375	236488.0
2018-03-28 07:30:00	AAPL	Stock	42.2625	42.3	41.97	42.0	285536.0
2018-03-28 08:00:00	AAPL	Stock	42.0612	42.285	41.905	42.0	558000.0
2018-03-28 08:30:00	AAPL	Stock	42.0025	42.0025	41.7525	41.835	635408.0
2018-03-28 09:00:00	AAPL	Stock	41.7925	41.85	41.6375	41.7825	706692.0
2018-03-28 09:30:00	AAPL	Stock	41.785	41.9475	41.2975	41.7375	21118048.0
2018-03-28 10:00:00	AAPL	Stock	41.7352	41.94	41.53	41.6575	10016552.0
2018-03-28 10:30:00	AAPL	Stock	41.6625	41.81	41.335	41.6325	11183708.0
2018-03-28 11:00:00	AAPL	Stock	41.6325	41.8725	41.6325	41.695	9819248.0
2018-03-28 11:30:00	AAPL	Stock	41.71	42.2375	41.665	42.0	10544576.0
2018-03-28 12:00:00	AAPL	Stock	42.01	42.505	41.945	42.1675	10020668.0
2018-03-28 12:30:00	AAPL	Stock	42.16	42.2225	41.7625	41.7975	7029328.0
2018-03-28 13:00:00	AAPL	Stock	41.795	42.11	41.6775	42.0125	6584612.0
2018-03-28 13:30:00	AAPL	Stock	42.0125	42.184	41.8125	41.9338	6373088.0
2018-03-28 14:00:00	AAPL	Stock	41.9375	42.0225	41.69	41.796	5608820.0
2018-03-28 14:30:00	AAPL	Stock	41.795	42.0575	41.715	41.75	7192544.0
2018-03-28 15:00:00	AAPL	Stock	41.7465	41.89	41.4825	41.8675	9209408.0
2018-03-28 15:30:00	AAPL	Stock	41.865	41.94	41.5975	41.62	15964552.0
2018-03-28 16:00:00	AAPL	Stock	41.62	41.675	41.6175	41.6575	7375684.0
2018-03-28 16:30:00	AAPL	Stock	41.6675	41.7125	41.6625	41.7125	25096.0
2018-03-28 17:00:00	AAPL	Stock	41.62	41.715	41.575	41.575	85572.0
2018-03-28 17:30:00	AAPL	Stock	41.575	41.6225	41.56	41.6225	93376.0
2018-03-28 18:00:00	AAPL	Stock	41.575	41.67	41.575	41.65	61828.0
2018-03-28 18:30:00	AAPL	Stock	41.65	41.7375	41.65	41.7	23364.0
2018-03-28 19:00:00	AAPL	Stock	41.6875	41.7	41.6875	41.7	25328.0
2018-03-28 19:30:00	AAPL	Stock	41.7	41.7125	41.675	41.7125	19160.0
2018-03-28 04:00:00	MSFT	Stock	89.39	89.39	89.0	89.34	1818.0
2018-03-28 04:30:00	MSFT	Stock	89.16	89.16	89.12	89.12	258.0
2018-03-28 05:00:00	MSFT	Stock	88.92	88.92	88.92	88.92	200.0
2018-03-28 05:30:00	MSFT	Stock	89.0	89.02	88.99	89.0	4601.0
2018-03-28 06:00:00	MSFT	Stock	89.0	89.08	89.0	89.05	1222.0
2018-03-28 06:30:00	MSFT	Stock	89.46	89.6	89.4	89.6	1847.0
2018-03-28 07:00:00	MSFT	Stock	89.56	90.65	89.56	90.65	51588.0
2018-03-28 07:30:00	MSFT	Stock	90.43	90.55	90.15	90.15	24719.0
2018-03-28 08:00:00	MSFT	Stock	90.5	90.5	89.9	89.91	34834.0
2018-03-28 08:30:00	MSFT	Stock	90.0	90.044	89.25	89.25	54938.0
2018-03-28 09:00:00	MSFT	Stock	89.55	90.0	89.049	89.81	160514.0
2018-03-28 09:30:00	MSFT	Stock	89.8	90.67	89.65	90.41	6981944.0
2018-03-28 10:00:00	MSFT	Stock	90.41	90.74	89.62	89.85	4091131.0
2018-03-28 10:30:00	MSFT	Stock	89.84	90.16	88.873	89.49	4058845.0
2018-03-28 11:00:00	MSFT	Stock	89.5	90.12	89.28	89.3	2679907.0
2018-03-28 11:30:00	MSFT	Stock	89.31	90.29	89.01	89.9	2654378.0
2018-03-28 12:00:00	MSFT	Stock	89.9	91.23	89.78	90.317	2754124.0
2018-03-28 12:30:00	MSFT	Stock	90.32	90.91	89.76	89.78	3304352.0

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

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