PREVIEW / etf_30min / 2023-04-25

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-04-25.parquet
  size:    702 KB
  rows:    27,872

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-04-25 04:00:00	SPY	ETF	410.67	411.18	409.86	410.1	32164.0
2023-04-25 04:30:00	SPY	ETF	410.1	410.81	410.1	410.5	13837.0
2023-04-25 05:00:00	SPY	ETF	410.5	410.59	410.3	410.5	11263.0
2023-04-25 05:30:00	SPY	ETF	410.56	410.68	410.37	410.65	24241.0
2023-04-25 06:00:00	SPY	ETF	410.7	410.84	410.39	410.44	57166.0
2023-04-25 06:30:00	SPY	ETF	410.49	410.74	410.49	410.73	170704.0
2023-04-25 07:00:00	SPY	ETF	410.81	411.04	410.71	411.04	107385.0
2023-04-25 07:30:00	SPY	ETF	411.08	411.11	410.42	410.8	147601.0
2023-04-25 08:00:00	SPY	ETF	410.89	411.9	410.3496	411.01	394748.0
2023-04-25 08:30:00	SPY	ETF	411.03	411.04	410.66	410.79	176222.0
2023-04-25 09:00:00	SPY	ETF	410.77	412.27	410.5	410.59	285308.0
2023-04-25 09:30:00	SPY	ETF	410.59	411.16	410.04	410.28	5965609.0
2023-04-25 10:00:00	SPY	ETF	410.27	410.79	409.42	409.67	5604976.0
2023-04-25 10:30:00	SPY	ETF	409.67	409.97	409.13	409.83	4100854.0
2023-04-25 11:00:00	SPY	ETF	409.84	410.41	409.525	409.58	3140178.0
2023-04-25 11:30:00	SPY	ETF	409.56	409.57	408.95	409.0399	3621252.0
2023-04-25 12:00:00	SPY	ETF	409.03	409.29	408.84	408.9098	3127936.0
2023-04-25 12:30:00	SPY	ETF	408.9	409.01	408.43	408.65	2431111.0
2023-04-25 13:00:00	SPY	ETF	408.65	408.91	406.97	407.525	5493909.0
2023-04-25 13:30:00	SPY	ETF	407.52	407.55	406.825	406.975	3289679.0
2023-04-25 14:00:00	SPY	ETF	406.9726	407.24	406.575	407.19	4471808.0
2023-04-25 14:30:00	SPY	ETF	407.19	407.4	406.585	406.6482	4219067.0
2023-04-25 15:00:00	SPY	ETF	406.63	407.43	406.51	406.9	3773845.0
2023-04-25 15:30:00	SPY	ETF	406.91	407.15	406.02	406.12	12575463.0
2023-04-25 16:00:00	SPY	ETF	406.12	408.4884	405.96	407.52	5325552.0
2023-04-25 16:30:00	SPY	ETF	407.54	407.71	406.0233	407.7	402912.0
2023-04-25 17:00:00	SPY	ETF	407.8	407.98	407.64	407.98	74468.0
2023-04-25 17:30:00	SPY	ETF	407.99	408.04	407.94	407.95	27791.0
2023-04-25 18:00:00	SPY	ETF	407.95	408.38	407.68	408.07	103758.0
2023-04-25 18:30:00	SPY	ETF	408.16	408.25	407.87	407.89	46524.0
2023-04-25 19:00:00	SPY	ETF	407.87	407.93	407.64	407.8	60254.0
2023-04-25 19:30:00	SPY	ETF	407.8	408.0	407.8	407.9	33672.0
2023-04-25 04:00:00	QQQ	ETF	314.92	315.14	313.78	313.91	64617.0
2023-04-25 04:30:00	QQQ	ETF	313.93	314.67	313.89	314.5	30497.0
2023-04-25 05:00:00	QQQ	ETF	314.45	314.54	314.25	314.47	6805.0
2023-04-25 05:30:00	QQQ	ETF	314.52	314.62	314.35	314.6	15209.0
2023-04-25 06:00:00	QQQ	ETF	314.66	314.87	314.35	314.52	27128.0
2023-04-25 06:30:00	QQQ	ETF	314.54	314.75	314.39	314.68	45854.0
2023-04-25 07:00:00	QQQ	ETF	314.71	314.98	314.6	314.95	52055.0
2023-04-25 07:30:00	QQQ	ETF	315.0	315.0	314.48	314.67	148828.0
2023-04-25 08:00:00	QQQ	ETF	314.75	316.186	313.8904	314.91	124216.0
2023-04-25 08:30:00	QQQ	ETF	314.91	314.91	314.41	314.57	113343.0
2023-04-25 09:00:00	QQQ	ETF	314.56	314.75	314.26	314.3	173948.0
2023-04-25 09:30:00	QQQ	ETF	314.29	314.97	313.78	314.1092	3996057.0
2023-04-25 10:00:00	QQQ	ETF	314.08	314.63	313.08	313.35	3775428.0
2023-04-25 10:30:00	QQQ	ETF	313.35	313.78	312.9	313.41	2855726.0
2023-04-25 11:00:00	QQQ	ETF	313.42	313.97	313.13	313.39	2263390.0
2023-04-25 11:30:00	QQQ	ETF	313.38	313.385	312.6	312.6601	1900151.0
2023-04-25 12:00:00	QQQ	ETF	312.67	312.77	312.27	312.4	2010335.0
2023-04-25 12:30:00	QQQ	ETF	312.39	312.41	311.8813	312.33	2018597.0

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

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