PREVIEW / etf_1hour / 2011-06-30

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-06-30.parquet
  size:    181 KB
  rows:    5,554

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-30 04:00:00	SPY	ETF	130.99	131.15	130.99	131.15	1650.0
2011-06-30 05:00:00	SPY	ETF	131.15	131.2	131.01	131.01	23200.0
2011-06-30 06:00:00	SPY	ETF	131.05	131.08	130.91	130.99	17600.0
2011-06-30 07:00:00	SPY	ETF	130.98	131.19	130.91	131.11	497240.0
2011-06-30 08:00:00	SPY	ETF	131.11	134.46	131.02	131.22	2479931.0
2011-06-30 09:00:00	SPY	ETF	131.21	131.79	130.99	131.53	34120337.0
2011-06-30 10:00:00	SPY	ETF	131.53	131.96	131.52	131.75	29548953.0
2011-06-30 11:00:00	SPY	ETF	131.75	132.07	131.74	132.005	24653226.0
2011-06-30 12:00:00	SPY	ETF	132.0	132.1	131.83	131.9	12065616.0
2011-06-30 13:00:00	SPY	ETF	131.89	131.98	131.69	131.86	15920971.0
2011-06-30 14:00:00	SPY	ETF	131.86	131.95	131.74	131.79	14719820.0
2011-06-30 15:00:00	SPY	ETF	131.79	132.18	131.67	131.97	50141763.0
2011-06-30 16:00:00	SPY	ETF	131.97	132.08	130.705	131.83	26956786.0
2011-06-30 17:00:00	SPY	ETF	131.83	132.04	131.82	132.02	7968152.0
2011-06-30 18:00:00	SPY	ETF	132.0	132.05	131.94	132.01	463131.0
2011-06-30 19:00:00	SPY	ETF	131.98	132.09	131.87	131.87	93422.0
2011-06-30 05:00:00	QQQ	ETF	56.48	56.53	56.48	56.52	800.0
2011-06-30 06:00:00	QQQ	ETF	56.42	56.45	56.42	56.45	700.0
2011-06-30 07:00:00	QQQ	ETF	56.45	56.54	56.41	56.52	57175.0
2011-06-30 08:00:00	QQQ	ETF	56.5	56.57	56.47	56.54	410609.0
2011-06-30 09:00:00	QQQ	ETF	56.54	56.8	56.45	56.73	8809461.0
2011-06-30 10:00:00	QQQ	ETF	56.7338	56.96	56.73	56.84	8386349.0
2011-06-30 11:00:00	QQQ	ETF	56.84	57.06	56.84	57.0119	6488459.0
2011-06-30 12:00:00	QQQ	ETF	57.02	57.06	56.92	56.99	3129634.0
2011-06-30 13:00:00	QQQ	ETF	56.985	57.02	56.89	56.97	2462070.0
2011-06-30 14:00:00	QQQ	ETF	56.97	57.01	56.92	56.97	2402488.0
2011-06-30 15:00:00	QQQ	ETF	56.97	57.09	56.91	57.03	9552323.0
2011-06-30 16:00:00	QQQ	ETF	57.03	57.06	56.97	56.98	3124269.0
2011-06-30 17:00:00	QQQ	ETF	56.98	57.0	56.95	56.95	238767.0
2011-06-30 18:00:00	QQQ	ETF	56.98	57.02	56.97	57.01	150702.0
2011-06-30 19:00:00	QQQ	ETF	57.02	57.05	57.01	57.03	15737.0
2011-06-30 04:00:00	IWM	ETF	82.51	82.51	82.51	82.51	149.0
2011-06-30 05:00:00	IWM	ETF	82.55	82.55	82.45	82.45	600.0
2011-06-30 07:00:00	IWM	ETF	82.39	82.51	82.39	82.46	11450.0
2011-06-30 08:00:00	IWM	ETF	82.45	82.48	82.3	82.43	398493.0
2011-06-30 09:00:00	IWM	ETF	82.42	82.84	82.28	82.6	11045741.0
2011-06-30 10:00:00	IWM	ETF	82.61	82.91	82.59	82.74	6336536.0
2011-06-30 11:00:00	IWM	ETF	82.74	83.0	82.73	82.941	5064076.0
2011-06-30 12:00:00	IWM	ETF	82.95	83.03	82.81	82.9106	3813818.0
2011-06-30 13:00:00	IWM	ETF	82.91	83.02	82.78	82.96	4606033.0
2011-06-30 14:00:00	IWM	ETF	82.95	83.05	82.87	82.91	4336678.0
2011-06-30 15:00:00	IWM	ETF	82.92	83.02	82.8	82.84	9796782.0
2011-06-30 16:00:00	IWM	ETF	82.84	82.94	82.75	82.75	2056877.0
2011-06-30 17:00:00	IWM	ETF	82.75	82.85	82.74	82.75	26408.0
2011-06-30 18:00:00	IWM	ETF	82.8	82.8	82.76	82.76	200.0
2011-06-30 19:00:00	IWM	ETF	82.85	82.85	82.85	82.85	4000.0
2011-06-30 04:00:00	DIA	ETF	122.85	122.87	122.83	122.87	10100.0
2011-06-30 05:00:00	DIA	ETF	122.86	122.89	122.86	122.89	3541.0
2011-06-30 07:00:00	DIA	ETF	122.72	122.9	122.7	122.87	10800.0
2011-06-30 08:00:00	DIA	ETF	122.84	122.93	122.8	122.93	24225.0

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

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