PREVIEW / etf_30min / 2024-04-24

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-04-24.parquet
  size:    791 KB
  rows:    31,590

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-24 04:00:00	SPY	ETF	506.74	506.97	506.58	506.58	23562.0
2024-04-24 04:30:00	SPY	ETF	506.6	506.76	506.3	506.31	12126.0
2024-04-24 05:00:00	SPY	ETF	506.31	506.4	506.05	506.1	10325.0
2024-04-24 05:30:00	SPY	ETF	506.23	506.24	505.6	505.86	26766.0
2024-04-24 06:00:00	SPY	ETF	505.89	506.33	505.89	506.32	18620.0
2024-04-24 06:30:00	SPY	ETF	506.33	506.34	505.83	505.96	13151.0
2024-04-24 07:00:00	SPY	ETF	505.99	506.58	505.9	506.54	162881.0
2024-04-24 07:30:00	SPY	ETF	506.5	506.89	506.45	506.83	96772.0
2024-04-24 08:00:00	SPY	ETF	506.02	507.6	505.8997	506.94	157020.0
2024-04-24 08:30:00	SPY	ETF	506.95	507.32	505.9	506.0301	271646.0
2024-04-24 09:00:00	SPY	ETF	506.03	506.62	505.77	506.56	223054.0
2024-04-24 09:30:00	SPY	ETF	506.56	507.37	505.93	506.2499	5577479.0
2024-04-24 10:00:00	SPY	ETF	506.24	507.1334	505.93	506.22	2982159.0
2024-04-24 10:30:00	SPY	ETF	506.24	506.43	504.98	505.24	2735926.0
2024-04-24 11:00:00	SPY	ETF	505.22	505.39	504.045	504.62	3515271.0
2024-04-24 11:30:00	SPY	ETF	504.63	505.12	503.6	503.75	2532295.0
2024-04-24 12:00:00	SPY	ETF	503.74	504.41	503.44	504.085	2370890.0
2024-04-24 12:30:00	SPY	ETF	504.09	504.4	503.13	504.325	2521383.0
2024-04-24 13:00:00	SPY	ETF	504.32	505.26	504.06	505.21	1992704.0
2024-04-24 13:30:00	SPY	ETF	505.21	506.545	505.195	506.43	2849488.0
2024-04-24 14:00:00	SPY	ETF	506.44	506.51	504.85	505.0417	2394857.0
2024-04-24 14:30:00	SPY	ETF	505.05	505.26	504.4	504.43	1607243.0
2024-04-24 15:00:00	SPY	ETF	504.44	506.185	504.23	505.85	2498374.0
2024-04-24 15:30:00	SPY	ETF	505.85	506.19	505.45	505.47	4857980.0
2024-04-24 16:00:00	SPY	ETF	505.46	505.78	502.23	503.1	3197406.0
2024-04-24 16:30:00	SPY	ETF	503.11	503.15	502.58	502.85	279856.0
2024-04-24 17:00:00	SPY	ETF	502.83	502.9	501.97	501.97	127891.0
2024-04-24 17:30:00	SPY	ETF	501.97	502.0	501.63	501.9	81779.0
2024-04-24 18:00:00	SPY	ETF	501.9	502.61	501.9	502.61	112905.0
2024-04-24 18:30:00	SPY	ETF	502.65	502.67	502.17	502.34	74273.0
2024-04-24 19:00:00	SPY	ETF	502.41	502.69	502.41	502.61	50340.0
2024-04-24 19:30:00	SPY	ETF	502.66	502.69	502.12	502.45	29997.0
2024-04-24 04:00:00	QQQ	ETF	428.06	428.13	427.67	427.84	61083.0
2024-04-24 04:30:00	QQQ	ETF	427.75	427.9	427.21	427.35	27969.0
2024-04-24 05:00:00	QQQ	ETF	427.39	427.64	427.14	427.23	29868.0
2024-04-24 05:30:00	QQQ	ETF	427.22	427.3	426.71	427.02	34264.0
2024-04-24 06:00:00	QQQ	ETF	426.97	427.71	426.94	427.65	90382.0
2024-04-24 06:30:00	QQQ	ETF	427.62	427.68	427.23	427.33	43980.0
2024-04-24 07:00:00	QQQ	ETF	427.35	427.82	427.27	427.8	170948.0
2024-04-24 07:30:00	QQQ	ETF	427.82	428.14	427.67	428.12	180328.0
2024-04-24 08:00:00	QQQ	ETF	427.5	428.48	425.07	428.34	398223.0
2024-04-24 08:30:00	QQQ	ETF	428.33	428.73	427.37	427.55	277595.0
2024-04-24 09:00:00	QQQ	ETF	427.54	428.25	427.16	428.25	244532.0
2024-04-24 09:30:00	QQQ	ETF	428.2	429.73	427.72	428.31	5178242.0
2024-04-24 10:00:00	QQQ	ETF	428.32	429.25	427.71	428.07	2959336.0
2024-04-24 10:30:00	QQQ	ETF	428.09	428.43	426.8825	427.26	2052683.0
2024-04-24 11:00:00	QQQ	ETF	427.265	427.43	425.855	426.41	2174032.0
2024-04-24 11:30:00	QQQ	ETF	426.43	426.9799	425.05	425.1599	2105137.0
2024-04-24 12:00:00	QQQ	ETF	425.14	425.76	424.55	425.19	1887550.0
2024-04-24 12:30:00	QQQ	ETF	425.19	425.72	424.2	425.55	1918139.0

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

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