PREVIEW / etf_1hour / 2017-01-04

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-01-04.parquet
  size:    280 KB
  rows:    9,042

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-04 04:00:00	SPY	ETF	225.43	225.59	225.41	225.59	5758.0
2017-01-04 05:00:00	SPY	ETF	225.64	225.67	225.58	225.61	6340.0
2017-01-04 06:00:00	SPY	ETF	225.4	225.6	225.4	225.59	38365.0
2017-01-04 07:00:00	SPY	ETF	225.55	225.67	225.54	225.67	145894.0
2017-01-04 08:00:00	SPY	ETF	225.65	225.79	225.56	225.67	569732.0
2017-01-04 09:00:00	SPY	ETF	225.65	226.35	225.56	226.03	9174193.0
2017-01-04 10:00:00	SPY	ETF	226.04	226.24	225.76	226.09	8062175.0
2017-01-04 11:00:00	SPY	ETF	226.09	226.45	226.06	226.4	8950463.0
2017-01-04 12:00:00	SPY	ETF	226.39	226.5	226.3	226.37	6706802.0
2017-01-04 13:00:00	SPY	ETF	226.37	226.43	226.28	226.35	4208919.0
2017-01-04 14:00:00	SPY	ETF	226.355	226.695	226.29	226.49	9580487.0
2017-01-04 15:00:00	SPY	ETF	226.49	226.75	226.36	226.53	21300157.0
2017-01-04 16:00:00	SPY	ETF	226.53	226.6303	226.39	226.47	8060704.0
2017-01-04 17:00:00	SPY	ETF	226.48	226.52	226.47	226.51	150327.0
2017-01-04 18:00:00	SPY	ETF	226.5	226.6	226.5	226.52	131510.0
2017-01-04 19:00:00	SPY	ETF	226.51	226.52	226.28	226.33	131640.0
2017-01-04 04:00:00	QQQ	ETF	119.65	119.72	119.65	119.72	710.0
2017-01-04 05:00:00	QQQ	ETF	119.73	119.73	119.73	119.73	330.0
2017-01-04 06:00:00	QQQ	ETF	119.68	119.68	119.68	119.68	10700.0
2017-01-04 07:00:00	QQQ	ETF	119.66	119.69	119.66	119.69	2497.0
2017-01-04 08:00:00	QQQ	ETF	119.69	119.79	119.69	119.7	98924.0
2017-01-04 09:00:00	QQQ	ETF	119.69	120.18	119.64	119.94	2233513.0
2017-01-04 10:00:00	QQQ	ETF	119.95	120.11	119.79	120.02	1817220.0
2017-01-04 11:00:00	QQQ	ETF	120.02	120.23	119.9	120.185	1826258.0
2017-01-04 12:00:00	QQQ	ETF	120.19	120.25	120.09	120.145	1200321.0
2017-01-04 13:00:00	QQQ	ETF	120.14	120.22	120.075	120.16	1139613.0
2017-01-04 14:00:00	QQQ	ETF	120.165	120.41	120.09	120.2967	3089769.0
2017-01-04 15:00:00	QQQ	ETF	120.29	120.39	120.14	120.19	3679189.0
2017-01-04 16:00:00	QQQ	ETF	120.19	120.23	120.12	120.2	1077342.0
2017-01-04 17:00:00	QQQ	ETF	119.84	120.2	119.84	120.17	4084.0
2017-01-04 18:00:00	QQQ	ETF	120.2	120.27	120.19	120.27	19603.0
2017-01-04 19:00:00	QQQ	ETF	120.16	120.16	120.06	120.06	13017.0
2017-01-04 04:00:00	IWM	ETF	135.86	135.87	135.85	135.87	2000.0
2017-01-04 05:00:00	IWM	ETF	136.04	136.04	136.0	136.0	1600.0
2017-01-04 06:00:00	IWM	ETF	136.06	136.06	136.05	136.05	200.0
2017-01-04 07:00:00	IWM	ETF	136.1	136.24	136.1	136.24	11158.0
2017-01-04 08:00:00	IWM	ETF	136.21	136.35	136.2	136.26	75256.0
2017-01-04 09:00:00	IWM	ETF	136.25	136.78	136.01	136.51	3301012.0
2017-01-04 10:00:00	IWM	ETF	136.54	137.04	136.2958	136.97	4537961.0
2017-01-04 11:00:00	IWM	ETF	136.97	137.66	136.9659	137.55	5336085.0
2017-01-04 12:00:00	IWM	ETF	137.56	137.82	137.46	137.5	2733236.0
2017-01-04 13:00:00	IWM	ETF	137.51	137.66	137.31	137.4	1967033.0
2017-01-04 14:00:00	IWM	ETF	137.41	137.75	137.38	137.535	3170705.0
2017-01-04 15:00:00	IWM	ETF	137.53	137.96	137.53	137.84	6922772.0
2017-01-04 16:00:00	IWM	ETF	137.78	137.96	137.5508	137.82	2104848.0
2017-01-04 17:00:00	IWM	ETF	137.75	137.78	137.71	137.71	3595.0
2017-01-04 18:00:00	IWM	ETF	137.74	137.87	137.74	137.87	2060.0
2017-01-04 19:00:00	IWM	ETF	137.74	137.8285	137.69	137.74	1097810.0
2017-01-04 07:00:00	DIA	ETF	198.67	198.69	198.67	198.69	450.0
2017-01-04 08:00:00	DIA	ETF	198.79	198.84	198.75	198.8	2045.0

> showing 50 of 9,042 rows — these rows as CSV

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