PREVIEW / etf_1hour / 2020-02-04

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-02-04.parquet
  size:    373 KB
  rows:    12,266

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
2020-02-04 04:00:00	SPY	ETF	327.28	327.92	327.2	327.79	42471.0
2020-02-04 05:00:00	SPY	ETF	327.83	327.87	327.38	327.4	24880.0
2020-02-04 06:00:00	SPY	ETF	327.34	327.76	327.29	327.55	94326.0
2020-02-04 07:00:00	SPY	ETF	327.53	328.25	327.37	328.2	678178.0
2020-02-04 08:00:00	SPY	ETF	327.44	328.4	325.9	328.33	624296.0
2020-02-04 09:00:00	SPY	ETF	328.32	328.95	327.72	328.73	9211204.0
2020-02-04 10:00:00	SPY	ETF	328.75	329.355	328.28	328.97	8792289.0
2020-02-04 11:00:00	SPY	ETF	328.96	329.9	328.86	329.585	5680206.0
2020-02-04 12:00:00	SPY	ETF	329.59	329.88	329.48	329.74	6633574.0
2020-02-04 13:00:00	SPY	ETF	329.745	329.8186	329.1	329.6401	4408344.0
2020-02-04 14:00:00	SPY	ETF	329.65	330.01	329.51	329.72	5905269.0
2020-02-04 15:00:00	SPY	ETF	329.715	329.87	328.88	329.08	12179498.0
2020-02-04 16:00:00	SPY	ETF	329.09	329.74	328.92	329.5	4564301.0
2020-02-04 17:00:00	SPY	ETF	329.56	329.7	329.06	329.45	1246186.0
2020-02-04 18:00:00	SPY	ETF	329.48	329.53	328.86	328.93	263751.0
2020-02-04 19:00:00	SPY	ETF	328.91	329.27	328.6	328.66	149842.0
2020-02-04 04:00:00	QQQ	ETF	224.26	224.81	224.26	224.76	52396.0
2020-02-04 05:00:00	QQQ	ETF	224.8	224.84	224.5	224.51	35096.0
2020-02-04 06:00:00	QQQ	ETF	224.5	224.8	224.4	224.68	47559.0
2020-02-04 07:00:00	QQQ	ETF	224.66	225.35	224.5	225.33	451486.0
2020-02-04 08:00:00	QQQ	ETF	224.52	225.5	223.36	225.45	356658.0
2020-02-04 09:00:00	QQQ	ETF	225.46	225.85	224.6523	225.6	4795648.0
2020-02-04 10:00:00	QQQ	ETF	225.6	226.33	225.27	226.05	3981505.0
2020-02-04 11:00:00	QQQ	ETF	226.06	227.12	226.04	227.01	3028476.0
2020-02-04 12:00:00	QQQ	ETF	227.017	227.21	226.905	227.125	2344465.0
2020-02-04 13:00:00	QQQ	ETF	227.13	227.29	226.67	227.24	2165970.0
2020-02-04 14:00:00	QQQ	ETF	227.24	227.71	227.2	227.61	1923230.0
2020-02-04 15:00:00	QQQ	ETF	227.6	227.86	227.185	227.42	5046472.0
2020-02-04 16:00:00	QQQ	ETF	227.41	228.08	227.25	227.87	1935265.0
2020-02-04 17:00:00	QQQ	ETF	227.94	227.95	227.47	227.89	166062.0
2020-02-04 18:00:00	QQQ	ETF	227.89	227.97	227.32	227.41	68065.0
2020-02-04 19:00:00	QQQ	ETF	227.31	227.73	227.08	227.1	96050.0
2020-02-04 04:00:00	IWM	ETF	163.92	164.18	163.88	164.17	12740.0
2020-02-04 05:00:00	IWM	ETF	164.17	164.17	164.13	164.14	3230.0
2020-02-04 06:00:00	IWM	ETF	164.07	164.4	164.07	164.33	18239.0
2020-02-04 07:00:00	IWM	ETF	164.33	164.52	164.28	164.52	120339.0
2020-02-04 08:00:00	IWM	ETF	164.33	164.75	164.3	164.75	50472.0
2020-02-04 09:00:00	IWM	ETF	164.8	165.04	164.16	164.7	2740095.0
2020-02-04 10:00:00	IWM	ETF	164.7	164.87	164.1907	164.64	1690323.0
2020-02-04 11:00:00	IWM	ETF	164.62	164.9	164.38	164.78	1100455.0
2020-02-04 12:00:00	IWM	ETF	164.79	165.25	164.775	165.09	1152411.0
2020-02-04 13:00:00	IWM	ETF	165.1	165.16	164.91	165.09	822468.0
2020-02-04 14:00:00	IWM	ETF	165.09	165.31	165.03	165.04	1120853.0
2020-02-04 15:00:00	IWM	ETF	165.03	165.14	164.63	164.74	2867996.0
2020-02-04 16:00:00	IWM	ETF	164.75	165.23	164.63	165.16	1166766.0
2020-02-04 17:00:00	IWM	ETF	162.32	165.19	162.32	164.77	121272.0
2020-02-04 18:00:00	IWM	ETF	165.07	165.12	164.78	164.8	5660.0
2020-02-04 19:00:00	IWM	ETF	164.79	164.97	164.68	164.69	11004.0
2020-02-04 04:00:00	DIA	ETF	287.23	287.23	287.23	287.23	100.0
2020-02-04 05:00:00	DIA	ETF	287.17	287.17	287.06	287.06	200.0

> showing 50 of 12,266 rows — these rows as CSV

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