PREVIEW / etf_1hour / 2014-04-09

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-04-09.parquet
  size:    216 KB
  rows:    6,794

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-04-09 04:00:00	SPY	ETF	185.09	185.41	185.02	185.34	18332.0
2014-04-09 05:00:00	SPY	ETF	185.31	185.36	185.24	185.32	10836.0
2014-04-09 06:00:00	SPY	ETF	185.26	185.3	185.11	185.18	65288.0
2014-04-09 07:00:00	SPY	ETF	185.17	185.33	185.07	185.32	168228.0
2014-04-09 08:00:00	SPY	ETF	185.12	185.64	185.0	185.56	560083.0
2014-04-09 09:00:00	SPY	ETF	185.56	185.7	185.11	185.31	12622614.0
2014-04-09 10:00:00	SPY	ETF	185.31	185.77	185.06	185.37	14295157.0
2014-04-09 11:00:00	SPY	ETF	185.37	185.74	185.24	185.67	8337755.0
2014-04-09 12:00:00	SPY	ETF	185.67	186.0	185.592	185.83	6893867.0
2014-04-09 13:00:00	SPY	ETF	185.83	185.95	185.69	185.75	5714433.0
2014-04-09 14:00:00	SPY	ETF	185.75	186.9	185.75	186.58	24682324.0
2014-04-09 15:00:00	SPY	ETF	186.58	187.15	186.52	187.12	18526708.0
2014-04-09 16:00:00	SPY	ETF	187.11	187.15	185.9298	187.06	4920704.0
2014-04-09 17:00:00	SPY	ETF	187.07	187.11	187.05	187.06	1095053.0
2014-04-09 18:00:00	SPY	ETF	187.07	187.16	187.07	187.13	139049.0
2014-04-09 19:00:00	SPY	ETF	187.15	187.22	187.13	187.2	85586.0
2014-04-09 04:00:00	QQQ	ETF	86.36	86.54	86.36	86.54	13500.0
2014-04-09 05:00:00	QQQ	ETF	86.52	86.52	86.52	86.52	120.0
2014-04-09 06:00:00	QQQ	ETF	86.42	86.5	86.42	86.5	106800.0
2014-04-09 07:00:00	QQQ	ETF	86.45	86.51	86.4	86.5	14900.0
2014-04-09 08:00:00	QQQ	ETF	86.51	86.7	86.44	86.69	263352.0
2014-04-09 09:00:00	QQQ	ETF	86.67	86.81	86.43	86.6727	7836872.0
2014-04-09 10:00:00	QQQ	ETF	86.67	86.96	86.44	86.79	7072176.0
2014-04-09 11:00:00	QQQ	ETF	86.79	87.0	86.66	86.925	3137436.0
2014-04-09 12:00:00	QQQ	ETF	86.92	87.1498	86.865	87.03	2610034.0
2014-04-09 13:00:00	QQQ	ETF	87.04	87.12	86.91	86.92	2509330.0
2014-04-09 14:00:00	QQQ	ETF	86.92	87.68	86.92	87.48	10010865.0
2014-04-09 15:00:00	QQQ	ETF	87.475	87.87	87.43	87.8	7094705.0
2014-04-09 16:00:00	QQQ	ETF	87.8	87.86	86.3163	87.84	2312670.0
2014-04-09 17:00:00	QQQ	ETF	87.85	87.89	87.85	87.89	7023.0
2014-04-09 18:00:00	QQQ	ETF	87.87	87.87	87.82	87.85	63499.0
2014-04-09 19:00:00	QQQ	ETF	87.84	87.92	87.84	87.92	55831.0
2014-04-09 07:00:00	IWM	ETF	113.64	113.85	113.64	113.85	95000.0
2014-04-09 08:00:00	IWM	ETF	113.84	114.08	113.78	114.05	259888.0
2014-04-09 09:00:00	IWM	ETF	114.03	114.34	113.58	113.81	5294475.0
2014-04-09 10:00:00	IWM	ETF	113.81	114.16	113.5	113.77	5863168.0
2014-04-09 11:00:00	IWM	ETF	113.77	114.17	113.53	114.13	3209939.0
2014-04-09 12:00:00	IWM	ETF	114.14	114.55	114.01	114.31	2254761.0
2014-04-09 13:00:00	IWM	ETF	114.33	114.511	114.19	114.19	1801112.0
2014-04-09 14:00:00	IWM	ETF	114.2	115.15	114.199	114.6399	7867590.0
2014-04-09 15:00:00	IWM	ETF	114.63	115.25	114.55	115.19	7429672.0
2014-04-09 16:00:00	IWM	ETF	115.18	115.25	115.03	115.15	1351640.0
2014-04-09 17:00:00	IWM	ETF	115.15	115.19	115.15	115.19	15700.0
2014-04-09 18:00:00	IWM	ETF	115.15	115.19	115.15	115.19	3800.0
2014-04-09 19:00:00	IWM	ETF	115.18	115.2	115.17	115.2	9100.0
2014-04-09 09:00:00	DIA	ETF	162.87	163.07	162.45	162.64	872114.0
2014-04-09 10:00:00	DIA	ETF	162.6	162.95	162.43	162.56	861207.0
2014-04-09 11:00:00	DIA	ETF	162.57	162.925	162.48	162.87	395688.0
2014-04-09 12:00:00	DIA	ETF	162.88	163.2	162.8	163.06	440751.0
2014-04-09 13:00:00	DIA	ETF	163.059	163.165	162.98	163.06	417991.0

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

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