PREVIEW / etf_30min / 2002-08-05

all etf 30-min files

  file:    by_date/etf_30min/2002/2002-08-05.parquet
  size:    20 KB
  rows:    568

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
2002-08-05 09:30:00	SPY	ETF	86.49	86.93	85.97	86.13	5016900.0
2002-08-05 10:00:00	SPY	ETF	86.13	86.52	85.71	86.09	4689000.0
2002-08-05 10:30:00	SPY	ETF	86.09	86.26	85.56	85.56	1762000.0
2002-08-05 11:00:00	SPY	ETF	85.54	85.78	85.17	85.5	2801500.0
2002-08-05 11:30:00	SPY	ETF	85.5	85.55	85.0	85.26	1690000.0
2002-08-05 12:00:00	SPY	ETF	85.28	85.58	84.74	84.99	1847900.0
2002-08-05 12:30:00	SPY	ETF	84.97	85.01	84.53	84.6	1869500.0
2002-08-05 13:00:00	SPY	ETF	84.61	85.33	84.56	85.06	2887400.0
2002-08-05 13:30:00	SPY	ETF	85.12	85.24	84.7	84.8	1950200.0
2002-08-05 14:00:00	SPY	ETF	84.82	84.96	84.25	84.35	5803800.0
2002-08-05 14:30:00	SPY	ETF	84.31	84.71	84.21	84.39	2638000.0
2002-08-05 15:00:00	SPY	ETF	84.32	84.55	84.0	84.2	3518900.0
2002-08-05 15:30:00	SPY	ETF	84.13	84.35	83.6	83.73	4896700.0
2002-08-05 16:00:00	SPY	ETF	83.7	83.85	83.55	83.77	1658200.0
2002-08-05 09:30:00	QQQ	ETF	22.11	22.32	22.07	22.13	12964300.0
2002-08-05 10:00:00	QQQ	ETF	22.13	22.28	22.0	22.1	11628200.0
2002-08-05 10:30:00	QQQ	ETF	22.09	22.15	21.78	21.78	7288100.0
2002-08-05 11:00:00	QQQ	ETF	21.8	21.82	21.56	21.7	9023600.0
2002-08-05 11:30:00	QQQ	ETF	21.68	21.76	21.59	21.7	5134700.0
2002-08-05 12:00:00	QQQ	ETF	21.69	21.8	21.52	21.62	4142100.0
2002-08-05 12:30:00	QQQ	ETF	21.63	21.64	21.51	21.55	2716300.0
2002-08-05 13:00:00	QQQ	ETF	21.55	21.73	21.52	21.66	3362100.0
2002-08-05 13:30:00	QQQ	ETF	21.65	21.71	21.54	21.59	2591700.0
2002-08-05 14:00:00	QQQ	ETF	21.59	21.62	21.35	21.35	4939800.0
2002-08-05 14:30:00	QQQ	ETF	21.38	21.5	21.35	21.44	3890300.0
2002-08-05 15:00:00	QQQ	ETF	21.42	21.51	21.3	21.38	5055500.0
2002-08-05 15:30:00	QQQ	ETF	21.35	21.43	21.3	21.33	7115300.0
2002-08-05 16:00:00	QQQ	ETF	21.34	21.46	21.31	21.44	1098800.0
2002-08-05 09:30:00	IWM	ETF	37.485	37.61	37.425	37.53	334200.0
2002-08-05 10:00:00	IWM	ETF	37.48	37.645	37.325	37.62	232200.0
2002-08-05 10:30:00	IWM	ETF	37.55	37.55	37.25	37.325	167800.0
2002-08-05 11:00:00	IWM	ETF	37.325	37.325	37.085	37.12	80600.0
2002-08-05 11:30:00	IWM	ETF	37.225	37.225	37.05	37.1	63600.0
2002-08-05 12:00:00	IWM	ETF	37.245	37.245	37.02	37.035	62600.0
2002-08-05 12:30:00	IWM	ETF	37.035	37.035	36.83	36.85	36600.0
2002-08-05 13:00:00	IWM	ETF	36.85	37.14	36.85	37.14	145800.0
2002-08-05 13:30:00	IWM	ETF	37.095	37.11	37.02	37.025	25400.0
2002-08-05 14:00:00	IWM	ETF	37.015	37.02	36.875	36.875	39400.0
2002-08-05 14:30:00	IWM	ETF	36.955	36.97	36.84	36.86	11800.0
2002-08-05 15:00:00	IWM	ETF	36.925	36.925	36.68	36.71	103400.0
2002-08-05 15:30:00	IWM	ETF	36.695	36.705	36.485	36.485	87800.0
2002-08-05 16:00:00	IWM	ETF	36.485	36.485	36.485	36.485	200.0
2002-08-05 09:30:00	DIA	ETF	82.9	83.25	82.44	82.58	1189000.0
2002-08-05 10:00:00	DIA	ETF	82.5	83.06	82.21	82.56	713600.0
2002-08-05 10:30:00	DIA	ETF	82.57	82.79	82.11	82.18	785100.0
2002-08-05 11:00:00	DIA	ETF	82.16	82.35	81.81	82.15	864800.0
2002-08-05 11:30:00	DIA	ETF	82.11	82.15	81.65	81.95	396500.0
2002-08-05 12:00:00	DIA	ETF	81.93	82.13	81.39	81.63	389100.0
2002-08-05 12:30:00	DIA	ETF	81.6	81.68	81.14	81.17	459800.0
2002-08-05 13:00:00	DIA	ETF	81.19	81.85	81.15	81.63	371800.0

> showing 50 of 568 rows — these rows as CSV

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