PREVIEW / etf_1hour / 2017-04-21

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-04-21.parquet
  size:    268 KB
  rows:    8,748

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-04-21 04:00:00	SPY	ETF	235.45	235.54	235.36	235.45	1555.0
2017-04-21 05:00:00	SPY	ETF	235.35	235.47	235.32	235.46	1907.0
2017-04-21 06:00:00	SPY	ETF	235.46	235.47	235.31	235.44	6154.0
2017-04-21 07:00:00	SPY	ETF	235.48	235.61	235.48	235.49	30121.0
2017-04-21 08:00:00	SPY	ETF	235.55	235.6	235.41	235.44	244823.0
2017-04-21 09:00:00	SPY	ETF	235.44	235.44	234.91	235.0599	7256602.0
2017-04-21 10:00:00	SPY	ETF	235.06	235.22	234.73	234.8701	22317537.0
2017-04-21 11:00:00	SPY	ETF	234.88	235.12	234.5625	235.02	11042021.0
2017-04-21 12:00:00	SPY	ETF	235.02	235.02	234.63	234.71	6636043.0
2017-04-21 13:00:00	SPY	ETF	234.72	234.87	234.13	234.79	12215511.0
2017-04-21 14:00:00	SPY	ETF	234.79	235.0	234.66	234.815	7327972.0
2017-04-21 15:00:00	SPY	ETF	234.82	234.92	234.47	234.59	23182456.0
2017-04-21 16:00:00	SPY	ETF	234.58	235.2729	234.515	234.6	12303593.0
2017-04-21 17:00:00	SPY	ETF	234.6	234.74	234.0	234.27	6595719.0
2017-04-21 18:00:00	SPY	ETF	234.28	234.45	234.26	234.38	69300.0
2017-04-21 19:00:00	SPY	ETF	234.38	234.48	234.33	234.33	44353.0
2017-04-21 04:00:00	QQQ	ETF	132.77	132.77	132.77	132.77	5000.0
2017-04-21 05:00:00	QQQ	ETF	132.76	132.86	132.76	132.86	11598.0
2017-04-21 06:00:00	QQQ	ETF	132.86	132.87	132.76	132.81	15678.0
2017-04-21 07:00:00	QQQ	ETF	132.82	132.86	132.8	132.82	12299.0
2017-04-21 08:00:00	QQQ	ETF	132.8	132.8	132.73	132.73	54882.0
2017-04-21 09:00:00	QQQ	ETF	132.72	132.74	132.36	132.47	1869823.0
2017-04-21 10:00:00	QQQ	ETF	132.48	132.63	132.41	132.49	2015684.0
2017-04-21 11:00:00	QQQ	ETF	132.48	132.76	132.4	132.71	1213777.0
2017-04-21 12:00:00	QQQ	ETF	132.71	132.73	132.49	132.54	1533530.0
2017-04-21 13:00:00	QQQ	ETF	132.535	132.57	132.22	132.506	2197526.0
2017-04-21 14:00:00	QQQ	ETF	132.519	132.545	132.385	132.48	1434906.0
2017-04-21 15:00:00	QQQ	ETF	132.48	132.6	132.32	132.54	4136659.0
2017-04-21 16:00:00	QQQ	ETF	132.54	132.63	132.48	132.48	1096873.0
2017-04-21 17:00:00	QQQ	ETF	132.47	132.49	132.35	132.44	13938.0
2017-04-21 18:00:00	QQQ	ETF	132.45	132.45	132.39	132.39	1738.0
2017-04-21 19:00:00	QQQ	ETF	132.46	132.46	132.39	132.39	11000.0
2017-04-21 04:00:00	IWM	ETF	137.54	137.55	137.54	137.55	600.0
2017-04-21 05:00:00	IWM	ETF	137.47	137.51	137.43	137.51	650.0
2017-04-21 06:00:00	IWM	ETF	137.47	137.47	137.34	137.34	1676.0
2017-04-21 07:00:00	IWM	ETF	137.49	137.49	137.34	137.34	3563.0
2017-04-21 08:00:00	IWM	ETF	137.34	137.45	137.3	137.33	24569.0
2017-04-21 09:00:00	IWM	ETF	137.32	137.48	136.905	137.16	3469036.0
2017-04-21 10:00:00	IWM	ETF	137.16	137.41	136.81	137.0	3681664.0
2017-04-21 11:00:00	IWM	ETF	137.01	137.25	136.71	137.18	2510392.0
2017-04-21 12:00:00	IWM	ETF	137.18	137.2	136.81	137.14	1792237.0
2017-04-21 13:00:00	IWM	ETF	137.15	137.32	136.79	137.26	2550503.0
2017-04-21 14:00:00	IWM	ETF	137.26	137.5475	137.17	137.29	3320502.0
2017-04-21 15:00:00	IWM	ETF	137.29	137.45	137.1	137.18	5214103.0
2017-04-21 16:00:00	IWM	ETF	137.19	137.3	137.04	137.21	1967894.0
2017-04-21 17:00:00	IWM	ETF	137.2	137.3	137.05	137.13	77892.0
2017-04-21 18:00:00	IWM	ETF	137.14	137.15	137.14	137.15	600.0
2017-04-21 19:00:00	IWM	ETF	137.15	137.16	137.1451	137.15	427000.0
2017-04-21 04:00:00	DIA	ETF	205.75	205.75	205.6	205.6	400.0
2017-04-21 07:00:00	DIA	ETF	205.74	205.74	205.7	205.7	1600.0

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

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