PREVIEW / etf_30min / 2023-08-10

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-08-10.parquet
  size:    693 KB
  rows:    27,955

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-10 04:00:00	SPY	ETF	448.51	448.52	448.13	448.21	21388.0
2023-08-10 04:30:00	SPY	ETF	448.27	448.68	448.25	448.5	14688.0
2023-08-10 05:00:00	SPY	ETF	448.4	448.65	448.24	448.32	10591.0
2023-08-10 05:30:00	SPY	ETF	448.29	448.44	448.25	448.41	5030.0
2023-08-10 06:00:00	SPY	ETF	448.41	448.42	447.99	448.09	17279.0
2023-08-10 06:30:00	SPY	ETF	448.02	448.22	447.93	448.13	18908.0
2023-08-10 07:00:00	SPY	ETF	448.14	448.35	447.8	447.96	143187.0
2023-08-10 07:30:00	SPY	ETF	447.95	448.07	447.73	447.88	93046.0
2023-08-10 08:00:00	SPY	ETF	448.2797	448.84	447.28	448.2	310106.0
2023-08-10 08:30:00	SPY	ETF	448.4	449.72	446.76	449.03	1670467.0
2023-08-10 09:00:00	SPY	ETF	449.03	449.47	448.01	448.19	570936.0
2023-08-10 09:30:00	SPY	ETF	448.19	451.23	447.99	451.21	7655164.0
2023-08-10 10:00:00	SPY	ETF	451.22	451.7	450.55	450.95	6278481.0
2023-08-10 10:30:00	SPY	ETF	450.955	451.31	448.72	449.54	6603745.0
2023-08-10 11:00:00	SPY	ETF	449.54	449.64	447.97	448.83	5076203.0
2023-08-10 11:30:00	SPY	ETF	448.85	449.47	446.8611	447.62	5676538.0
2023-08-10 12:00:00	SPY	ETF	447.62	447.76	446.15	446.8712	4311197.0
2023-08-10 12:30:00	SPY	ETF	446.87	447.95	445.94	446.31	4012133.0
2023-08-10 13:00:00	SPY	ETF	446.29	446.825	445.73	446.06	3618859.0
2023-08-10 13:30:00	SPY	ETF	446.04	446.26	444.7	444.8623	4922919.0
2023-08-10 14:00:00	SPY	ETF	444.875	447.045	444.82	446.425	4196797.0
2023-08-10 14:30:00	SPY	ETF	446.45	447.48	445.89	447.44	3711827.0
2023-08-10 15:00:00	SPY	ETF	447.46	447.48	446.025	446.22	3613837.0
2023-08-10 15:30:00	SPY	ETF	446.19	446.19	445.025	445.93	10591284.0
2023-08-10 16:00:00	SPY	ETF	445.92	446.05	445.55	446.02	3705464.0
2023-08-10 16:30:00	SPY	ETF	446.02	446.15	445.8441	446.03	167418.0
2023-08-10 17:00:00	SPY	ETF	446.11	446.11	445.99	445.99	30823.0
2023-08-10 17:30:00	SPY	ETF	445.99	446.1	445.92	446.05	14982.0
2023-08-10 18:00:00	SPY	ETF	446.08	446.39	446.08	446.39	22084.0
2023-08-10 18:30:00	SPY	ETF	446.44	446.44	446.32	446.32	15755.0
2023-08-10 19:00:00	SPY	ETF	446.31	446.38	446.2	446.38	7737.0
2023-08-10 19:30:00	SPY	ETF	446.38	446.56	446.38	446.46	21667.0
2023-08-10 04:00:00	QQQ	ETF	370.43	370.46	370.08	370.2	54978.0
2023-08-10 04:30:00	QQQ	ETF	370.19	370.75	370.17	370.52	82315.0
2023-08-10 05:00:00	QQQ	ETF	370.4	370.63	370.21	370.32	14637.0
2023-08-10 05:30:00	QQQ	ETF	370.34	370.56	370.23	370.51	10318.0
2023-08-10 06:00:00	QQQ	ETF	370.51	370.51	370.0	370.16	33414.0
2023-08-10 06:30:00	QQQ	ETF	370.11	370.3	369.98	370.25	35730.0
2023-08-10 07:00:00	QQQ	ETF	370.21	370.56	370.01	370.2	105276.0
2023-08-10 07:30:00	QQQ	ETF	370.18	370.28	369.901	370.08	121580.0
2023-08-10 08:00:00	QQQ	ETF	370.3909	371.13	368.185	370.18	514559.0
2023-08-10 08:30:00	QQQ	ETF	370.82	372.31	369.62	371.67	1778582.0
2023-08-10 09:00:00	QQQ	ETF	371.73	372.03	370.81	370.96	731421.0
2023-08-10 09:30:00	QQQ	ETF	370.97	373.98	370.3214	373.91	6476100.0
2023-08-10 10:00:00	QQQ	ETF	373.93	374.36	373.04	373.345	4123207.0
2023-08-10 10:30:00	QQQ	ETF	373.34	373.87	371.14	371.75	4477878.0
2023-08-10 11:00:00	QQQ	ETF	371.76	371.91	370.06	370.915	3749308.0
2023-08-10 11:30:00	QQQ	ETF	370.91	371.62	368.76	369.495	3573918.0
2023-08-10 12:00:00	QQQ	ETF	369.49	369.75	368.47	369.41	2375303.0
2023-08-10 12:30:00	QQQ	ETF	369.39	370.52	368.555	368.89	2376762.0

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

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