PREVIEW / etf_1hour / 2023-02-09

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-02-09.parquet
  size:    476 KB
  rows:    17,183

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-09 04:00:00	SPY	ETF	413.59	414.65	413.02	414.65	67317.0
2023-02-09 05:00:00	SPY	ETF	414.71	414.92	414.21	414.91	42749.0
2023-02-09 06:00:00	SPY	ETF	414.91	414.91	413.8	414.08	187351.0
2023-02-09 07:00:00	SPY	ETF	414.09	414.09	413.49	413.53	249057.0
2023-02-09 08:00:00	SPY	ETF	414.04	414.6896	411.86	414.41	426457.0
2023-02-09 09:00:00	SPY	ETF	414.45	414.57	412.96	413.35	5662344.0
2023-02-09 10:00:00	SPY	ETF	413.37	414.03	412.09	413.01	6991063.0
2023-02-09 11:00:00	SPY	ETF	413.02	413.02	410.925	411.4099	6140172.0
2023-02-09 12:00:00	SPY	ETF	411.41	412.13	409.28	410.131	6874740.0
2023-02-09 13:00:00	SPY	ETF	410.131	410.5	409.03	409.3399	6160301.0
2023-02-09 14:00:00	SPY	ETF	409.34	409.615	408.165	408.44	7741968.0
2023-02-09 15:00:00	SPY	ETF	408.45	408.47	405.81	407.13	18996700.0
2023-02-09 16:00:00	SPY	ETF	407.14	407.71	406.98	407.68	3148031.0
2023-02-09 17:00:00	SPY	ETF	407.69	407.77	407.57	407.71	70105.0
2023-02-09 18:00:00	SPY	ETF	407.65	407.66	407.24	407.4	97261.0
2023-02-09 19:00:00	SPY	ETF	407.27	407.35	406.74	407.04	160282.0
2023-02-09 04:00:00	QQQ	ETF	307.26	308.35	307.15	308.35	110962.0
2023-02-09 05:00:00	QQQ	ETF	308.36	308.78	307.89	308.78	71646.0
2023-02-09 06:00:00	QQQ	ETF	308.75	308.79	307.66	308.05	146614.0
2023-02-09 07:00:00	QQQ	ETF	308.06	308.07	307.35	307.35	347569.0
2023-02-09 08:00:00	QQQ	ETF	307.99	308.69	304.598	308.6	605391.0
2023-02-09 09:00:00	QQQ	ETF	308.61	308.99	306.68	307.63	5513475.0
2023-02-09 10:00:00	QQQ	ETF	307.64	308.45	306.17	307.16	5511113.0
2023-02-09 11:00:00	QQQ	ETF	307.16	307.17	304.86	305.45	4716680.0
2023-02-09 12:00:00	QQQ	ETF	305.42	306.27	303.46	304.485	4118295.0
2023-02-09 13:00:00	QQQ	ETF	304.47	304.98	303.26	303.54	3611029.0
2023-02-09 14:00:00	QQQ	ETF	303.53	303.86	302.34	302.67	4348966.0
2023-02-09 15:00:00	QQQ	ETF	302.67	302.68	300.2	301.64	9255514.0
2023-02-09 16:00:00	QQQ	ETF	301.65	302.19	301.411	302.16	1259435.0
2023-02-09 17:00:00	QQQ	ETF	302.19	302.19	301.68	301.94	203870.0
2023-02-09 18:00:00	QQQ	ETF	301.97	302.23	301.7	301.89	112646.0
2023-02-09 19:00:00	QQQ	ETF	301.87	301.87	301.11	301.34	135390.0
2023-02-09 04:00:00	IWM	ETF	193.8	194.6	193.8	194.6	12373.0
2023-02-09 05:00:00	IWM	ETF	194.46	194.59	194.3	194.57	4478.0
2023-02-09 06:00:00	IWM	ETF	194.31	194.35	194.18	194.2	46262.0
2023-02-09 07:00:00	IWM	ETF	194.17	194.25	193.95	193.95	61109.0
2023-02-09 08:00:00	IWM	ETF	194.2104	194.5	193.95	194.47	138725.0
2023-02-09 09:00:00	IWM	ETF	194.42	195.12	193.5	193.68	2018441.0
2023-02-09 10:00:00	IWM	ETF	193.69	194.21	192.88	193.23	1467861.0
2023-02-09 11:00:00	IWM	ETF	193.2	193.24	191.85	192.2	1482871.0
2023-02-09 12:00:00	IWM	ETF	192.1901	192.56	191.02	191.57	1618679.0
2023-02-09 13:00:00	IWM	ETF	191.54	191.56	190.77	190.86	1729097.0
2023-02-09 14:00:00	IWM	ETF	190.85	191.11	190.4	190.575	1564460.0
2023-02-09 15:00:00	IWM	ETF	190.57	190.58	189.43	189.96	3512382.0
2023-02-09 16:00:00	IWM	ETF	189.93	190.29	189.89	190.29	989604.0
2023-02-09 17:00:00	IWM	ETF	190.4	190.4	189.93	190.24	384929.0
2023-02-09 18:00:00	IWM	ETF	190.2	190.28	190.01	190.16	28804.0
2023-02-09 19:00:00	IWM	ETF	190.13	190.13	189.85	189.96	82602.0
2023-02-09 04:00:00	DIA	ETF	341.82	342.18	341.61	342.18	3660.0
2023-02-09 05:00:00	DIA	ETF	342.31	342.31	342.29	342.29	1000.0

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

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