PREVIEW / etf_30min / 2022-04-01

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-04-01.parquet
  size:    675 KB
  rows:    26,421

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-04-01 04:00:00	SPY	ETF	453.68	453.99	453.55	453.9	18806.0
2022-04-01 04:30:00	SPY	ETF	453.83	454.08	453.8	454.01	30344.0
2022-04-01 05:00:00	SPY	ETF	453.77	454.28	453.62	454.0	25084.0
2022-04-01 05:30:00	SPY	ETF	453.99	454.39	453.92	454.35	26152.0
2022-04-01 06:00:00	SPY	ETF	454.36	454.57	454.28	454.37	41335.0
2022-04-01 06:30:00	SPY	ETF	454.33	454.45	454.03	454.31	17971.0
2022-04-01 07:00:00	SPY	ETF	454.21	454.34	453.98	454.03	142017.0
2022-04-01 07:30:00	SPY	ETF	454.0	454.13	453.94	454.12	202968.0
2022-04-01 08:00:00	SPY	ETF	453.8304	454.35	451.978	454.23	378889.0
2022-04-01 08:30:00	SPY	ETF	454.25	454.3	453.13	453.24	371281.0
2022-04-01 09:00:00	SPY	ETF	453.2	453.71	452.79	453.29	349731.0
2022-04-01 09:30:00	SPY	ETF	453.32	453.46	451.66	452.26	5657671.0
2022-04-01 10:00:00	SPY	ETF	452.25	452.81	450.8	451.1	5292468.0
2022-04-01 10:30:00	SPY	ETF	451.07	452.3078	450.8	451.99	3827901.0
2022-04-01 11:00:00	SPY	ETF	451.985	452.43	451.565	451.695	2446886.0
2022-04-01 11:30:00	SPY	ETF	451.69	451.75	450.11	450.35	3686430.0
2022-04-01 12:00:00	SPY	ETF	450.33	450.51	449.67	450.43	2714895.0
2022-04-01 12:30:00	SPY	ETF	450.43	450.44	449.35	449.931	2413615.0
2022-04-01 13:00:00	SPY	ETF	449.95	450.22	449.14	449.66	2027055.0
2022-04-01 13:30:00	SPY	ETF	449.65	450.88	449.555	450.53	2549585.0
2022-04-01 14:00:00	SPY	ETF	450.53	452.21	450.47	452.15	4096118.0
2022-04-01 14:30:00	SPY	ETF	452.18	452.77	451.63	451.7966	3169329.0
2022-04-01 15:00:00	SPY	ETF	451.8	452.5	450.6284	451.0799	3655172.0
2022-04-01 15:30:00	SPY	ETF	451.07	453.19	450.31	452.88	14590270.0
2022-04-01 16:00:00	SPY	ETF	452.87	453.06	452.15	452.69	5265709.0
2022-04-01 16:30:00	SPY	ETF	452.65	452.92	452.3	452.84	194015.0
2022-04-01 17:00:00	SPY	ETF	452.86	453.12	452.7001	452.93	116044.0
2022-04-01 17:30:00	SPY	ETF	452.92	453.19	452.92	453.12	59846.0
2022-04-01 18:00:00	SPY	ETF	453.15	453.15	453.06	453.11	8498.0
2022-04-01 18:30:00	SPY	ETF	453.12	453.18	452.99	452.99	3888.0
2022-04-01 19:00:00	SPY	ETF	453.05	453.17	453.02	453.05	5977.0
2022-04-01 19:30:00	SPY	ETF	453.1	453.29	453.05	453.29	12374.0
2022-04-01 04:00:00	QQQ	ETF	363.63	363.99	363.34	363.6	53469.0
2022-04-01 04:30:00	QQQ	ETF	363.48	363.8	363.44	363.6	16979.0
2022-04-01 05:00:00	QQQ	ETF	363.51	363.53	363.03	363.49	22974.0
2022-04-01 05:30:00	QQQ	ETF	363.49	363.98	363.49	363.88	18133.0
2022-04-01 06:00:00	QQQ	ETF	364.0	364.28	364.0	364.18	28744.0
2022-04-01 06:30:00	QQQ	ETF	364.16	364.24	363.83	363.97	27697.0
2022-04-01 07:00:00	QQQ	ETF	364.01	364.04	363.63	363.72	91139.0
2022-04-01 07:30:00	QQQ	ETF	363.72	364.09	363.7	364.09	100006.0
2022-04-01 08:00:00	QQQ	ETF	363.9399	364.1496	362.811	364.0	146107.0
2022-04-01 08:30:00	QQQ	ETF	363.87	364.12	362.79	362.81	531441.0
2022-04-01 09:00:00	QQQ	ETF	362.83	363.1	362.43	362.75	412989.0
2022-04-01 09:30:00	QQQ	ETF	362.81	363.61	360.59	361.41	5306579.0
2022-04-01 10:00:00	QQQ	ETF	361.41	362.48	360.5512	361.405	4101816.0
2022-04-01 10:30:00	QQQ	ETF	361.3986	362.77	361.01	362.57	3215178.0
2022-04-01 11:00:00	QQQ	ETF	362.57	362.71	360.9819	361.11	2114121.0
2022-04-01 11:30:00	QQQ	ETF	361.1082	361.22	359.3	359.53	3250609.0
2022-04-01 12:00:00	QQQ	ETF	359.53	360.05	358.94	359.95	2464364.0
2022-04-01 12:30:00	QQQ	ETF	359.945	359.945	358.76	359.04	2410613.0

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

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