PREVIEW / etf_1hour / 2013-12-06

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-12-06.parquet
  size:    214 KB
  rows:    6,687

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-12-06 04:00:00	SPY	ETF	179.47	179.84	179.4	179.76	134615.0
2013-12-06 05:00:00	SPY	ETF	179.78	179.8	179.62	179.62	48655.0
2013-12-06 06:00:00	SPY	ETF	179.6	179.9	179.6	179.87	112660.0
2013-12-06 07:00:00	SPY	ETF	179.87	179.89	179.6	179.7	413957.0
2013-12-06 08:00:00	SPY	ETF	179.7	180.93	179.14	180.65	10528690.0
2013-12-06 09:00:00	SPY	ETF	180.66	180.9	180.36	180.545	19528637.0
2013-12-06 10:00:00	SPY	ETF	180.55	180.72	180.15	180.358	16795520.0
2013-12-06 11:00:00	SPY	ETF	180.35	180.77	180.27	180.74	13687220.0
2013-12-06 12:00:00	SPY	ETF	180.75	180.97	180.57	180.94	7531053.0
2013-12-06 13:00:00	SPY	ETF	180.93	181.11	180.81	180.999	12869716.0
2013-12-06 14:00:00	SPY	ETF	180.995	181.11	180.87	180.945	7848110.0
2013-12-06 15:00:00	SPY	ETF	180.945	181.02	180.6	180.93	23192014.0
2013-12-06 16:00:00	SPY	ETF	180.93	181.06	178.9884	181.05	11541822.0
2013-12-06 17:00:00	SPY	ETF	181.05	181.1	180.94	181.1	1690687.0
2013-12-06 18:00:00	SPY	ETF	181.1	181.1	181.01	181.01	25912.0
2013-12-06 19:00:00	SPY	ETF	181.02	181.23	181.02	181.17	106924.0
2013-12-06 20:00:00	SPY	ETF	181.17	181.17	181.17	181.17	200.0
2013-12-06 04:00:00	QQQ	ETF	85.65	85.78	85.65	85.77	21440.0
2013-12-06 05:00:00	QQQ	ETF	85.73	85.73	85.7	85.7	2200.0
2013-12-06 06:00:00	QQQ	ETF	85.67	85.76	85.67	85.76	6100.0
2013-12-06 07:00:00	QQQ	ETF	85.75	85.75	85.66	85.69	80100.0
2013-12-06 08:00:00	QQQ	ETF	85.69	86.15	85.45	86.07	2142235.0
2013-12-06 09:00:00	QQQ	ETF	86.08	86.16	85.88	85.99	6910116.0
2013-12-06 10:00:00	QQQ	ETF	86.0	86.07	85.59	85.775	6192101.0
2013-12-06 11:00:00	QQQ	ETF	85.77	86.09	85.73	86.075	4203004.0
2013-12-06 12:00:00	QQQ	ETF	86.075	86.18	86.03	86.15	2551750.0
2013-12-06 13:00:00	QQQ	ETF	86.14	86.17	86.01	86.0847	2110338.0
2013-12-06 14:00:00	QQQ	ETF	86.09	86.15	86.0249	86.06	1647983.0
2013-12-06 15:00:00	QQQ	ETF	86.06	86.09	85.9	85.99	6235596.0
2013-12-06 16:00:00	QQQ	ETF	85.99	86.06	85.964	86.05	1148721.0
2013-12-06 17:00:00	QQQ	ETF	86.05	86.06	86.05	86.06	4400.0
2013-12-06 18:00:00	QQQ	ETF	86.07	86.11	86.02	86.02	3570.0
2013-12-06 19:00:00	QQQ	ETF	86.09	86.12	86.06	86.12	8100.0
2013-12-06 06:00:00	IWM	ETF	111.47	113.9	111.47	112.1	5161.0
2013-12-06 07:00:00	IWM	ETF	112.13	112.15	111.98	112.03	160747.0
2013-12-06 08:00:00	IWM	ETF	112.04	112.92	111.68	112.75	1595702.0
2013-12-06 09:00:00	IWM	ETF	112.74	112.99	112.43	112.64	5557312.0
2013-12-06 10:00:00	IWM	ETF	112.65	112.84	112.19	112.44	5715027.0
2013-12-06 11:00:00	IWM	ETF	112.45	112.985	112.37	112.95	3267957.0
2013-12-06 12:00:00	IWM	ETF	112.945	113.1	112.84	113.03	2494143.0
2013-12-06 13:00:00	IWM	ETF	113.02	113.03	112.68	112.71	1862833.0
2013-12-06 14:00:00	IWM	ETF	112.707	112.83	112.62	112.7	1841266.0
2013-12-06 15:00:00	IWM	ETF	112.715	112.74	112.46	112.5	6626708.0
2013-12-06 16:00:00	IWM	ETF	112.5	112.7634	111.634	112.43	1729383.0
2013-12-06 17:00:00	IWM	ETF	112.43	112.51	112.43	112.51	28996.0
2013-12-06 18:00:00	IWM	ETF	112.51	112.51	112.51	112.51	300.0
2013-12-06 19:00:00	IWM	ETF	112.47	112.47	112.45	112.45	1100.0
2013-12-06 04:00:00	DIA	ETF	158.77	158.77	158.77	158.77	500.0
2013-12-06 08:00:00	DIA	ETF	158.75	160.55	158.6	159.48	60552.0
2013-12-06 09:00:00	DIA	ETF	159.51	159.72	159.33	159.52	1059581.0

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

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