PREVIEW / etf_1hour / 2017-01-06

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-01-06.parquet
  size:    273 KB
  rows:    8,779

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-01-06 04:00:00	SPY	ETF	226.35	226.35	226.27	226.27	5827.0
2017-01-06 05:00:00	SPY	ETF	226.3	226.43	226.3	226.4	14631.0
2017-01-06 06:00:00	SPY	ETF	226.4	226.43	226.38	226.43	2003.0
2017-01-06 07:00:00	SPY	ETF	226.43	226.48	226.23	226.28	114013.0
2017-01-06 08:00:00	SPY	ETF	226.33	226.72	226.23	226.7	825916.0
2017-01-06 09:00:00	SPY	ETF	226.71	226.72	225.9	226.42	6020294.0
2017-01-06 10:00:00	SPY	ETF	226.413	226.725	226.17	226.59	7618341.0
2017-01-06 11:00:00	SPY	ETF	226.58	227.43	226.53	227.2962	8420353.0
2017-01-06 12:00:00	SPY	ETF	227.3	227.74	227.19	227.635	7804189.0
2017-01-06 13:00:00	SPY	ETF	227.64	227.68	227.37	227.52	5806004.0
2017-01-06 14:00:00	SPY	ETF	227.52	227.75	227.38	227.41	10013027.0
2017-01-06 15:00:00	SPY	ETF	227.41	227.58	227.17	227.24	16094541.0
2017-01-06 16:00:00	SPY	ETF	227.23	227.59	227.13	227.15	7167756.0
2017-01-06 17:00:00	SPY	ETF	227.14	227.19	227.11	227.12	67782.0
2017-01-06 18:00:00	SPY	ETF	227.11	227.11	226.8	226.83	107323.0
2017-01-06 19:00:00	SPY	ETF	226.83	226.9	226.7	226.79	81538.0
2017-01-06 04:00:00	QQQ	ETF	120.86	120.86	120.86	120.86	999.0
2017-01-06 05:00:00	QQQ	ETF	120.88	120.88	120.88	120.88	600.0
2017-01-06 06:00:00	QQQ	ETF	120.9	120.92	120.9	120.92	500.0
2017-01-06 07:00:00	QQQ	ETF	120.98	120.99	120.88	120.88	14138.0
2017-01-06 08:00:00	QQQ	ETF	120.9	121.1	120.87	121.06	167823.0
2017-01-06 09:00:00	QQQ	ETF	121.01	121.3	120.685	121.28	2308857.0
2017-01-06 10:00:00	QQQ	ETF	121.28	121.58	121.115	121.49	2921556.0
2017-01-06 11:00:00	QQQ	ETF	121.49	121.89	121.45	121.861	3426221.0
2017-01-06 12:00:00	QQQ	ETF	121.85	122.16	121.82	122.12	2219765.0
2017-01-06 13:00:00	QQQ	ETF	122.115	122.16	121.94	122.075	1487007.0
2017-01-06 14:00:00	QQQ	ETF	122.08	122.25	122.03	122.05	1666385.0
2017-01-06 15:00:00	QQQ	ETF	122.06	122.12	121.88	121.91	3187116.0
2017-01-06 16:00:00	QQQ	ETF	121.915	122.1	121.87	121.95	1937734.0
2017-01-06 17:00:00	QQQ	ETF	121.93	121.95	121.93	121.93	14878.0
2017-01-06 18:00:00	QQQ	ETF	121.93	121.93	121.83	121.85	9533.0
2017-01-06 19:00:00	QQQ	ETF	121.84	121.84	121.77	121.77	11863.0
2017-01-06 07:00:00	IWM	ETF	136.11	136.11	135.98	135.98	2026.0
2017-01-06 08:00:00	IWM	ETF	135.96	136.65	135.95	136.61	157476.0
2017-01-06 09:00:00	IWM	ETF	136.6	136.71	135.77	136.3059	2511712.0
2017-01-06 10:00:00	IWM	ETF	136.29	136.41	135.68	136.05	2698710.0
2017-01-06 11:00:00	IWM	ETF	136.03	136.59	135.79	136.56	3050892.0
2017-01-06 12:00:00	IWM	ETF	136.56	136.61	136.2943	136.44	1749056.0
2017-01-06 13:00:00	IWM	ETF	136.44	136.64	136.21	136.21	1625578.0
2017-01-06 14:00:00	IWM	ETF	136.21	136.39	135.855	135.97	2027475.0
2017-01-06 15:00:00	IWM	ETF	135.97	136.13	135.68	135.68	4797885.0
2017-01-06 16:00:00	IWM	ETF	135.69	135.7835	135.58	135.58	1172949.0
2017-01-06 17:00:00	IWM	ETF	135.56	135.69	135.51	135.68	19913.0
2017-01-06 18:00:00	IWM	ETF	135.6	135.62	135.59	135.6	1732.0
2017-01-06 19:00:00	IWM	ETF	135.56	135.56	135.43	135.43	6125.0
2017-01-06 07:00:00	DIA	ETF	198.75	198.75	198.55	198.56	3225.0
2017-01-06 08:00:00	DIA	ETF	198.68	198.94	198.51	198.93	11752.0
2017-01-06 09:00:00	DIA	ETF	198.85	198.93	198.17	198.62	446529.0
2017-01-06 10:00:00	DIA	ETF	198.6199	199.01	198.55	198.91	464342.0
2017-01-06 11:00:00	DIA	ETF	198.92	199.61	198.88	199.45	501455.0

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

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