PREVIEW / etf_1hour / 2011-02-22

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-02-22.parquet
  size:    193 KB
  rows:    5,928

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-22 04:00:00	SPY	ETF	133.49	133.49	132.48	132.7	26399.0
2011-02-22 05:00:00	SPY	ETF	132.72	132.93	132.55	132.93	40118.0
2011-02-22 06:00:00	SPY	ETF	132.98	133.03	132.8	132.87	210981.0
2011-02-22 07:00:00	SPY	ETF	132.87	133.16	132.86	133.15	983348.0
2011-02-22 08:00:00	SPY	ETF	133.16	134.15	132.66	133.16	3517399.0
2011-02-22 09:00:00	SPY	ETF	133.18	134.57	132.75	133.6	28461813.0
2011-02-22 10:00:00	SPY	ETF	133.6	133.86	133.4	133.54	28459901.0
2011-02-22 11:00:00	SPY	ETF	133.55	133.57	132.68	132.8	29261863.0
2011-02-22 12:00:00	SPY	ETF	132.81	132.84	132.01	132.13	28546568.0
2011-02-22 13:00:00	SPY	ETF	132.13	132.28	131.73	131.97	24534429.0
2011-02-22 14:00:00	SPY	ETF	131.96	134.5615	131.75	131.91	23680876.0
2011-02-22 15:00:00	SPY	ETF	131.91	132.01	131.47	131.83	43046497.0
2011-02-22 16:00:00	SPY	ETF	131.83	134.5615	131.78	131.82	18951634.0
2011-02-22 17:00:00	SPY	ETF	131.82	134.5615	131.67	131.72	1150183.0
2011-02-22 18:00:00	SPY	ETF	131.7	132.0	131.67	131.96	128663.0
2011-02-22 19:00:00	SPY	ETF	131.97	132.15	131.93	132.15	198764.0
2011-02-22 04:00:00	QQQ	ETF	57.94	57.94	57.8	57.82	47500.0
2011-02-22 05:00:00	QQQ	ETF	57.82	57.95	57.81	57.94	9915.0
2011-02-22 06:00:00	QQQ	ETF	57.95	57.95	57.84	57.88	54452.0
2011-02-22 07:00:00	QQQ	ETF	57.88	58.08	57.88	58.05	318803.0
2011-02-22 08:00:00	QQQ	ETF	58.14	58.15	57.92	58.01	1882998.0
2011-02-22 09:00:00	QQQ	ETF	58.02	58.03	57.51	57.94	19244177.0
2011-02-22 10:00:00	QQQ	ETF	57.94	58.13	57.77	58.02	9821391.0
2011-02-22 11:00:00	QQQ	ETF	58.02	58.04	57.6	57.66	12758318.0
2011-02-22 12:00:00	QQQ	ETF	57.66	57.69	57.19	57.241	7964493.0
2011-02-22 13:00:00	QQQ	ETF	57.24	57.35	57.09	57.215	7391528.0
2011-02-22 14:00:00	QQQ	ETF	57.2195	57.35	57.11	57.22	6407596.0
2011-02-22 15:00:00	QQQ	ETF	57.22	57.25	56.94	57.02	13281546.0
2011-02-22 16:00:00	QQQ	ETF	57.02	57.1	56.89	57.05	7251223.0
2011-02-22 17:00:00	QQQ	ETF	57.06	57.06	56.95	56.95	129045.0
2011-02-22 18:00:00	QQQ	ETF	56.97	57.07	56.97	57.04	128412.0
2011-02-22 19:00:00	QQQ	ETF	57.05	57.11	57.03	57.1	46681.0
2011-02-22 04:00:00	IWM	ETF	82.8	82.8	82.34	82.39	1850.0
2011-02-22 05:00:00	IWM	ETF	82.36	82.42	82.36	82.41	83800.0
2011-02-22 06:00:00	IWM	ETF	82.52	82.52	82.4	82.46	33000.0
2011-02-22 07:00:00	IWM	ETF	82.45	82.7	82.45	82.67	156521.0
2011-02-22 08:00:00	IWM	ETF	82.98	83.21	82.6	82.61	1107656.0
2011-02-22 09:00:00	IWM	ETF	82.6	82.94	82.05	82.78	11093515.0
2011-02-22 10:00:00	IWM	ETF	82.79	83.02	82.3	82.58	9039682.0
2011-02-22 11:00:00	IWM	ETF	82.58	82.59	81.85	81.9799	8827746.0
2011-02-22 12:00:00	IWM	ETF	81.99	82.0	81.4	81.52	6470887.0
2011-02-22 13:00:00	IWM	ETF	81.52	81.68	81.33	81.51	5768317.0
2011-02-22 14:00:00	IWM	ETF	81.5199	81.79	81.3999	81.51	4469602.0
2011-02-22 15:00:00	IWM	ETF	81.51	81.9	81.09	81.2	13606590.0
2011-02-22 16:00:00	IWM	ETF	81.21	82.72	81.11	81.17	3793686.0
2011-02-22 17:00:00	IWM	ETF	81.16	81.24	81.12	81.16	40218.0
2011-02-22 18:00:00	IWM	ETF	81.15	81.25	81.15	81.25	7250.0
2011-02-22 19:00:00	IWM	ETF	81.23	81.3	81.16	81.29	6836.0
2011-02-22 04:00:00	DIA	ETF	122.7	122.7	122.31	122.47	700.0
2011-02-22 05:00:00	DIA	ETF	122.4	122.4	122.34	122.34	400.0

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

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