PREVIEW / etf_1hour / 2011-07-18

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-07-18.parquet
  size:    183 KB
  rows:    5,632

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-18 04:00:00	SPY	ETF	131.85	131.85	131.0	131.2	11428.0
2011-07-18 05:00:00	SPY	ETF	131.06	131.21	131.05	131.05	25550.0
2011-07-18 06:00:00	SPY	ETF	131.04	131.12	130.85	130.96	51968.0
2011-07-18 07:00:00	SPY	ETF	130.98	131.14	130.6	131.03	2174819.0
2011-07-18 08:00:00	SPY	ETF	131.03	131.17	130.83	131.15	5752875.0
2011-07-18 09:00:00	SPY	ETF	131.15	131.29	130.63	130.77	17853031.0
2011-07-18 10:00:00	SPY	ETF	130.775	130.87	129.91	130.11	33171334.0
2011-07-18 11:00:00	SPY	ETF	130.1087	130.31	129.63	129.7199	21841291.0
2011-07-18 12:00:00	SPY	ETF	129.71	130.09	129.67	130.04	17462444.0
2011-07-18 13:00:00	SPY	ETF	130.03	130.4	129.79	130.355	14535017.0
2011-07-18 14:00:00	SPY	ETF	130.36	130.45	130.03	130.44	15201944.0
2011-07-18 15:00:00	SPY	ETF	130.44	130.65	130.21	130.6	40165758.0
2011-07-18 16:00:00	SPY	ETF	130.59	131.6721	130.1	130.64	18386558.0
2011-07-18 17:00:00	SPY	ETF	130.63	130.63	130.55	130.57	177237.0
2011-07-18 18:00:00	SPY	ETF	130.6	130.61	130.52	130.54	336920.0
2011-07-18 19:00:00	SPY	ETF	130.53	130.75	130.53	130.69	104890.0
2011-07-18 04:00:00	QQQ	ETF	57.53	57.58	57.53	57.56	1872.0
2011-07-18 05:00:00	QQQ	ETF	57.56	57.56	57.46	57.46	11000.0
2011-07-18 06:00:00	QQQ	ETF	57.4	57.4	57.35	57.35	1491.0
2011-07-18 07:00:00	QQQ	ETF	57.4	57.5	57.27	57.45	1292665.0
2011-07-18 08:00:00	QQQ	ETF	57.44	57.57	57.39	57.56	3004810.0
2011-07-18 09:00:00	QQQ	ETF	57.56	57.79	57.45	57.5	6387825.0
2011-07-18 10:00:00	QQQ	ETF	57.5	57.62	57.11	57.21	12030125.0
2011-07-18 11:00:00	QQQ	ETF	57.2	57.32	56.98	57.02	5119000.0
2011-07-18 12:00:00	QQQ	ETF	57.03	57.18	56.98	57.15	3484053.0
2011-07-18 13:00:00	QQQ	ETF	57.15	57.35	57.05	57.32	4392685.0
2011-07-18 14:00:00	QQQ	ETF	57.33	57.42	57.22	57.42	3716164.0
2011-07-18 15:00:00	QQQ	ETF	57.42	57.54	57.36	57.53	8388799.0
2011-07-18 16:00:00	QQQ	ETF	57.53	57.8	57.4	57.58	2126640.0
2011-07-18 17:00:00	QQQ	ETF	57.57	57.58	57.2601	57.52	201149.0
2011-07-18 18:00:00	QQQ	ETF	57.54	57.54	57.49	57.5	75620.0
2011-07-18 19:00:00	QQQ	ETF	57.51	57.57	57.49	57.55	19931.0
2011-07-18 05:00:00	IWM	ETF	82.5	82.5	82.5	82.5	100.0
2011-07-18 06:00:00	IWM	ETF	82.3	82.3	82.3	82.3	1500.0
2011-07-18 07:00:00	IWM	ETF	82.38	82.5	82.1	82.48	307345.0
2011-07-18 08:00:00	IWM	ETF	82.49	82.51	82.29	82.5	534689.0
2011-07-18 09:00:00	IWM	ETF	82.51	82.64	81.86	81.89	7217883.0
2011-07-18 10:00:00	IWM	ETF	81.9	82.02	81.21	81.37	13904461.0
2011-07-18 11:00:00	IWM	ETF	81.36	81.57	81.03	81.09	5982662.0
2011-07-18 12:00:00	IWM	ETF	81.09	81.37	81.0	81.34	2541871.0
2011-07-18 13:00:00	IWM	ETF	81.3501	81.64	81.12	81.61	3111298.0
2011-07-18 14:00:00	IWM	ETF	81.61	81.63	81.3	81.58	3588305.0
2011-07-18 15:00:00	IWM	ETF	81.585	81.74	81.41	81.51	9657407.0
2011-07-18 16:00:00	IWM	ETF	81.5	82.7768	81.35	81.63	4784133.0
2011-07-18 17:00:00	IWM	ETF	81.64	81.69	81.56	81.56	127478.0
2011-07-18 18:00:00	IWM	ETF	81.55	81.62	81.55	81.58	2600.0
2011-07-18 19:00:00	IWM	ETF	81.58	81.67	81.55	81.64	4100.0
2011-07-18 05:00:00	DIA	ETF	124.21	124.21	124.0	124.0	1000.0
2011-07-18 06:00:00	DIA	ETF	123.98	123.98	123.98	123.98	100.0
2011-07-18 07:00:00	DIA	ETF	123.97	124.03	123.75	124.03	4182.0

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

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