PREVIEW / etf_1hour / 2015-10-27

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-10-27.parquet
  size:    242 KB
  rows:    7,708

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-10-27 04:00:00	SPY	ETF	206.71	206.71	206.38	206.53	51894.0
2015-10-27 05:00:00	SPY	ETF	206.65	206.78	206.61	206.77	6124.0
2015-10-27 06:00:00	SPY	ETF	206.74	206.77	206.66	206.73	2568.0
2015-10-27 07:00:00	SPY	ETF	206.72	206.73	206.58	206.66	36506.0
2015-10-27 08:00:00	SPY	ETF	206.61	206.73	206.27	206.4	574155.0
2015-10-27 09:00:00	SPY	ETF	206.4	206.72	206.09	206.6311	8716008.0
2015-10-27 10:00:00	SPY	ETF	206.63	206.69	206.03	206.58	13330370.0
2015-10-27 11:00:00	SPY	ETF	206.58	207.0	206.14	206.255	9230750.0
2015-10-27 12:00:00	SPY	ETF	206.2501	206.39	206.06	206.13	7958183.0
2015-10-27 13:00:00	SPY	ETF	206.135	206.15	205.79	205.985	8654359.0
2015-10-27 14:00:00	SPY	ETF	205.98	206.34	205.95	206.07	8039058.0
2015-10-27 15:00:00	SPY	ETF	206.07	206.59	206.04	206.58	13864014.0
2015-10-27 16:00:00	SPY	ETF	206.57	207.08	206.42	206.98	6523458.0
2015-10-27 17:00:00	SPY	ETF	206.98	207.0	206.73	206.85	256907.0
2015-10-27 18:00:00	SPY	ETF	206.87	206.89	206.69	206.7	90369.0
2015-10-27 19:00:00	SPY	ETF	206.73	206.75	206.6	206.73	35893.0
2015-10-27 04:00:00	QQQ	ETF	112.48	112.48	112.44	112.44	18750.0
2015-10-27 06:00:00	QQQ	ETF	112.59	112.65	112.51	112.64	12299.0
2015-10-27 07:00:00	QQQ	ETF	112.6	112.73	112.53	112.73	35816.0
2015-10-27 08:00:00	QQQ	ETF	112.74	112.75	112.57	112.63	57361.0
2015-10-27 09:00:00	QQQ	ETF	112.62	113.03	112.52	112.94	2944584.0
2015-10-27 10:00:00	QQQ	ETF	112.93	112.94	112.58	112.91	3139330.0
2015-10-27 11:00:00	QQQ	ETF	112.92	113.24	112.86	112.92	3996937.0
2015-10-27 12:00:00	QQQ	ETF	112.91	112.9799	112.72	112.82	2369316.0
2015-10-27 13:00:00	QQQ	ETF	112.81	112.9	112.64	112.8005	2244202.0
2015-10-27 14:00:00	QQQ	ETF	112.8	113.01	112.79	112.84	2318003.0
2015-10-27 15:00:00	QQQ	ETF	112.83	113.11	112.815	113.09	4215439.0
2015-10-27 16:00:00	QQQ	ETF	113.09	113.57	112.67	113.34	1527840.0
2015-10-27 17:00:00	QQQ	ETF	113.35	113.37	113.04	113.14	76703.0
2015-10-27 18:00:00	QQQ	ETF	113.11	113.13	112.98	113.07	73912.0
2015-10-27 19:00:00	QQQ	ETF	113.06	113.09	113.01	113.07	19785.0
2015-10-27 07:00:00	IWM	ETF	115.15	115.15	115.15	115.15	1000.0
2015-10-27 08:00:00	IWM	ETF	115.05	115.05	114.8	114.8	36041.0
2015-10-27 09:00:00	IWM	ETF	114.8	114.87	114.39	114.73	2570961.0
2015-10-27 10:00:00	IWM	ETF	114.7	114.8	113.8	114.28	4643437.0
2015-10-27 11:00:00	IWM	ETF	114.28	114.6599	113.89	113.99	4274472.0
2015-10-27 12:00:00	IWM	ETF	114.0	114.11	113.49	113.525	4671695.0
2015-10-27 13:00:00	IWM	ETF	113.525	113.525	113.1	113.31	5720934.0
2015-10-27 14:00:00	IWM	ETF	113.3	113.55	113.24	113.34	4450838.0
2015-10-27 15:00:00	IWM	ETF	113.34	113.91	113.3239	113.82	6603981.0
2015-10-27 16:00:00	IWM	ETF	113.82	114.0072	113.6	113.95	878538.0
2015-10-27 17:00:00	IWM	ETF	114.08	114.1	113.95	114.05	22945.0
2015-10-27 18:00:00	IWM	ETF	113.9	113.9	113.9	113.9	100.0
2015-10-27 19:00:00	IWM	ETF	113.84	113.86	113.84	113.86	4300.0
2015-10-27 07:00:00	DIA	ETF	175.75	175.75	175.75	175.75	1000.0
2015-10-27 08:00:00	DIA	ETF	175.76	175.76	175.55	175.55	3700.0
2015-10-27 09:00:00	DIA	ETF	175.52	175.92	175.24	175.89	722788.0
2015-10-27 10:00:00	DIA	ETF	175.85	175.93	175.45	175.84	622804.0
2015-10-27 11:00:00	DIA	ETF	175.84	176.19	175.5	175.58	517721.0
2015-10-27 12:00:00	DIA	ETF	175.58	175.83	175.48	175.65	228507.0

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

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