PREVIEW / etf_1hour / 2014-05-05

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-05-05.parquet
  size:    214 KB
  rows:    6,805

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
2014-05-05 04:00:00	SPY	ETF	188.04	188.04	187.4	187.4	1200.0
2014-05-05 05:00:00	SPY	ETF	187.1	187.48	187.1	187.28	2501.0
2014-05-05 06:00:00	SPY	ETF	187.33	187.39	187.27	187.28	38407.0
2014-05-05 07:00:00	SPY	ETF	187.27	187.31	187.14	187.31	142025.0
2014-05-05 08:00:00	SPY	ETF	187.22	187.82	187.17	187.21	791525.0
2014-05-05 09:00:00	SPY	ETF	187.21	187.4	186.62	187.39	13419280.0
2014-05-05 10:00:00	SPY	ETF	187.4	188.21	187.22	188.05	16948436.0
2014-05-05 11:00:00	SPY	ETF	188.06	188.37	187.91	188.22	9498788.0
2014-05-05 12:00:00	SPY	ETF	188.225	188.27	187.99	188.02	3643496.0
2014-05-05 13:00:00	SPY	ETF	188.02	188.14	187.9	188.11	3820699.0
2014-05-05 14:00:00	SPY	ETF	188.11	188.55	188.11	188.44	5396868.0
2014-05-05 15:00:00	SPY	ETF	188.45	188.49	188.28	188.44	10410031.0
2014-05-05 16:00:00	SPY	ETF	188.43	188.4483	187.55	188.29	8010333.0
2014-05-05 17:00:00	SPY	ETF	188.29	188.4	188.29	188.35	131451.0
2014-05-05 18:00:00	SPY	ETF	188.35	188.35	188.24	188.27	17244.0
2014-05-05 19:00:00	SPY	ETF	188.3	188.32	188.26	188.28	42274.0
2014-05-05 04:00:00	QQQ	ETF	87.4	87.4	87.21	87.21	1600.0
2014-05-05 05:00:00	QQQ	ETF	87.2	87.2	86.97	87.01	5800.0
2014-05-05 06:00:00	QQQ	ETF	87.26	87.26	87.26	87.26	100.0
2014-05-05 07:00:00	QQQ	ETF	87.15	87.22	87.01	87.15	49850.0
2014-05-05 08:00:00	QQQ	ETF	87.16	87.17	87.05	87.06	182819.0
2014-05-05 09:00:00	QQQ	ETF	87.06	87.38	86.76	87.38	5722213.0
2014-05-05 10:00:00	QQQ	ETF	87.38	87.84	87.2401	87.66	7130100.0
2014-05-05 11:00:00	QQQ	ETF	87.67	87.8	87.55	87.74	2144994.0
2014-05-05 12:00:00	QQQ	ETF	87.74	87.775	87.58	87.599	2216041.0
2014-05-05 13:00:00	QQQ	ETF	87.59	87.73	87.531	87.7	1520354.0
2014-05-05 14:00:00	QQQ	ETF	87.71	87.97	87.7	87.91	2692246.0
2014-05-05 15:00:00	QQQ	ETF	87.91	87.97	87.83	87.94	3730150.0
2014-05-05 16:00:00	QQQ	ETF	87.94	87.97	87.0419	87.9	1007650.0
2014-05-05 17:00:00	QQQ	ETF	87.92	87.96	87.88	87.96	15121.0
2014-05-05 18:00:00	QQQ	ETF	87.93	87.93	87.85	87.85	13514.0
2014-05-05 19:00:00	QQQ	ETF	87.85	87.88	87.82	87.88	39138.0
2014-05-05 04:00:00	IWM	ETF	112.03	112.03	111.48	111.5	800.0
2014-05-05 06:00:00	IWM	ETF	111.36	111.36	111.15	111.15	1300.0
2014-05-05 07:00:00	IWM	ETF	111.18	111.27	111.18	111.27	24600.0
2014-05-05 08:00:00	IWM	ETF	111.22	111.3	111.13	111.21	138248.0
2014-05-05 09:00:00	IWM	ETF	111.19	111.31	110.53	111.29	4811551.0
2014-05-05 10:00:00	IWM	ETF	111.3	112.18	111.11	111.84	5734517.0
2014-05-05 11:00:00	IWM	ETF	111.84	111.89	111.42	111.73	2566807.0
2014-05-05 12:00:00	IWM	ETF	111.73	111.85	111.38	111.4	1513551.0
2014-05-05 13:00:00	IWM	ETF	111.4	111.55	111.07	111.45	2181235.0
2014-05-05 14:00:00	IWM	ETF	111.46	112.05	111.44	111.98	1940284.0
2014-05-05 15:00:00	IWM	ETF	111.98	112.0	111.715	111.85	3229641.0
2014-05-05 16:00:00	IWM	ETF	111.85	111.89	111.55	111.89	1642654.0
2014-05-05 17:00:00	IWM	ETF	111.73	111.73	111.73	111.73	100.0
2014-05-05 08:00:00	DIA	ETF	164.3	164.3	164.13	164.14	8352.0
2014-05-05 09:00:00	DIA	ETF	164.09	164.09	135.38	163.96	932234.0
2014-05-05 10:00:00	DIA	ETF	163.98	164.83	163.83	164.72	1132638.0
2014-05-05 11:00:00	DIA	ETF	164.73	164.9	164.55	164.82	471937.0
2014-05-05 12:00:00	DIA	ETF	164.82	164.87	164.66	164.68	277398.0

> showing 50 of 6,805 rows — these rows as CSV

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