PREVIEW / etf_1hour / 2022-01-27

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-01-27.parquet
  size:    462 KB
  rows:    16,817

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-01-27 04:00:00	SPY	ETF	432.27	434.47	431.91	434.27	152224.0
2022-01-27 05:00:00	SPY	ETF	434.06	434.79	431.6	431.89	96456.0
2022-01-27 06:00:00	SPY	ETF	431.99	434.58	431.99	434.43	144606.0
2022-01-27 07:00:00	SPY	ETF	434.5	435.29	432.73	434.74	523309.0
2022-01-27 08:00:00	SPY	ETF	434.0499	437.14	426.85	437.07	1562550.0
2022-01-27 09:00:00	SPY	ETF	437.0	441.27	436.86	440.28	13739220.0
2022-01-27 10:00:00	SPY	ETF	440.3	441.59	435.88	439.19	13864379.0
2022-01-27 11:00:00	SPY	ETF	439.19	440.38	437.03	438.9	10326864.0
2022-01-27 12:00:00	SPY	ETF	438.92	439.03	432.54	434.0	14240361.0
2022-01-27 13:00:00	SPY	ETF	434.01	434.5	430.06	431.99	14962917.0
2022-01-27 14:00:00	SPY	ETF	431.98	434.27	429.85	431.11	14387590.0
2022-01-27 15:00:00	SPY	ETF	431.16	433.98	429.45	431.27	21637506.0
2022-01-27 16:00:00	SPY	ETF	431.28	440.0	430.77	433.82	4871742.0
2022-01-27 17:00:00	SPY	ETF	433.71	435.83	433.1	434.65	421024.0
2022-01-27 18:00:00	SPY	ETF	434.4	434.76	431.24	433.1	378734.0
2022-01-27 19:00:00	SPY	ETF	433.0	433.72	431.7	433.34	224920.0
2022-01-27 04:00:00	QQQ	ETF	344.37	346.9	343.0	346.44	254480.0
2022-01-27 05:00:00	QQQ	ETF	346.43	347.27	343.2	343.62	166636.0
2022-01-27 06:00:00	QQQ	ETF	343.64	346.67	343.64	346.59	228410.0
2022-01-27 07:00:00	QQQ	ETF	346.69	347.72	345.14	346.98	462469.0
2022-01-27 08:00:00	QQQ	ETF	346.42	348.75	338.6	348.56	873459.0
2022-01-27 09:00:00	QQQ	ETF	348.52	350.94	346.96	349.955	9199022.0
2022-01-27 10:00:00	QQQ	ETF	349.95	351.27	345.6899	348.5	12163299.0
2022-01-27 11:00:00	QQQ	ETF	348.49	349.86	346.88	348.48	8778762.0
2022-01-27 12:00:00	QQQ	ETF	348.4815	348.59	343.16	344.89	7717044.0
2022-01-27 13:00:00	QQQ	ETF	344.83	345.55	340.84	343.07	9035655.0
2022-01-27 14:00:00	QQQ	ETF	343.04	345.1	340.54	341.5729	8934220.0
2022-01-27 15:00:00	QQQ	ETF	341.59	343.95	340.05	341.02	11653148.0
2022-01-27 16:00:00	QQQ	ETF	341.04	344.1	340.05	344.0796	3005369.0
2022-01-27 17:00:00	QQQ	ETF	344.07	345.7	341.1	345.26	947126.0
2022-01-27 18:00:00	QQQ	ETF	345.38	345.74	341.1	343.71	385071.0
2022-01-27 19:00:00	QQQ	ETF	343.71	344.74	342.68	344.34	293493.0
2022-01-27 04:00:00	IWM	ETF	194.85	195.68	194.57	195.4	39161.0
2022-01-27 05:00:00	IWM	ETF	195.46	195.95	194.38	194.6	26839.0
2022-01-27 06:00:00	IWM	ETF	194.62	195.88	194.62	195.81	39520.0
2022-01-27 07:00:00	IWM	ETF	195.77	196.5	195.13	196.15	239562.0
2022-01-27 08:00:00	IWM	ETF	196.25	197.55	192.35	197.42	321349.0
2022-01-27 09:00:00	IWM	ETF	197.4	199.61	197.35	198.46	6247678.0
2022-01-27 10:00:00	IWM	ETF	198.47	198.82	195.08	196.21	7184657.0
2022-01-27 11:00:00	IWM	ETF	196.17	197.01	194.59	195.44	4840675.0
2022-01-27 12:00:00	IWM	ETF	195.45	195.5	192.82	193.36	5058527.0
2022-01-27 13:00:00	IWM	ETF	193.34	193.74	191.61	192.795	6438994.0
2022-01-27 14:00:00	IWM	ETF	192.77	193.81	191.18	191.75	4931250.0
2022-01-27 15:00:00	IWM	ETF	191.74	192.515	190.601	191.44	7817585.0
2022-01-27 16:00:00	IWM	ETF	191.43	192.2	191.33	192.2	1386808.0
2022-01-27 17:00:00	IWM	ETF	192.27	193.12	192.19	192.78	215020.0
2022-01-27 18:00:00	IWM	ETF	192.51	192.71	191.63	191.72	245694.0
2022-01-27 19:00:00	IWM	ETF	191.72	192.09	190.82	191.72	158985.0
2022-01-27 04:00:00	DIA	ETF	341.04	341.9	340.69	341.9	2217.0
2022-01-27 05:00:00	DIA	ETF	342.06	342.06	341.31	341.59	2300.0

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

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