PREVIEW / etf_30min / 2003-06-25

all etf 30-min files

  file:    by_date/etf_30min/2003/2003-06-25.parquet
  size:    24 KB
  rows:    700

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-06-25 08:00:00	SPY	ETF	98.61	98.71	98.61	98.71	35200.0
2003-06-25 08:30:00	SPY	ETF	98.67	98.7	98.55	98.6	22900.0
2003-06-25 09:00:00	SPY	ETF	98.57	98.58	98.46	98.53	96400.0
2003-06-25 09:30:00	SPY	ETF	98.53	99.07	98.51	99.07	2898900.0
2003-06-25 10:00:00	SPY	ETF	99.07	99.333	98.98	99.101	3503500.0
2003-06-25 10:30:00	SPY	ETF	99.11	99.3	99.06	99.25	1344100.0
2003-06-25 11:00:00	SPY	ETF	99.25	99.44	99.17	99.28	1299000.0
2003-06-25 11:30:00	SPY	ETF	99.27	99.3	99.1	99.18	852600.0
2003-06-25 12:00:00	SPY	ETF	99.17	99.27	99.14	99.188	632300.0
2003-06-25 12:30:00	SPY	ETF	99.19	99.297	99.172	99.29	413200.0
2003-06-25 13:00:00	SPY	ETF	99.289	99.32	99.16	99.23	799600.0
2003-06-25 13:30:00	SPY	ETF	99.22	99.34	98.88	98.9	2821300.0
2003-06-25 14:00:00	SPY	ETF	98.92	99.24	98.28	98.75	12201900.0
2003-06-25 14:30:00	SPY	ETF	98.77	99.07	98.6	98.843	3151300.0
2003-06-25 15:00:00	SPY	ETF	98.84	98.98	97.92	98.15	4682700.0
2003-06-25 15:30:00	SPY	ETF	98.12	98.14	97.67	97.86	3932000.0
2003-06-25 16:00:00	SPY	ETF	97.84	97.86	97.53	97.54	3707700.0
2003-06-25 16:30:00	SPY	ETF	97.55	97.64	97.52	97.63	149700.0
2003-06-25 17:00:00	SPY	ETF	97.65	97.67	97.62	97.66	117500.0
2003-06-25 17:30:00	SPY	ETF	97.66	97.69	97.59	97.61	73300.0
2003-06-25 18:00:00	SPY	ETF	97.6	97.61	97.56	97.61	4100.0
2003-06-25 18:30:00	SPY	ETF	97.62	97.62	97.61	97.61	500.0
2003-06-25 19:00:00	SPY	ETF	97.61	97.61	97.6	97.6	1600.0
2003-06-25 19:30:00	SPY	ETF	97.61	97.63	97.56	97.56	5100.0
2003-06-25 08:00:00	QQQ	ETF	29.7	29.75	29.7	29.72	37700.0
2003-06-25 08:30:00	QQQ	ETF	29.72	29.72	29.61	29.65	89100.0
2003-06-25 09:00:00	QQQ	ETF	29.65	29.69	29.61	29.67	161900.0
2003-06-25 09:30:00	QQQ	ETF	29.67	29.95	29.636	29.93	7603700.0
2003-06-25 10:00:00	QQQ	ETF	29.91	30.07	29.88	29.96	8048900.0
2003-06-25 10:30:00	QQQ	ETF	29.951	30.1	29.93	30.07	3904000.0
2003-06-25 11:00:00	QQQ	ETF	30.07	30.18	30.06	30.09	5020700.0
2003-06-25 11:30:00	QQQ	ETF	30.1	30.1	29.98	30.04	3251700.0
2003-06-25 12:00:00	QQQ	ETF	30.03	30.13	30.01	30.04	1184500.0
2003-06-25 12:30:00	QQQ	ETF	30.043	30.14	30.03	30.13	1455700.0
2003-06-25 13:00:00	QQQ	ETF	30.12	30.15	30.08	30.08	1395300.0
2003-06-25 13:30:00	QQQ	ETF	30.08	30.15	29.95	29.974	4631400.0
2003-06-25 14:00:00	QQQ	ETF	29.974	30.14	29.79	29.95	12348200.0
2003-06-25 14:30:00	QQQ	ETF	29.92	30.08	29.83	29.928	9247400.0
2003-06-25 15:00:00	QQQ	ETF	29.9	29.98	29.5	29.692	11566300.0
2003-06-25 15:30:00	QQQ	ETF	29.67	29.73	29.49	29.62	9588500.0
2003-06-25 16:00:00	QQQ	ETF	29.623	29.63	29.48	29.51	1758400.0
2003-06-25 16:30:00	QQQ	ETF	29.5	29.54	29.499	29.51	390400.0
2003-06-25 17:00:00	QQQ	ETF	29.503	29.54	29.503	29.52	36600.0
2003-06-25 17:30:00	QQQ	ETF	29.53	29.54	29.497	29.52	38000.0
2003-06-25 18:00:00	QQQ	ETF	29.51	29.54	29.5	29.52	22500.0
2003-06-25 18:30:00	QQQ	ETF	29.52	29.53	29.51	29.53	3000.0
2003-06-25 19:00:00	QQQ	ETF	29.53	29.57	29.52	29.56	6200.0
2003-06-25 19:30:00	QQQ	ETF	29.56	29.56	29.53	29.55	8700.0
2003-06-25 20:00:00	QQQ	ETF	29.53	29.53	29.53	29.53	200.0
2003-06-25 09:30:00	IWM	ETF	43.835	44.11	43.835	44.085	481200.0

> showing 50 of 700 rows — these rows as CSV

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