PREVIEW / etf_1hour / 2011-06-27

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-06-27.parquet
  size:    178 KB
  rows:    5,466

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-06-27 04:00:00	SPY	ETF	126.86	127.2	126.69	127.2	11850.0
2011-06-27 05:00:00	SPY	ETF	127.2	127.26	127.08	127.15	8872.0
2011-06-27 06:00:00	SPY	ETF	127.2	127.48	127.17	127.17	20250.0
2011-06-27 07:00:00	SPY	ETF	127.22	127.28	127.09	127.1	255620.0
2011-06-27 08:00:00	SPY	ETF	127.08	127.3	126.86	126.93	1955020.0
2011-06-27 09:00:00	SPY	ETF	126.93	127.37	126.64	127.18	22529912.0
2011-06-27 10:00:00	SPY	ETF	127.18	127.82	127.14	127.67	24132391.0
2011-06-27 11:00:00	SPY	ETF	127.68	127.87	127.4	127.86	15844140.0
2011-06-27 12:00:00	SPY	ETF	127.8501	127.95	127.71	127.76	10918101.0
2011-06-27 13:00:00	SPY	ETF	127.76	127.93	127.59	127.78	15738133.0
2011-06-27 14:00:00	SPY	ETF	127.775	128.43	127.775	128.26	26012701.0
2011-06-27 15:00:00	SPY	ETF	128.27	128.4	127.92	127.95	30828892.0
2011-06-27 16:00:00	SPY	ETF	127.95	128.25	127.53	128.22	12938416.0
2011-06-27 17:00:00	SPY	ETF	128.23	128.27	128.12	128.21	192785.0
2011-06-27 18:00:00	SPY	ETF	128.23	128.33	126.7679	128.26	2545575.0
2011-06-27 19:00:00	SPY	ETF	128.26	128.37	128.25	128.36	49948.0
2011-06-27 05:00:00	QQQ	ETF	54.44	54.5	54.44	54.5	1300.0
2011-06-27 06:00:00	QQQ	ETF	54.43	54.47	54.43	54.44	7500.0
2011-06-27 07:00:00	QQQ	ETF	54.45	54.47	54.41	54.42	3700.0
2011-06-27 08:00:00	QQQ	ETF	54.41	54.45	54.02	54.34	254790.0
2011-06-27 09:00:00	QQQ	ETF	54.34	54.69	54.27	54.63	8139745.0
2011-06-27 10:00:00	QQQ	ETF	54.63	55.06	54.61	54.97	7797073.0
2011-06-27 11:00:00	QQQ	ETF	54.97	55.16	54.92	55.1471	5270383.0
2011-06-27 12:00:00	QQQ	ETF	55.149	55.23	55.12	55.18	3554481.0
2011-06-27 13:00:00	QQQ	ETF	55.185	55.2699	55.09	55.195	3650506.0
2011-06-27 14:00:00	QQQ	ETF	55.19	55.53	55.19	55.445	5730752.0
2011-06-27 15:00:00	QQQ	ETF	55.445	55.5	55.22	55.24	8396177.0
2011-06-27 16:00:00	QQQ	ETF	55.24	55.4944	55.18	55.35	1980505.0
2011-06-27 17:00:00	QQQ	ETF	55.35	55.37	55.0129	55.34	154877.0
2011-06-27 18:00:00	QQQ	ETF	55.34	55.43	55.24	55.42	59822.0
2011-06-27 19:00:00	QQQ	ETF	55.43	55.45	55.43	55.45	29604.0
2011-06-27 04:00:00	IWM	ETF	80.03	80.03	80.03	80.03	200.0
2011-06-27 07:00:00	IWM	ETF	80.14	80.29	80.14	80.24	4304.0
2011-06-27 08:00:00	IWM	ETF	80.18	80.18	79.85	79.86	275686.0
2011-06-27 09:00:00	IWM	ETF	79.87	80.12	79.455	80.0	6708165.0
2011-06-27 10:00:00	IWM	ETF	80.0	80.63	79.97	80.39	9183486.0
2011-06-27 11:00:00	IWM	ETF	80.4	80.55	80.23	80.49	4890007.0
2011-06-27 12:00:00	IWM	ETF	80.49	80.58	80.285	80.32	2821513.0
2011-06-27 13:00:00	IWM	ETF	80.33	80.48	80.1	80.24	3989946.0
2011-06-27 14:00:00	IWM	ETF	80.24	80.72	80.235	80.58	6434812.0
2011-06-27 15:00:00	IWM	ETF	80.5785	80.72	80.49	80.56	6512695.0
2011-06-27 16:00:00	IWM	ETF	80.55	80.74	79.8541	80.69	2089144.0
2011-06-27 17:00:00	IWM	ETF	80.72	80.75	80.68	80.73	23450.0
2011-06-27 18:00:00	IWM	ETF	80.73	80.76	80.73	80.75	12400.0
2011-06-27 19:00:00	IWM	ETF	80.74	80.82	80.74	80.81	1900.0
2011-06-27 07:00:00	DIA	ETF	119.5	119.52	119.4	119.4	6800.0
2011-06-27 08:00:00	DIA	ETF	119.43	119.48	119.29	119.29	26800.0
2011-06-27 09:00:00	DIA	ETF	119.3	119.77	119.08	119.62	462503.0
2011-06-27 10:00:00	DIA	ETF	119.6	120.14	119.54	120.04	697047.0
2011-06-27 11:00:00	DIA	ETF	120.05	120.2	119.8	120.2	509693.0

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

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