PREVIEW / etf_1hour / 2016-08-29

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-08-29.parquet
  size:    249 KB
  rows:    7,967

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-29 04:00:00	SPY	ETF	217.16	217.2	217.16	217.19	3446.0
2016-08-29 05:00:00	SPY	ETF	217.13	217.23	217.0	217.21	5345.0
2016-08-29 06:00:00	SPY	ETF	217.21	217.32	217.21	217.32	3014.0
2016-08-29 07:00:00	SPY	ETF	217.34	217.38	217.3	217.34	29634.0
2016-08-29 08:00:00	SPY	ETF	217.34	217.63	217.227	217.54	437075.0
2016-08-29 09:00:00	SPY	ETF	217.54	218.18	217.4	218.05	8570231.0
2016-08-29 10:00:00	SPY	ETF	218.05	218.29	217.987	218.16	11989730.0
2016-08-29 11:00:00	SPY	ETF	218.1599	218.57	218.12	218.4899	7733451.0
2016-08-29 12:00:00	SPY	ETF	218.49	218.6	218.3601	218.5536	4190173.0
2016-08-29 13:00:00	SPY	ETF	218.555	218.665	218.49	218.61	4131960.0
2016-08-29 14:00:00	SPY	ETF	218.61	218.65	218.3489	218.45	5437645.0
2016-08-29 15:00:00	SPY	ETF	218.45	218.53	218.265	218.36	18018213.0
2016-08-29 16:00:00	SPY	ETF	218.37	218.46	218.26	218.45	8070674.0
2016-08-29 17:00:00	SPY	ETF	218.44	218.44	218.39	218.42	36043.0
2016-08-29 18:00:00	SPY	ETF	218.41	218.47	218.39	218.47	25066.0
2016-08-29 19:00:00	SPY	ETF	218.47	218.53	218.46	218.48	26312.0
2016-08-29 04:00:00	QQQ	ETF	116.53	116.53	116.53	116.53	300.0
2016-08-29 06:00:00	QQQ	ETF	116.73	116.74	116.73	116.74	594.0
2016-08-29 07:00:00	QQQ	ETF	116.76	116.79	116.74	116.74	12697.0
2016-08-29 08:00:00	QQQ	ETF	116.77	116.89	116.75	116.89	16278.0
2016-08-29 09:00:00	QQQ	ETF	116.88	117.1	116.79	117.01	2029601.0
2016-08-29 10:00:00	QQQ	ETF	117.01	117.07	116.83	116.9	1407896.0
2016-08-29 11:00:00	QQQ	ETF	116.9	117.19	116.86	117.15	1046533.0
2016-08-29 12:00:00	QQQ	ETF	117.1411	117.24	117.0961	117.24	615906.0
2016-08-29 13:00:00	QQQ	ETF	117.24	117.251	117.16	117.2	1011835.0
2016-08-29 14:00:00	QQQ	ETF	117.195	117.23	117.03	117.1	892887.0
2016-08-29 15:00:00	QQQ	ETF	117.1	117.13	116.91	116.93	3402608.0
2016-08-29 16:00:00	QQQ	ETF	116.93	117.02	116.91	117.02	330773.0
2016-08-29 17:00:00	QQQ	ETF	116.96	117.02	116.96	117.02	499.0
2016-08-29 18:00:00	QQQ	ETF	117.01	117.01	116.98	117.0	3088.0
2016-08-29 19:00:00	QQQ	ETF	117.02	117.04	117.01	117.04	6499.0
2016-08-29 07:00:00	IWM	ETF	123.17	123.17	123.16	123.16	2000.0
2016-08-29 08:00:00	IWM	ETF	123.16	123.37	123.16	123.31	46174.0
2016-08-29 09:00:00	IWM	ETF	123.29	123.71	123.24	123.58	1865953.0
2016-08-29 10:00:00	IWM	ETF	123.59	123.79	123.45	123.57	1895659.0
2016-08-29 11:00:00	IWM	ETF	123.57	124.03	123.57	123.93	1635615.0
2016-08-29 12:00:00	IWM	ETF	123.93	124.03	123.8	123.975	1325362.0
2016-08-29 13:00:00	IWM	ETF	123.98	124.17	123.94	124.021	1104881.0
2016-08-29 14:00:00	IWM	ETF	124.02	124.11	123.6901	123.9	1387104.0
2016-08-29 15:00:00	IWM	ETF	123.9	123.9	123.645	123.69	2540574.0
2016-08-29 16:00:00	IWM	ETF	123.7	124.0121	123.65	123.93	958014.0
2016-08-29 17:00:00	IWM	ETF	123.93	123.95	123.86	123.86	5199.0
2016-08-29 18:00:00	IWM	ETF	123.86	123.86	123.86	123.86	100.0
2016-08-29 19:00:00	IWM	ETF	123.87	123.94	123.86	123.92	1876.0
2016-08-29 08:00:00	DIA	ETF	183.89	183.89	183.89	183.89	150.0
2016-08-29 09:00:00	DIA	ETF	183.79	184.58	183.79	184.53	301819.0
2016-08-29 10:00:00	DIA	ETF	184.54	184.85	184.53	184.74	413820.0
2016-08-29 11:00:00	DIA	ETF	184.73	185.04	184.68	184.9563	388843.0
2016-08-29 12:00:00	DIA	ETF	184.96	185.024	184.74	184.95	174982.0
2016-08-29 13:00:00	DIA	ETF	184.955	185.02	184.89	184.98	109418.0

> showing 50 of 7,967 rows — these rows as CSV

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