PREVIEW / stock_30min / 2021-08-24

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-08-24.parquet
  size:    2.2 MB
  rows:    110,370
  symbols: 2,799

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
2021-08-24 04:00:00	AAPL	Stock	150.0	150.21	150.0	150.13	19811.0
2021-08-24 04:30:00	AAPL	Stock	150.14	150.14	149.96	150.04	17762.0
2021-08-24 05:00:00	AAPL	Stock	150.04	150.12	150.0	150.03	11364.0
2021-08-24 05:30:00	AAPL	Stock	149.95	149.95	149.69	149.75	9547.0
2021-08-24 06:00:00	AAPL	Stock	149.77	149.8	149.62	149.75	4477.0
2021-08-24 06:30:00	AAPL	Stock	149.73	149.76	149.63	149.7	7158.0
2021-08-24 07:00:00	AAPL	Stock	149.73	149.82	149.55	149.64	53516.0
2021-08-24 07:30:00	AAPL	Stock	149.66	149.68	149.41	149.53	58743.0
2021-08-24 08:00:00	AAPL	Stock	149.65	149.78	149.336	149.5	129274.0
2021-08-24 08:30:00	AAPL	Stock	149.47	149.57	149.38	149.49	91916.0
2021-08-24 09:00:00	AAPL	Stock	149.47	149.7	149.44	149.46	127030.0
2021-08-24 09:30:00	AAPL	Stock	149.45	150.86	149.15	150.58	9548583.0
2021-08-24 10:00:00	AAPL	Stock	150.59	150.73	150.1301	150.4511	4533422.0
2021-08-24 10:30:00	AAPL	Stock	150.45	150.51	149.925	149.99	3256030.0
2021-08-24 11:00:00	AAPL	Stock	149.9999	149.9999	149.445	149.4801	3231451.0
2021-08-24 11:30:00	AAPL	Stock	149.48	149.95	149.3051	149.83	3478996.0
2021-08-24 12:00:00	AAPL	Stock	149.83	149.9299	149.56	149.695	2085453.0
2021-08-24 12:30:00	AAPL	Stock	149.69	149.71	149.52	149.56	1599725.0
2021-08-24 13:00:00	AAPL	Stock	149.5505	149.74	149.48	149.6158	1715180.0
2021-08-24 13:30:00	AAPL	Stock	149.6186	149.81	149.52	149.6449	1511036.0
2021-08-24 14:00:00	AAPL	Stock	149.65	149.67	149.5001	149.529	1431422.0
2021-08-24 14:30:00	AAPL	Stock	149.52	149.77	149.5	149.74	1553499.0
2021-08-24 15:00:00	AAPL	Stock	149.75	149.905	149.71	149.7968	1868449.0
2021-08-24 15:30:00	AAPL	Stock	149.791	149.81	149.455	149.63	3496508.0
2021-08-24 16:00:00	AAPL	Stock	149.62	149.67	149.5	149.64	3021806.0
2021-08-24 16:30:00	AAPL	Stock	149.63	149.65	149.32	149.65	22986.0
2021-08-24 17:00:00	AAPL	Stock	149.64	149.67	149.61	149.64	8236.0
2021-08-24 17:30:00	AAPL	Stock	149.64	149.67	149.64	149.6501	13465.0
2021-08-24 18:00:00	AAPL	Stock	149.64	149.66	149.63	149.66	8259.0
2021-08-24 18:30:00	AAPL	Stock	149.65	149.65	149.61	149.61	7441.0
2021-08-24 19:00:00	AAPL	Stock	149.6	149.61	149.55	149.56	13634.0
2021-08-24 19:30:00	AAPL	Stock	149.57	149.66	149.53	149.58	20211.0
2021-08-24 04:00:00	MSFT	Stock	305.64	305.89	305.5	305.85	2217.0
2021-08-24 04:30:00	MSFT	Stock	305.9	305.95	305.56	305.56	5445.0
2021-08-24 05:00:00	MSFT	Stock	305.8	305.8	305.63	305.8	1328.0
2021-08-24 05:30:00	MSFT	Stock	305.75	305.75	305.3	305.3	3283.0
2021-08-24 06:00:00	MSFT	Stock	305.35	305.43	305.35	305.43	634.0
2021-08-24 06:30:00	MSFT	Stock	305.35	305.5	305.23	305.5	1725.0
2021-08-24 07:00:00	MSFT	Stock	305.45	305.49	304.81	304.81	11172.0
2021-08-24 07:30:00	MSFT	Stock	304.96	305.14	304.63	304.68	11829.0
2021-08-24 08:00:00	MSFT	Stock	305.25	305.411	303.77	304.06	16005.0
2021-08-24 08:30:00	MSFT	Stock	304.26	304.4	304.12	304.4	7605.0
2021-08-24 09:00:00	MSFT	Stock	304.38	305.5	304.38	304.93	20740.0
2021-08-24 09:30:00	MSFT	Stock	305.01	305.65	303.26	303.7	2037673.0
2021-08-24 10:00:00	MSFT	Stock	303.72	304.46	303.53	303.83	1025995.0
2021-08-24 10:30:00	MSFT	Stock	303.825	303.89	302.84	302.99	983475.0
2021-08-24 11:00:00	MSFT	Stock	302.98	303.25	302.31	302.31	927112.0
2021-08-24 11:30:00	MSFT	Stock	302.3	302.62	302.0035	302.61	974928.0
2021-08-24 12:00:00	MSFT	Stock	302.6	302.759	302.12	302.1938	522902.0
2021-08-24 12:30:00	MSFT	Stock	302.202	302.54	302.0735	302.39	504199.0

> showing 50 of 110,370 rows — these rows as CSV

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