PREVIEW / etf_1hour / 2012-11-27

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-11-27.parquet
  size:    189 KB
  rows:    5,890

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-11-27 05:00:00	SPY	ETF	141.05	141.08	140.89	140.9	73850.0
2012-11-27 06:00:00	SPY	ETF	140.85	141.01	140.81	141.01	50954.0
2012-11-27 07:00:00	SPY	ETF	140.95	141.16	140.95	141.09	832285.0
2012-11-27 08:00:00	SPY	ETF	141.09	141.3	140.88	141.08	1173066.0
2012-11-27 09:00:00	SPY	ETF	141.09	141.35	140.75	141.265	12180094.0
2012-11-27 10:00:00	SPY	ETF	141.27	141.31	140.48	140.685	21974259.0
2012-11-27 11:00:00	SPY	ETF	140.695	141.35	140.69	141.25	14247180.0
2012-11-27 12:00:00	SPY	ETF	141.253	141.39	141.0	141.205	8299687.0
2012-11-27 13:00:00	SPY	ETF	141.2	141.21	140.92	141.01	8627267.0
2012-11-27 14:00:00	SPY	ETF	141.02	141.205	140.32	140.65	22994665.0
2012-11-27 15:00:00	SPY	ETF	140.66	141.0834	140.24	140.42	26740053.0
2012-11-27 16:00:00	SPY	ETF	140.44	141.0934	140.33	140.43	8753890.0
2012-11-27 17:00:00	SPY	ETF	140.42	140.7772	140.36	140.38	329164.0
2012-11-27 18:00:00	SPY	ETF	140.38	140.42	140.2	140.2	828266.0
2012-11-27 19:00:00	SPY	ETF	140.24	140.34	140.19	140.24	37056.0
2012-11-27 04:00:00	QQQ	ETF	65.25	65.28	65.17	65.17	2300.0
2012-11-27 06:00:00	QQQ	ETF	65.13	65.16	65.12	65.15	84750.0
2012-11-27 07:00:00	QQQ	ETF	65.17	65.28	65.17	65.25	17690.0
2012-11-27 08:00:00	QQQ	ETF	65.25	65.265	65.14	65.2	173355.0
2012-11-27 09:00:00	QQQ	ETF	65.17	65.32	65.07	65.23	3744725.0
2012-11-27 10:00:00	QQQ	ETF	65.22	65.25	64.85	64.97	5132264.0
2012-11-27 11:00:00	QQQ	ETF	64.97	65.3085	64.97	65.2601	3055471.0
2012-11-27 12:00:00	QQQ	ETF	65.27	65.4	65.15	65.36	1731405.0
2012-11-27 13:00:00	QQQ	ETF	65.35	65.35	65.18	65.265	1988055.0
2012-11-27 14:00:00	QQQ	ETF	65.26	65.35	64.92	65.08	4230757.0
2012-11-27 15:00:00	QQQ	ETF	65.08	65.19	64.91	64.96	4596472.0
2012-11-27 16:00:00	QQQ	ETF	64.95	65.1299	64.94	64.97	319067.0
2012-11-27 17:00:00	QQQ	ETF	64.98	65.1428	64.98	65.0	168352.0
2012-11-27 18:00:00	QQQ	ETF	65.04	65.06	64.92	64.92	22346.0
2012-11-27 19:00:00	QQQ	ETF	64.91	64.97	64.54	64.54	12095.0
2012-11-27 04:00:00	IWM	ETF	80.83	80.83	80.83	80.83	100.0
2012-11-27 07:00:00	IWM	ETF	80.72	80.9	80.72	80.85	49600.0
2012-11-27 08:00:00	IWM	ETF	80.82	80.93	80.74	80.86	82055.0
2012-11-27 09:00:00	IWM	ETF	80.85	81.23	80.57	81.12	7473927.0
2012-11-27 10:00:00	IWM	ETF	81.11	81.13	80.62	80.8	5780948.0
2012-11-27 11:00:00	IWM	ETF	80.79	81.23	80.79	81.14	2874927.0
2012-11-27 12:00:00	IWM	ETF	81.15	81.219	80.98	81.1	1675306.0
2012-11-27 13:00:00	IWM	ETF	81.09	81.15	80.87	80.9999	2614420.0
2012-11-27 14:00:00	IWM	ETF	81.0	81.14	80.65	80.84	3656163.0
2012-11-27 15:00:00	IWM	ETF	80.84	80.98	80.62	80.65	5491169.0
2012-11-27 16:00:00	IWM	ETF	80.66	80.79	80.63	80.68	2029072.0
2012-11-27 17:00:00	IWM	ETF	80.69	80.882	80.64	80.64	109652.0
2012-11-27 18:00:00	IWM	ETF	80.66	80.66	80.53	80.53	5230.0
2012-11-27 19:00:00	IWM	ETF	80.52	80.56	80.52	80.52	1150.0
2012-11-27 06:00:00	DIA	ETF	129.31	129.31	129.31	129.31	100.0
2012-11-27 07:00:00	DIA	ETF	129.44	129.44	129.44	129.44	500.0
2012-11-27 08:00:00	DIA	ETF	129.45	129.48	129.35	129.45	4600.0
2012-11-27 09:00:00	DIA	ETF	129.39	129.65	129.13	129.65	306488.0
2012-11-27 10:00:00	DIA	ETF	129.61	129.64	128.91	129.07	781260.0
2012-11-27 11:00:00	DIA	ETF	129.08	129.5599	129.07	129.47	438618.0

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

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