PREVIEW / etf_1hour / 2014-03-11

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-03-11.parquet
  size:    213 KB
  rows:    6,665

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-03-11 04:00:00	SPY	ETF	188.14	188.21	188.07	188.14	14800.0
2014-03-11 05:00:00	SPY	ETF	188.09	188.11	187.9	188.0	10865.0
2014-03-11 06:00:00	SPY	ETF	188.03	188.14	187.92	188.14	46768.0
2014-03-11 07:00:00	SPY	ETF	188.09	188.18	188.02	188.05	128597.0
2014-03-11 08:00:00	SPY	ETF	188.07	188.44	188.04	188.38	629277.0
2014-03-11 09:00:00	SPY	ETF	188.36	188.56	187.68	187.9301	10511449.0
2014-03-11 10:00:00	SPY	ETF	187.94	188.71	187.66	188.59	13640147.0
2014-03-11 11:00:00	SPY	ETF	188.6	188.65	187.842	187.94	10266295.0
2014-03-11 12:00:00	SPY	ETF	187.93	187.98	187.4	187.67	11912468.0
2014-03-11 13:00:00	SPY	ETF	187.66	187.78	187.27	187.75	9328966.0
2014-03-11 14:00:00	SPY	ETF	187.74	187.83	187.11	187.15	11509577.0
2014-03-11 15:00:00	SPY	ETF	187.15	187.3	186.8	187.2	21999314.0
2014-03-11 16:00:00	SPY	ETF	187.18	188.1467	186.92	186.95	6900902.0
2014-03-11 17:00:00	SPY	ETF	186.95	187.03	186.94	187.0	128255.0
2014-03-11 18:00:00	SPY	ETF	187.0	187.1	186.96	187.01	76967.0
2014-03-11 19:00:00	SPY	ETF	186.98	187.02	186.79	186.85	104233.0
2014-03-11 06:00:00	QQQ	ETF	90.55	90.61	90.54	90.61	2100.0
2014-03-11 07:00:00	QQQ	ETF	90.62	90.62	90.59	90.6	8435.0
2014-03-11 08:00:00	QQQ	ETF	90.61	90.78	90.6	90.77	84287.0
2014-03-11 09:00:00	QQQ	ETF	90.74	90.87	90.48	90.67	2234658.0
2014-03-11 10:00:00	QQQ	ETF	90.67	91.055	90.51	91.0	3581913.0
2014-03-11 11:00:00	QQQ	ETF	91.01	91.03	90.671	90.78	2168991.0
2014-03-11 12:00:00	QQQ	ETF	90.78	90.82	90.5	90.58	2422833.0
2014-03-11 13:00:00	QQQ	ETF	90.57	90.6	90.37	90.58	2436027.0
2014-03-11 14:00:00	QQQ	ETF	90.575	90.62	90.15	90.16	3143576.0
2014-03-11 15:00:00	QQQ	ETF	90.16	90.23	89.95	90.2199	5270108.0
2014-03-11 16:00:00	QQQ	ETF	90.22	90.6032	90.09	90.12	1377377.0
2014-03-11 17:00:00	QQQ	ETF	90.12	90.18	90.12	90.14	9120.0
2014-03-11 18:00:00	QQQ	ETF	90.15	90.18	90.11	90.13	6600.0
2014-03-11 19:00:00	QQQ	ETF	90.12	90.12	90.02	90.06	13165.0
2014-03-11 05:00:00	IWM	ETF	119.0	119.0	119.0	119.0	100.0
2014-03-11 07:00:00	IWM	ETF	119.18	119.2	119.07	119.1	117985.0
2014-03-11 08:00:00	IWM	ETF	119.12	119.41	119.1	119.34	338100.0
2014-03-11 09:00:00	IWM	ETF	119.35	119.5	118.66	119.0	5204757.0
2014-03-11 10:00:00	IWM	ETF	118.99	119.805	118.62	119.64	4924321.0
2014-03-11 11:00:00	IWM	ETF	119.63	119.65	118.82	118.95	2999638.0
2014-03-11 12:00:00	IWM	ETF	118.94	118.94	118.26	118.6	5965531.0
2014-03-11 13:00:00	IWM	ETF	118.6	118.67	118.23	118.62	3799738.0
2014-03-11 14:00:00	IWM	ETF	118.62	118.66	117.735	117.86	7307370.0
2014-03-11 15:00:00	IWM	ETF	117.85	118.06	117.51	118.04	9030550.0
2014-03-11 16:00:00	IWM	ETF	118.03	119.3002	117.84	117.84	3859021.0
2014-03-11 17:00:00	IWM	ETF	117.83	117.91	117.82	117.91	6700.0
2014-03-11 18:00:00	IWM	ETF	117.92	117.94	117.87	117.87	4800.0
2014-03-11 19:00:00	IWM	ETF	117.88	117.88	117.75	117.75	11862.0
2014-03-11 08:00:00	DIA	ETF	164.02	164.23	163.98	164.17	5417.0
2014-03-11 09:00:00	DIA	ETF	164.11	164.32	163.58	163.81	592030.0
2014-03-11 10:00:00	DIA	ETF	163.8	164.49	163.63	164.398	731751.0
2014-03-11 11:00:00	DIA	ETF	164.4	164.44	163.75	163.86	749193.0
2014-03-11 12:00:00	DIA	ETF	163.86	163.91	163.45	163.66	552039.0
2014-03-11 13:00:00	DIA	ETF	163.66	163.76	163.38	163.74	460209.0

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

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