PREVIEW / etf_30min / 2003-07-02

all etf 30-min files

  file:    by_date/etf_30min/2003/2003-07-02.parquet
  size:    24 KB
  rows:    698

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-02 08:00:00	SPY	ETF	98.88	98.95	98.85	98.95	3400.0
2003-07-02 08:30:00	SPY	ETF	98.95	98.95	98.69	98.75	62400.0
2003-07-02 09:00:00	SPY	ETF	98.7	98.79	98.69	98.79	24700.0
2003-07-02 09:30:00	SPY	ETF	98.77	99.2	98.57	99.19	5448700.0
2003-07-02 10:00:00	SPY	ETF	99.17	99.28	98.74	98.831	4256500.0
2003-07-02 10:30:00	SPY	ETF	98.84	99.199	98.8	99.1	1531800.0
2003-07-02 11:00:00	SPY	ETF	99.09	99.21	98.76	99.05	1653000.0
2003-07-02 11:30:00	SPY	ETF	99.06	99.15	98.9	99.13	947200.0
2003-07-02 12:00:00	SPY	ETF	99.15	99.29	99.08	99.2	1799400.0
2003-07-02 12:30:00	SPY	ETF	99.2	99.41	99.19	99.37	1486100.0
2003-07-02 13:00:00	SPY	ETF	99.35	99.47	99.09	99.36	1389500.0
2003-07-02 13:30:00	SPY	ETF	99.35	99.56	99.32	99.4	2284700.0
2003-07-02 14:00:00	SPY	ETF	99.39	99.4	99.0	99.27	2186400.0
2003-07-02 14:30:00	SPY	ETF	99.28	99.5	99.221	99.49	1701500.0
2003-07-02 15:00:00	SPY	ETF	99.49	99.61	99.3	99.38	2071700.0
2003-07-02 15:30:00	SPY	ETF	99.36	99.68	99.3	99.6	3085800.0
2003-07-02 16:00:00	SPY	ETF	99.57	99.79	99.3246	99.73	1602200.0
2003-07-02 16:30:00	SPY	ETF	99.73	99.78	99.69	99.73	204000.0
2003-07-02 17:00:00	SPY	ETF	99.7	99.73	99.7	99.72	6400.0
2003-07-02 17:30:00	SPY	ETF	99.72	99.72	99.69	99.71	14700.0
2003-07-02 18:00:00	SPY	ETF	99.73	99.75	99.72	99.72	300.0
2003-07-02 18:30:00	SPY	ETF	99.73	99.73	99.71	99.71	600.0
2003-07-02 19:00:00	SPY	ETF	99.75	99.75	99.75	99.75	900.0
2003-07-02 19:30:00	SPY	ETF	99.75	99.75	99.75	99.75	200.0
2003-07-02 08:00:00	QQQ	ETF	30.47	30.51	30.46	30.5	47300.0
2003-07-02 08:30:00	QQQ	ETF	30.51	30.51	30.4	30.45	58300.0
2003-07-02 09:00:00	QQQ	ETF	30.44	30.47	30.4	30.43	112200.0
2003-07-02 09:30:00	QQQ	ETF	30.412	30.621	30.38	30.62	12900600.0
2003-07-02 10:00:00	QQQ	ETF	30.61	30.73	30.5	30.541	7294900.0
2003-07-02 10:30:00	QQQ	ETF	30.54	30.72	30.52	30.682	6788000.0
2003-07-02 11:00:00	QQQ	ETF	30.69	30.73	30.51	30.64	3965700.0
2003-07-02 11:30:00	QQQ	ETF	30.629	30.69	30.57	30.68	2196000.0
2003-07-02 12:00:00	QQQ	ETF	30.68	30.75	30.67	30.719	3328200.0
2003-07-02 12:30:00	QQQ	ETF	30.74	30.84	30.719	30.82	4799200.0
2003-07-02 13:00:00	QQQ	ETF	30.84	30.87	30.71	30.86	5054200.0
2003-07-02 13:30:00	QQQ	ETF	30.83	30.89	30.81	30.82	5743100.0
2003-07-02 14:00:00	QQQ	ETF	30.81	30.83	30.67	30.77	4590600.0
2003-07-02 14:30:00	QQQ	ETF	30.76	30.84	30.73	30.83	4030400.0
2003-07-02 15:00:00	QQQ	ETF	30.82	30.88	30.69	30.764	4892900.0
2003-07-02 15:30:00	QQQ	ETF	30.76	30.93	30.75	30.91	6687300.0
2003-07-02 16:00:00	QQQ	ETF	30.91	30.99	30.88	30.93	2426800.0
2003-07-02 16:30:00	QQQ	ETF	30.93	30.98	30.9	30.93	327200.0
2003-07-02 17:00:00	QQQ	ETF	30.92	30.94	30.91	30.93	22700.0
2003-07-02 17:30:00	QQQ	ETF	30.92	30.94	30.92	30.93	8200.0
2003-07-02 18:00:00	QQQ	ETF	30.93	30.95	30.93	30.93	7700.0
2003-07-02 18:30:00	QQQ	ETF	30.93	30.95	30.93	30.95	2200.0
2003-07-02 19:00:00	QQQ	ETF	30.93	30.96	30.93	30.96	10400.0
2003-07-02 19:30:00	QQQ	ETF	30.97	30.97	30.93	30.96	13600.0
2003-07-02 20:00:00	QQQ	ETF	30.95	30.95	30.95	30.95	100.0
2003-07-02 09:00:00	IWM	ETF	44.81	44.81	44.81	44.81	200.0

> showing 50 of 698 rows — these rows as CSV

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