PREVIEW / etf_1hour / 2022-03-04

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-03-04.parquet
  size:    457 KB
  rows:    16,738

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-04 04:00:00	SPY	ETF	431.62	433.07	431.34	432.19	126270.0
2022-03-04 05:00:00	SPY	ETF	432.15	433.59	431.89	432.0	80566.0
2022-03-04 06:00:00	SPY	ETF	432.04	432.6	431.39	431.94	118057.0
2022-03-04 07:00:00	SPY	ETF	432.12	432.49	430.74	432.2	336129.0
2022-03-04 08:00:00	SPY	ETF	431.7099	436.096	430.76	431.58	1369311.0
2022-03-04 09:00:00	SPY	ETF	431.66	432.49	429.37	431.79	10903307.0
2022-03-04 10:00:00	SPY	ETF	431.78	432.43	428.35	428.51	14399954.0
2022-03-04 11:00:00	SPY	ETF	428.51	430.02	427.88	429.22	10555946.0
2022-03-04 12:00:00	SPY	ETF	429.2265	432.35	428.72	431.935	9299841.0
2022-03-04 13:00:00	SPY	ETF	431.94	433.37	430.31	430.48	8315500.0
2022-03-04 14:00:00	SPY	ETF	430.48	431.86	429.2	429.31	9140902.0
2022-03-04 15:00:00	SPY	ETF	429.32	432.63	429.22	432.24	20032608.0
2022-03-04 16:00:00	SPY	ETF	432.24	432.3068	431.52	431.78	4042257.0
2022-03-04 17:00:00	SPY	ETF	431.62	432.17	431.51	431.67	141089.0
2022-03-04 18:00:00	SPY	ETF	431.7	431.94	430.0	431.15	73144.0
2022-03-04 19:00:00	SPY	ETF	431.15	431.5	431.09	431.28	21609.0
2022-03-04 04:00:00	QQQ	ETF	340.2	340.24	338.72	339.25	127633.0
2022-03-04 05:00:00	QQQ	ETF	339.41	341.0	339.28	339.56	146945.0
2022-03-04 06:00:00	QQQ	ETF	339.21	340.08	339.0	339.56	143281.0
2022-03-04 07:00:00	QQQ	ETF	339.73	339.93	338.33	339.77	387259.0
2022-03-04 08:00:00	QQQ	ETF	339.4401	342.516	338.36	339.19	1325046.0
2022-03-04 09:00:00	QQQ	ETF	339.16	341.31	337.35	339.54	8069464.0
2022-03-04 10:00:00	QQQ	ETF	339.51	340.19	335.95	336.07	9810017.0
2022-03-04 11:00:00	QQQ	ETF	336.08	337.11	334.92	336.21	7537976.0
2022-03-04 12:00:00	QQQ	ETF	336.22	338.68	335.6632	338.13	6856921.0
2022-03-04 13:00:00	QQQ	ETF	338.2	339.79	336.57	336.73	5893157.0
2022-03-04 14:00:00	QQQ	ETF	336.74	337.68	335.12	335.24	6161813.0
2022-03-04 15:00:00	QQQ	ETF	335.23	337.8	335.16	337.35	11025460.0
2022-03-04 16:00:00	QQQ	ETF	337.36	337.42	336.0	336.53	2103851.0
2022-03-04 17:00:00	QQQ	ETF	336.52	337.0	336.44	336.8	91536.0
2022-03-04 18:00:00	QQQ	ETF	336.75	336.79	336.31	336.4	12938.0
2022-03-04 19:00:00	QQQ	ETF	336.4	336.5	336.2	336.28	43673.0
2022-03-04 04:00:00	IWM	ETF	199.86	200.23	199.05	199.42	32307.0
2022-03-04 05:00:00	IWM	ETF	199.46	200.2	199.23	199.77	63367.0
2022-03-04 06:00:00	IWM	ETF	199.59	199.8	199.06	199.54	46355.0
2022-03-04 07:00:00	IWM	ETF	199.66	199.9	198.91	199.63	113648.0
2022-03-04 08:00:00	IWM	ETF	199.2101	201.0	199.2101	199.55	171985.0
2022-03-04 09:00:00	IWM	ETF	199.66	200.86	198.66	199.87	3369777.0
2022-03-04 10:00:00	IWM	ETF	199.86	200.17	197.67	197.72	3761844.0
2022-03-04 11:00:00	IWM	ETF	197.73	198.4	196.98	197.55	3352579.0
2022-03-04 12:00:00	IWM	ETF	197.56	198.87	197.0	198.535	2596288.0
2022-03-04 13:00:00	IWM	ETF	198.57	199.5	198.05	198.1	2105073.0
2022-03-04 14:00:00	IWM	ETF	198.11	198.83	197.31	197.35	1954618.0
2022-03-04 15:00:00	IWM	ETF	197.34	198.81	197.31	198.74	4975314.0
2022-03-04 16:00:00	IWM	ETF	198.66	198.72	198.08	198.55	1781137.0
2022-03-04 17:00:00	IWM	ETF	198.31	198.66	198.0	198.33	181910.0
2022-03-04 18:00:00	IWM	ETF	198.28	198.33	197.58	197.58	18643.0
2022-03-04 19:00:00	IWM	ETF	197.9	198.3	197.71	198.25	16300.0
2022-03-04 04:00:00	DIA	ETF	335.92	335.99	335.03	335.16	2451.0
2022-03-04 05:00:00	DIA	ETF	335.63	336.05	335.63	336.05	1250.0

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

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