PREVIEW / etf_30min / 2024-04-17

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-04-17.parquet
  size:    794 KB
  rows:    32,241

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-17 04:00:00	SPY	ETF	504.15	504.9	504.15	504.82	16495.0
2024-04-17 04:30:00	SPY	ETF	504.66	505.48	504.66	505.24	19581.0
2024-04-17 05:00:00	SPY	ETF	505.15	505.15	504.56	504.77	21192.0
2024-04-17 05:30:00	SPY	ETF	504.92	505.5	504.92	505.35	8962.0
2024-04-17 06:00:00	SPY	ETF	505.49	505.67	505.33	505.61	12669.0
2024-04-17 06:30:00	SPY	ETF	505.75	506.02	505.5	505.54	137561.0
2024-04-17 07:00:00	SPY	ETF	505.56	505.75	504.9	505.38	189410.0
2024-04-17 07:30:00	SPY	ETF	505.36	505.58	504.94	505.07	75954.0
2024-04-17 08:00:00	SPY	ETF	505.62	506.05	502.25	504.94	258290.0
2024-04-17 08:30:00	SPY	ETF	504.8	505.57	504.77	505.36	139027.0
2024-04-17 09:00:00	SPY	ETF	505.35	506.32	505.27	506.05	338661.0
2024-04-17 09:30:00	SPY	ETF	506.05	506.22	505.0	505.29	5559144.0
2024-04-17 10:00:00	SPY	ETF	505.295	505.355	503.45	504.38	4146544.0
2024-04-17 10:30:00	SPY	ETF	504.36	504.51	502.19	502.9	3362651.0
2024-04-17 11:00:00	SPY	ETF	502.91	504.01	502.09	502.1	3253341.0
2024-04-17 11:30:00	SPY	ETF	502.1	502.18	501.01	501.73	3811202.0
2024-04-17 12:00:00	SPY	ETF	501.71	501.79	500.17	500.48	4465622.0
2024-04-17 12:30:00	SPY	ETF	500.48	500.57	499.12	499.89	4675199.0
2024-04-17 13:00:00	SPY	ETF	499.91	501.79	499.69	501.77	4104267.0
2024-04-17 13:30:00	SPY	ETF	501.8	502.56	501.07	502.4	3304313.0
2024-04-17 14:00:00	SPY	ETF	502.41	502.54	501.38	501.86	2820885.0
2024-04-17 14:30:00	SPY	ETF	501.87	504.03	501.3	501.59	4448756.0
2024-04-17 15:00:00	SPY	ETF	501.59	501.59	500.36	500.7197	4307126.0
2024-04-17 15:30:00	SPY	ETF	500.71	501.82	500.41	500.5	8450318.0
2024-04-17 16:00:00	SPY	ETF	500.49	500.63	500.05	500.6	2415579.0
2024-04-17 16:30:00	SPY	ETF	500.61	500.65	500.47	500.57	180578.0
2024-04-17 17:00:00	SPY	ETF	500.62	500.78	500.62	500.78	66154.0
2024-04-17 17:30:00	SPY	ETF	500.78	500.89	500.64	500.72	47213.0
2024-04-17 18:00:00	SPY	ETF	500.72	500.99	500.72	500.95	39053.0
2024-04-17 18:30:00	SPY	ETF	500.87	500.961	500.74	500.91	11254.0
2024-04-17 19:00:00	SPY	ETF	500.92	501.09	500.73	500.83	12327.0
2024-04-17 19:30:00	SPY	ETF	500.84	501.08	500.84	501.06	43323.0
2024-04-17 04:00:00	QQQ	ETF	431.28	431.83	430.87	431.77	28810.0
2024-04-17 04:30:00	QQQ	ETF	431.53	432.25	431.5	431.93	53387.0
2024-04-17 05:00:00	QQQ	ETF	431.99	432.0	431.39	431.67	34252.0
2024-04-17 05:30:00	QQQ	ETF	431.74	432.4	431.58	432.4	19102.0
2024-04-17 06:00:00	QQQ	ETF	432.41	432.54	432.07	432.37	46989.0
2024-04-17 06:30:00	QQQ	ETF	432.58	432.72	432.17	432.17	25612.0
2024-04-17 07:00:00	QQQ	ETF	432.27	432.6	432.0	432.34	78677.0
2024-04-17 07:30:00	QQQ	ETF	432.29	432.5	431.85	431.92	84130.0
2024-04-17 08:00:00	QQQ	ETF	432.39	432.61	429.0	431.91	189369.0
2024-04-17 08:30:00	QQQ	ETF	431.88	432.64	431.87	432.47	99170.0
2024-04-17 09:00:00	QQQ	ETF	432.41	433.33	432.35	433.08	269831.0
2024-04-17 09:30:00	QQQ	ETF	433.1	433.12	431.11	431.52	3762645.0
2024-04-17 10:00:00	QQQ	ETF	431.57	431.6	429.53	430.54	3419940.0
2024-04-17 10:30:00	QQQ	ETF	430.54	430.73	428.46	429.36	2346127.0
2024-04-17 11:00:00	QQQ	ETF	429.37	430.53	428.53	428.53	2403900.0
2024-04-17 11:30:00	QQQ	ETF	428.52	428.66	427.5401	428.04	2672271.0
2024-04-17 12:00:00	QQQ	ETF	428.04	428.11	426.24	426.47	3307212.0
2024-04-17 12:30:00	QQQ	ETF	426.46	426.64	424.9	425.51	3174615.0

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

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