PREVIEW / etf_1hour / 2016-04-28

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-04-28.parquet
  size:    255 KB
  rows:    8,183

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
2016-04-28 04:00:00	SPY	ETF	208.47	208.47	207.45	207.6	191714.0
2016-04-28 05:00:00	SPY	ETF	207.61	207.95	207.6	207.88	24005.0
2016-04-28 06:00:00	SPY	ETF	207.84	208.04	207.84	207.84	66084.0
2016-04-28 07:00:00	SPY	ETF	207.86	208.21	207.8	207.97	363317.0
2016-04-28 08:00:00	SPY	ETF	207.93	208.29	207.82	208.27	818605.0
2016-04-28 09:00:00	SPY	ETF	208.24	209.08	208.18	209.05	9684382.0
2016-04-28 10:00:00	SPY	ETF	209.04	209.48	208.925	209.44	11482504.0
2016-04-28 11:00:00	SPY	ETF	209.44	209.76	209.36	209.56	6456148.0
2016-04-28 12:00:00	SPY	ETF	209.57	209.71	209.32	209.62	6538793.0
2016-04-28 13:00:00	SPY	ETF	209.625	209.65	209.06	209.25	6166400.0
2016-04-28 14:00:00	SPY	ETF	209.25	209.35	208.5	208.61	7500845.0
2016-04-28 15:00:00	SPY	ETF	208.62	208.63	206.96	207.48	36525440.0
2016-04-28 16:00:00	SPY	ETF	207.49	209.339	207.2685	207.85	7500569.0
2016-04-28 17:00:00	SPY	ETF	207.83	207.93	207.4475	207.83	570943.0
2016-04-28 18:00:00	SPY	ETF	207.83	207.87	207.61	207.69	373001.0
2016-04-28 19:00:00	SPY	ETF	207.72	207.86	207.72	207.81	44566.0
2016-04-28 04:00:00	QQQ	ETF	107.59	107.59	107.22	107.27	10845.0
2016-04-28 05:00:00	QQQ	ETF	107.35	107.42	107.32	107.32	5906.0
2016-04-28 06:00:00	QQQ	ETF	107.44	107.52	107.43	107.43	8097.0
2016-04-28 07:00:00	QQQ	ETF	107.33	107.56	107.33	107.5	59136.0
2016-04-28 08:00:00	QQQ	ETF	107.51	107.66	107.47	107.66	111465.0
2016-04-28 09:00:00	QQQ	ETF	107.67	108.036	107.56	107.982	3196248.0
2016-04-28 10:00:00	QQQ	ETF	107.98	108.27	107.81	108.26	2885279.0
2016-04-28 11:00:00	QQQ	ETF	108.265	108.3335	108.17	108.21	1871864.0
2016-04-28 12:00:00	QQQ	ETF	108.22	108.28	107.8089	107.9	1544089.0
2016-04-28 13:00:00	QQQ	ETF	107.9	107.91	107.545	107.59	2295381.0
2016-04-28 14:00:00	QQQ	ETF	107.59	107.7	107.04	107.15	3348160.0
2016-04-28 15:00:00	QQQ	ETF	107.16	107.16	106.0705	106.31	10249857.0
2016-04-28 16:00:00	QQQ	ETF	106.32	107.5848	106.28	107.0	2840327.0
2016-04-28 17:00:00	QQQ	ETF	107.01	107.03	106.9	106.96	63639.0
2016-04-28 18:00:00	QQQ	ETF	107.01	107.08	106.92	106.96	44507.0
2016-04-28 19:00:00	QQQ	ETF	107.0	107.09	107.0	107.03	10561.0
2016-04-28 04:00:00	IWM	ETF	114.52	114.52	113.71	113.77	5150.0
2016-04-28 05:00:00	IWM	ETF	113.77	113.88	113.77	113.85	3200.0
2016-04-28 06:00:00	IWM	ETF	113.91	113.95	113.89	113.95	28967.0
2016-04-28 07:00:00	IWM	ETF	113.89	114.07	113.84	113.96	32849.0
2016-04-28 08:00:00	IWM	ETF	113.93	114.19	113.93	114.19	58573.0
2016-04-28 09:00:00	IWM	ETF	114.2	114.68	113.9	114.6072	2694006.0
2016-04-28 10:00:00	IWM	ETF	114.6	114.86	114.54	114.79	2418777.0
2016-04-28 11:00:00	IWM	ETF	114.79	115.0	114.65	114.88	2290259.0
2016-04-28 12:00:00	IWM	ETF	114.89	114.96	114.66	114.7	1530126.0
2016-04-28 13:00:00	IWM	ETF	114.705	114.79	114.49	114.73	1711827.0
2016-04-28 14:00:00	IWM	ETF	114.72	114.79	114.2	114.28	1982864.0
2016-04-28 15:00:00	IWM	ETF	114.28	114.28	113.19	113.47	8141240.0
2016-04-28 16:00:00	IWM	ETF	113.47	113.82	113.44	113.76	932031.0
2016-04-28 17:00:00	IWM	ETF	113.75	113.78	113.74	113.74	7095.0
2016-04-28 18:00:00	IWM	ETF	113.62	113.62	113.6	113.6	12200.0
2016-04-28 19:00:00	IWM	ETF	113.6	113.74	113.6	113.74	8900.0
2016-04-28 07:00:00	DIA	ETF	178.86	178.86	178.7	178.75	2725.0
2016-04-28 08:00:00	DIA	ETF	178.85	179.07	178.82	178.82	6267.0

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

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