PREVIEW / etf_1hour / 2022-02-28

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-02-28.parquet
  size:    465 KB
  rows:    16,819

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-28 04:00:00	SPY	ETF	430.1	432.21	429.64	430.83	254098.0
2022-02-28 05:00:00	SPY	ETF	431.0	432.05	429.91	432.05	173448.0
2022-02-28 06:00:00	SPY	ETF	432.0	432.9	431.0	431.47	218682.0
2022-02-28 07:00:00	SPY	ETF	431.54	434.0	431.42	432.24	1085161.0
2022-02-28 08:00:00	SPY	ETF	432.17	433.99	427.67	431.4	1227938.0
2022-02-28 09:00:00	SPY	ETF	431.4199	434.49	431.05	434.27	13564239.0
2022-02-28 10:00:00	SPY	ETF	434.29	436.26	431.85	435.95	16697206.0
2022-02-28 11:00:00	SPY	ETF	435.94	438.2	435.49	437.3414	13090517.0
2022-02-28 12:00:00	SPY	ETF	437.34	437.675	432.66	433.59	10099121.0
2022-02-28 13:00:00	SPY	ETF	433.6	435.46	432.87	434.58	9696740.0
2022-02-28 14:00:00	SPY	ETF	434.56	434.56	430.7	432.92	14316442.0
2022-02-28 15:00:00	SPY	ETF	432.92	436.94	431.61	436.67	25767598.0
2022-02-28 16:00:00	SPY	ETF	436.65	436.81	436.05	436.75	7159012.0
2022-02-28 17:00:00	SPY	ETF	436.75	436.75	436.31	436.42	101582.0
2022-02-28 18:00:00	SPY	ETF	436.42	437.82	436.42	437.45	162001.0
2022-02-28 19:00:00	SPY	ETF	437.63	437.63	435.99	436.59	130131.0
2022-02-28 04:00:00	QQQ	ETF	341.27	342.55	340.0	341.0	289852.0
2022-02-28 05:00:00	QQQ	ETF	341.06	341.68	340.2	341.45	192584.0
2022-02-28 06:00:00	QQQ	ETF	341.47	342.25	340.59	341.14	138671.0
2022-02-28 07:00:00	QQQ	ETF	341.26	343.16	341.24	341.9	513821.0
2022-02-28 08:00:00	QQQ	ETF	341.5399	346.029	337.21	341.48	640695.0
2022-02-28 09:00:00	QQQ	ETF	341.44	345.03	341.25	344.98	8805761.0
2022-02-28 10:00:00	QQQ	ETF	344.94	347.17	342.24	346.72	9398410.0
2022-02-28 11:00:00	QQQ	ETF	346.69	348.54	346.03	347.6851	6578790.0
2022-02-28 12:00:00	QQQ	ETF	347.67	348.05	343.07	344.09	6742888.0
2022-02-28 13:00:00	QQQ	ETF	344.08	345.855	343.35	344.85	6040061.0
2022-02-28 14:00:00	QQQ	ETF	344.81	344.81	341.32	343.36	7352317.0
2022-02-28 15:00:00	QQQ	ETF	343.36	347.28	342.01	347.15	11689682.0
2022-02-28 16:00:00	QQQ	ETF	347.14	347.14	346.44	346.72	2178341.0
2022-02-28 17:00:00	QQQ	ETF	346.62	346.85	346.39	346.59	62092.0
2022-02-28 18:00:00	QQQ	ETF	346.64	347.96	346.47	347.71	179669.0
2022-02-28 19:00:00	QQQ	ETF	347.77	347.77	346.02	346.5	134679.0
2022-02-28 04:00:00	IWM	ETF	198.14	199.42	198.08	198.86	60910.0
2022-02-28 05:00:00	IWM	ETF	198.72	199.68	198.17	199.67	50697.0
2022-02-28 06:00:00	IWM	ETF	199.7	200.47	199.45	200.13	70029.0
2022-02-28 07:00:00	IWM	ETF	200.13	201.4	199.73	200.17	239367.0
2022-02-28 08:00:00	IWM	ETF	200.6	201.08	198.04	199.96	217277.0
2022-02-28 09:00:00	IWM	ETF	199.8	202.55	199.78	202.53	3482192.0
2022-02-28 10:00:00	IWM	ETF	202.52	203.74	201.33	203.58	4327614.0
2022-02-28 11:00:00	IWM	ETF	203.6	204.6	203.21	204.19	2776009.0
2022-02-28 12:00:00	IWM	ETF	204.16	204.28	201.375	202.13	2984280.0
2022-02-28 13:00:00	IWM	ETF	202.12	203.16	201.87	202.78	1998972.0
2022-02-28 14:00:00	IWM	ETF	202.78	202.78	200.96	202.44	2912009.0
2022-02-28 15:00:00	IWM	ETF	202.42	203.54	201.57	203.07	5271393.0
2022-02-28 16:00:00	IWM	ETF	203.32	203.53	203.06	203.34	2920217.0
2022-02-28 17:00:00	IWM	ETF	203.48	203.48	203.16	203.34	15316.0
2022-02-28 18:00:00	IWM	ETF	203.27	204.1	203.21	203.89	28500.0
2022-02-28 19:00:00	IWM	ETF	203.91	203.99	203.19	203.42	61815.0
2022-02-28 04:00:00	DIA	ETF	335.97	336.91	335.69	335.99	12510.0
2022-02-28 05:00:00	DIA	ETF	336.39	336.62	335.49	336.57	5720.0

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

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