PREVIEW / etf_30min / 2002-09-20

all etf 30-min files

  file:    by_date/etf_30min/2002/2002-09-20.parquet
  size:    20 KB
  rows:    563

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-09-20 09:30:00	SPY	ETF	84.92	85.2	84.55	84.65	5690200.0
2002-09-20 10:00:00	SPY	ETF	84.57	84.87	84.37	84.87	4454500.0
2002-09-20 10:30:00	SPY	ETF	84.88	84.96	84.07	84.21	5414700.0
2002-09-20 11:00:00	SPY	ETF	84.22	84.55	84.05	84.47	2283900.0
2002-09-20 11:30:00	SPY	ETF	84.45	84.68	84.2	84.38	1634200.0
2002-09-20 12:00:00	SPY	ETF	84.39	84.89	84.31	84.8	2955700.0
2002-09-20 12:30:00	SPY	ETF	84.8	85.0	84.68	84.78	1413500.0
2002-09-20 13:00:00	SPY	ETF	84.78	85.0	84.58	84.9	1245800.0
2002-09-20 13:30:00	SPY	ETF	84.91	84.96	84.56	84.69	1118800.0
2002-09-20 14:00:00	SPY	ETF	84.68	84.74	84.25	84.53	1873900.0
2002-09-20 14:30:00	SPY	ETF	84.52	84.8	84.17	84.56	1695100.0
2002-09-20 15:00:00	SPY	ETF	84.61	84.77	84.25	84.6	1573800.0
2002-09-20 15:30:00	SPY	ETF	84.61	85.14	84.56	84.66	5039000.0
2002-09-20 16:00:00	SPY	ETF	84.73	84.73	84.35	84.35	1661400.0
2002-09-20 09:30:00	QQQ	ETF	21.83	21.9	21.53	21.62	14703300.0
2002-09-20 10:00:00	QQQ	ETF	21.62	21.74	21.5	21.69	10770500.0
2002-09-20 10:30:00	QQQ	ETF	21.7	21.79	21.48	21.55	9660100.0
2002-09-20 11:00:00	QQQ	ETF	21.54	21.71	21.51	21.66	4551000.0
2002-09-20 11:30:00	QQQ	ETF	21.66	21.72	21.57	21.63	2974100.0
2002-09-20 12:00:00	QQQ	ETF	21.64	21.81	21.61	21.76	3317600.0
2002-09-20 12:30:00	QQQ	ETF	21.76	21.85	21.72	21.8	4480400.0
2002-09-20 13:00:00	QQQ	ETF	21.77	21.83	21.68	21.78	2358600.0
2002-09-20 13:30:00	QQQ	ETF	21.79	21.81	21.61	21.65	2474000.0
2002-09-20 14:00:00	QQQ	ETF	21.66	21.67	21.53	21.64	3090700.0
2002-09-20 14:30:00	QQQ	ETF	21.64	21.74	21.55	21.68	5317400.0
2002-09-20 15:00:00	QQQ	ETF	21.68	21.69	21.56	21.66	3025400.0
2002-09-20 15:30:00	QQQ	ETF	21.64	21.79	21.6	21.65	6860000.0
2002-09-20 16:00:00	QQQ	ETF	21.61	21.7	21.61	21.67	1443800.0
2002-09-20 09:30:00	IWM	ETF	36.875	36.965	36.4	36.64	312800.0
2002-09-20 10:00:00	IWM	ETF	36.625	36.71	36.565	36.68	74600.0
2002-09-20 10:30:00	IWM	ETF	36.69	36.715	36.455	36.48	203400.0
2002-09-20 11:00:00	IWM	ETF	36.525	36.54	36.46	36.54	84400.0
2002-09-20 11:30:00	IWM	ETF	36.55	36.6	36.5	36.5	151800.0
2002-09-20 12:00:00	IWM	ETF	36.49	36.6	36.485	36.56	62800.0
2002-09-20 12:30:00	IWM	ETF	36.6	36.615	36.535	36.535	16200.0
2002-09-20 13:00:00	IWM	ETF	36.575	36.605	36.52	36.595	7200.0
2002-09-20 13:30:00	IWM	ETF	36.545	36.605	36.495	36.515	64400.0
2002-09-20 14:00:00	IWM	ETF	36.49	36.49	36.4	36.405	87800.0
2002-09-20 14:30:00	IWM	ETF	36.45	36.53	36.4	36.53	67600.0
2002-09-20 15:00:00	IWM	ETF	36.465	36.53	36.455	36.53	136800.0
2002-09-20 15:30:00	IWM	ETF	36.495	36.68	36.495	36.565	200200.0
2002-09-20 16:00:00	IWM	ETF	36.55	36.55	36.55	36.55	600.0
2002-09-20 09:30:00	DIA	ETF	79.88	80.08	79.5	79.65	1644800.0
2002-09-20 10:00:00	DIA	ETF	79.6	79.95	79.51	79.89	933500.0
2002-09-20 10:30:00	DIA	ETF	79.9	80.05	79.23	79.36	987900.0
2002-09-20 11:00:00	DIA	ETF	79.37	79.66	79.2	79.6	565800.0
2002-09-20 11:30:00	DIA	ETF	79.59	79.79	79.41	79.59	456900.0
2002-09-20 12:00:00	DIA	ETF	79.56	80.0	79.5	79.87	347500.0
2002-09-20 12:30:00	DIA	ETF	79.89	80.09	79.72	79.9	694900.0
2002-09-20 13:00:00	DIA	ETF	79.87	80.08	79.67	79.96	532000.0

> showing 50 of 563 rows — these rows as CSV

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