PREVIEW / etf_1hour / 2016-06-20

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-06-20.parquet
  size:    251 KB
  rows:    8,167

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-06-20 04:00:00	SPY	ETF	208.4	209.0	208.4	209.0	36606.0
2016-06-20 05:00:00	SPY	ETF	208.96	209.07	208.74	208.91	31219.0
2016-06-20 06:00:00	SPY	ETF	208.89	209.08	208.86	209.02	84398.0
2016-06-20 07:00:00	SPY	ETF	209.02	209.13	208.93	209.03	475950.0
2016-06-20 08:00:00	SPY	ETF	208.86	209.05	208.66	208.87	941691.0
2016-06-20 09:00:00	SPY	ETF	208.87	209.36	208.66	209.12	13853190.0
2016-06-20 10:00:00	SPY	ETF	209.12	209.61	209.05	209.18	10265002.0
2016-06-20 11:00:00	SPY	ETF	209.18	209.33	208.73	208.95	9794525.0
2016-06-20 12:00:00	SPY	ETF	208.945	209.06	208.75	208.9501	5817995.0
2016-06-20 13:00:00	SPY	ETF	208.95	209.02	208.55	208.84	7567976.0
2016-06-20 14:00:00	SPY	ETF	208.835	208.86	208.44	208.795	7486355.0
2016-06-20 15:00:00	SPY	ETF	208.79	208.83	207.75	207.86	17953108.0
2016-06-20 16:00:00	SPY	ETF	207.86	208.68	207.5	208.63	4352795.0
2016-06-20 17:00:00	SPY	ETF	208.62	208.62	208.06	208.2	653045.0
2016-06-20 18:00:00	SPY	ETF	208.19	208.3	208.07	208.26	1124581.0
2016-06-20 19:00:00	SPY	ETF	208.28	208.3	208.09	208.15	58215.0
2016-06-20 04:00:00	QQQ	ETF	107.42	107.75	107.42	107.75	1582.0
2016-06-20 05:00:00	QQQ	ETF	107.79	107.79	107.65	107.65	1059.0
2016-06-20 06:00:00	QQQ	ETF	107.72	107.79	107.72	107.77	3501.0
2016-06-20 07:00:00	QQQ	ETF	107.77	107.87	107.75	107.81	48404.0
2016-06-20 08:00:00	QQQ	ETF	107.8	107.81	107.73	107.76	144098.0
2016-06-20 09:00:00	QQQ	ETF	107.76	107.98	107.69	107.925	5171247.0
2016-06-20 10:00:00	QQQ	ETF	107.93	108.22	107.925	108.17	2882168.0
2016-06-20 11:00:00	QQQ	ETF	108.17	108.24	107.86	107.97	1846156.0
2016-06-20 12:00:00	QQQ	ETF	107.97	108.06	107.85	107.9901	1014544.0
2016-06-20 13:00:00	QQQ	ETF	108.0	108.02	107.75	107.87	1157015.0
2016-06-20 14:00:00	QQQ	ETF	107.865	107.88	107.65	107.82	1284792.0
2016-06-20 15:00:00	QQQ	ETF	107.8101	107.83	107.08	107.16	4600896.0
2016-06-20 16:00:00	QQQ	ETF	107.18	107.54	106.99	107.51	608062.0
2016-06-20 17:00:00	QQQ	ETF	107.31	107.34	107.19	107.29	12500.0
2016-06-20 18:00:00	QQQ	ETF	107.28	107.34	107.22	107.31	17772.0
2016-06-20 19:00:00	QQQ	ETF	107.28	107.33	107.18	107.18	40470.0
2016-06-20 04:00:00	IWM	ETF	115.5	115.83	115.5	115.83	3229.0
2016-06-20 06:00:00	IWM	ETF	115.8	115.87	115.8	115.87	15860.0
2016-06-20 07:00:00	IWM	ETF	115.86	115.9	115.8	115.89	62548.0
2016-06-20 08:00:00	IWM	ETF	115.84	115.91	115.77	115.84	146099.0
2016-06-20 09:00:00	IWM	ETF	115.8	115.98	115.52	115.65	5006833.0
2016-06-20 10:00:00	IWM	ETF	115.66	116.3	115.61	116.21	3897641.0
2016-06-20 11:00:00	IWM	ETF	116.19	116.39	116.03	116.32	2215609.0
2016-06-20 12:00:00	IWM	ETF	116.315	116.45	116.15	116.19	1890893.0
2016-06-20 13:00:00	IWM	ETF	116.19	116.245	115.96	116.05	2136958.0
2016-06-20 14:00:00	IWM	ETF	116.05	116.05	115.69	115.98	2139050.0
2016-06-20 15:00:00	IWM	ETF	115.98	115.99	115.33	115.33	5216914.0
2016-06-20 16:00:00	IWM	ETF	115.33	115.74	114.99	115.73	1538751.0
2016-06-20 17:00:00	IWM	ETF	115.74	115.74	115.35	115.44	51372.0
2016-06-20 18:00:00	IWM	ETF	115.37	115.48	115.35	115.35	3300.0
2016-06-20 19:00:00	IWM	ETF	115.42	115.42	115.42	115.42	100.0
2016-06-20 04:00:00	DIA	ETF	178.0	178.0	178.0	178.0	100.0
2016-06-20 07:00:00	DIA	ETF	178.53	178.55	178.36	178.36	7543.0
2016-06-20 08:00:00	DIA	ETF	178.27	178.51	178.27	178.49	9162.0

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

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