PREVIEW / stock_30min / 2023-01-03

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-01-03.parquet
  size:    2.1 MB
  rows:    103,477
  symbols: 1,950

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-03 04:00:00	AAPL	Stock	130.28	131.46	130.28	130.9	70645.0
2023-01-03 04:30:00	AAPL	Stock	130.92	131.3	130.9	131.3	27226.0
2023-01-03 05:00:00	AAPL	Stock	131.4	131.4	130.8	130.8	22577.0
2023-01-03 05:30:00	AAPL	Stock	130.8	131.05	130.8	131.0	6006.0
2023-01-03 06:00:00	AAPL	Stock	130.91	130.95	130.71	130.79	9048.0
2023-01-03 06:30:00	AAPL	Stock	130.9	131.25	130.05	130.38	47480.0
2023-01-03 07:00:00	AAPL	Stock	130.38	130.74	130.03	130.46	69116.0
2023-01-03 07:30:00	AAPL	Stock	130.5	130.75	130.37	130.5	40155.0
2023-01-03 08:00:00	AAPL	Stock	130.25	131.2285	129.63	130.5	234644.0
2023-01-03 08:30:00	AAPL	Stock	130.47	131.1	130.41	130.92	145541.0
2023-01-03 09:00:00	AAPL	Stock	130.95	131.36	130.25	130.29	483536.0
2023-01-03 09:30:00	AAPL	Stock	130.25	130.9	126.88	126.9336	13123732.0
2023-01-03 10:00:00	AAPL	Stock	126.94	127.3	125.23	125.46	9359045.0
2023-01-03 10:30:00	AAPL	Stock	125.46	125.78	125.05	125.595	8151890.0
2023-01-03 11:00:00	AAPL	Stock	125.595	125.87	124.73	125.345	7631983.0
2023-01-03 11:30:00	AAPL	Stock	125.3502	125.37	124.49	124.7425	5591073.0
2023-01-03 12:00:00	AAPL	Stock	124.75	125.055	124.3491	124.66	4288054.0
2023-01-03 12:30:00	AAPL	Stock	124.66	124.94	124.35	124.59	3628739.0
2023-01-03 13:00:00	AAPL	Stock	124.5999	124.76	124.19	124.6499	3593715.0
2023-01-03 13:30:00	AAPL	Stock	124.6699	124.84	124.19	124.815	3660845.0
2023-01-03 14:00:00	AAPL	Stock	124.82	125.0	124.42	124.57	3198290.0
2023-01-03 14:30:00	AAPL	Stock	124.578	125.33	124.17	124.6283	5349340.0
2023-01-03 15:00:00	AAPL	Stock	124.63	125.03	124.4	124.62	4811437.0
2023-01-03 15:30:00	AAPL	Stock	124.63	125.42	124.625	125.05	9427839.0
2023-01-03 16:00:00	AAPL	Stock	125.04	125.18	124.85	124.98	14751597.0
2023-01-03 16:30:00	AAPL	Stock	124.98	125.12	124.93	125.0207	212318.0
2023-01-03 17:00:00	AAPL	Stock	125.02	125.04	124.84	124.89	53342.0
2023-01-03 17:30:00	AAPL	Stock	124.89	124.96	124.85	124.92	16546.0
2023-01-03 18:00:00	AAPL	Stock	124.9	124.9699	124.81	124.92	21162.0
2023-01-03 18:30:00	AAPL	Stock	124.9395	124.98	124.9	124.96	9912.0
2023-01-03 19:00:00	AAPL	Stock	124.97	125.1	124.95	125.1	27003.0
2023-01-03 19:30:00	AAPL	Stock	125.09	125.12	124.92	125.0	61422.0
2023-01-03 04:00:00	MSFT	Stock	240.99	243.29	240.99	243.08	10971.0
2023-01-03 04:30:00	MSFT	Stock	243.03	243.63	243.02	243.54	1339.0
2023-01-03 05:00:00	MSFT	Stock	243.55	243.55	242.65	242.65	767.0
2023-01-03 05:30:00	MSFT	Stock	242.64	242.95	242.64	242.95	817.0
2023-01-03 06:00:00	MSFT	Stock	242.87	242.87	242.49	242.5	1086.0
2023-01-03 06:30:00	MSFT	Stock	242.53	242.53	239.97	240.92	3389.0
2023-01-03 07:00:00	MSFT	Stock	240.88	241.25	240.87	241.17	4802.0
2023-01-03 07:30:00	MSFT	Stock	241.15	241.65	241.09	241.25	5276.0
2023-01-03 08:00:00	MSFT	Stock	240.9739	242.47	240.55	241.87	20469.0
2023-01-03 08:30:00	MSFT	Stock	241.89	242.49	241.55	242.29	12767.0
2023-01-03 09:00:00	MSFT	Stock	242.16	243.98	242.15	243.35	25444.0
2023-01-03 09:30:00	MSFT	Stock	243.14	245.75	241.25	241.25	3042676.0
2023-01-03 10:00:00	MSFT	Stock	241.27	241.82	239.3401	239.7881	1442429.0
2023-01-03 10:30:00	MSFT	Stock	239.8	239.8	238.3	239.63	1237673.0
2023-01-03 11:00:00	MSFT	Stock	239.665	239.83	237.5	238.36	1081041.0
2023-01-03 11:30:00	MSFT	Stock	238.37	238.57	237.5	238.2	773450.0
2023-01-03 12:00:00	MSFT	Stock	238.2	238.69	237.61	238.1501	741983.0
2023-01-03 12:30:00	MSFT	Stock	238.18	238.99	237.63	238.17	767004.0

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

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