PREVIEW / etf_1hour / 2019-11-19

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-11-19.parquet
  size:    344 KB
  rows:    11,396

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-19 04:00:00	SPY	ETF	312.56	313.12	312.56	313.09	13908.0
2019-11-19 05:00:00	SPY	ETF	313.08	313.12	313.0	313.03	10741.0
2019-11-19 06:00:00	SPY	ETF	312.99	313.13	312.78	312.92	29977.0
2019-11-19 07:00:00	SPY	ETF	312.9	312.91	312.75	312.9	103246.0
2019-11-19 08:00:00	SPY	ETF	312.92	312.92	312.54	312.67	174700.0
2019-11-19 09:00:00	SPY	ETF	312.67	312.87	311.97	312.04	3816437.0
2019-11-19 10:00:00	SPY	ETF	312.035	312.12	311.22	311.36	6662427.0
2019-11-19 11:00:00	SPY	ETF	311.36	312.47	311.33	312.14	17053683.0
2019-11-19 12:00:00	SPY	ETF	312.13	312.2	311.6	311.91	5915082.0
2019-11-19 13:00:00	SPY	ETF	311.91	312.13	311.7	311.93	7122486.0
2019-11-19 14:00:00	SPY	ETF	311.94	312.4	311.935	312.04	6334382.0
2019-11-19 15:00:00	SPY	ETF	312.04	312.34	311.81	311.89	11841965.0
2019-11-19 16:00:00	SPY	ETF	311.88	312.0694	311.62	311.62	7336063.0
2019-11-19 17:00:00	SPY	ETF	311.65	312.68	311.51	311.55	274408.0
2019-11-19 18:00:00	SPY	ETF	311.55	311.58	311.01	311.14	180374.0
2019-11-19 19:00:00	SPY	ETF	311.18	311.56	311.08	311.38	79747.0
2019-11-19 04:00:00	QQQ	ETF	203.61	203.98	203.6	203.97	22212.0
2019-11-19 05:00:00	QQQ	ETF	203.96	203.99	203.9	203.95	16115.0
2019-11-19 06:00:00	QQQ	ETF	203.92	204.15	203.89	203.93	20865.0
2019-11-19 07:00:00	QQQ	ETF	203.94	203.97	203.84	203.97	40203.0
2019-11-19 08:00:00	QQQ	ETF	203.89	204.0	203.42	203.81	58951.0
2019-11-19 09:00:00	QQQ	ETF	203.84	203.98	203.2199	203.28	1831228.0
2019-11-19 10:00:00	QQQ	ETF	203.27	203.47	202.59	202.71	2267993.0
2019-11-19 11:00:00	QQQ	ETF	202.71	203.66	202.69	203.58	2154715.0
2019-11-19 12:00:00	QQQ	ETF	203.57	203.65	203.19	203.42	1535374.0
2019-11-19 13:00:00	QQQ	ETF	203.42	203.53	203.2526	203.42	786040.0
2019-11-19 14:00:00	QQQ	ETF	203.43	203.8	203.43	203.51	1392319.0
2019-11-19 15:00:00	QQQ	ETF	203.5025	203.64	203.29	203.36	2057769.0
2019-11-19 16:00:00	QQQ	ETF	203.37	203.38	203.13	203.13	894898.0
2019-11-19 17:00:00	QQQ	ETF	203.19	203.2	203.09	203.1	21025.0
2019-11-19 18:00:00	QQQ	ETF	203.1	203.11	202.7	202.76	76641.0
2019-11-19 19:00:00	QQQ	ETF	202.77	203.06	202.7	202.87	37189.0
2019-11-19 04:00:00	IWM	ETF	158.98	159.15	158.91	159.15	5700.0
2019-11-19 05:00:00	IWM	ETF	159.15	159.22	159.13	159.15	7774.0
2019-11-19 06:00:00	IWM	ETF	159.11	159.15	159.02	159.1	9128.0
2019-11-19 07:00:00	IWM	ETF	159.08	159.08	159.02	159.08	28702.0
2019-11-19 08:00:00	IWM	ETF	159.08	159.17	158.97	159.05	43052.0
2019-11-19 09:00:00	IWM	ETF	159.05	159.19	158.6	158.6263	1452340.0
2019-11-19 10:00:00	IWM	ETF	158.62	159.07	158.31	158.575	1877223.0
2019-11-19 11:00:00	IWM	ETF	158.585	159.42	158.5468	159.31	1331037.0
2019-11-19 12:00:00	IWM	ETF	159.31	159.39	159.11	159.375	927216.0
2019-11-19 13:00:00	IWM	ETF	159.36	159.59	159.26	159.49	1464197.0
2019-11-19 14:00:00	IWM	ETF	159.49	159.7	159.415	159.505	1539951.0
2019-11-19 15:00:00	IWM	ETF	159.5	159.58	159.06	159.1	2251919.0
2019-11-19 16:00:00	IWM	ETF	159.11	159.18	158.94	158.97	1845748.0
2019-11-19 17:00:00	IWM	ETF	159.08	159.08	158.93	158.98	1312.0
2019-11-19 18:00:00	IWM	ETF	158.98	159.11	158.66	158.66	57424.0
2019-11-19 19:00:00	IWM	ETF	158.7	158.97	158.7	158.86	4902.0
2019-11-19 04:00:00	DIA	ETF	280.95	281.43	280.95	281.43	2500.0
2019-11-19 06:00:00	DIA	ETF	281.01	281.01	280.74	280.87	3085.0

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

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