PREVIEW / etf_30min / 2024-10-07

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-10-07.parquet
  size:    869 KB
  rows:    35,207

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-07 04:00:00	SPY	ETF	571.78	571.78	570.7	571.25	26337.0
2024-10-07 04:30:00	SPY	ETF	571.36	571.52	570.57	570.57	7589.0
2024-10-07 05:00:00	SPY	ETF	570.42	570.47	569.43	569.46	29195.0
2024-10-07 05:30:00	SPY	ETF	569.42	570.09	569.42	570.0	12026.0
2024-10-07 06:00:00	SPY	ETF	570.1	570.33	569.73	570.22	37474.0
2024-10-07 06:30:00	SPY	ETF	570.3	570.5	570.21	570.41	28203.0
2024-10-07 07:00:00	SPY	ETF	570.42	570.46	570.0	570.3	68789.0
2024-10-07 07:30:00	SPY	ETF	570.25	570.74	570.18	570.66	101761.0
2024-10-07 08:00:00	SPY	ETF	570.02	572.55	570.0	570.89	100719.0
2024-10-07 08:30:00	SPY	ETF	570.78	571.19	570.76	570.88	41397.0
2024-10-07 09:00:00	SPY	ETF	570.959	571.32	570.71	571.31	182438.0
2024-10-07 09:30:00	SPY	ETF	571.3	571.65	570.53	570.72	3214377.0
2024-10-07 10:00:00	SPY	ETF	570.72	571.9599	570.66	571.5	1861348.0
2024-10-07 10:30:00	SPY	ETF	571.51	571.62	570.9	571.29	1524449.0
2024-10-07 11:00:00	SPY	ETF	571.25	571.7799	570.62	571.65	1455695.0
2024-10-07 11:30:00	SPY	ETF	571.65	571.74	571.05	571.13	996897.0
2024-10-07 12:00:00	SPY	ETF	571.13	571.18	570.12	570.9609	1391991.0
2024-10-07 12:30:00	SPY	ETF	570.97	571.0008	570.2689	570.61	871037.0
2024-10-07 13:00:00	SPY	ETF	570.62	570.98	570.37	570.37	933734.0
2024-10-07 13:30:00	SPY	ETF	570.35	570.55	569.8253	570.43	1013956.0
2024-10-07 14:00:00	SPY	ETF	570.4201	570.47	569.5	569.55	1118455.0
2024-10-07 14:30:00	SPY	ETF	569.54	569.54	566.63	566.8499	3542688.0
2024-10-07 15:00:00	SPY	ETF	566.83	568.295	566.67	567.88	1887780.0
2024-10-07 15:30:00	SPY	ETF	567.88	568.6798	566.77	567.81	8922792.0
2024-10-07 16:00:00	SPY	ETF	567.83	568.162	567.77	568.011	1962855.0
2024-10-07 16:30:00	SPY	ETF	568.0	568.46	568.0	568.05	136538.0
2024-10-07 17:00:00	SPY	ETF	568.03	568.13	567.8	568.0483	237816.0
2024-10-07 17:30:00	SPY	ETF	568.0	568.2	567.9	568.17	14570.0
2024-10-07 18:00:00	SPY	ETF	568.18	568.41	567.68	567.78	32988.0
2024-10-07 18:30:00	SPY	ETF	567.75	567.8	565.8	566.87	81504.0
2024-10-07 19:00:00	SPY	ETF	567.22	567.93	567.18	567.65	20049.0
2024-10-07 19:30:00	SPY	ETF	567.54	567.9411	567.36	567.7	11458.0
2024-10-07 04:00:00	QQQ	ETF	486.28	486.28	485.42	485.63	22072.0
2024-10-07 04:30:00	QQQ	ETF	485.8	486.03	484.8	484.8	11955.0
2024-10-07 05:00:00	QQQ	ETF	484.8	484.8	483.56	483.67	36744.0
2024-10-07 05:30:00	QQQ	ETF	483.69	484.34	483.69	484.3	24719.0
2024-10-07 06:00:00	QQQ	ETF	484.3	484.48	483.9	484.28	12336.0
2024-10-07 06:30:00	QQQ	ETF	484.33	484.58	484.25	484.46	7548.0
2024-10-07 07:00:00	QQQ	ETF	484.56	484.63	484.09	484.46	63111.0
2024-10-07 07:30:00	QQQ	ETF	484.3	484.9	484.18	484.75	38039.0
2024-10-07 08:00:00	QQQ	ETF	484.46	487.685	483.6604	485.08	125309.0
2024-10-07 08:30:00	QQQ	ETF	485.1	485.52	484.991	485.0896	71701.0
2024-10-07 09:00:00	QQQ	ETF	485.15	485.62	484.85	485.45	118546.0
2024-10-07 09:30:00	QQQ	ETF	485.42	486.04	484.25	484.76	1993907.0
2024-10-07 10:00:00	QQQ	ETF	484.76	486.42	484.6001	486.37	1122441.0
2024-10-07 10:30:00	QQQ	ETF	486.39	486.57	485.33	486.05	1193224.0
2024-10-07 11:00:00	QQQ	ETF	486.01	486.05	484.97	485.97	820529.0
2024-10-07 11:30:00	QQQ	ETF	485.98	486.28	485.505	485.72	642035.0
2024-10-07 12:00:00	QQQ	ETF	485.73	486.1	484.71	485.77	877657.0
2024-10-07 12:30:00	QQQ	ETF	485.79	485.85	484.94	485.3599	464260.0

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

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