PREVIEW / etf_30min / 2023-09-12

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-09-12.parquet
  size:    690 KB
  rows:    27,029

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-09-12 04:00:00	SPY	ETF	447.6	447.76	447.2	447.6	24178.0
2023-09-12 04:30:00	SPY	ETF	447.42	447.5	447.29	447.39	1802.0
2023-09-12 05:00:00	SPY	ETF	447.39	447.58	447.33	447.47	1280.0
2023-09-12 05:30:00	SPY	ETF	447.46	447.63	447.15	447.63	5794.0
2023-09-12 06:00:00	SPY	ETF	447.53	447.68	447.49	447.49	2906.0
2023-09-12 06:30:00	SPY	ETF	447.61	447.83	447.42	447.7	12200.0
2023-09-12 07:00:00	SPY	ETF	447.72	447.74	447.15	447.39	115892.0
2023-09-12 07:30:00	SPY	ETF	447.34	447.41	447.07	447.14	49749.0
2023-09-12 08:00:00	SPY	ETF	447.7203	448.22	447.05	447.53	84409.0
2023-09-12 08:30:00	SPY	ETF	447.48	447.8	447.19	447.19	64274.0
2023-09-12 09:00:00	SPY	ETF	447.18	447.18	446.6	446.94	393567.0
2023-09-12 09:30:00	SPY	ETF	446.95	447.82	446.79	447.65	4401069.0
2023-09-12 10:00:00	SPY	ETF	447.66	447.67	446.44	446.625	3818014.0
2023-09-12 10:30:00	SPY	ETF	446.63	446.945	446.22	446.24	3222379.0
2023-09-12 11:00:00	SPY	ETF	446.24	446.79	446.095	446.7317	2845911.0
2023-09-12 11:30:00	SPY	ETF	446.735	447.22	446.73	447.06	2737352.0
2023-09-12 12:00:00	SPY	ETF	447.07	447.515	447.07	447.25	2203423.0
2023-09-12 12:30:00	SPY	ETF	447.26	447.54	446.96	447.26	1544426.0
2023-09-12 13:00:00	SPY	ETF	447.27	448.53	447.12	448.21	3075659.0
2023-09-12 13:30:00	SPY	ETF	448.21	448.445	446.89	447.0329	3537773.0
2023-09-12 14:00:00	SPY	ETF	447.03	447.11	446.57	446.8701	2480994.0
2023-09-12 14:30:00	SPY	ETF	446.86	446.98	445.94	446.07	3108463.0
2023-09-12 15:00:00	SPY	ETF	446.07	446.08	445.39	445.63	3726721.0
2023-09-12 15:30:00	SPY	ETF	445.63	446.21	445.62	445.97	9535806.0
2023-09-12 16:00:00	SPY	ETF	445.96	447.2668	445.91	446.09	2505235.0
2023-09-12 16:30:00	SPY	ETF	446.08	446.2	445.98	445.99	70285.0
2023-09-12 17:00:00	SPY	ETF	445.97	446.06	445.95	446.0	31617.0
2023-09-12 17:30:00	SPY	ETF	446.0	446.01	445.83	445.9	52902.0
2023-09-12 18:00:00	SPY	ETF	445.9	445.96	445.79	445.79	57811.0
2023-09-12 18:30:00	SPY	ETF	445.83	446.001	445.83	445.98	11853.0
2023-09-12 19:00:00	SPY	ETF	445.85	445.99	445.82	445.99	6342.0
2023-09-12 19:30:00	SPY	ETF	445.98	446.08	445.98	446.05	22361.0
2023-09-12 04:00:00	QQQ	ETF	376.21	376.21	375.86	376.15	33968.0
2023-09-12 04:30:00	QQQ	ETF	376.02	376.07	375.71	375.85	16711.0
2023-09-12 05:00:00	QQQ	ETF	375.86	376.08	375.77	376.04	14305.0
2023-09-12 05:30:00	QQQ	ETF	375.95	376.22	375.68	376.19	13254.0
2023-09-12 06:00:00	QQQ	ETF	376.05	376.31	376.05	376.31	7560.0
2023-09-12 06:30:00	QQQ	ETF	376.33	376.55	376.15	376.4	10317.0
2023-09-12 07:00:00	QQQ	ETF	376.45	376.46	375.8	375.97	59200.0
2023-09-12 07:30:00	QQQ	ETF	375.87	375.96	375.72	375.75	53834.0
2023-09-12 08:00:00	QQQ	ETF	377.04	377.252	375.57	375.9	103637.0
2023-09-12 08:30:00	QQQ	ETF	375.86	376.28	375.64	375.65	113342.0
2023-09-12 09:00:00	QQQ	ETF	375.65	375.65	375.09	375.24	240949.0
2023-09-12 09:30:00	QQQ	ETF	375.28	376.675	374.93	376.4731	3214460.0
2023-09-12 10:00:00	QQQ	ETF	376.47	376.575	374.801	374.85	2435610.0
2023-09-12 10:30:00	QQQ	ETF	374.86	375.21	373.9	373.95	2822248.0
2023-09-12 11:00:00	QQQ	ETF	373.93	374.46	373.3	373.9599	2319458.0
2023-09-12 11:30:00	QQQ	ETF	373.9608	374.465	373.96	374.168	1612179.0
2023-09-12 12:00:00	QQQ	ETF	374.18	374.72	374.1788	374.4	1162351.0
2023-09-12 12:30:00	QQQ	ETF	374.41	374.6699	374.05	374.31	874670.0

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

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