PREVIEW / etf_1hour / 2013-03-15

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-03-15.parquet
  size:    195 KB
  rows:    6,135

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-03-15 04:00:00	SPY	ETF	156.41	156.41	155.89	155.98	39230.0
2013-03-15 05:00:00	SPY	ETF	155.98	155.98	155.82	155.88	7134.0
2013-03-15 06:00:00	SPY	ETF	155.85	155.95	155.81	155.85	46680.0
2013-03-15 07:00:00	SPY	ETF	155.88	156.02	155.85	156.01	339245.0
2013-03-15 08:00:00	SPY	ETF	155.88	156.15	155.88	156.09	933847.0
2013-03-15 09:00:00	SPY	ETF	156.09	156.12	155.44	155.45	23415961.0
2013-03-15 10:00:00	SPY	ETF	155.44	155.79	155.31	155.7	18220744.0
2013-03-15 11:00:00	SPY	ETF	155.71	155.95	155.69	155.885	13117055.0
2013-03-15 12:00:00	SPY	ETF	155.885	156.04	155.83	155.89	8052417.0
2013-03-15 13:00:00	SPY	ETF	155.89	155.91	155.8	155.805	6439648.0
2013-03-15 14:00:00	SPY	ETF	155.81	155.85	155.47	155.59	15276190.0
2013-03-15 15:00:00	SPY	ETF	155.59	155.84	155.53	155.84	22148185.0
2013-03-15 16:00:00	SPY	ETF	155.83	156.0272	155.35	155.76	11409218.0
2013-03-15 17:00:00	SPY	ETF	155.76	155.87	155.68	155.85	4864752.0
2013-03-15 18:00:00	SPY	ETF	155.83	155.87	155.79	155.82	83290.0
2013-03-15 19:00:00	SPY	ETF	155.79	155.83	155.77	155.77	10646.0
2013-03-15 04:00:00	QQQ	ETF	68.68	68.69	68.68	68.69	10300.0
2013-03-15 05:00:00	QQQ	ETF	68.7	68.7	68.65	68.65	298.0
2013-03-15 06:00:00	QQQ	ETF	68.65	68.67	68.65	68.67	24300.0
2013-03-15 07:00:00	QQQ	ETF	68.7	68.77	68.67	68.74	86380.0
2013-03-15 08:00:00	QQQ	ETF	68.76	68.81	68.74	68.78	166092.0
2013-03-15 09:00:00	QQQ	ETF	68.78	68.81	68.47	68.48	5617502.0
2013-03-15 10:00:00	QQQ	ETF	68.47	68.5699	68.391	68.501	3749224.0
2013-03-15 11:00:00	QQQ	ETF	68.51	68.68	68.49	68.615	2363888.0
2013-03-15 12:00:00	QQQ	ETF	68.601	68.7	68.57	68.625	1863639.0
2013-03-15 13:00:00	QQQ	ETF	68.63	68.64	68.58	68.58	1161266.0
2013-03-15 14:00:00	QQQ	ETF	68.5799	68.6	68.34	68.4	3953508.0
2013-03-15 15:00:00	QQQ	ETF	68.4	68.51	68.36	68.51	6126385.0
2013-03-15 16:00:00	QQQ	ETF	68.51	68.5217	68.41	68.48	2330605.0
2013-03-15 17:00:00	QQQ	ETF	68.49	68.51	68.48	68.51	2028.0
2013-03-15 18:00:00	QQQ	ETF	68.45	68.45	68.45	68.45	130.0
2013-03-15 19:00:00	QQQ	ETF	68.5	68.5	68.45	68.45	1010.0
2013-03-15 04:00:00	IWM	ETF	94.78	94.78	94.7	94.7	300.0
2013-03-15 07:00:00	IWM	ETF	94.7	94.72	94.7	94.72	4900.0
2013-03-15 08:00:00	IWM	ETF	94.71	94.8	94.71	94.8	200682.0
2013-03-15 09:00:00	IWM	ETF	94.75	94.77	94.45	94.45	5229794.0
2013-03-15 10:00:00	IWM	ETF	94.45	94.73	94.39	94.62	7410176.0
2013-03-15 11:00:00	IWM	ETF	94.628	94.85	94.61	94.7599	2980082.0
2013-03-15 12:00:00	IWM	ETF	94.76	94.93	94.73	94.825	1972370.0
2013-03-15 13:00:00	IWM	ETF	94.83	94.92	94.82	94.88	1439940.0
2013-03-15 14:00:00	IWM	ETF	94.88	94.96	94.58	94.67	6288360.0
2013-03-15 15:00:00	IWM	ETF	94.67	94.82	94.57	94.67	6035058.0
2013-03-15 16:00:00	IWM	ETF	94.68	94.75	94.62	94.65	1126273.0
2013-03-15 17:00:00	IWM	ETF	94.65	94.65	94.61	94.61	20534.0
2013-03-15 06:00:00	DIA	ETF	144.88	144.88	144.85	144.85	400.0
2013-03-15 07:00:00	DIA	ETF	144.89	144.91	144.89	144.91	7700.0
2013-03-15 08:00:00	DIA	ETF	144.91	145.01	144.87	144.97	23400.0
2013-03-15 09:00:00	DIA	ETF	144.96	144.96	144.45	144.49	2082882.0
2013-03-15 10:00:00	DIA	ETF	144.48	144.74	144.39	144.66	1997690.0
2013-03-15 11:00:00	DIA	ETF	144.655	144.89	144.635	144.75	884052.0

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

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