PREVIEW / etf_1hour / 2016-08-16

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-08-16.parquet
  size:    255 KB
  rows:    8,308

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
2016-08-16 04:00:00	SPY	ETF	218.85	218.85	218.52	218.6	98506.0
2016-08-16 05:00:00	SPY	ETF	218.63	219.0	218.63	218.92	5963.0
2016-08-16 06:00:00	SPY	ETF	218.91	218.91	218.63	218.82	15474.0
2016-08-16 07:00:00	SPY	ETF	218.85	218.87	218.64	218.65	83979.0
2016-08-16 08:00:00	SPY	ETF	218.68	218.82	218.47	218.55	563420.0
2016-08-16 09:00:00	SPY	ETF	218.57	218.65	218.14	218.395	7753038.0
2016-08-16 10:00:00	SPY	ETF	218.39	218.68	218.21	218.29	8905135.0
2016-08-16 11:00:00	SPY	ETF	218.29	218.62	218.25	218.47	5319390.0
2016-08-16 12:00:00	SPY	ETF	218.48	218.58	218.32	218.55	4129367.0
2016-08-16 13:00:00	SPY	ETF	218.541	218.58	218.17	218.26	4695196.0
2016-08-16 14:00:00	SPY	ETF	218.26	218.42	218.07	218.39	7101198.0
2016-08-16 15:00:00	SPY	ETF	218.389	218.41	217.96	217.98	10376574.0
2016-08-16 16:00:00	SPY	ETF	217.98	218.26	217.96	218.22	3124071.0
2016-08-16 17:00:00	SPY	ETF	218.21	218.31	217.96	218.22	204036.0
2016-08-16 18:00:00	SPY	ETF	218.21	218.29	218.18	218.19	74166.0
2016-08-16 19:00:00	SPY	ETF	218.19	218.28	218.19	218.26	29859.0
2016-08-16 04:00:00	QQQ	ETF	117.4	117.55	117.4	117.46	2834.0
2016-08-16 05:00:00	QQQ	ETF	117.5	117.68	117.5	117.68	5551.0
2016-08-16 06:00:00	QQQ	ETF	117.64	117.64	117.49	117.57	7744.0
2016-08-16 07:00:00	QQQ	ETF	117.59	117.62	117.47	117.47	19804.0
2016-08-16 08:00:00	QQQ	ETF	117.54	117.54	117.4	117.44	45095.0
2016-08-16 09:00:00	QQQ	ETF	117.46	117.51	117.03	117.26	1896988.0
2016-08-16 10:00:00	QQQ	ETF	117.26	117.44	117.14	117.2065	1198371.0
2016-08-16 11:00:00	QQQ	ETF	117.2	117.38	117.16	117.2999	1279464.0
2016-08-16 12:00:00	QQQ	ETF	117.3	117.42	117.23	117.403	996709.0
2016-08-16 13:00:00	QQQ	ETF	117.4	117.41	117.1305	117.2	1047212.0
2016-08-16 14:00:00	QQQ	ETF	117.21	117.281	117.05	117.2499	1455154.0
2016-08-16 15:00:00	QQQ	ETF	117.24	117.31	117.03	117.05	2152470.0
2016-08-16 16:00:00	QQQ	ETF	117.06	117.15	117.05	117.15	496187.0
2016-08-16 17:00:00	QQQ	ETF	117.16	117.18	117.15	117.18	3896.0
2016-08-16 18:00:00	QQQ	ETF	117.12	117.16	117.12	117.14	10776.0
2016-08-16 19:00:00	QQQ	ETF	117.12	117.18	117.12	117.13	10701.0
2016-08-16 04:00:00	IWM	ETF	123.22	123.22	123.22	123.22	600.0
2016-08-16 05:00:00	IWM	ETF	123.3	123.32	123.3	123.3	10000.0
2016-08-16 06:00:00	IWM	ETF	123.25	123.25	123.16	123.2	20428.0
2016-08-16 07:00:00	IWM	ETF	123.29	123.29	123.16	123.16	5266.0
2016-08-16 08:00:00	IWM	ETF	123.16	123.21	123.04	123.09	58517.0
2016-08-16 09:00:00	IWM	ETF	123.1	123.12	122.5803	122.92	3488557.0
2016-08-16 10:00:00	IWM	ETF	122.91	123.11	122.505	122.5699	2443028.0
2016-08-16 11:00:00	IWM	ETF	122.56	122.85	122.5	122.7	1572076.0
2016-08-16 12:00:00	IWM	ETF	122.71	122.73	122.34	122.7	2095630.0
2016-08-16 13:00:00	IWM	ETF	122.7	122.77	122.505	122.615	1271018.0
2016-08-16 14:00:00	IWM	ETF	122.62	122.72	122.49	122.67	1527713.0
2016-08-16 15:00:00	IWM	ETF	122.67	122.74	122.26	122.38	3455808.0
2016-08-16 16:00:00	IWM	ETF	122.39	122.7178	122.39	122.54	678183.0
2016-08-16 17:00:00	IWM	ETF	122.54	122.54	122.54	122.54	18133.0
2016-08-16 19:00:00	IWM	ETF	122.47	122.48	122.47	122.48	700.0
2016-08-16 06:00:00	DIA	ETF	186.25	186.25	186.25	186.25	300.0
2016-08-16 08:00:00	DIA	ETF	186.11	186.11	186.03	186.03	1600.0
2016-08-16 09:00:00	DIA	ETF	186.1	186.17	185.76	186.07	353385.0

> showing 50 of 8,308 rows — these rows as CSV

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