PREVIEW / etf_30min / 2002-06-18

all etf 30-min files

  file:    by_date/etf_30min/2002/2002-06-18.parquet
  size:    18 KB
  rows:    519

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-06-18 09:30:00	SPY	ETF	103.74	104.12	103.63	104.03	2157800.0
2002-06-18 10:00:00	SPY	ETF	104.07	104.46	103.85	104.31	2683200.0
2002-06-18 10:30:00	SPY	ETF	104.31	104.7	104.18	104.57	1644200.0
2002-06-18 11:00:00	SPY	ETF	104.58	104.58	104.03	104.24	1151100.0
2002-06-18 11:30:00	SPY	ETF	104.24	104.74	104.21	104.62	890500.0
2002-06-18 12:00:00	SPY	ETF	104.6	104.65	104.37	104.42	843300.0
2002-06-18 12:30:00	SPY	ETF	104.42	104.55	104.07	104.1	875800.0
2002-06-18 13:00:00	SPY	ETF	104.12	104.25	103.92	104.05	744300.0
2002-06-18 13:30:00	SPY	ETF	104.05	104.37	104.0	104.25	485500.0
2002-06-18 14:00:00	SPY	ETF	104.17	104.52	104.07	104.1	625800.0
2002-06-18 14:30:00	SPY	ETF	104.07	104.55	104.04	104.5	856700.0
2002-06-18 15:00:00	SPY	ETF	104.51	104.64	104.29	104.38	869400.0
2002-06-18 15:30:00	SPY	ETF	104.4	104.46	104.14	104.25	1762800.0
2002-06-18 16:00:00	SPY	ETF	104.22	105.48	104.19	104.95	5205400.0
2002-06-18 16:30:00	SPY	ETF	104.9	105.07	104.63	104.66	444200.0
2002-06-18 17:00:00	SPY	ETF	104.66	104.7	104.59	104.59	11000.0
2002-06-18 17:30:00	SPY	ETF	104.65	104.65	104.2	104.38	146800.0
2002-06-18 18:00:00	SPY	ETF	104.42	104.5	104.32	104.39	85700.0
2002-06-18 09:30:00	QQQ	ETF	28.31	28.63	28.31	28.56	12057500.0
2002-06-18 10:00:00	QQQ	ETF	28.56	28.9	28.44	28.83	13215900.0
2002-06-18 10:30:00	QQQ	ETF	28.85	28.95	28.71	28.82	7177400.0
2002-06-18 11:00:00	QQQ	ETF	28.81	28.86	28.5	28.58	5870700.0
2002-06-18 11:30:00	QQQ	ETF	28.58	28.83	28.58	28.77	5209200.0
2002-06-18 12:00:00	QQQ	ETF	28.76	28.82	28.63	28.64	2639400.0
2002-06-18 12:30:00	QQQ	ETF	28.65	28.75	28.5	28.53	4790500.0
2002-06-18 13:00:00	QQQ	ETF	28.52	28.57	28.31	28.36	4911000.0
2002-06-18 13:30:00	QQQ	ETF	28.37	28.57	28.34	28.48	4407900.0
2002-06-18 14:00:00	QQQ	ETF	28.48	28.64	28.41	28.46	4250700.0
2002-06-18 14:30:00	QQQ	ETF	28.46	28.64	28.43	28.59	3464100.0
2002-06-18 15:00:00	QQQ	ETF	28.59	28.68	28.49	28.55	3662100.0
2002-06-18 15:30:00	QQQ	ETF	28.53	28.55	28.32	28.33	5777800.0
2002-06-18 16:00:00	QQQ	ETF	28.35	29.25	28.24	28.87	14389600.0
2002-06-18 16:30:00	QQQ	ETF	28.87	28.88	28.52	28.61	3871100.0
2002-06-18 17:00:00	QQQ	ETF	28.62	28.67	28.53	28.53	1005700.0
2002-06-18 17:30:00	QQQ	ETF	28.53	28.57	28.23	28.26	1529700.0
2002-06-18 18:00:00	QQQ	ETF	28.28	28.38	28.26	28.32	423300.0
2002-06-18 09:30:00	IWM	ETF	46.765	46.91	46.68	46.89	169200.0
2002-06-18 10:00:00	IWM	ETF	46.895	47.255	46.785	47.255	358400.0
2002-06-18 10:30:00	IWM	ETF	47.195	47.275	47.12	47.2	168000.0
2002-06-18 11:00:00	IWM	ETF	47.16	47.245	46.96	47.04	149800.0
2002-06-18 11:30:00	IWM	ETF	47.05	47.125	47.015	47.09	108000.0
2002-06-18 12:00:00	IWM	ETF	47.06	47.125	46.97	46.97	65000.0
2002-06-18 12:30:00	IWM	ETF	46.97	47.0	46.84	46.84	40800.0
2002-06-18 13:00:00	IWM	ETF	46.845	46.845	46.575	46.575	91800.0
2002-06-18 13:30:00	IWM	ETF	46.595	46.77	46.595	46.77	9000.0
2002-06-18 14:00:00	IWM	ETF	46.64	46.775	46.64	46.76	96800.0
2002-06-18 14:30:00	IWM	ETF	46.73	46.815	46.69	46.81	56200.0
2002-06-18 15:00:00	IWM	ETF	46.83	46.9	46.76	46.875	106000.0
2002-06-18 15:30:00	IWM	ETF	46.83	46.945	46.69	46.69	244200.0
2002-06-18 16:00:00	IWM	ETF	46.665	46.945	46.665	46.71	220800.0

> showing 50 of 519 rows — these rows as CSV

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