PREVIEW / etf_30min / 2024-07-15

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-07-15.parquet
  size:    845 KB
  rows:    34,421

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-07-15 04:00:00	SPY	ETF	560.93	561.8	560.93	561.78	50203.0
2024-07-15 04:30:00	SPY	ETF	561.85	561.9	561.79	561.83	2578.0
2024-07-15 05:00:00	SPY	ETF	561.87	562.05	561.87	562.05	7396.0
2024-07-15 05:30:00	SPY	ETF	562.05	562.06	561.9	561.9	45049.0
2024-07-15 06:00:00	SPY	ETF	561.77	561.91	561.71	561.89	5206.0
2024-07-15 06:30:00	SPY	ETF	561.9	561.95	561.82	561.95	36876.0
2024-07-15 07:00:00	SPY	ETF	561.94	562.34	561.79	562.31	145745.0
2024-07-15 07:30:00	SPY	ETF	562.3	562.51	561.79	561.85	74452.0
2024-07-15 08:00:00	SPY	ETF	561.9417	562.4982	560.41	561.94	115915.0
2024-07-15 08:30:00	SPY	ETF	561.93	562.02	561.54	561.63	42250.0
2024-07-15 09:00:00	SPY	ETF	561.62	562.13	561.59	562.01	92025.0
2024-07-15 09:30:00	SPY	ETF	562.05	562.83	561.39	561.92	3827050.0
2024-07-15 10:00:00	SPY	ETF	561.91	562.77	561.8979	562.7	2026013.0
2024-07-15 10:30:00	SPY	ETF	562.7	563.79	562.6588	563.64	1647660.0
2024-07-15 11:00:00	SPY	ETF	563.64	564.8371	563.61	563.72	2038537.0
2024-07-15 11:30:00	SPY	ETF	563.73	564.15	563.14	563.7799	1451118.0
2024-07-15 12:00:00	SPY	ETF	563.77	563.77	562.14	562.89	1696607.0
2024-07-15 12:30:00	SPY	ETF	562.88	563.18	562.23	562.57	1055556.0
2024-07-15 13:00:00	SPY	ETF	562.56	562.58	561.36	561.67	1516342.0
2024-07-15 13:30:00	SPY	ETF	561.62	561.66	560.72	561.04	1209439.0
2024-07-15 14:00:00	SPY	ETF	561.09	561.85	560.71	561.8101	979621.0
2024-07-15 14:30:00	SPY	ETF	561.81	562.5	561.64	562.275	1156987.0
2024-07-15 15:00:00	SPY	ETF	562.28	562.56	561.91	562.0699	1356501.0
2024-07-15 15:30:00	SPY	ETF	562.07	562.29	559.63	561.49	6831555.0
2024-07-15 16:00:00	SPY	ETF	561.48	561.77	561.23	561.66	3017038.0
2024-07-15 16:30:00	SPY	ETF	561.66	561.89	561.53	561.77	80153.0
2024-07-15 17:00:00	SPY	ETF	561.77	561.91	561.73	561.8	34271.0
2024-07-15 17:30:00	SPY	ETF	561.88	561.93	561.53	561.82	90584.0
2024-07-15 18:00:00	SPY	ETF	561.83	562.41	561.83	562.37	33396.0
2024-07-15 18:30:00	SPY	ETF	562.37	562.37	562.14	562.19	11727.0
2024-07-15 19:00:00	SPY	ETF	562.2	562.33	562.19	562.29	4074.0
2024-07-15 19:30:00	SPY	ETF	562.3	562.37	562.22	562.22	9589.0
2024-07-15 04:00:00	QQQ	ETF	495.15	497.16	495.15	496.93	53691.0
2024-07-15 04:30:00	QQQ	ETF	496.99	497.09	496.96	496.98	12927.0
2024-07-15 05:00:00	QQQ	ETF	497.05	497.05	496.95	497.02	2412.0
2024-07-15 05:30:00	QQQ	ETF	497.1	497.14	496.98	497.06	6189.0
2024-07-15 06:00:00	QQQ	ETF	496.9	497.18	496.6	497.03	8865.0
2024-07-15 06:30:00	QQQ	ETF	497.0	497.02	496.9	496.96	5184.0
2024-07-15 07:00:00	QQQ	ETF	497.03	497.49	496.98	497.42	75907.0
2024-07-15 07:30:00	QQQ	ETF	497.47	497.64	496.81	496.86	51554.0
2024-07-15 08:00:00	QQQ	ETF	497.01	497.62	495.73	497.09	133899.0
2024-07-15 08:30:00	QQQ	ETF	497.1	497.18	496.27	496.4001	95090.0
2024-07-15 09:00:00	QQQ	ETF	496.44	496.83	496.37	496.59	94965.0
2024-07-15 09:30:00	QQQ	ETF	496.61	497.96	495.92	497.03	3080296.0
2024-07-15 10:00:00	QQQ	ETF	497.07	498.42	496.96	498.31	1302578.0
2024-07-15 10:30:00	QQQ	ETF	498.32	499.638	498.24	499.37	1238532.0
2024-07-15 11:00:00	QQQ	ETF	499.38	501.01	499.3105	499.52	1603475.0
2024-07-15 11:30:00	QQQ	ETF	499.51	499.79	497.865	498.75	1921888.0
2024-07-15 12:00:00	QQQ	ETF	498.72	498.82	496.39	497.85	1787042.0
2024-07-15 12:30:00	QQQ	ETF	497.82	498.39	497.06	497.57	1294177.0

> showing 50 of 34,421 rows — these rows as CSV

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