PREVIEW / etf_1hour / 2011-04-20

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-04-20.parquet
  size:    186 KB
  rows:    5,728

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-04-20 04:00:00	SPY	ETF	131.39	132.5	131.39	132.47	8940.0
2011-04-20 05:00:00	SPY	ETF	132.55	132.92	132.5	132.83	23875.0
2011-04-20 06:00:00	SPY	ETF	132.81	133.31	132.75	133.02	199485.0
2011-04-20 07:00:00	SPY	ETF	133.0	133.33	132.99	133.08	1590359.0
2011-04-20 08:00:00	SPY	ETF	133.02	133.16	133.02	133.03	2241509.0
2011-04-20 09:00:00	SPY	ETF	133.03	133.08	132.79	132.94	22131096.0
2011-04-20 10:00:00	SPY	ETF	132.95	133.39	132.88	133.23	20769791.0
2011-04-20 11:00:00	SPY	ETF	133.23	133.31	133.0	133.23	17334761.0
2011-04-20 12:00:00	SPY	ETF	133.23	133.26	132.93	132.95	18516463.0
2011-04-20 13:00:00	SPY	ETF	132.95	133.08	132.84	133.025	11815749.0
2011-04-20 14:00:00	SPY	ETF	133.03	133.09	132.87	133.01	9526066.0
2011-04-20 15:00:00	SPY	ETF	133.0	133.2	132.88	133.13	30098638.0
2011-04-20 16:00:00	SPY	ETF	133.13	133.8	133.1	133.77	18768890.0
2011-04-20 17:00:00	SPY	ETF	133.77	133.9	133.74	133.82	477737.0
2011-04-20 18:00:00	SPY	ETF	133.82	134.0	133.16	133.88	685087.0
2011-04-20 19:00:00	SPY	ETF	133.9	133.95	133.82	133.89	94219.0
2011-04-20 04:00:00	QQQ	ETF	57.16	57.3	57.16	57.3	3000.0
2011-04-20 06:00:00	QQQ	ETF	57.43	57.61	57.43	57.5	8081.0
2011-04-20 07:00:00	QQQ	ETF	57.5	57.63	57.48	57.48	431732.0
2011-04-20 08:00:00	QQQ	ETF	57.48	57.56	57.46	57.53	708832.0
2011-04-20 09:00:00	QQQ	ETF	57.54	57.71	57.52	57.6301	9170466.0
2011-04-20 10:00:00	QQQ	ETF	57.63	57.94	57.59	57.891	11238389.0
2011-04-20 11:00:00	QQQ	ETF	57.8994	57.92	57.76	57.8708	4162188.0
2011-04-20 12:00:00	QQQ	ETF	57.87	57.89	57.76	57.76	4515378.0
2011-04-20 13:00:00	QQQ	ETF	57.765	57.85	57.715	57.84	2800610.0
2011-04-20 14:00:00	QQQ	ETF	57.83	57.88	57.76	57.81	2994459.0
2011-04-20 15:00:00	QQQ	ETF	57.8199	57.9	57.69	57.88	10133275.0
2011-04-20 16:00:00	QQQ	ETF	57.88	58.32	57.7686	58.3	12400868.0
2011-04-20 17:00:00	QQQ	ETF	58.3	58.48	58.3	58.48	2700662.0
2011-04-20 18:00:00	QQQ	ETF	58.42	58.46	57.86	58.42	198835.0
2011-04-20 19:00:00	QQQ	ETF	58.42	58.49	58.4	58.43	76751.0
2011-04-20 04:00:00	IWM	ETF	82.76	83.0	82.76	83.0	1500.0
2011-04-20 05:00:00	IWM	ETF	83.4	83.51	83.4	83.48	1800.0
2011-04-20 06:00:00	IWM	ETF	83.41	83.73	83.4	83.57	12115.0
2011-04-20 07:00:00	IWM	ETF	83.56	83.78	83.55	83.61	68652.0
2011-04-20 08:00:00	IWM	ETF	83.61	83.64	83.42	83.54	451788.0
2011-04-20 09:00:00	IWM	ETF	83.54	83.68	83.25	83.32	9867955.0
2011-04-20 10:00:00	IWM	ETF	83.33	83.8301	83.28	83.75	7284327.0
2011-04-20 11:00:00	IWM	ETF	83.76	83.8	83.61	83.75	2356159.0
2011-04-20 12:00:00	IWM	ETF	83.75	83.751	83.4885	83.5	3618302.0
2011-04-20 13:00:00	IWM	ETF	83.5	83.57	83.29	83.47	4164615.0
2011-04-20 14:00:00	IWM	ETF	83.47	83.62	83.35	83.53	2417067.0
2011-04-20 15:00:00	IWM	ETF	83.53	83.88	83.44	83.88	10471470.0
2011-04-20 16:00:00	IWM	ETF	83.87	84.18	83.6416	84.15	2820243.0
2011-04-20 17:00:00	IWM	ETF	84.13	84.25	84.13	84.21	119656.0
2011-04-20 18:00:00	IWM	ETF	84.23	84.26	84.15	84.2	12802.0
2011-04-20 19:00:00	IWM	ETF	84.2	84.25	84.17	84.25	1506.0
2011-04-20 04:00:00	DIA	ETF	123.09	123.34	123.09	123.34	1500.0
2011-04-20 05:00:00	DIA	ETF	123.61	123.7	123.6	123.62	3380.0
2011-04-20 06:00:00	DIA	ETF	123.63	124.05	123.63	123.9	1100.0

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

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