PREVIEW / etf_30min / 2003-07-15

all etf 30-min files

  file:    by_date/etf_30min/2003/2003-07-15.parquet
  size:    25 KB
  rows:    719

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
2003-07-15 08:00:00	SPY	ETF	101.11	101.29	101.09	101.24	44300.0
2003-07-15 08:30:00	SPY	ETF	101.27	101.5	101.27	101.46	86300.0
2003-07-15 09:00:00	SPY	ETF	101.46	101.55	101.38	101.38	22700.0
2003-07-15 09:30:00	SPY	ETF	101.38	101.46	100.78	101.05	4215500.0
2003-07-15 10:00:00	SPY	ETF	101.01	101.25	100.59	100.86	5611200.0
2003-07-15 10:30:00	SPY	ETF	100.87	101.32	100.765	101.09	2792900.0
2003-07-15 11:00:00	SPY	ETF	101.09	101.25	100.53	100.55	1679400.0
2003-07-15 11:30:00	SPY	ETF	100.55	100.854	100.48	100.83	1427100.0
2003-07-15 12:00:00	SPY	ETF	100.81	100.86	100.67	100.77	1056800.0
2003-07-15 12:30:00	SPY	ETF	100.78	100.85	100.3	100.49	1717500.0
2003-07-15 13:00:00	SPY	ETF	100.45	100.52	100.06	100.19	2662100.0
2003-07-15 13:30:00	SPY	ETF	100.2	100.63	100.16	100.53	1796100.0
2003-07-15 14:00:00	SPY	ETF	100.54	100.55	100.073	100.09	1563900.0
2003-07-15 14:30:00	SPY	ETF	100.08	100.34	100.0	100.18	2310800.0
2003-07-15 15:00:00	SPY	ETF	100.2	100.29	99.95	100.27	2852200.0
2003-07-15 15:30:00	SPY	ETF	100.25	100.39	100.16	100.38	3608000.0
2003-07-15 16:00:00	SPY	ETF	100.39	100.71	100.36	100.68	3469000.0
2003-07-15 16:30:00	SPY	ETF	100.71	101.061	100.36	100.99	388100.0
2003-07-15 17:00:00	SPY	ETF	101.01	101.09	100.98	101.08	271900.0
2003-07-15 17:30:00	SPY	ETF	101.07	101.12	100.43	100.96	237700.0
2003-07-15 18:00:00	SPY	ETF	100.96	101.0	100.3785	101.0	20685400.0
2003-07-15 18:30:00	SPY	ETF	100.97	101.0	100.95	100.98	2600.0
2003-07-15 19:00:00	SPY	ETF	100.93	101.01	100.92	101.01	3600.0
2003-07-15 19:30:00	SPY	ETF	100.93	100.93	100.87	100.89	6700.0
2003-07-15 08:00:00	QQQ	ETF	32.45	32.5	32.41	32.43	78300.0
2003-07-15 08:30:00	QQQ	ETF	32.4	32.57	32.4	32.55	149800.0
2003-07-15 09:00:00	QQQ	ETF	32.56	32.56	32.51	32.53	86700.0
2003-07-15 09:30:00	QQQ	ETF	32.53	32.65	32.31	32.5	11645000.0
2003-07-15 10:00:00	QQQ	ETF	32.46	32.55	32.25	32.339	8315400.0
2003-07-15 10:30:00	QQQ	ETF	32.34	32.57	32.3	32.47	6734900.0
2003-07-15 11:00:00	QQQ	ETF	32.46	32.53	32.263	32.29	3701600.0
2003-07-15 11:30:00	QQQ	ETF	32.264	32.44	32.25	32.43	3254800.0
2003-07-15 12:00:00	QQQ	ETF	32.41	32.45	32.36	32.41	2815200.0
2003-07-15 12:30:00	QQQ	ETF	32.41	32.43	32.22	32.318	2563400.0
2003-07-15 13:00:00	QQQ	ETF	32.32	32.34	32.05	32.124	4449100.0
2003-07-15 13:30:00	QQQ	ETF	32.12	32.32	32.08	32.29	3005800.0
2003-07-15 14:00:00	QQQ	ETF	32.28	32.29	32.08	32.09	2239800.0
2003-07-15 14:30:00	QQQ	ETF	32.092	32.19	32.013	32.04	4258700.0
2003-07-15 15:00:00	QQQ	ETF	32.04	32.12	31.94	32.06	5595000.0
2003-07-15 15:30:00	QQQ	ETF	32.04	32.19	32.02	32.17	4395300.0
2003-07-15 16:00:00	QQQ	ETF	32.17	32.5	32.15	32.46	4118400.0
2003-07-15 16:30:00	QQQ	ETF	32.45	32.55	32.44	32.48	1726100.0
2003-07-15 17:00:00	QQQ	ETF	32.5	32.53	32.26	32.52	467700.0
2003-07-15 17:30:00	QQQ	ETF	32.5	32.55	32.49	32.501	537200.0
2003-07-15 18:00:00	QQQ	ETF	32.5	32.62	32.5	32.6	588900.0
2003-07-15 18:30:00	QQQ	ETF	32.6	32.62	32.6	32.62	52400.0
2003-07-15 19:00:00	QQQ	ETF	32.61	32.61	32.59	32.6	140000.0
2003-07-15 19:30:00	QQQ	ETF	32.6	32.61	32.56	32.6	31200.0
2003-07-15 09:00:00	IWM	ETF	48.22	48.22	48.22	48.22	1800.0
2003-07-15 09:30:00	IWM	ETF	48.15	48.15	47.755	47.885	455200.0

> showing 50 of 719 rows — these rows as CSV

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