PREVIEW / etf_1hour / 2019-11-13

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-11-13.parquet
  size:    339 KB
  rows:    11,145

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
2019-11-13 04:00:00	SPY	ETF	308.26	308.26	307.44	307.54	30557.0
2019-11-13 05:00:00	SPY	ETF	307.67	307.9	307.64	307.86	19827.0
2019-11-13 06:00:00	SPY	ETF	307.84	307.87	307.73	307.84	41118.0
2019-11-13 07:00:00	SPY	ETF	307.91	308.13	307.66	308.04	155819.0
2019-11-13 08:00:00	SPY	ETF	307.89	309.0	307.73	308.18	365564.0
2019-11-13 09:00:00	SPY	ETF	308.19	308.47	307.66	308.37	4901362.0
2019-11-13 10:00:00	SPY	ETF	308.3701	309.03	308.23	309.0	5049557.0
2019-11-13 11:00:00	SPY	ETF	309.0	309.25	308.65	309.12	5861519.0
2019-11-13 12:00:00	SPY	ETF	309.12	309.42	308.98	309.35	4717152.0
2019-11-13 13:00:00	SPY	ETF	309.35	309.54	308.38	308.83	7572284.0
2019-11-13 14:00:00	SPY	ETF	308.84	309.19	308.42	309.15	8577569.0
2019-11-13 15:00:00	SPY	ETF	309.15	309.37	308.87	309.07	10979033.0
2019-11-13 16:00:00	SPY	ETF	309.1	309.46	309.0	309.45	4836898.0
2019-11-13 17:00:00	SPY	ETF	309.41	309.45	309.3	309.43	161804.0
2019-11-13 18:00:00	SPY	ETF	309.41	309.45	309.19	309.26	82508.0
2019-11-13 19:00:00	SPY	ETF	309.26	309.32	309.05	309.09	109147.0
2019-11-13 04:00:00	QQQ	ETF	201.0	201.0	200.3	200.42	20283.0
2019-11-13 05:00:00	QQQ	ETF	200.47	200.65	200.44	200.61	39236.0
2019-11-13 06:00:00	QQQ	ETF	200.61	200.65	200.5	200.63	14220.0
2019-11-13 07:00:00	QQQ	ETF	200.67	200.89	200.55	200.78	56909.0
2019-11-13 08:00:00	QQQ	ETF	200.75	201.32	200.58	201.02	104286.0
2019-11-13 09:00:00	QQQ	ETF	201.03	201.34	200.71	201.12	1563729.0
2019-11-13 10:00:00	QQQ	ETF	201.12	201.6	201.0	201.54	1729285.0
2019-11-13 11:00:00	QQQ	ETF	201.54	201.7342	201.23	201.65	1413953.0
2019-11-13 12:00:00	QQQ	ETF	201.64	201.775	201.51	201.665	818106.0
2019-11-13 13:00:00	QQQ	ETF	201.67	201.7542	200.92	201.2	2083899.0
2019-11-13 14:00:00	QQQ	ETF	201.19	201.4	200.75	201.37	2265276.0
2019-11-13 15:00:00	QQQ	ETF	201.39	201.6	201.18	201.37	2011736.0
2019-11-13 16:00:00	QQQ	ETF	201.4	201.59	201.09	201.5	1304478.0
2019-11-13 17:00:00	QQQ	ETF	201.48	201.5	201.41	201.5	4497.0
2019-11-13 18:00:00	QQQ	ETF	201.44	201.44	201.3	201.38	33818.0
2019-11-13 19:00:00	QQQ	ETF	201.31	201.36	201.21	201.23	17880.0
2019-11-13 04:00:00	IWM	ETF	158.0	158.0	157.49	157.49	5950.0
2019-11-13 05:00:00	IWM	ETF	157.54	157.6	157.54	157.6	1000.0
2019-11-13 06:00:00	IWM	ETF	157.55	157.64	157.55	157.64	5150.0
2019-11-13 07:00:00	IWM	ETF	157.72	157.85	157.58	157.84	24126.0
2019-11-13 08:00:00	IWM	ETF	157.66	158.29	157.66	157.9	82178.0
2019-11-13 09:00:00	IWM	ETF	157.92	157.92	157.19	157.62	2033227.0
2019-11-13 10:00:00	IWM	ETF	157.63	157.98	157.21	157.85	1664638.0
2019-11-13 11:00:00	IWM	ETF	157.85	158.42	157.77	158.25	1420056.0
2019-11-13 12:00:00	IWM	ETF	158.24	158.49	158.13	158.44	530896.0
2019-11-13 13:00:00	IWM	ETF	158.44	158.5	157.7	157.89	1237803.0
2019-11-13 14:00:00	IWM	ETF	157.8926	158.34	157.7	158.33	1350776.0
2019-11-13 15:00:00	IWM	ETF	158.34	158.43	158.04	158.19	2861980.0
2019-11-13 16:00:00	IWM	ETF	158.19	158.7343	158.15	158.49	1081008.0
2019-11-13 17:00:00	IWM	ETF	158.49	158.49	158.36	158.45	1020.0
2019-11-13 18:00:00	IWM	ETF	158.49	158.49	158.36	158.36	2850.0
2019-11-13 19:00:00	IWM	ETF	158.49	158.49	158.25	158.31	8800.0
2019-11-13 04:00:00	DIA	ETF	276.37	276.37	276.3	276.3	200.0
2019-11-13 07:00:00	DIA	ETF	276.2	276.44	276.2	276.35	769.0

> showing 50 of 11,145 rows — these rows as CSV

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