PREVIEW / etf_30min / 2024-01-18

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-01-18.parquet
  size:    795 KB
  rows:    31,199

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
2024-01-18 04:00:00	SPY	ETF	472.64	473.01	472.62	472.91	10558.0
2024-01-18 04:30:00	SPY	ETF	472.87	473.14	472.79	472.85	8382.0
2024-01-18 05:00:00	SPY	ETF	472.83	472.87	472.62	472.78	14209.0
2024-01-18 05:30:00	SPY	ETF	472.77	473.46	472.77	473.43	5771.0
2024-01-18 06:00:00	SPY	ETF	473.5	473.9	473.5	473.9	23617.0
2024-01-18 06:30:00	SPY	ETF	473.86	474.21	473.73	474.15	133863.0
2024-01-18 07:00:00	SPY	ETF	474.13	474.59	474.0	474.4	84685.0
2024-01-18 07:30:00	SPY	ETF	474.42	474.67	474.3	474.34	116801.0
2024-01-18 08:00:00	SPY	ETF	474.34	474.69	472.04	474.6005	204606.0
2024-01-18 08:30:00	SPY	ETF	474.6	475.16	473.69	473.72	446167.0
2024-01-18 09:00:00	SPY	ETF	473.76	474.63	473.76	474.0	419856.0
2024-01-18 09:30:00	SPY	ETF	474.01	474.47	473.39	473.87	6100151.0
2024-01-18 10:00:00	SPY	ETF	473.875	474.349	473.395	474.16	3926595.0
2024-01-18 10:30:00	SPY	ETF	474.195	474.88	473.785	474.2701	4237049.0
2024-01-18 11:00:00	SPY	ETF	474.28	474.78	473.66	474.6866	3376442.0
2024-01-18 11:30:00	SPY	ETF	474.69	475.03	474.1888	474.4687	3094198.0
2024-01-18 12:00:00	SPY	ETF	474.47	474.5521	473.04	473.59	4179324.0
2024-01-18 12:30:00	SPY	ETF	473.6	473.66	473.0	473.18	2797787.0
2024-01-18 13:00:00	SPY	ETF	473.19	473.21	472.42	472.73	3464421.0
2024-01-18 13:30:00	SPY	ETF	472.74	474.1299	472.7	473.9801	3057650.0
2024-01-18 14:00:00	SPY	ETF	473.98	475.66	473.975	475.62	4563230.0
2024-01-18 14:30:00	SPY	ETF	475.62	475.9499	474.94	475.74	4443131.0
2024-01-18 15:00:00	SPY	ETF	475.75	476.41	475.59	476.41	3972751.0
2024-01-18 15:30:00	SPY	ETF	476.41	477.06	475.9	476.46	11511492.0
2024-01-18 16:00:00	SPY	ETF	476.46	476.68	474.2002	476.62	4292156.0
2024-01-18 16:30:00	SPY	ETF	476.62	476.65	476.47	476.5	153085.0
2024-01-18 17:00:00	SPY	ETF	476.5	476.54	476.49	476.54	38826.0
2024-01-18 17:30:00	SPY	ETF	476.54	476.6	476.52	476.6	12040.0
2024-01-18 18:00:00	SPY	ETF	476.52	476.58	476.31	476.51	71273.0
2024-01-18 18:30:00	SPY	ETF	476.49	476.88	476.43	476.88	52703.0
2024-01-18 19:00:00	SPY	ETF	476.84	476.87	476.57	476.83	22095.0
2024-01-18 19:30:00	SPY	ETF	476.84	476.86	476.63	476.74	40438.0
2024-01-18 04:00:00	QQQ	ETF	407.24	408.65	407.24	408.65	49250.0
2024-01-18 04:30:00	QQQ	ETF	408.63	409.0	408.45	408.64	21225.0
2024-01-18 05:00:00	QQQ	ETF	408.6	408.66	408.47	408.66	18128.0
2024-01-18 05:30:00	QQQ	ETF	408.56	409.18	408.56	409.18	8537.0
2024-01-18 06:00:00	QQQ	ETF	409.21	409.81	409.14	409.79	55218.0
2024-01-18 06:30:00	QQQ	ETF	409.71	410.51	409.71	410.38	75775.0
2024-01-18 07:00:00	QQQ	ETF	410.38	410.8	410.3	410.57	77931.0
2024-01-18 07:30:00	QQQ	ETF	410.65	411.17	410.63	410.72	196558.0
2024-01-18 08:00:00	QQQ	ETF	410.3802	411.18	406.86	410.981	273686.0
2024-01-18 08:30:00	QQQ	ETF	410.91	411.61	410.05	410.16	460926.0
2024-01-18 09:00:00	QQQ	ETF	410.2	411.14	410.2	410.5	382597.0
2024-01-18 09:30:00	QQQ	ETF	410.52	411.86	410.49	411.2199	5757590.0
2024-01-18 10:00:00	QQQ	ETF	411.22	411.55	410.22	411.33	3612823.0
2024-01-18 10:30:00	QQQ	ETF	411.35	412.46	410.73	411.89	3728469.0
2024-01-18 11:00:00	QQQ	ETF	411.92	412.66	411.18	412.5901	2657286.0
2024-01-18 11:30:00	QQQ	ETF	412.6	412.9881	412.12	412.4219	2582355.0
2024-01-18 12:00:00	QQQ	ETF	412.42	412.505	410.34	411.1501	3640923.0
2024-01-18 12:30:00	QQQ	ETF	411.16	411.19	410.32	410.57	2006895.0

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

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