PREVIEW / etf_1hour / 2020-12-07

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-12-07.parquet
  size:    399 KB
  rows:    13,896

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-07 04:00:00	SPY	ETF	367.56	368.19	367.36	368.12	45892.0
2020-12-07 05:00:00	SPY	ETF	368.06	368.6	368.06	368.15	20353.0
2020-12-07 06:00:00	SPY	ETF	368.04	368.72	368.04	368.65	49496.0
2020-12-07 07:00:00	SPY	ETF	368.66	368.72	368.24	368.61	230749.0
2020-12-07 08:00:00	SPY	ETF	368.5201	369.1	367.54	368.94	299460.0
2020-12-07 09:00:00	SPY	ETF	368.93	369.365	368.84	369.365	4044341.0
2020-12-07 10:00:00	SPY	ETF	369.37	369.59	369.0501	369.34	4521545.0
2020-12-07 11:00:00	SPY	ETF	369.33	369.62	369.01	369.42	4442478.0
2020-12-07 12:00:00	SPY	ETF	369.41	369.48	368.86	368.8699	4029551.0
2020-12-07 13:00:00	SPY	ETF	368.86	368.9199	368.0575	368.42	5199309.0
2020-12-07 14:00:00	SPY	ETF	368.42	368.75	367.89	368.3901	5570791.0
2020-12-07 15:00:00	SPY	ETF	368.4	369.205	367.72	369.12	12878818.0
2020-12-07 16:00:00	SPY	ETF	369.14	369.26	367.97	368.14	6087320.0
2020-12-07 17:00:00	SPY	ETF	368.14	369.07	368.06	368.25	355046.0
2020-12-07 18:00:00	SPY	ETF	368.25	368.43	368.2	368.23	104562.0
2020-12-07 19:00:00	SPY	ETF	368.21	368.31	367.8	368.28	149180.0
2020-12-07 04:00:00	QQQ	ETF	304.59	305.12	304.44	304.84	27395.0
2020-12-07 05:00:00	QQQ	ETF	304.89	305.41	304.88	305.27	18943.0
2020-12-07 06:00:00	QQQ	ETF	305.1	305.45	305.1	305.38	15349.0
2020-12-07 07:00:00	QQQ	ETF	305.39	305.52	305.16	305.41	59525.0
2020-12-07 08:00:00	QQQ	ETF	305.19	305.72	305.18	305.72	111999.0
2020-12-07 09:00:00	QQQ	ETF	305.692	307.03	305.52	306.931	2960087.0
2020-12-07 10:00:00	QQQ	ETF	306.9882	307.339	306.75	307.03	1786844.0
2020-12-07 11:00:00	QQQ	ETF	307.03	307.63	306.89	307.13	1695990.0
2020-12-07 12:00:00	QQQ	ETF	307.1291	307.1291	306.63	306.6602	934890.0
2020-12-07 13:00:00	QQQ	ETF	306.66	306.705	306.04	306.59	1259538.0
2020-12-07 14:00:00	QQQ	ETF	306.58	307.06	306.23	306.8816	1361833.0
2020-12-07 15:00:00	QQQ	ETF	306.9	307.32	306.15	307.26	3051762.0
2020-12-07 16:00:00	QQQ	ETF	307.27	307.37	306.46	306.64	4017486.0
2020-12-07 17:00:00	QQQ	ETF	306.67	306.78	306.56	306.76	14166.0
2020-12-07 18:00:00	QQQ	ETF	306.77	307.05	306.68	306.7	40764.0
2020-12-07 19:00:00	QQQ	ETF	306.65	306.77	306.36	306.68	79979.0
2020-12-07 04:00:00	IWM	ETF	186.89	187.33	186.74	187.33	17500.0
2020-12-07 05:00:00	IWM	ETF	187.43	187.76	187.4	187.5	14623.0
2020-12-07 06:00:00	IWM	ETF	187.46	187.96	187.42	187.88	10940.0
2020-12-07 07:00:00	IWM	ETF	187.94	187.96	187.56	187.81	47643.0
2020-12-07 08:00:00	IWM	ETF	187.7799	187.9	187.23	187.9	74248.0
2020-12-07 09:00:00	IWM	ETF	187.81	188.485	187.44	187.8298	1520306.0
2020-12-07 10:00:00	IWM	ETF	187.815	188.73	187.57	188.58	1227557.0
2020-12-07 11:00:00	IWM	ETF	188.57	188.9	188.36	188.78	1162673.0
2020-12-07 12:00:00	IWM	ETF	188.77	188.9528	188.41	188.51	1220779.0
2020-12-07 13:00:00	IWM	ETF	188.5	188.5	187.85	188.04	1236598.0
2020-12-07 14:00:00	IWM	ETF	188.04	188.36	187.67	188.18	1086381.0
2020-12-07 15:00:00	IWM	ETF	188.19	188.54	187.79	188.33	3714897.0
2020-12-07 16:00:00	IWM	ETF	188.34	188.42	187.5	187.62	752722.0
2020-12-07 17:00:00	IWM	ETF	187.62	187.92	187.25	187.8	9453.0
2020-12-07 18:00:00	IWM	ETF	187.75	188.38	187.64	187.73	17773.0
2020-12-07 19:00:00	IWM	ETF	187.67	187.8	187.5	187.62	18491.0
2020-12-07 04:00:00	DIA	ETF	300.69	301.32	300.68	301.24	3151.0
2020-12-07 05:00:00	DIA	ETF	301.45	301.45	301.17	301.17	600.0

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

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