PREVIEW / etf_1hour / 2019-08-21

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-08-21.parquet
  size:    333 KB
  rows:    10,954

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
2019-08-21 04:00:00	SPY	ETF	291.3	291.94	291.3	291.87	21593.0
2019-08-21 05:00:00	SPY	ETF	291.84	291.97	291.71	291.76	22270.0
2019-08-21 06:00:00	SPY	ETF	291.64	291.92	291.64	291.7	58102.0
2019-08-21 07:00:00	SPY	ETF	291.72	291.84	291.6	291.7	187650.0
2019-08-21 08:00:00	SPY	ETF	291.73	292.33	290.79	292.31	1010636.0
2019-08-21 09:00:00	SPY	ETF	292.3	292.86	292.09	292.53	6583990.0
2019-08-21 10:00:00	SPY	ETF	292.54	292.62	291.96	292.3	5998948.0
2019-08-21 11:00:00	SPY	ETF	292.29	292.83	292.04	292.75	7226890.0
2019-08-21 12:00:00	SPY	ETF	292.74	292.79	292.35	292.59	3750419.0
2019-08-21 13:00:00	SPY	ETF	292.585	292.69	292.29	292.32	3674220.0
2019-08-21 14:00:00	SPY	ETF	292.31	292.68	291.72	292.0	6469684.0
2019-08-21 15:00:00	SPY	ETF	291.98	292.52	291.85	292.43	8847180.0
2019-08-21 16:00:00	SPY	ETF	292.41	293.15	292.33	293.11	4186195.0
2019-08-21 17:00:00	SPY	ETF	293.03	293.11	293.0	293.05	119502.0
2019-08-21 18:00:00	SPY	ETF	293.06	293.76	293.01	293.42	129692.0
2019-08-21 19:00:00	SPY	ETF	293.48	293.61	293.35	293.4	140294.0
2019-08-21 04:00:00	QQQ	ETF	188.06	188.55	188.06	188.45	31188.0
2019-08-21 05:00:00	QQQ	ETF	188.51	188.59	188.37	188.52	14566.0
2019-08-21 06:00:00	QQQ	ETF	188.43	188.53	188.28	188.34	23150.0
2019-08-21 07:00:00	QQQ	ETF	188.33	188.4	188.17	188.24	89831.0
2019-08-21 08:00:00	QQQ	ETF	188.27	188.55	186.97	188.55	268965.0
2019-08-21 09:00:00	QQQ	ETF	188.56	189.23	188.38	189.0	3723553.0
2019-08-21 10:00:00	QQQ	ETF	189.02	189.13	188.555	188.75	2537421.0
2019-08-21 11:00:00	QQQ	ETF	188.75	189.09	188.55	188.97	1734246.0
2019-08-21 12:00:00	QQQ	ETF	188.97	189.0	188.65	188.79	1069142.0
2019-08-21 13:00:00	QQQ	ETF	188.795	188.87	188.41	188.43	1149709.0
2019-08-21 14:00:00	QQQ	ETF	188.42	188.81	187.96	188.315	2837088.0
2019-08-21 15:00:00	QQQ	ETF	188.31	188.7	188.17	188.63	3208428.0
2019-08-21 16:00:00	QQQ	ETF	188.62	189.04	188.59	189.02	1138708.0
2019-08-21 17:00:00	QQQ	ETF	188.96	189.02	188.9	188.97	25864.0
2019-08-21 18:00:00	QQQ	ETF	188.98	189.58	188.84	189.35	337029.0
2019-08-21 19:00:00	QQQ	ETF	189.35	189.49	189.31	189.34	37880.0
2019-08-21 04:00:00	IWM	ETF	149.98	150.22	149.9	150.22	5600.0
2019-08-21 05:00:00	IWM	ETF	150.14	150.14	150.1	150.1	5200.0
2019-08-21 06:00:00	IWM	ETF	150.18	150.18	150.1	150.1	2500.0
2019-08-21 07:00:00	IWM	ETF	150.1	150.16	150.05	150.14	36200.0
2019-08-21 08:00:00	IWM	ETF	150.1201	150.48	149.42	150.48	90326.0
2019-08-21 09:00:00	IWM	ETF	150.53	150.75	149.79	150.49	2006154.0
2019-08-21 10:00:00	IWM	ETF	150.49	150.605	149.86	150.17	1780129.0
2019-08-21 11:00:00	IWM	ETF	150.16	150.59	150.05	150.45	1091843.0
2019-08-21 12:00:00	IWM	ETF	150.48	150.65	150.13	150.56	881924.0
2019-08-21 13:00:00	IWM	ETF	150.56	150.62	150.27	150.3	604123.0
2019-08-21 14:00:00	IWM	ETF	150.3	150.57	150.05	150.13	1458517.0
2019-08-21 15:00:00	IWM	ETF	150.13	150.42	150.06	150.36	2513429.0
2019-08-21 16:00:00	IWM	ETF	150.36	150.74	150.32	150.71	1380525.0
2019-08-21 17:00:00	IWM	ETF	150.69	150.69	150.59	150.69	8999.0
2019-08-21 18:00:00	IWM	ETF	150.66	151.08	150.64	150.92	347339.0
2019-08-21 19:00:00	IWM	ETF	150.92	151.04	150.88	150.9	12396.0
2019-08-21 05:00:00	DIA	ETF	260.94	261.07	260.94	261.07	6700.0
2019-08-21 06:00:00	DIA	ETF	261.0	261.0	261.0	261.0	800.0

> showing 50 of 10,954 rows — these rows as CSV

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