PREVIEW / etf_30min / 2023-08-28

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-08-28.parquet
  size:    674 KB
  rows:    27,012

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
2023-08-28 04:00:00	SPY	ETF	437.3	440.88	437.3	440.88	2728.0
2023-08-28 04:30:00	SPY	ETF	440.86	440.93	440.61	440.64	6438.0
2023-08-28 05:00:00	SPY	ETF	440.54	440.54	440.26	440.47	3398.0
2023-08-28 05:30:00	SPY	ETF	440.71	440.82	440.55	440.57	5844.0
2023-08-28 06:00:00	SPY	ETF	440.58	440.58	440.15	440.3	9443.0
2023-08-28 06:30:00	SPY	ETF	440.3	440.61	440.3	440.53	12769.0
2023-08-28 07:00:00	SPY	ETF	440.5	440.82	440.43	440.79	37692.0
2023-08-28 07:30:00	SPY	ETF	440.64	440.91	440.5	440.901	35747.0
2023-08-28 08:00:00	SPY	ETF	440.7787	441.7	440.15	441.69	99050.0
2023-08-28 08:30:00	SPY	ETF	441.66	442.15	441.63	442.09	191484.0
2023-08-28 09:00:00	SPY	ETF	442.1	442.35	441.98	442.2	186047.0
2023-08-28 09:30:00	SPY	ETF	442.24	443.209	441.785	442.58	5923841.0
2023-08-28 10:00:00	SPY	ETF	442.6	443.18	442.18	443.179	3316027.0
2023-08-28 10:30:00	SPY	ETF	443.17	443.23	441.36	442.07	4082352.0
2023-08-28 11:00:00	SPY	ETF	442.07	442.08	441.2	441.46	3024092.0
2023-08-28 11:30:00	SPY	ETF	441.46	441.98	440.9	441.489	3271569.0
2023-08-28 12:00:00	SPY	ETF	441.49	441.7	440.955	441.21	2206369.0
2023-08-28 12:30:00	SPY	ETF	441.2116	442.62	441.015	442.58	2375779.0
2023-08-28 13:00:00	SPY	ETF	442.58	443.26	442.46	442.74	3372769.0
2023-08-28 13:30:00	SPY	ETF	442.76	442.97	440.86	441.14	3441465.0
2023-08-28 14:00:00	SPY	ETF	441.13	441.41	440.89	441.26	2976267.0
2023-08-28 14:30:00	SPY	ETF	441.26	441.96	440.99	441.85	2698686.0
2023-08-28 15:00:00	SPY	ETF	441.86	442.38	441.38	441.79	2944552.0
2023-08-28 15:30:00	SPY	ETF	441.79	443.4	441.65	442.72	8013369.0
2023-08-28 16:00:00	SPY	ETF	442.71	442.93	442.58	442.88	2530443.0
2023-08-28 16:30:00	SPY	ETF	442.88	442.96	442.84	442.94	35062.0
2023-08-28 17:00:00	SPY	ETF	442.95	442.99	439.97	442.96	1426446.0
2023-08-28 17:30:00	SPY	ETF	442.96	442.97	442.76	442.95	52840.0
2023-08-28 18:00:00	SPY	ETF	442.97	443.17	442.97	443.15	34240.0
2023-08-28 18:30:00	SPY	ETF	443.091	443.12	443.04	443.04	11330.0
2023-08-28 19:00:00	SPY	ETF	443.01	443.01	442.87	442.91	14234.0
2023-08-28 19:30:00	SPY	ETF	442.95	442.96	442.77	442.84	33429.0
2023-08-28 04:00:00	QQQ	ETF	364.5	365.35	364.5	365.32	20035.0
2023-08-28 04:30:00	QQQ	ETF	365.34	365.35	365.02	365.13	7348.0
2023-08-28 05:00:00	QQQ	ETF	365.07	365.07	364.54	365.01	7567.0
2023-08-28 05:30:00	QQQ	ETF	365.01	365.12	364.81	364.88	8879.0
2023-08-28 06:00:00	QQQ	ETF	364.78	364.78	364.54	364.63	7604.0
2023-08-28 06:30:00	QQQ	ETF	364.8	365.1	364.8	364.9	9214.0
2023-08-28 07:00:00	QQQ	ETF	364.9	365.33	364.88	365.11	45753.0
2023-08-28 07:30:00	QQQ	ETF	365.12	365.5	365.11	365.35	34806.0
2023-08-28 08:00:00	QQQ	ETF	365.15	366.08	364.27	366.08	134794.0
2023-08-28 08:30:00	QQQ	ETF	366.07	366.87	366.02	366.86	150470.0
2023-08-28 09:00:00	QQQ	ETF	366.81	367.2	366.49	367.0096	181242.0
2023-08-28 09:30:00	QQQ	ETF	366.99	367.71	364.71	365.89	5803532.0
2023-08-28 10:00:00	QQQ	ETF	365.91	366.93	365.54	366.87	2856178.0
2023-08-28 10:30:00	QQQ	ETF	366.87	366.97	364.63	365.4401	2801682.0
2023-08-28 11:00:00	QQQ	ETF	365.44	365.6	364.74	365.07	2127984.0
2023-08-28 11:30:00	QQQ	ETF	365.08	365.59	364.25	365.0401	2183375.0
2023-08-28 12:00:00	QQQ	ETF	365.03	365.18	364.49	364.76	1473478.0
2023-08-28 12:30:00	QQQ	ETF	364.76	366.45	364.55	366.4	1795265.0

> showing 50 of 27,012 rows — these rows as CSV

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