PREVIEW / etf_1hour / 2016-05-25

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-05-25.parquet
  size:    249 KB
  rows:    8,093

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
2016-05-25 04:00:00	SPY	ETF	208.5	208.91	208.5	208.9	24019.0
2016-05-25 05:00:00	SPY	ETF	208.87	209.04	208.86	208.99	48907.0
2016-05-25 06:00:00	SPY	ETF	208.97	208.97	208.76	208.79	16813.0
2016-05-25 07:00:00	SPY	ETF	208.81	208.93	208.67	208.82	297760.0
2016-05-25 08:00:00	SPY	ETF	208.82	210.2346	208.12	208.83	753698.0
2016-05-25 09:00:00	SPY	ETF	208.83	209.28	208.55	209.21	13266547.0
2016-05-25 10:00:00	SPY	ETF	209.21	209.71	209.2	209.405	12962646.0
2016-05-25 11:00:00	SPY	ETF	209.41	209.59	209.14	209.3	8297950.0
2016-05-25 12:00:00	SPY	ETF	209.31	209.36	209.13	209.32	5895469.0
2016-05-25 13:00:00	SPY	ETF	209.32	209.66	209.32	209.615	5914371.0
2016-05-25 14:00:00	SPY	ETF	209.62	209.71	209.19	209.22	8260638.0
2016-05-25 15:00:00	SPY	ETF	209.211	209.77	209.16	209.22	16795566.0
2016-05-25 16:00:00	SPY	ETF	209.22	209.38	209.19	209.38	4632641.0
2016-05-25 17:00:00	SPY	ETF	209.37	209.41	209.35	209.38	169077.0
2016-05-25 18:00:00	SPY	ETF	209.38	209.39	209.21	209.29	175756.0
2016-05-25 19:00:00	SPY	ETF	209.28	209.28	209.13	209.17	137084.0
2016-05-25 04:00:00	QQQ	ETF	108.93	109.02	108.93	108.97	1623.0
2016-05-25 05:00:00	QQQ	ETF	109.06	109.14	109.06	109.14	1199.0
2016-05-25 06:00:00	QQQ	ETF	109.12	109.12	108.98	108.98	3300.0
2016-05-25 07:00:00	QQQ	ETF	109.0	109.06	108.93	109.02	43923.0
2016-05-25 08:00:00	QQQ	ETF	108.96	109.08	108.92	108.99	93258.0
2016-05-25 09:00:00	QQQ	ETF	108.98	109.19	108.684	109.13	2747759.0
2016-05-25 10:00:00	QQQ	ETF	109.13	109.34	109.08	109.22	4641217.0
2016-05-25 11:00:00	QQQ	ETF	109.22	109.33	109.02	109.19	2833109.0
2016-05-25 12:00:00	QQQ	ETF	109.19	109.27	109.13	109.26	1900468.0
2016-05-25 13:00:00	QQQ	ETF	109.27	109.57	109.26	109.49	2746974.0
2016-05-25 14:00:00	QQQ	ETF	109.49	109.5	109.1234	109.1234	2076859.0
2016-05-25 15:00:00	QQQ	ETF	109.13	109.4499	109.09	109.25	4600968.0
2016-05-25 16:00:00	QQQ	ETF	109.22	109.29	109.18	109.29	961384.0
2016-05-25 17:00:00	QQQ	ETF	108.4724	109.34	108.4724	109.25	501039.0
2016-05-25 18:00:00	QQQ	ETF	109.25	109.25	109.18	109.22	3147.0
2016-05-25 19:00:00	QQQ	ETF	109.24	109.24	109.17	109.19	2699.0
2016-05-25 04:00:00	IWM	ETF	113.49	113.49	113.49	113.49	100.0
2016-05-25 05:00:00	IWM	ETF	113.5	113.6	113.5	113.6	200.0
2016-05-25 06:00:00	IWM	ETF	113.52	113.52	113.45	113.45	2000.0
2016-05-25 07:00:00	IWM	ETF	113.47	113.55	113.4	113.49	18059.0
2016-05-25 08:00:00	IWM	ETF	113.48	113.55	113.45	113.48	17603.0
2016-05-25 09:00:00	IWM	ETF	113.47	113.48	113.08	113.43	3435704.0
2016-05-25 10:00:00	IWM	ETF	113.43	113.9	113.39	113.7375	5149102.0
2016-05-25 11:00:00	IWM	ETF	113.74	113.84	113.33	113.518	2673764.0
2016-05-25 12:00:00	IWM	ETF	113.52	113.61	113.26	113.455	1662793.0
2016-05-25 13:00:00	IWM	ETF	113.46	113.77	113.46	113.68	1563272.0
2016-05-25 14:00:00	IWM	ETF	113.675	113.735	113.47	113.47	1792822.0
2016-05-25 15:00:00	IWM	ETF	113.47	113.77	113.385	113.55	4769539.0
2016-05-25 16:00:00	IWM	ETF	113.55	113.72	113.55	113.63	1085573.0
2016-05-25 17:00:00	IWM	ETF	113.62	113.63	113.62	113.62	13719.0
2016-05-25 19:00:00	IWM	ETF	113.59	113.59	113.55	113.55	400.0
2016-05-25 04:00:00	DIA	ETF	177.3	177.5	177.3	177.5	703.0
2016-05-25 05:00:00	DIA	ETF	177.71	177.71	177.71	177.71	1500.0
2016-05-25 06:00:00	DIA	ETF	177.65	177.65	177.55	177.55	1800.0

> showing 50 of 8,093 rows — these rows as CSV

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