PREVIEW / etf_30min / 2024-02-05

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-02-05.parquet
  size:    823 KB
  rows:    32,529

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-05 04:00:00	SPY	ETF	493.65	493.73	493.06	493.12	13856.0
2024-02-05 04:30:00	SPY	ETF	493.18	493.27	492.84	493.04	8901.0
2024-02-05 05:00:00	SPY	ETF	493.05	493.48	493.05	493.48	7943.0
2024-02-05 05:30:00	SPY	ETF	493.48	493.77	493.48	493.57	7084.0
2024-02-05 06:00:00	SPY	ETF	493.56	493.65	493.47	493.61	5678.0
2024-02-05 06:30:00	SPY	ETF	493.55	493.64	493.45	493.47	5305.0
2024-02-05 07:00:00	SPY	ETF	493.46	493.94	493.3	493.67	34537.0
2024-02-05 07:30:00	SPY	ETF	493.68	493.94	493.62	493.85	27611.0
2024-02-05 08:00:00	SPY	ETF	493.3908	493.93	492.8604	493.17	133240.0
2024-02-05 08:30:00	SPY	ETF	493.18	493.25	492.78	492.89	138295.0
2024-02-05 09:00:00	SPY	ETF	492.95	493.7	492.83	493.7	261767.0
2024-02-05 09:30:00	SPY	ETF	493.71	493.71	492.88	493.44	5248051.0
2024-02-05 10:00:00	SPY	ETF	493.39	493.44	490.79	491.3901	6301141.0
2024-02-05 10:30:00	SPY	ETF	491.4	491.5	490.23	490.855	4330592.0
2024-02-05 11:00:00	SPY	ETF	490.86	491.83	490.7	491.325	2954886.0
2024-02-05 11:30:00	SPY	ETF	491.33	492.165	491.33	492.14	2846693.0
2024-02-05 12:00:00	SPY	ETF	492.14	492.75	492.03	492.735	2691686.0
2024-02-05 12:30:00	SPY	ETF	492.75	493.39	492.75	493.03	2948569.0
2024-02-05 13:00:00	SPY	ETF	493.03	493.5	492.58	492.6	2308971.0
2024-02-05 13:30:00	SPY	ETF	492.61	493.225	492.58	493.14	1748645.0
2024-02-05 14:00:00	SPY	ETF	493.14	493.55	492.87	493.48	2090195.0
2024-02-05 14:30:00	SPY	ETF	493.47	494.17	493.42	493.98	2990354.0
2024-02-05 15:00:00	SPY	ETF	494.0	494.03	492.59	493.67	3331555.0
2024-02-05 15:30:00	SPY	ETF	493.66	493.95	492.52	492.58	9275375.0
2024-02-05 16:00:00	SPY	ETF	492.57	493.306	491.4696	492.38	3859693.0
2024-02-05 16:30:00	SPY	ETF	492.35	492.46	492.22	492.46	272192.0
2024-02-05 17:00:00	SPY	ETF	492.47	492.47	492.36	492.44	19834.0
2024-02-05 17:30:00	SPY	ETF	492.43	492.55	492.3	492.43	219348.0
2024-02-05 18:00:00	SPY	ETF	492.42	492.6	492.42	492.48	30349.0
2024-02-05 18:30:00	SPY	ETF	492.46	492.46	492.19	492.22	9283.0
2024-02-05 19:00:00	SPY	ETF	492.3	492.47	492.3	492.47	3281.0
2024-02-05 19:30:00	SPY	ETF	492.46	492.59	492.46	492.57	23169.0
2024-02-05 04:00:00	QQQ	ETF	428.75	429.05	428.26	428.26	68111.0
2024-02-05 04:30:00	QQQ	ETF	428.31	428.49	427.9	428.13	37528.0
2024-02-05 05:00:00	QQQ	ETF	428.13	428.62	428.12	428.62	25308.0
2024-02-05 05:30:00	QQQ	ETF	428.76	429.04	428.73	428.97	30831.0
2024-02-05 06:00:00	QQQ	ETF	428.93	429.06	428.74	429.03	17730.0
2024-02-05 06:30:00	QQQ	ETF	428.89	429.01	428.58	428.69	19839.0
2024-02-05 07:00:00	QQQ	ETF	428.7	429.379	428.52	428.99	132122.0
2024-02-05 07:30:00	QQQ	ETF	428.99	429.38	428.94	429.34	77160.0
2024-02-05 08:00:00	QQQ	ETF	428.9892	429.44	428.0804	428.7	195635.0
2024-02-05 08:30:00	QQQ	ETF	428.68	428.77	428.32	428.51	136087.0
2024-02-05 09:00:00	QQQ	ETF	428.6	429.12	428.45	429.04	178227.0
2024-02-05 09:30:00	QQQ	ETF	429.07	429.42	427.95	428.6501	4332014.0
2024-02-05 10:00:00	QQQ	ETF	428.65	428.65	426.12	426.74	3752462.0
2024-02-05 10:30:00	QQQ	ETF	426.74	426.9	425.0	425.94	2701882.0
2024-02-05 11:00:00	QQQ	ETF	425.94	426.92	425.7387	426.395	2019661.0
2024-02-05 11:30:00	QQQ	ETF	426.39	427.62	426.39	427.55	1734241.0
2024-02-05 12:00:00	QQQ	ETF	427.55	428.25	427.42	428.22	1752801.0
2024-02-05 12:30:00	QQQ	ETF	428.22	428.98	428.22	428.4	2081564.0

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

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