PREVIEW / etf_1hour / 2014-03-06

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-03-06.parquet
  size:    215 KB
  rows:    6,794

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-06 04:00:00	SPY	ETF	188.26	188.26	188.07	188.09	35372.0
2014-03-06 05:00:00	SPY	ETF	188.09	188.14	188.05	188.07	4862.0
2014-03-06 06:00:00	SPY	ETF	188.11	188.15	187.95	188.02	22220.0
2014-03-06 07:00:00	SPY	ETF	188.0	188.14	187.92	188.07	318161.0
2014-03-06 08:00:00	SPY	ETF	188.04	188.25	187.9	188.11	1072026.0
2014-03-06 09:00:00	SPY	ETF	188.12	188.61	188.09	188.56	11545203.0
2014-03-06 10:00:00	SPY	ETF	188.56	188.58	188.11	188.47	13356742.0
2014-03-06 11:00:00	SPY	ETF	188.475	188.52	188.3305	188.5	5708893.0
2014-03-06 12:00:00	SPY	ETF	188.505	188.6	188.45	188.52	5336419.0
2014-03-06 13:00:00	SPY	ETF	188.51	188.56	187.93	187.97	10816458.0
2014-03-06 14:00:00	SPY	ETF	187.97	188.35	187.89	188.265	10556391.0
2014-03-06 15:00:00	SPY	ETF	188.27	188.42	187.99	188.18	15416240.0
2014-03-06 16:00:00	SPY	ETF	188.19	188.21	187.7796	188.14	7285970.0
2014-03-06 17:00:00	SPY	ETF	188.16	188.21	188.1	188.1	78716.0
2014-03-06 18:00:00	SPY	ETF	188.12	188.34	188.12	188.26	123682.0
2014-03-06 19:00:00	SPY	ETF	188.29	188.33	188.22	188.24	60445.0
2014-03-06 04:00:00	QQQ	ETF	91.24	91.3	91.22	91.22	10100.0
2014-03-06 05:00:00	QQQ	ETF	91.2	91.2	91.2	91.2	100.0
2014-03-06 06:00:00	QQQ	ETF	91.21	91.21	91.21	91.21	3500.0
2014-03-06 07:00:00	QQQ	ETF	91.2	91.25	91.18	91.19	76600.0
2014-03-06 08:00:00	QQQ	ETF	91.22	91.28	91.15	91.19	110231.0
2014-03-06 09:00:00	QQQ	ETF	91.21	91.335	91.18	91.24	3252257.0
2014-03-06 10:00:00	QQQ	ETF	91.24	91.25	91.03	91.24	3473617.0
2014-03-06 11:00:00	QQQ	ETF	91.239	91.2801	91.15	91.27	2189780.0
2014-03-06 12:00:00	QQQ	ETF	91.2763	91.3	91.16	91.1801	1471019.0
2014-03-06 13:00:00	QQQ	ETF	91.1801	91.22	90.7	90.71	3304052.0
2014-03-06 14:00:00	QQQ	ETF	90.7	91.01	90.65	90.96	2877052.0
2014-03-06 15:00:00	QQQ	ETF	90.97	91.05	90.8104	90.96	4642307.0
2014-03-06 16:00:00	QQQ	ETF	90.96	91.2409	90.8932	90.99	1512126.0
2014-03-06 17:00:00	QQQ	ETF	91.0	91.04	91.0	91.01	5570.0
2014-03-06 18:00:00	QQQ	ETF	91.01	91.03	90.96	91.02	19503.0
2014-03-06 19:00:00	QQQ	ETF	91.03	91.03	90.98	90.99	1400.0
2014-03-06 05:00:00	IWM	ETF	120.1	120.27	120.1	120.11	1300.0
2014-03-06 06:00:00	IWM	ETF	120.0	120.0	119.98	119.98	10000.0
2014-03-06 07:00:00	IWM	ETF	120.11	120.17	120.0	120.05	93700.0
2014-03-06 08:00:00	IWM	ETF	120.05	120.19	119.94	119.98	211080.0
2014-03-06 09:00:00	IWM	ETF	120.03	120.25	119.91	120.14	4515676.0
2014-03-06 10:00:00	IWM	ETF	120.15	120.15	119.57	119.8	6124565.0
2014-03-06 11:00:00	IWM	ETF	119.805	119.99	119.71	119.97	3494084.0
2014-03-06 12:00:00	IWM	ETF	119.96	120.0	119.85	119.93	1695749.0
2014-03-06 13:00:00	IWM	ETF	119.93	119.99	119.42	119.47	3587356.0
2014-03-06 14:00:00	IWM	ETF	119.46	119.87	119.43	119.8601	2927936.0
2014-03-06 15:00:00	IWM	ETF	119.87	119.94	119.58	119.74	5295610.0
2014-03-06 16:00:00	IWM	ETF	119.74	119.8209	119.65	119.81	2358457.0
2014-03-06 17:00:00	IWM	ETF	119.81	119.83	119.77	119.77	3500.0
2014-03-06 18:00:00	IWM	ETF	119.71	119.83	119.71	119.83	2318.0
2014-03-06 19:00:00	IWM	ETF	119.8	119.83	119.8	119.83	2900.0
2014-03-06 07:00:00	DIA	ETF	163.75	163.75	163.75	163.75	2000.0
2014-03-06 08:00:00	DIA	ETF	163.79	163.83	163.55	163.7	13483.0
2014-03-06 09:00:00	DIA	ETF	163.77	164.2697	163.76	164.2697	578803.0

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

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