PREVIEW / etf_30min / 2023-03-23

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-03-23.parquet
  size:    694 KB
  rows:    28,234

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-23 04:00:00	SPY	ETF	395.02	395.38	394.03	395.21	79100.0
2023-03-23 04:30:00	SPY	ETF	394.96	395.49	394.96	395.17	13299.0
2023-03-23 05:00:00	SPY	ETF	395.15	395.17	394.39	394.47	26899.0
2023-03-23 05:30:00	SPY	ETF	394.5	394.5	394.09	394.3	19061.0
2023-03-23 06:00:00	SPY	ETF	394.36	394.43	393.3	393.4	94649.0
2023-03-23 06:30:00	SPY	ETF	393.29	393.97	393.12	393.95	91001.0
2023-03-23 07:00:00	SPY	ETF	393.98	394.66	393.98	394.28	75866.0
2023-03-23 07:30:00	SPY	ETF	394.31	394.88	394.11	394.59	146014.0
2023-03-23 08:00:00	SPY	ETF	394.65	395.25	393.5196	394.24	258238.0
2023-03-23 08:30:00	SPY	ETF	394.3	395.02	394.0	394.32	262109.0
2023-03-23 09:00:00	SPY	ETF	394.31	395.08	393.7	395.06	274944.0
2023-03-23 09:30:00	SPY	ETF	395.07	396.17	394.92	395.95	7188723.0
2023-03-23 10:00:00	SPY	ETF	395.95	397.26	395.84	396.69	6026356.0
2023-03-23 10:30:00	SPY	ETF	396.69	398.55	396.39	398.42	4934329.0
2023-03-23 11:00:00	SPY	ETF	398.42	399.29	397.85	397.93	4651801.0
2023-03-23 11:30:00	SPY	ETF	397.92	398.65	397.77	398.02	3363906.0
2023-03-23 12:00:00	SPY	ETF	398.04	398.3201	397.13	397.66	3982098.0
2023-03-23 12:30:00	SPY	ETF	397.66	398.025	396.54	396.77	3454910.0
2023-03-23 13:00:00	SPY	ETF	396.77	397.13	394.75	395.3399	5831491.0
2023-03-23 13:30:00	SPY	ETF	395.335	396.2	394.66	394.82	3515894.0
2023-03-23 14:00:00	SPY	ETF	394.82	395.36	392.8	392.8	5478263.0
2023-03-23 14:30:00	SPY	ETF	392.83	393.35	390.54	392.3	9746753.0
2023-03-23 15:00:00	SPY	ETF	392.31	394.77	390.35	391.82	13557365.0
2023-03-23 15:30:00	SPY	ETF	391.8	394.99	391.22	393.11	15626708.0
2023-03-23 16:00:00	SPY	ETF	393.13	393.3877	392.93	393.1	3685986.0
2023-03-23 16:30:00	SPY	ETF	393.09	394.84	393.03	394.33	791690.0
2023-03-23 17:00:00	SPY	ETF	394.35	394.36	393.17	394.18	539736.0
2023-03-23 17:30:00	SPY	ETF	394.21	394.64	394.18	394.47	36433.0
2023-03-23 18:00:00	SPY	ETF	394.4	394.53	393.65	393.77	77060.0
2023-03-23 18:30:00	SPY	ETF	393.76	393.83	393.34	393.61	42193.0
2023-03-23 19:00:00	SPY	ETF	393.55	394.09	393.55	393.94	36577.0
2023-03-23 19:30:00	SPY	ETF	393.99	394.05	393.69	393.91	39406.0
2023-03-23 04:00:00	QQQ	ETF	308.83	309.61	308.08	309.38	85477.0
2023-03-23 04:30:00	QQQ	ETF	309.27	309.9	309.17	309.53	60483.0
2023-03-23 05:00:00	QQQ	ETF	309.6	309.6	309.1	309.23	29723.0
2023-03-23 05:30:00	QQQ	ETF	309.26	309.5	308.95	309.41	26581.0
2023-03-23 06:00:00	QQQ	ETF	309.39	309.52	308.62	308.8	66979.0
2023-03-23 06:30:00	QQQ	ETF	308.72	309.18	308.4	309.18	59517.0
2023-03-23 07:00:00	QQQ	ETF	309.15	309.39	308.95	309.03	85365.0
2023-03-23 07:30:00	QQQ	ETF	309.01	309.43	308.89	309.17	113230.0
2023-03-23 08:00:00	QQQ	ETF	309.1982	309.5496	306.349	309.07	258183.0
2023-03-23 08:30:00	QQQ	ETF	308.9	309.64	308.71	309.15	507049.0
2023-03-23 09:00:00	QQQ	ETF	309.14	309.93	308.7	309.91	327401.0
2023-03-23 09:30:00	QQQ	ETF	309.92	310.93	309.73	310.8004	5183889.0
2023-03-23 10:00:00	QQQ	ETF	310.81	312.41	310.7	311.8	3972181.0
2023-03-23 10:30:00	QQQ	ETF	311.815	313.56	311.54	313.3199	3895849.0
2023-03-23 11:00:00	QQQ	ETF	313.35	314.15	312.73	312.815	2890188.0
2023-03-23 11:30:00	QQQ	ETF	312.83	313.63	312.62	313.0899	2358115.0
2023-03-23 12:00:00	QQQ	ETF	313.08	313.44	312.34	313.07	2330638.0
2023-03-23 12:30:00	QQQ	ETF	313.04	313.28	312.12	312.39	1925006.0

> showing 50 of 28,234 rows — these rows as CSV

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