PREVIEW / etf_1hour / 2017-12-14

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-12-14.parquet
  size:    289 KB
  rows:    9,497

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-12-14 04:00:00	SPY	ETF	267.18	267.4	267.18	267.38	1970.0
2017-12-14 05:00:00	SPY	ETF	267.4	267.4	267.2	267.2	7753.0
2017-12-14 06:00:00	SPY	ETF	267.19	267.26	267.17	267.19	9701.0
2017-12-14 07:00:00	SPY	ETF	267.15	267.21	267.08	267.16	169410.0
2017-12-14 08:00:00	SPY	ETF	267.15	267.24	266.96	267.21	368507.0
2017-12-14 09:00:00	SPY	ETF	267.22	267.23	266.85	267.115	5713343.0
2017-12-14 10:00:00	SPY	ETF	267.115	267.22	266.96	266.99	8723965.0
2017-12-14 11:00:00	SPY	ETF	266.99	267.07	266.55	266.88	10069562.0
2017-12-14 12:00:00	SPY	ETF	266.89	266.91	266.45	266.51	6852989.0
2017-12-14 13:00:00	SPY	ETF	266.51	266.6567	266.15	266.18	13807312.0
2017-12-14 14:00:00	SPY	ETF	266.18	266.32	265.6	266.07	10521176.0
2017-12-14 15:00:00	SPY	ETF	266.07	266.31	265.6	265.67	23016635.0
2017-12-14 16:00:00	SPY	ETF	265.68	267.18	265.29	267.18	17962317.0
2017-12-14 17:00:00	SPY	ETF	265.32	265.66	265.22	265.45	1225608.0
2017-12-14 18:00:00	SPY	ETF	265.46	266.83	265.39	265.55	717904.0
2017-12-14 19:00:00	SPY	ETF	265.55	265.63	265.45	265.63	26230.0
2017-12-14 04:00:00	QQQ	ETF	156.21	156.22	156.2	156.22	12700.0
2017-12-14 05:00:00	QQQ	ETF	156.23	156.24	156.19	156.21	74586.0
2017-12-14 06:00:00	QQQ	ETF	156.21	156.26	156.21	156.21	5300.0
2017-12-14 07:00:00	QQQ	ETF	156.26	156.27	156.12	156.15	11203.0
2017-12-14 08:00:00	QQQ	ETF	156.19	156.28	156.11	156.28	50964.0
2017-12-14 09:00:00	QQQ	ETF	156.29	156.44	156.065	156.29	2146678.0
2017-12-14 10:00:00	QQQ	ETF	156.29	156.66	156.11	156.54	2633655.0
2017-12-14 11:00:00	QQQ	ETF	156.54	156.615	156.2	156.39	1833466.0
2017-12-14 12:00:00	QQQ	ETF	156.395	156.48	156.195	156.24	1045638.0
2017-12-14 13:00:00	QQQ	ETF	156.24	156.29	155.78	156.05	3112178.0
2017-12-14 14:00:00	QQQ	ETF	156.05	156.215	155.71	156.06	3048419.0
2017-12-14 15:00:00	QQQ	ETF	156.055	156.17	155.8	155.87	3561841.0
2017-12-14 16:00:00	QQQ	ETF	155.88	155.99	155.75	155.75	2567593.0
2017-12-14 17:00:00	QQQ	ETF	155.78	156.26	155.75	155.76	42723.0
2017-12-14 18:00:00	QQQ	ETF	155.77	155.88	155.76	155.85	236070.0
2017-12-14 19:00:00	QQQ	ETF	155.82	155.9	155.81	155.87	5888.0
2017-12-14 04:00:00	IWM	ETF	152.09	152.16	152.05	152.1	16009.0
2017-12-14 05:00:00	IWM	ETF	152.09	152.09	151.99	152.04	4803.0
2017-12-14 06:00:00	IWM	ETF	151.99	151.99	151.99	151.99	997.0
2017-12-14 07:00:00	IWM	ETF	151.96	152.02	151.87	151.92	9309.0
2017-12-14 08:00:00	IWM	ETF	151.98	151.98	151.82	151.86	27934.0
2017-12-14 09:00:00	IWM	ETF	151.9	152.13	151.62	151.98	1847402.0
2017-12-14 10:00:00	IWM	ETF	151.99	152.2	151.45	151.69	2427359.0
2017-12-14 11:00:00	IWM	ETF	151.7	151.9	151.13	151.79	2423112.0
2017-12-14 12:00:00	IWM	ETF	151.785	151.84	151.21	151.27	1439859.0
2017-12-14 13:00:00	IWM	ETF	151.26	151.28	149.97	149.9801	3202657.0
2017-12-14 14:00:00	IWM	ETF	149.98	150.5	149.64	150.28	4481493.0
2017-12-14 15:00:00	IWM	ETF	150.27	150.48	149.78	150.09	6011746.0
2017-12-14 16:00:00	IWM	ETF	150.1	150.7452	149.96	149.96	1083573.0
2017-12-14 17:00:00	IWM	ETF	150.05	150.1	149.95	150.0	124073.0
2017-12-14 18:00:00	IWM	ETF	150.06	150.09	150.0	150.08	6932.0
2017-12-14 19:00:00	IWM	ETF	150.06	150.15	150.01	150.0383	184716.0
2017-12-14 07:00:00	DIA	ETF	246.9	246.9	246.9	246.9	100.0
2017-12-14 08:00:00	DIA	ETF	246.9	246.95	246.86	246.94	4750.0

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

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