PREVIEW / etf_30min / 2023-11-14

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-11-14.parquet
  size:    778 KB
  rows:    30,860

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-11-14 04:00:00	SPY	ETF	440.5	441.39	440.5	441.27	34413.0
2023-11-14 04:30:00	SPY	ETF	441.19	441.24	440.97	441.08	9664.0
2023-11-14 05:00:00	SPY	ETF	441.2	441.29	440.95	441.29	13698.0
2023-11-14 05:30:00	SPY	ETF	441.29	441.29	440.58	440.66	7982.0
2023-11-14 06:00:00	SPY	ETF	440.73	440.75	440.34	440.45	41088.0
2023-11-14 06:30:00	SPY	ETF	440.43	440.75	440.43	440.75	41819.0
2023-11-14 07:00:00	SPY	ETF	440.68	440.75	440.46	440.57	20103.0
2023-11-14 07:30:00	SPY	ETF	440.47	440.61	440.23	440.61	57531.0
2023-11-14 08:00:00	SPY	ETF	440.7003	441.2196	440.2893	440.67	144649.0
2023-11-14 08:30:00	SPY	ETF	440.66	446.7	439.92	446.47	2806035.0
2023-11-14 09:00:00	SPY	ETF	446.47	446.48	445.91	446.3	618663.0
2023-11-14 09:30:00	SPY	ETF	446.33	448.045	446.09	447.94	11419978.0
2023-11-14 10:00:00	SPY	ETF	447.93	448.88	447.62	448.87	7908948.0
2023-11-14 10:30:00	SPY	ETF	448.855	449.3812	448.7186	448.96	6012843.0
2023-11-14 11:00:00	SPY	ETF	448.98	449.73	448.95	449.46	4286434.0
2023-11-14 11:30:00	SPY	ETF	449.46	449.59	448.4	448.435	3355934.0
2023-11-14 12:00:00	SPY	ETF	448.46	448.72	447.87	448.11	3923421.0
2023-11-14 12:30:00	SPY	ETF	448.119	448.82	448.07	448.75	2454100.0
2023-11-14 13:00:00	SPY	ETF	448.75	448.94	448.46	448.85	1901556.0
2023-11-14 13:30:00	SPY	ETF	448.86	449.14	448.23	448.23	2266999.0
2023-11-14 14:00:00	SPY	ETF	448.25	448.6	447.7	448.56	2963287.0
2023-11-14 14:30:00	SPY	ETF	448.57	449.505	448.5595	449.43	3729109.0
2023-11-14 15:00:00	SPY	ETF	449.43	450.06	449.32	449.8611	4977411.0
2023-11-14 15:30:00	SPY	ETF	449.87	449.94	448.29	448.71	13195598.0
2023-11-14 16:00:00	SPY	ETF	448.71	449.7006	448.3048	449.22	2801636.0
2023-11-14 16:30:00	SPY	ETF	449.2001	449.25	448.73	449.1	872796.0
2023-11-14 17:00:00	SPY	ETF	449.09	449.29	448.99	449.24	113676.0
2023-11-14 17:30:00	SPY	ETF	449.21	449.3	449.18	449.2502	23923.0
2023-11-14 18:00:00	SPY	ETF	449.25	449.51	449.21	449.47	72187.0
2023-11-14 18:30:00	SPY	ETF	449.43	449.61	449.26	449.26	26500.0
2023-11-14 19:00:00	SPY	ETF	449.36	449.39	449.09	449.2699	49872.0
2023-11-14 19:30:00	SPY	ETF	449.26	449.35	449.14	449.26	28593.0
2023-11-14 04:00:00	QQQ	ETF	378.44	378.73	378.36	378.55	44724.0
2023-11-14 04:30:00	QQQ	ETF	378.48	378.48	378.27	378.36	85568.0
2023-11-14 05:00:00	QQQ	ETF	378.39	378.54	378.23	378.54	92740.0
2023-11-14 05:30:00	QQQ	ETF	378.54	378.54	377.93	378.07	52289.0
2023-11-14 06:00:00	QQQ	ETF	378.06	378.06	377.77	377.99	6794.0
2023-11-14 06:30:00	QQQ	ETF	377.88	378.18	377.88	378.14	4558.0
2023-11-14 07:00:00	QQQ	ETF	378.14	378.23	377.98	378.05	52448.0
2023-11-14 07:30:00	QQQ	ETF	378.05	378.17	377.8	378.17	55683.0
2023-11-14 08:00:00	QQQ	ETF	378.13	378.6996	377.492	378.37	177411.0
2023-11-14 08:30:00	QQQ	ETF	378.34	384.38	377.0	383.93	3865273.0
2023-11-14 09:00:00	QQQ	ETF	383.88	384.181	383.37	383.73	762668.0
2023-11-14 09:30:00	QQQ	ETF	383.71	385.01	383.18	384.8905	9798616.0
2023-11-14 10:00:00	QQQ	ETF	384.89	385.5	384.57	385.4	4594742.0
2023-11-14 10:30:00	QQQ	ETF	385.4	385.87	384.88	385.01	3284512.0
2023-11-14 11:00:00	QQQ	ETF	385.01	385.63	384.88	385.0877	2403442.0
2023-11-14 11:30:00	QQQ	ETF	385.09	385.3	384.25	384.4	2668054.0
2023-11-14 12:00:00	QQQ	ETF	384.41	384.79	384.19	384.33	2426417.0
2023-11-14 12:30:00	QQQ	ETF	384.34	385.28	384.28	385.2298	1775099.0

> showing 50 of 30,860 rows — these rows as CSV

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