PREVIEW / etf_1hour / 2021-08-23

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-08-23.parquet
  size:    430 KB
  rows:    14,886

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
2021-08-23 04:00:00	SPY	ETF	444.02	444.69	444.02	444.69	24115.0
2021-08-23 05:00:00	SPY	ETF	444.54	444.86	444.54	444.83	11420.0
2021-08-23 06:00:00	SPY	ETF	444.89	444.92	444.73	444.9	10775.0
2021-08-23 07:00:00	SPY	ETF	444.88	445.13	444.7	444.9	139893.0
2021-08-23 08:00:00	SPY	ETF	444.95	445.06	443.582	444.91	174954.0
2021-08-23 09:00:00	SPY	ETF	444.931	446.38	444.75	446.335	6235609.0
2021-08-23 10:00:00	SPY	ETF	446.35	447.319	446.17	447.25	6419031.0
2021-08-23 11:00:00	SPY	ETF	447.245	447.86	447.235	447.74	3903741.0
2021-08-23 12:00:00	SPY	ETF	447.75	448.165	447.67	448.15	4041706.0
2021-08-23 13:00:00	SPY	ETF	448.16	448.23	447.43	447.72	3808277.0
2021-08-23 14:00:00	SPY	ETF	447.72	448.11	447.64	448.04	3490968.0
2021-08-23 15:00:00	SPY	ETF	448.03	448.07	447.13	447.25	10319185.0
2021-08-23 16:00:00	SPY	ETF	447.25	447.79	447.15	447.77	1951282.0
2021-08-23 17:00:00	SPY	ETF	447.7	447.8	447.67	447.75	31609.0
2021-08-23 18:00:00	SPY	ETF	447.74	447.99	447.26	447.88	53240.0
2021-08-23 19:00:00	SPY	ETF	447.87	448.02	447.86	448.0	30718.0
2021-08-23 04:00:00	QQQ	ETF	368.2	369.12	368.2	369.05	113761.0
2021-08-23 05:00:00	QQQ	ETF	369.09	369.11	368.72	368.88	39773.0
2021-08-23 06:00:00	QQQ	ETF	368.84	368.9	368.72	368.88	34459.0
2021-08-23 07:00:00	QQQ	ETF	368.87	369.11	368.79	368.94	255662.0
2021-08-23 08:00:00	QQQ	ETF	368.91	369.49	368.005	368.76	218260.0
2021-08-23 09:00:00	QQQ	ETF	368.76	370.81	368.69	370.68	4071612.0
2021-08-23 10:00:00	QQQ	ETF	370.69	372.36	370.435	372.325	4705776.0
2021-08-23 11:00:00	QQQ	ETF	372.32	373.35	372.07	373.2812	3303268.0
2021-08-23 12:00:00	QQQ	ETF	373.28	373.61	372.9901	373.58	2604433.0
2021-08-23 13:00:00	QQQ	ETF	373.59	373.69	373.02	373.36	2360810.0
2021-08-23 14:00:00	QQQ	ETF	373.3799	373.935	373.375	373.835	1697159.0
2021-08-23 15:00:00	QQQ	ETF	373.83	373.87	373.075	373.2	4603746.0
2021-08-23 16:00:00	QQQ	ETF	373.2	373.72	373.1	373.68	1795387.0
2021-08-23 17:00:00	QQQ	ETF	373.57	373.89	373.57	373.75	30716.0
2021-08-23 18:00:00	QQQ	ETF	373.75	373.82	373.57	373.68	28386.0
2021-08-23 19:00:00	QQQ	ETF	373.69	373.77	373.69	373.77	23939.0
2021-08-23 04:00:00	IWM	ETF	217.05	217.34	216.95	217.2	23271.0
2021-08-23 05:00:00	IWM	ETF	217.22	217.63	217.22	217.63	13378.0
2021-08-23 06:00:00	IWM	ETF	217.77	217.83	217.49	217.75	30782.0
2021-08-23 07:00:00	IWM	ETF	217.68	217.89	217.49	217.68	46069.0
2021-08-23 08:00:00	IWM	ETF	217.78	217.85	217.47	217.54	116475.0
2021-08-23 09:00:00	IWM	ETF	217.55	219.115	217.32	218.69	4728949.0
2021-08-23 10:00:00	IWM	ETF	218.68	218.96	217.89	218.58	3691285.0
2021-08-23 11:00:00	IWM	ETF	218.585	218.8	218.18	218.74	2302389.0
2021-08-23 12:00:00	IWM	ETF	218.73	219.1	218.54	219.02	2008705.0
2021-08-23 13:00:00	IWM	ETF	219.05	219.41	218.9	219.18	1977875.0
2021-08-23 14:00:00	IWM	ETF	219.19	219.59	219.15	219.565	1240415.0
2021-08-23 15:00:00	IWM	ETF	219.565	219.94	219.23	219.63	5435472.0
2021-08-23 16:00:00	IWM	ETF	219.62	219.86	219.49	219.62	931500.0
2021-08-23 17:00:00	IWM	ETF	219.87	219.89	219.69	219.89	1906.0
2021-08-23 18:00:00	IWM	ETF	219.86	220.08	219.86	220.02	11240.0
2021-08-23 19:00:00	IWM	ETF	220.01	220.06	219.97	220.06	14737.0
2021-08-23 04:00:00	DIA	ETF	351.96	352.16	351.95	352.16	746.0
2021-08-23 05:00:00	DIA	ETF	352.37	352.62	352.37	352.62	4400.0

> showing 50 of 14,886 rows — these rows as CSV

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