PREVIEW / stock_30min / 2023-12-20

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-12-20.parquet
  size:    2.1 MB
  rows:    103,610
  symbols: 1,236

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-12-20 04:00:00	AAPL	Stock	196.0	196.2	195.71	196.04	8471.0
2023-12-20 04:30:00	AAPL	Stock	195.96	195.96	195.68	195.95	4277.0
2023-12-20 05:00:00	AAPL	Stock	195.97	195.97	195.83	195.85	6019.0
2023-12-20 05:30:00	AAPL	Stock	195.81	195.99	195.81	195.99	2915.0
2023-12-20 06:00:00	AAPL	Stock	195.99	196.07	195.99	196.06	3782.0
2023-12-20 06:30:00	AAPL	Stock	196.12	196.12	195.86	196.0	5890.0
2023-12-20 07:00:00	AAPL	Stock	196.0	196.25	195.95	196.1	12618.0
2023-12-20 07:30:00	AAPL	Stock	196.15	196.18	195.89	196.04	16085.0
2023-12-20 08:00:00	AAPL	Stock	196.04	196.9	195.9799	196.15	43971.0
2023-12-20 08:30:00	AAPL	Stock	196.14	196.34	196.05	196.14	21404.0
2023-12-20 09:00:00	AAPL	Stock	196.14	196.94	195.95	196.91	107946.0
2023-12-20 09:30:00	AAPL	Stock	196.86	197.68	196.69	197.52	5187787.0
2023-12-20 10:00:00	AAPL	Stock	197.51	197.665	197.23	197.385	2291268.0
2023-12-20 10:30:00	AAPL	Stock	197.385	197.595	197.26	197.385	1643525.0
2023-12-20 11:00:00	AAPL	Stock	197.385	197.44	197.14	197.23	1729955.0
2023-12-20 11:30:00	AAPL	Stock	197.23	197.35	197.01	197.3037	1389068.0
2023-12-20 12:00:00	AAPL	Stock	197.31	197.44	197.2	197.3583	1242169.0
2023-12-20 12:30:00	AAPL	Stock	197.35	197.44	197.2231	197.41	1018526.0
2023-12-20 13:00:00	AAPL	Stock	197.41	197.4526	197.32	197.4	1119075.0
2023-12-20 13:30:00	AAPL	Stock	197.41	197.57	197.1668	197.235	1329686.0
2023-12-20 14:00:00	AAPL	Stock	197.23	197.34	197.115	197.185	1151623.0
2023-12-20 14:30:00	AAPL	Stock	197.19	197.235	195.68	195.72	3128167.0
2023-12-20 15:00:00	AAPL	Stock	195.72	196.18	195.16	195.2	4116256.0
2023-12-20 15:30:00	AAPL	Stock	195.21	195.75	194.84	194.84	6120194.0
2023-12-20 16:00:00	AAPL	Stock	194.85	195.06	194.76	194.99	9381845.0
2023-12-20 16:30:00	AAPL	Stock	194.99	195.373	194.83	195.3001	64281.0
2023-12-20 17:00:00	AAPL	Stock	195.33	195.52	195.31	195.41	33163.0
2023-12-20 17:30:00	AAPL	Stock	195.4	195.45	195.33	195.33	16442.0
2023-12-20 18:00:00	AAPL	Stock	195.36	195.44	194.83	195.37	45253.0
2023-12-20 18:30:00	AAPL	Stock	195.3302	195.4	195.33	195.3301	10060.0
2023-12-20 19:00:00	AAPL	Stock	195.38	195.42	195.37	195.4	7114.0
2023-12-20 19:30:00	AAPL	Stock	195.4	195.5	195.38	195.4	13548.0
2023-12-20 04:00:00	MSFT	Stock	373.01	373.01	371.54	371.8	2050.0
2023-12-20 04:30:00	MSFT	Stock	371.7	371.7	371.66	371.66	742.0
2023-12-20 05:00:00	MSFT	Stock	371.99	372.16	371.9	371.92	1675.0
2023-12-20 05:30:00	MSFT	Stock	372.08	372.11	371.99	372.0	786.0
2023-12-20 06:00:00	MSFT	Stock	372.0	372.02	371.9	371.9	1613.0
2023-12-20 06:30:00	MSFT	Stock	372.19	373.2	372.19	372.39	5903.0
2023-12-20 07:00:00	MSFT	Stock	372.38	372.65	372.3	372.3	11598.0
2023-12-20 07:30:00	MSFT	Stock	372.41	372.41	371.9	371.9	3510.0
2023-12-20 08:00:00	MSFT	Stock	372.49	373.3	372.0	372.8	31944.0
2023-12-20 08:30:00	MSFT	Stock	372.7476	373.35	372.7	373.29	22309.0
2023-12-20 09:00:00	MSFT	Stock	373.3	375.3	373.3	375.0	81737.0
2023-12-20 09:30:00	MSFT	Stock	375.0	375.25	371.81	374.3701	3124961.0
2023-12-20 10:00:00	MSFT	Stock	374.3	375.15	373.85	375.08	1422276.0
2023-12-20 10:30:00	MSFT	Stock	375.1101	375.3	374.31	374.83	979246.0
2023-12-20 11:00:00	MSFT	Stock	374.81	375.04	374.03	374.57	706784.0
2023-12-20 11:30:00	MSFT	Stock	374.585	375.0	374.07	374.71	617799.0
2023-12-20 12:00:00	MSFT	Stock	374.71	375.74	374.71	375.63	787960.0
2023-12-20 12:30:00	MSFT	Stock	375.635	376.03	375.08	375.8175	770868.0

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

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