PREVIEW / stock_30min / 2022-07-11

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-07-11.parquet
  size:    2.0 MB
  rows:    101,335
  symbols: 2,299

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
2022-07-11 04:00:00	AAPL	Stock	145.98	145.98	145.3	145.62	22079.0
2022-07-11 04:30:00	AAPL	Stock	145.7	145.87	145.59	145.63	7249.0
2022-07-11 05:00:00	AAPL	Stock	145.63	145.97	145.62	145.97	19091.0
2022-07-11 05:30:00	AAPL	Stock	145.83	146.05	145.82	145.86	15246.0
2022-07-11 06:00:00	AAPL	Stock	145.87	146.19	145.82	145.99	20721.0
2022-07-11 06:30:00	AAPL	Stock	146.02	146.09	145.91	145.98	3158.0
2022-07-11 07:00:00	AAPL	Stock	146.0	146.2	146.0	146.05	37174.0
2022-07-11 07:30:00	AAPL	Stock	146.05	146.1	145.82	145.82	30435.0
2022-07-11 08:00:00	AAPL	Stock	146.1097	146.673	145.5	146.06	76692.0
2022-07-11 08:30:00	AAPL	Stock	146.05	146.15	145.8	145.99	80484.0
2022-07-11 09:00:00	AAPL	Stock	146.0301	146.13	145.62	145.71	128060.0
2022-07-11 09:30:00	AAPL	Stock	145.71	145.85	143.78	144.32	7277112.0
2022-07-11 10:00:00	AAPL	Stock	144.3111	145.03	144.04	144.99	4386201.0
2022-07-11 10:30:00	AAPL	Stock	144.98	145.625	144.9309	145.065	3569517.0
2022-07-11 11:00:00	AAPL	Stock	145.06	145.66	144.91	145.39	3148151.0
2022-07-11 11:30:00	AAPL	Stock	145.4	145.49	144.93	145.15	2276521.0
2022-07-11 12:00:00	AAPL	Stock	145.15	145.49	145.0	145.3707	1916118.0
2022-07-11 12:30:00	AAPL	Stock	145.38	145.64	145.26	145.485	1804015.0
2022-07-11 13:00:00	AAPL	Stock	145.48	146.23	145.44	146.105	2795780.0
2022-07-11 13:30:00	AAPL	Stock	146.1012	146.64	146.1	146.415	2240472.0
2022-07-11 14:00:00	AAPL	Stock	146.4179	146.465	145.79	145.8042	2216508.0
2022-07-11 14:30:00	AAPL	Stock	145.805	145.96	145.32	145.32	2459800.0
2022-07-11 15:00:00	AAPL	Stock	145.32	145.46	144.8	145.0	3603050.0
2022-07-11 15:30:00	AAPL	Stock	145.01	145.125	144.4	144.905	6193247.0
2022-07-11 16:00:00	AAPL	Stock	144.9	145.05	144.74	145.04	7317675.0
2022-07-11 16:30:00	AAPL	Stock	145.05	145.15	145.0	145.0	26266.0
2022-07-11 17:00:00	AAPL	Stock	145.0	145.0	144.92	144.96	7200.0
2022-07-11 17:30:00	AAPL	Stock	144.9603	145.0	144.87	144.9866	8833.0
2022-07-11 18:00:00	AAPL	Stock	145.0	145.0	144.87	144.94	103122.0
2022-07-11 18:30:00	AAPL	Stock	144.98	144.98	144.71	144.77	24995.0
2022-07-11 19:00:00	AAPL	Stock	144.71	144.97	144.71	144.97	5839.0
2022-07-11 19:30:00	AAPL	Stock	144.9	145.11	144.89	145.11	14396.0
2022-07-11 04:00:00	MSFT	Stock	265.3	265.69	265.22	265.69	1922.0
2022-07-11 04:30:00	MSFT	Stock	265.67	265.68	265.45	265.5	2673.0
2022-07-11 05:00:00	MSFT	Stock	265.77	265.86	265.63	265.63	1880.0
2022-07-11 05:30:00	MSFT	Stock	265.88	265.88	265.61	265.61	494.0
2022-07-11 06:00:00	MSFT	Stock	265.9	266.0	265.76	265.76	2795.0
2022-07-11 06:30:00	MSFT	Stock	265.73	265.89	265.73	265.89	1097.0
2022-07-11 07:00:00	MSFT	Stock	265.97	266.35	265.74	265.74	5793.0
2022-07-11 07:30:00	MSFT	Stock	265.94	265.94	265.32	265.5	1315.0
2022-07-11 08:00:00	MSFT	Stock	266.3654	266.991	265.0312	266.0023	21637.0
2022-07-11 08:30:00	MSFT	Stock	265.74	265.9347	265.5	265.5355	14750.0
2022-07-11 09:00:00	MSFT	Stock	265.76	265.9578	264.93	265.23	19743.0
2022-07-11 09:30:00	MSFT	Stock	265.23	265.82	262.18	262.56	1479387.0
2022-07-11 10:00:00	MSFT	Stock	262.54	263.96	262.25	263.78	890328.0
2022-07-11 10:30:00	MSFT	Stock	263.81	265.13	263.68	264.0198	965031.0
2022-07-11 11:00:00	MSFT	Stock	264.0	265.01	263.89	264.8	617776.0
2022-07-11 11:30:00	MSFT	Stock	264.805	264.98	264.0	264.7178	685926.0
2022-07-11 12:00:00	MSFT	Stock	264.72	265.0139	264.39	264.89	496931.0
2022-07-11 12:30:00	MSFT	Stock	264.88	265.39	264.46	264.85	442716.0

> showing 50 of 101,335 rows — these rows as CSV

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