PREVIEW / etf_30min / 2023-08-11

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-08-11.parquet
  size:    678 KB
  rows:    27,321

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
2023-08-11 04:00:00	SPY	ETF	446.25	446.31	445.8	445.85	9755.0
2023-08-11 04:30:00	SPY	ETF	445.5	445.58	445.19	445.57	15198.0
2023-08-11 05:00:00	SPY	ETF	445.7	445.94	445.66	445.92	3359.0
2023-08-11 05:30:00	SPY	ETF	445.93	446.03	445.05	445.05	11893.0
2023-08-11 06:00:00	SPY	ETF	445.27	445.76	445.27	445.7	14444.0
2023-08-11 06:30:00	SPY	ETF	445.75	446.04	445.52	445.52	34210.0
2023-08-11 07:00:00	SPY	ETF	445.52	446.07	445.51	445.84	125523.0
2023-08-11 07:30:00	SPY	ETF	445.85	445.98	445.47	445.57	106566.0
2023-08-11 08:00:00	SPY	ETF	445.6816	446.27	445.3	445.65	201838.0
2023-08-11 08:30:00	SPY	ETF	445.88	445.88	444.09	444.25	679415.0
2023-08-11 09:00:00	SPY	ETF	444.17	444.84	443.9	443.9	463098.0
2023-08-11 09:30:00	SPY	ETF	443.97	444.64	443.345	444.15	4940602.0
2023-08-11 10:00:00	SPY	ETF	444.17	446.67	444.17	446.045	7078606.0
2023-08-11 10:30:00	SPY	ETF	446.06	446.7007	445.18	445.2798	3670844.0
2023-08-11 11:00:00	SPY	ETF	445.28	445.64	444.439	444.57	3124436.0
2023-08-11 11:30:00	SPY	ETF	444.57	445.37	444.31	445.3199	3134517.0
2023-08-11 12:00:00	SPY	ETF	445.3115	445.92	444.72	445.0768	2910638.0
2023-08-11 12:30:00	SPY	ETF	445.08	445.415	444.48	444.7	2105442.0
2023-08-11 13:00:00	SPY	ETF	444.72	445.515	444.44	445.43	2407638.0
2023-08-11 13:30:00	SPY	ETF	445.44	445.57	444.445	444.9487	2740458.0
2023-08-11 14:00:00	SPY	ETF	444.95	445.94	444.84	445.65	3057800.0
2023-08-11 14:30:00	SPY	ETF	445.66	446.24	445.39	446.05	2856774.0
2023-08-11 15:00:00	SPY	ETF	446.05	446.13	445.1699	445.87	2985967.0
2023-08-11 15:30:00	SPY	ETF	445.86	446.16	444.99	445.58	9515162.0
2023-08-11 16:00:00	SPY	ETF	445.58	446.0	445.0	445.81	2877672.0
2023-08-11 16:30:00	SPY	ETF	445.81	445.89	445.427	445.81	106816.0
2023-08-11 17:00:00	SPY	ETF	445.8	445.87	445.65	445.87	518390.0
2023-08-11 17:30:00	SPY	ETF	445.9	445.93	445.77	445.77	22435.0
2023-08-11 18:00:00	SPY	ETF	445.85	445.88	445.8	445.8	5254.0
2023-08-11 18:30:00	SPY	ETF	445.86	445.88	445.8	445.88	2408.0
2023-08-11 19:00:00	SPY	ETF	445.8501	445.8501	445.83	445.83	899.0
2023-08-11 19:30:00	SPY	ETF	445.87	445.9	445.77	445.81	14668.0
2023-08-11 04:00:00	QQQ	ETF	368.59	369.05	368.17	368.2	26008.0
2023-08-11 04:30:00	QQQ	ETF	368.25	368.25	367.58	367.81	30310.0
2023-08-11 05:00:00	QQQ	ETF	368.06	368.38	367.97	368.31	22043.0
2023-08-11 05:30:00	QQQ	ETF	368.34	368.49	367.26	367.63	34302.0
2023-08-11 06:00:00	QQQ	ETF	367.65	367.96	367.59	367.88	34592.0
2023-08-11 06:30:00	QQQ	ETF	367.95	368.27	367.71	367.71	24343.0
2023-08-11 07:00:00	QQQ	ETF	367.81	368.4	367.8	368.3	54300.0
2023-08-11 07:30:00	QQQ	ETF	368.15	368.42	367.85	368.009	33282.0
2023-08-11 08:00:00	QQQ	ETF	368.25	369.54	367.34	368.18	167979.0
2023-08-11 08:30:00	QQQ	ETF	368.2	368.23	365.82	366.17	801350.0
2023-08-11 09:00:00	QQQ	ETF	366.1	366.65	365.71	365.96	430255.0
2023-08-11 09:30:00	QQQ	ETF	365.99	366.608	365.05	365.585	4435804.0
2023-08-11 10:00:00	QQQ	ETF	365.51	368.0	365.51	367.315	4736271.0
2023-08-11 10:30:00	QQQ	ETF	367.33	367.78	366.065	366.23	2470558.0
2023-08-11 11:00:00	QQQ	ETF	366.23	366.6	365.13	365.17	2694111.0
2023-08-11 11:30:00	QQQ	ETF	365.17	365.84	364.69	365.8063	3509228.0
2023-08-11 12:00:00	QQQ	ETF	365.79	366.665	365.39	365.77	2234095.0
2023-08-11 12:30:00	QQQ	ETF	365.7742	366.11	365.04	365.33	1307071.0

> showing 50 of 27,321 rows — these rows as CSV

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