PREVIEW / etf_30min / 2023-05-30

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-05-30.parquet
  size:    715 KB
  rows:    28,408

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-05-30 04:00:00	SPY	ETF	421.51	422.19	421.51	421.91	38786.0
2023-05-30 04:30:00	SPY	ETF	421.86	422.21	421.85	422.08	19126.0
2023-05-30 05:00:00	SPY	ETF	422.06	422.55	422.06	422.29	19200.0
2023-05-30 05:30:00	SPY	ETF	422.33	422.59	422.33	422.43	22480.0
2023-05-30 06:00:00	SPY	ETF	422.4	422.54	422.35	422.48	15186.0
2023-05-30 06:30:00	SPY	ETF	422.39	422.52	422.19	422.19	20712.0
2023-05-30 07:00:00	SPY	ETF	422.16	422.42	421.84	422.08	129056.0
2023-05-30 07:30:00	SPY	ETF	422.08	422.72	422.08	422.45	107027.0
2023-05-30 08:00:00	SPY	ETF	422.2001	422.99	421.04	422.45	354659.0
2023-05-30 08:30:00	SPY	ETF	422.46	422.65	422.17	422.45	102663.0
2023-05-30 09:00:00	SPY	ETF	422.4701	422.59	422.01	422.01	266849.0
2023-05-30 09:30:00	SPY	ETF	422.03	422.58	421.065	421.3301	7201889.0
2023-05-30 10:00:00	SPY	ETF	421.36	421.98	420.19	420.69	5491056.0
2023-05-30 10:30:00	SPY	ETF	420.69	421.28	420.29	420.68	3355727.0
2023-05-30 11:00:00	SPY	ETF	420.68	421.1	419.68	420.4501	3246829.0
2023-05-30 11:30:00	SPY	ETF	420.47	421.02	420.3401	420.7071	2857844.0
2023-05-30 12:00:00	SPY	ETF	420.7169	420.78	419.951	420.1	2244205.0
2023-05-30 12:30:00	SPY	ETF	420.11	420.55	419.48	420.52	3117625.0
2023-05-30 13:00:00	SPY	ETF	420.53	420.54	419.29	419.425	2476573.0
2023-05-30 13:30:00	SPY	ETF	419.42	419.81	418.935	419.015	3560505.0
2023-05-30 14:00:00	SPY	ETF	419.01	420.17	418.735	420.05	3355008.0
2023-05-30 14:30:00	SPY	ETF	420.06	420.975	420.06	420.2154	4080119.0
2023-05-30 15:00:00	SPY	ETF	420.215	420.45	419.78	420.28	3153833.0
2023-05-30 15:30:00	SPY	ETF	420.275	420.6	419.618	420.17	9124038.0
2023-05-30 16:00:00	SPY	ETF	420.16	420.42	420.08	420.19	2353305.0
2023-05-30 16:30:00	SPY	ETF	420.25	420.46	420.18	420.18	182210.0
2023-05-30 17:00:00	SPY	ETF	420.06	420.23	420.05	420.23	52967.0
2023-05-30 17:30:00	SPY	ETF	420.12	420.25	419.76	419.85	138972.0
2023-05-30 18:00:00	SPY	ETF	419.9	420.0	419.77	419.97	33479.0
2023-05-30 18:30:00	SPY	ETF	419.99	420.1	419.99	420.02	7677.0
2023-05-30 19:00:00	SPY	ETF	420.03	420.34	420.03	420.26	15510.0
2023-05-30 19:30:00	SPY	ETF	420.29	420.48	420.24	420.32	19307.0
2023-05-30 04:00:00	QQQ	ETF	350.7	352.09	350.11	351.65	91534.0
2023-05-30 04:30:00	QQQ	ETF	351.63	352.12	351.54	351.86	95669.0
2023-05-30 05:00:00	QQQ	ETF	351.8	352.56	351.77	352.15	54655.0
2023-05-30 05:30:00	QQQ	ETF	352.17	352.7	352.12	352.4	37982.0
2023-05-30 06:00:00	QQQ	ETF	352.38	352.63	352.31	352.44	48644.0
2023-05-30 06:30:00	QQQ	ETF	352.4	352.49	352.09	352.09	35218.0
2023-05-30 07:00:00	QQQ	ETF	352.05	352.56	352.05	352.37	123472.0
2023-05-30 07:30:00	QQQ	ETF	352.42	353.46	352.42	353.23	270685.0
2023-05-30 08:00:00	QQQ	ETF	352.0806	354.18	349.8	353.41	536034.0
2023-05-30 08:30:00	QQQ	ETF	353.39	353.69	352.9	353.1	328855.0
2023-05-30 09:00:00	QQQ	ETF	353.15	353.4	352.72	352.72	265283.0
2023-05-30 09:30:00	QQQ	ETF	352.71	353.93	350.65	351.12	11900619.0
2023-05-30 10:00:00	QQQ	ETF	351.11	351.84	350.06	350.7	6057885.0
2023-05-30 10:30:00	QQQ	ETF	350.7	351.75	350.46	351.35	3686700.0
2023-05-30 11:00:00	QQQ	ETF	351.345	351.99	350.51	351.37	3893280.0
2023-05-30 11:30:00	QQQ	ETF	351.375	352.12	351.17	351.4592	2471222.0
2023-05-30 12:00:00	QQQ	ETF	351.46	351.55	350.34	350.3999	2814140.0
2023-05-30 12:30:00	QQQ	ETF	350.42	351.2	349.89	351.2	2515517.0

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

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