PREVIEW / etf_1hour / 2022-03-02

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-03-02.parquet
  size:    456 KB
  rows:    16,612

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
2022-03-02 04:00:00	SPY	ETF	429.3	433.6	428.87	433.16	70535.0
2022-03-02 05:00:00	SPY	ETF	433.03	434.0	432.11	432.41	73686.0
2022-03-02 06:00:00	SPY	ETF	432.59	433.59	432.01	433.02	39684.0
2022-03-02 07:00:00	SPY	ETF	432.95	433.61	431.62	432.6	292299.0
2022-03-02 08:00:00	SPY	ETF	433.15	433.57	427.87	431.46	809158.0
2022-03-02 09:00:00	SPY	ETF	431.43	434.77	431.42	433.63	8559737.0
2022-03-02 10:00:00	SPY	ETF	433.61	435.68	431.57	434.51	16597677.0
2022-03-02 11:00:00	SPY	ETF	434.52	438.3	433.6	437.1	14176144.0
2022-03-02 12:00:00	SPY	ETF	437.09	438.12	436.51	437.7812	8236077.0
2022-03-02 13:00:00	SPY	ETF	437.78	439.32	437.78	438.75	7415103.0
2022-03-02 14:00:00	SPY	ETF	438.77	439.46	437.6304	437.9986	8102799.0
2022-03-02 15:00:00	SPY	ETF	437.97	439.72	437.67	437.83	19739556.0
2022-03-02 16:00:00	SPY	ETF	437.84	438.01	436.7	437.05	5526194.0
2022-03-02 17:00:00	SPY	ETF	437.0	437.89	436.55	436.82	120549.0
2022-03-02 18:00:00	SPY	ETF	436.94	437.33	436.78	437.2	88093.0
2022-03-02 19:00:00	SPY	ETF	437.26	437.43	437.01	437.28	75998.0
2022-03-02 04:00:00	QQQ	ETF	341.19	344.19	340.65	343.69	95428.0
2022-03-02 05:00:00	QQQ	ETF	343.6	344.88	343.24	343.8	95082.0
2022-03-02 06:00:00	QQQ	ETF	343.78	344.85	343.62	344.08	83540.0
2022-03-02 07:00:00	QQQ	ETF	343.95	344.55	343.08	343.59	224718.0
2022-03-02 08:00:00	QQQ	ETF	344.12	344.9296	339.79	342.26	1915434.0
2022-03-02 09:00:00	QQQ	ETF	342.21	344.62	341.725	343.26	7666915.0
2022-03-02 10:00:00	QQQ	ETF	343.25	344.47	340.24	342.62	13346468.0
2022-03-02 11:00:00	QQQ	ETF	342.63	346.87	341.76	345.415	8670524.0
2022-03-02 12:00:00	QQQ	ETF	345.41	346.57	345.07	346.09	4052206.0
2022-03-02 13:00:00	QQQ	ETF	346.1	347.87	346.09	347.1256	3669780.0
2022-03-02 14:00:00	QQQ	ETF	347.14	348.31	346.74	347.245	3983601.0
2022-03-02 15:00:00	QQQ	ETF	347.23	348.59	347.08	347.18	8127412.0
2022-03-02 16:00:00	QQQ	ETF	347.21	347.31	345.65	346.19	1779347.0
2022-03-02 17:00:00	QQQ	ETF	346.19	347.22	345.7	346.01	193603.0
2022-03-02 18:00:00	QQQ	ETF	346.0	346.48	346.0	346.43	111041.0
2022-03-02 19:00:00	QQQ	ETF	346.45	346.58	346.21	346.44	85938.0
2022-03-02 04:00:00	IWM	ETF	198.97	201.29	198.77	201.15	33195.0
2022-03-02 05:00:00	IWM	ETF	201.2	201.58	200.65	200.79	23355.0
2022-03-02 06:00:00	IWM	ETF	200.67	201.34	200.45	201.13	20232.0
2022-03-02 07:00:00	IWM	ETF	201.0	201.41	200.31	200.84	86744.0
2022-03-02 08:00:00	IWM	ETF	200.8101	200.98	199.55	200.1	231760.0
2022-03-02 09:00:00	IWM	ETF	200.1	202.828	200.09	202.42	3879167.0
2022-03-02 10:00:00	IWM	ETF	202.4	203.18	201.19	202.56	4112468.0
2022-03-02 11:00:00	IWM	ETF	202.55	203.97	202.16	203.48	2919148.0
2022-03-02 12:00:00	IWM	ETF	203.47	204.13	203.31	204.07	1803741.0
2022-03-02 13:00:00	IWM	ETF	204.08	204.95	204.08	204.89	2044667.0
2022-03-02 14:00:00	IWM	ETF	204.89	205.3	204.1	204.27	2248601.0
2022-03-02 15:00:00	IWM	ETF	204.26	205.0	204.06	204.33	3503837.0
2022-03-02 16:00:00	IWM	ETF	204.35	204.36	203.8	203.82	893449.0
2022-03-02 17:00:00	IWM	ETF	203.75	204.24	203.68	203.8399	204234.0
2022-03-02 18:00:00	IWM	ETF	203.77	203.84	203.6	203.73	61747.0
2022-03-02 19:00:00	IWM	ETF	203.77	203.91	203.62	203.8	24140.0
2022-03-02 04:00:00	DIA	ETF	333.87	335.91	333.56	335.63	7994.0
2022-03-02 05:00:00	DIA	ETF	335.9	335.9	334.95	334.99	5816.0

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

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