PREVIEW / etf_1hour / 2014-04-16

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-04-16.parquet
  size:    217 KB
  rows:    6,890

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-04-16 04:00:00	SPY	ETF	185.07	185.39	185.0	185.35	37510.0
2014-04-16 05:00:00	SPY	ETF	185.38	185.49	185.37	185.43	13794.0
2014-04-16 06:00:00	SPY	ETF	185.41	185.46	185.3	185.32	66438.0
2014-04-16 07:00:00	SPY	ETF	185.3	185.47	185.27	185.33	475439.0
2014-04-16 08:00:00	SPY	ETF	185.44	185.45	185.16	185.28	740788.0
2014-04-16 09:00:00	SPY	ETF	185.27	185.66	184.78	185.07	14377757.0
2014-04-16 10:00:00	SPY	ETF	185.07	185.29	184.68	184.805	14928474.0
2014-04-16 11:00:00	SPY	ETF	184.8	185.461	184.65	185.42	10579136.0
2014-04-16 12:00:00	SPY	ETF	185.42	185.78	185.29	185.295	14055553.0
2014-04-16 13:00:00	SPY	ETF	185.29	185.58	185.055	185.51	8582446.0
2014-04-16 14:00:00	SPY	ETF	185.52	185.84	185.14	185.775	9967625.0
2014-04-16 15:00:00	SPY	ETF	185.77	186.14	185.59	186.13	18490536.0
2014-04-16 16:00:00	SPY	ETF	186.12	186.22	184.2081	185.71	8737756.0
2014-04-16 17:00:00	SPY	ETF	185.71	185.89	185.71	185.8	310861.0
2014-04-16 18:00:00	SPY	ETF	185.79	185.79	185.31	185.39	993663.0
2014-04-16 19:00:00	SPY	ETF	185.37	185.5	185.36	185.47	75708.0
2014-04-16 04:00:00	QQQ	ETF	85.78	85.87	85.75	85.83	17475.0
2014-04-16 05:00:00	QQQ	ETF	85.88	85.91	85.84	85.87	47100.0
2014-04-16 06:00:00	QQQ	ETF	85.89	85.9	85.81	85.83	72565.0
2014-04-16 07:00:00	QQQ	ETF	85.83	85.9	85.77	85.79	67252.0
2014-04-16 08:00:00	QQQ	ETF	85.8	85.89	85.66	85.73	232629.0
2014-04-16 09:00:00	QQQ	ETF	85.74	85.9	85.23	85.475	7380227.0
2014-04-16 10:00:00	QQQ	ETF	85.49	85.76	85.12	85.22	7708203.0
2014-04-16 11:00:00	QQQ	ETF	85.22	85.73	85.091	85.72	3869099.0
2014-04-16 12:00:00	QQQ	ETF	85.7289	86.045	85.62	85.62	4685931.0
2014-04-16 13:00:00	QQQ	ETF	85.62	85.8	85.465	85.69	4099393.0
2014-04-16 14:00:00	QQQ	ETF	85.69	85.93	85.48	85.89	2916596.0
2014-04-16 15:00:00	QQQ	ETF	85.89	86.18	85.7601	86.17	6028790.0
2014-04-16 16:00:00	QQQ	ETF	86.18	86.18	85.0854	85.61	5572654.0
2014-04-16 17:00:00	QQQ	ETF	85.63	85.82	85.0855	85.82	1093880.0
2014-04-16 18:00:00	QQQ	ETF	85.76	85.76	85.49	85.54	89582.0
2014-04-16 19:00:00	QQQ	ETF	85.53	85.6	85.52	85.59	32893.0
2014-04-16 04:00:00	IWM	ETF	111.57	112.16	111.57	112.16	1316.0
2014-04-16 05:00:00	IWM	ETF	112.33	112.38	112.33	112.38	1300.0
2014-04-16 06:00:00	IWM	ETF	112.28	112.28	112.28	112.28	100.0
2014-04-16 07:00:00	IWM	ETF	112.27	112.31	112.1	112.21	124590.0
2014-04-16 08:00:00	IWM	ETF	112.25	112.28	112.01	112.1	180724.0
2014-04-16 09:00:00	IWM	ETF	112.11	112.17	111.369	111.62	8090831.0
2014-04-16 10:00:00	IWM	ETF	111.63	112.07	111.42	111.42	6026955.0
2014-04-16 11:00:00	IWM	ETF	111.43	112.05	111.23	111.98	4753879.0
2014-04-16 12:00:00	IWM	ETF	111.975	112.41	111.84	111.851	4807493.0
2014-04-16 13:00:00	IWM	ETF	111.85	112.11	111.56	111.96	4369150.0
2014-04-16 14:00:00	IWM	ETF	111.96	112.17	111.54	112.11	3000946.0
2014-04-16 15:00:00	IWM	ETF	112.12	112.44	111.9701	112.34	6657491.0
2014-04-16 16:00:00	IWM	ETF	112.35	112.41	111.81	111.9	3146881.0
2014-04-16 17:00:00	IWM	ETF	111.91	112.0	111.88	111.9	124890.0
2014-04-16 18:00:00	IWM	ETF	111.86	111.95	111.71	111.71	59721.0
2014-04-16 19:00:00	IWM	ETF	111.75	111.79	111.75	111.79	340.0
2014-04-16 06:00:00	DIA	ETF	163.2	163.2	163.2	163.2	100.0
2014-04-16 07:00:00	DIA	ETF	163.2	163.3	163.17	163.17	2700.0

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

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