PREVIEW / etf_1hour / 2015-02-09

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-02-09.parquet
  size:    239 KB
  rows:    7,612

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-09 04:00:00	SPY	ETF	204.85	204.85	204.51	204.59	105893.0
2015-02-09 05:00:00	SPY	ETF	204.5	204.99	204.45	204.81	81605.0
2015-02-09 06:00:00	SPY	ETF	204.86	204.86	204.46	204.49	129114.0
2015-02-09 07:00:00	SPY	ETF	204.45	204.93	204.43	204.86	345621.0
2015-02-09 08:00:00	SPY	ETF	204.87	204.93	204.37	204.69	1208462.0
2015-02-09 09:00:00	SPY	ETF	204.72	205.6	204.61	205.34	13156434.0
2015-02-09 10:00:00	SPY	ETF	205.35	205.49	204.69	204.76	12481152.0
2015-02-09 11:00:00	SPY	ETF	204.755	205.53	204.73	205.27	8238327.0
2015-02-09 12:00:00	SPY	ETF	205.27	205.64	205.09	205.285	6697151.0
2015-02-09 13:00:00	SPY	ETF	205.285	205.43	204.81	205.03	7763385.0
2015-02-09 14:00:00	SPY	ETF	205.04	205.06	204.53	204.56	8021461.0
2015-02-09 15:00:00	SPY	ETF	204.57	204.93	204.135	204.59	20866257.0
2015-02-09 16:00:00	SPY	ETF	204.59	205.1161	204.5	204.78	6585313.0
2015-02-09 17:00:00	SPY	ETF	204.78	204.87	204.63	204.82	586825.0
2015-02-09 18:00:00	SPY	ETF	204.84	205.0	204.84	204.96	77755.0
2015-02-09 19:00:00	SPY	ETF	204.99	205.03	204.86	204.94	53981.0
2015-02-09 04:00:00	QQQ	ETF	102.73	102.73	102.65	102.65	7100.0
2015-02-09 05:00:00	QQQ	ETF	102.64	103.46	102.64	103.46	16300.0
2015-02-09 06:00:00	QQQ	ETF	102.67	102.67	102.6	102.6	7900.0
2015-02-09 07:00:00	QQQ	ETF	102.6	102.83	102.6	102.81	112860.0
2015-02-09 08:00:00	QQQ	ETF	102.81	102.83	102.57	102.68	124445.0
2015-02-09 09:00:00	QQQ	ETF	102.69	103.13	102.65	102.98	3320607.0
2015-02-09 10:00:00	QQQ	ETF	102.97	103.07	102.55	102.6	2511726.0
2015-02-09 11:00:00	QQQ	ETF	102.6	103.12	102.6	102.98	1879972.0
2015-02-09 12:00:00	QQQ	ETF	102.98	103.285	102.92	103.17	3746172.0
2015-02-09 13:00:00	QQQ	ETF	103.165	103.24	102.925	103.0	2901678.0
2015-02-09 14:00:00	QQQ	ETF	103.01	103.04	102.75	102.77	2318743.0
2015-02-09 15:00:00	QQQ	ETF	102.77	103.03	102.61	102.79	3700467.0
2015-02-09 16:00:00	QQQ	ETF	102.79	102.99	102.77	102.93	301082.0
2015-02-09 17:00:00	QQQ	ETF	102.92	102.96	102.9	102.9	8000.0
2015-02-09 18:00:00	QQQ	ETF	102.95	103.04	102.95	102.99	6247.0
2015-02-09 19:00:00	QQQ	ETF	103.05	103.05	102.93	102.98	5520.0
2015-02-09 05:00:00	IWM	ETF	119.51	119.51	119.51	119.51	500.0
2015-02-09 06:00:00	IWM	ETF	119.31	119.31	119.31	119.31	500.0
2015-02-09 07:00:00	IWM	ETF	119.5	119.63	119.26	119.63	14586.0
2015-02-09 08:00:00	IWM	ETF	119.57	119.61	119.11	119.33	119416.0
2015-02-09 09:00:00	IWM	ETF	119.35	120.14	119.29	120.109	2770596.0
2015-02-09 10:00:00	IWM	ETF	120.11	120.22	119.21	119.3	4035137.0
2015-02-09 11:00:00	IWM	ETF	119.3	119.88	119.26	119.79	2135350.0
2015-02-09 12:00:00	IWM	ETF	119.78	119.83	119.54	119.6	1109865.0
2015-02-09 13:00:00	IWM	ETF	119.59	119.725	119.33	119.38	1200874.0
2015-02-09 14:00:00	IWM	ETF	119.38	119.38	118.91	118.91	2909989.0
2015-02-09 15:00:00	IWM	ETF	118.91	119.015	118.72	118.86	5554337.0
2015-02-09 16:00:00	IWM	ETF	118.86	119.7649	118.77	118.98	4407975.0
2015-02-09 17:00:00	IWM	ETF	119.0	119.04	118.96	119.01	56418.0
2015-02-09 18:00:00	IWM	ETF	119.01	119.01	119.01	119.01	1200.0
2015-02-09 19:00:00	IWM	ETF	119.02	119.02	119.0	119.02	1915.0
2015-02-09 04:00:00	DIA	ETF	177.39	177.39	177.39	177.39	100.0
2015-02-09 06:00:00	DIA	ETF	177.53	177.53	177.53	177.53	100.0
2015-02-09 07:00:00	DIA	ETF	177.05	177.55	177.05	177.55	1000.0

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

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