PREVIEW / etf_30min / 2024-01-25

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-01-25.parquet
  size:    805 KB
  rows:    31,749

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-01-25 04:00:00	SPY	ETF	485.79	485.89	485.63	485.8	9288.0
2024-01-25 04:30:00	SPY	ETF	485.9	486.09	485.9	485.96	4638.0
2024-01-25 05:00:00	SPY	ETF	485.85	485.85	485.69	485.69	2649.0
2024-01-25 05:30:00	SPY	ETF	485.66	485.9	485.66	485.77	1702.0
2024-01-25 06:00:00	SPY	ETF	485.77	485.97	485.77	485.97	1048.0
2024-01-25 06:30:00	SPY	ETF	485.66	486.0	485.62	485.99	9605.0
2024-01-25 07:00:00	SPY	ETF	486.0	486.13	485.69	485.9	25015.0
2024-01-25 07:30:00	SPY	ETF	485.85	486.02	485.411	485.411	26279.0
2024-01-25 08:00:00	SPY	ETF	486.04	486.13	485.39	485.94	114199.0
2024-01-25 08:30:00	SPY	ETF	485.97	487.5	485.53	487.34	595095.0
2024-01-25 09:00:00	SPY	ETF	487.3401	487.71	487.14	487.56	290581.0
2024-01-25 09:30:00	SPY	ETF	487.56	487.7	486.77	487.32	5379248.0
2024-01-25 10:00:00	SPY	ETF	487.33	488.305	486.9	488.08	4295312.0
2024-01-25 10:30:00	SPY	ETF	488.09	488.1701	486.86	487.16	4138294.0
2024-01-25 11:00:00	SPY	ETF	487.17	487.84	486.82	487.78	3072203.0
2024-01-25 11:30:00	SPY	ETF	487.79	488.11	487.26	487.61	2960444.0
2024-01-25 12:00:00	SPY	ETF	487.62	487.75	486.41	486.63	3752198.0
2024-01-25 12:30:00	SPY	ETF	486.65	486.78	486.17	486.5807	2729792.0
2024-01-25 13:00:00	SPY	ETF	486.6	487.31	486.08	486.274	3285920.0
2024-01-25 13:30:00	SPY	ETF	486.28	486.84	485.79	485.95	2811292.0
2024-01-25 14:00:00	SPY	ETF	485.95	486.275	485.39	486.175	4098066.0
2024-01-25 14:30:00	SPY	ETF	486.18	486.665	485.79	486.66	2855558.0
2024-01-25 15:00:00	SPY	ETF	486.665	486.9	486.29	486.55	2656530.0
2024-01-25 15:30:00	SPY	ETF	486.55	488.04	486.425	488.0	10149166.0
2024-01-25 16:00:00	SPY	ETF	488.01	488.14	487.2218	487.96	3002784.0
2024-01-25 16:30:00	SPY	ETF	487.95	488.2	487.5895	487.5895	276807.0
2024-01-25 17:00:00	SPY	ETF	487.58	487.65	487.37	487.4	33584.0
2024-01-25 17:30:00	SPY	ETF	487.4	487.5	487.4	487.42	18460.0
2024-01-25 18:00:00	SPY	ETF	487.47	487.49	486.95	486.95	96790.0
2024-01-25 18:30:00	SPY	ETF	486.95	487.1898	486.94	487.06	15951.0
2024-01-25 19:00:00	SPY	ETF	487.06	487.12	486.84	486.94	10560.0
2024-01-25 19:30:00	SPY	ETF	487.0	487.14	486.92	486.94	54514.0
2024-01-25 04:00:00	QQQ	ETF	426.12	426.4	425.8	426.01	25669.0
2024-01-25 04:30:00	QQQ	ETF	426.04	426.38	426.04	426.27	35258.0
2024-01-25 05:00:00	QQQ	ETF	426.08	426.1	425.8	425.86	16676.0
2024-01-25 05:30:00	QQQ	ETF	425.88	425.95	425.7	425.76	12682.0
2024-01-25 06:00:00	QQQ	ETF	425.92	425.99	425.71	425.87	18361.0
2024-01-25 06:30:00	QQQ	ETF	425.89	426.58	425.79	426.58	53617.0
2024-01-25 07:00:00	QQQ	ETF	426.53	426.97	426.32	426.64	81353.0
2024-01-25 07:30:00	QQQ	ETF	426.57	426.95	426.3	426.38	65112.0
2024-01-25 08:00:00	QQQ	ETF	426.83	426.96	425.511	426.59	144212.0
2024-01-25 08:30:00	QQQ	ETF	426.57	428.2	425.88	427.97	493540.0
2024-01-25 09:00:00	QQQ	ETF	428.04	428.45	427.8	428.38	171739.0
2024-01-25 09:30:00	QQQ	ETF	428.35	428.45	426.85	427.06	4513887.0
2024-01-25 10:00:00	QQQ	ETF	427.06	428.66	426.59	428.5204	2760463.0
2024-01-25 10:30:00	QQQ	ETF	428.53	428.715	427.25	427.98	2372667.0
2024-01-25 11:00:00	QQQ	ETF	427.98	428.465	427.44	428.38	1649165.0
2024-01-25 11:30:00	QQQ	ETF	428.4	429.04	427.88	428.3701	1865650.0
2024-01-25 12:00:00	QQQ	ETF	428.39	428.57	427.03	427.29	2249144.0
2024-01-25 12:30:00	QQQ	ETF	427.29	427.4502	426.18	426.63	2012664.0

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

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