PREVIEW / etf_1hour / 2017-12-04

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-12-04.parquet
  size:    302 KB
  rows:    9,937

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-12-04 04:00:00	SPY	ETF	265.9	266.15	265.87	265.87	13592.0
2017-12-04 05:00:00	SPY	ETF	265.87	266.27	265.87	266.23	36994.0
2017-12-04 06:00:00	SPY	ETF	266.23	266.37	266.18	266.34	87773.0
2017-12-04 07:00:00	SPY	ETF	266.31	266.38	266.18	266.18	507135.0
2017-12-04 08:00:00	SPY	ETF	264.46	266.36	264.46	266.09	653943.0
2017-12-04 09:00:00	SPY	ETF	266.07	266.8	266.03	266.42	12793686.0
2017-12-04 10:00:00	SPY	ETF	266.42	266.5	265.36	265.65	19332081.0
2017-12-04 11:00:00	SPY	ETF	265.64	266.0	265.37	265.8	7640432.0
2017-12-04 12:00:00	SPY	ETF	265.8	266.04	265.465	265.81	6451142.0
2017-12-04 13:00:00	SPY	ETF	265.81	266.01	265.75	265.939	4940061.0
2017-12-04 14:00:00	SPY	ETF	265.94	265.95	264.85	265.03	10010031.0
2017-12-04 15:00:00	SPY	ETF	265.03	265.06	264.12	264.13	18580292.0
2017-12-04 16:00:00	SPY	ETF	264.12	264.21	263.7	263.94	10226984.0
2017-12-04 17:00:00	SPY	ETF	263.92	266.1945	263.92	263.94	248413.0
2017-12-04 18:00:00	SPY	ETF	263.94	264.15	263.9	264.12	80548.0
2017-12-04 19:00:00	SPY	ETF	264.09	264.27	264.0	264.08	43829.0
2017-12-04 04:00:00	QQQ	ETF	155.3	155.5	155.13	155.13	3432.0
2017-12-04 05:00:00	QQQ	ETF	155.13	155.4	155.12	155.4	22416.0
2017-12-04 06:00:00	QQQ	ETF	155.35	155.48	155.35	155.43	33433.0
2017-12-04 07:00:00	QQQ	ETF	155.4	155.52	155.32	155.33	211179.0
2017-12-04 08:00:00	QQQ	ETF	155.35	155.52	155.24	155.36	255873.0
2017-12-04 09:00:00	QQQ	ETF	155.45	155.625	154.78	154.85	6962489.0
2017-12-04 10:00:00	QQQ	ETF	154.86	154.86	152.99	153.25	10874838.0
2017-12-04 11:00:00	QQQ	ETF	153.245	153.79	152.98	153.59	6142394.0
2017-12-04 12:00:00	QQQ	ETF	153.58	154.06	153.45	154.02	3361826.0
2017-12-04 13:00:00	QQQ	ETF	154.02	154.28	153.99	154.22	2344176.0
2017-12-04 14:00:00	QQQ	ETF	154.23	154.23	153.23	153.29	4319036.0
2017-12-04 15:00:00	QQQ	ETF	153.28	153.36	152.56	152.73	9264958.0
2017-12-04 16:00:00	QQQ	ETF	152.73	153.8814	152.4	152.62	2374803.0
2017-12-04 17:00:00	QQQ	ETF	152.7	152.7	152.5	152.52	51471.0
2017-12-04 18:00:00	QQQ	ETF	152.56	152.84	152.56	152.84	38365.0
2017-12-04 19:00:00	QQQ	ETF	152.71	152.9	152.7	152.75	11898.0
2017-12-04 04:00:00	IWM	ETF	154.12	154.4	154.12	154.39	15375.0
2017-12-04 05:00:00	IWM	ETF	154.36	154.59	154.35	154.57	26258.0
2017-12-04 06:00:00	IWM	ETF	154.53	154.66	154.53	154.61	34654.0
2017-12-04 07:00:00	IWM	ETF	154.58	154.66	154.43	154.44	70376.0
2017-12-04 08:00:00	IWM	ETF	153.02	154.66	153.02	154.42	160359.0
2017-12-04 09:00:00	IWM	ETF	154.44	155.41	154.4	154.89	5943307.0
2017-12-04 10:00:00	IWM	ETF	154.9	154.94	153.84	154.34	5817801.0
2017-12-04 11:00:00	IWM	ETF	154.35	154.535	153.851	154.34	3786720.0
2017-12-04 12:00:00	IWM	ETF	154.34	154.4	153.59	153.76	2956615.0
2017-12-04 13:00:00	IWM	ETF	153.76	153.89	153.6	153.78	1281931.0
2017-12-04 14:00:00	IWM	ETF	153.79	153.79	152.85	153.04	2616808.0
2017-12-04 15:00:00	IWM	ETF	153.035	153.26	152.3	152.44	7259525.0
2017-12-04 16:00:00	IWM	ETF	152.42	152.48	152.13	152.35	2675407.0
2017-12-04 17:00:00	IWM	ETF	152.33	153.9484	152.32	152.32	169501.0
2017-12-04 18:00:00	IWM	ETF	152.4	152.6	152.37	152.45	414223.0
2017-12-04 19:00:00	IWM	ETF	152.5	152.78	152.5	152.64	13421.0
2017-12-04 04:00:00	DIA	ETF	243.6	244.55	243.6	244.55	995.0
2017-12-04 05:00:00	DIA	ETF	244.38	244.57	244.38	244.57	336.0

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

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