PREVIEW / etf_1hour / 2023-03-03

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-03-03.parquet
  size:    462 KB
  rows:    16,862

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-03-03 04:00:00	SPY	ETF	397.56	398.42	397.56	398.17	32033.0
2023-03-03 05:00:00	SPY	ETF	398.23	398.79	398.23	398.63	42185.0
2023-03-03 06:00:00	SPY	ETF	398.72	399.1	398.7	398.99	36992.0
2023-03-03 07:00:00	SPY	ETF	399.05	399.4	398.59	398.65	302074.0
2023-03-03 08:00:00	SPY	ETF	399.27	399.9	397.0	399.87	599003.0
2023-03-03 09:00:00	SPY	ETF	399.87	400.92	399.155	400.55	8716253.0
2023-03-03 10:00:00	SPY	ETF	400.52	401.5	399.03	400.71	13604134.0
2023-03-03 11:00:00	SPY	ETF	400.75	402.15	400.52	401.9214	7191180.0
2023-03-03 12:00:00	SPY	ETF	401.93	403.0	401.84	402.95	5793843.0
2023-03-03 13:00:00	SPY	ETF	402.96	403.24	402.65	402.875	5289072.0
2023-03-03 14:00:00	SPY	ETF	402.89	403.89	402.58	403.845	6909416.0
2023-03-03 15:00:00	SPY	ETF	403.85	404.45	403.48	404.14	16976200.0
2023-03-03 16:00:00	SPY	ETF	404.13	405.0	403.89	404.44	5428701.0
2023-03-03 17:00:00	SPY	ETF	404.47	404.62	404.38	404.48	99728.0
2023-03-03 18:00:00	SPY	ETF	404.49	404.65	404.41	404.59	14130.0
2023-03-03 19:00:00	SPY	ETF	404.6	404.95	404.57	404.73	49765.0
2023-03-03 04:00:00	QQQ	ETF	293.71	294.33	293.71	294.0	78458.0
2023-03-03 05:00:00	QQQ	ETF	294.21	294.65	294.11	294.43	39562.0
2023-03-03 06:00:00	QQQ	ETF	294.38	294.92	294.38	294.87	78181.0
2023-03-03 07:00:00	QQQ	ETF	294.83	295.12	294.08	294.22	407782.0
2023-03-03 08:00:00	QQQ	ETF	295.048	295.56	292.64	295.5	778466.0
2023-03-03 09:00:00	QQQ	ETF	295.52	296.9752	294.87	296.75	6505170.0
2023-03-03 10:00:00	QQQ	ETF	296.72	297.8	295.335	296.65	8894702.0
2023-03-03 11:00:00	QQQ	ETF	296.67	297.75	296.28	297.54	4706338.0
2023-03-03 12:00:00	QQQ	ETF	297.56	298.62	297.38	298.5699	3954485.0
2023-03-03 13:00:00	QQQ	ETF	298.57	298.86	298.27	298.6599	3490879.0
2023-03-03 14:00:00	QQQ	ETF	298.66	299.6	298.4	299.5	4098716.0
2023-03-03 15:00:00	QQQ	ETF	299.5	299.92	299.03	299.7	10712280.0
2023-03-03 16:00:00	QQQ	ETF	299.69	300.1	299.4	300.04	2541499.0
2023-03-03 17:00:00	QQQ	ETF	300.02	300.06	299.68	300.04	101965.0
2023-03-03 18:00:00	QQQ	ETF	299.92	300.07	299.81	300.01	19070.0
2023-03-03 19:00:00	QQQ	ETF	300.07	300.38	300.02	300.3	49981.0
2023-03-03 04:00:00	IWM	ETF	188.83	189.2	188.83	189.03	4408.0
2023-03-03 05:00:00	IWM	ETF	189.19	189.37	189.07	189.32	4556.0
2023-03-03 06:00:00	IWM	ETF	189.32	189.49	189.32	189.38	4321.0
2023-03-03 07:00:00	IWM	ETF	189.46	189.73	189.37	189.42	84889.0
2023-03-03 08:00:00	IWM	ETF	189.61	189.88	189.32	189.86	103456.0
2023-03-03 09:00:00	IWM	ETF	189.93	190.09	188.91	189.44	2111496.0
2023-03-03 10:00:00	IWM	ETF	189.42	189.89	188.42	189.23	2906764.0
2023-03-03 11:00:00	IWM	ETF	189.235	190.83	189.235	190.695	1914826.0
2023-03-03 12:00:00	IWM	ETF	190.7	191.13	190.64	191.08	1265437.0
2023-03-03 13:00:00	IWM	ETF	191.09	191.39	190.99	191.27	1267418.0
2023-03-03 14:00:00	IWM	ETF	191.27	191.77	191.19	191.68	1456203.0
2023-03-03 15:00:00	IWM	ETF	191.68	191.93	191.27	191.49	3601052.0
2023-03-03 16:00:00	IWM	ETF	191.5	191.7	191.4	191.611	1036125.0
2023-03-03 17:00:00	IWM	ETF	191.53	191.73	191.5	191.69	1232926.0
2023-03-03 18:00:00	IWM	ETF	191.61	191.68	191.61	191.63	3040.0
2023-03-03 19:00:00	IWM	ETF	191.63	191.9	191.54	191.73	19736.0
2023-03-03 04:00:00	DIA	ETF	330.4	330.66	330.4	330.66	700.0
2023-03-03 05:00:00	DIA	ETF	330.61	330.75	330.61	330.75	200.0

> showing 50 of 16,862 rows — these rows as CSV

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