PREVIEW / etf_1hour / 2022-03-31

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-03-31.parquet
  size:    453 KB
  rows:    16,319

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
2022-03-31 04:00:00	SPY	ETF	459.6	459.65	459.01	459.38	108388.0
2022-03-31 05:00:00	SPY	ETF	459.35	459.4	459.05	459.28	20928.0
2022-03-31 06:00:00	SPY	ETF	459.1	459.33	458.8	458.82	21819.0
2022-03-31 07:00:00	SPY	ETF	458.87	458.96	458.08	458.849	93407.0
2022-03-31 08:00:00	SPY	ETF	458.35	459.98	458.18	458.75	300061.0
2022-03-31 09:00:00	SPY	ETF	458.66	458.93	457.111	457.93	5041897.0
2022-03-31 10:00:00	SPY	ETF	457.91	458.76	456.56	458.46	6883494.0
2022-03-31 11:00:00	SPY	ETF	458.48	458.62	457.28	457.92	4325587.0
2022-03-31 12:00:00	SPY	ETF	457.93	458.12	456.61	456.71	4201137.0
2022-03-31 13:00:00	SPY	ETF	456.7	457.48	456.27	456.95	4266730.0
2022-03-31 14:00:00	SPY	ETF	456.93	456.99	455.83	456.58	7080672.0
2022-03-31 15:00:00	SPY	ETF	456.6	457.36	451.16	451.65	34911208.0
2022-03-31 16:00:00	SPY	ETF	451.65	453.38	451.44	453.05	10985159.0
2022-03-31 17:00:00	SPY	ETF	453.09	453.2	451.64	452.99	318486.0
2022-03-31 18:00:00	SPY	ETF	452.95	453.33	452.68	453.08	182773.0
2022-03-31 19:00:00	SPY	ETF	453.08	453.4	453.03	453.2	58712.0
2022-03-31 04:00:00	QQQ	ETF	368.56	369.15	368.37	368.74	93211.0
2022-03-31 05:00:00	QQQ	ETF	368.74	368.78	368.42	368.67	51697.0
2022-03-31 06:00:00	QQQ	ETF	368.52	368.76	368.04	368.04	82313.0
2022-03-31 07:00:00	QQQ	ETF	368.07	368.21	367.24	368.04	248509.0
2022-03-31 08:00:00	QQQ	ETF	368.13	369.4	367.27	367.88	305500.0
2022-03-31 09:00:00	QQQ	ETF	367.93	368.03	364.79	365.94	5856938.0
2022-03-31 10:00:00	QQQ	ETF	365.93	367.6	364.48	367.16	7157878.0
2022-03-31 11:00:00	QQQ	ETF	367.17	367.245	365.87	366.43	4074435.0
2022-03-31 12:00:00	QQQ	ETF	366.42	366.58	364.7	364.84	3927617.0
2022-03-31 13:00:00	QQQ	ETF	364.8429	366.04	364.51	365.34	4320400.0
2022-03-31 14:00:00	QQQ	ETF	365.33	365.95	364.345	365.93	4825260.0
2022-03-31 15:00:00	QQQ	ETF	365.95	366.85	361.68	362.0	17436841.0
2022-03-31 16:00:00	QQQ	ETF	362.0	363.39	361.3259	363.2	2779892.0
2022-03-31 17:00:00	QQQ	ETF	363.2	363.39	362.54	363.11	145359.0
2022-03-31 18:00:00	QQQ	ETF	363.12	363.38	362.82	363.13	146778.0
2022-03-31 19:00:00	QQQ	ETF	363.15	363.31	363.04	363.08	100470.0
2022-03-31 04:00:00	IWM	ETF	208.02	208.07	207.73	207.85	14416.0
2022-03-31 05:00:00	IWM	ETF	207.76	207.86	207.69	207.76	3981.0
2022-03-31 06:00:00	IWM	ETF	207.7	207.75	207.43	207.44	5272.0
2022-03-31 07:00:00	IWM	ETF	207.32	207.42	207.01	207.34	41195.0
2022-03-31 08:00:00	IWM	ETF	207.0399	208.25	207.01	207.34	48391.0
2022-03-31 09:00:00	IWM	ETF	207.34	208.91	206.84	208.25	2598700.0
2022-03-31 10:00:00	IWM	ETF	208.26	208.69	206.99	208.51	2794476.0
2022-03-31 11:00:00	IWM	ETF	208.53	208.53	207.3	207.72	1426348.0
2022-03-31 12:00:00	IWM	ETF	207.72	207.87	207.04	207.19	1501455.0
2022-03-31 13:00:00	IWM	ETF	207.18	207.5	206.72	207.13	1171887.0
2022-03-31 14:00:00	IWM	ETF	207.12	207.15	206.47	206.9285	1589262.0
2022-03-31 15:00:00	IWM	ETF	206.92	207.33	205.15	205.2	6013714.0
2022-03-31 16:00:00	IWM	ETF	205.22	205.89	205.0	205.56	2079679.0
2022-03-31 17:00:00	IWM	ETF	205.52	205.83	205.27	205.39	454690.0
2022-03-31 18:00:00	IWM	ETF	205.56	205.82	205.42	205.58	15993.0
2022-03-31 19:00:00	IWM	ETF	205.72	205.84	205.61	205.78	24721.0
2022-03-31 04:00:00	DIA	ETF	352.34	352.34	352.06	352.06	3429.0
2022-03-31 06:00:00	DIA	ETF	352.08	352.08	352.0	352.07	2200.0

> showing 50 of 16,319 rows — these rows as CSV

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