PREVIEW / etf_1hour / 2013-03-26

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-03-26.parquet
  size:    194 KB
  rows:    6,056

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
2013-03-26 04:00:00	SPY	ETF	155.28	155.46	155.25	155.42	46071.0
2013-03-26 05:00:00	SPY	ETF	155.44	155.5	155.36	155.49	19279.0
2013-03-26 06:00:00	SPY	ETF	155.49	155.54	155.44	155.5	67900.0
2013-03-26 07:00:00	SPY	ETF	155.5	155.54	155.21	155.22	387997.0
2013-03-26 08:00:00	SPY	ETF	155.22	155.51	155.2	155.43	2259341.0
2013-03-26 09:00:00	SPY	ETF	155.43	155.93	155.34	155.83	12787519.0
2013-03-26 10:00:00	SPY	ETF	155.8	156.01	155.42	155.74	21188597.0
2013-03-26 11:00:00	SPY	ETF	155.73	155.91	155.58	155.7101	7937330.0
2013-03-26 12:00:00	SPY	ETF	155.72	155.85	155.54	155.68	6600771.0
2013-03-26 13:00:00	SPY	ETF	155.68	155.95	155.6399	155.905	6598824.0
2013-03-26 14:00:00	SPY	ETF	155.9099	156.04	155.84	155.9199	5776305.0
2013-03-26 15:00:00	SPY	ETF	155.92	156.23	155.91	156.14	17033949.0
2013-03-26 16:00:00	SPY	ETF	156.15	156.27	156.06	156.19	3683049.0
2013-03-26 17:00:00	SPY	ETF	156.19	156.23	156.16	156.23	203213.0
2013-03-26 18:00:00	SPY	ETF	156.19	156.26	156.15	156.26	94210.0
2013-03-26 19:00:00	SPY	ETF	156.24	156.26	156.16	156.17	38184.0
2013-03-26 04:00:00	QQQ	ETF	68.55	68.56	68.48	68.56	10600.0
2013-03-26 05:00:00	QQQ	ETF	68.5	68.5	68.5	68.5	100.0
2013-03-26 06:00:00	QQQ	ETF	68.57	68.57	68.55	68.55	8400.0
2013-03-26 07:00:00	QQQ	ETF	68.55	68.55	68.43	68.43	14150.0
2013-03-26 08:00:00	QQQ	ETF	68.43	68.52	68.43	68.51	1610157.0
2013-03-26 09:00:00	QQQ	ETF	68.51	68.72	68.46	68.62	2339033.0
2013-03-26 10:00:00	QQQ	ETF	68.63	68.71	68.45	68.57	4389648.0
2013-03-26 11:00:00	QQQ	ETF	68.57	68.67	68.5	68.56	1299739.0
2013-03-26 12:00:00	QQQ	ETF	68.56	68.61	68.45	68.51	1468172.0
2013-03-26 13:00:00	QQQ	ETF	68.51	68.68	68.51	68.63	1088649.0
2013-03-26 14:00:00	QQQ	ETF	68.621	68.7	68.55	68.6025	1708951.0
2013-03-26 15:00:00	QQQ	ETF	68.6	68.73	68.6	68.71	4410987.0
2013-03-26 16:00:00	QQQ	ETF	68.71	68.76	68.6042	68.74	834669.0
2013-03-26 17:00:00	QQQ	ETF	68.75	68.78	68.75	68.78	9680.0
2013-03-26 18:00:00	QQQ	ETF	68.75	68.78	68.74	68.78	12762.0
2013-03-26 19:00:00	QQQ	ETF	68.8	68.8	68.75	68.76	5361.0
2013-03-26 04:00:00	IWM	ETF	94.29	94.29	94.18	94.18	2850.0
2013-03-26 06:00:00	IWM	ETF	94.23	94.24	94.23	94.24	2100.0
2013-03-26 07:00:00	IWM	ETF	94.23	94.3	94.05	94.05	126329.0
2013-03-26 08:00:00	IWM	ETF	94.07	94.28	94.07	94.24	1727294.0
2013-03-26 09:00:00	IWM	ETF	94.24	94.49	94.18	94.305	3136637.0
2013-03-26 10:00:00	IWM	ETF	94.3	94.365	93.88	93.96	5475419.0
2013-03-26 11:00:00	IWM	ETF	93.96	94.04	93.83	93.89	2458529.0
2013-03-26 12:00:00	IWM	ETF	93.89	94.0	93.75	93.83	1748544.0
2013-03-26 13:00:00	IWM	ETF	93.83	93.9888	93.81	93.93	1417674.0
2013-03-26 14:00:00	IWM	ETF	93.94	94.0	93.88	93.921	1589395.0
2013-03-26 15:00:00	IWM	ETF	93.92	94.31	93.92	94.27	5377366.0
2013-03-26 16:00:00	IWM	ETF	94.28	94.35	93.8715	94.32	1759336.0
2013-03-26 17:00:00	IWM	ETF	94.31	94.34	94.27	94.3	31350.0
2013-03-26 19:00:00	IWM	ETF	94.3	94.33	94.3	94.31	2600.0
2013-03-26 07:00:00	DIA	ETF	144.52	144.52	144.52	144.52	100.0
2013-03-26 08:00:00	DIA	ETF	144.45	144.55	144.45	144.55	3250.0
2013-03-26 09:00:00	DIA	ETF	144.55	145.1	144.55	145.02	797765.0
2013-03-26 10:00:00	DIA	ETF	145.02	145.24	144.8	145.04	1027471.0

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

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