PREVIEW / etf_1hour / 2011-07-15

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-07-15.parquet
  size:    176 KB
  rows:    5,438

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
2011-07-15 04:00:00	SPY	ETF	131.01	131.22	130.92	131.21	1700.0
2011-07-15 05:00:00	SPY	ETF	131.08	131.39	131.08	131.36	2800.0
2011-07-15 06:00:00	SPY	ETF	131.19	131.36	131.17	131.24	33500.0
2011-07-15 07:00:00	SPY	ETF	131.25	131.56	131.17	131.48	310205.0
2011-07-15 08:00:00	SPY	ETF	131.44	131.69	131.24	131.57	3577627.0
2011-07-15 09:00:00	SPY	ETF	131.57	131.87	131.1	131.29	31561646.0
2011-07-15 10:00:00	SPY	ETF	131.29	131.74	130.77	131.04	46625622.0
2011-07-15 11:00:00	SPY	ETF	131.04	131.45	130.92	131.24	24335492.0
2011-07-15 12:00:00	SPY	ETF	131.24	131.71	131.1	131.235	23392265.0
2011-07-15 13:00:00	SPY	ETF	131.24	131.38	130.97	130.98	11841127.0
2011-07-15 14:00:00	SPY	ETF	130.98	131.209	130.84	131.03	17948470.0
2011-07-15 15:00:00	SPY	ETF	131.02	131.7101	130.94	131.71	33703002.0
2011-07-15 16:00:00	SPY	ETF	131.71	132.05	130.9404	132.02	19585036.0
2011-07-15 17:00:00	SPY	ETF	132.02	132.04	132.01	132.02	1364717.0
2011-07-15 18:00:00	SPY	ETF	132.02	132.04	131.67	132.0	1754589.0
2011-07-15 19:00:00	SPY	ETF	132.01	132.04	131.99	132.01	47999.0
2011-07-15 06:00:00	QQQ	ETF	57.5	57.5	57.49	57.49	800.0
2011-07-15 07:00:00	QQQ	ETF	57.47	57.59	57.46	57.57	99820.0
2011-07-15 08:00:00	QQQ	ETF	57.59	57.69	57.52	57.69	2709719.0
2011-07-15 09:00:00	QQQ	ETF	57.68	57.83	57.41	57.48	13941369.0
2011-07-15 10:00:00	QQQ	ETF	57.49	57.7	57.31	57.455	14377727.0
2011-07-15 11:00:00	QQQ	ETF	57.45	57.64	57.41	57.51	3558419.0
2011-07-15 12:00:00	QQQ	ETF	57.51	57.71	57.5	57.63	5137036.0
2011-07-15 13:00:00	QQQ	ETF	57.63	57.7	57.49	57.5	4494774.0
2011-07-15 14:00:00	QQQ	ETF	57.5	57.58	57.41	57.48	7069073.0
2011-07-15 15:00:00	QQQ	ETF	57.48	57.84	57.45	57.84	9046193.0
2011-07-15 16:00:00	QQQ	ETF	57.84	57.94	57.6656	57.88	1335205.0
2011-07-15 17:00:00	QQQ	ETF	57.89	57.96	57.89	57.93	61540.0
2011-07-15 18:00:00	QQQ	ETF	57.82	57.93	57.82	57.93	35577.0
2011-07-15 19:00:00	QQQ	ETF	57.92	57.93	57.91	57.93	3950.0
2011-07-15 07:00:00	IWM	ETF	82.54	82.64	82.54	82.64	13200.0
2011-07-15 08:00:00	IWM	ETF	82.6	82.9	81.9	82.6	1011511.0
2011-07-15 09:00:00	IWM	ETF	82.61	82.78	82.25	82.43	9901224.0
2011-07-15 10:00:00	IWM	ETF	82.43	82.81	82.24	82.51	11878182.0
2011-07-15 11:00:00	IWM	ETF	82.52	82.77	82.42	82.55	4878580.0
2011-07-15 12:00:00	IWM	ETF	82.56	82.91	82.49	82.6299	5508960.0
2011-07-15 13:00:00	IWM	ETF	82.63	82.74	82.44	82.47	2546227.0
2011-07-15 14:00:00	IWM	ETF	82.46	82.53	82.18	82.35	6742177.0
2011-07-15 15:00:00	IWM	ETF	82.34	82.81	82.3	82.78	10421536.0
2011-07-15 16:00:00	IWM	ETF	82.78	83.04	82.2296	82.98	5193916.0
2011-07-15 17:00:00	IWM	ETF	82.98	83.01	82.98	83.0	5995.0
2011-07-15 18:00:00	IWM	ETF	82.98	83.0	82.95	82.97	2050.0
2011-07-15 19:00:00	IWM	ETF	82.97	83.02	82.97	83.02	11800.0
2011-07-15 06:00:00	DIA	ETF	124.49	124.53	124.39	124.44	104100.0
2011-07-15 07:00:00	DIA	ETF	124.44	124.55	124.28	124.53	441100.0
2011-07-15 08:00:00	DIA	ETF	124.46	124.65	124.28	124.54	193750.0
2011-07-15 09:00:00	DIA	ETF	124.55	124.77	124.12	124.27	2057485.0
2011-07-15 10:00:00	DIA	ETF	124.29	124.66	123.78	124.03	1370585.0
2011-07-15 11:00:00	DIA	ETF	124.05	124.3755	123.92	124.15	647401.0
2011-07-15 12:00:00	DIA	ETF	124.15	124.58	124.03	124.1132	863781.0

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

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