PREVIEW / etf_1hour / 2014-02-10

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-02-10.parquet
  size:    214 KB
  rows:    6,783

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-10 04:00:00	SPY	ETF	179.73	179.73	179.29	179.48	179989.0
2014-02-10 05:00:00	SPY	ETF	179.46	179.52	179.3	179.33	38618.0
2014-02-10 06:00:00	SPY	ETF	179.34	179.41	179.15	179.26	72230.0
2014-02-10 07:00:00	SPY	ETF	179.26	179.51	179.24	179.48	416692.0
2014-02-10 08:00:00	SPY	ETF	179.31	179.63	179.1	179.52	733857.0
2014-02-10 09:00:00	SPY	ETF	179.51	179.84	179.34	179.73	14622303.0
2014-02-10 10:00:00	SPY	ETF	179.72	179.79	179.22	179.38	13734555.0
2014-02-10 11:00:00	SPY	ETF	179.38	179.77	179.21	179.6595	11420729.0
2014-02-10 12:00:00	SPY	ETF	179.66	179.72	179.53	179.66	5329912.0
2014-02-10 13:00:00	SPY	ETF	179.66	179.78	179.52	179.71	5622768.0
2014-02-10 14:00:00	SPY	ETF	179.72	180.07	179.69	179.945	8665319.0
2014-02-10 15:00:00	SPY	ETF	179.95	180.02	179.75	180.0	14259562.0
2014-02-10 16:00:00	SPY	ETF	180.01	180.05	179.6564	180.04	15967423.0
2014-02-10 17:00:00	SPY	ETF	180.02	180.09	180.0	180.08	155044.0
2014-02-10 18:00:00	SPY	ETF	180.09	180.15	179.97	180.0	124181.0
2014-02-10 19:00:00	SPY	ETF	180.03	180.28	180.0	180.14	143966.0
2014-02-10 04:00:00	QQQ	ETF	87.3	87.3	87.2	87.2	4580.0
2014-02-10 05:00:00	QQQ	ETF	87.21	87.21	87.21	87.21	100.0
2014-02-10 06:00:00	QQQ	ETF	87.19	87.19	87.18	87.18	2400.0
2014-02-10 07:00:00	QQQ	ETF	87.18	87.29	87.15	87.28	14679.0
2014-02-10 08:00:00	QQQ	ETF	87.21	87.34	87.21	87.3	133618.0
2014-02-10 09:00:00	QQQ	ETF	87.31	87.68	87.21	87.59	5099676.0
2014-02-10 10:00:00	QQQ	ETF	87.59	87.61	87.34	87.45	4514679.0
2014-02-10 11:00:00	QQQ	ETF	87.445	87.75	87.38	87.7	3381595.0
2014-02-10 12:00:00	QQQ	ETF	87.7	87.76	87.6299	87.64	1531329.0
2014-02-10 13:00:00	QQQ	ETF	87.63	87.6825	87.52	87.63	1712863.0
2014-02-10 14:00:00	QQQ	ETF	87.64	87.84	87.62	87.77	2471024.0
2014-02-10 15:00:00	QQQ	ETF	87.78	87.801	87.67	87.8	3684581.0
2014-02-10 16:00:00	QQQ	ETF	87.8	87.85	87.3155	87.83	2225623.0
2014-02-10 17:00:00	QQQ	ETF	87.31	87.9	87.31	87.87	15763.0
2014-02-10 18:00:00	QQQ	ETF	87.85	87.86	87.84	87.84	3000.0
2014-02-10 19:00:00	QQQ	ETF	87.87	87.96	87.87	87.9	15300.0
2014-02-10 07:00:00	IWM	ETF	110.59	110.63	110.42	110.63	21204.0
2014-02-10 08:00:00	IWM	ETF	110.65	110.79	110.59	110.7	235245.0
2014-02-10 09:00:00	IWM	ETF	110.7	110.85	110.06	110.53	5909807.0
2014-02-10 10:00:00	IWM	ETF	110.54	110.56	109.96	110.19	5109907.0
2014-02-10 11:00:00	IWM	ETF	110.19	110.5	109.97	110.43	2795686.0
2014-02-10 12:00:00	IWM	ETF	110.4299	110.55	110.36	110.49	2509972.0
2014-02-10 13:00:00	IWM	ETF	110.5	110.72	110.4075	110.69	1589157.0
2014-02-10 14:00:00	IWM	ETF	110.7	110.98	110.665	110.82	2355619.0
2014-02-10 15:00:00	IWM	ETF	110.825	111.09	110.79	111.06	3968246.0
2014-02-10 16:00:00	IWM	ETF	111.06	111.06	110.841	111.02	6266066.0
2014-02-10 17:00:00	IWM	ETF	111.04	111.13	110.98	111.03	34864.0
2014-02-10 18:00:00	IWM	ETF	111.03	111.03	110.98	110.98	600.0
2014-02-10 19:00:00	IWM	ETF	110.99	111.06	110.98	111.03	49400.0
2014-02-10 08:00:00	DIA	ETF	157.6	157.65	157.59	157.59	9567.0
2014-02-10 09:00:00	DIA	ETF	157.65	157.78	157.31	157.63	863105.0
2014-02-10 10:00:00	DIA	ETF	157.63	157.64	157.17	157.31	915005.0
2014-02-10 11:00:00	DIA	ETF	157.31	157.65	157.13	157.546	719915.0
2014-02-10 12:00:00	DIA	ETF	157.55	157.605	157.43	157.555	291680.0

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

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