PREVIEW / etf_1hour / 2020-12-15

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-12-15.parquet
  size:    400 KB
  rows:    13,583

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-15 04:00:00	SPY	ETF	366.51	367.15	366.51	366.97	26727.0
2020-12-15 05:00:00	SPY	ETF	366.97	366.97	366.7	366.75	86141.0
2020-12-15 06:00:00	SPY	ETF	366.82	366.96	366.52	366.67	51271.0
2020-12-15 07:00:00	SPY	ETF	366.62	367.46	366.61	367.04	167856.0
2020-12-15 08:00:00	SPY	ETF	367.0233	367.46	364.75	367.29	192609.0
2020-12-15 09:00:00	SPY	ETF	367.32	367.775	366.69	366.86	4704824.0
2020-12-15 10:00:00	SPY	ETF	366.85	367.17	366.0701	366.721	5776562.0
2020-12-15 11:00:00	SPY	ETF	366.74	367.25	365.92	367.1597	8378956.0
2020-12-15 12:00:00	SPY	ETF	367.15	368.54	367.08	368.49	8905465.0
2020-12-15 13:00:00	SPY	ETF	368.5	369.26	368.37	369.175	5929941.0
2020-12-15 14:00:00	SPY	ETF	369.16	369.56	368.97	369.21	5361526.0
2020-12-15 15:00:00	SPY	ETF	369.22	369.5798	368.6	369.57	12120724.0
2020-12-15 16:00:00	SPY	ETF	369.55	369.6	368.44	369.33	10178217.0
2020-12-15 17:00:00	SPY	ETF	369.43	369.79	369.42	369.72	485540.0
2020-12-15 18:00:00	SPY	ETF	369.7	369.7	369.21	369.32	199827.0
2020-12-15 19:00:00	SPY	ETF	369.4	369.45	368.8	369.08	112394.0
2020-12-15 04:00:00	QQQ	ETF	305.0	305.47	305.0	305.26	20158.0
2020-12-15 05:00:00	QQQ	ETF	305.27	305.27	305.02	305.08	5325.0
2020-12-15 06:00:00	QQQ	ETF	305.18	305.18	304.9	305.02	19059.0
2020-12-15 07:00:00	QQQ	ETF	304.99	305.82	304.99	305.76	104685.0
2020-12-15 08:00:00	QQQ	ETF	305.78	306.28	303.97	306.24	168951.0
2020-12-15 09:00:00	QQQ	ETF	306.25	306.83	305.81	306.38	2893962.0
2020-12-15 10:00:00	QQQ	ETF	306.39	306.68	305.36	305.49	2768757.0
2020-12-15 11:00:00	QQQ	ETF	305.48	305.48	304.11	304.92	3433408.0
2020-12-15 12:00:00	QQQ	ETF	304.91	305.78	304.86	305.7274	1779200.0
2020-12-15 13:00:00	QQQ	ETF	305.7	306.29	305.61	306.21	1304060.0
2020-12-15 14:00:00	QQQ	ETF	306.21	306.78	305.91	306.756	2430503.0
2020-12-15 15:00:00	QQQ	ETF	306.77	307.28	306.61	307.25	3857519.0
2020-12-15 16:00:00	QQQ	ETF	307.24	307.5	307.11	307.26	1007848.0
2020-12-15 17:00:00	QQQ	ETF	307.45	307.45	307.21	307.38	224617.0
2020-12-15 18:00:00	QQQ	ETF	307.39	307.5	307.06	307.15	48918.0
2020-12-15 19:00:00	QQQ	ETF	307.17	307.27	306.91	307.12	53404.0
2020-12-15 04:00:00	IWM	ETF	191.12	191.38	191.0	191.2	129122.0
2020-12-15 05:00:00	IWM	ETF	191.15	191.17	191.04	191.04	12600.0
2020-12-15 06:00:00	IWM	ETF	191.16	191.24	190.9	190.9	12825.0
2020-12-15 07:00:00	IWM	ETF	191.05	191.53	191.05	191.14	39183.0
2020-12-15 08:00:00	IWM	ETF	191.27	191.6796	190.52	191.57	37112.0
2020-12-15 09:00:00	IWM	ETF	191.6	191.86	190.73	191.13	2133515.0
2020-12-15 10:00:00	IWM	ETF	191.145	192.28	191.0	192.12	1923932.0
2020-12-15 11:00:00	IWM	ETF	192.13	192.445	191.36	192.36	1509946.0
2020-12-15 12:00:00	IWM	ETF	192.355	193.38	192.315	193.3384	1278482.0
2020-12-15 13:00:00	IWM	ETF	193.335	193.86	193.09	193.755	2481675.0
2020-12-15 14:00:00	IWM	ETF	193.75	194.27	193.68	194.09	2233993.0
2020-12-15 15:00:00	IWM	ETF	194.09	194.69	193.9	194.65	4592835.0
2020-12-15 16:00:00	IWM	ETF	194.65	194.92	189.8765	194.59	1880325.0
2020-12-15 17:00:00	IWM	ETF	194.57	194.72	194.45	194.72	16544.0
2020-12-15 18:00:00	IWM	ETF	194.65	194.77	194.57	194.72	37039.0
2020-12-15 19:00:00	IWM	ETF	194.74	194.75	194.22	194.36	53526.0
2020-12-15 04:00:00	DIA	ETF	300.95	301.01	300.8	300.92	1800.0
2020-12-15 05:00:00	DIA	ETF	300.94	300.94	300.77	300.77	485.0

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

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