PREVIEW / etf_1hour / 2011-06-03

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-06-03.parquet
  size:    182 KB
  rows:    5,608

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-06-03 04:00:00	SPY	ETF	131.52	131.53	131.41	131.45	5000.0
2011-06-03 05:00:00	SPY	ETF	131.5	131.5	131.36	131.36	650.0
2011-06-03 06:00:00	SPY	ETF	131.39	131.4	131.1	131.23	73558.0
2011-06-03 07:00:00	SPY	ETF	131.3	131.46	131.24	131.4	387350.0
2011-06-03 08:00:00	SPY	ETF	131.3	131.55	129.97	130.24	13996429.0
2011-06-03 09:00:00	SPY	ETF	130.24	130.65	130.04	130.54	29648554.0
2011-06-03 10:00:00	SPY	ETF	130.54	131.28	130.51	131.03	45300599.0
2011-06-03 11:00:00	SPY	ETF	131.03	131.16	130.62	130.99	26032805.0
2011-06-03 12:00:00	SPY	ETF	131.0	131.42	130.88	131.21	16844894.0
2011-06-03 13:00:00	SPY	ETF	131.21	131.26	130.93	130.96	9800436.0
2011-06-03 14:00:00	SPY	ETF	130.95	130.97	130.58	130.6	15888155.0
2011-06-03 15:00:00	SPY	ETF	130.605	130.8	130.27	130.43	39275996.0
2011-06-03 16:00:00	SPY	ETF	130.42	131.7117	130.07	130.28	24110177.0
2011-06-03 17:00:00	SPY	ETF	130.27	131.7117	130.26	130.3	6151442.0
2011-06-03 18:00:00	SPY	ETF	130.27	130.4	130.25	130.25	179405.0
2011-06-03 19:00:00	SPY	ETF	130.25	130.32	130.25	130.29	54744.0
2011-06-03 04:00:00	QQQ	ETF	57.05	57.05	57.05	57.05	100.0
2011-06-03 05:00:00	QQQ	ETF	57.02	57.02	57.02	57.02	100.0
2011-06-03 06:00:00	QQQ	ETF	57.0	57.0	56.93	56.93	320.0
2011-06-03 07:00:00	QQQ	ETF	56.95	57.02	56.95	57.02	56833.0
2011-06-03 08:00:00	QQQ	ETF	57.01	57.02	56.47	56.6	2062789.0
2011-06-03 09:00:00	QQQ	ETF	56.6	56.8	56.52	56.7	6605218.0
2011-06-03 10:00:00	QQQ	ETF	56.6906	56.99	56.66	56.93	8372361.0
2011-06-03 11:00:00	QQQ	ETF	56.92	56.94	56.68	56.79	5393187.0
2011-06-03 12:00:00	QQQ	ETF	56.8	56.88	56.77	56.8	2479107.0
2011-06-03 13:00:00	QQQ	ETF	56.8	56.849	56.68	56.7	2882537.0
2011-06-03 14:00:00	QQQ	ETF	56.695	56.7	56.5	56.515	3738530.0
2011-06-03 15:00:00	QQQ	ETF	56.51	56.54	56.27	56.358	12841736.0
2011-06-03 16:00:00	QQQ	ETF	56.35	56.37	56.19	56.28	4463726.0
2011-06-03 17:00:00	QQQ	ETF	56.28	56.31	56.26	56.3	9945.0
2011-06-03 18:00:00	QQQ	ETF	56.3	56.35	56.28	56.3	70173.0
2011-06-03 19:00:00	QQQ	ETF	56.28	56.3	56.28	56.3	20314.0
2011-06-03 04:00:00	IWM	ETF	81.9	81.9	81.9	81.9	100.0
2011-06-03 05:00:00	IWM	ETF	81.78	81.78	81.78	81.78	200.0
2011-06-03 06:00:00	IWM	ETF	81.72	81.72	81.5	81.5	1400.0
2011-06-03 07:00:00	IWM	ETF	81.6	81.71	81.6	81.71	23200.0
2011-06-03 08:00:00	IWM	ETF	81.71	81.74	80.7	80.84	2330073.0
2011-06-03 09:00:00	IWM	ETF	80.84	81.195	80.69	81.04	9613246.0
2011-06-03 10:00:00	IWM	ETF	81.05	81.73	80.99	81.52	11870499.0
2011-06-03 11:00:00	IWM	ETF	81.52	81.57	80.94	81.327	8499260.0
2011-06-03 12:00:00	IWM	ETF	81.33	81.56	81.19	81.44	4267778.0
2011-06-03 13:00:00	IWM	ETF	81.44	81.49	81.21	81.21	3073160.0
2011-06-03 14:00:00	IWM	ETF	81.21	81.215	80.85	80.87	4826678.0
2011-06-03 15:00:00	IWM	ETF	80.87	81.1	80.72	80.88	10376956.0
2011-06-03 16:00:00	IWM	ETF	80.88	80.9	80.74	80.82	1935315.0
2011-06-03 17:00:00	IWM	ETF	80.81	80.81	80.74	80.74	21220.0
2011-06-03 18:00:00	IWM	ETF	80.81	80.89	80.81	80.89	4340.0
2011-06-03 19:00:00	IWM	ETF	80.84	80.85	80.75	80.85	2740.0
2011-06-03 05:00:00	DIA	ETF	122.03	122.03	122.03	122.03	200.0
2011-06-03 06:00:00	DIA	ETF	121.95	121.95	121.9	121.9	7500.0

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

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