PREVIEW / etf_30min / 2024-04-10

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-04-10.parquet
  size:    824 KB
  rows:    33,161

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-04-10 04:00:00	SPY	ETF	519.99	520.01	519.76	519.98	7322.0
2024-04-10 04:30:00	SPY	ETF	520.01	520.21	519.95	520.2	1400.0
2024-04-10 05:00:00	SPY	ETF	520.37	520.37	519.97	519.99	1491.0
2024-04-10 05:30:00	SPY	ETF	519.86	519.86	519.55	519.65	1780.0
2024-04-10 06:00:00	SPY	ETF	519.26	519.65	519.26	519.5	4429.0
2024-04-10 06:30:00	SPY	ETF	519.41	519.91	519.41	519.91	5528.0
2024-04-10 07:00:00	SPY	ETF	519.87	520.11	519.81	519.96	54502.0
2024-04-10 07:30:00	SPY	ETF	520.01	520.2	519.98	520.2	58230.0
2024-04-10 08:00:00	SPY	ETF	519.88	521.35	519.76	520.9	239722.0
2024-04-10 08:30:00	SPY	ETF	520.53	520.53	511.27	512.75	3366522.0
2024-04-10 09:00:00	SPY	ETF	512.72	513.67	511.55	513.48	928670.0
2024-04-10 09:30:00	SPY	ETF	513.48	514.48	512.67	513.985	8651722.0
2024-04-10 10:00:00	SPY	ETF	514.0	515.13	513.41	514.67	4734600.0
2024-04-10 10:30:00	SPY	ETF	514.66	516.16	513.97	514.46	4500013.0
2024-04-10 11:00:00	SPY	ETF	514.47	514.53	513.48	514.485	3153876.0
2024-04-10 11:30:00	SPY	ETF	514.49	514.53	513.0	513.3499	2435555.0
2024-04-10 12:00:00	SPY	ETF	513.34	513.81	512.98	513.395	2057860.0
2024-04-10 12:30:00	SPY	ETF	513.4	514.38	513.24	514.1679	2226496.0
2024-04-10 13:00:00	SPY	ETF	514.1679	515.14	512.09	513.8604	5650490.0
2024-04-10 13:30:00	SPY	ETF	513.88	514.9	512.29	513.76	5353409.0
2024-04-10 14:00:00	SPY	ETF	513.7804	514.68	513.08	513.2	4044040.0
2024-04-10 14:30:00	SPY	ETF	513.19	514.18	512.5651	512.635	2544251.0
2024-04-10 15:00:00	SPY	ETF	512.63	515.07	512.445	514.26	4042966.0
2024-04-10 15:30:00	SPY	ETF	514.26	515.01	513.41	514.16	9407467.0
2024-04-10 16:00:00	SPY	ETF	514.15	514.3	513.16	513.54	2044802.0
2024-04-10 16:30:00	SPY	ETF	513.59	513.99	513.42	513.98	207584.0
2024-04-10 17:00:00	SPY	ETF	514.0	514.0	513.8	513.85	55225.0
2024-04-10 17:30:00	SPY	ETF	513.85	513.88	513.8	513.81	25366.0
2024-04-10 18:00:00	SPY	ETF	513.81	513.81	513.25	513.67	86999.0
2024-04-10 18:30:00	SPY	ETF	513.65	513.65	513.45	513.45	2420.0
2024-04-10 19:00:00	SPY	ETF	513.28	513.36	512.87	513.05	40895.0
2024-04-10 19:30:00	SPY	ETF	513.0599	513.41	513.05	513.21	16155.0
2024-04-10 04:00:00	QQQ	ETF	442.77	443.17	442.77	442.98	20597.0
2024-04-10 04:30:00	QQQ	ETF	443.0	443.41	443.0	443.38	10290.0
2024-04-10 05:00:00	QQQ	ETF	443.38	443.5	442.88	442.9	10458.0
2024-04-10 05:30:00	QQQ	ETF	442.87	442.92	442.23	442.23	9819.0
2024-04-10 06:00:00	QQQ	ETF	442.17	442.28	441.86	442.23	18909.0
2024-04-10 06:30:00	QQQ	ETF	442.1	442.68	442.01	442.6	28181.0
2024-04-10 07:00:00	QQQ	ETF	442.5	442.8	442.49	442.53	37437.0
2024-04-10 07:30:00	QQQ	ETF	442.58	442.88	442.58	442.75	41941.0
2024-04-10 08:00:00	QQQ	ETF	442.49	444.75	442.3496	443.6	214275.0
2024-04-10 08:30:00	QQQ	ETF	443.0	443.0	434.96	436.1909	2411784.0
2024-04-10 09:00:00	QQQ	ETF	436.25	437.05	435.15	436.95	687657.0
2024-04-10 09:30:00	QQQ	ETF	437.0	438.67	436.28	437.98	8182636.0
2024-04-10 10:00:00	QQQ	ETF	438.0	438.66	437.23	437.9	4414109.0
2024-04-10 10:30:00	QQQ	ETF	437.95	439.24	436.92	437.47	3743521.0
2024-04-10 11:00:00	QQQ	ETF	437.49	438.02	436.77	438.0197	1830791.0
2024-04-10 11:30:00	QQQ	ETF	438.03	438.06	436.68	437.15	1449272.0
2024-04-10 12:00:00	QQQ	ETF	437.14	437.69	436.72	437.3	1233469.0
2024-04-10 12:30:00	QQQ	ETF	437.31	438.5	437.2	438.27	1681809.0

> showing 50 of 33,161 rows — these rows as CSV

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