PREVIEW / etf_30min / 2024-02-28

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-02-28.parquet
  size:    795 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-02-28 04:00:00	SPY	ETF	505.78	506.0	505.25	505.25	12156.0
2024-02-28 04:30:00	SPY	ETF	505.19	505.24	504.5	504.6	60256.0
2024-02-28 05:00:00	SPY	ETF	504.69	505.17	504.6	505.16	9651.0
2024-02-28 05:30:00	SPY	ETF	505.05	505.58	505.02	505.39	19950.0
2024-02-28 06:00:00	SPY	ETF	505.35	505.53	505.21	505.53	11399.0
2024-02-28 06:30:00	SPY	ETF	505.56	505.72	505.33	505.33	11822.0
2024-02-28 07:00:00	SPY	ETF	505.52	505.58	505.1	505.38	92823.0
2024-02-28 07:30:00	SPY	ETF	505.39	505.54	504.96	504.96	43682.0
2024-02-28 08:00:00	SPY	ETF	505.41	506.98	504.7396	505.31	215082.0
2024-02-28 08:30:00	SPY	ETF	505.27	505.9697	505.15	505.73	200265.0
2024-02-28 09:00:00	SPY	ETF	505.72	505.72	505.25	505.33	121585.0
2024-02-28 09:30:00	SPY	ETF	505.33	505.82	504.96	505.33	3666709.0
2024-02-28 10:00:00	SPY	ETF	505.33	505.99	505.24	505.6699	2845948.0
2024-02-28 10:30:00	SPY	ETF	505.67	506.52	505.61	506.475	2584392.0
2024-02-28 11:00:00	SPY	ETF	506.48	506.855	506.38	506.51	2242937.0
2024-02-28 11:30:00	SPY	ETF	506.51	506.8	506.165	506.57	1897572.0
2024-02-28 12:00:00	SPY	ETF	506.57	506.6799	505.88	506.03	1934814.0
2024-02-28 12:30:00	SPY	ETF	506.03	506.05	505.445	505.8799	2279748.0
2024-02-28 13:00:00	SPY	ETF	505.87	506.52	505.49	506.496	1912354.0
2024-02-28 13:30:00	SPY	ETF	506.5	506.78	506.34	506.63	1906492.0
2024-02-28 14:00:00	SPY	ETF	506.63	506.6987	505.53	505.755	2715406.0
2024-02-28 14:30:00	SPY	ETF	505.75	505.87	505.1776	505.845	2466496.0
2024-02-28 15:00:00	SPY	ETF	505.85	506.27	505.5	506.12	2373560.0
2024-02-28 15:30:00	SPY	ETF	506.12	506.27	505.34	506.19	7312877.0
2024-02-28 16:00:00	SPY	ETF	506.19	506.26	504.96	505.01	3918994.0
2024-02-28 16:30:00	SPY	ETF	505.01	505.09	504.74	505.0007	349375.0
2024-02-28 17:00:00	SPY	ETF	505.03	505.17	504.8	505.05	100219.0
2024-02-28 17:30:00	SPY	ETF	505.06	505.1	504.8	505.1	33917.0
2024-02-28 18:00:00	SPY	ETF	505.1	505.4	505.1	505.3	78528.0
2024-02-28 18:30:00	SPY	ETF	505.36	505.36	505.07	505.15	14461.0
2024-02-28 19:00:00	SPY	ETF	505.23	505.47	505.23	505.45	9165.0
2024-02-28 19:30:00	SPY	ETF	505.46	505.82	505.44	505.77	44698.0
2024-02-28 04:00:00	QQQ	ETF	436.18	436.39	435.56	435.56	38169.0
2024-02-28 04:30:00	QQQ	ETF	435.5	435.58	434.71	434.79	64948.0
2024-02-28 05:00:00	QQQ	ETF	434.87	435.55	434.81	435.43	25160.0
2024-02-28 05:30:00	QQQ	ETF	435.35	435.99	435.3	435.87	14462.0
2024-02-28 06:00:00	QQQ	ETF	435.87	436.0	435.66	435.99	13586.0
2024-02-28 06:30:00	QQQ	ETF	435.9	436.23	435.78	435.99	20180.0
2024-02-28 07:00:00	QQQ	ETF	435.99	436.29	435.69	435.94	92585.0
2024-02-28 07:30:00	QQQ	ETF	435.92	436.09	435.41	435.48	83635.0
2024-02-28 08:00:00	QQQ	ETF	435.889	437.928	434.9	435.6	109968.0
2024-02-28 08:30:00	QQQ	ETF	435.6	436.34	435.37	435.981	297009.0
2024-02-28 09:00:00	QQQ	ETF	435.99	435.99	435.3	435.45	172722.0
2024-02-28 09:30:00	QQQ	ETF	435.44	435.98	434.3	434.77	3680698.0
2024-02-28 10:00:00	QQQ	ETF	434.76	435.42	434.37	434.93	2226614.0
2024-02-28 10:30:00	QQQ	ETF	434.95	435.6	434.89	435.544	1465209.0
2024-02-28 11:00:00	QQQ	ETF	435.55	436.5	435.55	436.33	1610152.0
2024-02-28 11:30:00	QQQ	ETF	436.35	436.67	436.16	436.39	1086425.0
2024-02-28 12:00:00	QQQ	ETF	436.4	436.47	435.49	435.61	1138671.0
2024-02-28 12:30:00	QQQ	ETF	435.6101	435.62	434.78	435.29	1657421.0

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

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