PREVIEW / etf_30min / 2024-04-22

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-04-22.parquet
  size:    805 KB
  rows:    32,228

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-04-22 04:00:00	SPY	ETF	496.7	497.07	496.51	497.02	10041.0
2024-04-22 04:30:00	SPY	ETF	496.91	497.18	496.61	497.0	9429.0
2024-04-22 05:00:00	SPY	ETF	496.97	497.76	496.97	497.63	8869.0
2024-04-22 05:30:00	SPY	ETF	497.56	498.13	497.55	497.83	36434.0
2024-04-22 06:00:00	SPY	ETF	497.9	498.28	497.9	498.17	20277.0
2024-04-22 06:30:00	SPY	ETF	497.95	498.04	497.61	497.72	27550.0
2024-04-22 07:00:00	SPY	ETF	497.74	498.15	496.64	497.84	165074.0
2024-04-22 07:30:00	SPY	ETF	497.71	498.4	497.71	498.07	147971.0
2024-04-22 08:00:00	SPY	ETF	498.31	498.34	496.34	497.42	234795.0
2024-04-22 08:30:00	SPY	ETF	497.42	498.25	497.29	498.0594	148910.0
2024-04-22 09:00:00	SPY	ETF	498.06	498.29	497.78	497.84	128859.0
2024-04-22 09:30:00	SPY	ETF	497.84	498.07	496.74	497.59	5379027.0
2024-04-22 10:00:00	SPY	ETF	497.5801	498.22	496.22	496.425	3531797.0
2024-04-22 10:30:00	SPY	ETF	496.435	497.31	495.95	496.215	2821970.0
2024-04-22 11:00:00	SPY	ETF	496.21	496.445	495.43	496.4325	3507551.0
2024-04-22 11:30:00	SPY	ETF	496.44	497.41	496.37	497.39	2688950.0
2024-04-22 12:00:00	SPY	ETF	497.4	498.51	497.2701	497.76	2635596.0
2024-04-22 12:30:00	SPY	ETF	497.77	498.44	497.29	498.41	2078647.0
2024-04-22 13:00:00	SPY	ETF	498.4176	500.05	498.24	500.04	3031577.0
2024-04-22 13:30:00	SPY	ETF	500.04	501.905	499.885	501.43	4272184.0
2024-04-22 14:00:00	SPY	ETF	501.43	502.335	501.19	502.06	3171094.0
2024-04-22 14:30:00	SPY	ETF	502.07	502.38	500.625	501.33	3581480.0
2024-04-22 15:00:00	SPY	ETF	501.34	501.36	500.26	500.59	3217470.0
2024-04-22 15:30:00	SPY	ETF	500.58	500.665	498.905	499.63	10240850.0
2024-04-22 16:00:00	SPY	ETF	499.64	499.73	498.97	499.38	5211658.0
2024-04-22 16:30:00	SPY	ETF	499.41	499.75	499.36	499.65	200611.0
2024-04-22 17:00:00	SPY	ETF	499.7	500.0	499.68	500.0	48004.0
2024-04-22 17:30:00	SPY	ETF	500.0	500.0	499.85	499.9	36333.0
2024-04-22 18:00:00	SPY	ETF	499.9	500.16	499.38	499.55	131354.0
2024-04-22 18:30:00	SPY	ETF	499.67	499.73	499.58	499.6	44265.0
2024-04-22 19:00:00	SPY	ETF	499.59	499.65	498.67	499.35	65844.0
2024-04-22 19:30:00	SPY	ETF	499.38	499.53	499.27	499.35	20364.0
2024-04-22 04:00:00	QQQ	ETF	416.57	416.91	416.03	416.62	38501.0
2024-04-22 04:30:00	QQQ	ETF	416.62	416.91	416.38	416.69	25999.0
2024-04-22 05:00:00	QQQ	ETF	416.68	417.39	416.66	417.16	26770.0
2024-04-22 05:30:00	QQQ	ETF	417.15	417.58	417.02	417.45	21248.0
2024-04-22 06:00:00	QQQ	ETF	417.52	417.95	417.52	417.73	40243.0
2024-04-22 06:30:00	QQQ	ETF	417.68	417.68	417.01	417.1	26670.0
2024-04-22 07:00:00	QQQ	ETF	417.1	417.58	416.56	417.04	183973.0
2024-04-22 07:30:00	QQQ	ETF	417.05	417.5	416.97	417.1	166552.0
2024-04-22 08:00:00	QQQ	ETF	416.88	417.8604	414.96	416.6	307627.0
2024-04-22 08:30:00	QQQ	ETF	416.615	417.7	416.55	417.49	220272.0
2024-04-22 09:00:00	QQQ	ETF	417.539	417.7	417.24	417.34	222390.0
2024-04-22 09:30:00	QQQ	ETF	417.31	418.33	416.71	417.16	4439189.0
2024-04-22 10:00:00	QQQ	ETF	417.16	417.9099	414.74	415.0	3095878.0
2024-04-22 10:30:00	QQQ	ETF	414.995	416.05	414.34	414.825	2461874.0
2024-04-22 11:00:00	QQQ	ETF	414.79	415.38	413.94	415.32	2074973.0
2024-04-22 11:30:00	QQQ	ETF	415.34	416.48	415.23	416.41	1722124.0
2024-04-22 12:00:00	QQQ	ETF	416.4247	417.4899	416.31	416.585	2005345.0
2024-04-22 12:30:00	QQQ	ETF	416.59	417.01	416.0251	416.97	1226303.0

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

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