PREVIEW / etf_1hour / 2017-05-09

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-05-09.parquet
  size:    278 KB
  rows:    9,013

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-05-09 04:00:00	SPY	ETF	239.7	239.7	239.7	239.7	290.0
2017-05-09 05:00:00	SPY	ETF	239.75	239.84	239.74	239.84	8200.0
2017-05-09 06:00:00	SPY	ETF	239.84	239.93	239.71	239.93	39900.0
2017-05-09 07:00:00	SPY	ETF	239.88	239.96	239.84	239.92	48443.0
2017-05-09 08:00:00	SPY	ETF	239.89	240.08	239.87	239.96	184790.0
2017-05-09 09:00:00	SPY	ETF	239.94	240.06	239.8	239.99	4862860.0
2017-05-09 10:00:00	SPY	ETF	239.99	240.19	239.89	239.94	7659773.0
2017-05-09 11:00:00	SPY	ETF	239.95	240.02	239.69	239.95	4416219.0
2017-05-09 12:00:00	SPY	ETF	239.95	239.995	239.61	239.65	5571328.0
2017-05-09 13:00:00	SPY	ETF	239.65	239.75	239.4	239.6862	4354697.0
2017-05-09 14:00:00	SPY	ETF	239.68	239.72	239.48	239.6	4815977.0
2017-05-09 15:00:00	SPY	ETF	239.61	239.74	239.04	239.46	14644842.0
2017-05-09 16:00:00	SPY	ETF	239.44	239.51	239.35	239.45	3842472.0
2017-05-09 17:00:00	SPY	ETF	239.45	239.47	239.39	239.4	198787.0
2017-05-09 18:00:00	SPY	ETF	239.38	239.51	239.14	239.15	145701.0
2017-05-09 19:00:00	SPY	ETF	239.16	239.16	239.0	239.01	56402.0
2017-05-09 04:00:00	QQQ	ETF	137.91	137.91	137.85	137.85	590.0
2017-05-09 05:00:00	QQQ	ETF	137.88	137.88	137.88	137.88	600.0
2017-05-09 06:00:00	QQQ	ETF	137.91	137.91	137.9	137.9	600.0
2017-05-09 07:00:00	QQQ	ETF	137.9	137.95	137.9	137.95	17185.0
2017-05-09 08:00:00	QQQ	ETF	137.95	138.05	137.95	138.0	79561.0
2017-05-09 09:00:00	QQQ	ETF	138.01	138.39	137.93	138.38	2974521.0
2017-05-09 10:00:00	QQQ	ETF	138.39	138.628	138.36	138.38	4385355.0
2017-05-09 11:00:00	QQQ	ETF	138.39	138.48	138.25	138.31	3170718.0
2017-05-09 12:00:00	QQQ	ETF	138.31	138.44	138.3	138.321	1682638.0
2017-05-09 13:00:00	QQQ	ETF	138.33	138.39	138.13	138.26	2520276.0
2017-05-09 14:00:00	QQQ	ETF	138.26	138.3	138.19	138.25	1279860.0
2017-05-09 15:00:00	QQQ	ETF	138.245	138.38	138.05	138.32	3136622.0
2017-05-09 16:00:00	QQQ	ETF	138.31	138.48	138.28	138.45	4146671.0
2017-05-09 17:00:00	QQQ	ETF	138.4	138.44	138.36	138.36	5190.0
2017-05-09 18:00:00	QQQ	ETF	138.36	138.4	138.26	138.26	11584.0
2017-05-09 19:00:00	QQQ	ETF	138.25	138.25	138.16	138.17	18652.0
2017-05-09 04:00:00	IWM	ETF	138.49	138.49	138.49	138.49	1000.0
2017-05-09 06:00:00	IWM	ETF	138.54	138.64	138.47	138.64	900.0
2017-05-09 07:00:00	IWM	ETF	138.57	138.64	138.57	138.63	10049.0
2017-05-09 08:00:00	IWM	ETF	138.63	138.75	138.46	138.47	47990.0
2017-05-09 09:00:00	IWM	ETF	138.48	138.83	138.42	138.689	1990096.0
2017-05-09 10:00:00	IWM	ETF	138.69	138.8	138.24	138.48	4160573.0
2017-05-09 11:00:00	IWM	ETF	138.48	138.67	137.95	138.67	2951892.0
2017-05-09 12:00:00	IWM	ETF	138.67	138.78	138.45	138.5	1270094.0
2017-05-09 13:00:00	IWM	ETF	138.5	138.66	138.3	138.54	1415998.0
2017-05-09 14:00:00	IWM	ETF	138.54	138.55	138.33	138.43	1417094.0
2017-05-09 15:00:00	IWM	ETF	138.44	138.54	137.78	138.36	5810417.0
2017-05-09 16:00:00	IWM	ETF	138.36	138.4916	138.17	138.17	1750861.0
2017-05-09 17:00:00	IWM	ETF	138.26	138.26	138.14	138.14	3924.0
2017-05-09 18:00:00	IWM	ETF	138.41	138.41	138.06	138.12	379818.0
2017-05-09 19:00:00	IWM	ETF	138.06	138.06	137.91	137.92	6755.0
2017-05-09 08:00:00	DIA	ETF	210.2	210.29	210.2	210.23	800.0
2017-05-09 09:00:00	DIA	ETF	210.15	210.24	209.99	210.14	173012.0
2017-05-09 10:00:00	DIA	ETF	210.14	210.32	209.9859	210.09	341738.0

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

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