PREVIEW / etf_1hour / 2015-11-23

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-11-23.parquet
  size:    244 KB
  rows:    7,764

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-11-23 04:00:00	SPY	ETF	209.4	209.45	209.06	209.09	10692.0
2015-11-23 05:00:00	SPY	ETF	209.07	209.26	209.07	209.11	17848.0
2015-11-23 06:00:00	SPY	ETF	209.08	209.51	208.91	209.41	44543.0
2015-11-23 07:00:00	SPY	ETF	209.33	209.76	209.26	209.46	277405.0
2015-11-23 08:00:00	SPY	ETF	209.34	209.54	209.21	209.21	449394.0
2015-11-23 09:00:00	SPY	ETF	209.21	209.68	209.15	209.295	7730887.0
2015-11-23 10:00:00	SPY	ETF	209.29	209.98	209.14	209.95	10722955.0
2015-11-23 11:00:00	SPY	ETF	209.945	209.945	209.64	209.84	7073270.0
2015-11-23 12:00:00	SPY	ETF	209.83	209.86	209.51	209.6531	4807716.0
2015-11-23 13:00:00	SPY	ETF	209.655	209.76	209.24	209.25	4509191.0
2015-11-23 14:00:00	SPY	ETF	209.245	209.31	208.52	208.86	12530149.0
2015-11-23 15:00:00	SPY	ETF	208.86	209.22	208.83	209.06	13210429.0
2015-11-23 16:00:00	SPY	ETF	209.05	209.32	209.01	209.04	2908453.0
2015-11-23 17:00:00	SPY	ETF	209.06	209.08	209.0	209.0	75039.0
2015-11-23 18:00:00	SPY	ETF	209.01	209.17	208.91	209.17	94109.0
2015-11-23 19:00:00	SPY	ETF	209.19	209.22	209.07	209.15	42114.0
2015-11-23 04:00:00	QQQ	ETF	114.51	114.51	114.37	114.37	10800.0
2015-11-23 06:00:00	QQQ	ETF	114.21	114.47	114.21	114.47	500.0
2015-11-23 07:00:00	QQQ	ETF	114.47	114.66	114.46	114.49	22250.0
2015-11-23 08:00:00	QQQ	ETF	114.5	114.6	114.43	114.43	45355.0
2015-11-23 09:00:00	QQQ	ETF	114.43	114.74	114.35	114.62	2623217.0
2015-11-23 10:00:00	QQQ	ETF	114.63	114.94	114.5	114.81	3370532.0
2015-11-23 11:00:00	QQQ	ETF	114.815	114.815	114.48	114.6	2395121.0
2015-11-23 12:00:00	QQQ	ETF	114.6	114.6068	114.39	114.5	1791539.0
2015-11-23 13:00:00	QQQ	ETF	114.51	114.57	114.19	114.2	1326002.0
2015-11-23 14:00:00	QQQ	ETF	114.19	114.4305	113.66	113.95	3840224.0
2015-11-23 15:00:00	QQQ	ETF	113.96	114.25	113.94	114.14	3599973.0
2015-11-23 16:00:00	QQQ	ETF	114.15	114.22	114.13	114.16	502768.0
2015-11-23 17:00:00	QQQ	ETF	114.15	114.19	114.14	114.17	3684.0
2015-11-23 18:00:00	QQQ	ETF	114.12	114.24	114.09	114.24	9860.0
2015-11-23 19:00:00	QQQ	ETF	114.2	114.26	114.19	114.19	5200.0
2015-11-23 07:00:00	IWM	ETF	116.72	116.73	116.72	116.73	3000.0
2015-11-23 08:00:00	IWM	ETF	116.75	116.78	116.61	116.61	9076.0
2015-11-23 09:00:00	IWM	ETF	116.6	117.19	116.6	116.9546	1883412.0
2015-11-23 10:00:00	IWM	ETF	116.96	117.77	116.81	117.76	3166456.0
2015-11-23 11:00:00	IWM	ETF	117.76	117.85	117.56	117.725	2479380.0
2015-11-23 12:00:00	IWM	ETF	117.72	117.89	117.52	117.79	1517927.0
2015-11-23 13:00:00	IWM	ETF	117.79	117.89	117.54	117.54	1577695.0
2015-11-23 14:00:00	IWM	ETF	117.53	117.625	117.06	117.31	3020659.0
2015-11-23 15:00:00	IWM	ETF	117.31	117.59	117.27	117.34	3309047.0
2015-11-23 16:00:00	IWM	ETF	117.34	117.53	117.34	117.5	1297577.0
2015-11-23 17:00:00	IWM	ETF	117.49	117.49	117.4	117.49	25300.0
2015-11-23 19:00:00	IWM	ETF	117.34	117.42	117.3	117.42	3044.0
2015-11-23 08:00:00	DIA	ETF	178.07	178.07	177.97	177.99	1055.0
2015-11-23 09:00:00	DIA	ETF	177.9	178.22	177.71	177.81	260502.0
2015-11-23 10:00:00	DIA	ETF	177.82	178.48	177.7	178.33	440731.0
2015-11-23 11:00:00	DIA	ETF	178.34	178.34	177.96	178.16	273287.0
2015-11-23 12:00:00	DIA	ETF	178.15	178.15	177.86	178.0139	239589.0
2015-11-23 13:00:00	DIA	ETF	178.02	178.1	177.75	177.75	176539.0
2015-11-23 14:00:00	DIA	ETF	177.74	177.79	177.3	177.5899	460026.0

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

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