PREVIEW / etf_30min / 2023-07-17

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-07-17.parquet
  size:    722 KB
  rows:    28,166

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-07-17 04:00:00	SPY	ETF	449.22	449.33	449.1	449.3	13091.0
2023-07-17 04:30:00	SPY	ETF	449.28	449.32	448.92	448.92	11876.0
2023-07-17 05:00:00	SPY	ETF	448.93	449.09	448.91	448.91	3905.0
2023-07-17 05:30:00	SPY	ETF	448.97	448.97	448.43	448.47	17859.0
2023-07-17 06:00:00	SPY	ETF	448.51	448.57	448.42	448.54	1979.0
2023-07-17 06:30:00	SPY	ETF	448.52	448.65	448.38	448.38	76326.0
2023-07-17 07:00:00	SPY	ETF	448.39	448.8	448.39	448.63	35277.0
2023-07-17 07:30:00	SPY	ETF	448.61	448.7	448.35	448.45	81234.0
2023-07-17 08:00:00	SPY	ETF	448.45	449.1	448.25	448.57	122283.0
2023-07-17 08:30:00	SPY	ETF	448.42	448.79	448.42	448.72	58996.0
2023-07-17 09:00:00	SPY	ETF	448.74	449.13	448.72	449.13	233131.0
2023-07-17 09:30:00	SPY	ETF	449.13	449.8	449.08	449.64	3989689.0
2023-07-17 10:00:00	SPY	ETF	449.64	450.085	449.6	449.84	2972022.0
2023-07-17 10:30:00	SPY	ETF	449.85	450.141	449.66	449.96	2191818.0
2023-07-17 11:00:00	SPY	ETF	449.97	450.46	449.77	450.38	2104740.0
2023-07-17 11:30:00	SPY	ETF	450.38	450.74	450.28	450.67	2868155.0
2023-07-17 12:00:00	SPY	ETF	450.69	450.73	450.2	450.24	1779284.0
2023-07-17 12:30:00	SPY	ETF	450.24	450.61	450.04	450.6	1609199.0
2023-07-17 13:00:00	SPY	ETF	450.598	450.69	450.285	450.48	1210024.0
2023-07-17 13:30:00	SPY	ETF	450.465	450.86	450.42	450.79	1261517.0
2023-07-17 14:00:00	SPY	ETF	450.8	451.13	450.645	451.0101	1683788.0
2023-07-17 14:30:00	SPY	ETF	451.01	451.0964	450.66	450.89	1480388.0
2023-07-17 15:00:00	SPY	ETF	450.89	451.93	450.89	451.54	3577337.0
2023-07-17 15:30:00	SPY	ETF	451.53	451.535	450.6	450.855	8933836.0
2023-07-17 16:00:00	SPY	ETF	450.84	451.5	450.33	450.51	2153690.0
2023-07-17 16:30:00	SPY	ETF	450.52	450.54	450.32	450.41	101178.0
2023-07-17 17:00:00	SPY	ETF	450.41	450.53	450.39	450.46	47433.0
2023-07-17 17:30:00	SPY	ETF	450.5	450.54	450.48	450.54	5667.0
2023-07-17 18:00:00	SPY	ETF	450.5	450.62	450.39	450.45	38905.0
2023-07-17 18:30:00	SPY	ETF	450.46	450.48	450.31	450.37	12356.0
2023-07-17 19:00:00	SPY	ETF	450.4	450.41	450.28	450.34	5720.0
2023-07-17 19:30:00	SPY	ETF	450.34	450.47	450.29	450.29	32001.0
2023-07-17 04:00:00	QQQ	ETF	379.51	379.77	379.41	379.72	43958.0
2023-07-17 04:30:00	QQQ	ETF	379.65	379.67	379.4	379.4	36203.0
2023-07-17 05:00:00	QQQ	ETF	379.38	379.38	379.14	379.23	7809.0
2023-07-17 05:30:00	QQQ	ETF	379.24	379.36	378.79	378.8	36321.0
2023-07-17 06:00:00	QQQ	ETF	378.91	378.97	378.58	378.9	22186.0
2023-07-17 06:30:00	QQQ	ETF	378.88	379.05	378.76	378.76	63950.0
2023-07-17 07:00:00	QQQ	ETF	378.75	379.19	378.75	379.0	55078.0
2023-07-17 07:30:00	QQQ	ETF	379.04	379.12	378.75	378.81	34050.0
2023-07-17 08:00:00	QQQ	ETF	379.0	379.5	378.53	379.02	92214.0
2023-07-17 08:30:00	QQQ	ETF	378.97	379.3	378.84	379.29	78458.0
2023-07-17 09:00:00	QQQ	ETF	379.32	379.77	379.18	379.76	188661.0
2023-07-17 09:30:00	QQQ	ETF	379.8	381.0801	379.31	380.07	5857977.0
2023-07-17 10:00:00	QQQ	ETF	380.065	380.705	379.82	380.3505	2530701.0
2023-07-17 10:30:00	QQQ	ETF	380.37	380.85	380.0402	380.44	2018318.0
2023-07-17 11:00:00	QQQ	ETF	380.47	381.1307	380.09	381.04	1743246.0
2023-07-17 11:30:00	QQQ	ETF	381.04	381.77	380.89	381.68	1913971.0
2023-07-17 12:00:00	QQQ	ETF	381.68	381.7201	380.72	380.8779	1177796.0
2023-07-17 12:30:00	QQQ	ETF	380.87	381.4296	380.56	381.41	1152475.0

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

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