PREVIEW / etf_1hour / 2022-04-20

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-04-20.parquet
  size:    455 KB
  rows:    16,507

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-04-20 04:00:00	SPY	ETF	443.34	443.9	442.72	443.8	104607.0
2022-04-20 05:00:00	SPY	ETF	443.95	445.16	443.85	445.12	66342.0
2022-04-20 06:00:00	SPY	ETF	445.06	445.62	444.8	445.48	47177.0
2022-04-20 07:00:00	SPY	ETF	445.33	446.93	445.0	446.87	288820.0
2022-04-20 08:00:00	SPY	ETF	446.04	447.17	443.0	447.16	559314.0
2022-04-20 09:00:00	SPY	ETF	447.14	447.57	444.41	445.02	8295887.0
2022-04-20 10:00:00	SPY	ETF	445.0089	447.25	444.37	446.93	8620179.0
2022-04-20 11:00:00	SPY	ETF	446.93	446.97	445.06	446.03	5604706.0
2022-04-20 12:00:00	SPY	ETF	446.02	446.68	444.795	446.2799	5198228.0
2022-04-20 13:00:00	SPY	ETF	446.26	447.19	445.88	446.61	5004931.0
2022-04-20 14:00:00	SPY	ETF	446.6	446.89	443.48	444.01	6249022.0
2022-04-20 15:00:00	SPY	ETF	444.01	446.39	443.89	444.68	12177697.0
2022-04-20 16:00:00	SPY	ETF	444.66	446.16	444.53	446.0	2852094.0
2022-04-20 17:00:00	SPY	ETF	445.94	446.11	445.75	445.96	81242.0
2022-04-20 18:00:00	SPY	ETF	445.96	446.44	445.89	445.98	173598.0
2022-04-20 19:00:00	SPY	ETF	446.0	446.4	445.9	446.19	71037.0
2022-04-20 04:00:00	QQQ	ETF	343.52	344.66	343.04	344.58	186066.0
2022-04-20 05:00:00	QQQ	ETF	344.66	346.19	344.5	346.02	245134.0
2022-04-20 06:00:00	QQQ	ETF	345.91	346.2	345.43	345.85	153940.0
2022-04-20 07:00:00	QQQ	ETF	345.85	348.21	345.49	348.05	573864.0
2022-04-20 08:00:00	QQQ	ETF	345.5701	348.16	342.51	348.06	1097499.0
2022-04-20 09:00:00	QQQ	ETF	348.06	348.08	342.56	343.0899	8528376.0
2022-04-20 10:00:00	QQQ	ETF	343.07	344.58	341.9	344.12	10274550.0
2022-04-20 11:00:00	QQQ	ETF	344.11	344.19	341.53	342.0899	6775559.0
2022-04-20 12:00:00	QQQ	ETF	342.07	342.75	340.5007	342.305	5245624.0
2022-04-20 13:00:00	QQQ	ETF	342.27	343.79	341.91	342.94	4549185.0
2022-04-20 14:00:00	QQQ	ETF	342.9	343.2199	339.96	340.69	4674670.0
2022-04-20 15:00:00	QQQ	ETF	340.63	342.83	340.58	341.05	10669144.0
2022-04-20 16:00:00	QQQ	ETF	341.035	343.2	340.82	342.65	2298304.0
2022-04-20 17:00:00	QQQ	ETF	342.77	343.1	341.21	342.74	260728.0
2022-04-20 18:00:00	QQQ	ETF	342.65	343.16	342.5	342.72	265791.0
2022-04-20 19:00:00	QQQ	ETF	342.72	343.1501	342.62	343.05	237915.0
2022-04-20 04:00:00	IWM	ETF	201.25	201.65	201.16	201.65	57783.0
2022-04-20 05:00:00	IWM	ETF	201.62	202.56	201.62	202.32	52836.0
2022-04-20 06:00:00	IWM	ETF	202.17	202.61	202.06	202.57	12242.0
2022-04-20 07:00:00	IWM	ETF	202.57	203.09	202.3	203.09	46928.0
2022-04-20 08:00:00	IWM	ETF	202.38	203.28	202.36	203.22	72756.0
2022-04-20 09:00:00	IWM	ETF	203.17	203.75	201.98	202.28	3628658.0
2022-04-20 10:00:00	IWM	ETF	202.28	203.68	201.86	203.56	2978102.0
2022-04-20 11:00:00	IWM	ETF	203.55	203.65	202.52	203.3	1514786.0
2022-04-20 12:00:00	IWM	ETF	203.3	203.57	202.72	203.42	1081089.0
2022-04-20 13:00:00	IWM	ETF	203.43	203.87	203.25	203.55	1211845.0
2022-04-20 14:00:00	IWM	ETF	203.55	203.74	202.06	202.31	1701402.0
2022-04-20 15:00:00	IWM	ETF	202.3	203.28	202.27	202.34	3229051.0
2022-04-20 16:00:00	IWM	ETF	202.33	202.92	202.22	202.83	742204.0
2022-04-20 17:00:00	IWM	ETF	202.6	202.7	202.33	202.6	96243.0
2022-04-20 18:00:00	IWM	ETF	202.59	203.03	202.59	202.78	47289.0
2022-04-20 19:00:00	IWM	ETF	202.81	203.1	202.81	202.92	15275.0
2022-04-20 04:00:00	DIA	ETF	348.62	348.66	348.45	348.66	1419.0
2022-04-20 05:00:00	DIA	ETF	348.92	349.23	348.92	349.23	2219.0

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

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