PREVIEW / etf_30min / 2023-06-29

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-06-29.parquet
  size:    699 KB
  rows:    27,823

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-06-29 04:00:00	SPY	ETF	436.33	436.9	436.25	436.82	27081.0
2023-06-29 04:30:00	SPY	ETF	436.67	436.97	436.66	436.94	6963.0
2023-06-29 05:00:00	SPY	ETF	436.9	436.98	436.75	436.86	5989.0
2023-06-29 05:30:00	SPY	ETF	436.83	437.34	436.83	437.32	15496.0
2023-06-29 06:00:00	SPY	ETF	437.29	437.75	437.18	437.63	17137.0
2023-06-29 06:30:00	SPY	ETF	437.65	437.75	437.54	437.6	13448.0
2023-06-29 07:00:00	SPY	ETF	437.59	437.78	437.55	437.78	48753.0
2023-06-29 07:30:00	SPY	ETF	437.76	437.8	437.43	437.55	63404.0
2023-06-29 08:00:00	SPY	ETF	437.6	437.8	436.32	437.79	123866.0
2023-06-29 08:30:00	SPY	ETF	437.75	438.18	436.57	436.75	583359.0
2023-06-29 09:00:00	SPY	ETF	436.77	436.77	435.7	435.95	522574.0
2023-06-29 09:30:00	SPY	ETF	435.95	436.98	435.54	436.7	5673856.0
2023-06-29 10:00:00	SPY	ETF	436.73	437.37	436.06	436.68	4379540.0
2023-06-29 10:30:00	SPY	ETF	436.69	436.94	435.91	436.4	3917338.0
2023-06-29 11:00:00	SPY	ETF	436.4	437.69	436.32	437.63	3383315.0
2023-06-29 11:30:00	SPY	ETF	437.6362	437.88	437.21	437.71	3256244.0
2023-06-29 12:00:00	SPY	ETF	437.72	438.195	437.26	438.09	2774775.0
2023-06-29 12:30:00	SPY	ETF	438.0824	438.28	437.41	437.68	2793867.0
2023-06-29 13:00:00	SPY	ETF	437.67	437.76	436.93	437.72	2624692.0
2023-06-29 13:30:00	SPY	ETF	437.72	437.7699	436.96	437.1	2170600.0
2023-06-29 14:00:00	SPY	ETF	437.095	437.3	436.39	437.22	3186694.0
2023-06-29 14:30:00	SPY	ETF	437.23	437.4108	436.86	437.4108	1923863.0
2023-06-29 15:00:00	SPY	ETF	437.42	437.8	437.35	437.668	2473204.0
2023-06-29 15:30:00	SPY	ETF	437.66	438.17	437.145	438.14	8753576.0
2023-06-29 16:00:00	SPY	ETF	438.15	438.29	437.99	438.25	2297717.0
2023-06-29 16:30:00	SPY	ETF	438.24	438.29	438.12	438.12	163824.0
2023-06-29 17:00:00	SPY	ETF	438.11	438.25	438.11	438.2	265419.0
2023-06-29 17:30:00	SPY	ETF	438.22	438.22	438.11	438.11	3299.0
2023-06-29 18:00:00	SPY	ETF	438.11	438.21	438.01	438.21	77705.0
2023-06-29 18:30:00	SPY	ETF	438.19	438.19	438.08	438.16	14987.0
2023-06-29 19:00:00	SPY	ETF	438.2	438.28	438.18	438.25	7912.0
2023-06-29 19:30:00	SPY	ETF	438.22	438.39	438.21	438.28	28490.0
2023-06-29 04:00:00	QQQ	ETF	364.52	365.3	364.52	365.26	31965.0
2023-06-29 04:30:00	QQQ	ETF	365.23	365.26	365.0	365.26	13400.0
2023-06-29 05:00:00	QQQ	ETF	365.22	365.24	365.0	365.06	4790.0
2023-06-29 05:30:00	QQQ	ETF	365.11	365.67	365.1	365.66	11134.0
2023-06-29 06:00:00	QQQ	ETF	365.6	366.02	365.43	365.9	13263.0
2023-06-29 06:30:00	QQQ	ETF	365.96	366.16	365.86	365.91	20644.0
2023-06-29 07:00:00	QQQ	ETF	365.85	366.01	365.74	366.01	55150.0
2023-06-29 07:30:00	QQQ	ETF	366.01	366.01	365.56	365.76	64366.0
2023-06-29 08:00:00	QQQ	ETF	365.9098	366.1	364.5	366.0	309506.0
2023-06-29 08:30:00	QQQ	ETF	366.0	366.25	364.4	364.7	797069.0
2023-06-29 09:00:00	QQQ	ETF	364.79	364.83	363.87	364.24	523354.0
2023-06-29 09:30:00	QQQ	ETF	364.24	364.89	363.3	363.79	5104399.0
2023-06-29 10:00:00	QQQ	ETF	363.81	364.6	362.27	362.9101	3555221.0
2023-06-29 10:30:00	QQQ	ETF	362.92	363.472	362.14	363.1138	2668935.0
2023-06-29 11:00:00	QQQ	ETF	363.1284	364.69	362.98	364.5899	2333421.0
2023-06-29 11:30:00	QQQ	ETF	364.585	364.69	363.9309	364.3775	1724983.0
2023-06-29 12:00:00	QQQ	ETF	364.38	364.78	363.5199	364.26	1807094.0
2023-06-29 12:30:00	QQQ	ETF	364.27	364.54	363.2575	363.54	1687930.0

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

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