PREVIEW / etf_1hour / 2017-10-26

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-10-26.parquet
  size:    289 KB
  rows:    9,494

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-10-26 04:00:00	SPY	ETF	255.65	255.65	255.5	255.5	4600.0
2017-10-26 05:00:00	SPY	ETF	255.5	255.53	255.48	255.53	40800.0
2017-10-26 06:00:00	SPY	ETF	255.61	255.88	255.61	255.87	31600.0
2017-10-26 07:00:00	SPY	ETF	255.85	256.14	255.83	256.0	233813.0
2017-10-26 08:00:00	SPY	ETF	256.0	256.12	255.6	255.92	578248.0
2017-10-26 09:00:00	SPY	ETF	255.87	256.2	255.82	256.035	7930644.0
2017-10-26 10:00:00	SPY	ETF	256.04	256.16	255.56	256.11	7655035.0
2017-10-26 11:00:00	SPY	ETF	256.11	256.3	255.69	255.93	9953920.0
2017-10-26 12:00:00	SPY	ETF	255.93	256.14	255.68	255.7646	5106735.0
2017-10-26 13:00:00	SPY	ETF	255.76	256.04	255.6801	256.02	3867179.0
2017-10-26 14:00:00	SPY	ETF	256.02	256.1	255.76	255.77	3267255.0
2017-10-26 15:00:00	SPY	ETF	255.77	255.92	255.58	255.59	18333493.0
2017-10-26 16:00:00	SPY	ETF	255.6	256.13	255.4	256.04	8289768.0
2017-10-26 17:00:00	SPY	ETF	256.04	256.1	256.0	256.03	119173.0
2017-10-26 18:00:00	SPY	ETF	256.02	256.06	255.96	255.99	68519.0
2017-10-26 19:00:00	SPY	ETF	255.99	256.02	255.97	256.02	62491.0
2017-10-26 04:00:00	QQQ	ETF	147.68	147.69	147.59	147.59	10200.0
2017-10-26 05:00:00	QQQ	ETF	147.59	147.65	147.58	147.62	29200.0
2017-10-26 06:00:00	QQQ	ETF	147.68	147.8	147.68	147.77	8720.0
2017-10-26 07:00:00	QQQ	ETF	147.77	147.91	147.68	147.7	53743.0
2017-10-26 08:00:00	QQQ	ETF	147.72	147.79	147.42	147.45	353202.0
2017-10-26 09:00:00	QQQ	ETF	147.43	147.59	147.14	147.33	2996599.0
2017-10-26 10:00:00	QQQ	ETF	147.34	147.6452	146.92	147.57	3594059.0
2017-10-26 11:00:00	QQQ	ETF	147.56	147.705	147.185	147.34	2163951.0
2017-10-26 12:00:00	QQQ	ETF	147.3499	147.48	147.1	147.181	993274.0
2017-10-26 13:00:00	QQQ	ETF	147.18	147.36	147.09	147.2454	944908.0
2017-10-26 14:00:00	QQQ	ETF	147.24	147.41	147.19	147.23	1035416.0
2017-10-26 15:00:00	QQQ	ETF	147.235	147.2991	146.97	146.98	3397301.0
2017-10-26 16:00:00	QQQ	ETF	146.98	148.43	146.96	148.24	3716607.0
2017-10-26 17:00:00	QQQ	ETF	148.28	148.5	148.28	148.35	242086.0
2017-10-26 18:00:00	QQQ	ETF	148.33	148.36	148.26	148.3	100496.0
2017-10-26 19:00:00	QQQ	ETF	148.3	148.3	148.22	148.27	29982.0
2017-10-26 04:00:00	IWM	ETF	148.73	148.74	148.59	148.59	7300.0
2017-10-26 06:00:00	IWM	ETF	148.85	148.96	148.83	148.95	16961.0
2017-10-26 07:00:00	IWM	ETF	148.92	149.1	148.92	149.01	48630.0
2017-10-26 08:00:00	IWM	ETF	149.0	149.15	148.8	148.91	149868.0
2017-10-26 09:00:00	IWM	ETF	148.89	149.14	148.68	148.9103	1630436.0
2017-10-26 10:00:00	IWM	ETF	148.91	149.25	148.59	149.1608	2857247.0
2017-10-26 11:00:00	IWM	ETF	149.1646	149.34	148.88	148.96	2847763.0
2017-10-26 12:00:00	IWM	ETF	148.97	149.06	148.51	148.54	813511.0
2017-10-26 13:00:00	IWM	ETF	148.54	148.99	148.54	148.93	904777.0
2017-10-26 14:00:00	IWM	ETF	148.94	149.04	148.715	148.785	782197.0
2017-10-26 15:00:00	IWM	ETF	148.78	148.88	148.6	148.78	2853851.0
2017-10-26 16:00:00	IWM	ETF	148.75	149.18	148.63	148.96	655395.0
2017-10-26 17:00:00	IWM	ETF	148.96	148.98	148.96	148.98	11044.0
2017-10-26 18:00:00	IWM	ETF	148.98	149.0	148.88	148.97	6902.0
2017-10-26 19:00:00	IWM	ETF	148.91	148.95	148.85	148.95	10277.0
2017-10-26 07:00:00	DIA	ETF	233.75	234.04	233.75	234.04	1500.0
2017-10-26 08:00:00	DIA	ETF	234.08	234.08	233.8	233.82	10354.0
2017-10-26 09:00:00	DIA	ETF	233.85	234.42	233.82	234.33	591421.0

> showing 50 of 9,494 rows — these rows as CSV

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