PREVIEW / etf_1hour / 2014-01-08

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-01-08.parquet
  size:    216 KB
  rows:    6,800

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-01-08 04:00:00	SPY	ETF	183.51	183.51	183.31	183.31	1990.0
2014-01-08 05:00:00	SPY	ETF	183.22	183.26	183.09	183.14	7022.0
2014-01-08 06:00:00	SPY	ETF	183.22	183.27	183.11	183.13	24887.0
2014-01-08 07:00:00	SPY	ETF	183.13	183.31	183.12	183.26	119721.0
2014-01-08 08:00:00	SPY	ETF	183.21	183.6	183.05	183.3	1240266.0
2014-01-08 09:00:00	SPY	ETF	183.29	183.58	182.89	183.24	10471338.0
2014-01-08 10:00:00	SPY	ETF	183.24	183.83	183.111	183.58	16766123.0
2014-01-08 11:00:00	SPY	ETF	183.59	183.77	183.37	183.7	9417633.0
2014-01-08 12:00:00	SPY	ETF	183.705	183.769	183.42	183.48	5681337.0
2014-01-08 13:00:00	SPY	ETF	183.48	183.65	183.34	183.58	7057565.0
2014-01-08 14:00:00	SPY	ETF	183.58	183.73	183.23	183.38	16363015.0
2014-01-08 15:00:00	SPY	ETF	183.38	183.6	182.97	183.53	21749286.0
2014-01-08 16:00:00	SPY	ETF	183.54	183.68	183.41	183.57	6707121.0
2014-01-08 17:00:00	SPY	ETF	183.56	183.65	183.55	183.55	96928.0
2014-01-08 18:00:00	SPY	ETF	183.55	183.55	183.5	183.5	49290.0
2014-01-08 19:00:00	SPY	ETF	183.5	183.54	183.49	183.52	38680.0
2014-01-08 04:00:00	QQQ	ETF	87.04	87.04	87.04	87.04	3000.0
2014-01-08 05:00:00	QQQ	ETF	86.93	86.97	86.93	86.97	900.0
2014-01-08 07:00:00	QQQ	ETF	86.94	87.04	86.94	87.03	6700.0
2014-01-08 08:00:00	QQQ	ETF	87.03	87.15	86.97	87.08	182547.0
2014-01-08 09:00:00	QQQ	ETF	87.04	87.2	86.945	87.1799	3607288.0
2014-01-08 10:00:00	QQQ	ETF	87.1799	87.55	87.12	87.3499	3496852.0
2014-01-08 11:00:00	QQQ	ETF	87.35	87.52	87.3	87.4975	1618354.0
2014-01-08 12:00:00	QQQ	ETF	87.5	87.53	87.35	87.38	1283088.0
2014-01-08 13:00:00	QQQ	ETF	87.39	87.46	87.311	87.4199	1660064.0
2014-01-08 14:00:00	QQQ	ETF	87.418	87.51	87.29	87.33	3811635.0
2014-01-08 15:00:00	QQQ	ETF	87.33	87.37	87.06	87.33	4521033.0
2014-01-08 16:00:00	QQQ	ETF	87.33	87.46	87.1233	87.41	2807125.0
2014-01-08 17:00:00	QQQ	ETF	87.39	87.43	87.37	87.43	11194.0
2014-01-08 18:00:00	QQQ	ETF	87.38	87.38	87.36	87.36	10606.0
2014-01-08 19:00:00	QQQ	ETF	87.36	87.4	87.36	87.36	1900.0
2014-01-08 07:00:00	IWM	ETF	114.54	114.61	114.53	114.57	8000.0
2014-01-08 08:00:00	IWM	ETF	114.54	114.84	114.43	114.63	980336.0
2014-01-08 09:00:00	IWM	ETF	114.59	114.81	114.07	114.435	3447369.0
2014-01-08 10:00:00	IWM	ETF	114.439	115.08	114.33	114.898	4217120.0
2014-01-08 11:00:00	IWM	ETF	114.9	114.96	114.62	114.95	3259042.0
2014-01-08 12:00:00	IWM	ETF	114.9506	115.02	114.52	114.63	1738989.0
2014-01-08 13:00:00	IWM	ETF	114.63	114.79	114.47	114.64	3486751.0
2014-01-08 14:00:00	IWM	ETF	114.63	114.75	114.29	114.5209	4481699.0
2014-01-08 15:00:00	IWM	ETF	114.53	114.85	114.25	114.84	4965753.0
2014-01-08 16:00:00	IWM	ETF	114.84	114.92	114.78	114.9	1312028.0
2014-01-08 17:00:00	IWM	ETF	114.9	114.9	114.75	114.75	200.0
2014-01-08 19:00:00	IWM	ETF	114.78	114.78	114.78	114.78	1000.0
2014-01-08 08:00:00	DIA	ETF	164.58	164.75	164.55	164.69	4017.0
2014-01-08 09:00:00	DIA	ETF	164.65	164.83	163.93	164.26	2353313.0
2014-01-08 10:00:00	DIA	ETF	164.25	164.65	164.12	164.349	1121829.0
2014-01-08 11:00:00	DIA	ETF	164.35	164.55	164.15	164.5	560533.0
2014-01-08 12:00:00	DIA	ETF	164.5	164.54	164.24	164.285	421081.0
2014-01-08 13:00:00	DIA	ETF	164.3	164.42	164.12	164.35	674787.0
2014-01-08 14:00:00	DIA	ETF	164.34	164.48	164.09	164.198	1687241.0

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

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