PREVIEW / stock_30min / 2023-07-21

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-07-21.parquet
  size:    2.0 MB
  rows:    99,290
  symbols: 1,549

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
2023-07-21 04:00:00	AAPL	Stock	193.13	193.36	193.04	193.26	6885.0
2023-07-21 04:30:00	AAPL	Stock	193.16	193.23	193.12	193.18	5205.0
2023-07-21 05:00:00	AAPL	Stock	193.01	193.08	193.01	193.07	832.0
2023-07-21 05:30:00	AAPL	Stock	193.01	193.03	192.78	192.96	2448.0
2023-07-21 06:00:00	AAPL	Stock	192.94	193.3	192.94	193.21	2652.0
2023-07-21 06:30:00	AAPL	Stock	193.32	193.4	193.2	193.38	2826.0
2023-07-21 07:00:00	AAPL	Stock	193.35	193.7	193.3	193.47	19201.0
2023-07-21 07:30:00	AAPL	Stock	193.48	193.49	193.31	193.33	12388.0
2023-07-21 08:00:00	AAPL	Stock	193.335	193.89	193.0	193.8892	92145.0
2023-07-21 08:30:00	AAPL	Stock	193.84	193.9	193.68	193.82	42258.0
2023-07-21 09:00:00	AAPL	Stock	193.82	194.3	193.72	194.14	231013.0
2023-07-21 09:30:00	AAPL	Stock	194.1	194.97	193.725	193.79	7196145.0
2023-07-21 10:00:00	AAPL	Stock	193.795	193.97	192.83	192.87	3414389.0
2023-07-21 10:30:00	AAPL	Stock	192.8613	193.44	192.81	193.15	2475446.0
2023-07-21 11:00:00	AAPL	Stock	193.16	193.81	193.13	193.595	1620477.0
2023-07-21 11:30:00	AAPL	Stock	193.595	193.77	192.7	193.105	2020118.0
2023-07-21 12:00:00	AAPL	Stock	193.105	193.15	192.58	192.6082	2061884.0
2023-07-21 12:30:00	AAPL	Stock	192.6247	192.68	191.96	192.173	2050410.0
2023-07-21 13:00:00	AAPL	Stock	192.17	192.72	192.1	192.7	1216385.0
2023-07-21 13:30:00	AAPL	Stock	192.7	193.22	192.58	193.11	1758826.0
2023-07-21 14:00:00	AAPL	Stock	193.11	193.1849	192.39	192.725	1641177.0
2023-07-21 14:30:00	AAPL	Stock	192.73	193.04	192.48	192.59	1115845.0
2023-07-21 15:00:00	AAPL	Stock	192.59	192.69	192.13	192.41	1649735.0
2023-07-21 15:30:00	AAPL	Stock	192.405	192.46	191.23	191.93	6733362.0
2023-07-21 16:00:00	AAPL	Stock	191.93	192.26	191.91	192.14	15452179.0
2023-07-21 16:30:00	AAPL	Stock	192.14	192.32	191.94	192.3	92499.0
2023-07-21 17:00:00	AAPL	Stock	192.29	192.2972	191.94	192.09	147067.0
2023-07-21 17:30:00	AAPL	Stock	192.0	192.0	191.92	191.92	4719.0
2023-07-21 18:00:00	AAPL	Stock	191.98	192.03	191.93	191.95	3523.0
2023-07-21 18:30:00	AAPL	Stock	191.94	192.07	191.93	192.0	14488.0
2023-07-21 19:00:00	AAPL	Stock	192.05	192.07	191.98	192.07	2858.0
2023-07-21 19:30:00	AAPL	Stock	192.01	192.06	191.98	192.05	5056.0
2023-07-21 04:00:00	MSFT	Stock	347.73	348.86	347.73	348.55	6053.0
2023-07-21 04:30:00	MSFT	Stock	348.53	348.83	348.5	348.75	1139.0
2023-07-21 05:00:00	MSFT	Stock	348.69	348.69	348.69	348.69	100.0
2023-07-21 05:30:00	MSFT	Stock	348.7	348.7	348.06	348.1	17713.0
2023-07-21 06:00:00	MSFT	Stock	348.17	348.51	348.1	348.51	613.0
2023-07-21 06:30:00	MSFT	Stock	348.46	349.7	348.46	349.42	4017.0
2023-07-21 07:00:00	MSFT	Stock	349.06	349.94	349.06	349.3	10574.0
2023-07-21 07:30:00	MSFT	Stock	349.03	349.03	348.5	348.51	10549.0
2023-07-21 08:00:00	MSFT	Stock	349.03	349.85	347.04	349.6999	85363.0
2023-07-21 08:30:00	MSFT	Stock	349.6991	349.7	348.95	349.02	27002.0
2023-07-21 09:00:00	MSFT	Stock	349.11	350.56	348.65	349.19	79637.0
2023-07-21 09:30:00	MSFT	Stock	349.28	350.3	346.88	347.665	3458992.0
2023-07-21 10:00:00	MSFT	Stock	347.661	348.54	345.5	346.1654	1613908.0
2023-07-21 10:30:00	MSFT	Stock	346.11	348.48	346.09	347.06	1263494.0
2023-07-21 11:00:00	MSFT	Stock	347.06	348.35	346.5201	347.17	927392.0
2023-07-21 11:30:00	MSFT	Stock	347.18	347.47	345.735	346.38	874603.0
2023-07-21 12:00:00	MSFT	Stock	346.37	346.61	344.96	345.015	888513.0
2023-07-21 12:30:00	MSFT	Stock	345.04	346.09	344.98	345.77	902109.0

> showing 50 of 99,290 rows — these rows as CSV

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