PREVIEW / etf_1hour / 2016-12-08

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-12-08.parquet
  size:    282 KB
  rows:    9,051

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-12-08 04:00:00	SPY	ETF	224.35	224.35	224.07	224.2	12936.0
2016-12-08 05:00:00	SPY	ETF	224.18	224.41	224.15	224.4	9773.0
2016-12-08 06:00:00	SPY	ETF	224.46	224.46	224.22	224.35	87255.0
2016-12-08 07:00:00	SPY	ETF	224.3	224.61	223.8	224.4	628264.0
2016-12-08 08:00:00	SPY	ETF	224.31	224.71	224.07	224.51	852005.0
2016-12-08 09:00:00	SPY	ETF	224.52	224.94	224.35	224.58	10942635.0
2016-12-08 10:00:00	SPY	ETF	224.58	224.78	224.26	224.71	10918097.0
2016-12-08 11:00:00	SPY	ETF	224.71	224.93	224.57	224.79	10738275.0
2016-12-08 12:00:00	SPY	ETF	224.79	225.59	224.78	225.33	10080488.0
2016-12-08 13:00:00	SPY	ETF	225.33	225.7	225.19	225.64	10119603.0
2016-12-08 14:00:00	SPY	ETF	225.64	225.65	224.78	225.07	17073880.0
2016-12-08 15:00:00	SPY	ETF	225.01	225.3	224.88	225.14	15351523.0
2016-12-08 16:00:00	SPY	ETF	225.14	225.36	224.9722	225.32	7499691.0
2016-12-08 17:00:00	SPY	ETF	225.32	225.8652	225.15	225.24	3770205.0
2016-12-08 18:00:00	SPY	ETF	225.25	225.33	225.25	225.28	109964.0
2016-12-08 19:00:00	SPY	ETF	225.26	225.36	225.25	225.33	62816.0
2016-12-08 04:00:00	QQQ	ETF	118.22	118.24	118.2	118.24	650.0
2016-12-08 05:00:00	QQQ	ETF	118.24	118.36	118.24	118.35	4200.0
2016-12-08 06:00:00	QQQ	ETF	118.35	118.35	118.35	118.35	200.0
2016-12-08 07:00:00	QQQ	ETF	118.28	118.41	118.1	118.31	53817.0
2016-12-08 08:00:00	QQQ	ETF	118.31	118.44	118.1	118.32	141709.0
2016-12-08 09:00:00	QQQ	ETF	118.35	118.76	118.18	118.49	3308912.0
2016-12-08 10:00:00	QQQ	ETF	118.47	118.74	118.3	118.67	2478618.0
2016-12-08 11:00:00	QQQ	ETF	118.66	118.8357	118.48	118.6	1885699.0
2016-12-08 12:00:00	QQQ	ETF	118.61	118.87	118.56	118.69	1735333.0
2016-12-08 13:00:00	QQQ	ETF	118.69	118.73	118.47	118.67	1637838.0
2016-12-08 14:00:00	QQQ	ETF	118.6747	118.705	118.1952	118.39	2147089.0
2016-12-08 15:00:00	QQQ	ETF	118.39	118.64	118.35	118.59	2703339.0
2016-12-08 16:00:00	QQQ	ETF	118.59	118.72	118.57	118.71	485477.0
2016-12-08 17:00:00	QQQ	ETF	118.67	118.69	118.6	118.65	7857.0
2016-12-08 18:00:00	QQQ	ETF	118.65	118.68	118.65	118.66	13951.0
2016-12-08 19:00:00	QQQ	ETF	118.66	118.7	118.66	118.7	3550.0
2016-12-08 04:00:00	IWM	ETF	135.79	135.79	135.77	135.77	1980.0
2016-12-08 05:00:00	IWM	ETF	135.94	135.94	135.94	135.94	114.0
2016-12-08 06:00:00	IWM	ETF	135.9	135.92	135.82	135.82	2178.0
2016-12-08 07:00:00	IWM	ETF	135.84	136.15	135.61	136.05	91245.0
2016-12-08 08:00:00	IWM	ETF	136.04	136.29	135.81	136.2	114341.0
2016-12-08 09:00:00	IWM	ETF	136.2	136.34	135.815	136.03	3087440.0
2016-12-08 10:00:00	IWM	ETF	136.03	136.85	135.8	136.715	5537866.0
2016-12-08 11:00:00	IWM	ETF	136.71	137.46	136.71	137.05	5929110.0
2016-12-08 12:00:00	IWM	ETF	137.06	137.9865	137.06	137.91	5001798.0
2016-12-08 13:00:00	IWM	ETF	137.91	138.21	137.62	138.14	4467488.0
2016-12-08 14:00:00	IWM	ETF	138.14	138.17	137.221	137.55	3925706.0
2016-12-08 15:00:00	IWM	ETF	137.55	138.135	137.5	138.06	6298085.0
2016-12-08 16:00:00	IWM	ETF	138.05	138.35	137.4912	138.28	1479678.0
2016-12-08 17:00:00	IWM	ETF	138.28	138.4	138.28	138.38	23013.0
2016-12-08 18:00:00	IWM	ETF	138.28	138.5	138.28	138.3	11899.0
2016-12-08 19:00:00	IWM	ETF	138.29	138.32	138.28	138.32	12937.0
2016-12-08 07:00:00	DIA	ETF	195.38	195.38	195.18	195.3	850.0
2016-12-08 08:00:00	DIA	ETF	195.47	195.66	195.25	195.64	6778.0

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

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