PREVIEW / etf_1hour / 2012-06-18

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-06-18.parquet
  size:    184 KB
  rows:    5,709

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-18 04:00:00	SPY	ETF	134.6	134.6	133.57	133.86	15177.0
2012-06-18 05:00:00	SPY	ETF	133.95	134.15	133.84	134.15	26640.0
2012-06-18 06:00:00	SPY	ETF	134.17	134.3	133.87	133.98	140078.0
2012-06-18 07:00:00	SPY	ETF	134.01	134.09	133.77	133.77	686536.0
2012-06-18 08:00:00	SPY	ETF	133.79	133.8996	133.45	133.54	2339169.0
2012-06-18 09:00:00	SPY	ETF	133.56	133.99	133.28	133.86	21420975.0
2012-06-18 10:00:00	SPY	ETF	133.88	134.57	133.74	134.24	24056537.0
2012-06-18 11:00:00	SPY	ETF	134.24	134.26	133.85	134.19	19610832.0
2012-06-18 12:00:00	SPY	ETF	134.18	134.36	134.0	134.139	9482715.0
2012-06-18 13:00:00	SPY	ETF	134.13	134.54	134.06	134.5	8788349.0
2012-06-18 14:00:00	SPY	ETF	134.51	134.73	134.38	134.47	12383458.0
2012-06-18 15:00:00	SPY	ETF	134.45	134.58	134.16	134.42	21181579.0
2012-06-18 16:00:00	SPY	ETF	134.41	134.77	133.9078	134.71	7562976.0
2012-06-18 17:00:00	SPY	ETF	134.71	134.77	134.64	134.66	86715.0
2012-06-18 18:00:00	SPY	ETF	134.67	134.67	134.57	134.58	99878.0
2012-06-18 19:00:00	SPY	ETF	134.6	134.76	134.6	134.76	110857.0
2012-06-18 07:00:00	QQQ	ETF	62.98	63.02	62.92	62.92	46056.0
2012-06-18 08:00:00	QQQ	ETF	62.9	63.47	62.69	62.74	321174.0
2012-06-18 09:00:00	QQQ	ETF	62.73	63.18	62.63	63.11	5097733.0
2012-06-18 10:00:00	QQQ	ETF	63.11	63.52	63.07	63.34	7330891.0
2012-06-18 11:00:00	QQQ	ETF	63.35	63.39	63.13	63.38	5124700.0
2012-06-18 12:00:00	QQQ	ETF	63.37	63.465	63.27	63.365	2101058.0
2012-06-18 13:00:00	QQQ	ETF	63.3601	63.66	63.33	63.6482	2571113.0
2012-06-18 14:00:00	QQQ	ETF	63.65	63.74	63.56	63.61	2537464.0
2012-06-18 15:00:00	QQQ	ETF	63.62	63.7	63.47	63.57	5797778.0
2012-06-18 16:00:00	QQQ	ETF	63.56	63.67	63.1501	63.65	683612.0
2012-06-18 17:00:00	QQQ	ETF	63.65	63.77	63.65	63.7	188003.0
2012-06-18 18:00:00	QQQ	ETF	63.69	63.7	63.65	63.66	9668.0
2012-06-18 19:00:00	QQQ	ETF	63.66	63.73	63.66	63.72	9915.0
2012-06-18 04:00:00	IWM	ETF	76.88	76.88	76.88	76.88	200.0
2012-06-18 05:00:00	IWM	ETF	76.82	77.0	76.79	77.0	1600.0
2012-06-18 07:00:00	IWM	ETF	76.89	76.91	76.72	76.8	66078.0
2012-06-18 08:00:00	IWM	ETF	76.76	76.78	76.56	76.59	152940.0
2012-06-18 09:00:00	IWM	ETF	76.58	76.98	76.35	76.81	6340830.0
2012-06-18 10:00:00	IWM	ETF	76.82	77.56	76.74	77.26	7875070.0
2012-06-18 11:00:00	IWM	ETF	77.26	77.3	76.87	77.07	6620409.0
2012-06-18 12:00:00	IWM	ETF	77.06	77.29	76.9	77.0201	3372575.0
2012-06-18 13:00:00	IWM	ETF	77.02	77.46	76.98	77.44	3529719.0
2012-06-18 14:00:00	IWM	ETF	77.45	77.6	77.3	77.37	3935614.0
2012-06-18 15:00:00	IWM	ETF	77.38	77.5	77.1	77.28	8125783.0
2012-06-18 16:00:00	IWM	ETF	77.28	77.46	77.0043	77.45	1549615.0
2012-06-18 17:00:00	IWM	ETF	77.45	77.45	77.35	77.39	22100.0
2012-06-18 18:00:00	IWM	ETF	77.36	77.36	77.36	77.36	200.0
2012-06-18 19:00:00	IWM	ETF	77.36	77.43	77.33	77.42	30750.0
2012-06-18 07:00:00	DIA	ETF	127.33	127.33	126.97	126.97	9700.0
2012-06-18 08:00:00	DIA	ETF	127.9	127.92	126.74	126.78	526213.0
2012-06-18 09:00:00	DIA	ETF	126.79	127.135	126.65	126.96	671304.0
2012-06-18 10:00:00	DIA	ETF	126.98	127.54	126.86	127.24	723708.0
2012-06-18 11:00:00	DIA	ETF	127.24	127.28	126.96	127.22	704982.0
2012-06-18 12:00:00	DIA	ETF	127.18	127.26	126.98	127.08	431830.0

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

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