PREVIEW / etf_1hour / 2022-02-22

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-02-22.parquet
  size:    468 KB
  rows:    17,276

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-22 04:00:00	SPY	ETF	430.25	430.97	428.24	428.76	141092.0
2022-02-22 05:00:00	SPY	ETF	428.99	434.66	428.92	433.32	544631.0
2022-02-22 06:00:00	SPY	ETF	433.45	433.82	432.03	433.19	230177.0
2022-02-22 07:00:00	SPY	ETF	433.12	434.63	432.22	433.81	458385.0
2022-02-22 08:00:00	SPY	ETF	432.6701	434.61	426.5	433.43	899144.0
2022-02-22 09:00:00	SPY	ETF	433.36	435.3	430.49	434.19	11181805.0
2022-02-22 10:00:00	SPY	ETF	434.19	435.5	431.67	431.78	10395875.0
2022-02-22 11:00:00	SPY	ETF	431.79	432.45	430.41	431.2404	8938843.0
2022-02-22 12:00:00	SPY	ETF	431.24	431.93	429.23	429.44	6614829.0
2022-02-22 13:00:00	SPY	ETF	429.45	430.09	426.77	427.3199	7889901.0
2022-02-22 14:00:00	SPY	ETF	427.29	431.7799	425.86	430.94	18409377.0
2022-02-22 15:00:00	SPY	ETF	430.95	432.88	428.05	429.65	25673857.0
2022-02-22 16:00:00	SPY	ETF	429.65	431.66	429.57	430.87	5277815.0
2022-02-22 17:00:00	SPY	ETF	430.79	431.0	430.62	430.76	191239.0
2022-02-22 18:00:00	SPY	ETF	430.73	432.3	429.57	432.031	210026.0
2022-02-22 19:00:00	SPY	ETF	432.13	432.2	431.86	432.14	109742.0
2022-02-22 04:00:00	QQQ	ETF	335.0	336.84	334.12	334.74	301882.0
2022-02-22 05:00:00	QQQ	ETF	334.76	340.57	334.69	339.47	339599.0
2022-02-22 06:00:00	QQQ	ETF	339.57	339.73	338.2	339.4	144905.0
2022-02-22 07:00:00	QQQ	ETF	339.15	340.35	338.37	339.83	680458.0
2022-02-22 08:00:00	QQQ	ETF	339.8701	341.766	332.28	339.9	727173.0
2022-02-22 09:00:00	QQQ	ETF	339.79	343.73	338.04	341.93	8857395.0
2022-02-22 10:00:00	QQQ	ETF	341.92	344.04	339.17	340.01	9386698.0
2022-02-22 11:00:00	QQQ	ETF	340.03	340.48	337.34	338.25	8505606.0
2022-02-22 12:00:00	QQQ	ETF	338.23	339.14	336.865	337.31	5388538.0
2022-02-22 13:00:00	QQQ	ETF	337.3023	337.91	335.22	335.63	5285166.0
2022-02-22 14:00:00	QQQ	ETF	335.63	340.36	334.35	339.5747	12599879.0
2022-02-22 15:00:00	QQQ	ETF	339.61	341.72	336.78	338.09	14964043.0
2022-02-22 16:00:00	QQQ	ETF	338.11	340.15	338.0705	339.52	2260960.0
2022-02-22 17:00:00	QQQ	ETF	339.72	340.0	339.49	339.78	235992.0
2022-02-22 18:00:00	QQQ	ETF	339.8	341.15	339.43	340.67	260174.0
2022-02-22 19:00:00	QQQ	ETF	340.7	340.86	340.37	340.83	143963.0
2022-02-22 04:00:00	IWM	ETF	197.18	197.82	196.76	197.14	48767.0
2022-02-22 05:00:00	IWM	ETF	197.29	200.0	197.23	199.4	29761.0
2022-02-22 06:00:00	IWM	ETF	199.42	199.61	198.85	199.28	18601.0
2022-02-22 07:00:00	IWM	ETF	199.29	200.01	198.9	199.71	105209.0
2022-02-22 08:00:00	IWM	ETF	199.08	199.97	196.37	199.49	158117.0
2022-02-22 09:00:00	IWM	ETF	199.49	200.09	197.78	199.33	4089773.0
2022-02-22 10:00:00	IWM	ETF	199.32	200.45	198.45	198.605	3223922.0
2022-02-22 11:00:00	IWM	ETF	198.59	198.97	197.67	198.095	2346501.0
2022-02-22 12:00:00	IWM	ETF	198.06	198.42	197.01	197.22	1582767.0
2022-02-22 13:00:00	IWM	ETF	197.225	197.6	195.58	196.08	3186984.0
2022-02-22 14:00:00	IWM	ETF	196.08	198.93	195.35	198.54	4303705.0
2022-02-22 15:00:00	IWM	ETF	198.54	199.49	196.15	196.66	4240216.0
2022-02-22 16:00:00	IWM	ETF	196.66	197.97	196.66	197.55	1317896.0
2022-02-22 17:00:00	IWM	ETF	197.45	197.78	197.38	197.6	10722.0
2022-02-22 18:00:00	IWM	ETF	197.6	198.47	196.66	198.22	35956.0
2022-02-22 19:00:00	IWM	ETF	198.24	198.38	197.95	197.99	20222.0
2022-02-22 04:00:00	DIA	ETF	337.74	337.74	337.13	337.2	4922.0
2022-02-22 05:00:00	DIA	ETF	338.07	340.61	338.07	340.38	4600.0

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

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