PREVIEW / etf_1hour / 2013-09-20

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-09-20.parquet
  size:    209 KB
  rows:    6,530

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-20 04:00:00	SPY	ETF	172.12	172.5	172.08	172.08	13013.0
2013-09-20 05:00:00	SPY	ETF	172.05	172.2	171.99	172.13	9119.0
2013-09-20 06:00:00	SPY	ETF	172.14	172.2	172.05	172.17	19895.0
2013-09-20 07:00:00	SPY	ETF	172.18	172.27	172.03	172.03	315968.0
2013-09-20 08:00:00	SPY	ETF	172.05	172.24	171.79	172.0	1163716.0
2013-09-20 09:00:00	SPY	ETF	172.01	172.37	171.745	171.86	20365663.0
2013-09-20 10:00:00	SPY	ETF	171.86	172.1069	171.6	171.87	15551706.0
2013-09-20 11:00:00	SPY	ETF	171.87	172.3	171.22	171.25	14021783.0
2013-09-20 12:00:00	SPY	ETF	171.245	171.42	171.1	171.38	11771398.0
2013-09-20 13:00:00	SPY	ETF	171.38	171.42	170.96	170.98	9228730.0
2013-09-20 14:00:00	SPY	ETF	170.98	171.16	170.84	171.02	13729396.0
2013-09-20 15:00:00	SPY	ETF	171.025	171.13	170.58	170.71	30623842.0
2013-09-20 16:00:00	SPY	ETF	170.71	172.15	170.58	170.88	6125409.0
2013-09-20 17:00:00	SPY	ETF	170.86	170.92	170.72	170.73	2057625.0
2013-09-20 18:00:00	SPY	ETF	170.72	170.73	170.57	170.61	122521.0
2013-09-20 19:00:00	SPY	ETF	170.65	171.2215	170.61	170.64	189964.0
2013-09-20 04:00:00	QQQ	ETF	79.41	79.41	79.39	79.39	200.0
2013-09-20 05:00:00	QQQ	ETF	79.46	79.46	79.4	79.4	6400.0
2013-09-20 06:00:00	QQQ	ETF	79.4	79.4	79.4	79.4	200.0
2013-09-20 07:00:00	QQQ	ETF	79.4	79.42	79.37	79.37	19500.0
2013-09-20 08:00:00	QQQ	ETF	79.39	79.42	79.29	79.41	164584.0
2013-09-20 09:00:00	QQQ	ETF	79.4	79.52	79.29	79.33	3730972.0
2013-09-20 10:00:00	QQQ	ETF	79.33	79.54	79.3	79.45	3684586.0
2013-09-20 11:00:00	QQQ	ETF	79.445	79.47	79.1	79.12	2479816.0
2013-09-20 12:00:00	QQQ	ETF	79.12	79.26	79.06	79.24	2178059.0
2013-09-20 13:00:00	QQQ	ETF	79.25	79.27	79.02	79.07	2478449.0
2013-09-20 14:00:00	QQQ	ETF	79.07	79.17	78.99	79.1	2053803.0
2013-09-20 15:00:00	QQQ	ETF	79.09	79.14	78.95	78.99	5690411.0
2013-09-20 16:00:00	QQQ	ETF	78.98	79.48	78.93	78.96	1258207.0
2013-09-20 17:00:00	QQQ	ETF	78.96	78.98	78.82	78.85	299793.0
2013-09-20 18:00:00	QQQ	ETF	78.85	78.88	78.85	78.88	3260.0
2013-09-20 19:00:00	QQQ	ETF	78.85	79.2227	78.82	78.82	142083.0
2013-09-20 04:00:00	IWM	ETF	107.07	107.07	107.07	107.07	265.0
2013-09-20 07:00:00	IWM	ETF	107.07	107.19	107.03	107.05	343610.0
2013-09-20 08:00:00	IWM	ETF	107.04	107.07	106.9	107.07	908622.0
2013-09-20 09:00:00	IWM	ETF	107.04	107.34	106.875	107.04	5010409.0
2013-09-20 10:00:00	IWM	ETF	107.04	107.16	106.84	107.08	4395099.0
2013-09-20 11:00:00	IWM	ETF	107.0762	107.13	106.86	106.8705	3690464.0
2013-09-20 12:00:00	IWM	ETF	106.88	107.13	106.87	107.12	3724660.0
2013-09-20 13:00:00	IWM	ETF	107.12	107.17	106.89	106.91	3828421.0
2013-09-20 14:00:00	IWM	ETF	106.905	107.03	106.71	106.925	5097278.0
2013-09-20 15:00:00	IWM	ETF	106.92	107.01	106.55	106.59	8823921.0
2013-09-20 16:00:00	IWM	ETF	106.58	106.9402	106.56	106.72	4314996.0
2013-09-20 17:00:00	IWM	ETF	106.72	106.75	106.67	106.67	13232.0
2013-09-20 18:00:00	IWM	ETF	106.6	106.6	106.6	106.6	100.0
2013-09-20 19:00:00	IWM	ETF	106.9161	106.9161	106.9161	106.9161	414469.0
2013-09-20 04:00:00	DIA	ETF	156.14	156.15	156.12	156.14	12200.0
2013-09-20 07:00:00	DIA	ETF	155.91	156.23	155.91	156.23	3000.0
2013-09-20 08:00:00	DIA	ETF	155.87	155.91	155.8	155.9	4151.0
2013-09-20 09:00:00	DIA	ETF	155.96	156.24	155.69	155.771	1014539.0

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

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