PREVIEW / stock_30min / 2021-11-23

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-11-23.parquet
  size:    2.3 MB
  rows:    113,116
  symbols: 2,704

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-11-23 04:00:00	AAPL	Stock	159.99	160.2	159.51	159.9	39454.0
2021-11-23 04:30:00	AAPL	Stock	159.92	160.68	159.9	160.66	34373.0
2021-11-23 05:00:00	AAPL	Stock	160.79	160.79	160.64	160.78	8896.0
2021-11-23 05:30:00	AAPL	Stock	160.77	160.78	160.45	160.6	8000.0
2021-11-23 06:00:00	AAPL	Stock	160.52	160.55	160.2	160.48	19375.0
2021-11-23 06:30:00	AAPL	Stock	160.52	161.12	160.44	160.85	18511.0
2021-11-23 07:00:00	AAPL	Stock	160.86	161.36	160.85	161.01	116377.0
2021-11-23 07:30:00	AAPL	Stock	161.0	161.05	160.66	160.7	60772.0
2021-11-23 08:00:00	AAPL	Stock	161.273	161.41	160.65	161.41	268859.0
2021-11-23 08:30:00	AAPL	Stock	161.43	161.7099	161.1953	161.3	331223.0
2021-11-23 09:00:00	AAPL	Stock	161.26	161.55	160.84	160.97	318671.0
2021-11-23 09:30:00	AAPL	Stock	161.12	161.8	159.62	160.735	10644436.0
2021-11-23 10:00:00	AAPL	Stock	160.74	160.86	159.0601	159.665	8202550.0
2021-11-23 10:30:00	AAPL	Stock	159.66	160.58	159.545	159.96	6267063.0
2021-11-23 11:00:00	AAPL	Stock	159.9544	160.49	159.72	160.26	4956211.0
2021-11-23 11:30:00	AAPL	Stock	160.26	160.44	159.23	159.82	4900067.0
2021-11-23 12:00:00	AAPL	Stock	159.82	160.29	159.43	160.2201	4238308.0
2021-11-23 12:30:00	AAPL	Stock	160.22	160.61	159.73	159.781	4193117.0
2021-11-23 13:00:00	AAPL	Stock	159.78	160.11	159.21	159.31	3257369.0
2021-11-23 13:30:00	AAPL	Stock	159.3	160.0815	159.08	160.015	4373588.0
2021-11-23 14:00:00	AAPL	Stock	160.02	160.24	159.83	160.045	3416943.0
2021-11-23 14:30:00	AAPL	Stock	160.04	160.9	159.82	160.88	4088036.0
2021-11-23 15:00:00	AAPL	Stock	160.89	161.17	160.535	160.7201	4680254.0
2021-11-23 15:30:00	AAPL	Stock	160.73	161.69	160.65	161.41	7832638.0
2021-11-23 16:00:00	AAPL	Stock	161.42	161.76	161.27	161.37	6828836.0
2021-11-23 16:30:00	AAPL	Stock	161.36	161.41	161.32	161.36	55280.0
2021-11-23 17:00:00	AAPL	Stock	161.36	161.45	161.22	161.3	46765.0
2021-11-23 17:30:00	AAPL	Stock	161.3	161.32	161.25	161.31	20370.0
2021-11-23 18:00:00	AAPL	Stock	161.3	161.47	161.3	161.43	24428.0
2021-11-23 18:30:00	AAPL	Stock	161.41	161.41	161.3	161.31	18675.0
2021-11-23 19:00:00	AAPL	Stock	161.32	161.44	161.3	161.38	9572.0
2021-11-23 19:30:00	AAPL	Stock	161.4	161.4	161.0	161.25	59195.0
2021-11-23 04:00:00	MSFT	Stock	338.48	338.49	337.46	338.17	5636.0
2021-11-23 04:30:00	MSFT	Stock	338.11	338.6	338.0	338.6	4444.0
2021-11-23 05:00:00	MSFT	Stock	338.95	339.01	338.8	339.0	3881.0
2021-11-23 05:30:00	MSFT	Stock	339.01	339.01	338.61	338.61	3644.0
2021-11-23 06:00:00	MSFT	Stock	338.02	338.19	338.0	338.15	1282.0
2021-11-23 06:30:00	MSFT	Stock	338.03	338.65	338.0	338.46	1462.0
2021-11-23 07:00:00	MSFT	Stock	338.57	339.29	338.03	338.05	15107.0
2021-11-23 07:30:00	MSFT	Stock	338.03	338.89	337.98	338.41	7748.0
2021-11-23 08:00:00	MSFT	Stock	338.5	339.0927	337.9626	338.68	25934.0
2021-11-23 08:30:00	MSFT	Stock	338.5	339.0	338.0	338.0	11059.0
2021-11-23 09:00:00	MSFT	Stock	338.01	338.38	336.4	336.9	55056.0
2021-11-23 09:30:00	MSFT	Stock	336.91	339.45	334.31	339.06	3148735.0
2021-11-23 10:00:00	MSFT	Stock	339.07	339.11	334.12	334.32	2203141.0
2021-11-23 10:30:00	MSFT	Stock	334.2701	334.69	333.56	334.44	1433937.0
2021-11-23 11:00:00	MSFT	Stock	334.43	336.33	333.93	335.91	1206804.0
2021-11-23 11:30:00	MSFT	Stock	335.9	336.4	335.12	335.55	874871.0
2021-11-23 12:00:00	MSFT	Stock	335.55	335.68	334.31	335.08	677217.0
2021-11-23 12:30:00	MSFT	Stock	335.059	335.42	334.2	334.54	603153.0

> showing 50 of 113,116 rows — these rows as CSV

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