PREVIEW / etf_1hour / 2016-09-08

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-09-08.parquet
  size:    252 KB
  rows:    8,121

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-08 04:00:00	SPY	ETF	219.21	219.44	219.21	219.32	6152.0
2016-09-08 05:00:00	SPY	ETF	219.25	219.32	219.22	219.27	25261.0
2016-09-08 06:00:00	SPY	ETF	219.22	219.23	219.15	219.16	19596.0
2016-09-08 07:00:00	SPY	ETF	219.16	219.18	218.92	218.94	129266.0
2016-09-08 08:00:00	SPY	ETF	218.93	219.17	218.58	218.71	1102360.0
2016-09-08 09:00:00	SPY	ETF	218.7	218.73	218.21	218.34	10667717.0
2016-09-08 10:00:00	SPY	ETF	218.34	218.82	218.15	218.57	13890371.0
2016-09-08 11:00:00	SPY	ETF	218.58	218.94	218.5	218.73	9044660.0
2016-09-08 12:00:00	SPY	ETF	218.73	218.79	218.395	218.6	6234433.0
2016-09-08 13:00:00	SPY	ETF	218.595	218.62	218.21	218.4695	7664811.0
2016-09-08 14:00:00	SPY	ETF	218.46	218.72	218.35	218.695	8114108.0
2016-09-08 15:00:00	SPY	ETF	218.7	218.73	218.51	218.53	11753009.0
2016-09-08 16:00:00	SPY	ETF	218.52	219.0528	218.27	218.36	4421909.0
2016-09-08 17:00:00	SPY	ETF	218.37	218.51	218.29	218.29	182450.0
2016-09-08 18:00:00	SPY	ETF	218.29	218.29	218.23	218.27	81449.0
2016-09-08 19:00:00	SPY	ETF	218.28	218.34	218.25	218.34	48879.0
2016-09-08 04:00:00	QQQ	ETF	117.99	118.01	117.99	117.99	20000.0
2016-09-08 05:00:00	QQQ	ETF	117.95	117.95	117.94	117.94	1100.0
2016-09-08 06:00:00	QQQ	ETF	117.92	117.92	117.9	117.9	600.0
2016-09-08 07:00:00	QQQ	ETF	117.92	117.92	117.78	117.8	48844.0
2016-09-08 08:00:00	QQQ	ETF	117.79	117.88	117.61	117.67	175670.0
2016-09-08 09:00:00	QQQ	ETF	117.68	117.69	117.15	117.22	2763379.0
2016-09-08 10:00:00	QQQ	ETF	117.22	117.53	117.06	117.365	2262327.0
2016-09-08 11:00:00	QQQ	ETF	117.365	117.56	117.25	117.42	2158439.0
2016-09-08 12:00:00	QQQ	ETF	117.419	117.445	117.19	117.23	1355897.0
2016-09-08 13:00:00	QQQ	ETF	117.22	117.26	116.92	117.12	1775052.0
2016-09-08 14:00:00	QQQ	ETF	117.12	117.32	117.06	117.295	1466790.0
2016-09-08 15:00:00	QQQ	ETF	117.3	117.33	117.19	117.23	2890877.0
2016-09-08 16:00:00	QQQ	ETF	117.23	117.2714	116.99	117.1	651679.0
2016-09-08 17:00:00	QQQ	ETF	117.23	117.23	117.05	117.06	19393.0
2016-09-08 18:00:00	QQQ	ETF	117.04	117.06	117.0	117.06	1777.0
2016-09-08 19:00:00	QQQ	ETF	117.05	117.09	117.04	117.07	20635.0
2016-09-08 05:00:00	IWM	ETF	125.56	125.56	125.56	125.56	100.0
2016-09-08 06:00:00	IWM	ETF	125.6	125.64	125.6	125.64	200.0
2016-09-08 07:00:00	IWM	ETF	125.56	125.56	125.41	125.41	93822.0
2016-09-08 08:00:00	IWM	ETF	125.41	125.59	125.24	125.3	134452.0
2016-09-08 09:00:00	IWM	ETF	125.31	125.32	124.8	124.93	2737570.0
2016-09-08 10:00:00	IWM	ETF	124.93	125.27	124.77	125.01	1983972.0
2016-09-08 11:00:00	IWM	ETF	125.02	125.36	124.99	125.2	1364485.0
2016-09-08 12:00:00	IWM	ETF	125.2	125.34	125.02	125.317	1184505.0
2016-09-08 13:00:00	IWM	ETF	125.31	125.41	124.94	125.13	1362286.0
2016-09-08 14:00:00	IWM	ETF	125.13	125.27	125.05	125.125	1080651.0
2016-09-08 15:00:00	IWM	ETF	125.12	125.23	125.04	125.18	2689244.0
2016-09-08 16:00:00	IWM	ETF	125.16	125.19	124.88	124.99	1159977.0
2016-09-08 17:00:00	IWM	ETF	125.0	125.03	125.0	125.03	2100.0
2016-09-08 18:00:00	IWM	ETF	124.99	124.99	124.98	124.98	1100.0
2016-09-08 19:00:00	IWM	ETF	125.02	125.02	125.02	125.02	100.0
2016-09-08 08:00:00	DIA	ETF	185.3	185.3	184.95	184.95	2839.0
2016-09-08 09:00:00	DIA	ETF	184.9	184.9	184.48	184.61	358008.0
2016-09-08 10:00:00	DIA	ETF	184.6	185.09	184.52	184.89	268947.0

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

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