PREVIEW / etf_1hour / 2014-02-05

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-02-05.parquet
  size:    220 KB
  rows:    6,931

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-02-05 04:00:00	SPY	ETF	174.76	174.92	174.69	174.79	144896.0
2014-02-05 05:00:00	SPY	ETF	174.75	174.88	174.61	174.62	37764.0
2014-02-05 06:00:00	SPY	ETF	174.6	174.76	174.42	174.52	84033.0
2014-02-05 07:00:00	SPY	ETF	174.55	174.71	174.3	174.37	612175.0
2014-02-05 08:00:00	SPY	ETF	174.37	174.87	173.94	174.76	3533700.0
2014-02-05 09:00:00	SPY	ETF	174.75	175.19	174.37	174.52	21196983.0
2014-02-05 10:00:00	SPY	ETF	174.53	175.4	173.71	174.31	41251698.0
2014-02-05 11:00:00	SPY	ETF	174.32	175.26	173.92	175.14	20243120.0
2014-02-05 12:00:00	SPY	ETF	175.1399	175.36	174.91	175.18	13962915.0
2014-02-05 13:00:00	SPY	ETF	175.18	175.56	175.16	175.41	15081320.0
2014-02-05 14:00:00	SPY	ETF	175.41	175.56	174.93	175.0199	12582406.0
2014-02-05 15:00:00	SPY	ETF	175.0199	175.54	174.92	175.14	24697581.0
2014-02-05 16:00:00	SPY	ETF	175.14	175.515	174.8	175.07	8012132.0
2014-02-05 17:00:00	SPY	ETF	175.08	175.12	174.95	174.95	330231.0
2014-02-05 18:00:00	SPY	ETF	174.95	175.1	174.94	175.1	146145.0
2014-02-05 19:00:00	SPY	ETF	175.02	175.39	175.02	175.24	446723.0
2014-02-05 05:00:00	QQQ	ETF	84.67	84.67	84.57	84.57	3800.0
2014-02-05 06:00:00	QQQ	ETF	84.51	84.56	84.48	84.56	3200.0
2014-02-05 07:00:00	QQQ	ETF	84.57	84.67	84.51	84.51	68200.0
2014-02-05 08:00:00	QQQ	ETF	84.54	84.77	84.35	84.75	212315.0
2014-02-05 09:00:00	QQQ	ETF	84.73	84.89	84.33	84.43	6361417.0
2014-02-05 10:00:00	QQQ	ETF	84.38	84.8199	83.74	84.09	11425489.0
2014-02-05 11:00:00	QQQ	ETF	84.09	84.77	83.87	84.7203	5746513.0
2014-02-05 12:00:00	QQQ	ETF	84.73	84.87	84.59	84.789	3801051.0
2014-02-05 13:00:00	QQQ	ETF	84.8	84.9901	84.77	84.9	2616994.0
2014-02-05 14:00:00	QQQ	ETF	84.9	84.97	84.63	84.661	2366077.0
2014-02-05 15:00:00	QQQ	ETF	84.661	84.87	84.6	84.67	4709496.0
2014-02-05 16:00:00	QQQ	ETF	84.66	85.01	84.48	84.63	2073562.0
2014-02-05 17:00:00	QQQ	ETF	84.91	84.91	84.55	84.58	118811.0
2014-02-05 18:00:00	QQQ	ETF	84.6	84.7	84.6	84.69	87800.0
2014-02-05 19:00:00	QQQ	ETF	84.68	84.82	84.67	84.75	94682.0
2014-02-05 06:00:00	IWM	ETF	108.99	108.99	108.99	108.99	4200.0
2014-02-05 07:00:00	IWM	ETF	108.76	109.0	108.61	108.64	147800.0
2014-02-05 08:00:00	IWM	ETF	108.66	109.03	108.32	108.99	544804.0
2014-02-05 09:00:00	IWM	ETF	108.99	109.15	108.05	108.29	7333333.0
2014-02-05 10:00:00	IWM	ETF	108.32	108.95	107.27	107.78	16023987.0
2014-02-05 11:00:00	IWM	ETF	107.78	108.58	107.43	108.43	6484015.0
2014-02-05 12:00:00	IWM	ETF	108.44	108.74	108.25	108.58	3398875.0
2014-02-05 13:00:00	IWM	ETF	108.58	108.9899	108.58	108.76	4099502.0
2014-02-05 14:00:00	IWM	ETF	108.75	108.85	108.29	108.36	3000516.0
2014-02-05 15:00:00	IWM	ETF	108.35	108.71	108.23	108.58	7416251.0
2014-02-05 16:00:00	IWM	ETF	108.6	109.4704	108.0134	108.54	4225397.0
2014-02-05 17:00:00	IWM	ETF	108.54	108.55	108.45	108.45	6591.0
2014-02-05 18:00:00	IWM	ETF	108.5	108.55	108.5	108.55	4800.0
2014-02-05 19:00:00	IWM	ETF	108.55	108.77	108.55	108.77	16313.0
2014-02-05 06:00:00	DIA	ETF	153.6	153.6	153.6	153.6	100.0
2014-02-05 07:00:00	DIA	ETF	153.53	153.54	153.53	153.54	2100.0
2014-02-05 08:00:00	DIA	ETF	153.49	153.83	153.18	153.8	28045.0
2014-02-05 09:00:00	DIA	ETF	153.81	154.14	153.47	153.635	1471083.0
2014-02-05 10:00:00	DIA	ETF	153.64	154.48	153.12	153.68	3734663.0

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

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