PREVIEW / etf_1hour / 2013-06-18

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-06-18.parquet
  size:    203 KB
  rows:    6,312

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-06-18 04:00:00	SPY	ETF	164.75	164.96	164.75	164.75	7408.0
2013-06-18 05:00:00	SPY	ETF	164.8	165.07	164.8	165.02	33875.0
2013-06-18 06:00:00	SPY	ETF	164.96	164.98	164.8	164.92	46800.0
2013-06-18 07:00:00	SPY	ETF	164.88	164.93	164.57	164.68	196848.0
2013-06-18 08:00:00	SPY	ETF	164.85	164.91	164.5	164.58	684188.0
2013-06-18 09:00:00	SPY	ETF	164.59	164.96	164.43	164.74	10207344.0
2013-06-18 10:00:00	SPY	ETF	164.745	165.39	164.64	165.33	13088340.0
2013-06-18 11:00:00	SPY	ETF	165.33	165.69	165.18	165.4	13794039.0
2013-06-18 12:00:00	SPY	ETF	165.39	165.78	165.29	165.75	9106019.0
2013-06-18 13:00:00	SPY	ETF	165.74	165.78	165.42	165.71	7190378.0
2013-06-18 14:00:00	SPY	ETF	165.7093	165.99	165.56	165.93	12258584.0
2013-06-18 15:00:00	SPY	ETF	165.92	165.94	165.5	165.74	24988870.0
2013-06-18 16:00:00	SPY	ETF	165.74	165.86	165.5774	165.79	9100675.0
2013-06-18 17:00:00	SPY	ETF	165.8	165.85	165.8	165.8	637121.0
2013-06-18 18:00:00	SPY	ETF	165.79	165.85	165.75	165.8	53907.0
2013-06-18 19:00:00	SPY	ETF	165.78	165.8	165.72	165.74	49256.0
2013-06-18 04:00:00	QQQ	ETF	73.08	73.16	73.07	73.07	3200.0
2013-06-18 05:00:00	QQQ	ETF	73.08	73.19	73.08	73.16	2100.0
2013-06-18 06:00:00	QQQ	ETF	73.13	73.13	73.1	73.13	2200.0
2013-06-18 07:00:00	QQQ	ETF	73.1	73.1	73.01	73.06	3950.0
2013-06-18 08:00:00	QQQ	ETF	73.05	73.19	73.01	73.06	48882.0
2013-06-18 09:00:00	QQQ	ETF	73.06	73.3399	73.04	73.24	2807027.0
2013-06-18 10:00:00	QQQ	ETF	73.23	73.6	73.2	73.55	3829164.0
2013-06-18 11:00:00	QQQ	ETF	73.55	73.69	73.49	73.54	2980951.0
2013-06-18 12:00:00	QQQ	ETF	73.54	73.64	73.45	73.62	1544203.0
2013-06-18 13:00:00	QQQ	ETF	73.63	73.64	73.515	73.61	1811899.0
2013-06-18 14:00:00	QQQ	ETF	73.6	73.72	73.53	73.719	1883137.0
2013-06-18 15:00:00	QQQ	ETF	73.71	73.71	73.49	73.57	5750066.0
2013-06-18 16:00:00	QQQ	ETF	73.57	73.6358	73.38	73.61	1425188.0
2013-06-18 17:00:00	QQQ	ETF	73.62	73.64	73.58	73.64	18463.0
2013-06-18 18:00:00	QQQ	ETF	73.59	73.63	73.57	73.57	7300.0
2013-06-18 19:00:00	QQQ	ETF	73.59	73.59	73.58	73.59	6760.0
2013-06-18 05:00:00	IWM	ETF	98.75	98.85	98.75	98.85	400.0
2013-06-18 06:00:00	IWM	ETF	98.58	98.68	98.58	98.68	800.0
2013-06-18 07:00:00	IWM	ETF	98.64	98.66	98.51	98.53	21600.0
2013-06-18 08:00:00	IWM	ETF	98.53	98.74	98.52	98.54	124749.0
2013-06-18 09:00:00	IWM	ETF	98.56	98.81	98.45	98.48	3478574.0
2013-06-18 10:00:00	IWM	ETF	98.48	98.89	98.47	98.84	2872187.0
2013-06-18 11:00:00	IWM	ETF	98.85	99.1	98.78	98.97	2262607.0
2013-06-18 12:00:00	IWM	ETF	98.97	99.51	98.88	99.47	3630098.0
2013-06-18 13:00:00	IWM	ETF	99.465	99.68	99.32	99.68	3030481.0
2013-06-18 14:00:00	IWM	ETF	99.68	99.8	99.58	99.705	3206207.0
2013-06-18 15:00:00	IWM	ETF	99.7	99.71	99.41	99.5	8677891.0
2013-06-18 16:00:00	IWM	ETF	99.5	99.67	99.45	99.61	2116486.0
2013-06-18 17:00:00	IWM	ETF	99.64	99.68	99.56	99.66	29175.0
2013-06-18 18:00:00	IWM	ETF	99.6	99.6	99.56	99.56	1570.0
2013-06-18 19:00:00	IWM	ETF	99.57	99.57	99.57	99.57	1100.0
2013-06-18 04:00:00	DIA	ETF	152.26	152.26	152.26	152.26	100.0
2013-06-18 07:00:00	DIA	ETF	151.93	152.04	151.93	152.04	2200.0
2013-06-18 08:00:00	DIA	ETF	152.01	152.13	152.01	152.13	2458.0

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

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