PREVIEW / etf_1hour / 2011-11-14

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-11-14.parquet
  size:    176 KB
  rows:    5,429

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-11-14 04:00:00	SPY	ETF	127.22	127.23	126.58	126.62	19446.0
2011-11-14 05:00:00	SPY	ETF	126.57	126.83	126.45	126.5	17000.0
2011-11-14 06:00:00	SPY	ETF	126.45	126.45	126.0	126.17	125508.0
2011-11-14 07:00:00	SPY	ETF	126.15	126.18	125.76	126.11	603422.0
2011-11-14 08:00:00	SPY	ETF	126.2	126.49	125.8916	126.27	3322063.0
2011-11-14 09:00:00	SPY	ETF	126.24	127.45	125.57	125.88	19798874.0
2011-11-14 10:00:00	SPY	ETF	125.89	126.22	125.6	125.96	22340681.0
2011-11-14 11:00:00	SPY	ETF	125.96	126.27	125.44	125.6	20585176.0
2011-11-14 12:00:00	SPY	ETF	125.59	125.66	125.03	125.33	24219005.0
2011-11-14 13:00:00	SPY	ETF	125.32	125.61	125.17	125.39	12642354.0
2011-11-14 14:00:00	SPY	ETF	125.39	125.6	124.92	124.94	12564836.0
2011-11-14 15:00:00	SPY	ETF	124.941	125.67	124.92	125.48	26749806.0
2011-11-14 16:00:00	SPY	ETF	125.47	126.6705	125.1	125.78	14155135.0
2011-11-14 17:00:00	SPY	ETF	125.78	126.6705	125.55	125.62	1193225.0
2011-11-14 18:00:00	SPY	ETF	125.62	125.74	125.46	125.72	141562.0
2011-11-14 19:00:00	SPY	ETF	125.72	125.91	125.72	125.87	152394.0
2011-11-14 04:00:00	QQQ	ETF	57.96	57.96	57.66	57.66	5000.0
2011-11-14 05:00:00	QQQ	ETF	57.62	57.66	57.62	57.66	1800.0
2011-11-14 06:00:00	QQQ	ETF	57.6	57.6	57.48	57.6	2900.0
2011-11-14 07:00:00	QQQ	ETF	57.58	57.65	57.48	57.65	43760.0
2011-11-14 08:00:00	QQQ	ETF	57.62	57.82	57.58	57.73	138153.0
2011-11-14 09:00:00	QQQ	ETF	57.71	57.82	57.5	57.71	4922446.0
2011-11-14 10:00:00	QQQ	ETF	57.7172	58.01	57.63	57.73	10135011.0
2011-11-14 11:00:00	QQQ	ETF	57.73	57.91	57.57	57.615	4563888.0
2011-11-14 12:00:00	QQQ	ETF	57.6	57.65	57.29	57.48	5207650.0
2011-11-14 13:00:00	QQQ	ETF	57.48	57.65	57.38	57.57	4824279.0
2011-11-14 14:00:00	QQQ	ETF	57.57	57.64	57.28	57.29	3449076.0
2011-11-14 15:00:00	QQQ	ETF	57.28	57.55	57.28	57.49	7288994.0
2011-11-14 16:00:00	QQQ	ETF	57.5	57.64	57.4565	57.63	1246881.0
2011-11-14 17:00:00	QQQ	ETF	57.63	57.65	57.59	57.61	27384.0
2011-11-14 18:00:00	QQQ	ETF	57.6	57.63	57.56	57.63	37040.0
2011-11-14 19:00:00	QQQ	ETF	57.63	57.68	57.61	57.68	59661.0
2011-11-14 04:00:00	IWM	ETF	74.43	74.43	74.29	74.29	1900.0
2011-11-14 05:00:00	IWM	ETF	74.46	74.46	74.24	74.24	11200.0
2011-11-14 06:00:00	IWM	ETF	74.11	74.17	73.89	74.17	13582.0
2011-11-14 07:00:00	IWM	ETF	74.01	74.02	73.8	74.0	63443.0
2011-11-14 08:00:00	IWM	ETF	73.99	74.23	73.9	74.12	311684.0
2011-11-14 09:00:00	IWM	ETF	74.1	74.27	73.66	73.93	4110437.0
2011-11-14 10:00:00	IWM	ETF	73.92	74.23	73.57	73.69	8615316.0
2011-11-14 11:00:00	IWM	ETF	73.69	73.93	73.26	73.37	4825422.0
2011-11-14 12:00:00	IWM	ETF	73.37	73.4	73.0	73.195	5489301.0
2011-11-14 13:00:00	IWM	ETF	73.19	73.48	73.01	73.31	4180595.0
2011-11-14 14:00:00	IWM	ETF	73.31	73.46	72.78	72.795	5862634.0
2011-11-14 15:00:00	IWM	ETF	72.79	73.39	72.77	73.28	10266911.0
2011-11-14 16:00:00	IWM	ETF	73.28	74.4428	73.2124	73.48	6957836.0
2011-11-14 17:00:00	IWM	ETF	73.49	73.5	73.43	73.44	30640.0
2011-11-14 18:00:00	IWM	ETF	73.4	73.4	73.39	73.39	1000.0
2011-11-14 19:00:00	IWM	ETF	73.47	73.55	73.47	73.5	2100.0
2011-11-14 04:00:00	DIA	ETF	121.8	121.8	121.8	121.8	1000.0
2011-11-14 06:00:00	DIA	ETF	121.15	121.15	121.15	121.15	1000.0

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

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