PREVIEW / etf_1hour / 2020-08-03

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-08-03.parquet
  size:    374 KB
  rows:    12,808

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
2020-08-03 04:00:00	SPY	ETF	326.46	326.82	325.72	326.08	57676.0
2020-08-03 05:00:00	SPY	ETF	325.95	326.55	325.95	326.55	43947.0
2020-08-03 06:00:00	SPY	ETF	326.69	328.09	326.69	328.02	148265.0
2020-08-03 07:00:00	SPY	ETF	328.03	328.42	327.86	328.42	329497.0
2020-08-03 08:00:00	SPY	ETF	328.44	328.63	325.9	328.46	336089.0
2020-08-03 09:00:00	SPY	ETF	328.46	328.56	327.73	328.35	5626079.0
2020-08-03 10:00:00	SPY	ETF	328.345	329.28	327.91	328.2199	8308843.0
2020-08-03 11:00:00	SPY	ETF	328.23	329.38	328.15	329.06	5826660.0
2020-08-03 12:00:00	SPY	ETF	329.06	329.18	328.73	328.9	3541759.0
2020-08-03 13:00:00	SPY	ETF	328.91	329.27	328.8	329.08	3062308.0
2020-08-03 14:00:00	SPY	ETF	329.08	329.62	328.9	329.47	5530049.0
2020-08-03 15:00:00	SPY	ETF	329.48	329.56	328.39	328.76	13200867.0
2020-08-03 16:00:00	SPY	ETF	328.75	329.06	328.38	328.94	4471065.0
2020-08-03 17:00:00	SPY	ETF	328.96	329.09	328.75	329.09	1071289.0
2020-08-03 18:00:00	SPY	ETF	329.06	329.09	328.61	328.82	75195.0
2020-08-03 19:00:00	SPY	ETF	328.77	329.05	328.69	328.83	40782.0
2020-08-03 04:00:00	QQQ	ETF	266.7	267.17	266.51	266.8	59098.0
2020-08-03 05:00:00	QQQ	ETF	266.92	267.03	266.6	267.01	19629.0
2020-08-03 06:00:00	QQQ	ETF	266.91	268.13	266.91	268.12	50812.0
2020-08-03 07:00:00	QQQ	ETF	268.09	268.45	267.93	268.18	285957.0
2020-08-03 08:00:00	QQQ	ETF	268.2	268.38	266.0	268.11	268373.0
2020-08-03 09:00:00	QQQ	ETF	268.11	269.54	267.65	269.15	4399123.0
2020-08-03 10:00:00	QQQ	ETF	269.15	269.99	268.1503	268.6	4754647.0
2020-08-03 11:00:00	QQQ	ETF	268.6	269.645	268.4401	269.645	2618693.0
2020-08-03 12:00:00	QQQ	ETF	269.65	269.728	269.09	269.39	1755309.0
2020-08-03 13:00:00	QQQ	ETF	269.381	269.77	268.905	269.27	1930130.0
2020-08-03 14:00:00	QQQ	ETF	269.27	270.15	268.97	269.86	2828811.0
2020-08-03 15:00:00	QQQ	ETF	269.865	270.0	268.78	269.31	5728326.0
2020-08-03 16:00:00	QQQ	ETF	269.31	270.0	269.0	269.59	1088215.0
2020-08-03 17:00:00	QQQ	ETF	269.62	269.69	269.41	269.59	15975.0
2020-08-03 18:00:00	QQQ	ETF	269.59	269.59	269.22	269.32	45679.0
2020-08-03 19:00:00	QQQ	ETF	269.33	269.42	269.1	269.27	70656.0
2020-08-03 04:00:00	IWM	ETF	147.0	147.17	146.44	146.65	13193.0
2020-08-03 05:00:00	IWM	ETF	146.5	146.98	146.5	146.98	1720.0
2020-08-03 06:00:00	IWM	ETF	146.9	148.15	146.9	148.02	11022.0
2020-08-03 07:00:00	IWM	ETF	148.06	148.4	147.81	148.4	165849.0
2020-08-03 08:00:00	IWM	ETF	148.4	148.59	146.5	148.41	751796.0
2020-08-03 09:00:00	IWM	ETF	148.28	148.39	147.22	148.075	2335913.0
2020-08-03 10:00:00	IWM	ETF	148.07	148.58	147.62	147.93	2486899.0
2020-08-03 11:00:00	IWM	ETF	147.945	149.59	147.9	149.25	2063760.0
2020-08-03 12:00:00	IWM	ETF	149.24	149.42	148.91	149.22	1247537.0
2020-08-03 13:00:00	IWM	ETF	149.2178	149.47	148.86	149.36	821412.0
2020-08-03 14:00:00	IWM	ETF	149.36	149.94	149.2	149.875	1077749.0
2020-08-03 15:00:00	IWM	ETF	149.87	149.97	149.48	149.81	4363297.0
2020-08-03 16:00:00	IWM	ETF	149.76	149.8	149.5	149.68	1123294.0
2020-08-03 17:00:00	IWM	ETF	149.74	149.74	149.61	149.72	3300.0
2020-08-03 18:00:00	IWM	ETF	149.73	149.74	149.51	149.62	8108.0
2020-08-03 19:00:00	IWM	ETF	149.61	149.89	149.61	149.76	24090.0
2020-08-03 04:00:00	DIA	ETF	263.72	263.99	263.52	263.6	5652.0
2020-08-03 05:00:00	DIA	ETF	263.66	264.0	263.62	263.99	1182.0

> showing 50 of 12,808 rows — these rows as CSV

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