PREVIEW / etf_30min / 2022-03-31

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-03-31.parquet
  size:    668 KB
  rows:    26,376

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.06	459.28	93634.0
2022-03-31 04:30:00	SPY	ETF	459.31	459.44	459.01	459.38	14754.0
2022-03-31 05:00:00	SPY	ETF	459.35	459.4	459.05	459.25	17428.0
2022-03-31 05:30:00	SPY	ETF	459.27	459.39	459.17	459.28	3500.0
2022-03-31 06:00:00	SPY	ETF	459.1	459.26	458.83	459.23	11584.0
2022-03-31 06:30:00	SPY	ETF	459.2	459.33	458.8	458.82	10235.0
2022-03-31 07:00:00	SPY	ETF	458.87	458.96	458.08	458.08	45105.0
2022-03-31 07:30:00	SPY	ETF	458.17	458.849	458.1	458.849	48302.0
2022-03-31 08:00:00	SPY	ETF	458.35	459.98	458.18	458.79	167441.0
2022-03-31 08:30:00	SPY	ETF	458.79	459.24	458.38	458.75	132620.0
2022-03-31 09:00:00	SPY	ETF	458.66	458.93	457.86	457.88	215479.0
2022-03-31 09:30:00	SPY	ETF	457.89	458.15	457.111	457.93	4826418.0
2022-03-31 10:00:00	SPY	ETF	457.91	457.93	456.56	457.18	3987310.0
2022-03-31 10:30:00	SPY	ETF	457.2	458.76	457.02	458.46	2896184.0
2022-03-31 11:00:00	SPY	ETF	458.48	458.62	457.581	457.69	2040720.0
2022-03-31 11:30:00	SPY	ETF	457.67	458.2	457.28	457.92	2284867.0
2022-03-31 12:00:00	SPY	ETF	457.93	458.12	456.72	456.95	2192232.0
2022-03-31 12:30:00	SPY	ETF	456.9601	457.31	456.61	456.71	2008905.0
2022-03-31 13:00:00	SPY	ETF	456.7	457.02	456.27	456.95	2154793.0
2022-03-31 13:30:00	SPY	ETF	456.954	457.48	456.62	456.95	2111937.0
2022-03-31 14:00:00	SPY	ETF	456.93	456.99	455.9005	456.31	3575494.0
2022-03-31 14:30:00	SPY	ETF	456.31	456.62	455.83	456.58	3505178.0
2022-03-31 15:00:00	SPY	ETF	456.6	457.36	455.26	455.52	5462283.0
2022-03-31 15:30:00	SPY	ETF	455.52	455.655	451.16	451.65	29448925.0
2022-03-31 16:00:00	SPY	ETF	451.65	453.38	451.44	452.85	10397089.0
2022-03-31 16:30:00	SPY	ETF	452.8	453.22	451.64	453.05	588070.0
2022-03-31 17:00:00	SPY	ETF	453.09	453.2	451.64	452.73	190769.0
2022-03-31 17:30:00	SPY	ETF	452.73	452.99	452.54	452.99	127717.0
2022-03-31 18:00:00	SPY	ETF	452.95	453.33	452.68	452.75	156251.0
2022-03-31 18:30:00	SPY	ETF	452.75	453.16	452.75	453.08	26522.0
2022-03-31 19:00:00	SPY	ETF	453.08	453.24	453.03	453.16	9755.0
2022-03-31 19:30:00	SPY	ETF	453.22	453.4	453.11	453.2	48957.0
2022-03-31 04:00:00	QQQ	ETF	368.56	369.15	368.47	368.67	73747.0
2022-03-31 04:30:00	QQQ	ETF	368.67	368.87	368.37	368.74	19464.0
2022-03-31 05:00:00	QQQ	ETF	368.74	368.77	368.42	368.66	40409.0
2022-03-31 05:30:00	QQQ	ETF	368.73	368.78	368.6	368.67	11288.0
2022-03-31 06:00:00	QQQ	ETF	368.52	368.76	368.14	368.36	23105.0
2022-03-31 06:30:00	QQQ	ETF	368.33	368.57	368.04	368.04	59208.0
2022-03-31 07:00:00	QQQ	ETF	368.07	368.21	367.28	367.3	128197.0
2022-03-31 07:30:00	QQQ	ETF	367.34	368.11	367.24	368.04	120312.0
2022-03-31 08:00:00	QQQ	ETF	368.13	369.4	367.27	368.15	142469.0
2022-03-31 08:30:00	QQQ	ETF	368.02	368.57	367.54	367.88	163031.0
2022-03-31 09:00:00	QQQ	ETF	367.93	368.03	367.05	367.2	197086.0
2022-03-31 09:30:00	QQQ	ETF	367.24	367.46	364.79	365.94	5659852.0
2022-03-31 10:00:00	QQQ	ETF	365.93	366.49	364.48	365.7	4251090.0
2022-03-31 10:30:00	QQQ	ETF	365.69	367.6	365.62	367.16	2906788.0
2022-03-31 11:00:00	QQQ	ETF	367.17	367.245	365.87	366.12	2326393.0
2022-03-31 11:30:00	QQQ	ETF	366.1	367.1	365.93	366.43	1748042.0
2022-03-31 12:00:00	QQQ	ETF	366.42	366.58	365.045	365.3201	1820349.0
2022-03-31 12:30:00	QQQ	ETF	365.34	365.59	364.7	364.84	2107268.0

> showing 50 of 26,376 rows — these rows as CSV

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