PREVIEW / etf_30min / 2024-09-13

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-09-13.parquet
  size:    791 KB
  rows:    32,397

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-09-13 04:00:00	SPY	ETF	559.38	559.93	559.32	559.75	7739.0
2024-09-13 04:30:00	SPY	ETF	559.79	560.0	559.53	559.78	33688.0
2024-09-13 05:00:00	SPY	ETF	559.93	560.25	559.86	560.23	3945.0
2024-09-13 05:30:00	SPY	ETF	560.25	560.6	560.18	560.38	9927.0
2024-09-13 06:00:00	SPY	ETF	560.31	560.53	560.28	560.45	7738.0
2024-09-13 06:30:00	SPY	ETF	560.49	560.49	560.25	560.4	4769.0
2024-09-13 07:00:00	SPY	ETF	560.51	560.68	559.91	560.38	254075.0
2024-09-13 07:30:00	SPY	ETF	560.32	560.36	559.82	560.28	27862.0
2024-09-13 08:00:00	SPY	ETF	560.5113	560.5117	559.23	560.18	59086.0
2024-09-13 08:30:00	SPY	ETF	560.21	560.43	559.49	560.3	69005.0
2024-09-13 09:00:00	SPY	ETF	560.22	560.4	559.6	559.69	110338.0
2024-09-13 09:30:00	SPY	ETF	559.69	561.28	559.45	560.9301	3240336.0
2024-09-13 10:00:00	SPY	ETF	560.99	562.36	559.93	561.12	2514248.0
2024-09-13 10:30:00	SPY	ETF	561.11	562.57	560.27	561.86	2354073.0
2024-09-13 11:00:00	SPY	ETF	561.85	562.14	561.51	561.85	1403612.0
2024-09-13 11:30:00	SPY	ETF	561.8799	562.8	561.7	562.66	1447173.0
2024-09-13 12:00:00	SPY	ETF	562.65	562.94	561.52	561.57	1333688.0
2024-09-13 12:30:00	SPY	ETF	561.565	562.23	561.33	562.19	1151356.0
2024-09-13 13:00:00	SPY	ETF	562.19	562.8098	562.14	562.76	1142435.0
2024-09-13 13:30:00	SPY	ETF	562.7301	563.03	562.4	562.57	949971.0
2024-09-13 14:00:00	SPY	ETF	562.57	562.98	561.27	561.4099	1921992.0
2024-09-13 14:30:00	SPY	ETF	561.41	561.87	561.11	561.44	1302563.0
2024-09-13 15:00:00	SPY	ETF	561.43	561.97	561.02	561.8	1337938.0
2024-09-13 15:30:00	SPY	ETF	561.8	562.34	561.26	561.94	4339269.0
2024-09-13 16:00:00	SPY	ETF	561.95	562.11	561.49	561.95	3449270.0
2024-09-13 16:30:00	SPY	ETF	561.95	561.95	561.56	561.63	68761.0
2024-09-13 17:00:00	SPY	ETF	561.5785	561.76	561.5785	561.61	6829.0
2024-09-13 17:30:00	SPY	ETF	561.65	561.9334	561.53	561.75	450748.0
2024-09-13 18:00:00	SPY	ETF	561.75	561.85	561.65	561.81	43586.0
2024-09-13 18:30:00	SPY	ETF	561.75	561.75	561.58	561.7	4451.0
2024-09-13 19:00:00	SPY	ETF	561.69	561.7599	561.69	561.75	14382.0
2024-09-13 19:30:00	SPY	ETF	561.6007	561.7328	561.45	561.65	6507.0
2024-09-13 04:00:00	QQQ	ETF	473.12	473.58	472.89	473.49	17913.0
2024-09-13 04:30:00	QQQ	ETF	473.42	473.79	473.31	473.56	17485.0
2024-09-13 05:00:00	QQQ	ETF	473.64	473.9	473.44	473.78	15924.0
2024-09-13 05:30:00	QQQ	ETF	473.8	474.08	473.75	473.81	13912.0
2024-09-13 06:00:00	QQQ	ETF	473.77	474.02	473.59	473.78	6773.0
2024-09-13 06:30:00	QQQ	ETF	473.85	473.94	473.6	473.94	12760.0
2024-09-13 07:00:00	QQQ	ETF	473.89	473.99	473.429	473.76	20480.0
2024-09-13 07:30:00	QQQ	ETF	473.8	473.88	473.25	473.61	85736.0
2024-09-13 08:00:00	QQQ	ETF	473.86	474.25	473.07	473.47	62051.0
2024-09-13 08:30:00	QQQ	ETF	473.41	473.6101	472.59	473.42	90873.0
2024-09-13 09:00:00	QQQ	ETF	473.41	473.5399	472.43	472.54	140318.0
2024-09-13 09:30:00	QQQ	ETF	472.5	474.69	472.25	473.81	2618521.0
2024-09-13 10:00:00	QQQ	ETF	473.89	475.38	472.61	473.75	2613585.0
2024-09-13 10:30:00	QQQ	ETF	473.79	475.5	472.5982	475.01	2141799.0
2024-09-13 11:00:00	QQQ	ETF	475.0225	475.67	474.78	475.1501	1479301.0
2024-09-13 11:30:00	QQQ	ETF	475.175	475.72	474.6513	475.52	1242887.0
2024-09-13 12:00:00	QQQ	ETF	475.49	476.13	474.34	474.63	1317927.0
2024-09-13 12:30:00	QQQ	ETF	474.62	475.71	474.15	475.685	1090721.0

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

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