PREVIEW / etf_1hour / 2014-05-29

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-05-29.parquet
  size:    211 KB
  rows:    6,747

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-29 04:00:00	SPY	ETF	191.65	191.65	191.56	191.63	5657.0
2014-05-29 05:00:00	SPY	ETF	191.5	191.62	191.5	191.62	3645.0
2014-05-29 06:00:00	SPY	ETF	191.63	191.68	191.54	191.68	10864.0
2014-05-29 07:00:00	SPY	ETF	191.69	191.69	191.56	191.57	150871.0
2014-05-29 08:00:00	SPY	ETF	191.59	192.08	191.48	191.78	715866.0
2014-05-29 09:00:00	SPY	ETF	191.78	191.96	191.66	191.81	7961831.0
2014-05-29 10:00:00	SPY	ETF	191.81	191.87	191.33	191.74	11871237.0
2014-05-29 11:00:00	SPY	ETF	191.75	191.9	191.65	191.73	5044252.0
2014-05-29 12:00:00	SPY	ETF	191.73	191.89	191.715	191.805	3683362.0
2014-05-29 13:00:00	SPY	ETF	191.8	191.89	191.74	191.8277	3118776.0
2014-05-29 14:00:00	SPY	ETF	191.82	192.2	191.79	192.1575	8507995.0
2014-05-29 15:00:00	SPY	ETF	192.17	192.38	192.1599	192.38	16399206.0
2014-05-29 16:00:00	SPY	ETF	192.37	192.4	192.0845	192.35	4115907.0
2014-05-29 17:00:00	SPY	ETF	192.35	192.36	192.28	192.3	106114.0
2014-05-29 18:00:00	SPY	ETF	192.3	192.34	192.28	192.3	99227.0
2014-05-29 19:00:00	SPY	ETF	192.29	192.32	192.26	192.3	107837.0
2014-05-29 04:00:00	QQQ	ETF	90.99	90.99	90.93	90.93	14349.0
2014-05-29 05:00:00	QQQ	ETF	90.94	90.94	90.93	90.93	7300.0
2014-05-29 06:00:00	QQQ	ETF	90.91	90.95	90.91	90.95	2300.0
2014-05-29 07:00:00	QQQ	ETF	90.94	90.96	90.93	90.95	99441.0
2014-05-29 08:00:00	QQQ	ETF	90.87	90.98	90.83	90.95	187388.0
2014-05-29 09:00:00	QQQ	ETF	90.98	91.14	90.88	91.09	3861948.0
2014-05-29 10:00:00	QQQ	ETF	91.08	91.12	90.86	91.06	3904173.0
2014-05-29 11:00:00	QQQ	ETF	91.07	91.19	90.98	91.0	2238658.0
2014-05-29 12:00:00	QQQ	ETF	91.0	91.11	90.963	91.06	1268847.0
2014-05-29 13:00:00	QQQ	ETF	91.05	91.1023	90.99	91.06	1124751.0
2014-05-29 14:00:00	QQQ	ETF	91.06	91.2	91.0301	91.19	1782580.0
2014-05-29 15:00:00	QQQ	ETF	91.2	91.31	91.12	91.3	8399809.0
2014-05-29 16:00:00	QQQ	ETF	91.3	91.37	90.736	91.35	9110829.0
2014-05-29 17:00:00	QQQ	ETF	91.34	91.39	91.34	91.37	12733.0
2014-05-29 18:00:00	QQQ	ETF	91.35	91.35	91.31	91.35	7050.0
2014-05-29 19:00:00	QQQ	ETF	91.33	91.34	91.32	91.34	8976.0
2014-05-29 04:00:00	IWM	ETF	113.4	113.4	113.4	113.4	100.0
2014-05-29 07:00:00	IWM	ETF	113.26	113.26	113.2	113.2	11000.0
2014-05-29 08:00:00	IWM	ETF	113.27	113.33	113.0	113.33	217275.0
2014-05-29 09:00:00	IWM	ETF	113.33	113.52	113.1	113.34	3466069.0
2014-05-29 10:00:00	IWM	ETF	113.331	113.34	112.7	113.27	6746897.0
2014-05-29 11:00:00	IWM	ETF	113.27	113.59	113.11	113.27	2143556.0
2014-05-29 12:00:00	IWM	ETF	113.27	113.45	113.22	113.33	1445058.0
2014-05-29 13:00:00	IWM	ETF	113.32	113.35	113.095	113.14	1193196.0
2014-05-29 14:00:00	IWM	ETF	113.135	113.42	113.0	113.27	2758983.0
2014-05-29 15:00:00	IWM	ETF	113.28	113.41	113.24	113.38	4003148.0
2014-05-29 16:00:00	IWM	ETF	113.37	113.47	113.36	113.45	726410.0
2014-05-29 17:00:00	IWM	ETF	113.47	113.47	113.47	113.47	400.0
2014-05-29 19:00:00	IWM	ETF	113.27	113.4	113.27	113.4	500.0
2014-05-29 08:00:00	DIA	ETF	166.23	166.48	166.23	166.48	1100.0
2014-05-29 09:00:00	DIA	ETF	166.5	166.57	166.321	166.41	401203.0
2014-05-29 10:00:00	DIA	ETF	166.39	166.46	166.03	166.3025	466716.0
2014-05-29 11:00:00	DIA	ETF	166.3	166.39	166.24	166.32	151785.0
2014-05-29 12:00:00	DIA	ETF	166.3202	166.4001	166.3	166.32	148535.0

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

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