PREVIEW / etf_1hour / 2016-10-03

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-10-03.parquet
  size:    256 KB
  rows:    8,298

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-10-03 04:00:00	SPY	ETF	216.66	216.66	216.36	216.38	20326.0
2016-10-03 05:00:00	SPY	ETF	216.41	216.58	216.37	216.47	15954.0
2016-10-03 06:00:00	SPY	ETF	216.48	216.54	216.33	216.33	36872.0
2016-10-03 07:00:00	SPY	ETF	216.31	216.39	216.18	216.2	75694.0
2016-10-03 08:00:00	SPY	ETF	216.24	216.31	215.62	215.66	1121925.0
2016-10-03 09:00:00	SPY	ETF	215.68	215.86	215.28	215.46	8398776.0
2016-10-03 10:00:00	SPY	ETF	215.46	216.04	215.33	215.79	11090548.0
2016-10-03 11:00:00	SPY	ETF	215.795	215.8	215.11	215.3311	9697598.0
2016-10-03 12:00:00	SPY	ETF	215.33	215.54	215.04	215.49	12381340.0
2016-10-03 13:00:00	SPY	ETF	215.48	215.585	215.18	215.535	6978962.0
2016-10-03 14:00:00	SPY	ETF	215.53	215.72	215.23	215.48	7440974.0
2016-10-03 15:00:00	SPY	ETF	215.475	215.94	215.34	215.69	15590360.0
2016-10-03 16:00:00	SPY	ETF	215.67	215.9	215.64	215.78	7234519.0
2016-10-03 17:00:00	SPY	ETF	215.78	215.8	215.71	215.77	67695.0
2016-10-03 18:00:00	SPY	ETF	215.75	215.92	215.75	215.88	72098.0
2016-10-03 19:00:00	SPY	ETF	215.88	215.88	215.81	215.83	41857.0
2016-10-03 04:00:00	QQQ	ETF	118.72	118.72	118.72	118.72	510.0
2016-10-03 05:00:00	QQQ	ETF	118.72	118.72	118.72	118.72	1229.0
2016-10-03 06:00:00	QQQ	ETF	118.81	118.81	118.72	118.72	9870.0
2016-10-03 07:00:00	QQQ	ETF	118.7	118.73	118.68	118.68	13216.0
2016-10-03 08:00:00	QQQ	ETF	118.71	118.72	118.44	118.44	116851.0
2016-10-03 09:00:00	QQQ	ETF	118.4	118.59	118.2	118.24	2233155.0
2016-10-03 10:00:00	QQQ	ETF	118.24	118.7	118.2	118.55	2559041.0
2016-10-03 11:00:00	QQQ	ETF	118.56	118.56	118.1	118.24	1921531.0
2016-10-03 12:00:00	QQQ	ETF	118.23	118.32	118.09	118.29	2081599.0
2016-10-03 13:00:00	QQQ	ETF	118.29	118.35	118.14	118.33	1201855.0
2016-10-03 14:00:00	QQQ	ETF	118.33	118.49	118.221	118.33	1733935.0
2016-10-03 15:00:00	QQQ	ETF	118.33	118.63	118.289	118.56	3025364.0
2016-10-03 16:00:00	QQQ	ETF	118.55	118.68	118.55	118.68	348509.0
2016-10-03 17:00:00	QQQ	ETF	118.69	118.69	118.63	118.65	1621.0
2016-10-03 18:00:00	QQQ	ETF	118.69	118.73	118.69	118.72	9673.0
2016-10-03 19:00:00	QQQ	ETF	118.7	118.7	118.67	118.68	9915.0
2016-10-03 05:00:00	IWM	ETF	124.23	124.34	124.23	124.34	860.0
2016-10-03 06:00:00	IWM	ETF	124.23	124.23	124.19	124.19	5040.0
2016-10-03 07:00:00	IWM	ETF	124.17	124.2	124.17	124.2	27476.0
2016-10-03 08:00:00	IWM	ETF	124.09	124.21	123.67	123.67	189281.0
2016-10-03 09:00:00	IWM	ETF	123.7	123.87	123.35	123.39	3053569.0
2016-10-03 10:00:00	IWM	ETF	123.45	124.095	123.215	123.93	2991630.0
2016-10-03 11:00:00	IWM	ETF	123.94	123.95	123.24	123.39	1914847.0
2016-10-03 12:00:00	IWM	ETF	123.385	123.55	123.13	123.537	1595097.0
2016-10-03 13:00:00	IWM	ETF	123.54	123.71	123.25	123.64	1054660.0
2016-10-03 14:00:00	IWM	ETF	123.65	123.77	123.32	123.53	1686093.0
2016-10-03 15:00:00	IWM	ETF	123.53	123.83	123.35	123.82	3256788.0
2016-10-03 16:00:00	IWM	ETF	123.81	123.92	123.775	123.9	948746.0
2016-10-03 17:00:00	IWM	ETF	123.88	123.91	123.82	123.91	4830.0
2016-10-03 18:00:00	IWM	ETF	123.92	123.92	123.92	123.92	100.0
2016-10-03 04:00:00	DIA	ETF	183.3	183.78	183.3	183.78	350.0
2016-10-03 08:00:00	DIA	ETF	182.88	182.88	182.78	182.78	1685.0
2016-10-03 09:00:00	DIA	ETF	182.34	182.4	181.78	181.95	596750.0
2016-10-03 10:00:00	DIA	ETF	181.97	182.5	181.97	182.27	384379.0

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

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