PREVIEW / stock_30min / 2023-06-23

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-06-23.parquet
  size:    2.1 MB
  rows:    100,839
  symbols: 1,600

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-23 04:00:00	AAPL	Stock	186.48	186.48	186.07	186.1	12938.0
2023-06-23 04:30:00	AAPL	Stock	186.2	186.21	185.8	185.95	9577.0
2023-06-23 05:00:00	AAPL	Stock	185.91	186.21	185.9	186.0	8048.0
2023-06-23 05:30:00	AAPL	Stock	186.15	186.21	186.0	186.05	5434.0
2023-06-23 06:00:00	AAPL	Stock	186.11	186.13	185.99	186.11	5201.0
2023-06-23 06:30:00	AAPL	Stock	186.0	186.04	185.94	186.0	2810.0
2023-06-23 07:00:00	AAPL	Stock	186.0	186.32	186.0	186.3	34935.0
2023-06-23 07:30:00	AAPL	Stock	186.25	186.25	186.03	186.18	16028.0
2023-06-23 08:00:00	AAPL	Stock	186.16	186.3666	185.8	185.95	98484.0
2023-06-23 08:30:00	AAPL	Stock	185.92	185.97	185.2	185.38	165594.0
2023-06-23 09:00:00	AAPL	Stock	185.38	185.73	185.28	185.61	141516.0
2023-06-23 09:30:00	AAPL	Stock	185.55	186.18	185.01	185.28	5585677.0
2023-06-23 10:00:00	AAPL	Stock	185.27	186.05	185.01	185.83	3297806.0
2023-06-23 10:30:00	AAPL	Stock	185.82	186.35	185.66	186.27	2565079.0
2023-06-23 11:00:00	AAPL	Stock	186.28	186.39	185.91	186.08	1987415.0
2023-06-23 11:30:00	AAPL	Stock	186.0862	186.69	185.94	186.5613	1916681.0
2023-06-23 12:00:00	AAPL	Stock	186.57	187.1	186.535	186.94	2267619.0
2023-06-23 12:30:00	AAPL	Stock	186.94	187.14	186.81	186.983	1530805.0
2023-06-23 13:00:00	AAPL	Stock	186.99	187.47	186.985	187.337	1637116.0
2023-06-23 13:30:00	AAPL	Stock	187.33	187.56	187.22	187.34	1542755.0
2023-06-23 14:00:00	AAPL	Stock	187.34	187.425	187.105	187.24	1501993.0
2023-06-23 14:30:00	AAPL	Stock	187.23	187.27	186.575	186.7	1971909.0
2023-06-23 15:00:00	AAPL	Stock	186.71	187.05	186.38	186.815	2423764.0
2023-06-23 15:30:00	AAPL	Stock	186.83	187.25	186.51	186.68	5244340.0
2023-06-23 16:00:00	AAPL	Stock	186.67	186.74	186.35	186.39	9802572.0
2023-06-23 16:30:00	AAPL	Stock	186.41	186.68	186.37	186.5	36802.0
2023-06-23 17:00:00	AAPL	Stock	186.48	186.68	186.43	186.51	47491.0
2023-06-23 17:30:00	AAPL	Stock	186.52	186.58	186.51	186.51	9542.0
2023-06-23 18:00:00	AAPL	Stock	186.53	186.55	186.48	186.49	6891.0
2023-06-23 18:30:00	AAPL	Stock	186.5	186.5001	186.47	186.48	6068.0
2023-06-23 19:00:00	AAPL	Stock	186.48	186.52	186.46	186.51	6112.0
2023-06-23 19:30:00	AAPL	Stock	186.46	186.5	186.45	186.5	9276.0
2023-06-23 04:00:00	MSFT	Stock	338.02	338.3	337.75	337.8	1292.0
2023-06-23 04:30:00	MSFT	Stock	337.78	337.78	337.32	337.32	1159.0
2023-06-23 05:00:00	MSFT	Stock	337.25	337.25	337.25	337.25	102.0
2023-06-23 05:30:00	MSFT	Stock	337.21	337.48	337.15	337.48	1764.0
2023-06-23 06:00:00	MSFT	Stock	337.25	337.25	337.17	337.17	931.0
2023-06-23 06:30:00	MSFT	Stock	337.17	337.17	337.0	337.0	947.0
2023-06-23 07:00:00	MSFT	Stock	337.34	337.99	337.17	337.65	6996.0
2023-06-23 07:30:00	MSFT	Stock	337.65	337.74	336.26	336.81	11696.0
2023-06-23 08:00:00	MSFT	Stock	337.33	339.0	336.0598	336.38	24137.0
2023-06-23 08:30:00	MSFT	Stock	336.5	336.5	334.12	335.0	32925.0
2023-06-23 09:00:00	MSFT	Stock	335.0	335.3018	334.37	334.37	33576.0
2023-06-23 09:30:00	MSFT	Stock	334.36	336.18	333.45	334.9	2129225.0
2023-06-23 10:00:00	MSFT	Stock	334.9	336.41	334.49	335.83	943231.0
2023-06-23 10:30:00	MSFT	Stock	335.84	337.06	335.45	336.09	1098747.0
2023-06-23 11:00:00	MSFT	Stock	336.125	336.313	335.18	335.3892	711884.0
2023-06-23 11:30:00	MSFT	Stock	335.4	336.2452	335.0232	335.85	495665.0
2023-06-23 12:00:00	MSFT	Stock	335.87	336.83	335.76	336.55	539895.0
2023-06-23 12:30:00	MSFT	Stock	336.61	337.31	336.26	337.19	511951.0

> showing 50 of 100,839 rows — these rows as CSV

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