PREVIEW / etf_1hour / 2016-04-13

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-04-13.parquet
  size:    256 KB
  rows:    8,222

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-13 04:00:00	SPY	ETF	206.8	207.01	206.7	206.95	20919.0
2016-04-13 05:00:00	SPY	ETF	206.96	207.3	206.96	207.08	39000.0
2016-04-13 06:00:00	SPY	ETF	207.09	207.21	206.94	207.21	124694.0
2016-04-13 07:00:00	SPY	ETF	207.22	207.29	207.04	207.13	440368.0
2016-04-13 08:00:00	SPY	ETF	207.12	207.23	198.86	206.9	975954.0
2016-04-13 09:00:00	SPY	ETF	206.9	207.45	206.9	207.285	11888126.0
2016-04-13 10:00:00	SPY	ETF	207.29	207.44	206.84	207.07	15963973.0
2016-04-13 11:00:00	SPY	ETF	207.06	207.8	207.0121	207.57	13520405.0
2016-04-13 12:00:00	SPY	ETF	207.57	207.61	207.21	207.42	7326325.0
2016-04-13 13:00:00	SPY	ETF	207.415	207.71	207.15	207.65	8336871.0
2016-04-13 14:00:00	SPY	ETF	207.64	207.88	207.5	207.59	10529652.0
2016-04-13 15:00:00	SPY	ETF	207.585	208.1	207.55	208.02	18773069.0
2016-04-13 16:00:00	SPY	ETF	208.02	208.05	205.9398	208.0	5916813.0
2016-04-13 17:00:00	SPY	ETF	208.0	208.09	207.98	208.07	438252.0
2016-04-13 18:00:00	SPY	ETF	208.05	208.09	207.94	208.0	252997.0
2016-04-13 19:00:00	SPY	ETF	208.0	208.08	207.95	208.08	144468.0
2016-04-13 04:00:00	QQQ	ETF	110.07	110.23	110.07	110.19	2798.0
2016-04-13 05:00:00	QQQ	ETF	110.25	110.44	110.25	110.36	4895.0
2016-04-13 06:00:00	QQQ	ETF	110.33	110.39	110.29	110.35	6761.0
2016-04-13 07:00:00	QQQ	ETF	110.33	110.4	110.28	110.35	147290.0
2016-04-13 08:00:00	QQQ	ETF	110.32	110.37	110.2	110.28	122915.0
2016-04-13 09:00:00	QQQ	ETF	110.27	110.82	110.21	110.725	3683256.0
2016-04-13 10:00:00	QQQ	ETF	110.725	110.92	110.49	110.52	4155765.0
2016-04-13 11:00:00	QQQ	ETF	110.51	110.894	110.43	110.61	2789291.0
2016-04-13 12:00:00	QQQ	ETF	110.61	110.69	110.4	110.56	2040778.0
2016-04-13 13:00:00	QQQ	ETF	110.56	110.595	110.34	110.54	1890375.0
2016-04-13 14:00:00	QQQ	ETF	110.54	110.76	110.421	110.6	1747099.0
2016-04-13 15:00:00	QQQ	ETF	110.59	111.08	110.58	110.92	4996400.0
2016-04-13 16:00:00	QQQ	ETF	110.89	110.98	109.513	110.96	1830789.0
2016-04-13 17:00:00	QQQ	ETF	110.97	110.97	110.92	110.92	8616.0
2016-04-13 18:00:00	QQQ	ETF	110.93	110.96	110.91	110.96	10447.0
2016-04-13 19:00:00	QQQ	ETF	110.91	110.98	110.88	110.95	42786.0
2016-04-13 04:00:00	IWM	ETF	110.55	110.55	110.55	110.55	277.0
2016-04-13 05:00:00	IWM	ETF	110.82	110.9	110.82	110.84	3600.0
2016-04-13 06:00:00	IWM	ETF	110.8	110.82	110.7	110.82	80194.0
2016-04-13 07:00:00	IWM	ETF	110.83	110.85	110.73	110.73	109198.0
2016-04-13 08:00:00	IWM	ETF	110.73	110.76	110.57	110.6	89909.0
2016-04-13 09:00:00	IWM	ETF	110.61	111.0	110.51	110.84	3484627.0
2016-04-13 10:00:00	IWM	ETF	110.85	111.41	110.8	111.1299	4297141.0
2016-04-13 11:00:00	IWM	ETF	111.11	111.97	111.09	111.72	6395140.0
2016-04-13 12:00:00	IWM	ETF	111.72	111.79	111.52	111.695	3033400.0
2016-04-13 13:00:00	IWM	ETF	111.695	111.99	111.6	111.95	2636245.0
2016-04-13 14:00:00	IWM	ETF	111.94	112.32	111.86	112.24	3454722.0
2016-04-13 15:00:00	IWM	ETF	112.23	112.43	112.15	112.32	6862040.0
2016-04-13 16:00:00	IWM	ETF	112.33	112.48	112.28	112.47	1540051.0
2016-04-13 17:00:00	IWM	ETF	112.47	112.52	112.42	112.49	83856.0
2016-04-13 18:00:00	IWM	ETF	112.44	112.45	112.4	112.45	4713.0
2016-04-13 19:00:00	IWM	ETF	112.44	112.5	112.42	112.5	4400.0
2016-04-13 06:00:00	DIA	ETF	178.0	178.0	177.82	177.82	2138.0
2016-04-13 08:00:00	DIA	ETF	177.91	177.92	177.85	177.91	6957.0

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

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