PREVIEW / etf_1hour / 2020-12-04

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-12-04.parquet
  size:    397 KB
  rows:    13,466

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
2020-12-04 04:00:00	SPY	ETF	367.5	367.96	367.48	367.59	11077.0
2020-12-04 05:00:00	SPY	ETF	367.5	367.7	367.4	367.68	17420.0
2020-12-04 06:00:00	SPY	ETF	367.75	367.82	367.51	367.59	142716.0
2020-12-04 07:00:00	SPY	ETF	367.54	367.87	367.48	367.49	109365.0
2020-12-04 08:00:00	SPY	ETF	367.5	367.95	366.69	367.37	777509.0
2020-12-04 09:00:00	SPY	ETF	367.38	368.42	367.18	368.2356	3771165.0
2020-12-04 10:00:00	SPY	ETF	368.225	369.27	368.095	369.05	7246751.0
2020-12-04 11:00:00	SPY	ETF	369.04	369.2584	368.72	369.05	3964568.0
2020-12-04 12:00:00	SPY	ETF	369.05	369.2	368.875	369.0	3742494.0
2020-12-04 13:00:00	SPY	ETF	369.005	369.1801	368.71	368.74	3136252.0
2020-12-04 14:00:00	SPY	ETF	368.74	369.28	368.55	369.1999	4558835.0
2020-12-04 15:00:00	SPY	ETF	369.2	369.85	368.67	369.83	13766958.0
2020-12-04 16:00:00	SPY	ETF	369.82	369.94	368.94	369.01	7618573.0
2020-12-04 17:00:00	SPY	ETF	369.0	369.85	369.0	369.15	413998.0
2020-12-04 18:00:00	SPY	ETF	369.15	369.34	369.11	369.19	38254.0
2020-12-04 19:00:00	SPY	ETF	369.21	369.25	369.14	369.22	22622.0
2020-12-04 04:00:00	QQQ	ETF	305.12	305.2	305.0	305.01	23073.0
2020-12-04 05:00:00	QQQ	ETF	304.93	305.11	304.88	305.04	23981.0
2020-12-04 06:00:00	QQQ	ETF	305.2	305.26	305.08	305.13	34236.0
2020-12-04 07:00:00	QQQ	ETF	305.13	305.15	304.61	304.74	203486.0
2020-12-04 08:00:00	QQQ	ETF	304.74	305.46	304.25	304.34	400030.0
2020-12-04 09:00:00	QQQ	ETF	304.36	305.09	303.63	305.02	2455481.0
2020-12-04 10:00:00	QQQ	ETF	305.02	305.4	304.21	304.85	2619641.0
2020-12-04 11:00:00	QQQ	ETF	304.85	305.61	304.46	305.17	1814656.0
2020-12-04 12:00:00	QQQ	ETF	305.19	305.6	305.01	305.58	1305685.0
2020-12-04 13:00:00	QQQ	ETF	305.58	305.67	304.98	305.05	1078269.0
2020-12-04 14:00:00	QQQ	ETF	305.04	305.35	304.71	305.32	1442573.0
2020-12-04 15:00:00	QQQ	ETF	305.325	305.63	304.83	305.6	3153086.0
2020-12-04 16:00:00	QQQ	ETF	305.6	305.73	305.06	305.1	602964.0
2020-12-04 17:00:00	QQQ	ETF	305.1	305.1299	304.94	305.09	10967.0
2020-12-04 18:00:00	QQQ	ETF	305.09	305.33	305.01	305.21	18048.0
2020-12-04 19:00:00	QQQ	ETF	305.22	305.38	305.06	305.06	9728.0
2020-12-04 04:00:00	IWM	ETF	184.68	185.08	184.55	184.8	12565.0
2020-12-04 05:00:00	IWM	ETF	184.76	184.8	184.63	184.72	6300.0
2020-12-04 06:00:00	IWM	ETF	184.76	184.94	184.71	184.76	28674.0
2020-12-04 07:00:00	IWM	ETF	184.76	185.39	184.76	185.07	129323.0
2020-12-04 08:00:00	IWM	ETF	185.05	185.3504	184.3	184.92	178368.0
2020-12-04 09:00:00	IWM	ETF	184.96	185.98	184.82	185.83	2556520.0
2020-12-04 10:00:00	IWM	ETF	185.83	186.93	185.41	186.85	3308807.0
2020-12-04 11:00:00	IWM	ETF	186.8499	187.46	186.57	187.17	2584112.0
2020-12-04 12:00:00	IWM	ETF	187.165	187.54	186.905	187.249	1273181.0
2020-12-04 13:00:00	IWM	ETF	187.245	187.645	187.17	187.315	1293855.0
2020-12-04 14:00:00	IWM	ETF	187.31	187.75	187.03	187.75	1593604.0
2020-12-04 15:00:00	IWM	ETF	187.75	188.45	187.67	188.16	5201935.0
2020-12-04 16:00:00	IWM	ETF	188.2	188.47	188.05	188.1	1472345.0
2020-12-04 17:00:00	IWM	ETF	188.06	188.22	188.06	188.19	9770.0
2020-12-04 18:00:00	IWM	ETF	188.18	188.25	188.02	188.25	8426.0
2020-12-04 19:00:00	IWM	ETF	188.14	188.27	188.12	188.12	1466.0
2020-12-04 04:00:00	DIA	ETF	300.67	301.44	300.67	301.12	400.0
2020-12-04 05:00:00	DIA	ETF	301.05	301.11	301.05	301.11	1200.0

> showing 50 of 13,466 rows — these rows as CSV

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