PREVIEW / etf_1hour / 2022-02-18

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-02-18.parquet
  size:    450 KB
  rows:    16,107

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-18 04:00:00	SPY	ETF	439.44	439.68	437.8	439.51	25645.0
2022-02-18 05:00:00	SPY	ETF	439.51	439.55	439.15	439.19	20453.0
2022-02-18 06:00:00	SPY	ETF	439.09	439.51	438.39	438.82	70407.0
2022-02-18 07:00:00	SPY	ETF	438.86	439.46	438.4	439.36	281902.0
2022-02-18 08:00:00	SPY	ETF	439.33	440.0	435.67	437.14	1361687.0
2022-02-18 09:00:00	SPY	ETF	437.16	438.66	435.91	438.36	9093717.0
2022-02-18 10:00:00	SPY	ETF	438.39	438.66	435.21	435.47	10231832.0
2022-02-18 11:00:00	SPY	ETF	435.48	435.6	432.88	433.21	10667672.0
2022-02-18 12:00:00	SPY	ETF	433.19	435.04	432.41	432.48	8705946.0
2022-02-18 13:00:00	SPY	ETF	432.49	434.36	431.82	433.95	8370321.0
2022-02-18 14:00:00	SPY	ETF	433.94	437.08	433.705	436.6648	12195164.0
2022-02-18 15:00:00	SPY	ETF	436.64	437.4095	432.8	434.27	22853691.0
2022-02-18 16:00:00	SPY	ETF	434.26	435.28	434.01	434.1	5738904.0
2022-02-18 17:00:00	SPY	ETF	434.12	434.23	432.7	432.95	364171.0
2022-02-18 18:00:00	SPY	ETF	433.0	433.27	432.1	432.43	97536.0
2022-02-18 19:00:00	SPY	ETF	432.46	432.5	432.12	432.22	99220.0
2022-02-18 04:00:00	QQQ	ETF	347.57	348.0	346.97	347.95	277884.0
2022-02-18 05:00:00	QQQ	ETF	347.99	348.17	347.49	347.76	56735.0
2022-02-18 06:00:00	QQQ	ETF	347.8	348.1	346.98	347.36	71729.0
2022-02-18 07:00:00	QQQ	ETF	347.43	347.91	347.2	347.82	351406.0
2022-02-18 08:00:00	QQQ	ETF	347.5	348.04	344.6	345.83	892257.0
2022-02-18 09:00:00	QQQ	ETF	345.81	346.81	343.57	345.92	7821439.0
2022-02-18 10:00:00	QQQ	ETF	345.92	346.1799	342.24	342.65	8166628.0
2022-02-18 11:00:00	QQQ	ETF	342.63	342.98	340.51	340.83	8061372.0
2022-02-18 12:00:00	QQQ	ETF	340.81	342.81	339.97	340.06	5963622.0
2022-02-18 13:00:00	QQQ	ETF	340.07	341.65	339.14	341.15	5752549.0
2022-02-18 14:00:00	QQQ	ETF	341.12	344.67	340.97	344.0	8953867.0
2022-02-18 15:00:00	QQQ	ETF	344.0	344.93	340.5064	341.58	12450365.0
2022-02-18 16:00:00	QQQ	ETF	341.59	342.37	341.1	341.44	2515483.0
2022-02-18 17:00:00	QQQ	ETF	341.43	341.45	339.94	340.0	181893.0
2022-02-18 18:00:00	QQQ	ETF	339.95	340.02	339.07	339.39	82446.0
2022-02-18 19:00:00	QQQ	ETF	339.4	339.4	339.15	339.35	83400.0
2022-02-18 04:00:00	IWM	ETF	203.0	203.03	202.39	202.95	28551.0
2022-02-18 05:00:00	IWM	ETF	202.87	202.97	202.48	202.48	13153.0
2022-02-18 06:00:00	IWM	ETF	202.52	202.76	202.2	202.4	29476.0
2022-02-18 07:00:00	IWM	ETF	202.39	202.62	202.24	202.6	131818.0
2022-02-18 08:00:00	IWM	ETF	202.9296	203.6	200.53	201.28	271196.0
2022-02-18 09:00:00	IWM	ETF	201.32	202.63	200.335	202.42	3623361.0
2022-02-18 10:00:00	IWM	ETF	202.44	202.72	200.22	200.31	3434421.0
2022-02-18 11:00:00	IWM	ETF	200.29	200.37	198.88	199.14	3865153.0
2022-02-18 12:00:00	IWM	ETF	199.15	200.3	198.96	199.27	2509389.0
2022-02-18 13:00:00	IWM	ETF	199.28	200.26	198.76	199.95	1827375.0
2022-02-18 14:00:00	IWM	ETF	199.995	201.4	199.69	200.75	2304944.0
2022-02-18 15:00:00	IWM	ETF	200.74	201.16	199.03	199.45	4954295.0
2022-02-18 16:00:00	IWM	ETF	199.47	200.03	199.31	199.44	1276018.0
2022-02-18 17:00:00	IWM	ETF	199.44	199.47	198.75	198.75	16472.0
2022-02-18 18:00:00	IWM	ETF	198.76	199.47	198.47	198.7	15054.0
2022-02-18 19:00:00	IWM	ETF	198.88	198.88	198.21	198.6	22721.0
2022-02-18 04:00:00	DIA	ETF	344.27	344.4	344.27	344.4	600.0
2022-02-18 05:00:00	DIA	ETF	344.46	344.46	344.2	344.25	1489.0

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

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