PREVIEW / etf_30min / 2024-05-14

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-05-14.parquet
  size:    788 KB
  rows:    31,567

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
2024-05-14 04:00:00	SPY	ETF	521.03	521.15	520.98	521.13	3459.0
2024-05-14 04:30:00	SPY	ETF	521.07	521.21	521.07	521.2	2613.0
2024-05-14 05:00:00	SPY	ETF	521.18	521.18	521.11	521.11	700.0
2024-05-14 05:30:00	SPY	ETF	521.02	521.16	520.95	521.16	5648.0
2024-05-14 06:00:00	SPY	ETF	521.15	521.16	521.04	521.09	4288.0
2024-05-14 06:30:00	SPY	ETF	521.08	521.25	520.99	521.22	6256.0
2024-05-14 07:00:00	SPY	ETF	521.2	521.24	521.08	521.08	20157.0
2024-05-14 07:30:00	SPY	ETF	521.08	521.15	520.98	521.13	6974.0
2024-05-14 08:00:00	SPY	ETF	521.08	521.43	520.7	521.33	71302.0
2024-05-14 08:30:00	SPY	ETF	520.98	521.15	518.18	520.87	883485.0
2024-05-14 09:00:00	SPY	ETF	520.86	521.45	520.52	521.1	410413.0
2024-05-14 09:30:00	SPY	ETF	521.1	521.68	520.88	521.3	3428166.0
2024-05-14 10:00:00	SPY	ETF	521.27	522.41	520.96	522.23	3402166.0
2024-05-14 10:30:00	SPY	ETF	522.23	522.28	520.64	521.765	2568901.0
2024-05-14 11:00:00	SPY	ETF	521.77	522.13	521.52	521.92	1599286.0
2024-05-14 11:30:00	SPY	ETF	521.93	521.93	520.96	521.09	1214688.0
2024-05-14 12:00:00	SPY	ETF	521.095	521.3	520.81	520.95	1250727.0
2024-05-14 12:30:00	SPY	ETF	520.94	521.04	520.68	520.98	1009341.0
2024-05-14 13:00:00	SPY	ETF	520.98	521.07	520.56	521.0409	1186178.0
2024-05-14 13:30:00	SPY	ETF	521.05	521.485	520.975	521.29	1301364.0
2024-05-14 14:00:00	SPY	ETF	521.28	522.375	521.23	522.32	2025635.0
2024-05-14 14:30:00	SPY	ETF	522.32	523.5225	522.185	523.2687	3505663.0
2024-05-14 15:00:00	SPY	ETF	523.255	523.78	522.985	523.4414	2831439.0
2024-05-14 15:30:00	SPY	ETF	523.44	523.83	523.2	523.29	9544906.0
2024-05-14 16:00:00	SPY	ETF	523.29	523.4259	523.09	523.15	5142839.0
2024-05-14 16:30:00	SPY	ETF	523.15	523.33	523.1	523.33	120389.0
2024-05-14 17:00:00	SPY	ETF	523.38	523.4	523.1	523.14	41893.0
2024-05-14 17:30:00	SPY	ETF	523.18	523.29	523.18	523.27	13034.0
2024-05-14 18:00:00	SPY	ETF	523.22	523.57	523.1	523.57	33266.0
2024-05-14 18:30:00	SPY	ETF	523.56	523.76	523.56	523.71	21387.0
2024-05-14 19:00:00	SPY	ETF	523.7	523.73	523.62	523.62	17842.0
2024-05-14 19:30:00	SPY	ETF	523.59	523.62	523.55	523.6	12981.0
2024-05-14 04:00:00	QQQ	ETF	443.01	443.25	443.01	443.25	10951.0
2024-05-14 04:30:00	QQQ	ETF	443.25	443.43	443.22	443.43	2993.0
2024-05-14 05:00:00	QQQ	ETF	443.37	443.43	443.18	443.18	6110.0
2024-05-14 05:30:00	QQQ	ETF	443.18	443.3	443.02	443.3	4322.0
2024-05-14 06:00:00	QQQ	ETF	443.3	443.3	443.09	443.2	4646.0
2024-05-14 06:30:00	QQQ	ETF	443.11	443.36	443.04	443.31	10833.0
2024-05-14 07:00:00	QQQ	ETF	443.3	443.35	442.94	442.97	15107.0
2024-05-14 07:30:00	QQQ	ETF	442.88	443.079	442.82	442.94	28452.0
2024-05-14 08:00:00	QQQ	ETF	443.3205	443.42	442.53	443.2	76913.0
2024-05-14 08:30:00	QQQ	ETF	443.19	443.2	440.06	442.39	470740.0
2024-05-14 09:00:00	QQQ	ETF	442.4	443.031	442.1	442.6	167654.0
2024-05-14 09:30:00	QQQ	ETF	442.65	443.911	442.46	443.055	4008042.0
2024-05-14 10:00:00	QQQ	ETF	443.03	444.97	442.66	444.815	3108829.0
2024-05-14 10:30:00	QQQ	ETF	444.82	444.94	442.88	444.2197	2174460.0
2024-05-14 11:00:00	QQQ	ETF	444.21	444.88	444.03	444.69	1575748.0
2024-05-14 11:30:00	QQQ	ETF	444.695	444.7	443.4	443.77	1165137.0
2024-05-14 12:00:00	QQQ	ETF	443.765	444.03	443.41	443.58	1025080.0
2024-05-14 12:30:00	QQQ	ETF	443.57	443.7	443.24	443.6889	826160.0

> showing 50 of 31,567 rows — these rows as CSV

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