PREVIEW / etf_1hour / 2019-11-25

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-11-25.parquet
  size:    339 KB
  rows:    11,197

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-25 04:00:00	SPY	ETF	312.0	312.03	311.86	311.98	16283.0
2019-11-25 05:00:00	SPY	ETF	312.01	312.06	311.93	312.03	21363.0
2019-11-25 06:00:00	SPY	ETF	311.99	312.01	311.85	311.9	6016.0
2019-11-25 07:00:00	SPY	ETF	311.9	312.03	311.8	311.87	128589.0
2019-11-25 08:00:00	SPY	ETF	311.83	312.17	311.76	312.09	271682.0
2019-11-25 09:00:00	SPY	ETF	312.0999	312.75	311.96	312.715	5895609.0
2019-11-25 10:00:00	SPY	ETF	312.705	313.15	312.68	312.885	8035798.0
2019-11-25 11:00:00	SPY	ETF	312.88	313.0	312.705	312.92	4685026.0
2019-11-25 12:00:00	SPY	ETF	312.92	312.97	312.78	312.905	2381052.0
2019-11-25 13:00:00	SPY	ETF	312.91	313.08	312.83	312.905	2383034.0
2019-11-25 14:00:00	SPY	ETF	312.9	313.04	312.84	312.94	3980191.0
2019-11-25 15:00:00	SPY	ETF	312.94	313.37	312.92	313.35	11497080.0
2019-11-25 16:00:00	SPY	ETF	313.35	313.38	313.12	313.2	7653361.0
2019-11-25 17:00:00	SPY	ETF	313.18	313.23	313.11	313.2	129473.0
2019-11-25 18:00:00	SPY	ETF	313.18	313.26	313.09	313.25	47876.0
2019-11-25 19:00:00	SPY	ETF	313.26	313.7	313.22	313.68	106481.0
2019-11-25 04:00:00	QQQ	ETF	202.56	202.64	202.52	202.63	34215.0
2019-11-25 05:00:00	QQQ	ETF	202.6	202.66	202.57	202.63	14500.0
2019-11-25 06:00:00	QQQ	ETF	202.6	202.63	202.49	202.54	10305.0
2019-11-25 07:00:00	QQQ	ETF	202.54	202.62	202.41	202.51	41947.0
2019-11-25 08:00:00	QQQ	ETF	202.4101	202.74	202.4	202.72	140719.0
2019-11-25 09:00:00	QQQ	ETF	202.73	203.6551	202.64	203.6	2164693.0
2019-11-25 10:00:00	QQQ	ETF	203.6	204.1	203.52	203.936	1971755.0
2019-11-25 11:00:00	QQQ	ETF	203.93	204.0	203.8	203.92	1063284.0
2019-11-25 12:00:00	QQQ	ETF	203.91	203.93	203.81	203.89	1558925.0
2019-11-25 13:00:00	QQQ	ETF	203.9	203.99	203.88	203.95	783536.0
2019-11-25 14:00:00	QQQ	ETF	203.94	204.0	203.83	203.93	799003.0
2019-11-25 15:00:00	QQQ	ETF	203.93	204.26	203.89	204.25	3278283.0
2019-11-25 16:00:00	QQQ	ETF	204.24	204.27	204.1	204.21	663465.0
2019-11-25 17:00:00	QQQ	ETF	204.24	204.24	204.12	204.15	254021.0
2019-11-25 18:00:00	QQQ	ETF	204.17	204.19	204.11	204.18	18828.0
2019-11-25 19:00:00	QQQ	ETF	204.19	204.6	204.16	204.6	34273.0
2019-11-25 04:00:00	IWM	ETF	158.85	158.93	158.85	158.88	5736.0
2019-11-25 05:00:00	IWM	ETF	158.91	158.93	158.9	158.9	8500.0
2019-11-25 06:00:00	IWM	ETF	158.88	158.9	158.86	158.87	3790.0
2019-11-25 07:00:00	IWM	ETF	158.89	158.92	158.76	158.77	10811.0
2019-11-25 08:00:00	IWM	ETF	158.79	158.97	158.72	158.97	14518.0
2019-11-25 09:00:00	IWM	ETF	158.98	160.09	158.89	160.075	2622221.0
2019-11-25 10:00:00	IWM	ETF	160.075	161.3	159.99	161.08	4377254.0
2019-11-25 11:00:00	IWM	ETF	161.09	161.47	161.0	161.39	2386852.0
2019-11-25 12:00:00	IWM	ETF	161.38	161.58	161.18	161.57	1835042.0
2019-11-25 13:00:00	IWM	ETF	161.57	161.67	161.4478	161.535	1426956.0
2019-11-25 14:00:00	IWM	ETF	161.53	161.71	161.45	161.68	1707438.0
2019-11-25 15:00:00	IWM	ETF	161.685	161.83	161.53	161.58	4304137.0
2019-11-25 16:00:00	IWM	ETF	161.58	161.68	161.3475	161.53	1811066.0
2019-11-25 17:00:00	IWM	ETF	161.52	161.74	161.52	161.69	324593.0
2019-11-25 18:00:00	IWM	ETF	161.65	161.65	161.52	161.62	14150.0
2019-11-25 19:00:00	IWM	ETF	161.61	161.96	161.61	161.96	18466.0
2019-11-25 04:00:00	DIA	ETF	279.68	279.68	279.68	279.68	100.0
2019-11-25 05:00:00	DIA	ETF	279.8	279.8	279.77	279.78	700.0

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

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