PREVIEW / etf_1hour / 2019-08-22

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-08-22.parquet
  size:    328 KB
  rows:    10,757

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-22 04:00:00	SPY	ETF	293.17	293.24	292.22	292.6	46240.0
2019-08-22 05:00:00	SPY	ETF	292.52	292.61	291.85	292.08	23133.0
2019-08-22 06:00:00	SPY	ETF	292.24	292.52	292.16	292.32	81549.0
2019-08-22 07:00:00	SPY	ETF	292.42	293.4	292.37	293.27	225950.0
2019-08-22 08:00:00	SPY	ETF	292.39	293.73	291.95	293.5	515644.0
2019-08-22 09:00:00	SPY	ETF	293.5499	293.93	293.16	293.47	5603146.0
2019-08-22 10:00:00	SPY	ETF	293.47	293.5	290.4	290.58	11741243.0
2019-08-22 11:00:00	SPY	ETF	290.58	291.89	290.57	291.49	6369475.0
2019-08-22 12:00:00	SPY	ETF	291.5	292.34	291.45	292.015	4925636.0
2019-08-22 13:00:00	SPY	ETF	292.015	292.84	292.005	292.6	4543187.0
2019-08-22 14:00:00	SPY	ETF	292.61	292.96	292.2738	292.86	4208373.0
2019-08-22 15:00:00	SPY	ETF	292.865	293.24	292.13	292.31	8767408.0
2019-08-22 16:00:00	SPY	ETF	292.3	292.46	291.96	292.01	3452685.0
2019-08-22 17:00:00	SPY	ETF	292.04	292.15	291.95	292.02	74674.0
2019-08-22 18:00:00	SPY	ETF	292.06	292.36	292.06	292.11	98361.0
2019-08-22 19:00:00	SPY	ETF	292.2	292.25	291.88	292.18	28779.0
2019-08-22 04:00:00	QQQ	ETF	189.04	189.04	188.24	188.46	35259.0
2019-08-22 05:00:00	QQQ	ETF	188.48	188.48	187.83	188.1	55055.0
2019-08-22 06:00:00	QQQ	ETF	188.09	188.45	188.09	188.31	36711.0
2019-08-22 07:00:00	QQQ	ETF	188.35	189.17	188.27	189.12	149076.0
2019-08-22 08:00:00	QQQ	ETF	188.3299	189.5	188.28	189.21	246046.0
2019-08-22 09:00:00	QQQ	ETF	189.24	189.46	188.9	189.21	2027725.0
2019-08-22 10:00:00	QQQ	ETF	189.23	189.23	186.54	186.68	5836616.0
2019-08-22 11:00:00	QQQ	ETF	186.71	187.69	186.64	187.2701	2643670.0
2019-08-22 12:00:00	QQQ	ETF	187.28	187.94	187.24	187.7	2275118.0
2019-08-22 13:00:00	QQQ	ETF	187.695	188.4	187.69	188.21	1400710.0
2019-08-22 14:00:00	QQQ	ETF	188.21	188.54	187.97	188.46	1417146.0
2019-08-22 15:00:00	QQQ	ETF	188.48	188.72	187.92	188.05	3617251.0
2019-08-22 16:00:00	QQQ	ETF	188.02	188.1	187.77	187.84	599772.0
2019-08-22 17:00:00	QQQ	ETF	187.91	187.91	187.79	187.8	13635.0
2019-08-22 18:00:00	QQQ	ETF	187.83	188.11	187.83	188.03	37659.0
2019-08-22 19:00:00	QQQ	ETF	187.98	188.0	187.76	187.95	10652.0
2019-08-22 05:00:00	IWM	ETF	150.12	150.13	150.12	150.13	1200.0
2019-08-22 06:00:00	IWM	ETF	150.25	150.31	150.25	150.31	1100.0
2019-08-22 07:00:00	IWM	ETF	150.31	150.74	150.31	150.74	38580.0
2019-08-22 08:00:00	IWM	ETF	150.73	150.96	150.73	150.85	33523.0
2019-08-22 09:00:00	IWM	ETF	150.88	151.08	150.61	150.96	1130697.0
2019-08-22 10:00:00	IWM	ETF	150.97	151.05	149.14	149.25	2705648.0
2019-08-22 11:00:00	IWM	ETF	149.24	149.9	149.18	149.75	1759537.0
2019-08-22 12:00:00	IWM	ETF	149.74	150.36	149.71	150.14	896858.0
2019-08-22 13:00:00	IWM	ETF	150.14	150.76	150.14	150.5501	1394347.0
2019-08-22 14:00:00	IWM	ETF	150.55	150.63	150.05	150.3115	751968.0
2019-08-22 15:00:00	IWM	ETF	150.32	150.39	149.9	149.99	2557060.0
2019-08-22 16:00:00	IWM	ETF	150.03	150.06	149.82	149.89	638744.0
2019-08-22 17:00:00	IWM	ETF	149.9	149.9	149.78	149.78	3600.0
2019-08-22 18:00:00	IWM	ETF	149.86	150.03	149.86	150.03	5484.0
2019-08-22 19:00:00	IWM	ETF	149.88	149.99	149.88	149.99	2000.0
2019-08-22 04:00:00	DIA	ETF	262.58	262.58	261.84	261.84	1400.0
2019-08-22 05:00:00	DIA	ETF	261.69	261.69	261.55	261.64	500.0
2019-08-22 06:00:00	DIA	ETF	261.8	261.82	261.8	261.82	2950.0

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

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