PREVIEW / etf_1hour / 2012-06-14

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-06-14.parquet
  size:    182 KB
  rows:    5,604

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
2012-06-14 04:00:00	SPY	ETF	132.5	132.5	132.1	132.1	2710.0
2012-06-14 05:00:00	SPY	ETF	132.1	132.28	131.96	132.08	59480.0
2012-06-14 06:00:00	SPY	ETF	132.11	132.56	132.05	132.4	147965.0
2012-06-14 07:00:00	SPY	ETF	132.4	132.46	131.96	132.11	679862.0
2012-06-14 08:00:00	SPY	ETF	132.1	132.57	131.8	132.4	2541657.0
2012-06-14 09:00:00	SPY	ETF	132.4	132.75	131.98	132.72	20147210.0
2012-06-14 10:00:00	SPY	ETF	132.72	133.08	132.57	133.01	24989166.0
2012-06-14 11:00:00	SPY	ETF	133.0	133.27	132.91	133.03	16917959.0
2012-06-14 12:00:00	SPY	ETF	133.03	133.28	132.95	133.2	15912780.0
2012-06-14 13:00:00	SPY	ETF	133.21	133.35	133.0	133.12	29490596.0
2012-06-14 14:00:00	SPY	ETF	133.12	133.27	132.66	132.68	20091318.0
2012-06-14 15:00:00	SPY	ETF	132.68	134.0	132.64	133.49	78910778.0
2012-06-14 16:00:00	SPY	ETF	133.51	134.1363	132.0693	133.96	19376805.0
2012-06-14 17:00:00	SPY	ETF	133.97	134.009	133.83	133.84	454069.0
2012-06-14 18:00:00	SPY	ETF	133.83	133.88	133.78	133.83	81374.0
2012-06-14 19:00:00	SPY	ETF	133.83	133.84	133.76	133.81	64451.0
2012-06-14 04:00:00	QQQ	ETF	62.24	62.24	62.24	62.24	1100.0
2012-06-14 05:00:00	QQQ	ETF	62.21	62.21	62.21	62.21	1700.0
2012-06-14 06:00:00	QQQ	ETF	62.16	62.3	62.16	62.29	17000.0
2012-06-14 07:00:00	QQQ	ETF	62.23	62.23	62.08	62.14	25580.0
2012-06-14 08:00:00	QQQ	ETF	62.14	62.31	62.0	62.26	96640.0
2012-06-14 09:00:00	QQQ	ETF	62.23	62.27	61.8	62.24	5138979.0
2012-06-14 10:00:00	QQQ	ETF	62.23	62.46	62.16	62.42	7352176.0
2012-06-14 11:00:00	QQQ	ETF	62.42	62.57	62.35	62.46	4725234.0
2012-06-14 12:00:00	QQQ	ETF	62.45	62.529	62.41	62.49	2600429.0
2012-06-14 13:00:00	QQQ	ETF	62.49	62.521	62.29	62.34	3550336.0
2012-06-14 14:00:00	QQQ	ETF	62.335	62.38	61.97	61.98	6775411.0
2012-06-14 15:00:00	QQQ	ETF	61.98	62.61	61.96	62.4	19224599.0
2012-06-14 16:00:00	QQQ	ETF	62.39	62.53	62.1109	62.51	7455857.0
2012-06-14 17:00:00	QQQ	ETF	62.52	62.52	62.47	62.5	25450.0
2012-06-14 18:00:00	QQQ	ETF	62.49	62.49	62.45	62.46	31500.0
2012-06-14 19:00:00	QQQ	ETF	62.46	62.47	62.42	62.46	17500.0
2012-06-14 04:00:00	IWM	ETF	75.4	75.4	75.4	75.4	500.0
2012-06-14 05:00:00	IWM	ETF	75.34	75.34	75.34	75.34	1000.0
2012-06-14 06:00:00	IWM	ETF	75.59	75.59	75.47	75.47	900.0
2012-06-14 07:00:00	IWM	ETF	75.47	75.54	75.22	75.31	8500.0
2012-06-14 08:00:00	IWM	ETF	75.28	75.56	75.01	75.46	198537.0
2012-06-14 09:00:00	IWM	ETF	75.44	75.92	75.16	75.89	4289950.0
2012-06-14 10:00:00	IWM	ETF	75.89	76.17	75.69	76.12	6068304.0
2012-06-14 11:00:00	IWM	ETF	76.13	76.22	75.98	76.02	3687157.0
2012-06-14 12:00:00	IWM	ETF	76.01	76.25	75.95	76.2	2457249.0
2012-06-14 13:00:00	IWM	ETF	76.21	76.25	75.91	76.06	2989984.0
2012-06-14 14:00:00	IWM	ETF	76.06	76.15	75.47	75.48	4600345.0
2012-06-14 15:00:00	IWM	ETF	75.49	76.47	75.44	76.24	19108695.0
2012-06-14 16:00:00	IWM	ETF	76.23	76.47	75.2945	76.47	1876079.0
2012-06-14 17:00:00	IWM	ETF	76.46	76.46	76.38	76.38	31600.0
2012-06-14 18:00:00	IWM	ETF	76.35	76.35	76.33	76.33	5000.0
2012-06-14 08:00:00	DIA	ETF	125.02	125.29	124.77	125.24	24400.0
2012-06-14 09:00:00	DIA	ETF	125.16	125.64	124.95	125.64	523111.0
2012-06-14 10:00:00	DIA	ETF	125.5905	126.0	125.53	125.95	956888.0

> showing 50 of 5,604 rows — these rows as CSV

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