PREVIEW / etf_1hour / 2013-09-23

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-09-23.parquet
  size:    207 KB
  rows:    6,413

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
2013-09-23 04:00:00	SPY	ETF	171.04	171.17	171.02	171.02	1700.0
2013-09-23 05:00:00	SPY	ETF	170.99	171.0	170.87	170.9	32376.0
2013-09-23 06:00:00	SPY	ETF	170.92	170.96	170.9	170.9	40600.0
2013-09-23 07:00:00	SPY	ETF	170.87	170.87	170.28	170.32	301510.0
2013-09-23 08:00:00	SPY	ETF	170.29	171.05	170.22	170.41	1129728.0
2013-09-23 09:00:00	SPY	ETF	170.42	170.65	170.06	170.09	14333391.0
2013-09-23 10:00:00	SPY	ETF	170.09	170.2	169.52	169.6	18660967.0
2013-09-23 11:00:00	SPY	ETF	169.61	169.82	169.39	169.63	15052779.0
2013-09-23 12:00:00	SPY	ETF	169.635	170.01	169.62	169.99	6538232.0
2013-09-23 13:00:00	SPY	ETF	169.99	170.18	169.76	170.175	8643399.0
2013-09-23 14:00:00	SPY	ETF	170.17	170.23	169.89	170.14	10582963.0
2013-09-23 15:00:00	SPY	ETF	170.14	170.15	169.78	169.93	16284071.0
2013-09-23 16:00:00	SPY	ETF	169.94	169.99	169.67	169.74	11110566.0
2013-09-23 17:00:00	SPY	ETF	169.75	170.033	169.71	169.77	141134.0
2013-09-23 18:00:00	SPY	ETF	169.74	169.82	169.74	169.81	20242.0
2013-09-23 19:00:00	SPY	ETF	169.78	169.78	169.67	169.7	61556.0
2013-09-23 04:00:00	QQQ	ETF	79.0	79.15	79.0	79.15	1500.0
2013-09-23 05:00:00	QQQ	ETF	79.15	79.16	79.1	79.12	28600.0
2013-09-23 06:00:00	QQQ	ETF	79.14	79.16	79.12	79.12	6200.0
2013-09-23 07:00:00	QQQ	ETF	79.1	79.1	78.8	78.81	70500.0
2013-09-23 08:00:00	QQQ	ETF	79.09	79.32	78.79	79.28	1462209.0
2013-09-23 09:00:00	QQQ	ETF	79.28	79.41	79.005	79.02	5082116.0
2013-09-23 10:00:00	QQQ	ETF	79.02	79.05	78.591	78.63	5668251.0
2013-09-23 11:00:00	QQQ	ETF	78.63	78.71	78.455	78.55	3758353.0
2013-09-23 12:00:00	QQQ	ETF	78.55	78.87	78.54	78.859	1998946.0
2013-09-23 13:00:00	QQQ	ETF	78.85	78.99	78.72	78.9899	2208388.0
2013-09-23 14:00:00	QQQ	ETF	78.99	79.03	78.78	78.9598	2607198.0
2013-09-23 15:00:00	QQQ	ETF	78.95	78.98	78.74	78.84	3779099.0
2013-09-23 16:00:00	QQQ	ETF	78.85	79.1799	78.73	78.74	2879800.0
2013-09-23 17:00:00	QQQ	ETF	78.8723	78.8723	78.76	78.8	141639.0
2013-09-23 18:00:00	QQQ	ETF	78.77	78.82	78.77	78.82	2620.0
2013-09-23 19:00:00	QQQ	ETF	78.78	78.78	78.75	78.76	8696.0
2013-09-23 04:00:00	IWM	ETF	106.86	106.86	106.86	106.86	100.0
2013-09-23 07:00:00	IWM	ETF	106.79	106.79	106.49	106.5	10300.0
2013-09-23 08:00:00	IWM	ETF	106.47	107.0	106.44	106.59	120333.0
2013-09-23 09:00:00	IWM	ETF	106.61	106.77	106.36	106.42	3611240.0
2013-09-23 10:00:00	IWM	ETF	106.41	106.54	105.83	105.91	7185116.0
2013-09-23 11:00:00	IWM	ETF	105.9099	106.17	105.8	106.03	3691556.0
2013-09-23 12:00:00	IWM	ETF	106.03	106.35	106.03	106.31	2741683.0
2013-09-23 13:00:00	IWM	ETF	106.31	106.72	106.21	106.71	4486082.0
2013-09-23 14:00:00	IWM	ETF	106.72	106.87	106.59	106.8	3965052.0
2013-09-23 15:00:00	IWM	ETF	106.79	106.84	106.51	106.65	7256872.0
2013-09-23 16:00:00	IWM	ETF	106.65	106.7452	106.5	106.56	3503352.0
2013-09-23 17:00:00	IWM	ETF	106.4652	106.55	106.4	106.46	593199.0
2013-09-23 18:00:00	IWM	ETF	106.57	106.57	106.56	106.57	600.0
2013-09-23 19:00:00	IWM	ETF	106.57	106.57	106.57	106.57	250.0
2013-09-23 05:00:00	DIA	ETF	154.55	154.55	154.55	154.55	100.0
2013-09-23 07:00:00	DIA	ETF	154.55	154.55	154.29	154.29	2161.0
2013-09-23 08:00:00	DIA	ETF	154.25	154.36	154.14	154.24	20739.0
2013-09-23 09:00:00	DIA	ETF	154.28	154.32	153.92	153.98	2130973.0

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

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