PREVIEW / etf_1hour / 2019-11-18

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-11-18.parquet
  size:    344 KB
  rows:    11,392

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-18 04:00:00	SPY	ETF	312.13	312.29	312.13	312.24	9048.0
2019-11-18 05:00:00	SPY	ETF	312.32	312.37	312.16	312.16	9112.0
2019-11-18 06:00:00	SPY	ETF	312.14	312.33	312.09	312.3	25752.0
2019-11-18 07:00:00	SPY	ETF	312.3	312.47	312.23	312.45	140081.0
2019-11-18 08:00:00	SPY	ETF	312.4	312.58	311.3	311.63	709418.0
2019-11-18 09:00:00	SPY	ETF	311.63	311.71	311.085	311.45	3956323.0
2019-11-18 10:00:00	SPY	ETF	311.45	311.8	311.03	311.6223	11651498.0
2019-11-18 11:00:00	SPY	ETF	311.625	312.0	311.48	311.94	5702463.0
2019-11-18 12:00:00	SPY	ETF	311.94	311.98	311.68	311.895	2438570.0
2019-11-18 13:00:00	SPY	ETF	311.9	312.21	311.83	312.13	3430939.0
2019-11-18 14:00:00	SPY	ETF	312.13	312.28	311.95	312.14	3204652.0
2019-11-18 15:00:00	SPY	ETF	312.145	312.19	311.67	311.99	11078091.0
2019-11-18 16:00:00	SPY	ETF	312.0	312.18	311.78	312.06	4077200.0
2019-11-18 17:00:00	SPY	ETF	312.06	312.1	312.0	312.06	981700.0
2019-11-18 18:00:00	SPY	ETF	312.06	312.06	311.88	311.89	72160.0
2019-11-18 19:00:00	SPY	ETF	311.94	311.94	311.55	311.71	54737.0
2019-11-18 04:00:00	QQQ	ETF	203.11	203.24	203.08	203.18	14645.0
2019-11-18 05:00:00	QQQ	ETF	203.27	203.3	203.11	203.12	34600.0
2019-11-18 06:00:00	QQQ	ETF	203.11	203.3	203.1	203.29	27675.0
2019-11-18 07:00:00	QQQ	ETF	203.23	203.38	203.16	203.34	100785.0
2019-11-18 08:00:00	QQQ	ETF	203.26	203.37	202.47	202.69	561000.0
2019-11-18 09:00:00	QQQ	ETF	202.65	202.72	201.77	202.1836	2109974.0
2019-11-18 10:00:00	QQQ	ETF	202.19	202.61	201.9	202.47	2155963.0
2019-11-18 11:00:00	QQQ	ETF	202.47	202.865	202.28	202.81	2155147.0
2019-11-18 12:00:00	QQQ	ETF	202.81	202.84	202.5285	202.7	718950.0
2019-11-18 13:00:00	QQQ	ETF	202.7	203.14	202.63	203.045	1011277.0
2019-11-18 14:00:00	QQQ	ETF	203.045	203.39	202.931	203.2596	1010502.0
2019-11-18 15:00:00	QQQ	ETF	203.25	203.28	202.815	203.08	2233487.0
2019-11-18 16:00:00	QQQ	ETF	203.07	203.15	202.7031	203.11	423873.0
2019-11-18 17:00:00	QQQ	ETF	203.19	203.19	203.04	203.12	1570375.0
2019-11-18 18:00:00	QQQ	ETF	203.1	203.11	202.95	202.98	22514.0
2019-11-18 19:00:00	QQQ	ETF	203.0	203.0	202.75	202.82	30607.0
2019-11-18 04:00:00	IWM	ETF	159.05	159.05	158.98	159.0	3300.0
2019-11-18 05:00:00	IWM	ETF	159.04	159.04	158.99	158.99	9223.0
2019-11-18 06:00:00	IWM	ETF	158.93	159.04	158.93	159.04	6100.0
2019-11-18 07:00:00	IWM	ETF	159.03	159.2	159.01	159.2	19240.0
2019-11-18 08:00:00	IWM	ETF	159.11	159.17	158.39	158.7	135115.0
2019-11-18 09:00:00	IWM	ETF	158.76	158.76	158.06	158.435	1151590.0
2019-11-18 10:00:00	IWM	ETF	158.43	158.68	158.01	158.22	1942884.0
2019-11-18 11:00:00	IWM	ETF	158.22	158.56	157.94	158.56	1514445.0
2019-11-18 12:00:00	IWM	ETF	158.56	158.66	158.43	158.52	568454.0
2019-11-18 13:00:00	IWM	ETF	158.53	158.57	158.44	158.5	524954.0
2019-11-18 14:00:00	IWM	ETF	158.5	158.58	158.38	158.5101	640272.0
2019-11-18 15:00:00	IWM	ETF	158.515	158.58	158.36	158.47	2214565.0
2019-11-18 16:00:00	IWM	ETF	158.47	158.61	158.4	158.44	514565.0
2019-11-18 17:00:00	IWM	ETF	158.43	158.49	158.43	158.49	5850.0
2019-11-18 18:00:00	IWM	ETF	158.47	158.52	158.35	158.35	19211.0
2019-11-18 19:00:00	IWM	ETF	158.36	158.36	158.17	158.24	14266.0
2019-11-18 06:00:00	DIA	ETF	280.33	280.38	280.33	280.38	1600.0
2019-11-18 07:00:00	DIA	ETF	280.47	280.5	280.47	280.5	311.0

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

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