PREVIEW / etf_30min / 2023-03-21

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-03-21.parquet
  size:    673 KB
  rows:    27,730

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
2023-03-21 04:00:00	SPY	ETF	394.78	395.01	394.25	395.0	24261.0
2023-03-21 04:30:00	SPY	ETF	395.02	395.12	394.64	395.0	21281.0
2023-03-21 05:00:00	SPY	ETF	394.96	395.41	394.72	395.27	27694.0
2023-03-21 05:30:00	SPY	ETF	395.34	395.85	395.26	395.84	40182.0
2023-03-21 06:00:00	SPY	ETF	395.92	396.37	395.65	396.2	46634.0
2023-03-21 06:30:00	SPY	ETF	396.2	396.68	395.83	396.07	90543.0
2023-03-21 07:00:00	SPY	ETF	396.05	397.09	395.88	397.06	435563.0
2023-03-21 07:30:00	SPY	ETF	396.93	397.16	396.65	396.97	274061.0
2023-03-21 08:00:00	SPY	ETF	396.3001	397.17	393.99	396.83	322619.0
2023-03-21 08:30:00	SPY	ETF	396.8	397.06	396.66	396.92	163779.0
2023-03-21 09:00:00	SPY	ETF	396.92	397.32	396.8	397.28	302076.0
2023-03-21 09:30:00	SPY	ETF	397.26	397.99	397.07	397.88	6757981.0
2023-03-21 10:00:00	SPY	ETF	397.87	398.3393	396.05	396.43	6919133.0
2023-03-21 10:30:00	SPY	ETF	396.44	397.05	395.83	396.24	4242321.0
2023-03-21 11:00:00	SPY	ETF	396.25	397.305	396.1157	396.87	3165124.0
2023-03-21 11:30:00	SPY	ETF	396.89	397.275	395.58	395.885	3777027.0
2023-03-21 12:00:00	SPY	ETF	395.9	396.67	395.66	396.49	2514560.0
2023-03-21 12:30:00	SPY	ETF	396.5	396.88	396.04	396.41	2816645.0
2023-03-21 13:00:00	SPY	ETF	396.42	397.03	396.15	396.94	2361954.0
2023-03-21 13:30:00	SPY	ETF	396.95	397.419	396.26	396.275	2854407.0
2023-03-21 14:00:00	SPY	ETF	396.27	397.165	396.24	397.05	2720086.0
2023-03-21 14:30:00	SPY	ETF	397.06	397.93	396.898	397.66	3174038.0
2023-03-21 15:00:00	SPY	ETF	397.65	398.49	397.6	398.225	4636559.0
2023-03-21 15:30:00	SPY	ETF	398.22	399.41	398.03	398.87	13860821.0
2023-03-21 16:00:00	SPY	ETF	398.87	399.21	397.4136	399.04	4670196.0
2023-03-21 16:30:00	SPY	ETF	399.03	399.1	398.95	398.96	121434.0
2023-03-21 17:00:00	SPY	ETF	398.99	399.01	398.91	398.91	43102.0
2023-03-21 17:30:00	SPY	ETF	398.973	398.9803	398.85	398.88	13813.0
2023-03-21 18:00:00	SPY	ETF	398.91	398.91	398.62	398.66	60581.0
2023-03-21 18:30:00	SPY	ETF	398.67	398.85	398.67	398.85	15835.0
2023-03-21 19:00:00	SPY	ETF	398.83	398.96	398.76	398.94	35189.0
2023-03-21 19:30:00	SPY	ETF	398.89	398.94	398.71	398.89	84947.0
2023-03-21 04:00:00	QQQ	ETF	306.67	306.94	306.4	306.88	16656.0
2023-03-21 04:30:00	QQQ	ETF	306.9	306.9	306.35	306.59	18449.0
2023-03-21 05:00:00	QQQ	ETF	306.35	306.49	306.2	306.34	24699.0
2023-03-21 05:30:00	QQQ	ETF	306.37	306.52	306.08	306.52	13433.0
2023-03-21 06:00:00	QQQ	ETF	306.69	307.29	306.43	307.05	34155.0
2023-03-21 06:30:00	QQQ	ETF	307.04	307.22	306.6	306.77	28852.0
2023-03-21 07:00:00	QQQ	ETF	306.76	307.99	306.75	307.83	84491.0
2023-03-21 07:30:00	QQQ	ETF	307.85	308.32	307.75	308.13	129643.0
2023-03-21 08:00:00	QQQ	ETF	308.0114	308.28	305.91	307.73	251607.0
2023-03-21 08:30:00	QQQ	ETF	307.73	307.91	307.43	307.67	150589.0
2023-03-21 09:00:00	QQQ	ETF	307.64	308.21	307.59	307.94	193815.0
2023-03-21 09:30:00	QQQ	ETF	307.94	308.94	307.63	308.8505	4697332.0
2023-03-21 10:00:00	QQQ	ETF	308.86	309.4	306.91	307.3	4288625.0
2023-03-21 10:30:00	QQQ	ETF	307.3	307.62	306.418	306.86	2279515.0
2023-03-21 11:00:00	QQQ	ETF	306.87	307.98	306.69	307.48	1921251.0
2023-03-21 11:30:00	QQQ	ETF	307.46	307.82	306.395	306.8501	2467081.0
2023-03-21 12:00:00	QQQ	ETF	306.87	307.8	306.67	307.665	1915643.0
2023-03-21 12:30:00	QQQ	ETF	307.67	308.21	307.43	308.01	1754332.0

> showing 50 of 27,730 rows — these rows as CSV

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