PREVIEW / etf_30min / 2023-07-07

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-07-07.parquet
  size:    704 KB
  rows:    27,658

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-07-07 04:00:00	SPY	ETF	439.02	439.14	438.69	439.12	16167.0
2023-07-07 04:30:00	SPY	ETF	439.12	439.28	438.92	439.25	10218.0
2023-07-07 05:00:00	SPY	ETF	439.24	439.73	439.24	439.55	9710.0
2023-07-07 05:30:00	SPY	ETF	439.56	439.6	439.4	439.56	2618.0
2023-07-07 06:00:00	SPY	ETF	439.4	439.5	439.17	439.47	4779.0
2023-07-07 06:30:00	SPY	ETF	439.5	439.51	439.41	439.46	3803.0
2023-07-07 07:00:00	SPY	ETF	439.55	439.67	439.39	439.45	19478.0
2023-07-07 07:30:00	SPY	ETF	439.42	439.61	439.33	439.33	37644.0
2023-07-07 08:00:00	SPY	ETF	439.6	439.66	438.77	439.6	258726.0
2023-07-07 08:30:00	SPY	ETF	439.71	440.49	438.6039	439.07	1124822.0
2023-07-07 09:00:00	SPY	ETF	439.03	439.25	438.3	438.64	328793.0
2023-07-07 09:30:00	SPY	ETF	438.63	440.2	438.47	440.16	4816116.0
2023-07-07 10:00:00	SPY	ETF	440.16	440.25	439.29	439.4719	3282050.0
2023-07-07 10:30:00	SPY	ETF	439.475	439.94	438.82	439.87	2831816.0
2023-07-07 11:00:00	SPY	ETF	439.86	440.14	439.69	439.9309	1910516.0
2023-07-07 11:30:00	SPY	ETF	439.96	440.4	439.8913	440.37	2391143.0
2023-07-07 12:00:00	SPY	ETF	440.38	441.07	440.36	441.05	3405181.0
2023-07-07 12:30:00	SPY	ETF	441.06	442.29	441.06	442.26	5438994.0
2023-07-07 13:00:00	SPY	ETF	442.255	442.64	442.225	442.61	3112622.0
2023-07-07 13:30:00	SPY	ETF	442.61	442.64	441.5	441.79	3319918.0
2023-07-07 14:00:00	SPY	ETF	441.799	441.87	441.54	441.78	2174582.0
2023-07-07 14:30:00	SPY	ETF	441.78	441.855	441.07	441.19	2515128.0
2023-07-07 15:00:00	SPY	ETF	441.195	441.2599	440.21	440.285	4146902.0
2023-07-07 15:30:00	SPY	ETF	440.28	440.535	438.3	438.521	16997568.0
2023-07-07 16:00:00	SPY	ETF	438.545	439.1	438.4783	438.97	7324887.0
2023-07-07 16:30:00	SPY	ETF	438.97	438.99	438.69	438.85	144452.0
2023-07-07 17:00:00	SPY	ETF	438.88	438.92	438.7	438.7	58240.0
2023-07-07 17:30:00	SPY	ETF	438.7	438.75	438.55	438.72	467048.0
2023-07-07 18:00:00	SPY	ETF	438.72	438.76	438.7	438.76	6904.0
2023-07-07 18:30:00	SPY	ETF	438.76	438.8895	438.76	438.81	3895.0
2023-07-07 19:00:00	SPY	ETF	438.81	438.81	438.76	438.76	4317.0
2023-07-07 19:30:00	SPY	ETF	438.76	438.93	438.7	438.73	21800.0
2023-07-07 04:00:00	QQQ	ETF	366.6	366.82	366.27	366.82	31329.0
2023-07-07 04:30:00	QQQ	ETF	366.72	367.08	366.6	366.99	35850.0
2023-07-07 05:00:00	QQQ	ETF	367.06	367.34	367.04	367.17	19060.0
2023-07-07 05:30:00	QQQ	ETF	367.16	367.2	367.04	367.08	8399.0
2023-07-07 06:00:00	QQQ	ETF	367.05	367.05	366.67	366.81	23614.0
2023-07-07 06:30:00	QQQ	ETF	366.93	366.99	366.79	366.99	12946.0
2023-07-07 07:00:00	QQQ	ETF	367.0	367.16	366.95	367.02	29909.0
2023-07-07 07:30:00	QQQ	ETF	366.94	367.16	366.79	366.79	34735.0
2023-07-07 08:00:00	QQQ	ETF	367.0096	367.5	366.45	367.29	154219.0
2023-07-07 08:30:00	QQQ	ETF	367.3	369.41	366.85	367.13	1528590.0
2023-07-07 09:00:00	QQQ	ETF	367.11	367.83	366.33	367.25	696840.0
2023-07-07 09:30:00	QQQ	ETF	367.23	368.52	366.45	368.45	4314237.0
2023-07-07 10:00:00	QQQ	ETF	368.45	368.57	367.07	367.075	2629665.0
2023-07-07 10:30:00	QQQ	ETF	367.08	367.7699	366.21	367.6043	2949607.0
2023-07-07 11:00:00	QQQ	ETF	367.57	368.15	367.5	367.8499	1491349.0
2023-07-07 11:30:00	QQQ	ETF	367.87	368.62	367.65	368.6	1609091.0
2023-07-07 12:00:00	QQQ	ETF	368.6	369.18	368.58	369.0	1842955.0
2023-07-07 12:30:00	QQQ	ETF	369.0	369.94	368.98	369.8407	2303410.0

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

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