PREVIEW / etf_1hour / 2023-02-17

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-02-17.parquet
  size:    467 KB
  rows:    17,010

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-02-17 04:00:00	SPY	ETF	405.84	406.49	405.37	405.96	42129.0
2023-02-17 05:00:00	SPY	ETF	406.07	406.07	405.37	405.37	33871.0
2023-02-17 06:00:00	SPY	ETF	405.37	405.73	405.05	405.53	187532.0
2023-02-17 07:00:00	SPY	ETF	405.54	406.26	405.43	406.1	392694.0
2023-02-17 08:00:00	SPY	ETF	406.0	408.3431	404.94	406.19	803651.0
2023-02-17 09:00:00	SPY	ETF	406.16	406.81	404.18	404.74	8797295.0
2023-02-17 10:00:00	SPY	ETF	404.75	407.23	404.68	404.94	9972680.0
2023-02-17 11:00:00	SPY	ETF	404.935	405.52	404.12	404.8	6928176.0
2023-02-17 12:00:00	SPY	ETF	404.79	405.9808	404.05	404.4699	5615421.0
2023-02-17 13:00:00	SPY	ETF	404.47	405.46	404.25	405.16	6040024.0
2023-02-17 14:00:00	SPY	ETF	405.17	407.25	405.1	407.089	8358864.0
2023-02-17 15:00:00	SPY	ETF	407.11	407.51	406.3787	407.24	13126284.0
2023-02-17 16:00:00	SPY	ETF	407.24	408.04	406.95	407.07	3843511.0
2023-02-17 17:00:00	SPY	ETF	407.11	407.26	407.0	407.1716	333833.0
2023-02-17 18:00:00	SPY	ETF	407.08	407.26	406.94	407.2	69757.0
2023-02-17 19:00:00	SPY	ETF	407.25	407.6	407.21	407.38	28273.0
2023-02-17 04:00:00	QQQ	ETF	300.73	301.52	300.49	300.83	113992.0
2023-02-17 05:00:00	QQQ	ETF	300.95	300.96	300.34	300.34	60929.0
2023-02-17 06:00:00	QQQ	ETF	300.31	300.71	300.01	300.54	92003.0
2023-02-17 07:00:00	QQQ	ETF	300.62	301.2	300.52	300.9	301503.0
2023-02-17 08:00:00	QQQ	ETF	300.75	301.57	300.0	301.13	659495.0
2023-02-17 09:00:00	QQQ	ETF	301.04	301.93	298.88	299.67	7310834.0
2023-02-17 10:00:00	QQQ	ETF	299.66	301.5695	299.33	299.405	7123179.0
2023-02-17 11:00:00	QQQ	ETF	299.39	299.86	298.34	299.0094	4959625.0
2023-02-17 12:00:00	QQQ	ETF	299.0	300.09	298.1	298.5	4039073.0
2023-02-17 13:00:00	QQQ	ETF	298.52	299.37	298.33	299.1204	3206249.0
2023-02-17 14:00:00	QQQ	ETF	299.13	301.27	299.05	301.12	4092551.0
2023-02-17 15:00:00	QQQ	ETF	301.14	301.52	300.24	301.15	7255199.0
2023-02-17 16:00:00	QQQ	ETF	301.15	301.2	300.9	300.98	1730162.0
2023-02-17 17:00:00	QQQ	ETF	301.0	301.16	300.89	301.01	898127.0
2023-02-17 18:00:00	QQQ	ETF	301.01	301.45	301.01	301.4	1115654.0
2023-02-17 19:00:00	QQQ	ETF	301.45	301.5	301.31	301.5	14312.0
2023-02-17 04:00:00	IWM	ETF	191.21	191.76	190.97	191.54	8487.0
2023-02-17 05:00:00	IWM	ETF	191.49	191.54	191.27	191.27	2712.0
2023-02-17 06:00:00	IWM	ETF	191.25	191.37	191.08	191.27	3480.0
2023-02-17 07:00:00	IWM	ETF	191.31	191.61	191.26	191.56	64442.0
2023-02-17 08:00:00	IWM	ETF	191.61	191.89	191.39	191.83	88430.0
2023-02-17 09:00:00	IWM	ETF	191.81	192.59	190.97	191.31	2631789.0
2023-02-17 10:00:00	IWM	ETF	191.28	193.23	191.27	191.93	2548266.0
2023-02-17 11:00:00	IWM	ETF	191.925	192.3373	191.48	191.92	1836041.0
2023-02-17 12:00:00	IWM	ETF	191.92	192.54	191.56	191.84	1568085.0
2023-02-17 13:00:00	IWM	ETF	191.85	192.4	191.7	192.16	927126.0
2023-02-17 14:00:00	IWM	ETF	192.17	193.19	192.08	193.09	1219904.0
2023-02-17 15:00:00	IWM	ETF	193.1	193.3699	192.695	193.09	2349897.0
2023-02-17 16:00:00	IWM	ETF	193.13	193.16	192.95	192.99	1306499.0
2023-02-17 17:00:00	IWM	ETF	192.92	193.13	192.86	193.09	33991.0
2023-02-17 18:00:00	IWM	ETF	193.1	193.25	193.02	193.2	181819.0
2023-02-17 19:00:00	IWM	ETF	193.19	193.29	193.13	193.29	7424.0
2023-02-17 04:00:00	DIA	ETF	335.75	335.75	335.75	335.75	253.0
2023-02-17 06:00:00	DIA	ETF	335.29	335.29	335.12	335.12	2050.0

> showing 50 of 17,010 rows — these rows as CSV

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