PREVIEW / stock_30min / 2023-06-16

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-06-16.parquet
  size:    2.1 MB
  rows:    103,772
  symbols: 1,573

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-06-16 04:00:00	AAPL	Stock	185.99	185.99	185.66	185.83	7283.0
2023-06-16 04:30:00	AAPL	Stock	185.95	185.96	185.6	185.69	6349.0
2023-06-16 05:00:00	AAPL	Stock	185.76	185.8	185.35	185.37	16070.0
2023-06-16 05:30:00	AAPL	Stock	185.38	185.6	185.38	185.54	1681.0
2023-06-16 06:00:00	AAPL	Stock	185.6	185.6	185.3	185.39	5173.0
2023-06-16 06:30:00	AAPL	Stock	185.4	185.53	185.11	185.52	24783.0
2023-06-16 07:00:00	AAPL	Stock	185.53	185.96	185.47	185.8	32784.0
2023-06-16 07:30:00	AAPL	Stock	185.87	185.96	185.65	185.66	20754.0
2023-06-16 08:00:00	AAPL	Stock	185.68	186.16	185.43	186.16	568064.0
2023-06-16 08:30:00	AAPL	Stock	186.13	186.31	186.0242	186.3	111408.0
2023-06-16 09:00:00	AAPL	Stock	186.32	187.5	185.9	186.66	679600.0
2023-06-16 09:30:00	AAPL	Stock	186.61	186.99	184.96	185.22	20914859.0
2023-06-16 10:00:00	AAPL	Stock	185.23	185.92	185.13	185.9082	3085778.0
2023-06-16 10:30:00	AAPL	Stock	185.9001	185.96	185.37	185.7301	2586181.0
2023-06-16 11:00:00	AAPL	Stock	185.74	186.13	185.34	185.48	2331841.0
2023-06-16 11:30:00	AAPL	Stock	185.48	185.8	185.3	185.77	1964624.0
2023-06-16 12:00:00	AAPL	Stock	185.77	185.83	185.51	185.7301	1434146.0
2023-06-16 12:30:00	AAPL	Stock	185.74	185.98	185.5666	185.93	1484972.0
2023-06-16 13:00:00	AAPL	Stock	185.94	186.0299	185.6	185.8	1223520.0
2023-06-16 13:30:00	AAPL	Stock	185.81	185.9	185.46	185.58	1324857.0
2023-06-16 14:00:00	AAPL	Stock	185.57	185.62	185.2	185.31	1632250.0
2023-06-16 14:30:00	AAPL	Stock	185.3	185.3	184.8618	184.9	2195234.0
2023-06-16 15:00:00	AAPL	Stock	184.9	185.025	184.71	184.915	2491059.0
2023-06-16 15:30:00	AAPL	Stock	184.92	185.35	184.27	185.01	6613002.0
2023-06-16 16:00:00	AAPL	Stock	185.02	185.2	184.92	184.98	25996904.0
2023-06-16 16:30:00	AAPL	Stock	184.92	185.04	184.92	185.01	1946080.0
2023-06-16 17:00:00	AAPL	Stock	185.02	185.04	184.95	185.03	36814.0
2023-06-16 17:30:00	AAPL	Stock	184.95	185.03	184.92	184.93	12230.0
2023-06-16 18:00:00	AAPL	Stock	184.93	184.96	184.93	184.93	1434.0
2023-06-16 18:30:00	AAPL	Stock	184.96	184.98	184.92	184.92	2517.0
2023-06-16 19:00:00	AAPL	Stock	184.92	184.98	184.92	184.96	3634.0
2023-06-16 19:30:00	AAPL	Stock	185.0	185.0	184.94	184.94	3738.0
2023-06-16 04:00:00	MSFT	Stock	348.11	349.57	348.11	349.57	3317.0
2023-06-16 04:30:00	MSFT	Stock	349.48	349.8	349.48	349.62	1837.0
2023-06-16 05:00:00	MSFT	Stock	349.71	349.82	349.2	349.24	4761.0
2023-06-16 05:30:00	MSFT	Stock	349.23	349.73	349.13	349.41	2322.0
2023-06-16 06:00:00	MSFT	Stock	349.42	349.42	348.32	348.32	3643.0
2023-06-16 06:30:00	MSFT	Stock	348.35	349.85	348.26	349.28	12029.0
2023-06-16 07:00:00	MSFT	Stock	349.49	350.5	349.49	350.49	21156.0
2023-06-16 07:30:00	MSFT	Stock	350.49	350.6	349.76	349.8	24489.0
2023-06-16 08:00:00	MSFT	Stock	349.48	351.02	347.86	350.7365	320017.0
2023-06-16 08:30:00	MSFT	Stock	350.6	350.85	349.86	350.29	45039.0
2023-06-16 09:00:00	MSFT	Stock	350.29	352.25	349.4	351.47	212570.0
2023-06-16 09:30:00	MSFT	Stock	351.07	351.47	345.0	345.84	11485874.0
2023-06-16 10:00:00	MSFT	Stock	345.87	347.77	345.1884	347.71	1893144.0
2023-06-16 10:30:00	MSFT	Stock	347.67	347.99	346.06	346.62	1289316.0
2023-06-16 11:00:00	MSFT	Stock	346.66	347.93	345.15	345.606	1210609.0
2023-06-16 11:30:00	MSFT	Stock	345.5942	347.07	345.4201	346.98	812606.0
2023-06-16 12:00:00	MSFT	Stock	347.0	347.2	346.4158	346.57	546427.0
2023-06-16 12:30:00	MSFT	Stock	346.6	347.0	346.12	346.695	556768.0

> showing 50 of 103,772 rows — these rows as CSV

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