PREVIEW / etf_1hour / 2022-02-23

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-02-23.parquet
  size:    463 KB
  rows:    16,664

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-02-23 04:00:00	SPY	ETF	433.45	434.16	433.16	433.16	73043.0
2022-02-23 05:00:00	SPY	ETF	433.13	433.37	432.24	432.6	43278.0
2022-02-23 06:00:00	SPY	ETF	432.65	432.9	431.24	431.53	35461.0
2022-02-23 07:00:00	SPY	ETF	431.39	433.5	431.31	433.07	210743.0
2022-02-23 08:00:00	SPY	ETF	432.4801	433.9796	431.3996	433.09	688138.0
2022-02-23 09:00:00	SPY	ETF	433.06	433.27	431.0	431.16	8434676.0
2022-02-23 10:00:00	SPY	ETF	431.1675	431.17	427.68	428.14	12208277.0
2022-02-23 11:00:00	SPY	ETF	428.14	429.12	426.61	428.81	9951052.0
2022-02-23 12:00:00	SPY	ETF	428.83	430.26	427.65	428.02	8462353.0
2022-02-23 13:00:00	SPY	ETF	428.01	428.02	425.05	426.16	10166846.0
2022-02-23 14:00:00	SPY	ETF	426.16	426.64	423.03	423.6101	11979932.0
2022-02-23 15:00:00	SPY	ETF	423.62	423.89	421.35	421.97	31390906.0
2022-02-23 16:00:00	SPY	ETF	421.97	422.43	420.99	421.16	5700388.0
2022-02-23 17:00:00	SPY	ETF	421.17	421.34	420.82	421.3	89487.0
2022-02-23 18:00:00	SPY	ETF	421.28	422.15	420.59	421.48	280445.0
2022-02-23 19:00:00	SPY	ETF	421.51	421.98	418.78	418.85	364342.0
2022-02-23 04:00:00	QQQ	ETF	341.01	342.96	341.01	342.09	188603.0
2022-02-23 05:00:00	QQQ	ETF	342.13	342.42	341.01	341.5	149686.0
2022-02-23 06:00:00	QQQ	ETF	341.46	341.59	340.31	340.45	112827.0
2022-02-23 07:00:00	QQQ	ETF	340.46	342.24	340.25	341.96	279923.0
2022-02-23 08:00:00	QQQ	ETF	340.88	342.9196	340.0	341.96	495576.0
2022-02-23 09:00:00	QQQ	ETF	341.92	342.183	338.78	339.08	6957535.0
2022-02-23 10:00:00	QQQ	ETF	339.09	339.09	335.37	336.04	9862066.0
2022-02-23 11:00:00	QQQ	ETF	336.04	337.28	334.42	336.8099	7449412.0
2022-02-23 12:00:00	QQQ	ETF	336.81	338.09	335.39	335.69	5815131.0
2022-02-23 13:00:00	QQQ	ETF	335.6997	335.6997	332.95	333.73	7492454.0
2022-02-23 14:00:00	QQQ	ETF	333.67	334.279	330.92	331.42	8276773.0
2022-02-23 15:00:00	QQQ	ETF	331.41	331.64	329.1	329.41	15562039.0
2022-02-23 16:00:00	QQQ	ETF	329.41	330.18	328.57	328.88	3398452.0
2022-02-23 17:00:00	QQQ	ETF	328.92	328.99	328.32	328.52	157410.0
2022-02-23 18:00:00	QQQ	ETF	328.69	329.62	328.22	329.16	556039.0
2022-02-23 19:00:00	QQQ	ETF	329.26	329.55	326.38	326.49	424670.0
2022-02-23 04:00:00	IWM	ETF	199.23	199.53	198.8	198.86	33301.0
2022-02-23 05:00:00	IWM	ETF	198.69	198.84	198.2	198.47	32790.0
2022-02-23 06:00:00	IWM	ETF	198.42	198.47	197.2	197.43	32527.0
2022-02-23 07:00:00	IWM	ETF	197.4	198.45	197.4	198.35	51818.0
2022-02-23 08:00:00	IWM	ETF	198.3304	198.57	197.32	198.18	92852.0
2022-02-23 09:00:00	IWM	ETF	198.16	198.9	197.43	197.59	2733191.0
2022-02-23 10:00:00	IWM	ETF	197.61	197.61	195.55	195.81	3641311.0
2022-02-23 11:00:00	IWM	ETF	195.79	196.42	195.04	196.35	2320347.0
2022-02-23 12:00:00	IWM	ETF	196.3551	197.32	196.005	196.19	2029783.0
2022-02-23 13:00:00	IWM	ETF	196.2	196.2	194.68	195.23	3157501.0
2022-02-23 14:00:00	IWM	ETF	195.21	195.404	193.86	194.34	2301987.0
2022-02-23 15:00:00	IWM	ETF	194.33	194.485	192.55	192.93	6319693.0
2022-02-23 16:00:00	IWM	ETF	192.98	193.39	192.65	192.76	1166776.0
2022-02-23 17:00:00	IWM	ETF	192.97	192.97	192.36	192.55	19491.0
2022-02-23 18:00:00	IWM	ETF	192.79	193.25	192.36	192.8	67641.0
2022-02-23 19:00:00	IWM	ETF	193.08	193.1	191.44	191.44	93060.0
2022-02-23 04:00:00	DIA	ETF	338.39	338.82	338.39	338.41	3472.0
2022-02-23 05:00:00	DIA	ETF	337.88	338.3	337.84	337.84	2886.0

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

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