PREVIEW / etf_1hour / 2017-10-04

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-10-04.parquet
  size:    281 KB
  rows:    9,224

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
2017-10-04 04:00:00	SPY	ETF	252.77	252.87	252.77	252.84	4300.0
2017-10-04 05:00:00	SPY	ETF	252.84	252.84	252.77	252.78	16900.0
2017-10-04 06:00:00	SPY	ETF	252.78	252.78	252.7	252.7	16904.0
2017-10-04 07:00:00	SPY	ETF	252.76	252.81	252.66	252.78	57350.0
2017-10-04 08:00:00	SPY	ETF	252.82	252.82	252.62	252.66	122389.0
2017-10-04 09:00:00	SPY	ETF	252.66	252.9	252.56	252.81	6979720.0
2017-10-04 10:00:00	SPY	ETF	252.81	252.89	252.68	252.88	6086976.0
2017-10-04 11:00:00	SPY	ETF	252.88	253.3	252.8792	253.27	4256906.0
2017-10-04 12:00:00	SPY	ETF	253.27	253.44	253.17	253.24	5291462.0
2017-10-04 13:00:00	SPY	ETF	253.23	253.32	252.91	253.09	3828649.0
2017-10-04 14:00:00	SPY	ETF	253.085	253.18	252.99	253.16	3949911.0
2017-10-04 15:00:00	SPY	ETF	253.15	253.265	252.98	253.16	10736600.0
2017-10-04 16:00:00	SPY	ETF	253.16	253.27	253.11	253.19	8629442.0
2017-10-04 17:00:00	SPY	ETF	253.22	253.25	253.16	253.2	5226403.0
2017-10-04 18:00:00	SPY	ETF	253.2	253.21	253.13	253.21	70750.0
2017-10-04 19:00:00	SPY	ETF	253.18	253.19	253.14	253.16	78331.0
2017-10-04 04:00:00	QQQ	ETF	145.8	145.87	145.8	145.81	5273.0
2017-10-04 05:00:00	QQQ	ETF	145.78	145.78	145.76	145.76	2200.0
2017-10-04 06:00:00	QQQ	ETF	145.75	145.78	145.67	145.67	12518.0
2017-10-04 07:00:00	QQQ	ETF	145.75	145.8	145.66	145.69	75631.0
2017-10-04 08:00:00	QQQ	ETF	145.677	145.77	145.54	145.63	175990.0
2017-10-04 09:00:00	QQQ	ETF	145.61	145.88	145.47	145.73	3777112.0
2017-10-04 10:00:00	QQQ	ETF	145.74	145.851	145.5	145.72	3652782.0
2017-10-04 11:00:00	QQQ	ETF	145.74	146.11	145.735	146.03	1704291.0
2017-10-04 12:00:00	QQQ	ETF	146.03	146.34	145.99	146.1	2641306.0
2017-10-04 13:00:00	QQQ	ETF	146.1	146.1267	145.619	145.84	2748494.0
2017-10-04 14:00:00	QQQ	ETF	145.84	146.035	145.82	146.01	1346028.0
2017-10-04 15:00:00	QQQ	ETF	146.01	146.09	145.93	146.03	4163109.0
2017-10-04 16:00:00	QQQ	ETF	146.04	146.125	145.97	146.07	807346.0
2017-10-04 18:00:00	QQQ	ETF	146.03	146.07	146.03	146.07	2585.0
2017-10-04 19:00:00	QQQ	ETF	146.08	146.08	146.06	146.07	4160.0
2017-10-04 04:00:00	IWM	ETF	150.01	150.08	150.01	150.08	15200.0
2017-10-04 05:00:00	IWM	ETF	150.07	150.08	150.07	150.08	5500.0
2017-10-04 06:00:00	IWM	ETF	150.02	150.06	150.0	150.0	5305.0
2017-10-04 07:00:00	IWM	ETF	150.02	150.08	150.0	150.06	37300.0
2017-10-04 08:00:00	IWM	ETF	150.09	150.12	149.95	150.12	74948.0
2017-10-04 09:00:00	IWM	ETF	150.1	150.31	149.84	149.95	2751611.0
2017-10-04 10:00:00	IWM	ETF	149.94	150.39	149.92	150.34	2043325.0
2017-10-04 11:00:00	IWM	ETF	150.35	150.61	150.24	150.4756	2018027.0
2017-10-04 12:00:00	IWM	ETF	150.48	150.49	149.9	150.04	2037277.0
2017-10-04 13:00:00	IWM	ETF	150.045	150.11	149.39	149.51	3378684.0
2017-10-04 14:00:00	IWM	ETF	149.51	149.89	149.46	149.87	1786459.0
2017-10-04 15:00:00	IWM	ETF	149.87	149.88	149.66	149.85	3310916.0
2017-10-04 16:00:00	IWM	ETF	149.84	150.01	149.7723	149.88	800966.0
2017-10-04 17:00:00	IWM	ETF	149.85	149.97	149.85	149.9	29216.0
2017-10-04 18:00:00	IWM	ETF	149.9	149.98	149.85	149.98	17339.0
2017-10-04 19:00:00	IWM	ETF	149.91	149.91	149.86	149.91	17134.0
2017-10-04 06:00:00	DIA	ETF	226.3	226.3	226.25	226.25	600.0
2017-10-04 07:00:00	DIA	ETF	226.25	226.25	226.25	226.25	400.0
2017-10-04 08:00:00	DIA	ETF	226.24	226.25	226.19	226.25	2580.0

> showing 50 of 9,224 rows — these rows as CSV

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