PREVIEW / etf_30min / 2023-08-03

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-08-03.parquet
  size:    711 KB
  rows:    28,731

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-03 04:00:00	SPY	ETF	447.91	450.13	447.87	448.68	31275.0
2023-08-03 04:30:00	SPY	ETF	448.59	448.74	447.96	448.74	14353.0
2023-08-03 05:00:00	SPY	ETF	448.74	449.36	448.74	449.07	29007.0
2023-08-03 05:30:00	SPY	ETF	449.09	449.4	449.07	449.39	11091.0
2023-08-03 06:00:00	SPY	ETF	449.34	449.8	449.28	449.35	42901.0
2023-08-03 06:30:00	SPY	ETF	449.4	449.6	449.2	449.3	16178.0
2023-08-03 07:00:00	SPY	ETF	449.31	449.9	449.0	449.1	73956.0
2023-08-03 07:30:00	SPY	ETF	449.18	449.55	448.97	449.23	47674.0
2023-08-03 08:00:00	SPY	ETF	449.68	450.9	448.0	448.58	262458.0
2023-08-03 08:30:00	SPY	ETF	448.68	449.41	448.39	448.85	340986.0
2023-08-03 09:00:00	SPY	ETF	448.89	448.9094	448.01	448.04	283445.0
2023-08-03 09:30:00	SPY	ETF	448.04	449.0	447.63	448.561	6478276.0
2023-08-03 10:00:00	SPY	ETF	448.55	449.3	447.4088	447.42	5930946.0
2023-08-03 10:30:00	SPY	ETF	447.43	448.52	447.37	448.49	3631868.0
2023-08-03 11:00:00	SPY	ETF	448.49	449.56	448.38	449.38	3599788.0
2023-08-03 11:30:00	SPY	ETF	449.4	449.87	449.09	449.275	3094953.0
2023-08-03 12:00:00	SPY	ETF	449.28	449.8	449.13	449.67	1725390.0
2023-08-03 12:30:00	SPY	ETF	449.675	450.74	449.665	450.56	2735992.0
2023-08-03 13:00:00	SPY	ETF	450.56	450.79	450.19	450.48	2753256.0
2023-08-03 13:30:00	SPY	ETF	450.47	450.57	449.43	449.5101	2385348.0
2023-08-03 14:00:00	SPY	ETF	449.515	450.04	449.2599	449.8101	2314622.0
2023-08-03 14:30:00	SPY	ETF	449.83	450.12	449.2801	449.97	1878575.0
2023-08-03 15:00:00	SPY	ETF	449.99	450.03	448.775	449.23	2754758.0
2023-08-03 15:30:00	SPY	ETF	449.23	449.65	448.79	448.84	7298838.0
2023-08-03 16:00:00	SPY	ETF	448.84	450.66	448.58	450.4	2523809.0
2023-08-03 16:30:00	SPY	ETF	450.4	451.14	448.85	449.27	722148.0
2023-08-03 17:00:00	SPY	ETF	449.1	449.39	448.91	449.14	61165.0
2023-08-03 17:30:00	SPY	ETF	449.0	449.14	448.72	449.14	73307.0
2023-08-03 18:00:00	SPY	ETF	449.14	449.6	449.06	449.42	106600.0
2023-08-03 18:30:00	SPY	ETF	449.47	450.03	449.4	449.86	36216.0
2023-08-03 19:00:00	SPY	ETF	449.92	450.2	449.73	449.73	24174.0
2023-08-03 19:30:00	SPY	ETF	449.76	449.9	449.58	449.88	39487.0
2023-08-03 04:00:00	QQQ	ETF	371.74	373.19	371.63	372.69	48626.0
2023-08-03 04:30:00	QQQ	ETF	372.69	372.81	372.0	372.7	18201.0
2023-08-03 05:00:00	QQQ	ETF	372.81	373.57	372.81	373.36	23911.0
2023-08-03 05:30:00	QQQ	ETF	373.24	373.49	373.05	373.47	24088.0
2023-08-03 06:00:00	QQQ	ETF	373.68	373.83	373.29	373.29	11352.0
2023-08-03 06:30:00	QQQ	ETF	373.3	373.63	373.11	373.23	61659.0
2023-08-03 07:00:00	QQQ	ETF	373.25	374.01	372.86	373.111	110375.0
2023-08-03 07:30:00	QQQ	ETF	373.17	373.5	372.9	373.04	142983.0
2023-08-03 08:00:00	QQQ	ETF	373.84	374.81	371.61	372.46	378527.0
2023-08-03 08:30:00	QQQ	ETF	372.31	373.14	372.08	372.45	501912.0
2023-08-03 09:00:00	QQQ	ETF	372.43	372.43	371.76	371.91	438636.0
2023-08-03 09:30:00	QQQ	ETF	371.94	374.36	371.77	373.83	5848268.0
2023-08-03 10:00:00	QQQ	ETF	373.81	374.57	371.86	371.89	3729113.0
2023-08-03 10:30:00	QQQ	ETF	371.9	373.72	371.83	373.56	2807791.0
2023-08-03 11:00:00	QQQ	ETF	373.555	374.85	373.34	374.45	2297225.0
2023-08-03 11:30:00	QQQ	ETF	374.4599	375.03	374.045	374.22	2331469.0
2023-08-03 12:00:00	QQQ	ETF	374.2219	374.9188	373.96	374.73	1189920.0
2023-08-03 12:30:00	QQQ	ETF	374.735	375.95	374.64	375.59	2143739.0

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

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