PREVIEW / etf_1hour / 2024-12-04

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-12-04.parquet
  size:    611 KB
  rows:    22,842

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-04 04:00:00	SPY	ETF	604.68	605.58	604.68	605.39	35883.0
2024-12-04 05:00:00	SPY	ETF	605.37	605.6	605.1	605.5	51230.0
2024-12-04 06:00:00	SPY	ETF	605.48	605.81	605.46	605.81	37200.0
2024-12-04 07:00:00	SPY	ETF	605.78	605.9	605.55	605.56	139103.0
2024-12-04 08:00:00	SPY	ETF	605.7809	606.11	603.91	606.07	177400.0
2024-12-04 09:00:00	SPY	ETF	606.09	606.21	605.51	605.89	2586345.0
2024-12-04 10:00:00	SPY	ETF	605.88	606.3	604.95	606.23	3682528.0
2024-12-04 11:00:00	SPY	ETF	606.22	606.5	606.06	606.35	1446024.0
2024-12-04 12:00:00	SPY	ETF	606.345	606.54	605.91	606.4	1791645.0
2024-12-04 13:00:00	SPY	ETF	606.4	606.53	605.2	605.9801	1594153.0
2024-12-04 14:00:00	SPY	ETF	605.98	607.13	605.77	606.9158	2322841.0
2024-12-04 15:00:00	SPY	ETF	606.9	607.91	606.83	607.61	8573934.0
2024-12-04 16:00:00	SPY	ETF	607.59	607.66	607.1	607.24	3090333.0
2024-12-04 17:00:00	SPY	ETF	607.22	607.4	607.18	607.27	37073.0
2024-12-04 18:00:00	SPY	ETF	607.25	607.3	607.02	607.1	55687.0
2024-12-04 19:00:00	SPY	ETF	607.05	607.05	606.76	606.88	107387.0
2024-12-04 04:00:00	QQQ	ETF	519.54	519.94	519.36	519.93	99205.0
2024-12-04 05:00:00	QQQ	ETF	519.9	520.19	519.6	519.94	48064.0
2024-12-04 06:00:00	QQQ	ETF	519.95	520.58	519.95	520.3	56124.0
2024-12-04 07:00:00	QQQ	ETF	520.32	520.56	520.13	520.18	104716.0
2024-12-04 08:00:00	QQQ	ETF	520.4	521.061	517.257	521.06	257172.0
2024-12-04 09:00:00	QQQ	ETF	521.04	521.27	519.6	520.3	2639848.0
2024-12-04 10:00:00	QQQ	ETF	520.28	522.1	519.68	521.87	3235481.0
2024-12-04 11:00:00	QQQ	ETF	521.9199	522.25	521.06	521.65	2221412.0
2024-12-04 12:00:00	QQQ	ETF	521.64	522.12	521.25	521.86	1353610.0
2024-12-04 13:00:00	QQQ	ETF	521.85	522.16	520.88	521.67	1290978.0
2024-12-04 14:00:00	QQQ	ETF	521.64	522.74	521.44	522.61	1643722.0
2024-12-04 15:00:00	QQQ	ETF	522.59	523.52	522.486	523.25	3615312.0
2024-12-04 16:00:00	QQQ	ETF	523.24	523.27	521.761	522.76	1227736.0
2024-12-04 17:00:00	QQQ	ETF	522.79	522.83	522.65	522.65	40965.0
2024-12-04 18:00:00	QQQ	ETF	522.65	522.9092	522.48	522.72	58037.0
2024-12-04 19:00:00	QQQ	ETF	522.55	522.6	522.2502	522.32	76945.0
2024-12-04 04:00:00	IWM	ETF	239.59	240.34	239.59	240.27	25966.0
2024-12-04 05:00:00	IWM	ETF	240.32	240.47	240.06	240.41	10834.0
2024-12-04 06:00:00	IWM	ETF	240.44	240.44	240.02	240.16	12551.0
2024-12-04 07:00:00	IWM	ETF	240.16	240.42	240.09	240.35	52656.0
2024-12-04 08:00:00	IWM	ETF	240.2589	240.93	239.76	240.74	106419.0
2024-12-04 09:00:00	IWM	ETF	240.68	241.67	239.81	241.485	2350461.0
2024-12-04 10:00:00	IWM	ETF	241.44	241.65	240.43	241.11	2183224.0
2024-12-04 11:00:00	IWM	ETF	241.12	241.505	240.77	241.0	1231988.0
2024-12-04 12:00:00	IWM	ETF	240.995	241.05	240.32	240.5395	739393.0
2024-12-04 13:00:00	IWM	ETF	240.535	240.535	239.21	239.85	1190841.0
2024-12-04 14:00:00	IWM	ETF	239.86	240.37	239.52	240.02	1249024.0
2024-12-04 15:00:00	IWM	ETF	240.025	241.31	239.9201	240.92	2714523.0
2024-12-04 16:00:00	IWM	ETF	240.89	241.0	240.73	240.97	647363.0
2024-12-04 17:00:00	IWM	ETF	240.9	240.92	240.7501	240.84	6029.0
2024-12-04 18:00:00	IWM	ETF	240.75	240.86	240.61	240.66	9848.0
2024-12-04 19:00:00	IWM	ETF	240.61	240.74	240.41	240.54	40114.0
2024-12-04 04:00:00	DIA	ETF	449.3	449.89	449.3	449.81	5638.0
2024-12-04 05:00:00	DIA	ETF	449.8	450.04	449.8	450.04	3544.0

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

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