PREVIEW / etf_30min / 2024-02-02

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-02-02.parquet
  size:    825 KB
  rows:    32,599

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-02-02 04:00:00	SPY	ETF	491.95	492.36	491.87	491.88	29560.0
2024-02-02 04:30:00	SPY	ETF	491.86	491.87	491.56	491.8	23061.0
2024-02-02 05:00:00	SPY	ETF	491.83	491.92	491.83	491.92	10166.0
2024-02-02 05:30:00	SPY	ETF	492.0	492.04	491.88	491.92	15568.0
2024-02-02 06:00:00	SPY	ETF	491.89	492.03	491.76	491.97	8900.0
2024-02-02 06:30:00	SPY	ETF	492.22	492.24	492.09	492.22	15831.0
2024-02-02 07:00:00	SPY	ETF	492.23	492.66	492.0	492.62	48780.0
2024-02-02 07:30:00	SPY	ETF	492.6	492.65	492.39	492.55	77936.0
2024-02-02 08:00:00	SPY	ETF	492.2103	492.71	491.6	492.22	280666.0
2024-02-02 08:30:00	SPY	ETF	492.1	492.1	489.11	489.31	1985618.0
2024-02-02 09:00:00	SPY	ETF	489.29	489.72	488.95	489.64	706406.0
2024-02-02 09:30:00	SPY	ETF	489.66	490.95	489.3	490.49	7117472.0
2024-02-02 10:00:00	SPY	ETF	490.43	491.335	490.0	490.85	4759409.0
2024-02-02 10:30:00	SPY	ETF	490.86	492.42	490.34	492.18	5893541.0
2024-02-02 11:00:00	SPY	ETF	492.19	493.07	491.635	492.92	3916924.0
2024-02-02 11:30:00	SPY	ETF	492.92	494.04	492.92	493.57	4860136.0
2024-02-02 12:00:00	SPY	ETF	493.57	494.45	493.175	494.37	3654788.0
2024-02-02 12:30:00	SPY	ETF	494.38	494.66	492.25	493.64	5676359.0
2024-02-02 13:00:00	SPY	ETF	493.67	494.545	493.51	493.75	3438567.0
2024-02-02 13:30:00	SPY	ETF	493.75	494.42	493.314	494.275	2679385.0
2024-02-02 14:00:00	SPY	ETF	494.3	495.39	494.3	494.95	4331285.0
2024-02-02 14:30:00	SPY	ETF	494.99	495.75	494.9	495.67	4021483.0
2024-02-02 15:00:00	SPY	ETF	495.68	496.05	495.175	495.895	3994959.0
2024-02-02 15:30:00	SPY	ETF	495.905	495.91	494.26	494.27	11706766.0
2024-02-02 16:00:00	SPY	ETF	494.26	494.7103	492.2469	494.16	4495833.0
2024-02-02 16:30:00	SPY	ETF	494.14	494.15	493.63	493.63	229499.0
2024-02-02 17:00:00	SPY	ETF	493.76	494.3706	493.51	494.0	1907382.0
2024-02-02 17:30:00	SPY	ETF	494.01	494.35	494.01	494.3	50235.0
2024-02-02 18:00:00	SPY	ETF	494.3	494.39	494.23	494.2596	18308.0
2024-02-02 18:30:00	SPY	ETF	494.25	494.25	494.19	494.19	6274.0
2024-02-02 19:00:00	SPY	ETF	494.19	494.19	493.1	493.85	47651.0
2024-02-02 19:30:00	SPY	ETF	493.86	493.86	493.5999	493.61	16274.0
2024-02-02 04:00:00	QQQ	ETF	426.44	426.86	426.26	426.31	38180.0
2024-02-02 04:30:00	QQQ	ETF	426.32	426.36	426.03	426.17	47003.0
2024-02-02 05:00:00	QQQ	ETF	426.29	426.49	426.01	426.49	20051.0
2024-02-02 05:30:00	QQQ	ETF	426.49	426.66	426.23	426.34	7268.0
2024-02-02 06:00:00	QQQ	ETF	426.22	426.4	426.11	426.33	26208.0
2024-02-02 06:30:00	QQQ	ETF	426.34	426.47	426.3	426.45	35102.0
2024-02-02 07:00:00	QQQ	ETF	426.46	427.06	426.14	426.96	217991.0
2024-02-02 07:30:00	QQQ	ETF	426.94	426.98	426.48	426.62	75005.0
2024-02-02 08:00:00	QQQ	ETF	426.5	427.05	421.564	426.15	269643.0
2024-02-02 08:30:00	QQQ	ETF	426.13	426.15	423.2301	423.53	1677052.0
2024-02-02 09:00:00	QQQ	ETF	423.53	424.1	423.2499	423.8	676341.0
2024-02-02 09:30:00	QQQ	ETF	423.8	426.62	422.79	425.84	7027962.0
2024-02-02 10:00:00	QQQ	ETF	425.8	426.55	425.1601	425.66	3924604.0
2024-02-02 10:30:00	QQQ	ETF	425.67	427.61	424.8	426.96	3413872.0
2024-02-02 11:00:00	QQQ	ETF	426.98	427.84	426.18	427.74	2440292.0
2024-02-02 11:30:00	QQQ	ETF	427.74	428.85	427.71	428.4801	2721746.0
2024-02-02 12:00:00	QQQ	ETF	428.5	429.67	428.26	429.61	2024558.0
2024-02-02 12:30:00	QQQ	ETF	429.63	429.79	427.55	428.67	3661018.0

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

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