PREVIEW / etf_1hour / 2016-09-06

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-09-06.parquet
  size:    257 KB
  rows:    8,295

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-09-06 04:00:00	SPY	ETF	218.37	218.58	218.37	218.55	8833.0
2016-09-06 05:00:00	SPY	ETF	218.55	218.65	218.55	218.65	5754.0
2016-09-06 06:00:00	SPY	ETF	218.57	218.57	218.48	218.5	6386.0
2016-09-06 07:00:00	SPY	ETF	218.5	218.56	218.41	218.53	75032.0
2016-09-06 08:00:00	SPY	ETF	218.54	218.55	218.321	218.5	380675.0
2016-09-06 09:00:00	SPY	ETF	218.47	218.79	218.45	218.57	6000811.0
2016-09-06 10:00:00	SPY	ETF	218.57	218.7	217.86	218.11	11917999.0
2016-09-06 11:00:00	SPY	ETF	218.11	218.69	218.0202	218.669	6487511.0
2016-09-06 12:00:00	SPY	ETF	218.67	218.87	218.56	218.7201	4811044.0
2016-09-06 13:00:00	SPY	ETF	218.72	218.7501	218.58	218.67	3234759.0
2016-09-06 14:00:00	SPY	ETF	218.668	218.79	218.58	218.78	3150231.0
2016-09-06 15:00:00	SPY	ETF	218.78	219.09	218.6027	219.07	12287618.0
2016-09-06 16:00:00	SPY	ETF	219.06	219.16	218.94	219.09	7478762.0
2016-09-06 17:00:00	SPY	ETF	219.0236	219.1	219.0236	219.03	134362.0
2016-09-06 18:00:00	SPY	ETF	219.07	219.07	219.0	219.02	84874.0
2016-09-06 19:00:00	SPY	ETF	219.02	219.02	218.97	219.01	32219.0
2016-09-06 04:00:00	QQQ	ETF	117.12	117.17	117.1	117.17	10300.0
2016-09-06 05:00:00	QQQ	ETF	117.2	117.2	117.2	117.2	10000.0
2016-09-06 06:00:00	QQQ	ETF	117.13	117.13	117.13	117.13	100.0
2016-09-06 07:00:00	QQQ	ETF	117.14	117.19	117.13	117.19	11587.0
2016-09-06 08:00:00	QQQ	ETF	117.17	117.2	117.14	117.2	22785.0
2016-09-06 09:00:00	QQQ	ETF	117.2	117.52	117.13	117.47	2220544.0
2016-09-06 10:00:00	QQQ	ETF	117.46	117.6	117.06	117.3399	3773207.0
2016-09-06 11:00:00	QQQ	ETF	117.33	117.67	117.316	117.655	1873519.0
2016-09-06 12:00:00	QQQ	ETF	117.66	117.83	117.6134	117.73	1676846.0
2016-09-06 13:00:00	QQQ	ETF	117.73	117.76	117.6035	117.64	1129920.0
2016-09-06 14:00:00	QQQ	ETF	117.645	117.75	117.59	117.72	1156051.0
2016-09-06 15:00:00	QQQ	ETF	117.72	117.85	117.64	117.85	3589299.0
2016-09-06 16:00:00	QQQ	ETF	117.84	117.91	117.66	117.9	620928.0
2016-09-06 17:00:00	QQQ	ETF	117.86	117.97	117.86	117.91	12850.0
2016-09-06 18:00:00	QQQ	ETF	117.91	117.91	117.85	117.85	9597.0
2016-09-06 19:00:00	QQQ	ETF	117.86	117.86	117.83	117.86	7376.0
2016-09-06 04:00:00	IWM	ETF	124.55	124.55	124.55	124.55	135.0
2016-09-06 05:00:00	IWM	ETF	124.62	124.62	124.62	124.62	724.0
2016-09-06 06:00:00	IWM	ETF	124.63	124.63	124.63	124.63	1000.0
2016-09-06 07:00:00	IWM	ETF	124.6	124.67	124.6	124.66	9454.0
2016-09-06 08:00:00	IWM	ETF	124.67	124.72	124.61	124.72	75893.0
2016-09-06 09:00:00	IWM	ETF	124.72	124.97	124.55	124.65	2044627.0
2016-09-06 10:00:00	IWM	ETF	124.64	124.71	123.97	124.13	3011523.0
2016-09-06 11:00:00	IWM	ETF	124.13	124.48	124.06	124.4563	1356671.0
2016-09-06 12:00:00	IWM	ETF	124.46	124.62	124.425	124.51	1251107.0
2016-09-06 13:00:00	IWM	ETF	124.51	124.6	124.42	124.495	924715.0
2016-09-06 14:00:00	IWM	ETF	124.5	124.59	124.39	124.55	882096.0
2016-09-06 15:00:00	IWM	ETF	124.55	124.66	124.42	124.66	2592066.0
2016-09-06 16:00:00	IWM	ETF	124.65	124.75	124.6292	124.75	889738.0
2016-09-06 17:00:00	IWM	ETF	124.72	124.72	124.68	124.68	2272.0
2016-09-06 18:00:00	IWM	ETF	124.69	124.69	124.69	124.69	500.0
2016-09-06 19:00:00	IWM	ETF	124.75	124.75	124.75	124.75	500.0
2016-09-06 05:00:00	DIA	ETF	185.1	185.1	185.1	185.1	200.0
2016-09-06 08:00:00	DIA	ETF	185.09	185.09	185.09	185.09	134.0

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

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