PREVIEW / stock_30min / 2023-01-23

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-01-23.parquet
  size:    2.2 MB
  rows:    105,298
  symbols: 1,961

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-01-23 04:00:00	AAPL	Stock	138.5	138.5	137.56	137.56	14401.0
2023-01-23 04:30:00	AAPL	Stock	137.65	137.76	137.57	137.73	10526.0
2023-01-23 05:00:00	AAPL	Stock	137.74	137.83	137.3	137.32	15161.0
2023-01-23 05:30:00	AAPL	Stock	137.32	137.43	137.22	137.41	10872.0
2023-01-23 06:00:00	AAPL	Stock	137.39	137.6	137.3	137.45	6802.0
2023-01-23 06:30:00	AAPL	Stock	137.55	137.59	137.41	137.42	6661.0
2023-01-23 07:00:00	AAPL	Stock	137.54	137.8	137.41	137.67	33755.0
2023-01-23 07:30:00	AAPL	Stock	137.69	138.13	137.59	137.87	40988.0
2023-01-23 08:00:00	AAPL	Stock	137.5135	138.44	137.4285	138.27	135010.0
2023-01-23 08:30:00	AAPL	Stock	138.25	138.29	138.01	138.03	109097.0
2023-01-23 09:00:00	AAPL	Stock	138.06	138.17	137.8	138.12	134098.0
2023-01-23 09:30:00	AAPL	Stock	138.13	140.0	137.9	139.87	8322058.0
2023-01-23 10:00:00	AAPL	Stock	139.88	140.64	139.57	140.4675	5738747.0
2023-01-23 10:30:00	AAPL	Stock	140.465	141.48	140.465	141.2152	5247539.0
2023-01-23 11:00:00	AAPL	Stock	141.21	142.8	141.12	142.34	6988616.0
2023-01-23 11:30:00	AAPL	Stock	142.34	143.315	142.251	142.9	5680753.0
2023-01-23 12:00:00	AAPL	Stock	142.9	142.9	142.16	142.4525	3686456.0
2023-01-23 12:30:00	AAPL	Stock	142.46	142.52	141.94	142.16	3419765.0
2023-01-23 13:00:00	AAPL	Stock	142.15	142.49	142.0	142.27	3329357.0
2023-01-23 13:30:00	AAPL	Stock	142.27	142.33	141.88	141.95	2946166.0
2023-01-23 14:00:00	AAPL	Stock	141.96	141.98	141.51	141.76	3202757.0
2023-01-23 14:30:00	AAPL	Stock	141.78	141.95	140.614	140.98	4013435.0
2023-01-23 15:00:00	AAPL	Stock	140.98	141.03	140.36	140.585	3808796.0
2023-01-23 15:30:00	AAPL	Stock	140.59	141.26	140.4	141.1	6529674.0
2023-01-23 16:00:00	AAPL	Stock	141.09	141.15	140.9	141.0104	6824867.0
2023-01-23 16:30:00	AAPL	Stock	141.04	141.1782	141.03	141.13	75955.0
2023-01-23 17:00:00	AAPL	Stock	141.1008	141.14	141.07	141.1	30851.0
2023-01-23 17:30:00	AAPL	Stock	141.1	141.13	141.08	141.1	8488.0
2023-01-23 18:00:00	AAPL	Stock	141.11	141.13	141.07	141.07	7989.0
2023-01-23 18:30:00	AAPL	Stock	141.0899	141.09	140.97	141.05	18626.0
2023-01-23 19:00:00	AAPL	Stock	141.03	141.13	141.0	141.1	10336.0
2023-01-23 19:30:00	AAPL	Stock	141.1	141.13	141.06	141.11	11902.0
2023-01-23 04:00:00	MSFT	Stock	240.5	240.69	240.38	240.46	4142.0
2023-01-23 04:30:00	MSFT	Stock	240.48	240.69	240.3	240.3	2947.0
2023-01-23 05:00:00	MSFT	Stock	240.4	240.4	239.75	240.11	2934.0
2023-01-23 05:30:00	MSFT	Stock	240.13	240.6	240.07	240.41	1602.0
2023-01-23 06:00:00	MSFT	Stock	240.55	240.55	239.86	240.05	3465.0
2023-01-23 06:30:00	MSFT	Stock	239.87	239.87	239.75	239.75	1247.0
2023-01-23 07:00:00	MSFT	Stock	240.03	240.12	239.88	240.01	13350.0
2023-01-23 07:30:00	MSFT	Stock	240.2	240.61	240.03	240.38	14088.0
2023-01-23 08:00:00	MSFT	Stock	240.0	241.42	239.62	241.16	81655.0
2023-01-23 08:30:00	MSFT	Stock	241.15	241.15	240.68	240.9704	42984.0
2023-01-23 09:00:00	MSFT	Stock	241.06	242.56	240.65	241.05	107343.0
2023-01-23 09:30:00	MSFT	Stock	241.1	242.3399	239.65	241.55	3376796.0
2023-01-23 10:00:00	MSFT	Stock	241.6	242.51	240.58	242.2567	1694940.0
2023-01-23 10:30:00	MSFT	Stock	242.28	243.37	242.2	242.62	1369098.0
2023-01-23 11:00:00	MSFT	Stock	242.63	244.89	242.63	243.99	1331333.0
2023-01-23 11:30:00	MSFT	Stock	244.0	245.165	243.8899	244.59	1240560.0
2023-01-23 12:00:00	MSFT	Stock	244.59	244.59	243.75	244.3	1150783.0
2023-01-23 12:30:00	MSFT	Stock	244.31	244.52	243.62	244.205	1087957.0

> showing 50 of 105,298 rows — these rows as CSV

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