PREVIEW / etf_1hour / 2014-02-13

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-02-13.parquet
  size:    221 KB
  rows:    6,880

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
2014-02-13 04:00:00	SPY	ETF	181.6	181.6	181.25	181.4	61417.0
2014-02-13 05:00:00	SPY	ETF	181.44	181.61	181.35	181.42	93750.0
2014-02-13 06:00:00	SPY	ETF	181.35	181.39	181.15	181.29	209384.0
2014-02-13 07:00:00	SPY	ETF	181.29	181.49	181.25	181.34	341568.0
2014-02-13 08:00:00	SPY	ETF	181.34	181.44	180.75	181.13	2455703.0
2014-02-13 09:00:00	SPY	ETF	181.11	181.61	180.83	181.55	12634479.0
2014-02-13 10:00:00	SPY	ETF	181.55	182.44	181.46	182.34	18873165.0
2014-02-13 11:00:00	SPY	ETF	182.345	182.65	182.21	182.44	10916824.0
2014-02-13 12:00:00	SPY	ETF	182.45	182.66	182.31	182.59	7222695.0
2014-02-13 13:00:00	SPY	ETF	182.59	183.08	182.55	183.079	9202360.0
2014-02-13 14:00:00	SPY	ETF	183.07	183.2	182.87	183.13	10765687.0
2014-02-13 15:00:00	SPY	ETF	183.13	183.18	182.95	183.05	18208759.0
2014-02-13 16:00:00	SPY	ETF	183.04	183.1385	182.0838	183.01	6627228.0
2014-02-13 17:00:00	SPY	ETF	183.0	183.14	182.87	182.96	1419338.0
2014-02-13 18:00:00	SPY	ETF	182.94	182.95	182.72	182.87	274975.0
2014-02-13 19:00:00	SPY	ETF	182.85	183.04	182.84	182.96	135767.0
2014-02-13 04:00:00	QQQ	ETF	88.53	88.55	88.53	88.55	4600.0
2014-02-13 05:00:00	QQQ	ETF	88.57	88.62	88.52	88.62	3546.0
2014-02-13 06:00:00	QQQ	ETF	88.55	88.55	88.43	88.49	33400.0
2014-02-13 07:00:00	QQQ	ETF	88.54	88.6	88.47	88.47	36875.0
2014-02-13 08:00:00	QQQ	ETF	88.5	88.6	88.28	88.41	458537.0
2014-02-13 09:00:00	QQQ	ETF	88.43	88.89	88.29	88.84	5515540.0
2014-02-13 10:00:00	QQQ	ETF	88.84	89.4	88.79	89.34	7771004.0
2014-02-13 11:00:00	QQQ	ETF	89.35	89.45	89.27	89.319	3210723.0
2014-02-13 12:00:00	QQQ	ETF	89.31	89.45	89.2799	89.41	2299314.0
2014-02-13 13:00:00	QQQ	ETF	89.41	89.66	89.4023	89.66	2924495.0
2014-02-13 14:00:00	QQQ	ETF	89.66	89.7	89.5	89.63	2946052.0
2014-02-13 15:00:00	QQQ	ETF	89.64	89.7	89.531	89.66	6471339.0
2014-02-13 16:00:00	QQQ	ETF	89.67	89.67	88.616	89.63	3903134.0
2014-02-13 17:00:00	QQQ	ETF	89.63	89.67	89.57	89.63	14565.0
2014-02-13 18:00:00	QQQ	ETF	89.6	89.6	89.5	89.54	22130.0
2014-02-13 19:00:00	QQQ	ETF	89.56	89.66	89.56	89.63	14275.0
2014-02-13 06:00:00	IWM	ETF	111.74	111.81	111.74	111.81	1600.0
2014-02-13 07:00:00	IWM	ETF	111.92	112.0	111.88	111.88	33600.0
2014-02-13 08:00:00	IWM	ETF	111.9	111.9	111.42	111.72	333896.0
2014-02-13 09:00:00	IWM	ETF	111.73	112.24	111.36	112.2299	5175937.0
2014-02-13 10:00:00	IWM	ETF	112.22	112.87	112.14	112.79	5834003.0
2014-02-13 11:00:00	IWM	ETF	112.7804	113.08	112.72	112.94	3013538.0
2014-02-13 12:00:00	IWM	ETF	112.95	113.22	112.8601	113.149	2947681.0
2014-02-13 13:00:00	IWM	ETF	113.15	113.85	113.15	113.83	6226588.0
2014-02-13 14:00:00	IWM	ETF	113.84	114.07	113.67	113.96	4680509.0
2014-02-13 15:00:00	IWM	ETF	113.96	114.03	113.86	113.89	5536439.0
2014-02-13 16:00:00	IWM	ETF	113.88	113.9	111.95	113.89	2925260.0
2014-02-13 17:00:00	IWM	ETF	113.84	113.84	113.71	113.75	11150.0
2014-02-13 18:00:00	IWM	ETF	113.7	113.7	113.66	113.67	8700.0
2014-02-13 19:00:00	IWM	ETF	113.74	113.86	113.74	113.79	6993.0
2014-02-13 04:00:00	DIA	ETF	159.14	159.14	159.14	159.14	200.0
2014-02-13 06:00:00	DIA	ETF	159.02	159.02	158.98	159.0	400.0
2014-02-13 07:00:00	DIA	ETF	159.03	159.03	159.03	159.03	100.0
2014-02-13 08:00:00	DIA	ETF	159.27	159.28	158.57	158.9	30692.0

> showing 50 of 6,880 rows — these rows as CSV

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