PREVIEW / etf_1hour / 2021-07-15

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-07-15.parquet
  size:    411 KB
  rows:    14,406

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-07-15 04:00:00	SPY	ETF	435.8	436.4	435.28	436.3	24756.0
2021-07-15 05:00:00	SPY	ETF	436.32	436.32	435.69	436.0	18922.0
2021-07-15 06:00:00	SPY	ETF	435.9	435.93	434.63	434.86	56748.0
2021-07-15 07:00:00	SPY	ETF	434.88	435.18	434.06	434.82	286785.0
2021-07-15 08:00:00	SPY	ETF	434.9906	435.5	434.09	434.67	517711.0
2021-07-15 09:00:00	SPY	ETF	434.6596	435.42	433.98	435.35	5687554.0
2021-07-15 10:00:00	SPY	ETF	435.36	435.53	434.18	434.78	7233132.0
2021-07-15 11:00:00	SPY	ETF	434.78	435.36	434.2	434.7369	4782838.0
2021-07-15 12:00:00	SPY	ETF	434.73	434.96	434.01	434.56	4208889.0
2021-07-15 13:00:00	SPY	ETF	434.5625	434.6	432.72	432.79	6964319.0
2021-07-15 14:00:00	SPY	ETF	432.77	434.2099	432.74	434.2099	5883521.0
2021-07-15 15:00:00	SPY	ETF	434.2	434.81	434.02	434.73	9196984.0
2021-07-15 16:00:00	SPY	ETF	434.73	434.85	434.14	434.27	2089937.0
2021-07-15 17:00:00	SPY	ETF	434.27	434.42	434.05	434.11	102869.0
2021-07-15 18:00:00	SPY	ETF	434.17	434.26	434.0	434.13	57249.0
2021-07-15 19:00:00	SPY	ETF	434.19	434.251	433.72	433.77	99492.0
2021-07-15 04:00:00	QQQ	ETF	363.71	364.66	363.67	364.52	50669.0
2021-07-15 05:00:00	QQQ	ETF	364.55	364.6	364.14	364.32	47548.0
2021-07-15 06:00:00	QQQ	ETF	364.28	364.29	363.14	363.47	102480.0
2021-07-15 07:00:00	QQQ	ETF	363.34	363.51	362.36	363.0	241421.0
2021-07-15 08:00:00	QQQ	ETF	363.51	363.82	362.41	362.89	291263.0
2021-07-15 09:00:00	QQQ	ETF	362.89	363.26	360.61	362.98	4480130.0
2021-07-15 10:00:00	QQQ	ETF	362.98	363.05	359.61	360.25	6200299.0
2021-07-15 11:00:00	QQQ	ETF	360.2	361.41	359.57	360.11	3967436.0
2021-07-15 12:00:00	QQQ	ETF	360.11	360.66	359.07	360.27	5588155.0
2021-07-15 13:00:00	QQQ	ETF	360.269	360.3699	358.46	358.53	5487024.0
2021-07-15 14:00:00	QQQ	ETF	358.51	360.24	358.49	360.14	4515026.0
2021-07-15 15:00:00	QQQ	ETF	360.15	360.71	359.58	360.42	6702273.0
2021-07-15 16:00:00	QQQ	ETF	360.44	360.52	359.89	360.09	1478810.0
2021-07-15 17:00:00	QQQ	ETF	360.06	360.24	360.01	360.08	20182.0
2021-07-15 18:00:00	QQQ	ETF	360.08	360.19	359.9	360.08	56193.0
2021-07-15 19:00:00	QQQ	ETF	360.13	360.17	359.551	359.61	27279.0
2021-07-15 04:00:00	IWM	ETF	217.49	218.0	217.22	217.43	43258.0
2021-07-15 05:00:00	IWM	ETF	217.34	217.56	217.0	217.56	40016.0
2021-07-15 06:00:00	IWM	ETF	217.59	217.59	216.4	216.8	43899.0
2021-07-15 07:00:00	IWM	ETF	216.85	217.55	216.37	217.36	255891.0
2021-07-15 08:00:00	IWM	ETF	216.7899	218.57	216.3601	217.24	195631.0
2021-07-15 09:00:00	IWM	ETF	217.19	218.64	216.17	218.58	6095356.0
2021-07-15 10:00:00	IWM	ETF	218.55	219.0598	216.82	217.99	5642956.0
2021-07-15 11:00:00	IWM	ETF	218.0	218.69	217.22	218.5	3198871.0
2021-07-15 12:00:00	IWM	ETF	218.51	218.6299	217.87	217.94	2366100.0
2021-07-15 13:00:00	IWM	ETF	217.93	218.005	214.95	215.0	5413020.0
2021-07-15 14:00:00	IWM	ETF	215.0	216.63	214.94	216.595	4415629.0
2021-07-15 15:00:00	IWM	ETF	216.6	217.72	215.875	217.68	7125109.0
2021-07-15 16:00:00	IWM	ETF	217.63	217.7	216.5	217.52	2247576.0
2021-07-15 17:00:00	IWM	ETF	217.58	217.63	217.21	217.24	125193.0
2021-07-15 18:00:00	IWM	ETF	217.36	217.63	217.09	217.32	96640.0
2021-07-15 19:00:00	IWM	ETF	217.33	217.46	216.96	217.0	34317.0
2021-07-15 04:00:00	DIA	ETF	348.59	348.63	348.59	348.63	200.0
2021-07-15 05:00:00	DIA	ETF	348.59	348.6	348.26	348.6	2800.0

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

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