PREVIEW / etf_1hour / 2014-12-12

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-12-12.parquet
  size:    238 KB
  rows:    7,600

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-12-12 04:00:00	SPY	ETF	202.78	202.78	202.24	202.4	28906.0
2014-12-12 05:00:00	SPY	ETF	202.6	202.64	202.27	202.3	77861.0
2014-12-12 06:00:00	SPY	ETF	202.3	202.65	202.27	202.61	203849.0
2014-12-12 07:00:00	SPY	ETF	202.59	202.99	202.59	202.71	504367.0
2014-12-12 08:00:00	SPY	ETF	202.71	203.0	202.34	202.59	2441069.0
2014-12-12 09:00:00	SPY	ETF	202.61	203.819	202.44	203.73	22778901.0
2014-12-12 10:00:00	SPY	ETF	203.74	203.8	202.17	202.26	29727822.0
2014-12-12 11:00:00	SPY	ETF	202.27	202.57	201.78	201.86	26275075.0
2014-12-12 12:00:00	SPY	ETF	201.86	202.74	201.85	202.44	16073580.0
2014-12-12 13:00:00	SPY	ETF	202.44	203.2	202.16	203.03	16741610.0
2014-12-12 14:00:00	SPY	ETF	203.025	203.05	202.17	202.565	15086898.0
2014-12-12 15:00:00	SPY	ETF	202.56	202.69	200.85	200.87	43492749.0
2014-12-12 16:00:00	SPY	ETF	200.86	204.136	200.31	200.49	18046697.0
2014-12-12 17:00:00	SPY	ETF	200.48	200.61	200.41	200.55	703698.0
2014-12-12 18:00:00	SPY	ETF	200.56	200.89	200.52	200.63	169832.0
2014-12-12 19:00:00	SPY	ETF	200.62	200.65	200.55	200.56	63697.0
2014-12-12 04:00:00	QQQ	ETF	103.03	103.03	102.58	102.75	14226.0
2014-12-12 05:00:00	QQQ	ETF	102.76	102.86	102.6	102.78	30020.0
2014-12-12 06:00:00	QQQ	ETF	102.69	102.88	102.69	102.86	11100.0
2014-12-12 07:00:00	QQQ	ETF	102.84	103.1	102.84	102.97	27959.0
2014-12-12 08:00:00	QQQ	ETF	102.97	103.19	102.6457	102.95	670278.0
2014-12-12 09:00:00	QQQ	ETF	102.94	103.99	102.715	103.93	9477664.0
2014-12-12 10:00:00	QQQ	ETF	103.95	103.99	103.08	103.13	7354987.0
2014-12-12 11:00:00	QQQ	ETF	103.14	103.635	102.951	103.25	5921269.0
2014-12-12 12:00:00	QQQ	ETF	103.25	103.58	103.16	103.35	3716469.0
2014-12-12 13:00:00	QQQ	ETF	103.35	103.8999	103.26	103.82	3453148.0
2014-12-12 14:00:00	QQQ	ETF	103.82	103.84	103.3	103.48	2823083.0
2014-12-12 15:00:00	QQQ	ETF	103.485	103.58	102.67	102.68	7894202.0
2014-12-12 16:00:00	QQQ	ETF	102.67	103.5215	102.14	102.43	2456086.0
2014-12-12 17:00:00	QQQ	ETF	102.44	102.53	102.42	102.53	31031.0
2014-12-12 18:00:00	QQQ	ETF	102.67	102.67	102.52	102.52	15460.0
2014-12-12 19:00:00	QQQ	ETF	102.55	102.57	102.51	102.51	1052.0
2014-12-12 04:00:00	IWM	ETF	115.61	115.61	115.08	115.08	1680.0
2014-12-12 06:00:00	IWM	ETF	114.93	114.93	114.64	114.75	1100.0
2014-12-12 07:00:00	IWM	ETF	114.83	115.16	114.83	115.0	26868.0
2014-12-12 08:00:00	IWM	ETF	114.97	115.24	114.7	114.79	290986.0
2014-12-12 09:00:00	IWM	ETF	114.79	115.73	114.67	115.65	6679907.0
2014-12-12 10:00:00	IWM	ETF	115.67	115.69	114.76	114.81	7307353.0
2014-12-12 11:00:00	IWM	ETF	114.815	115.47	114.6	114.92	4751181.0
2014-12-12 12:00:00	IWM	ETF	114.93	115.53	114.87	115.31	2679698.0
2014-12-12 13:00:00	IWM	ETF	115.34	115.99	115.2	115.655	2723614.0
2014-12-12 14:00:00	IWM	ETF	115.65	115.73	115.3	115.59	2444195.0
2014-12-12 15:00:00	IWM	ETF	115.59	115.69	114.66	114.68	7432424.0
2014-12-12 16:00:00	IWM	ETF	114.68	114.76	114.16	114.35	2914784.0
2014-12-12 17:00:00	IWM	ETF	114.35	114.45	114.33	114.45	72294.0
2014-12-12 18:00:00	IWM	ETF	114.49	114.54	114.49	114.54	600.0
2014-12-12 19:00:00	IWM	ETF	114.63	114.63	114.55	114.55	500.0
2014-12-12 08:00:00	DIA	ETF	174.93	175.0	174.5	174.7	7663.0
2014-12-12 09:00:00	DIA	ETF	174.75	175.659	174.54	175.63	1381132.0
2014-12-12 10:00:00	DIA	ETF	175.63	175.67	174.2	174.26	1520081.0

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

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