PREVIEW / etf_1hour / 2022-07-05

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-07-05.parquet
  size:    460 KB
  rows:    16,710

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-07-05 04:00:00	SPY	ETF	381.44	382.01	378.85	379.0	85464.0
2022-07-05 05:00:00	SPY	ETF	379.03	379.39	378.47	379.33	46515.0
2022-07-05 06:00:00	SPY	ETF	379.25	379.87	379.23	379.45	60399.0
2022-07-05 07:00:00	SPY	ETF	379.51	379.63	377.81	377.91	298861.0
2022-07-05 08:00:00	SPY	ETF	377.9	383.3	375.94	376.16	869600.0
2022-07-05 09:00:00	SPY	ETF	376.03	376.55	373.28	373.89	9763573.0
2022-07-05 10:00:00	SPY	ETF	373.83	376.28	372.9	374.12	10293441.0
2022-07-05 11:00:00	SPY	ETF	374.13	375.76	373.06	375.23	6545265.0
2022-07-05 12:00:00	SPY	ETF	375.25	377.1199	374.86	375.4001	5842435.0
2022-07-05 13:00:00	SPY	ETF	375.44	378.06	375.35	377.475	6066790.0
2022-07-05 14:00:00	SPY	ETF	377.49	380.48	377.22	379.8899	7933443.0
2022-07-05 15:00:00	SPY	ETF	379.89	381.98	379.28	381.95	14106752.0
2022-07-05 16:00:00	SPY	ETF	381.95	381.99	381.28	381.78	2626248.0
2022-07-05 17:00:00	SPY	ETF	381.74	381.9	381.74	381.9	60883.0
2022-07-05 18:00:00	SPY	ETF	381.9	382.6	381.7	381.86	257301.0
2022-07-05 19:00:00	SPY	ETF	381.87	382.07	380.83	380.95	121798.0
2022-07-05 04:00:00	QQQ	ETF	282.51	283.07	280.0	280.07	104958.0
2022-07-05 05:00:00	QQQ	ETF	280.16	280.39	279.64	280.36	119610.0
2022-07-05 06:00:00	QQQ	ETF	280.27	280.86	280.26	280.4	43935.0
2022-07-05 07:00:00	QQQ	ETF	280.52	280.67	279.02	279.08	310214.0
2022-07-05 08:00:00	QQQ	ETF	280.55	283.8	277.82	278.0001	840786.0
2022-07-05 09:00:00	QQQ	ETF	277.97	279.1	276.7501	278.25	8153678.0
2022-07-05 10:00:00	QQQ	ETF	278.19	282.11	277.17	280.166	8655205.0
2022-07-05 11:00:00	QQQ	ETF	280.16	281.59	278.69	281.165	4947092.0
2022-07-05 12:00:00	QQQ	ETF	281.17	283.02	280.551	281.46	5103094.0
2022-07-05 13:00:00	QQQ	ETF	281.48	284.37	281.4	283.695	5221473.0
2022-07-05 14:00:00	QQQ	ETF	283.7	286.3	283.23	285.67	5547079.0
2022-07-05 15:00:00	QQQ	ETF	285.675	287.08	285.08	287.02	8646728.0
2022-07-05 16:00:00	QQQ	ETF	287.04	287.08	286.6	287.0	1120061.0
2022-07-05 17:00:00	QQQ	ETF	287.0	287.07	286.95	287.05	531488.0
2022-07-05 18:00:00	QQQ	ETF	287.08	287.6	286.82	286.97	169031.0
2022-07-05 19:00:00	QQQ	ETF	287.05	287.15	286.05	286.31	190977.0
2022-07-05 04:00:00	IWM	ETF	171.45	171.73	170.19	170.29	54496.0
2022-07-05 05:00:00	IWM	ETF	170.28	170.48	170.04	170.4	20594.0
2022-07-05 06:00:00	IWM	ETF	170.37	170.65	170.3	170.3	24135.0
2022-07-05 07:00:00	IWM	ETF	170.42	170.48	169.64	169.65	128805.0
2022-07-05 08:00:00	IWM	ETF	170.43	172.35	168.78	168.91	116682.0
2022-07-05 09:00:00	IWM	ETF	168.88	169.08	166.8	167.14	3229087.0
2022-07-05 10:00:00	IWM	ETF	167.12	169.455	166.73	168.73	3066027.0
2022-07-05 11:00:00	IWM	ETF	168.71	169.62	168.11	169.42	1880329.0
2022-07-05 12:00:00	IWM	ETF	169.43	170.22	168.99	169.16	1936389.0
2022-07-05 13:00:00	IWM	ETF	169.2	170.67	169.15	170.31	1546915.0
2022-07-05 14:00:00	IWM	ETF	170.32	171.47	170.21	171.23	1610488.0
2022-07-05 15:00:00	IWM	ETF	171.24	172.85	170.95	172.85	3723117.0
2022-07-05 16:00:00	IWM	ETF	172.83	172.9	172.4	172.55	1732338.0
2022-07-05 17:00:00	IWM	ETF	172.37	172.91	172.37	172.76	111491.0
2022-07-05 18:00:00	IWM	ETF	172.89	173.0	172.58	172.64	88223.0
2022-07-05 19:00:00	IWM	ETF	172.63	172.76	172.15	172.26	43617.0
2022-07-05 04:00:00	DIA	ETF	311.2	311.2	309.27	309.27	3893.0
2022-07-05 05:00:00	DIA	ETF	309.38	309.47	308.82	309.47	4000.0

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

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