PREVIEW / etf_1hour / 2016-10-05

all etf 1-hour files

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

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-05 04:00:00	SPY	ETF	214.81	214.9	214.81	214.86	3449.0
2016-10-05 05:00:00	SPY	ETF	215.0	215.0	214.72	214.8	32270.0
2016-10-05 06:00:00	SPY	ETF	214.78	214.88	214.7	214.75	28118.0
2016-10-05 07:00:00	SPY	ETF	214.78	215.33	214.75	215.26	252900.0
2016-10-05 08:00:00	SPY	ETF	215.2	215.48	214.68	215.28	1091998.0
2016-10-05 09:00:00	SPY	ETF	215.28	215.77	215.08	215.685	8565197.0
2016-10-05 10:00:00	SPY	ETF	215.685	215.91	215.33	215.64	15837870.0
2016-10-05 11:00:00	SPY	ETF	215.64	215.9	215.56	215.7857	6054607.0
2016-10-05 12:00:00	SPY	ETF	215.78	216.035	215.76	215.845	5582163.0
2016-10-05 13:00:00	SPY	ETF	215.84	216.01	215.73	215.99	5103844.0
2016-10-05 14:00:00	SPY	ETF	215.98	216.0	215.8	215.98	6468769.0
2016-10-05 15:00:00	SPY	ETF	215.98	216.13	215.56	215.66	14597240.0
2016-10-05 16:00:00	SPY	ETF	215.64	215.8757	214.7658	215.73	7161698.0
2016-10-05 17:00:00	SPY	ETF	215.75	215.77	215.7	215.72	108531.0
2016-10-05 18:00:00	SPY	ETF	215.7	215.8	215.65	215.7	89175.0
2016-10-05 19:00:00	SPY	ETF	215.7	215.72	215.66	215.67	20099.0
2016-10-05 04:00:00	QQQ	ETF	118.33	118.5	118.33	118.38	4900.0
2016-10-05 06:00:00	QQQ	ETF	118.4	118.4	118.38	118.38	400.0
2016-10-05 07:00:00	QQQ	ETF	118.41	118.68	118.41	118.65	77295.0
2016-10-05 08:00:00	QQQ	ETF	118.64	118.72	118.37	118.62	77949.0
2016-10-05 09:00:00	QQQ	ETF	118.61	118.9	118.54	118.87	1127490.0
2016-10-05 10:00:00	QQQ	ETF	118.88	119.11	118.74	118.86	3073366.0
2016-10-05 11:00:00	QQQ	ETF	118.85	119.08	118.81	119.04	1280703.0
2016-10-05 12:00:00	QQQ	ETF	119.04	119.17	119.01	119.03	1069610.0
2016-10-05 13:00:00	QQQ	ETF	119.02	119.1	118.9001	119.07	1064685.0
2016-10-05 14:00:00	QQQ	ETF	119.07	119.07	118.95	119.03	1330477.0
2016-10-05 15:00:00	QQQ	ETF	119.03	119.09	118.76	118.8	2972554.0
2016-10-05 16:00:00	QQQ	ETF	118.79	118.91	118.75	118.87	338292.0
2016-10-05 17:00:00	QQQ	ETF	118.83	118.85	118.82	118.82	877.0
2016-10-05 18:00:00	QQQ	ETF	118.86	118.88	118.84	118.84	1809.0
2016-10-05 19:00:00	QQQ	ETF	118.85	118.86	118.82	118.82	13200.0
2016-10-05 05:00:00	IWM	ETF	123.19	123.19	123.19	123.19	200.0
2016-10-05 07:00:00	IWM	ETF	123.23	123.55	123.21	123.55	58812.0
2016-10-05 08:00:00	IWM	ETF	123.21	123.64	123.21	123.56	56852.0
2016-10-05 09:00:00	IWM	ETF	123.53	124.04	123.45	123.88	2279955.0
2016-10-05 10:00:00	IWM	ETF	123.89	124.29	123.76	124.25	5025809.0
2016-10-05 11:00:00	IWM	ETF	124.24	124.57	124.175	124.52	2935166.0
2016-10-05 12:00:00	IWM	ETF	124.52	124.68	124.51	124.62	2618763.0
2016-10-05 13:00:00	IWM	ETF	124.61	124.64	124.44	124.56	1521977.0
2016-10-05 14:00:00	IWM	ETF	124.57	124.58	124.22	124.28	2180014.0
2016-10-05 15:00:00	IWM	ETF	124.28	124.36	123.87	123.97	4072156.0
2016-10-05 16:00:00	IWM	ETF	123.95	124.03	123.87	123.91	1224867.0
2016-10-05 17:00:00	IWM	ETF	123.95	123.96	123.9	123.9	10423.0
2016-10-05 18:00:00	IWM	ETF	123.93	123.93	123.93	123.93	2600.0
2016-10-05 19:00:00	IWM	ETF	123.93	123.95	123.85	123.95	3239.0
2016-10-05 04:00:00	DIA	ETF	181.55	181.55	181.5	181.5	300.0
2016-10-05 07:00:00	DIA	ETF	181.67	181.67	181.67	181.67	100.0
2016-10-05 08:00:00	DIA	ETF	182.05	182.05	181.48	181.48	821.0
2016-10-05 09:00:00	DIA	ETF	181.86	182.57	181.86	182.47	282462.0
2016-10-05 10:00:00	DIA	ETF	182.48	182.76	182.24	182.55	406721.0

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

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