PREVIEW / etf_1hour / 2013-06-20

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-06-20.parquet
  size:    228 KB
  rows:    7,141

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
2013-06-20 04:00:00	SPY	ETF	163.0	163.06	162.4	162.4	71033.0
2013-06-20 05:00:00	SPY	ETF	162.36	162.63	161.76	161.92	119150.0
2013-06-20 06:00:00	SPY	ETF	161.94	162.28	161.79	162.22	198803.0
2013-06-20 07:00:00	SPY	ETF	162.17	162.44	161.87	162.19	1108639.0
2013-06-20 08:00:00	SPY	ETF	162.19	162.44	161.94	162.01	1711295.0
2013-06-20 09:00:00	SPY	ETF	162.0	162.1	161.39	161.7299	34260218.0
2013-06-20 10:00:00	SPY	ETF	161.73	162.01	160.63	161.08	45390784.0
2013-06-20 11:00:00	SPY	ETF	161.09	161.19	160.48	161.06	28259766.0
2013-06-20 12:00:00	SPY	ETF	161.045	161.48	160.821	160.85	19138122.0
2013-06-20 13:00:00	SPY	ETF	160.855	161.07	160.49	160.89	22211488.0
2013-06-20 14:00:00	SPY	ETF	160.895	161.25	159.36	159.418	48992766.0
2013-06-20 15:00:00	SPY	ETF	159.41	160.5666	158.98	159.38	79656068.0
2013-06-20 16:00:00	SPY	ETF	159.37	163.4668	159.2907	159.62	27608104.0
2013-06-20 17:00:00	SPY	ETF	159.6	159.69	159.4371	159.58	2466249.0
2013-06-20 18:00:00	SPY	ETF	159.6	159.79	159.51	159.51	354637.0
2013-06-20 19:00:00	SPY	ETF	159.54	159.68	159.51	159.61	116044.0
2013-06-20 04:00:00	QQQ	ETF	72.52	72.52	72.15	72.18	12378.0
2013-06-20 05:00:00	QQQ	ETF	72.15	72.27	71.94	72.0	13170.0
2013-06-20 06:00:00	QQQ	ETF	72.0	72.09	71.91	72.06	51724.0
2013-06-20 07:00:00	QQQ	ETF	72.09	72.15	71.99	72.07	36500.0
2013-06-20 08:00:00	QQQ	ETF	72.09	72.19	72.04	72.08	117849.0
2013-06-20 09:00:00	QQQ	ETF	72.08	72.16	71.82	72.0499	7523958.0
2013-06-20 10:00:00	QQQ	ETF	72.05	72.15	71.66	71.76	10383394.0
2013-06-20 11:00:00	QQQ	ETF	71.7601	71.77	71.46	71.61	6181688.0
2013-06-20 12:00:00	QQQ	ETF	71.609	71.79	71.42	71.46	3244954.0
2013-06-20 13:00:00	QQQ	ETF	71.45	71.6	71.33	71.51	3844803.0
2013-06-20 14:00:00	QQQ	ETF	71.51	71.525	70.94	70.98	7967838.0
2013-06-20 15:00:00	QQQ	ETF	70.98	71.15	70.79	70.97	12313777.0
2013-06-20 16:00:00	QQQ	ETF	70.965	72.6765	70.83	70.85	5454718.0
2013-06-20 17:00:00	QQQ	ETF	70.85	70.88	70.8	70.85	49468.0
2013-06-20 18:00:00	QQQ	ETF	70.84	70.93	70.83	70.83	14529.0
2013-06-20 19:00:00	QQQ	ETF	70.88	70.9	70.8	70.9	8839.0
2013-06-20 04:00:00	IWM	ETF	97.7	97.7	97.26	97.26	2118.0
2013-06-20 05:00:00	IWM	ETF	97.25	97.25	97.0	97.0	13318.0
2013-06-20 06:00:00	IWM	ETF	97.04	97.33	96.8	97.08	9164.0
2013-06-20 07:00:00	IWM	ETF	97.1	97.2	96.83	97.1	163332.0
2013-06-20 08:00:00	IWM	ETF	97.09	97.31	96.99	97.03	513080.0
2013-06-20 09:00:00	IWM	ETF	97.04	97.04	96.21	96.45	9112652.0
2013-06-20 10:00:00	IWM	ETF	96.45	96.81	96.1	96.38	11208622.0
2013-06-20 11:00:00	IWM	ETF	96.38	96.41	96.04	96.21	5915466.0
2013-06-20 12:00:00	IWM	ETF	96.21	96.49	96.1	96.11	3676413.0
2013-06-20 13:00:00	IWM	ETF	96.11	96.27	95.96	96.25	3670109.0
2013-06-20 14:00:00	IWM	ETF	96.25	96.3	95.4	95.41	8630457.0
2013-06-20 15:00:00	IWM	ETF	95.41	95.94	95.29	95.69	14699241.0
2013-06-20 16:00:00	IWM	ETF	95.69	95.9981	95.52	95.53	4248622.0
2013-06-20 17:00:00	IWM	ETF	95.53	95.67	95.51	95.67	52400.0
2013-06-20 18:00:00	IWM	ETF	95.67	95.68	95.67	95.68	1536.0
2013-06-20 19:00:00	IWM	ETF	95.56	95.56	95.56	95.56	150.0
2013-06-20 04:00:00	DIA	ETF	150.67	150.67	150.67	150.67	100.0
2013-06-20 05:00:00	DIA	ETF	150.2	150.2	150.1	150.1	700.0

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

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