PREVIEW / etf_1hour / 2019-11-08

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-11-08.parquet
  size:    338 KB
  rows:    11,073

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-08 04:00:00	SPY	ETF	308.04	308.04	307.9	308.03	3944.0
2019-11-08 05:00:00	SPY	ETF	308.06	308.21	308.03	308.18	5740.0
2019-11-08 06:00:00	SPY	ETF	308.17	308.33	308.14	308.26	16348.0
2019-11-08 07:00:00	SPY	ETF	308.23	308.58	307.94	308.05	117701.0
2019-11-08 08:00:00	SPY	ETF	308.05	308.46	307.56	308.08	162304.0
2019-11-08 09:00:00	SPY	ETF	308.1	308.29	307.18	307.32	5348196.0
2019-11-08 10:00:00	SPY	ETF	307.33	308.18	307.03	308.11	6386167.0
2019-11-08 11:00:00	SPY	ETF	308.11	308.29	307.76	308.26	4219698.0
2019-11-08 12:00:00	SPY	ETF	308.26	308.44	308.2	308.31	2441726.0
2019-11-08 13:00:00	SPY	ETF	308.31	308.35	308.09	308.1	6005923.0
2019-11-08 14:00:00	SPY	ETF	308.1	308.24	308.02	308.225	2378820.0
2019-11-08 15:00:00	SPY	ETF	308.22	308.97	308.21	308.97	12432233.0
2019-11-08 16:00:00	SPY	ETF	308.98	309.06	308.79	308.94	8229110.0
2019-11-08 17:00:00	SPY	ETF	308.85	308.98	308.85	308.91	153943.0
2019-11-08 18:00:00	SPY	ETF	308.93	308.96	308.91	308.94	6328.0
2019-11-08 19:00:00	SPY	ETF	308.94	309.09	308.94	309.09	24080.0
2019-11-08 04:00:00	QQQ	ETF	200.15	200.18	199.99	200.18	6368.0
2019-11-08 05:00:00	QQQ	ETF	200.19	200.32	200.19	200.26	10196.0
2019-11-08 06:00:00	QQQ	ETF	200.34	200.39	200.25	200.3	20558.0
2019-11-08 07:00:00	QQQ	ETF	200.3	200.63	200.05	200.14	52199.0
2019-11-08 08:00:00	QQQ	ETF	200.27	200.55	199.7	200.17	74349.0
2019-11-08 09:00:00	QQQ	ETF	200.14	200.58	199.85	199.92	2217978.0
2019-11-08 10:00:00	QQQ	ETF	199.93	200.7	199.54	200.61	2660391.0
2019-11-08 11:00:00	QQQ	ETF	200.61	200.8467	200.3439	200.68	1292394.0
2019-11-08 12:00:00	QQQ	ETF	200.68	200.91	200.6393	200.72	848877.0
2019-11-08 13:00:00	QQQ	ETF	200.72	200.75	200.47	200.48	638131.0
2019-11-08 14:00:00	QQQ	ETF	200.485	200.66	200.45	200.595	642384.0
2019-11-08 15:00:00	QQQ	ETF	200.59	201.25	200.57	201.25	3007533.0
2019-11-08 16:00:00	QQQ	ETF	201.25	201.32	201.12	201.24	801309.0
2019-11-08 17:00:00	QQQ	ETF	201.23	201.23	201.08	201.15	97116.0
2019-11-08 18:00:00	QQQ	ETF	201.12	201.16	201.11	201.14	7413.0
2019-11-08 19:00:00	QQQ	ETF	201.15	201.18	201.15	201.16	7913.0
2019-11-08 04:00:00	IWM	ETF	158.48	158.56	158.42	158.48	5100.0
2019-11-08 05:00:00	IWM	ETF	158.52	158.52	158.52	158.52	300.0
2019-11-08 06:00:00	IWM	ETF	158.55	158.65	158.53	158.65	14093.0
2019-11-08 07:00:00	IWM	ETF	158.63	158.72	158.49	158.49	14260.0
2019-11-08 08:00:00	IWM	ETF	158.62	158.66	158.42	158.55	38712.0
2019-11-08 09:00:00	IWM	ETF	158.58	158.96	157.95	158.38	1830622.0
2019-11-08 10:00:00	IWM	ETF	158.38	159.27	158.01	158.94	1864709.0
2019-11-08 11:00:00	IWM	ETF	158.95	159.13	158.62	159.0	1051601.0
2019-11-08 12:00:00	IWM	ETF	158.995	159.055	158.78	158.81	640013.0
2019-11-08 13:00:00	IWM	ETF	158.81	158.96	158.7	158.81	638210.0
2019-11-08 14:00:00	IWM	ETF	158.81	158.93	158.765	158.93	582107.0
2019-11-08 15:00:00	IWM	ETF	158.93	159.165	158.845	159.09	2594407.0
2019-11-08 16:00:00	IWM	ETF	159.08	159.19	158.5952	159.17	697451.0
2019-11-08 17:00:00	IWM	ETF	159.19	159.19	159.08	159.11	219413.0
2019-11-08 18:00:00	IWM	ETF	159.11	159.11	159.08	159.08	10500.0
2019-11-08 19:00:00	IWM	ETF	159.08	159.15	159.08	159.12	7700.0
2019-11-08 07:00:00	DIA	ETF	277.53	277.53	277.35	277.35	900.0
2019-11-08 08:00:00	DIA	ETF	277.3001	277.5	277.2	277.2	7700.0

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

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