PREVIEW / etf_30min / 2024-07-10

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-07-10.parquet
  size:    836 KB
  rows:    32,856

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-10 04:00:00	SPY	ETF	556.27	556.41	556.25	556.41	7666.0
2024-07-10 04:30:00	SPY	ETF	556.46	556.51	556.42	556.5	1754.0
2024-07-10 05:00:00	SPY	ETF	556.54	556.71	556.5	556.71	5388.0
2024-07-10 05:30:00	SPY	ETF	556.68	556.72	556.58	556.72	4020.0
2024-07-10 06:00:00	SPY	ETF	556.71	556.74	556.6	556.74	1423.0
2024-07-10 06:30:00	SPY	ETF	556.74	556.77	556.69	556.7	2287.0
2024-07-10 07:00:00	SPY	ETF	556.67	556.76	556.56	556.64	26757.0
2024-07-10 07:30:00	SPY	ETF	556.69	557.18	556.69	557.07	69966.0
2024-07-10 08:00:00	SPY	ETF	556.6604	557.35	555.95	557.28	114653.0
2024-07-10 08:30:00	SPY	ETF	557.3	557.38	557.121	557.13	51029.0
2024-07-10 09:00:00	SPY	ETF	557.11	557.25	557.03	557.07	113648.0
2024-07-10 09:30:00	SPY	ETF	557.07	557.37	556.79	557.28	2665900.0
2024-07-10 10:00:00	SPY	ETF	557.27	557.75	557.14	557.36	1512656.0
2024-07-10 10:30:00	SPY	ETF	557.34	557.38	556.92	557.0203	907006.0
2024-07-10 11:00:00	SPY	ETF	557.02	557.7	556.77	557.68	954027.0
2024-07-10 11:30:00	SPY	ETF	557.68	558.03	557.67	557.89	1132383.0
2024-07-10 12:00:00	SPY	ETF	557.895	559.04	557.865	558.94	1791093.0
2024-07-10 12:30:00	SPY	ETF	558.93	559.36	558.67	559.335	1418150.0
2024-07-10 13:00:00	SPY	ETF	559.33	559.75	559.125	559.3701	1279673.0
2024-07-10 13:30:00	SPY	ETF	559.35	559.8499	559.21	559.8	883652.0
2024-07-10 14:00:00	SPY	ETF	559.81	559.87	559.4251	559.56	1139062.0
2024-07-10 14:30:00	SPY	ETF	559.57	560.22	559.52	560.09	1413235.0
2024-07-10 15:00:00	SPY	ETF	560.08	560.16	559.75	560.07	1878431.0
2024-07-10 15:30:00	SPY	ETF	560.07	561.67	559.965	561.26	6861524.0
2024-07-10 16:00:00	SPY	ETF	561.26	561.45	560.96	561.19	2743156.0
2024-07-10 16:30:00	SPY	ETF	561.18	561.2	561.03	561.04	141979.0
2024-07-10 17:00:00	SPY	ETF	561.0	561.15	560.9811	560.99	52621.0
2024-07-10 17:30:00	SPY	ETF	561.05	561.16	560.95	561.06	40466.0
2024-07-10 18:00:00	SPY	ETF	561.04	561.26	560.96	561.25	51785.0
2024-07-10 18:30:00	SPY	ETF	561.2	561.25	561.0	561.13	18642.0
2024-07-10 19:00:00	SPY	ETF	561.13	561.13	561.02	561.02	11824.0
2024-07-10 19:30:00	SPY	ETF	561.04	561.0757	560.961	561.05	9762.0
2024-07-10 04:00:00	QQQ	ETF	498.62	499.04	498.62	498.96	20557.0
2024-07-10 04:30:00	QQQ	ETF	498.99	499.12	498.91	499.12	12032.0
2024-07-10 05:00:00	QQQ	ETF	499.11	499.11	499.0	499.1	10478.0
2024-07-10 05:30:00	QQQ	ETF	499.07	499.08	498.91	499.05	18165.0
2024-07-10 06:00:00	QQQ	ETF	499.06	499.3	499.04	499.3	11946.0
2024-07-10 06:30:00	QQQ	ETF	499.31	499.33	499.14	499.19	8189.0
2024-07-10 07:00:00	QQQ	ETF	499.2	499.28	499.09	499.16	21660.0
2024-07-10 07:30:00	QQQ	ETF	499.131	499.75	499.131	499.53	25000.0
2024-07-10 08:00:00	QQQ	ETF	499.17	499.87	498.47	499.7902	85277.0
2024-07-10 08:30:00	QQQ	ETF	499.79	499.96	499.58	499.66	85544.0
2024-07-10 09:00:00	QQQ	ETF	499.67	499.91	499.62	499.7	71129.0
2024-07-10 09:30:00	QQQ	ETF	499.71	500.19	498.83	499.85	2301530.0
2024-07-10 10:00:00	QQQ	ETF	499.875	500.604	499.48	500.04	1350094.0
2024-07-10 10:30:00	QQQ	ETF	500.04	500.08	498.9037	499.0375	1484103.0
2024-07-10 11:00:00	QQQ	ETF	499.01	499.61	498.39	499.5957	1202022.0
2024-07-10 11:30:00	QQQ	ETF	499.605	499.97	499.47	499.93	862910.0
2024-07-10 12:00:00	QQQ	ETF	499.91	501.08	499.77	501.06	1264412.0
2024-07-10 12:30:00	QQQ	ETF	501.08	501.895	500.8877	501.85	1448292.0

> showing 50 of 32,856 rows — these rows as CSV

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