PREVIEW / etf_1hour / 2019-11-12

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-11-12.parquet
  size:    336 KB
  rows:    11,064

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-12 04:00:00	SPY	ETF	308.67	308.75	308.4	308.53	5796.0
2019-11-12 05:00:00	SPY	ETF	308.7	308.92	308.61	308.82	12810.0
2019-11-12 06:00:00	SPY	ETF	308.87	308.97	308.65	308.7	12977.0
2019-11-12 07:00:00	SPY	ETF	308.71	308.78	308.65	308.7	62298.0
2019-11-12 08:00:00	SPY	ETF	308.76	309.05	308.0	308.6	294196.0
2019-11-12 09:00:00	SPY	ETF	308.62	309.465	308.55	309.45	3639988.0
2019-11-12 10:00:00	SPY	ETF	309.46	309.99	309.2801	309.7516	7639398.0
2019-11-12 11:00:00	SPY	ETF	309.755	309.87	309.32	309.3803	5636598.0
2019-11-12 12:00:00	SPY	ETF	309.39	309.53	308.96	309.33	4888792.0
2019-11-12 13:00:00	SPY	ETF	309.32	309.6	309.23	309.505	3774063.0
2019-11-12 14:00:00	SPY	ETF	309.5	309.51	308.15	308.395	5672602.0
2019-11-12 15:00:00	SPY	ETF	308.3958	309.04	308.36	308.94	9751384.0
2019-11-12 16:00:00	SPY	ETF	308.95	309.02	308.76	308.85	1922657.0
2019-11-12 17:00:00	SPY	ETF	308.85	309.03	308.65	308.81	1217325.0
2019-11-12 18:00:00	SPY	ETF	308.82	308.95	308.58	308.66	207634.0
2019-11-12 19:00:00	SPY	ETF	308.65	308.65	308.32	308.4	111662.0
2019-11-12 04:00:00	QQQ	ETF	201.09	201.19	200.93	200.98	2022.0
2019-11-12 05:00:00	QQQ	ETF	201.1	201.37	201.1	201.32	22900.0
2019-11-12 06:00:00	QQQ	ETF	201.38	201.38	201.14	201.16	11829.0
2019-11-12 07:00:00	QQQ	ETF	201.19	201.23	201.11	201.21	34338.0
2019-11-12 08:00:00	QQQ	ETF	201.2199	201.5	200.97	201.05	65238.0
2019-11-12 09:00:00	QQQ	ETF	201.1	201.57	201.05	201.5401	1836145.0
2019-11-12 10:00:00	QQQ	ETF	201.55	202.085	201.44	201.94	2712224.0
2019-11-12 11:00:00	QQQ	ETF	201.96	202.21	201.79	201.85	1180479.0
2019-11-12 12:00:00	QQQ	ETF	201.855	202.06	201.63	201.87	1138323.0
2019-11-12 13:00:00	QQQ	ETF	201.89	202.01	201.8	201.91	939402.0
2019-11-12 14:00:00	QQQ	ETF	201.9	201.9	200.82	201.04	1901796.0
2019-11-12 15:00:00	QQQ	ETF	201.04	201.59	201.01	201.51	2681708.0
2019-11-12 16:00:00	QQQ	ETF	201.53	201.64	201.44	201.49	305909.0
2019-11-12 17:00:00	QQQ	ETF	201.46	201.56	201.38	201.4	12551.0
2019-11-12 18:00:00	QQQ	ETF	201.48	201.54	201.29	201.36	39790.0
2019-11-12 19:00:00	QQQ	ETF	201.32	201.32	201.06	201.11	19135.0
2019-11-12 04:00:00	IWM	ETF	159.0	159.0	158.96	158.96	800.0
2019-11-12 06:00:00	IWM	ETF	159.14	159.15	159.06	159.06	5080.0
2019-11-12 07:00:00	IWM	ETF	158.96	159.11	158.96	159.11	16100.0
2019-11-12 08:00:00	IWM	ETF	159.07	159.25	158.92	158.96	5292.0
2019-11-12 09:00:00	IWM	ETF	159.0	159.23	158.52	159.17	1205330.0
2019-11-12 10:00:00	IWM	ETF	159.17	159.88	159.17	159.43	1544266.0
2019-11-12 11:00:00	IWM	ETF	159.43	159.59	158.8532	158.92	939369.0
2019-11-12 12:00:00	IWM	ETF	158.9381	159.205	158.75	159.08	1133934.0
2019-11-12 13:00:00	IWM	ETF	159.09	159.4	159.01	159.32	984378.0
2019-11-12 14:00:00	IWM	ETF	159.32	159.32	158.485	158.64	1981070.0
2019-11-12 15:00:00	IWM	ETF	158.63	158.845	158.61	158.78	2041688.0
2019-11-12 16:00:00	IWM	ETF	158.83	158.84	158.64	158.67	1090862.0
2019-11-12 17:00:00	IWM	ETF	158.66	158.71	158.65	158.7	18722.0
2019-11-12 18:00:00	IWM	ETF	158.75	158.75	158.57	158.57	22200.0
2019-11-12 19:00:00	IWM	ETF	158.58	158.58	158.43	158.46	8061.0
2019-11-12 07:00:00	DIA	ETF	277.38	277.52	277.38	277.52	1000.0
2019-11-12 08:00:00	DIA	ETF	277.38	277.46	277.28	277.34	17631.0
2019-11-12 09:00:00	DIA	ETF	277.4	277.7022	277.07	277.67	282129.0

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

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