PREVIEW / etf_1hour / 2017-10-25

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-10-25.parquet
  size:    290 KB
  rows:    9,462

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-10-25 04:00:00	SPY	ETF	256.25	256.25	256.13	256.17	1200.0
2017-10-25 05:00:00	SPY	ETF	256.2	256.2	256.05	256.18	626.0
2017-10-25 06:00:00	SPY	ETF	256.19	256.35	256.19	256.29	5011.0
2017-10-25 07:00:00	SPY	ETF	256.34	256.44	256.08	256.15	55095.0
2017-10-25 08:00:00	SPY	ETF	256.12	256.32	256.1	256.23	247258.0
2017-10-25 09:00:00	SPY	ETF	256.2	256.31	255.75	255.805	5228122.0
2017-10-25 10:00:00	SPY	ETF	255.8	256.02	255.06	255.26	8659977.0
2017-10-25 11:00:00	SPY	ETF	255.25	255.26	254.46	254.725	19023034.0
2017-10-25 12:00:00	SPY	ETF	254.72	254.73	254.0	254.645	13896269.0
2017-10-25 13:00:00	SPY	ETF	254.645	255.14	254.45	255.09	8214685.0
2017-10-25 14:00:00	SPY	ETF	255.08	255.44	254.95	255.15	9988483.0
2017-10-25 15:00:00	SPY	ETF	255.15	255.57	254.9	255.3	18017786.0
2017-10-25 16:00:00	SPY	ETF	255.3	255.74	255.29	255.71	18156410.0
2017-10-25 17:00:00	SPY	ETF	255.68	255.72	255.66	255.72	121031.0
2017-10-25 18:00:00	SPY	ETF	255.71	255.71	255.63	255.63	91262.0
2017-10-25 19:00:00	SPY	ETF	255.63	255.63	255.56	255.6	78366.0
2017-10-25 04:00:00	QQQ	ETF	147.81	147.81	147.68	147.68	11000.0
2017-10-25 05:00:00	QQQ	ETF	147.61	147.78	147.58	147.78	18497.0
2017-10-25 06:00:00	QQQ	ETF	147.75	147.8	147.75	147.79	30099.0
2017-10-25 07:00:00	QQQ	ETF	147.88	147.88	147.68	147.72	31604.0
2017-10-25 08:00:00	QQQ	ETF	147.71	147.8	147.62	147.72	135142.0
2017-10-25 09:00:00	QQQ	ETF	147.7	148.18	147.5847	147.68	2996907.0
2017-10-25 10:00:00	QQQ	ETF	147.68	147.93	147.41	147.57	3318421.0
2017-10-25 11:00:00	QQQ	ETF	147.58	147.58	146.45	146.78	6550258.0
2017-10-25 12:00:00	QQQ	ETF	146.78	147.04	146.33	146.99	4708751.0
2017-10-25 13:00:00	QQQ	ETF	146.995	147.27	146.88	147.2	3727555.0
2017-10-25 14:00:00	QQQ	ETF	147.195	147.43	147.1	147.225	2113117.0
2017-10-25 15:00:00	QQQ	ETF	147.225	147.51	147.12	147.41	4985859.0
2017-10-25 16:00:00	QQQ	ETF	147.41	147.69	147.3974	147.67	2043999.0
2017-10-25 17:00:00	QQQ	ETF	147.61	147.7	147.61	147.7	7153.0
2017-10-25 18:00:00	QQQ	ETF	147.68	147.68	147.56	147.56	29162.0
2017-10-25 19:00:00	QQQ	ETF	147.57	147.57	147.5	147.55	30602.0
2017-10-25 04:00:00	IWM	ETF	148.95	148.95	148.79	148.83	3112.0
2017-10-25 05:00:00	IWM	ETF	148.7	148.71	148.7	148.7	2234.0
2017-10-25 06:00:00	IWM	ETF	148.91	148.93	148.91	148.93	1181.0
2017-10-25 07:00:00	IWM	ETF	149.0	149.0	148.7	148.73	34678.0
2017-10-25 08:00:00	IWM	ETF	148.7	148.91	148.68	148.82	48013.0
2017-10-25 09:00:00	IWM	ETF	148.81	149.0	148.57	148.72	1693768.0
2017-10-25 10:00:00	IWM	ETF	148.72	148.93	147.98	148.12	3616942.0
2017-10-25 11:00:00	IWM	ETF	148.11	148.22	147.22	147.6199	5198087.0
2017-10-25 12:00:00	IWM	ETF	147.6	148.005	147.35	147.99	2249834.0
2017-10-25 13:00:00	IWM	ETF	148.0	148.68	147.82	148.63	3362799.0
2017-10-25 14:00:00	IWM	ETF	148.63	148.67	148.155	148.31	1753393.0
2017-10-25 15:00:00	IWM	ETF	148.32	148.64	148.27	148.43	2567217.0
2017-10-25 16:00:00	IWM	ETF	148.44	148.85	148.3949	148.84	2857570.0
2017-10-25 17:00:00	IWM	ETF	148.84	148.84	148.79	148.79	4806.0
2017-10-25 18:00:00	IWM	ETF	148.74	148.74	148.72	148.72	1300.0
2017-10-25 19:00:00	IWM	ETF	148.72	148.72	148.66	148.69	13633.0
2017-10-25 06:00:00	DIA	ETF	234.48	234.54	234.4	234.4	3600.0
2017-10-25 07:00:00	DIA	ETF	234.54	234.54	234.05	234.2	2100.0

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

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