PREVIEW / etf_30min / 2003-07-31

all etf 30-min files

  file:    by_date/etf_30min/2003/2003-07-31.parquet
  size:    24 KB
  rows:    706

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-31 08:00:00	SPY	ETF	99.16	99.18	99.0	99.15	26700.0
2003-07-31 08:30:00	SPY	ETF	99.18	99.87	99.18	99.8	221800.0
2003-07-31 09:00:00	SPY	ETF	99.82	99.98	99.77	99.97	80800.0
2003-07-31 09:30:00	SPY	ETF	99.98	100.214	99.38	99.89	5107000.0
2003-07-31 10:00:00	SPY	ETF	99.857	100.11	99.172	99.64	8204800.0
2003-07-31 10:30:00	SPY	ETF	99.51	100.74	99.51	100.74	7035600.0
2003-07-31 11:00:00	SPY	ETF	100.74	100.94	100.61	100.76	3534000.0
2003-07-31 11:30:00	SPY	ETF	100.73	100.8	100.58	100.64	1326300.0
2003-07-31 12:00:00	SPY	ETF	100.59	100.78	100.55	100.68	1438100.0
2003-07-31 12:30:00	SPY	ETF	100.66	100.78	100.54	100.73	981900.0
2003-07-31 13:00:00	SPY	ETF	100.73	100.9	100.7	100.79	1350900.0
2003-07-31 13:30:00	SPY	ETF	100.77	100.81	100.65	100.76	1295200.0
2003-07-31 14:00:00	SPY	ETF	100.769	100.86	100.61	100.61	1199000.0
2003-07-31 14:30:00	SPY	ETF	100.62	100.65	100.1	100.27	4414400.0
2003-07-31 15:00:00	SPY	ETF	100.3	100.54	99.93	99.93	3217100.0
2003-07-31 15:30:00	SPY	ETF	99.95	100.01	99.25	99.41	7334300.0
2003-07-31 16:00:00	SPY	ETF	99.41	99.44	99.1318	99.36	3740100.0
2003-07-31 16:30:00	SPY	ETF	99.35	99.46	99.35	99.4	62700.0
2003-07-31 17:00:00	SPY	ETF	99.4	99.47	99.38	99.44	15000.0
2003-07-31 17:30:00	SPY	ETF	99.44	99.49	99.44	99.45	2400.0
2003-07-31 18:00:00	SPY	ETF	99.41	99.42	99.25	99.25	4141200.0
2003-07-31 18:30:00	SPY	ETF	99.48	99.6	99.4	99.6	1400.0
2003-07-31 19:00:00	SPY	ETF	99.52	99.55	99.52	99.55	2100.0
2003-07-31 19:30:00	SPY	ETF	99.56	99.56	99.5	99.5	7700.0
2003-07-31 08:00:00	QQQ	ETF	31.47	31.49	31.44	31.46	111200.0
2003-07-31 08:30:00	QQQ	ETF	31.48	31.8	31.48	31.78	410700.0
2003-07-31 09:00:00	QQQ	ETF	31.78	31.82	31.76	31.78	139500.0
2003-07-31 09:30:00	QQQ	ETF	31.79	31.925	31.63	31.85	9628600.0
2003-07-31 10:00:00	QQQ	ETF	31.83	31.92	31.52	31.72	7396700.0
2003-07-31 10:30:00	QQQ	ETF	31.717	32.23	31.68	32.201	13163600.0
2003-07-31 11:00:00	QQQ	ETF	32.23	32.31	32.15	32.22	8025100.0
2003-07-31 11:30:00	QQQ	ETF	32.213	32.235	32.13	32.14	3160000.0
2003-07-31 12:00:00	QQQ	ETF	32.16	32.24	32.14	32.18	2059300.0
2003-07-31 12:30:00	QQQ	ETF	32.19	32.26	32.14	32.22	1744500.0
2003-07-31 13:00:00	QQQ	ETF	32.22	32.29	32.203	32.231	2348300.0
2003-07-31 13:30:00	QQQ	ETF	32.235	32.25	32.17	32.22	1869100.0
2003-07-31 14:00:00	QQQ	ETF	32.22	32.26	32.12	32.13	2297600.0
2003-07-31 14:30:00	QQQ	ETF	32.13	32.14	31.95	32.02	6416200.0
2003-07-31 15:00:00	QQQ	ETF	32.01	32.16	31.936	31.96	5492500.0
2003-07-31 15:30:00	QQQ	ETF	31.95	32.0	31.66	31.709	11199900.0
2003-07-31 16:00:00	QQQ	ETF	31.7	31.84	31.69	31.76	2226700.0
2003-07-31 16:30:00	QQQ	ETF	31.78	31.8	31.4111	31.79	1181100.0
2003-07-31 17:00:00	QQQ	ETF	31.78	31.8	31.76	31.79	17500.0
2003-07-31 17:30:00	QQQ	ETF	31.78	31.807	31.77	31.8	11200.0
2003-07-31 18:00:00	QQQ	ETF	31.79	31.8	31.77	31.8	22800.0
2003-07-31 18:30:00	QQQ	ETF	31.8	31.83	31.8	31.82	12300.0
2003-07-31 19:00:00	QQQ	ETF	31.81	31.81	31.81	31.81	6500.0
2003-07-31 19:30:00	QQQ	ETF	31.82	31.9	31.82	31.86	11900.0
2003-07-31 08:30:00	IWM	ETF	47.29	47.34	47.28	47.34	55400.0
2003-07-31 09:00:00	IWM	ETF	47.325	47.325	47.325	47.325	1000.0

> showing 50 of 706 rows — these rows as CSV

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