PREVIEW / stock_30min / 2021-09-23

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-09-23.parquet
  size:    2.2 MB
  rows:    109,566
  symbols: 2,726

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-09-23 04:00:00	AAPL	Stock	146.71	147.1	146.71	146.97	25549.0
2021-09-23 04:30:00	AAPL	Stock	146.97	147.25	146.97	147.21	8994.0
2021-09-23 05:00:00	AAPL	Stock	147.21	147.68	147.12	147.44	19068.0
2021-09-23 05:30:00	AAPL	Stock	147.5	147.57	147.33	147.55	25612.0
2021-09-23 06:00:00	AAPL	Stock	147.54	147.58	146.92	147.25	53597.0
2021-09-23 06:30:00	AAPL	Stock	147.21	147.24	146.93	147.2	25118.0
2021-09-23 07:00:00	AAPL	Stock	147.2	147.36	147.0	147.25	84121.0
2021-09-23 07:30:00	AAPL	Stock	147.25	147.54	147.2	147.27	145488.0
2021-09-23 08:00:00	AAPL	Stock	147.0299	147.53	147.0	147.14	330165.0
2021-09-23 08:30:00	AAPL	Stock	147.12	147.26	146.63	146.77	249007.0
2021-09-23 09:00:00	AAPL	Stock	146.76	146.85	146.51	146.54	341009.0
2021-09-23 09:30:00	AAPL	Stock	146.62	146.75	145.64	146.265	10110066.0
2021-09-23 10:00:00	AAPL	Stock	146.275	146.98	146.2201	146.7741	5501977.0
2021-09-23 10:30:00	AAPL	Stock	146.77	147.08	146.56	146.94	4025660.0
2021-09-23 11:00:00	AAPL	Stock	146.955	146.985	146.36	146.64	3709897.0
2021-09-23 11:30:00	AAPL	Stock	146.64	146.95	146.52	146.9199	3013619.0
2021-09-23 12:00:00	AAPL	Stock	146.91	146.94	146.51	146.595	3109724.0
2021-09-23 12:30:00	AAPL	Stock	146.59	146.78	146.58	146.59	2432243.0
2021-09-23 13:00:00	AAPL	Stock	146.59	146.92	146.54	146.9112	2573308.0
2021-09-23 13:30:00	AAPL	Stock	146.9199	147.04	146.81	147.02	2107019.0
2021-09-23 14:00:00	AAPL	Stock	147.0189	147.0271	146.71	146.771	1945739.0
2021-09-23 14:30:00	AAPL	Stock	146.7795	146.98	146.71	146.95	2419056.0
2021-09-23 15:00:00	AAPL	Stock	146.9529	146.98	146.71	146.805	2321506.0
2021-09-23 15:30:00	AAPL	Stock	146.81	146.99	146.7	146.75	6678651.0
2021-09-23 16:00:00	AAPL	Stock	146.75	146.92	146.7	146.75	5648613.0
2021-09-23 16:30:00	AAPL	Stock	146.78	146.78	146.63	146.74	23823.0
2021-09-23 17:00:00	AAPL	Stock	146.73	148.63	146.7	146.8483	22884.0
2021-09-23 17:30:00	AAPL	Stock	146.84	146.85	146.78	146.82	11861.0
2021-09-23 18:00:00	AAPL	Stock	146.8	146.84	146.77	146.77	24139.0
2021-09-23 18:30:00	AAPL	Stock	146.8	146.85	146.78	146.84	5264.0
2021-09-23 19:00:00	AAPL	Stock	146.82	146.9	146.82	146.89	16515.0
2021-09-23 19:30:00	AAPL	Stock	146.89	146.9	146.83	146.9	45934.0
2021-09-23 04:00:00	MSFT	Stock	300.23	300.8	300.01	300.79	2666.0
2021-09-23 05:00:00	MSFT	Stock	300.9	301.5	300.9	301.27	7711.0
2021-09-23 05:30:00	MSFT	Stock	301.25	301.25	300.89	301.0	1146.0
2021-09-23 06:00:00	MSFT	Stock	301.02	301.45	300.11	300.79	6651.0
2021-09-23 06:30:00	MSFT	Stock	300.64	300.64	300.32	300.32	1449.0
2021-09-23 07:00:00	MSFT	Stock	300.43	300.46	299.71	300.0	18767.0
2021-09-23 07:30:00	MSFT	Stock	299.91	300.48	299.55	299.77	14629.0
2021-09-23 08:00:00	MSFT	Stock	300.3898	300.47	299.49	300.18	10674.0
2021-09-23 08:30:00	MSFT	Stock	300.08	300.25	298.98	299.0	16548.0
2021-09-23 09:00:00	MSFT	Stock	299.07	299.4	298.11	298.7	38436.0
2021-09-23 09:30:00	MSFT	Stock	298.96	299.63	297.5339	299.29	1915778.0
2021-09-23 10:00:00	MSFT	Stock	299.295	300.74	299.27	300.245	1228729.0
2021-09-23 10:30:00	MSFT	Stock	300.26	300.9	299.83	300.62	886988.0
2021-09-23 11:00:00	MSFT	Stock	300.64	300.6784	299.3201	299.9	749457.0
2021-09-23 11:30:00	MSFT	Stock	299.9	300.2501	299.43	300.165	661091.0
2021-09-23 12:00:00	MSFT	Stock	300.18	300.205	299.35	299.74	559765.0
2021-09-23 12:30:00	MSFT	Stock	299.7527	299.98	299.58	299.65	460472.0
2021-09-23 13:00:00	MSFT	Stock	299.66	300.146	299.495	300.07	474996.0

> showing 50 of 109,566 rows — these rows as CSV

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