PREVIEW / stock_30min / 2023-06-12

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-06-12.parquet
  size:    2.1 MB
  rows:    102,405
  symbols: 1,656

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-12 04:00:00	AAPL	Stock	180.04	181.72	180.04	181.62	17397.0
2023-06-12 04:30:00	AAPL	Stock	181.63	181.72	181.6	181.66	4759.0
2023-06-12 05:00:00	AAPL	Stock	181.68	181.74	181.68	181.74	4228.0
2023-06-12 05:30:00	AAPL	Stock	181.75	181.75	181.51	181.51	4474.0
2023-06-12 06:00:00	AAPL	Stock	181.6	181.61	181.32	181.32	4204.0
2023-06-12 06:30:00	AAPL	Stock	181.55	181.61	181.34	181.6	3692.0
2023-06-12 07:00:00	AAPL	Stock	181.55	181.85	181.54	181.85	23076.0
2023-06-12 07:30:00	AAPL	Stock	181.82	181.82	181.69	181.71	29857.0
2023-06-12 08:00:00	AAPL	Stock	181.57	181.85	181.4	181.6499	90312.0
2023-06-12 08:30:00	AAPL	Stock	181.61	181.99	181.6	181.94	39578.0
2023-06-12 09:00:00	AAPL	Stock	181.94	181.96	181.16	181.29	112408.0
2023-06-12 09:30:00	AAPL	Stock	181.27	182.04	181.24	181.44	4389141.0
2023-06-12 10:00:00	AAPL	Stock	181.44	181.67	180.97	181.6	2771787.0
2023-06-12 10:30:00	AAPL	Stock	181.6	181.97	181.4301	181.765	2070565.0
2023-06-12 11:00:00	AAPL	Stock	181.7601	182.11	181.72	182.015	2158292.0
2023-06-12 11:30:00	AAPL	Stock	182.02	182.53	182.02	182.3266	2444145.0
2023-06-12 12:00:00	AAPL	Stock	182.34	182.38	182.12	182.275	1412495.0
2023-06-12 12:30:00	AAPL	Stock	182.285	182.5	182.273	182.3978	1202760.0
2023-06-12 13:00:00	AAPL	Stock	182.395	182.66	182.36	182.54	1385871.0
2023-06-12 13:30:00	AAPL	Stock	182.5399	182.78	182.42	182.74	1413777.0
2023-06-12 14:00:00	AAPL	Stock	182.75	182.81	182.621	182.71	1234976.0
2023-06-12 14:30:00	AAPL	Stock	182.715	183.12	182.7	183.11	1843546.0
2023-06-12 15:00:00	AAPL	Stock	183.11	183.48	183.01	183.309	2344110.0
2023-06-12 15:30:00	AAPL	Stock	183.3	183.89	183.19	183.84	6020202.0
2023-06-12 16:00:00	AAPL	Stock	183.79	183.98	183.74	183.95	9985502.0
2023-06-12 16:30:00	AAPL	Stock	183.97	183.99	183.79	183.97	111306.0
2023-06-12 17:00:00	AAPL	Stock	183.96	183.99	183.79	183.97	51614.0
2023-06-12 17:30:00	AAPL	Stock	183.9074	184.06	183.9	184.06	33213.0
2023-06-12 18:00:00	AAPL	Stock	184.01	184.04	183.98	184.0	10909.0
2023-06-12 18:30:00	AAPL	Stock	184.05	184.28	184.0	184.28	21330.0
2023-06-12 19:00:00	AAPL	Stock	184.29	184.35	183.79	183.79	71938.0
2023-06-12 19:30:00	AAPL	Stock	183.88	183.99	181.5	182.5099	300613.0
2023-06-12 04:00:00	MSFT	Stock	328.55	328.6	327.84	328.46	4267.0
2023-06-12 04:30:00	MSFT	Stock	328.59	328.93	328.59	328.8	1483.0
2023-06-12 05:00:00	MSFT	Stock	328.99	329.37	328.99	329.37	950.0
2023-06-12 05:30:00	MSFT	Stock	329.13	329.13	329.0	329.0	1408.0
2023-06-12 06:00:00	MSFT	Stock	328.81	328.81	328.61	328.61	3245.0
2023-06-12 06:30:00	MSFT	Stock	328.67	328.67	328.61	328.61	1027.0
2023-06-12 07:00:00	MSFT	Stock	328.66	329.0	328.61	328.65	5595.0
2023-06-12 07:30:00	MSFT	Stock	328.75	328.99	328.61	328.82	5160.0
2023-06-12 08:00:00	MSFT	Stock	328.61	329.0	327.31	328.99	29321.0
2023-06-12 08:30:00	MSFT	Stock	328.99	329.0	328.75	329.0	4994.0
2023-06-12 09:00:00	MSFT	Stock	328.9699	329.13	328.24	328.57	25812.0
2023-06-12 09:30:00	MSFT	Stock	328.6	329.04	326.565	326.71	1881061.0
2023-06-12 10:00:00	MSFT	Stock	326.735	326.91	325.16	326.26	1320107.0
2023-06-12 10:30:00	MSFT	Stock	326.28	327.43	325.86	326.007	917911.0
2023-06-12 11:00:00	MSFT	Stock	325.98	326.48	325.56	326.43	681032.0
2023-06-12 11:30:00	MSFT	Stock	326.43	328.15	326.43	328.06	959550.0
2023-06-12 12:00:00	MSFT	Stock	328.05	328.06	327.21	327.68	540619.0
2023-06-12 12:30:00	MSFT	Stock	327.7	327.87	327.44	327.65	431521.0

> showing 50 of 102,405 rows — these rows as CSV

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