PREVIEW / stock_30min / 2023-11-07

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-11-07.parquet
  size:    2.0 MB
  rows:    97,382
  symbols: 1,341

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-11-07 04:00:00	AAPL	Stock	178.88	178.88	178.6	178.6	3831.0
2023-11-07 04:30:00	AAPL	Stock	178.52	178.52	178.47	178.5	1427.0
2023-11-07 05:00:00	AAPL	Stock	178.4	178.68	178.4	178.68	2267.0
2023-11-07 05:30:00	AAPL	Stock	178.55	178.55	178.45	178.49	1391.0
2023-11-07 06:00:00	AAPL	Stock	178.5	178.5	178.38	178.38	2693.0
2023-11-07 06:30:00	AAPL	Stock	178.35	178.41	178.22	178.41	26337.0
2023-11-07 07:00:00	AAPL	Stock	178.5	178.66	178.33	178.59	16819.0
2023-11-07 07:30:00	AAPL	Stock	178.6	178.69	178.47	178.66	6135.0
2023-11-07 08:00:00	AAPL	Stock	178.48	178.94	178.36	178.72	62392.0
2023-11-07 08:30:00	AAPL	Stock	178.76	178.97	178.74	178.85	34867.0
2023-11-07 09:00:00	AAPL	Stock	178.85	179.23	178.65	179.23	134806.0
2023-11-07 09:30:00	AAPL	Stock	179.18	180.53	178.97	180.195	7377832.0
2023-11-07 10:00:00	AAPL	Stock	180.19	180.82	180.14	180.71	3987582.0
2023-11-07 10:30:00	AAPL	Stock	180.695	181.27	180.53	181.215	3990413.0
2023-11-07 11:00:00	AAPL	Stock	181.215	181.595	181.08	181.455	2929008.0
2023-11-07 11:30:00	AAPL	Stock	181.455	181.64	181.18	181.47	2368778.0
2023-11-07 12:00:00	AAPL	Stock	181.48	181.49	180.52	181.175	4110771.0
2023-11-07 12:30:00	AAPL	Stock	181.175	181.59	180.935	181.575	2050177.0
2023-11-07 13:00:00	AAPL	Stock	181.58	182.16	181.525	182.015	3361653.0
2023-11-07 13:30:00	AAPL	Stock	182.0185	182.44	181.93	182.37	2752608.0
2023-11-07 14:00:00	AAPL	Stock	182.3702	182.43	182.171	182.3409	1762056.0
2023-11-07 14:30:00	AAPL	Stock	182.35	182.43	181.9	182.0401	2288022.0
2023-11-07 15:00:00	AAPL	Stock	182.05	182.29	181.905	182.195	2482654.0
2023-11-07 15:30:00	AAPL	Stock	182.195	182.34	181.55	181.88	6880409.0
2023-11-07 16:00:00	AAPL	Stock	181.89	181.94	181.71	181.82	9106672.0
2023-11-07 16:30:00	AAPL	Stock	181.8	181.87	181.76	181.84	22433.0
2023-11-07 17:00:00	AAPL	Stock	181.86	181.94	181.82	181.85	79111.0
2023-11-07 17:30:00	AAPL	Stock	181.83	181.89	181.82	181.83	8052.0
2023-11-07 18:00:00	AAPL	Stock	181.83	181.88	181.73	181.84	7132.0
2023-11-07 18:30:00	AAPL	Stock	181.84	181.94	181.81	181.89	11349.0
2023-11-07 19:00:00	AAPL	Stock	181.86	181.95	181.84	181.9	5764.0
2023-11-07 19:30:00	AAPL	Stock	181.94	182.3	181.75	182.22	28103.0
2023-11-07 04:00:00	MSFT	Stock	357.37	357.37	357.13	357.19	1974.0
2023-11-07 04:30:00	MSFT	Stock	357.25	357.33	357.25	357.25	994.0
2023-11-07 05:00:00	MSFT	Stock	357.1	357.4	357.07	357.4	961.0
2023-11-07 05:30:00	MSFT	Stock	357.21	357.22	357.21	357.22	200.0
2023-11-07 06:00:00	MSFT	Stock	357.3	357.31	357.18	357.18	1369.0
2023-11-07 06:30:00	MSFT	Stock	357.03	357.03	356.8	356.8	589.0
2023-11-07 07:00:00	MSFT	Stock	356.83	358.75	356.83	358.6	25558.0
2023-11-07 07:30:00	MSFT	Stock	358.6	358.89	358.29	358.65	34160.0
2023-11-07 08:00:00	MSFT	Stock	357.45	358.8	355.46	358.5	34591.0
2023-11-07 08:30:00	MSFT	Stock	358.69	359.0	358.4375	359.0	18308.0
2023-11-07 09:00:00	MSFT	Stock	359.05	359.99	359.0	359.54	62460.0
2023-11-07 09:30:00	MSFT	Stock	359.54	359.75	357.63	359.28	2722588.0
2023-11-07 10:00:00	MSFT	Stock	359.27	360.59	358.74	360.55	1477782.0
2023-11-07 10:30:00	MSFT	Stock	360.545	362.08	359.945	361.44	1507225.0
2023-11-07 11:00:00	MSFT	Stock	361.435	362.28	360.93	362.2	837345.0
2023-11-07 11:30:00	MSFT	Stock	362.19	362.38	361.33	361.735	716600.0
2023-11-07 12:00:00	MSFT	Stock	361.73	361.7599	360.76	361.205	773891.0
2023-11-07 12:30:00	MSFT	Stock	361.22	361.97	360.91	361.63	593034.0

> showing 50 of 97,382 rows — these rows as CSV

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