PREVIEW / etf_30min / 2024-10-30

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-10-30.parquet
  size:    871 KB
  rows:    34,593

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-10-30 04:00:00	SPY	ETF	582.89	583.23	582.5	583.13	10099.0
2024-10-30 04:30:00	SPY	ETF	583.05	583.14	582.65	582.66	8747.0
2024-10-30 05:00:00	SPY	ETF	582.58	583.09	582.5	583.06	5154.0
2024-10-30 05:30:00	SPY	ETF	583.13	583.13	582.75	582.92	2320.0
2024-10-30 06:00:00	SPY	ETF	582.95	583.05	582.65	583.05	55096.0
2024-10-30 06:30:00	SPY	ETF	583.02	583.02	582.0	582.16	49982.0
2024-10-30 07:00:00	SPY	ETF	582.13	582.65	582.06	582.33	60272.0
2024-10-30 07:30:00	SPY	ETF	582.36	582.47	581.77	581.91	102264.0
2024-10-30 08:00:00	SPY	ETF	582.37	583.06	581.65	581.68	151316.0
2024-10-30 08:30:00	SPY	ETF	581.68	582.1	581.39	581.55	121492.0
2024-10-30 09:00:00	SPY	ETF	581.52	581.52	580.88	581.33	171631.0
2024-10-30 09:30:00	SPY	ETF	581.29	581.91	579.29	581.85	3811291.0
2024-10-30 10:00:00	SPY	ETF	581.84	582.9	581.7401	582.7089	1804086.0
2024-10-30 10:30:00	SPY	ETF	582.71	582.96	581.9	582.3799	1308721.0
2024-10-30 11:00:00	SPY	ETF	582.3799	582.87	581.59	582.85	1042906.0
2024-10-30 11:30:00	SPY	ETF	582.8501	583.32	582.43	583.105	967945.0
2024-10-30 12:00:00	SPY	ETF	583.1	583.21	582.39	582.49	793436.0
2024-10-30 12:30:00	SPY	ETF	582.46	582.6	581.99	582.0	596886.0
2024-10-30 13:00:00	SPY	ETF	581.99	582.305	581.46	581.52	1180690.0
2024-10-30 13:30:00	SPY	ETF	581.515	581.59	580.29	580.64	1447608.0
2024-10-30 14:00:00	SPY	ETF	580.624	581.81	580.624	581.13	1277536.0
2024-10-30 14:30:00	SPY	ETF	581.11	581.434	581.0501	581.18	1068940.0
2024-10-30 15:00:00	SPY	ETF	581.17	581.17	580.14	580.5702	1658708.0
2024-10-30 15:30:00	SPY	ETF	580.57	580.75	579.38	579.97	6803063.0
2024-10-30 16:00:00	SPY	ETF	579.94	580.61	578.75	579.82	2727436.0
2024-10-30 16:30:00	SPY	ETF	579.78	580.0	579.19	579.22	198198.0
2024-10-30 17:00:00	SPY	ETF	579.2501	579.37	579.01	579.14	44997.0
2024-10-30 17:30:00	SPY	ETF	579.11	579.11	578.43	578.45	50883.0
2024-10-30 18:00:00	SPY	ETF	578.61	579.08	577.87	578.26	189046.0
2024-10-30 18:30:00	SPY	ETF	578.29	578.55	578.02	578.13	41228.0
2024-10-30 19:00:00	SPY	ETF	578.1198	578.3	578.06	578.1798	7466.0
2024-10-30 19:30:00	SPY	ETF	578.1	578.1801	577.8	577.9	61825.0
2024-10-30 04:00:00	QQQ	ETF	501.44	501.9	500.99	501.42	45172.0
2024-10-30 04:30:00	QQQ	ETF	501.5	501.56	500.7	500.86	15390.0
2024-10-30 05:00:00	QQQ	ETF	500.7	501.48	500.55	501.44	14641.0
2024-10-30 05:30:00	QQQ	ETF	501.45	501.47	501.06	501.06	11856.0
2024-10-30 06:00:00	QQQ	ETF	501.08	501.23	500.8	501.23	60936.0
2024-10-30 06:30:00	QQQ	ETF	501.21	501.22	500.85	501.22	51534.0
2024-10-30 07:00:00	QQQ	ETF	501.26	501.63	500.95	501.35	80540.0
2024-10-30 07:30:00	QQQ	ETF	501.38	501.41	500.67	500.67	82644.0
2024-10-30 08:00:00	QQQ	ETF	501.19	501.78	499.785	500.6	133661.0
2024-10-30 08:30:00	QQQ	ETF	500.38	500.83	499.7401	500.02	136749.0
2024-10-30 09:00:00	QQQ	ETF	500.02	500.05	498.92	499.37	186269.0
2024-10-30 09:30:00	QQQ	ETF	499.39	499.6	496.6	498.77	3096428.0
2024-10-30 10:00:00	QQQ	ETF	498.72	500.35	498.41	500.105	1580433.0
2024-10-30 10:30:00	QQQ	ETF	500.1	500.16	498.66	499.1975	1214740.0
2024-10-30 11:00:00	QQQ	ETF	499.15	499.96	498.15	499.94	1003719.0
2024-10-30 11:30:00	QQQ	ETF	499.94	499.99	498.96	499.66	956100.0
2024-10-30 12:00:00	QQQ	ETF	499.63	499.92	498.87	499.15	607097.0
2024-10-30 12:30:00	QQQ	ETF	499.14	499.6	498.87	499.04	403819.0

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

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