PREVIEW / etf_30min / 2024-09-19

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-09-19.parquet
  size:    878 KB
  rows:    35,198

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-19 04:00:00	SPY	ETF	567.22	568.74	566.22	568.45	33794.0
2024-09-19 04:30:00	SPY	ETF	568.44	569.02	568.44	568.87	31564.0
2024-09-19 05:00:00	SPY	ETF	568.9	569.94	568.86	569.73	48682.0
2024-09-19 05:30:00	SPY	ETF	569.75	570.05	569.64	569.87	30771.0
2024-09-19 06:00:00	SPY	ETF	569.95	570.45	569.75	570.44	131382.0
2024-09-19 06:30:00	SPY	ETF	570.44	570.65	570.34	570.47	67394.0
2024-09-19 07:00:00	SPY	ETF	570.47	570.65	570.2	570.42	143068.0
2024-09-19 07:30:00	SPY	ETF	570.38	571.05	570.3	570.54	216110.0
2024-09-19 08:00:00	SPY	ETF	570.48	571.02	566.6	570.39	271025.0
2024-09-19 08:30:00	SPY	ETF	570.4	570.6	569.91	570.0	315363.0
2024-09-19 09:00:00	SPY	ETF	569.98	571.07	569.6	571.01	399499.0
2024-09-19 09:30:00	SPY	ETF	571.01	571.09	568.08	569.58	5752254.0
2024-09-19 10:00:00	SPY	ETF	569.61	571.38	569.37	571.35	3578318.0
2024-09-19 10:30:00	SPY	ETF	571.33	571.89	569.75	569.91	3259643.0
2024-09-19 11:00:00	SPY	ETF	569.92	571.18	569.43	570.8991	2478575.0
2024-09-19 11:30:00	SPY	ETF	570.9	571.1699	570.05	570.4	1350615.0
2024-09-19 12:00:00	SPY	ETF	570.4	571.82	570.3392	571.68	1449216.0
2024-09-19 12:30:00	SPY	ETF	571.67	572.048	571.19	571.5	1483676.0
2024-09-19 13:00:00	SPY	ETF	571.5	572.085	571.3	571.8599	1294401.0
2024-09-19 13:30:00	SPY	ETF	571.855	572.88	571.855	572.5	1833666.0
2024-09-19 14:00:00	SPY	ETF	572.49	572.74	570.89	572.0	2416180.0
2024-09-19 14:30:00	SPY	ETF	572.0	572.25	571.0609	571.92	2833253.0
2024-09-19 15:00:00	SPY	ETF	571.92	572.11	570.67	571.17	2765249.0
2024-09-19 15:30:00	SPY	ETF	571.17	571.78	570.35	570.92	8869997.0
2024-09-19 16:00:00	SPY	ETF	570.93	571.01	570.43	570.77	4665678.0
2024-09-19 16:30:00	SPY	ETF	570.77	570.815	570.47	570.47	116927.0
2024-09-19 17:00:00	SPY	ETF	570.55	570.74	570.52	570.6103	15593.0
2024-09-19 17:30:00	SPY	ETF	570.64	570.66	570.5	570.66	27331.0
2024-09-19 18:00:00	SPY	ETF	570.68	570.85	570.47	570.68	80778.0
2024-09-19 18:30:00	SPY	ETF	570.7	570.7	570.15	570.41	25269.0
2024-09-19 19:00:00	SPY	ETF	570.38	570.49	570.32	570.45	10067.0
2024-09-19 19:30:00	SPY	ETF	570.49	570.64	570.19	570.25	14881.0
2024-09-19 04:00:00	QQQ	ETF	478.62	480.0	478.62	479.35	80660.0
2024-09-19 04:30:00	QQQ	ETF	479.35	479.98	479.3	479.85	48722.0
2024-09-19 05:00:00	QQQ	ETF	479.83	480.93	479.6	480.65	85939.0
2024-09-19 05:30:00	QQQ	ETF	480.64	480.98	480.49	480.91	29868.0
2024-09-19 06:00:00	QQQ	ETF	480.98	481.29	480.58	481.19	27898.0
2024-09-19 06:30:00	QQQ	ETF	481.29	481.4	481.06	481.24	61027.0
2024-09-19 07:00:00	QQQ	ETF	481.26	481.35	480.8	480.96	109308.0
2024-09-19 07:30:00	QQQ	ETF	480.98	481.77	480.9	481.6	166327.0
2024-09-19 08:00:00	QQQ	ETF	480.9	481.8	471.793	481.47	244233.0
2024-09-19 08:30:00	QQQ	ETF	481.48	481.8	481.16	481.35	164550.0
2024-09-19 09:00:00	QQQ	ETF	481.37	482.72	480.92	482.65	354933.0
2024-09-19 09:30:00	QQQ	ETF	482.61	483.06	480.49	481.64	5421005.0
2024-09-19 10:00:00	QQQ	ETF	481.63	484.64	481.42	484.5	3544662.0
2024-09-19 10:30:00	QQQ	ETF	484.48	485.19	482.77	482.93	2916874.0
2024-09-19 11:00:00	QQQ	ETF	482.965	484.84	482.59	484.62	2108664.0
2024-09-19 11:30:00	QQQ	ETF	484.62	485.11	483.49	483.79	1748098.0
2024-09-19 12:00:00	QQQ	ETF	483.8	485.38	483.67	485.22	1367077.0
2024-09-19 12:30:00	QQQ	ETF	485.2299	485.51	484.9	485.13	1307020.0

> showing 50 of 35,198 rows — these rows as CSV

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