PREVIEW / etf_1hour / 2011-02-28

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-02-28.parquet
  size:    182 KB
  rows:    5,590

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-28 04:00:00	SPY	ETF	132.02	132.18	131.98	132.0	8150.0
2011-02-28 05:00:00	SPY	ETF	132.15	132.15	132.05	132.05	600.0
2011-02-28 06:00:00	SPY	ETF	131.97	132.29	131.97	132.27	46550.0
2011-02-28 07:00:00	SPY	ETF	132.25	133.0	132.25	132.91	944786.0
2011-02-28 08:00:00	SPY	ETF	132.89	133.05	131.09	132.87	2202505.0
2011-02-28 09:00:00	SPY	ETF	132.89	133.19	132.73	133.03	18565975.0
2011-02-28 10:00:00	SPY	ETF	133.03	133.32	132.95	133.2	17484491.0
2011-02-28 11:00:00	SPY	ETF	133.2	133.23	132.8	132.89	13576487.0
2011-02-28 12:00:00	SPY	ETF	132.89	133.04	132.621	132.6601	9446041.0
2011-02-28 13:00:00	SPY	ETF	132.66	132.69	132.41	132.46	12315376.0
2011-02-28 14:00:00	SPY	ETF	132.46	132.86	132.38	132.86	12541325.0
2011-02-28 15:00:00	SPY	ETF	132.85	133.16	132.67	133.14	30483961.0
2011-02-28 16:00:00	SPY	ETF	133.14	133.32	132.9114	133.07	19316352.0
2011-02-28 17:00:00	SPY	ETF	133.08	133.13	132.3283	133.11	1709450.0
2011-02-28 18:00:00	SPY	ETF	133.11	133.24	133.08	133.24	175812.0
2011-02-28 19:00:00	SPY	ETF	133.26	133.39	133.26	133.37	119922.0
2011-02-28 04:00:00	QQQ	ETF	57.54	57.55	57.54	57.55	2100.0
2011-02-28 05:00:00	QQQ	ETF	57.55	57.55	57.55	57.55	200.0
2011-02-28 06:00:00	QQQ	ETF	57.58	57.69	57.57	57.69	10500.0
2011-02-28 07:00:00	QQQ	ETF	57.69	57.92	57.66	57.88	181440.0
2011-02-28 08:00:00	QQQ	ETF	57.9	57.96	57.83	57.85	571508.0
2011-02-28 09:00:00	QQQ	ETF	57.87	58.05	57.81	57.95	6271801.0
2011-02-28 10:00:00	QQQ	ETF	57.96	58.03	57.86	57.949	7410428.0
2011-02-28 11:00:00	QQQ	ETF	57.95	57.96	57.7	57.77	4996832.0
2011-02-28 12:00:00	QQQ	ETF	57.77	57.81	57.54	57.565	4270163.0
2011-02-28 13:00:00	QQQ	ETF	57.57	57.59	57.45	57.48	7022013.0
2011-02-28 14:00:00	QQQ	ETF	57.48	57.66	57.43	57.64	2995239.0
2011-02-28 15:00:00	QQQ	ETF	57.64	57.77	57.54	57.77	9092927.0
2011-02-28 16:00:00	QQQ	ETF	57.77	57.9	57.6576	57.8	3158849.0
2011-02-28 17:00:00	QQQ	ETF	57.8	57.82	57.79	57.82	123498.0
2011-02-28 18:00:00	QQQ	ETF	57.82	57.85	57.8	57.83	15670.0
2011-02-28 19:00:00	QQQ	ETF	57.85	57.89	57.81	57.81	21556.0
2011-02-28 04:00:00	IWM	ETF	82.11	82.11	82.11	82.11	363.0
2011-02-28 05:00:00	IWM	ETF	82.1	82.1	82.07	82.07	700.0
2011-02-28 07:00:00	IWM	ETF	82.27	82.92	82.27	82.91	62931.0
2011-02-28 08:00:00	IWM	ETF	82.88	82.97	82.33	82.77	345891.0
2011-02-28 09:00:00	IWM	ETF	82.78	82.84	82.52	82.64	7011904.0
2011-02-28 10:00:00	IWM	ETF	82.65	82.74	82.41	82.57	6285196.0
2011-02-28 11:00:00	IWM	ETF	82.56	82.62	82.11	82.28	6049515.0
2011-02-28 12:00:00	IWM	ETF	82.28	82.29	81.85	81.91	2886434.0
2011-02-28 13:00:00	IWM	ETF	81.91	81.91	81.59	81.7	4139949.0
2011-02-28 14:00:00	IWM	ETF	81.7	81.92	81.595	81.92	4100402.0
2011-02-28 15:00:00	IWM	ETF	81.91	82.28	81.64	82.25	9662962.0
2011-02-28 16:00:00	IWM	ETF	82.26	82.46	81.75	82.38	4819275.0
2011-02-28 17:00:00	IWM	ETF	82.39	82.39	82.25	82.25	126050.0
2011-02-28 18:00:00	IWM	ETF	82.35	82.35	82.31	82.31	1400.0
2011-02-28 19:00:00	IWM	ETF	82.37	82.46	82.37	82.4	8700.0
2011-02-28 06:00:00	DIA	ETF	121.03	121.16	121.03	121.15	481.0
2011-02-28 07:00:00	DIA	ETF	121.14	121.57	121.14	121.56	2500.0
2011-02-28 08:00:00	DIA	ETF	121.57	121.66	121.09	121.53	517208.0

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

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