PREVIEW / stock_30min / 2020-05-28

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-05-28.parquet
  size:    1.9 MB
  rows:    96,159
  symbols: 2,387

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
2020-05-28 04:00:00	AAPL	Stock	79.375	79.3925	79.205	79.205	5132.0
2020-05-28 04:30:00	AAPL	Stock	79.2125	79.2125	79.125	79.125	2400.0
2020-05-28 05:00:00	AAPL	Stock	79.25	79.275	79.25	79.275	2740.0
2020-05-28 05:30:00	AAPL	Stock	79.25	79.25	79.01	79.0175	3768.0
2020-05-28 06:00:00	AAPL	Stock	79.095	79.2125	79.095	79.2125	9536.0
2020-05-28 06:30:00	AAPL	Stock	79.3375	79.45	79.22	79.405	3400.0
2020-05-28 07:00:00	AAPL	Stock	79.405	79.42	79.09	79.205	88188.0
2020-05-28 07:30:00	AAPL	Stock	79.15	79.2375	79.025	79.025	106912.0
2020-05-28 08:00:00	AAPL	Stock	79.05	79.435	78.725	78.825	286288.0
2020-05-28 08:30:00	AAPL	Stock	78.8225	79.1	78.625	78.815	270924.0
2020-05-28 09:00:00	AAPL	Stock	78.8575	79.1925	78.8125	79.17	184980.0
2020-05-28 09:30:00	AAPL	Stock	79.175	80.11	78.9075	79.835	14188304.0
2020-05-28 10:00:00	AAPL	Stock	79.85	80.1875	79.6125	80.175	7626352.0
2020-05-28 10:30:00	AAPL	Stock	80.1775	80.2	80.0025	80.1175	4773992.0
2020-05-28 11:00:00	AAPL	Stock	80.11	80.2675	79.9125	80.075	6305776.0
2020-05-28 11:30:00	AAPL	Stock	80.075	80.43	79.9425	80.4072	5311672.0
2020-05-28 12:00:00	AAPL	Stock	80.4025	80.4975	80.3175	80.4852	5818056.0
2020-05-28 12:30:00	AAPL	Stock	80.4862	80.75	80.4275	80.605	7506916.0
2020-05-28 13:00:00	AAPL	Stock	80.609	80.7325	80.5525	80.715	4099424.0
2020-05-28 13:30:00	AAPL	Stock	80.715	80.8375	80.57	80.63	5816876.0
2020-05-28 14:00:00	AAPL	Stock	80.6262	80.7138	80.4525	80.5525	4764936.0
2020-05-28 14:30:00	AAPL	Stock	80.5525	80.6725	80.4375	80.5825	4194332.0
2020-05-28 15:00:00	AAPL	Stock	80.58	80.86	80.0275	80.0475	9630916.0
2020-05-28 15:30:00	AAPL	Stock	80.04	80.235	79.39	79.55	16550696.0
2020-05-28 16:00:00	AAPL	Stock	79.5575	79.875	79.5537	79.75	13720324.0
2020-05-28 16:30:00	AAPL	Stock	79.75	79.86	79.65	79.8475	136012.0
2020-05-28 17:00:00	AAPL	Stock	79.8	79.8475	79.75	79.8475	52800.0
2020-05-28 17:30:00	AAPL	Stock	79.81	79.85	79.75	79.85	26512.0
2020-05-28 18:00:00	AAPL	Stock	79.855	79.86	79.625	79.7225	55940.0
2020-05-28 18:30:00	AAPL	Stock	79.725	79.75	79.64	79.675	68724.0
2020-05-28 19:00:00	AAPL	Stock	79.73	79.7375	79.625	79.625	21116.0
2020-05-28 19:30:00	AAPL	Stock	79.6225	79.6225	79.39	79.525	81316.0
2020-05-28 04:30:00	MSFT	Stock	181.59	181.59	181.5	181.55	400.0
2020-05-28 05:00:00	MSFT	Stock	181.25	181.6	181.25	181.56	1082.0
2020-05-28 05:30:00	MSFT	Stock	181.2	181.2	180.72	180.72	1503.0
2020-05-28 06:00:00	MSFT	Stock	180.56	181.16	180.56	181.16	1786.0
2020-05-28 06:30:00	MSFT	Stock	181.35	181.39	180.97	181.25	2725.0
2020-05-28 07:00:00	MSFT	Stock	181.44	181.6	180.65	180.94	10382.0
2020-05-28 07:30:00	MSFT	Stock	181.0	181.18	180.2	180.2	13279.0
2020-05-28 08:00:00	MSFT	Stock	180.999	181.45	179.15	179.3	54259.0
2020-05-28 08:30:00	MSFT	Stock	179.34	179.8	178.5	179.26	60642.0
2020-05-28 09:00:00	MSFT	Stock	179.5	181.0	179.2	180.8	71032.0
2020-05-28 09:30:00	MSFT	Stock	180.8	182.38	180.52	181.03	3050428.0
2020-05-28 10:00:00	MSFT	Stock	181.04	182.025	180.38	181.81	1812515.0
2020-05-28 10:30:00	MSFT	Stock	181.81	182.37	181.45	182.24	1579718.0
2020-05-28 11:00:00	MSFT	Stock	182.24	182.47	181.445	182.09	1723405.0
2020-05-28 11:30:00	MSFT	Stock	182.09	182.47	181.41	182.445	1231241.0
2020-05-28 12:00:00	MSFT	Stock	182.43	182.7	182.3	182.68	1227315.0
2020-05-28 12:30:00	MSFT	Stock	182.68	183.83	182.6	183.325	1681386.0
2020-05-28 13:00:00	MSFT	Stock	183.32	183.99	183.32	183.94	1123502.0

> showing 50 of 96,159 rows — these rows as CSV

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