PREVIEW / etf_1hour / 2015-08-07

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-08-07.parquet
  size:    236 KB
  rows:    7,459

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-08-07 04:00:00	SPY	ETF	208.52	208.69	208.33	208.63	11960.0
2015-08-07 05:00:00	SPY	ETF	208.68	208.68	208.31	208.34	6000.0
2015-08-07 06:00:00	SPY	ETF	208.29	208.43	208.27	208.35	11420.0
2015-08-07 07:00:00	SPY	ETF	208.38	208.43	208.07	208.18	219260.0
2015-08-07 08:00:00	SPY	ETF	208.18	208.85	207.76	208.85	3020096.0
2015-08-07 09:00:00	SPY	ETF	208.85	208.9	207.68	208.21	16370448.0
2015-08-07 10:00:00	SPY	ETF	208.23	208.23	207.4	207.645	14161655.0
2015-08-07 11:00:00	SPY	ETF	207.66	207.8	206.95	207.27	16270653.0
2015-08-07 12:00:00	SPY	ETF	207.28	207.45	206.98	207.19	7632021.0
2015-08-07 13:00:00	SPY	ETF	207.185	207.345	206.87	207.1675	9467301.0
2015-08-07 14:00:00	SPY	ETF	207.16	207.44	206.97	207.39	7706830.0
2015-08-07 15:00:00	SPY	ETF	207.39	207.94	207.1375	207.93	29659807.0
2015-08-07 16:00:00	SPY	ETF	207.92	208.05	207.65	207.97	11546313.0
2015-08-07 17:00:00	SPY	ETF	207.97	208.04	207.57	207.93	816198.0
2015-08-07 18:00:00	SPY	ETF	207.93	207.94	207.91	207.92	18273.0
2015-08-07 19:00:00	SPY	ETF	207.91	207.95	207.9	207.92	16492.0
2015-08-07 06:00:00	QQQ	ETF	110.31	110.34	110.31	110.34	10000.0
2015-08-07 07:00:00	QQQ	ETF	110.32	110.35	110.25	110.26	97950.0
2015-08-07 08:00:00	QQQ	ETF	110.27	110.51	109.93	110.51	223351.0
2015-08-07 09:00:00	QQQ	ETF	110.47	110.57	109.845	110.48	4753486.0
2015-08-07 10:00:00	QQQ	ETF	110.49	110.49	109.77	109.94	3573244.0
2015-08-07 11:00:00	QQQ	ETF	109.94	110.029	109.4	109.69	3404542.0
2015-08-07 12:00:00	QQQ	ETF	109.699	109.89	109.585	109.64	2140939.0
2015-08-07 13:00:00	QQQ	ETF	109.64	109.74	109.42	109.56	1810063.0
2015-08-07 14:00:00	QQQ	ETF	109.56	109.88	109.48	109.87	1450274.0
2015-08-07 15:00:00	QQQ	ETF	109.87	110.35	109.79	110.3	5386944.0
2015-08-07 16:00:00	QQQ	ETF	110.3	110.38	109.6627	110.24	1149052.0
2015-08-07 17:00:00	QQQ	ETF	110.25	110.31	110.21	110.21	253829.0
2015-08-07 18:00:00	QQQ	ETF	110.21	110.21	110.14	110.14	6804.0
2015-08-07 19:00:00	QQQ	ETF	110.2	110.2	110.2	110.2	892.0
2015-08-07 07:00:00	IWM	ETF	120.54	120.54	120.21	120.25	36039.0
2015-08-07 08:00:00	IWM	ETF	120.25	122.0	119.99	120.59	493558.0
2015-08-07 09:00:00	IWM	ETF	120.56	120.56	119.72	120.34	4003575.0
2015-08-07 10:00:00	IWM	ETF	120.34	120.35	119.57	120.05	5223404.0
2015-08-07 11:00:00	IWM	ETF	120.06	120.145	119.4	119.62	3943273.0
2015-08-07 12:00:00	IWM	ETF	119.63	119.74	119.4	119.52	2627919.0
2015-08-07 13:00:00	IWM	ETF	119.51	119.68	119.22	119.4	2866602.0
2015-08-07 14:00:00	IWM	ETF	119.4	119.68	119.07	119.61	4273130.0
2015-08-07 15:00:00	IWM	ETF	119.6	119.91	119.425	119.91	8275593.0
2015-08-07 16:00:00	IWM	ETF	119.9	119.97	119.67	119.73	1192294.0
2015-08-07 17:00:00	IWM	ETF	119.72	119.98	119.7	119.733	203523.0
2015-08-07 18:00:00	IWM	ETF	119.73	119.73	119.73	119.73	200.0
2015-08-07 19:00:00	IWM	ETF	119.88	119.88	119.877	119.877	600.0
2015-08-07 08:00:00	DIA	ETF	174.1	174.2	173.7	174.2	26306.0
2015-08-07 09:00:00	DIA	ETF	174.38	174.38	173.58	173.98	807106.0
2015-08-07 10:00:00	DIA	ETF	173.97	173.97	173.22	173.39	1092626.0
2015-08-07 11:00:00	DIA	ETF	173.41	173.51	172.89	173.13	826024.0
2015-08-07 12:00:00	DIA	ETF	173.13	173.27	172.84	172.95	559117.0
2015-08-07 13:00:00	DIA	ETF	172.95	173.34	172.8	173.2299	703359.0
2015-08-07 14:00:00	DIA	ETF	173.21	173.4551	173.06	173.38	386900.0

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

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