PREVIEW / etf_1hour / 2019-09-04

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-09-04.parquet
  size:    337 KB
  rows:    11,039

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-09-04 04:00:00	SPY	ETF	293.51	293.72	293.24	293.46	29361.0
2019-09-04 05:00:00	SPY	ETF	293.47	293.6	293.1	293.13	20394.0
2019-09-04 06:00:00	SPY	ETF	293.07	293.2	292.83	293.0	41604.0
2019-09-04 07:00:00	SPY	ETF	292.98	293.34	292.88	293.24	478839.0
2019-09-04 08:00:00	SPY	ETF	293.1799	293.4799	291.59	293.35	446001.0
2019-09-04 09:00:00	SPY	ETF	293.3	293.48	292.8027	292.95	7174391.0
2019-09-04 10:00:00	SPY	ETF	292.9415	293.15	292.31	292.85	5678910.0
2019-09-04 11:00:00	SPY	ETF	292.86	293.51	292.68	293.45	5039739.0
2019-09-04 12:00:00	SPY	ETF	293.44	293.6	293.2	293.53	4826198.0
2019-09-04 13:00:00	SPY	ETF	293.52	293.6	293.13	293.195	3021917.0
2019-09-04 14:00:00	SPY	ETF	293.2	293.69	293.05	293.56	3337605.0
2019-09-04 15:00:00	SPY	ETF	293.56	294.055	293.56	293.97	11626345.0
2019-09-04 16:00:00	SPY	ETF	293.98	294.12	293.88	293.96	3314925.0
2019-09-04 17:00:00	SPY	ETF	293.95	294.05	293.84	293.9	431698.0
2019-09-04 18:00:00	SPY	ETF	293.93	294.1	293.84	293.99	168254.0
2019-09-04 19:00:00	SPY	ETF	294.04	294.04	293.87	294.0	17230.0
2019-09-04 04:00:00	QQQ	ETF	188.28	188.5	188.12	188.19	45364.0
2019-09-04 05:00:00	QQQ	ETF	188.26	188.38	187.9	187.93	21168.0
2019-09-04 06:00:00	QQQ	ETF	187.8	187.86	187.53	187.6	31483.0
2019-09-04 07:00:00	QQQ	ETF	187.6	187.84	187.45	187.75	110358.0
2019-09-04 08:00:00	QQQ	ETF	187.55	188.48	186.75	187.6	261643.0
2019-09-04 09:00:00	QQQ	ETF	187.6	187.895	187.3	187.44	3597616.0
2019-09-04 10:00:00	QQQ	ETF	187.44	187.61	186.9	187.33	2752243.0
2019-09-04 11:00:00	QQQ	ETF	187.34	187.84	187.29	187.785	2257106.0
2019-09-04 12:00:00	QQQ	ETF	187.78	188.14	187.53	188.08	1823201.0
2019-09-04 13:00:00	QQQ	ETF	188.08	188.23	187.86	187.9	1357860.0
2019-09-04 14:00:00	QQQ	ETF	187.9	188.095	187.78	188.02	1035669.0
2019-09-04 15:00:00	QQQ	ETF	188.04	188.49	188.03	188.34	5027346.0
2019-09-04 16:00:00	QQQ	ETF	188.34	188.43	188.21	188.31	1224487.0
2019-09-04 17:00:00	QQQ	ETF	188.25	188.35	188.25	188.26	22105.0
2019-09-04 18:00:00	QQQ	ETF	188.32	188.38	188.22	188.36	52350.0
2019-09-04 19:00:00	QQQ	ETF	188.36	188.38	188.25	188.33	44120.0
2019-09-04 04:00:00	IWM	ETF	148.08	148.2	147.92	147.98	18323.0
2019-09-04 05:00:00	IWM	ETF	147.97	148.01	147.8	147.8	8200.0
2019-09-04 06:00:00	IWM	ETF	147.79	147.79	147.65	147.69	6700.0
2019-09-04 07:00:00	IWM	ETF	147.69	147.94	147.68	147.92	20357.0
2019-09-04 08:00:00	IWM	ETF	147.76	148.1	147.72	147.99	50821.0
2019-09-04 09:00:00	IWM	ETF	147.95	148.36	147.76	147.99	2987020.0
2019-09-04 10:00:00	IWM	ETF	148.01	148.205	147.38	147.77	1728510.0
2019-09-04 11:00:00	IWM	ETF	147.74	147.8	147.435	147.61	1110064.0
2019-09-04 12:00:00	IWM	ETF	147.62	147.72	147.175	147.705	944431.0
2019-09-04 13:00:00	IWM	ETF	147.69	147.74	147.4	147.46	591503.0
2019-09-04 14:00:00	IWM	ETF	147.46	147.83	147.305	147.74	1081012.0
2019-09-04 15:00:00	IWM	ETF	147.74	147.94	147.735	147.88	2005785.0
2019-09-04 16:00:00	IWM	ETF	147.88	147.94	147.71	147.75	799033.0
2019-09-04 17:00:00	IWM	ETF	147.84	147.84	147.76	147.76	504450.0
2019-09-04 18:00:00	IWM	ETF	147.79	147.81	147.71	147.81	4963.0
2019-09-04 19:00:00	IWM	ETF	147.76	147.77	147.7	147.74	10600.0
2019-09-04 04:00:00	DIA	ETF	263.7	263.7	263.7	263.7	500.0
2019-09-04 05:00:00	DIA	ETF	263.88	263.88	263.88	263.88	100.0

> showing 50 of 11,039 rows — these rows as CSV

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