PREVIEW / etf_1hour / 2011-02-15

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-02-15.parquet
  size:    172 KB
  rows:    5,361

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-02-15 04:00:00	SPY	ETF	133.15	133.23	133.13	133.13	6900.0
2011-02-15 05:00:00	SPY	ETF	133.21	133.33	133.21	133.28	3100.0
2011-02-15 06:00:00	SPY	ETF	133.28	133.28	133.2	133.25	83800.0
2011-02-15 07:00:00	SPY	ETF	133.24	133.25	133.02	133.03	1465398.0
2011-02-15 08:00:00	SPY	ETF	133.01	133.24	132.87	132.96	3141760.0
2011-02-15 09:00:00	SPY	ETF	132.95	133.2	132.84	133.16	14421962.0
2011-02-15 10:00:00	SPY	ETF	133.16	133.22	132.66	132.9102	21671891.0
2011-02-15 11:00:00	SPY	ETF	132.92	133.13	132.89	132.94	13039868.0
2011-02-15 12:00:00	SPY	ETF	132.95	133.19	132.85	133.0985	6824096.0
2011-02-15 13:00:00	SPY	ETF	133.09	133.16	132.98	133.02	10867266.0
2011-02-15 14:00:00	SPY	ETF	133.01	133.02	132.66	132.91	12671615.0
2011-02-15 15:00:00	SPY	ETF	132.91	133.05	132.78	133.01	21218708.0
2011-02-15 16:00:00	SPY	ETF	133.01	133.4574	132.9	133.03	13152304.0
2011-02-15 17:00:00	SPY	ETF	133.06	133.11	133.03	133.09	230644.0
2011-02-15 18:00:00	SPY	ETF	133.09	133.12	133.03	133.12	67986.0
2011-02-15 19:00:00	SPY	ETF	133.1	133.19	133.1	133.18	58745.0
2011-02-15 05:00:00	QQQ	ETF	58.58	58.58	58.58	58.58	2500.0
2011-02-15 06:00:00	QQQ	ETF	58.56	58.56	58.55	58.55	600.0
2011-02-15 07:00:00	QQQ	ETF	58.53	58.54	58.45	58.45	820605.0
2011-02-15 08:00:00	QQQ	ETF	58.46	58.53	58.35	58.41	3225389.0
2011-02-15 09:00:00	QQQ	ETF	58.4	58.57	58.32	58.55	6636064.0
2011-02-15 10:00:00	QQQ	ETF	58.545	58.57	58.23	58.35	7847832.0
2011-02-15 11:00:00	QQQ	ETF	58.36	58.4795	58.34	58.38	2895187.0
2011-02-15 12:00:00	QQQ	ETF	58.38	58.55	58.34	58.52	2469800.0
2011-02-15 13:00:00	QQQ	ETF	58.52	58.54	58.45	58.48	2125140.0
2011-02-15 14:00:00	QQQ	ETF	58.485	58.49	58.3128	58.429	4543759.0
2011-02-15 15:00:00	QQQ	ETF	58.42	58.52	58.38	58.51	5449568.0
2011-02-15 16:00:00	QQQ	ETF	58.51	58.56	58.4257	58.47	1734514.0
2011-02-15 17:00:00	QQQ	ETF	58.47	58.5	58.47	58.5	18898.0
2011-02-15 18:00:00	QQQ	ETF	58.48	58.54	58.48	58.53	36380.0
2011-02-15 19:00:00	QQQ	ETF	58.52	58.59	58.51	58.55	33964.0
2011-02-15 05:00:00	IWM	ETF	82.44	82.44	82.44	82.44	2500.0
2011-02-15 07:00:00	IWM	ETF	82.38	82.38	82.26	82.26	17800.0
2011-02-15 08:00:00	IWM	ETF	82.28	82.3	82.12	82.19	1137530.0
2011-02-15 09:00:00	IWM	ETF	82.18	82.4	82.11	82.35	3082590.0
2011-02-15 10:00:00	IWM	ETF	82.37	82.43	81.96	82.1	8261321.0
2011-02-15 11:00:00	IWM	ETF	82.11	82.35	82.11	82.14	3529218.0
2011-02-15 12:00:00	IWM	ETF	82.15	82.38	82.123	82.288	1758073.0
2011-02-15 13:00:00	IWM	ETF	82.28	82.3	82.17	82.19	3569306.0
2011-02-15 14:00:00	IWM	ETF	82.19	82.2	81.86	81.99	4522180.0
2011-02-15 15:00:00	IWM	ETF	81.98	82.06	81.83	82.02	7591421.0
2011-02-15 16:00:00	IWM	ETF	82.02	82.4886	81.92	81.95	4609971.0
2011-02-15 17:00:00	IWM	ETF	81.99	82.01	81.99	82.01	6700.0
2011-02-15 18:00:00	IWM	ETF	82.02	82.02	82.02	82.02	900.0
2011-02-15 19:00:00	IWM	ETF	82.02	82.03	82.02	82.03	4300.0
2011-02-15 07:00:00	DIA	ETF	122.51	122.51	122.41	122.41	200.0
2011-02-15 08:00:00	DIA	ETF	122.44	122.45	122.27	122.33	28900.0
2011-02-15 09:00:00	DIA	ETF	122.3	122.37	122.08	122.28	882404.0
2011-02-15 10:00:00	DIA	ETF	122.29	122.33	121.94	122.09	937783.0
2011-02-15 11:00:00	DIA	ETF	122.1	122.34	122.1	122.16	496977.0

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

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