PREVIEW / etf_1hour / 2015-02-06

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-02-06.parquet
  size:    243 KB
  rows:    7,686

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
2015-02-06 04:00:00	SPY	ETF	205.96	206.21	205.96	206.21	9400.0
2015-02-06 05:00:00	SPY	ETF	206.03	206.11	205.91	205.98	32062.0
2015-02-06 06:00:00	SPY	ETF	206.01	206.14	206.0	206.1	25181.0
2015-02-06 07:00:00	SPY	ETF	206.1	206.33	206.06	206.11	119786.0
2015-02-06 08:00:00	SPY	ETF	206.11	206.99	205.79	206.61	3299716.0
2015-02-06 09:00:00	SPY	ETF	206.6	206.78	206.07	206.5	12965406.0
2015-02-06 10:00:00	SPY	ETF	206.5	207.24	206.48	207.01	14660884.0
2015-02-06 11:00:00	SPY	ETF	207.01	207.18	206.76	207.04	10093858.0
2015-02-06 12:00:00	SPY	ETF	207.04	207.13	206.36	206.82	11612185.0
2015-02-06 13:00:00	SPY	ETF	206.82	206.89	205.73	206.2399	16022748.0
2015-02-06 14:00:00	SPY	ETF	206.24	206.59	205.79	205.81	11322358.0
2015-02-06 15:00:00	SPY	ETF	205.81	205.83	204.92	205.51	29383601.0
2015-02-06 16:00:00	SPY	ETF	205.55	206.5811	205.4	205.92	13481421.0
2015-02-06 17:00:00	SPY	ETF	205.93	206.06	205.55	206.0	1739498.0
2015-02-06 18:00:00	SPY	ETF	206.02	206.05	205.95	205.95	51660.0
2015-02-06 19:00:00	SPY	ETF	205.99	206.04	205.95	206.04	37170.0
2015-02-06 04:00:00	QQQ	ETF	103.75	103.75	103.71	103.71	500.0
2015-02-06 06:00:00	QQQ	ETF	103.75	103.75	103.75	103.75	100.0
2015-02-06 07:00:00	QQQ	ETF	103.76	103.77	103.69	103.69	54300.0
2015-02-06 08:00:00	QQQ	ETF	103.67	104.01	103.65	103.93	304228.0
2015-02-06 09:00:00	QQQ	ETF	103.9	103.99	103.42	103.69	3502194.0
2015-02-06 10:00:00	QQQ	ETF	103.69	104.17	103.63	104.0399	4984626.0
2015-02-06 11:00:00	QQQ	ETF	104.03	104.15	103.951	104.0599	2177431.0
2015-02-06 12:00:00	QQQ	ETF	104.06	104.1049	103.62	103.86	2801530.0
2015-02-06 13:00:00	QQQ	ETF	103.861	103.89	103.25	103.53	3633569.0
2015-02-06 14:00:00	QQQ	ETF	103.53	103.7631	103.35	103.36	2401899.0
2015-02-06 15:00:00	QQQ	ETF	103.36	103.36	102.76	103.12	8036450.0
2015-02-06 16:00:00	QQQ	ETF	103.11	103.586	103.08	103.27	955499.0
2015-02-06 17:00:00	QQQ	ETF	103.28	103.36	103.15	103.15	21849.0
2015-02-06 18:00:00	QQQ	ETF	103.3	103.3	103.17	103.2	1395.0
2015-02-06 19:00:00	QQQ	ETF	103.25	103.3	103.25	103.3	300.0
2015-02-06 07:00:00	IWM	ETF	119.85	119.85	119.76	119.76	5600.0
2015-02-06 08:00:00	IWM	ETF	119.78	120.3	119.67	120.15	548857.0
2015-02-06 09:00:00	IWM	ETF	120.18	120.43	119.865	120.17	3450772.0
2015-02-06 10:00:00	IWM	ETF	120.18	120.8	120.18	120.58	4986043.0
2015-02-06 11:00:00	IWM	ETF	120.58	120.82	120.42	120.45	2199813.0
2015-02-06 12:00:00	IWM	ETF	120.46	120.53	120.02	120.35	2232235.0
2015-02-06 13:00:00	IWM	ETF	120.345	120.38	119.48	119.85	2985058.0
2015-02-06 14:00:00	IWM	ETF	119.845	120.17	119.57	119.77	2199301.0
2015-02-06 15:00:00	IWM	ETF	119.76	119.84	119.35	119.83	7838743.0
2015-02-06 16:00:00	IWM	ETF	119.84	119.89	119.72	119.89	1471988.0
2015-02-06 17:00:00	IWM	ETF	119.89	120.05	119.84	120.05	4188.0
2015-02-06 18:00:00	IWM	ETF	119.93	119.93	119.93	119.93	200.0
2015-02-06 19:00:00	IWM	ETF	119.91	119.91	119.91	119.91	2660.0
2015-02-06 06:00:00	DIA	ETF	178.55	178.55	178.55	178.55	850.0
2015-02-06 08:00:00	DIA	ETF	178.21	179.189	178.21	178.98	13250.0
2015-02-06 09:00:00	DIA	ETF	178.88	179.07	178.5	178.85	934316.0
2015-02-06 10:00:00	DIA	ETF	178.85	179.36	178.811	179.13	1339999.0
2015-02-06 11:00:00	DIA	ETF	179.12	179.2301	178.92	179.07	605691.0
2015-02-06 12:00:00	DIA	ETF	179.075	179.21	178.64	178.97	521182.0

> showing 50 of 7,686 rows — these rows as CSV

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