PREVIEW / stock_30min / 2022-09-30

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-09-30.parquet
  size:    2.1 MB
  rows:    103,797
  symbols: 2,223

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-09-30 04:00:00	AAPL	Stock	143.59	143.59	143.0	143.3	30999.0
2022-09-30 04:30:00	AAPL	Stock	143.3	143.58	143.02	143.54	39318.0
2022-09-30 05:00:00	AAPL	Stock	143.41	143.41	143.0	143.38	44765.0
2022-09-30 05:30:00	AAPL	Stock	143.25	143.3	142.89	142.89	15465.0
2022-09-30 06:00:00	AAPL	Stock	143.03	143.51	143.0	143.4	30545.0
2022-09-30 06:30:00	AAPL	Stock	143.27	143.32	142.76	142.79	34340.0
2022-09-30 07:00:00	AAPL	Stock	142.85	142.94	142.2	142.44	88352.0
2022-09-30 07:30:00	AAPL	Stock	142.44	142.5	141.79	141.96	90224.0
2022-09-30 08:00:00	AAPL	Stock	142.9238	143.3988	141.8	142.49	207143.0
2022-09-30 08:30:00	AAPL	Stock	142.5	142.5	140.96	141.83	354730.0
2022-09-30 09:00:00	AAPL	Stock	141.77	141.98	140.88	141.2	328932.0
2022-09-30 09:30:00	AAPL	Stock	141.21	142.63	140.61	142.12	12842812.0
2022-09-30 10:00:00	AAPL	Stock	142.12	142.53	141.37	142.22	6538532.0
2022-09-30 10:30:00	AAPL	Stock	142.22	142.89	141.855	142.2701	6068462.0
2022-09-30 11:00:00	AAPL	Stock	142.29	143.1	141.95	142.6188	5937027.0
2022-09-30 11:30:00	AAPL	Stock	142.6203	142.75	141.025	141.32	5273973.0
2022-09-30 12:00:00	AAPL	Stock	141.33	141.52	140.85	141.29	3982074.0
2022-09-30 12:30:00	AAPL	Stock	141.29	141.76	141.17	141.19	3151507.0
2022-09-30 13:00:00	AAPL	Stock	141.18	141.2993	140.69	141.06	3653559.0
2022-09-30 13:30:00	AAPL	Stock	141.065	141.1599	140.1769	140.3641	4062463.0
2022-09-30 14:00:00	AAPL	Stock	140.36	140.67	140.16	140.4404	4095939.0
2022-09-30 14:30:00	AAPL	Stock	140.4499	140.85	139.61	139.71	6666732.0
2022-09-30 15:00:00	AAPL	Stock	139.71	140.35	139.48	140.07	6791988.0
2022-09-30 15:30:00	AAPL	Stock	140.07	140.29	138.0	138.08	18935188.0
2022-09-30 16:00:00	AAPL	Stock	138.0	138.5	137.97	138.22	18864574.0
2022-09-30 16:30:00	AAPL	Stock	138.22	138.27	137.85	138.04	333356.0
2022-09-30 17:00:00	AAPL	Stock	138.03	138.24	137.61	137.74	138519.0
2022-09-30 17:30:00	AAPL	Stock	137.73	137.74	137.21	137.51	191390.0
2022-09-30 18:00:00	AAPL	Stock	137.53	137.69	137.52	137.69	40978.0
2022-09-30 18:30:00	AAPL	Stock	137.7	137.77	137.58	137.59	35228.0
2022-09-30 19:00:00	AAPL	Stock	137.6	137.69	137.5	137.63	41606.0
2022-09-30 19:30:00	AAPL	Stock	137.62	137.65	137.5	137.52	51769.0
2022-09-30 04:00:00	MSFT	Stock	240.93	241.0	239.92	240.45	3415.0
2022-09-30 04:30:00	MSFT	Stock	239.72	240.59	239.55	240.35	3220.0
2022-09-30 05:00:00	MSFT	Stock	240.05	240.05	239.03	239.03	2231.0
2022-09-30 05:30:00	MSFT	Stock	239.4	239.4	239.0	239.13	901.0
2022-09-30 06:00:00	MSFT	Stock	239.5	240.3	239.5	239.99	2030.0
2022-09-30 06:30:00	MSFT	Stock	239.75	239.75	239.0	239.0	1500.0
2022-09-30 07:00:00	MSFT	Stock	239.08	239.26	238.0	239.15	14966.0
2022-09-30 07:30:00	MSFT	Stock	239.1	239.1	238.3	239.0	11576.0
2022-09-30 08:00:00	MSFT	Stock	239.0	240.6	236.907	240.6	26061.0
2022-09-30 08:30:00	MSFT	Stock	239.51	240.59	236.4	238.99	55501.0
2022-09-30 09:00:00	MSFT	Stock	239.28	239.6	237.78	238.29	52149.0
2022-09-30 09:30:00	MSFT	Stock	238.3	240.52	237.35	238.8	2747416.0
2022-09-30 10:00:00	MSFT	Stock	238.77	239.47	237.3	238.62	1526899.0
2022-09-30 10:30:00	MSFT	Stock	238.595	239.46	238.34	238.99	1210067.0
2022-09-30 11:00:00	MSFT	Stock	238.99	240.54	238.67	239.97	1143868.0
2022-09-30 11:30:00	MSFT	Stock	239.98	240.27	237.61	237.6132	942760.0
2022-09-30 12:00:00	MSFT	Stock	237.63	237.63	236.44	237.08	1038049.0
2022-09-30 12:30:00	MSFT	Stock	237.095	237.65	236.781	236.96	599464.0

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

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