PREVIEW / etf_30min / 2023-08-29

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-08-29.parquet
  size:    714 KB
  rows:    28,127

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-29 04:00:00	SPY	ETF	442.68	442.81	442.46	442.7	12528.0
2023-08-29 04:30:00	SPY	ETF	442.65	443.04	442.65	442.69	18140.0
2023-08-29 05:00:00	SPY	ETF	442.44	442.91	442.42	442.76	10605.0
2023-08-29 05:30:00	SPY	ETF	442.76	443.41	442.76	443.4	11305.0
2023-08-29 06:00:00	SPY	ETF	443.39	443.44	442.95	443.02	13234.0
2023-08-29 06:30:00	SPY	ETF	443.02	443.15	442.69	442.69	5903.0
2023-08-29 07:00:00	SPY	ETF	442.68	442.91	442.55	442.55	18474.0
2023-08-29 07:30:00	SPY	ETF	442.54	442.74	442.22	442.36	84808.0
2023-08-29 08:00:00	SPY	ETF	442.7505	443.42	441.99	442.0	136776.0
2023-08-29 08:30:00	SPY	ETF	441.98	442.69	441.95	442.5	88581.0
2023-08-29 09:00:00	SPY	ETF	442.58	442.71	442.2	442.61	94580.0
2023-08-29 09:30:00	SPY	ETF	442.65	444.22	442.46	443.86	5178874.0
2023-08-29 10:00:00	SPY	ETF	443.81	446.07	443.81	445.95	7921904.0
2023-08-29 10:30:00	SPY	ETF	445.98	446.78	445.49	445.79	7145577.0
2023-08-29 11:00:00	SPY	ETF	445.79	446.97	445.72	446.855	3251195.0
2023-08-29 11:30:00	SPY	ETF	446.86	447.95	446.85	447.62	4282473.0
2023-08-29 12:00:00	SPY	ETF	447.62	448.445	447.49	448.325	3356784.0
2023-08-29 12:30:00	SPY	ETF	448.33	448.41	447.55	448.035	2398691.0
2023-08-29 13:00:00	SPY	ETF	448.05	448.44	447.89	448.27	2625477.0
2023-08-29 13:30:00	SPY	ETF	448.275	448.76	447.67	448.07	3562673.0
2023-08-29 14:00:00	SPY	ETF	448.08	448.57	447.94	448.38	3305768.0
2023-08-29 14:30:00	SPY	ETF	448.38	448.86	448.22	448.525	3413019.0
2023-08-29 15:00:00	SPY	ETF	448.52	449.26	448.12	449.1732	4146461.0
2023-08-29 15:30:00	SPY	ETF	449.17	449.45	448.74	449.14	12767874.0
2023-08-29 16:00:00	SPY	ETF	449.15	449.47	443.0222	449.35	4231535.0
2023-08-29 16:30:00	SPY	ETF	449.34	449.37	444.0011	449.32	252002.0
2023-08-29 17:00:00	SPY	ETF	449.35	449.37	449.27	449.36	52496.0
2023-08-29 17:30:00	SPY	ETF	449.35	449.38	449.3	449.35	14333.0
2023-08-29 18:00:00	SPY	ETF	449.35	449.65	449.31	449.59	37080.0
2023-08-29 18:30:00	SPY	ETF	449.59	449.66	449.44	449.49	17954.0
2023-08-29 19:00:00	SPY	ETF	449.49	449.57	449.4	449.4	13761.0
2023-08-29 19:30:00	SPY	ETF	449.44	449.49	449.38	449.45	20188.0
2023-08-29 04:00:00	QQQ	ETF	366.81	366.95	366.4	366.68	15639.0
2023-08-29 04:30:00	QQQ	ETF	366.71	367.05	366.51	366.51	30653.0
2023-08-29 05:00:00	QQQ	ETF	366.48	366.86	366.41	366.79	13329.0
2023-08-29 05:30:00	QQQ	ETF	366.76	367.34	366.76	367.31	13737.0
2023-08-29 06:00:00	QQQ	ETF	367.32	367.4	366.8	367.02	14345.0
2023-08-29 06:30:00	QQQ	ETF	367.11	367.26	366.73	366.78	21045.0
2023-08-29 07:00:00	QQQ	ETF	366.76	366.97	366.54	366.54	20261.0
2023-08-29 07:30:00	QQQ	ETF	366.55	366.83	366.37	366.48	30420.0
2023-08-29 08:00:00	QQQ	ETF	366.621	368.01	366.0	366.03	85132.0
2023-08-29 08:30:00	QQQ	ETF	366.02	366.581	365.94	366.42	86727.0
2023-08-29 09:00:00	QQQ	ETF	366.44	366.67	366.17	366.52	78354.0
2023-08-29 09:30:00	QQQ	ETF	366.56	368.93	366.231	368.505	4370034.0
2023-08-29 10:00:00	QQQ	ETF	368.52	371.88	368.475	371.7384	7055195.0
2023-08-29 10:30:00	QQQ	ETF	371.74	372.63	371.68	372.0	5324459.0
2023-08-29 11:00:00	QQQ	ETF	371.99	373.26	371.95	373.02	3196467.0
2023-08-29 11:30:00	QQQ	ETF	373.035	374.04	372.99	373.595	3256172.0
2023-08-29 12:00:00	QQQ	ETF	373.6	374.16	373.23	374.0	2395075.0
2023-08-29 12:30:00	QQQ	ETF	374.01	374.1	373.31	373.86	1868692.0

> showing 50 of 28,127 rows — these rows as CSV

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