PREVIEW / etf_1hour / 2017-02-01

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-02-01.parquet
  size:    279 KB
  rows:    8,982

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
2017-02-01 04:00:00	SPY	ETF	227.9	228.08	227.9	228.08	5518.0
2017-02-01 05:00:00	SPY	ETF	228.06	228.15	228.0	228.06	16864.0
2017-02-01 06:00:00	SPY	ETF	228.02	228.08	227.94	227.96	20088.0
2017-02-01 07:00:00	SPY	ETF	228.02	228.11	227.99	228.1	129683.0
2017-02-01 08:00:00	SPY	ETF	228.09	228.28	227.53	228.15	537608.0
2017-02-01 09:00:00	SPY	ETF	228.18	228.59	228.1	228.19	7369360.0
2017-02-01 10:00:00	SPY	ETF	228.23	228.35	227.15	227.25	11738517.0
2017-02-01 11:00:00	SPY	ETF	227.26	227.53	226.94	227.2	9360310.0
2017-02-01 12:00:00	SPY	ETF	227.21	227.5	227.125	227.3999	4307993.0
2017-02-01 13:00:00	SPY	ETF	227.396	227.59	227.1	227.26	5356679.0
2017-02-01 14:00:00	SPY	ETF	227.25	227.9	227.02	227.36	15596703.0
2017-02-01 15:00:00	SPY	ETF	227.365	227.86	227.35	227.64	14577921.0
2017-02-01 16:00:00	SPY	ETF	227.64	227.75	227.55	227.6	8580678.0
2017-02-01 17:00:00	SPY	ETF	227.56	227.63	227.48	227.59	169039.0
2017-02-01 18:00:00	SPY	ETF	227.6	227.63	227.31	227.41	106331.0
2017-02-01 19:00:00	SPY	ETF	227.39	227.41	227.11	227.12	75010.0
2017-02-01 04:00:00	QQQ	ETF	125.14	125.15	125.14	125.15	1300.0
2017-02-01 05:00:00	QQQ	ETF	125.23	125.23	125.23	125.23	250.0
2017-02-01 06:00:00	QQQ	ETF	125.18	125.22	125.15	125.15	1768.0
2017-02-01 07:00:00	QQQ	ETF	125.23	125.31	125.21	125.3	18939.0
2017-02-01 08:00:00	QQQ	ETF	125.28	125.41	124.57	125.35	133776.0
2017-02-01 09:00:00	QQQ	ETF	125.35	125.68	125.33	125.38	3293337.0
2017-02-01 10:00:00	QQQ	ETF	125.39	125.5	124.91	124.95	2846754.0
2017-02-01 11:00:00	QQQ	ETF	124.9449	125.13	124.86	125.009	1744053.0
2017-02-01 12:00:00	QQQ	ETF	125.01	125.29	125.01	125.22	1779109.0
2017-02-01 13:00:00	QQQ	ETF	125.23	125.335	125.05	125.11	1695632.0
2017-02-01 14:00:00	QQQ	ETF	125.11	125.54	125.05	125.37	2889624.0
2017-02-01 15:00:00	QQQ	ETF	125.36	125.61	125.36	125.43	3951617.0
2017-02-01 16:00:00	QQQ	ETF	125.44	125.58	125.41	125.5	1323114.0
2017-02-01 17:00:00	QQQ	ETF	125.5	125.5	124.85	125.46	25936.0
2017-02-01 18:00:00	QQQ	ETF	125.45	125.45	125.25	125.29	33363.0
2017-02-01 19:00:00	QQQ	ETF	125.31	125.31	125.08	125.08	17718.0
2017-02-01 04:00:00	IWM	ETF	135.65	135.68	135.63	135.68	6600.0
2017-02-01 05:00:00	IWM	ETF	135.68	135.79	135.66	135.66	2820.0
2017-02-01 06:00:00	IWM	ETF	135.65	135.66	135.62	135.66	3228.0
2017-02-01 07:00:00	IWM	ETF	135.76	135.8	135.71	135.78	28473.0
2017-02-01 08:00:00	IWM	ETF	135.79	136.2	135.23	136.03	108729.0
2017-02-01 09:00:00	IWM	ETF	136.02	136.87	136.02	136.2583	4571047.0
2017-02-01 10:00:00	IWM	ETF	136.28	136.52	135.34	135.45	4950999.0
2017-02-01 11:00:00	IWM	ETF	135.44	135.76	134.965	135.2164	2936850.0
2017-02-01 12:00:00	IWM	ETF	135.22	135.325	134.7	135.1	2124979.0
2017-02-01 13:00:00	IWM	ETF	135.105	135.31	134.97	135.06	1775684.0
2017-02-01 14:00:00	IWM	ETF	135.01	135.53	134.76	134.99	3818142.0
2017-02-01 15:00:00	IWM	ETF	134.9901	135.37	134.8183	135.23	4089560.0
2017-02-01 16:00:00	IWM	ETF	135.23	135.37	135.1	135.19	792754.0
2017-02-01 17:00:00	IWM	ETF	135.17	135.17	135.06	135.07	4698.0
2017-02-01 18:00:00	IWM	ETF	135.08	135.15	135.07	135.07	900.0
2017-02-01 19:00:00	IWM	ETF	135.07	135.07	134.78	134.86	22940.0
2017-02-01 04:00:00	DIA	ETF	198.65	198.65	198.65	198.65	200.0
2017-02-01 05:00:00	DIA	ETF	198.69	198.69	198.69	198.69	172.0

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

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