PREVIEW / etf_1hour / 2024-12-27

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-12-27.parquet
  size:    596 KB
  rows:    22,507

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-12-27 04:00:00	SPY	ETF	599.25	599.57	599.23	599.36	9632.0
2024-12-27 05:00:00	SPY	ETF	599.34	599.5	599.23	599.34	7524.0
2024-12-27 06:00:00	SPY	ETF	599.51	599.63	599.36	599.62	4695.0
2024-12-27 07:00:00	SPY	ETF	599.75	599.97	599.5	599.64	37360.0
2024-12-27 08:00:00	SPY	ETF	599.6401	600.59	598.68	598.81	192741.0
2024-12-27 09:00:00	SPY	ETF	598.81	598.9	596.43	596.82	3510506.0
2024-12-27 10:00:00	SPY	ETF	596.82	597.01	592.25	593.98	7123357.0
2024-12-27 11:00:00	SPY	ETF	593.96	594.6798	591.5801	592.0301	3873200.0
2024-12-27 12:00:00	SPY	ETF	592.03	592.46	590.7647	592.1	3753640.0
2024-12-27 13:00:00	SPY	ETF	592.08	594.12	591.8701	594.01	2386861.0
2024-12-27 14:00:00	SPY	ETF	593.97	595.53	593.622	595.26	3319752.0
2024-12-27 15:00:00	SPY	ETF	595.26	595.4	592.54	594.99	11713203.0
2024-12-27 16:00:00	SPY	ETF	595.01	595.29	594.6161	595.01	4418096.0
2024-12-27 17:00:00	SPY	ETF	595.01	595.05	594.95	595.01	34377.0
2024-12-27 18:00:00	SPY	ETF	595.0	595.01	594.92	594.92	29225.0
2024-12-27 19:00:00	SPY	ETF	594.92	595.0885	594.92	595.03	18595.0
2024-12-27 04:00:00	QQQ	ETF	527.85	527.85	527.27	527.63	35571.0
2024-12-27 05:00:00	QQQ	ETF	527.62	527.9	527.54	527.9	15989.0
2024-12-27 06:00:00	QQQ	ETF	527.94	528.08	527.65	528.08	11525.0
2024-12-27 07:00:00	QQQ	ETF	528.07	528.6	528.07	528.28	51378.0
2024-12-27 08:00:00	QQQ	ETF	528.53	528.7	526.98	527.19	148218.0
2024-12-27 09:00:00	QQQ	ETF	527.18	527.27	522.17	522.6	3477973.0
2024-12-27 10:00:00	QQQ	ETF	522.63	522.85	518.04	520.27	4192841.0
2024-12-27 11:00:00	QQQ	ETF	520.26	521.49	518.45	519.1	3509684.0
2024-12-27 12:00:00	QQQ	ETF	519.11	519.72	517.86	519.56	2651514.0
2024-12-27 13:00:00	QQQ	ETF	519.56	522.02	519.195	521.7799	2297623.0
2024-12-27 14:00:00	QQQ	ETF	521.78	522.86	520.965	522.62	2303666.0
2024-12-27 15:00:00	QQQ	ETF	522.61	522.81	520.27	522.57	4460963.0
2024-12-27 16:00:00	QQQ	ETF	522.56	523.25	522.5	522.94	1339949.0
2024-12-27 17:00:00	QQQ	ETF	522.92	522.98	522.56	522.65	52218.0
2024-12-27 18:00:00	QQQ	ETF	522.6303	522.66	522.43	522.47	20741.0
2024-12-27 19:00:00	QQQ	ETF	522.48	522.53	522.42	522.43	12124.0
2024-12-27 04:00:00	IWM	ETF	224.6	225.0	224.45	224.74	17813.0
2024-12-27 05:00:00	IWM	ETF	224.77	224.8	224.57	224.57	3601.0
2024-12-27 06:00:00	IWM	ETF	224.9	224.9	224.69	224.84	2436.0
2024-12-27 07:00:00	IWM	ETF	224.77	225.0	224.77	225.0	61792.0
2024-12-27 08:00:00	IWM	ETF	224.87	225.21	224.45	224.59	101081.0
2024-12-27 09:00:00	IWM	ETF	224.56	225.44	223.9	224.39	1769260.0
2024-12-27 10:00:00	IWM	ETF	224.45	224.51	221.21	222.58	3289549.0
2024-12-27 11:00:00	IWM	ETF	222.59	222.621	220.34	220.65	2943929.0
2024-12-27 12:00:00	IWM	ETF	220.63	220.93	220.2	220.82	1809807.0
2024-12-27 13:00:00	IWM	ETF	220.79	221.98	220.79	221.85	1285562.0
2024-12-27 14:00:00	IWM	ETF	221.83	222.65	221.525	222.6	2061800.0
2024-12-27 15:00:00	IWM	ETF	222.59	222.64	221.5	222.34	3440934.0
2024-12-27 16:00:00	IWM	ETF	222.39	222.54	222.22	222.52	1563094.0
2024-12-27 17:00:00	IWM	ETF	222.4936	222.5	222.2004	222.25	11937.0
2024-12-27 18:00:00	IWM	ETF	222.1203	222.2	222.03	222.03	7205.0
2024-12-27 19:00:00	IWM	ETF	221.95	222.09	221.95	222.09	3348.0
2024-12-27 04:00:00	DIA	ETF	432.27	432.31	432.12	432.18	950.0
2024-12-27 05:00:00	DIA	ETF	432.2	432.2	432.18	432.18	399.0

> showing 50 of 22,507 rows — these rows as CSV

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