PREVIEW / etf_1hour / 2019-11-14

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-11-14.parquet
  size:    335 KB
  rows:    11,106

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-14 04:00:00	SPY	ETF	308.91	309.01	308.69	308.91	4321.0
2019-11-14 05:00:00	SPY	ETF	308.93	309.52	308.93	309.1	12587.0
2019-11-14 06:00:00	SPY	ETF	309.05	309.15	308.83	309.1	56278.0
2019-11-14 07:00:00	SPY	ETF	309.17	309.22	308.9	309.02	76333.0
2019-11-14 08:00:00	SPY	ETF	309.02	309.17	308.66	308.81	368006.0
2019-11-14 09:00:00	SPY	ETF	308.81	309.2	308.7	309.2	2402500.0
2019-11-14 10:00:00	SPY	ETF	309.19	309.46	308.83	308.86	5456231.0
2019-11-14 11:00:00	SPY	ETF	308.85	309.35	308.09	308.4	8327188.0
2019-11-14 12:00:00	SPY	ETF	308.39	309.2036	308.31	309.025	4764470.0
2019-11-14 13:00:00	SPY	ETF	309.02	309.16	308.24	308.74	6025389.0
2019-11-14 14:00:00	SPY	ETF	308.75	309.31	308.58	309.275	6032517.0
2019-11-14 15:00:00	SPY	ETF	309.28	309.64	309.11	309.53	12375029.0
2019-11-14 16:00:00	SPY	ETF	309.54	309.74	309.2036	309.67	4686690.0
2019-11-14 17:00:00	SPY	ETF	309.67	309.67	309.53	309.6	129998.0
2019-11-14 18:00:00	SPY	ETF	309.6	309.81	309.5	309.8	79356.0
2019-11-14 19:00:00	SPY	ETF	309.8	310.69	309.61	310.62	742616.0
2019-11-14 04:00:00	QQQ	ETF	201.06	201.18	200.92	201.14	24621.0
2019-11-14 05:00:00	QQQ	ETF	201.26	201.52	201.14	201.14	35119.0
2019-11-14 06:00:00	QQQ	ETF	201.13	201.19	200.98	201.16	28950.0
2019-11-14 07:00:00	QQQ	ETF	201.2	201.24	200.92	201.02	54220.0
2019-11-14 08:00:00	QQQ	ETF	201.19	201.45	200.75	200.85	155645.0
2019-11-14 09:00:00	QQQ	ETF	200.9	201.23	200.7568	201.1	1748073.0
2019-11-14 10:00:00	QQQ	ETF	201.1	201.39	200.6	200.6	1581933.0
2019-11-14 11:00:00	QQQ	ETF	200.59	201.08	200.22	200.41	1796442.0
2019-11-14 12:00:00	QQQ	ETF	200.4	201.07	200.335	201.02	1627818.0
2019-11-14 13:00:00	QQQ	ETF	201.02	201.21	200.59	200.95	2004102.0
2019-11-14 14:00:00	QQQ	ETF	200.96	201.28	200.87	201.255	1314874.0
2019-11-14 15:00:00	QQQ	ETF	201.26	201.56	201.22	201.42	2739417.0
2019-11-14 16:00:00	QQQ	ETF	201.41	201.52	201.32	201.48	922214.0
2019-11-14 17:00:00	QQQ	ETF	201.47	201.48	201.35	201.4	24832.0
2019-11-14 18:00:00	QQQ	ETF	201.4	201.55	201.33	201.55	31393.0
2019-11-14 19:00:00	QQQ	ETF	201.51	202.21	201.43	202.18	89125.0
2019-11-14 04:00:00	IWM	ETF	158.06	158.06	158.06	158.06	500.0
2019-11-14 05:00:00	IWM	ETF	158.33	158.33	158.14	158.14	10637.0
2019-11-14 06:00:00	IWM	ETF	158.11	158.15	158.0	158.15	10700.0
2019-11-14 07:00:00	IWM	ETF	158.18	158.18	158.02	158.02	4400.0
2019-11-14 08:00:00	IWM	ETF	158.02	158.17	157.86	157.9101	67548.0
2019-11-14 09:00:00	IWM	ETF	158.0	158.4	157.7938	158.32	1472234.0
2019-11-14 10:00:00	IWM	ETF	158.35	158.77	158.27	158.47	1466843.0
2019-11-14 11:00:00	IWM	ETF	158.48	158.91	157.98	158.08	1395370.0
2019-11-14 12:00:00	IWM	ETF	158.08	158.4936	158.02	158.37	816347.0
2019-11-14 13:00:00	IWM	ETF	158.38	158.47	158.04	158.28	921918.0
2019-11-14 14:00:00	IWM	ETF	158.26	158.35	157.89	158.16	1618404.0
2019-11-14 15:00:00	IWM	ETF	158.16	158.335	158.09	158.14	2032964.0
2019-11-14 16:00:00	IWM	ETF	158.13	158.22	158.09	158.16	1544489.0
2019-11-14 17:00:00	IWM	ETF	158.15	158.15	158.11	158.15	11238.0
2019-11-14 18:00:00	IWM	ETF	158.15	158.28	158.1	158.28	64565.0
2019-11-14 19:00:00	IWM	ETF	158.29	158.83	158.19	158.83	16550.0
2019-11-14 06:00:00	DIA	ETF	277.94	277.94	277.94	277.94	100.0
2019-11-14 07:00:00	DIA	ETF	278.15	278.15	278.01	278.01	1322.0

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

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