PREVIEW / etf_30min / 2023-12-19

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-12-19.parquet
  size:    793 KB
  rows:    31,508

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-19 04:00:00	SPY	ETF	472.43	472.62	472.38	472.57	9344.0
2023-12-19 04:30:00	SPY	ETF	472.55	472.55	472.41	472.44	4896.0
2023-12-19 05:00:00	SPY	ETF	472.48	472.48	472.39	472.4	2100.0
2023-12-19 05:30:00	SPY	ETF	472.4	472.49	472.33	472.33	1782.0
2023-12-19 06:00:00	SPY	ETF	472.42	472.59	472.4	472.59	9448.0
2023-12-19 06:30:00	SPY	ETF	472.51	472.65	472.5	472.54	18174.0
2023-12-19 07:00:00	SPY	ETF	472.5	473.11	472.5	472.78	59607.0
2023-12-19 07:30:00	SPY	ETF	472.751	473.17	472.66	473.12	63930.0
2023-12-19 08:00:00	SPY	ETF	472.5206	473.22	472.13	473.19	150181.0
2023-12-19 08:30:00	SPY	ETF	473.06	473.15	472.82	472.91	129843.0
2023-12-19 09:00:00	SPY	ETF	472.86	472.9	472.49	472.53	168595.0
2023-12-19 09:30:00	SPY	ETF	472.54	473.66	472.45	473.48	4568309.0
2023-12-19 10:00:00	SPY	ETF	473.5	474.03	473.04	473.85	3549765.0
2023-12-19 10:30:00	SPY	ETF	473.86	474.08	473.62	474.065	2852669.0
2023-12-19 11:00:00	SPY	ETF	474.07	474.43	473.8499	474.2499	2467318.0
2023-12-19 11:30:00	SPY	ETF	474.255	474.475	473.865	473.91	2594981.0
2023-12-19 12:00:00	SPY	ETF	473.9	474.05	473.6305	473.855	2299590.0
2023-12-19 12:30:00	SPY	ETF	473.85	474.21	473.8	474.075	1728119.0
2023-12-19 13:00:00	SPY	ETF	474.08	474.145	473.6399	473.97	1990194.0
2023-12-19 13:30:00	SPY	ETF	473.98	474.35	473.7701	474.1758	2003570.0
2023-12-19 14:00:00	SPY	ETF	474.18	474.35	474.07	474.33	1668349.0
2023-12-19 14:30:00	SPY	ETF	474.33	474.41	474.0	474.17	2414184.0
2023-12-19 15:00:00	SPY	ETF	474.18	474.32	473.82	474.19	2304548.0
2023-12-19 15:30:00	SPY	ETF	474.19	474.92	474.04	474.82	7047427.0
2023-12-19 16:00:00	SPY	ETF	474.81	474.91	474.0589	474.59	3459372.0
2023-12-19 16:30:00	SPY	ETF	474.58	474.59	474.51	474.59	122891.0
2023-12-19 17:00:00	SPY	ETF	474.6	474.84	474.54	474.76	2163820.0
2023-12-19 17:30:00	SPY	ETF	474.76	474.815	474.69	474.7	128197.0
2023-12-19 18:00:00	SPY	ETF	474.7	474.7896	474.55	474.73	98718.0
2023-12-19 18:30:00	SPY	ETF	474.76	474.84	474.57	474.6	35793.0
2023-12-19 19:00:00	SPY	ETF	474.58	474.69	474.58	474.68	8328.0
2023-12-19 19:30:00	SPY	ETF	474.67	474.75	474.66	474.67	49777.0
2023-12-19 04:00:00	QQQ	ETF	407.22	407.46	407.0	407.33	33018.0
2023-12-19 04:30:00	QQQ	ETF	407.34	407.43	407.24	407.33	14386.0
2023-12-19 05:00:00	QQQ	ETF	407.33	407.42	407.32	407.32	3788.0
2023-12-19 05:30:00	QQQ	ETF	407.36	407.43	407.27	407.39	9117.0
2023-12-19 06:00:00	QQQ	ETF	407.39	407.6	407.23	407.59	20641.0
2023-12-19 06:30:00	QQQ	ETF	407.57	407.76	407.57	407.59	22981.0
2023-12-19 07:00:00	QQQ	ETF	407.58	408.37	407.49	407.77	83271.0
2023-12-19 07:30:00	QQQ	ETF	407.7	408.08	407.6	408.08	108763.0
2023-12-19 08:00:00	QQQ	ETF	407.6193	408.3304	406.75	407.89	122064.0
2023-12-19 08:30:00	QQQ	ETF	407.8	407.85	407.52	407.69	105850.0
2023-12-19 09:00:00	QQQ	ETF	407.68	407.83	407.47	407.56	119297.0
2023-12-19 09:30:00	QQQ	ETF	407.54	408.5286	407.345	408.18	3461304.0
2023-12-19 10:00:00	QQQ	ETF	408.19	408.57	407.54	408.45	2433098.0
2023-12-19 10:30:00	QQQ	ETF	408.44	408.87	407.81	408.6599	2088834.0
2023-12-19 11:00:00	QQQ	ETF	408.67	408.94	408.31	408.6	1722765.0
2023-12-19 11:30:00	QQQ	ETF	408.61	408.8988	408.1899	408.2014	1426720.0
2023-12-19 12:00:00	QQQ	ETF	408.2	408.34	407.84	408.27	1497782.0
2023-12-19 12:30:00	QQQ	ETF	408.26	408.7199	408.225	408.5123	1037242.0

> showing 50 of 31,508 rows — these rows as CSV

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