PREVIEW / etf_30min / 2024-03-05

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-03-05.parquet
  size:    814 KB
  rows:    32,635

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-03-05 04:00:00	SPY	ETF	510.73	510.95	510.66	510.92	5472.0
2024-03-05 04:30:00	SPY	ETF	510.88	511.0	510.5	510.55	7387.0
2024-03-05 05:00:00	SPY	ETF	510.54	510.66	510.4	510.58	5952.0
2024-03-05 05:30:00	SPY	ETF	510.69	510.95	510.69	510.86	13621.0
2024-03-05 06:00:00	SPY	ETF	510.92	511.11	510.9	511.05	19409.0
2024-03-05 06:30:00	SPY	ETF	511.09	511.12	510.78	511.01	122343.0
2024-03-05 07:00:00	SPY	ETF	511.01	511.24	510.9	511.12	54212.0
2024-03-05 07:30:00	SPY	ETF	511.06	511.06	510.45	510.549	41840.0
2024-03-05 08:00:00	SPY	ETF	511.0716	511.4	510.42	510.45	161081.0
2024-03-05 08:30:00	SPY	ETF	510.46	510.55	510.02	510.15	79345.0
2024-03-05 09:00:00	SPY	ETF	510.1699	510.33	509.89	510.24	149196.0
2024-03-05 09:30:00	SPY	ETF	510.24	510.32	509.32	509.66	5256873.0
2024-03-05 10:00:00	SPY	ETF	509.7	510.7	508.11	508.42	5665091.0
2024-03-05 10:30:00	SPY	ETF	508.41	508.41	507.5	508.12	3954345.0
2024-03-05 11:00:00	SPY	ETF	508.12	508.24	507.56	508.18	2398920.0
2024-03-05 11:30:00	SPY	ETF	508.16	508.41	506.96	507.68	3323961.0
2024-03-05 12:00:00	SPY	ETF	507.66	508.51	507.54	508.45	2110068.0
2024-03-05 12:30:00	SPY	ETF	508.46	508.5	507.69	507.99	1907281.0
2024-03-05 13:00:00	SPY	ETF	508.01	508.159	507.3602	507.7	2051760.0
2024-03-05 13:30:00	SPY	ETF	507.7	508.1	506.67	506.76	2894456.0
2024-03-05 14:00:00	SPY	ETF	506.76	507.375	506.65	507.03	2595261.0
2024-03-05 14:30:00	SPY	ETF	507.03	507.05	505.3	505.72	4155983.0
2024-03-05 15:00:00	SPY	ETF	505.73	506.07	504.92	505.01	4274453.0
2024-03-05 15:30:00	SPY	ETF	505.01	507.37	504.91	507.15	11573913.0
2024-03-05 16:00:00	SPY	ETF	507.14	507.8	507.0844	507.54	3367715.0
2024-03-05 16:30:00	SPY	ETF	507.53	507.73	507.43	507.71	242801.0
2024-03-05 17:00:00	SPY	ETF	507.71	507.81	507.18	507.18	228509.0
2024-03-05 17:30:00	SPY	ETF	507.8	507.83	507.7	507.75	36960.0
2024-03-05 18:00:00	SPY	ETF	507.7	507.7	507.3	507.42	87077.0
2024-03-05 18:30:00	SPY	ETF	507.35	507.51	507.22	507.34	42594.0
2024-03-05 19:00:00	SPY	ETF	507.37	507.37	507.18	507.32	12878.0
2024-03-05 19:30:00	SPY	ETF	507.34	507.38	506.97	506.97	66337.0
2024-03-05 04:00:00	QQQ	ETF	441.32	441.88	440.97	441.36	88857.0
2024-03-05 04:30:00	QQQ	ETF	441.35	441.43	440.72	440.77	36980.0
2024-03-05 05:00:00	QQQ	ETF	440.76	440.89	440.31	440.76	48504.0
2024-03-05 05:30:00	QQQ	ETF	440.8	441.09	440.8	440.99	18610.0
2024-03-05 06:00:00	QQQ	ETF	441.05	441.44	441.01	441.32	17247.0
2024-03-05 06:30:00	QQQ	ETF	441.35	441.48	441.26	441.48	12640.0
2024-03-05 07:00:00	QQQ	ETF	441.51	442.14	441.51	441.84	88722.0
2024-03-05 07:30:00	QQQ	ETF	441.861	441.9	441.15	441.311	90803.0
2024-03-05 08:00:00	QQQ	ETF	441.69	443.687	440.4104	441.3	216057.0
2024-03-05 08:30:00	QQQ	ETF	441.28	441.46	440.87	440.92	391893.0
2024-03-05 09:00:00	QQQ	ETF	440.86	441.19	440.63	441.0	138172.0
2024-03-05 09:30:00	QQQ	ETF	440.94	440.95	438.31	438.72	5834222.0
2024-03-05 10:00:00	QQQ	ETF	438.74	439.76	436.57	436.8	4415686.0
2024-03-05 10:30:00	QQQ	ETF	436.79	436.79	435.54	436.26	3627005.0
2024-03-05 11:00:00	QQQ	ETF	436.29	436.91	435.64	436.63	2651264.0
2024-03-05 11:30:00	QQQ	ETF	436.62	436.78	435.4803	436.24	2215193.0
2024-03-05 12:00:00	QQQ	ETF	436.208	437.118	436.1951	437.095	1737644.0
2024-03-05 12:30:00	QQQ	ETF	437.115	437.19	436.27	436.575	1602501.0

> showing 50 of 32,635 rows — these rows as CSV

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