PREVIEW / etf_1hour / 2012-02-14

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-02-14.parquet
  size:    184 KB
  rows:    5,666

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
2012-02-14 04:00:00	SPY	ETF	135.03	135.11	134.95	135.11	1250.0
2012-02-14 05:00:00	SPY	ETF	135.15	135.6	135.15	135.54	51851.0
2012-02-14 06:00:00	SPY	ETF	135.46	135.61	135.42	135.53	121180.0
2012-02-14 07:00:00	SPY	ETF	135.55	135.59	135.28	135.32	175935.0
2012-02-14 08:00:00	SPY	ETF	135.34	135.5	134.86	134.97	2911211.0
2012-02-14 09:00:00	SPY	ETF	134.97	135.14	134.78	134.9199	16033985.0
2012-02-14 10:00:00	SPY	ETF	134.91	135.0	134.58	134.72	27911195.0
2012-02-14 11:00:00	SPY	ETF	134.72	135.1	134.68	134.92	18606119.0
2012-02-14 12:00:00	SPY	ETF	134.92	135.01	134.64	134.69	11444909.0
2012-02-14 13:00:00	SPY	ETF	134.69	134.81	134.5	134.745	13747353.0
2012-02-14 14:00:00	SPY	ETF	134.75	134.81	134.27	134.51	17020949.0
2012-02-14 15:00:00	SPY	ETF	134.51	135.27	134.25	135.23	41573731.0
2012-02-14 16:00:00	SPY	ETF	135.22	135.36	134.7269	135.21	10481857.0
2012-02-14 17:00:00	SPY	ETF	135.22	135.3592	135.17	135.2	713229.0
2012-02-14 18:00:00	SPY	ETF	135.19	135.21	135.14	135.2	649245.0
2012-02-14 19:00:00	SPY	ETF	135.21	135.25	135.16	135.25	46734.0
2012-02-14 05:00:00	QQQ	ETF	63.12	63.19	63.12	63.19	1300.0
2012-02-14 06:00:00	QQQ	ETF	63.16	63.17	63.12	63.17	38800.0
2012-02-14 07:00:00	QQQ	ETF	63.19	63.2	63.04	63.04	54120.0
2012-02-14 08:00:00	QQQ	ETF	63.1	63.13	62.87	62.9	1216338.0
2012-02-14 09:00:00	QQQ	ETF	62.91	63.07	62.84	62.98	4216076.0
2012-02-14 10:00:00	QQQ	ETF	62.98	63.03	62.7899	62.85	6670168.0
2012-02-14 11:00:00	QQQ	ETF	62.854	63.03	62.815	62.92	4795760.0
2012-02-14 12:00:00	QQQ	ETF	62.91	62.949	62.78	62.82	2149902.0
2012-02-14 13:00:00	QQQ	ETF	62.81	62.93	62.73	62.89	3258142.0
2012-02-14 14:00:00	QQQ	ETF	62.89	62.94	62.69	62.8	4017918.0
2012-02-14 15:00:00	QQQ	ETF	62.8	63.22	62.72	63.21	8194741.0
2012-02-14 16:00:00	QQQ	ETF	63.21	63.34	63.19	63.26	1571675.0
2012-02-14 17:00:00	QQQ	ETF	63.27	63.28	63.22	63.24	40106.0
2012-02-14 18:00:00	QQQ	ETF	63.25	63.25	63.22	63.22	20438.0
2012-02-14 19:00:00	QQQ	ETF	63.23	63.35	63.0	63.35	31460.0
2012-02-14 06:00:00	IWM	ETF	82.37	82.39	82.34	82.39	1300.0
2012-02-14 07:00:00	IWM	ETF	82.38	82.38	82.22	82.22	400.0
2012-02-14 08:00:00	IWM	ETF	82.25	82.3	81.89	81.96	683157.0
2012-02-14 09:00:00	IWM	ETF	81.96	82.12	81.79	81.84	8107410.0
2012-02-14 10:00:00	IWM	ETF	81.83	81.88	81.42	81.5447	10294137.0
2012-02-14 11:00:00	IWM	ETF	81.55	81.91	81.51	81.74	3338662.0
2012-02-14 12:00:00	IWM	ETF	81.732	81.77	81.52	81.59	2383327.0
2012-02-14 13:00:00	IWM	ETF	81.58	81.76	81.36	81.68	4605105.0
2012-02-14 14:00:00	IWM	ETF	81.69	81.75	81.44	81.58	2703836.0
2012-02-14 15:00:00	IWM	ETF	81.57	82.01	81.37	81.99	8817926.0
2012-02-14 16:00:00	IWM	ETF	81.98	82.08	81.45	82.04	2913710.0
2012-02-14 17:00:00	IWM	ETF	82.05	82.06	81.98	82.01	26742.0
2012-02-14 18:00:00	IWM	ETF	82.0	82.0	82.0	82.0	100.0
2012-02-14 19:00:00	IWM	ETF	81.97	82.02	81.97	82.02	1700.0
2012-02-14 07:00:00	DIA	ETF	128.79	128.79	128.72	128.72	494.0
2012-02-14 08:00:00	DIA	ETF	128.61	128.65	128.3	128.35	13215.0
2012-02-14 09:00:00	DIA	ETF	128.33	128.5	128.17	128.37	300572.0
2012-02-14 10:00:00	DIA	ETF	128.36	128.4177	128.12	128.26	930520.0
2012-02-14 11:00:00	DIA	ETF	128.27	128.55	128.2	128.42	605787.0

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

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