PREVIEW / etf_30min / 2003-06-20

all etf 30-min files

  file:    by_date/etf_30min/2003/2003-06-20.parquet
  size:    23 KB
  rows:    693

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-20 08:00:00	SPY	ETF	100.0	100.1	100.0	100.05	12400.0
2003-06-20 08:30:00	SPY	ETF	100.08	100.22	100.08	100.22	20300.0
2003-06-20 09:00:00	SPY	ETF	100.24	100.5	100.22	100.39	153900.0
2003-06-20 09:30:00	SPY	ETF	100.37	100.44	99.709	99.93	5636800.0
2003-06-20 10:00:00	SPY	ETF	99.92	100.27	99.808	100.06	3149400.0
2003-06-20 10:30:00	SPY	ETF	100.06	100.42	100.02	100.21	2035900.0
2003-06-20 11:00:00	SPY	ETF	100.25	100.5	100.199	100.32	2392200.0
2003-06-20 11:30:00	SPY	ETF	100.31	100.37	100.16	100.24	867500.0
2003-06-20 12:00:00	SPY	ETF	100.243	100.35	100.18	100.29	487900.0
2003-06-20 12:30:00	SPY	ETF	100.25	100.42	100.209	100.23	487700.0
2003-06-20 13:00:00	SPY	ETF	100.23	100.29	99.74	99.78	2350400.0
2003-06-20 13:30:00	SPY	ETF	99.75	99.89	99.61	99.699	1773800.0
2003-06-20 14:00:00	SPY	ETF	99.7	100.002	99.69	99.85	1989600.0
2003-06-20 14:30:00	SPY	ETF	99.89	100.0	99.758	99.98	738200.0
2003-06-20 15:00:00	SPY	ETF	99.98	99.98	99.6	99.6	1252200.0
2003-06-20 15:30:00	SPY	ETF	99.6	99.88	99.53	99.75	3081900.0
2003-06-20 16:00:00	SPY	ETF	99.75	99.81	99.42	99.49	3660900.0
2003-06-20 16:30:00	SPY	ETF	99.48	99.6	99.43	99.6	112700.0
2003-06-20 17:00:00	SPY	ETF	99.55	99.6	99.55	99.6	3600.0
2003-06-20 17:30:00	SPY	ETF	99.6	99.6	99.59	99.6	3600.0
2003-06-20 18:00:00	SPY	ETF	99.55	99.55	99.55	99.55	500.0
2003-06-20 18:30:00	SPY	ETF	99.53	99.53	99.51	99.51	2600.0
2003-06-20 19:00:00	SPY	ETF	99.55	99.55	99.55	99.55	800.0
2003-06-20 19:30:00	SPY	ETF	99.55	99.6	99.55	99.6	2400.0
2003-06-20 08:00:00	QQQ	ETF	30.56	30.59	30.54	30.57	46400.0
2003-06-20 08:30:00	QQQ	ETF	30.58	30.67	30.57	30.67	82900.0
2003-06-20 09:00:00	QQQ	ETF	30.66	30.68	30.63	30.67	359600.0
2003-06-20 09:30:00	QQQ	ETF	30.7	30.72	30.27	30.36	14877100.0
2003-06-20 10:00:00	QQQ	ETF	30.36	30.54	30.25	30.34	8765600.0
2003-06-20 10:30:00	QQQ	ETF	30.35	30.56	30.33	30.436	4634000.0
2003-06-20 11:00:00	QQQ	ETF	30.44	30.63	30.41	30.57	4217500.0
2003-06-20 11:30:00	QQQ	ETF	30.56	30.59	30.5	30.53	2363600.0
2003-06-20 12:00:00	QQQ	ETF	30.529	30.63	30.51	30.576	2197300.0
2003-06-20 12:30:00	QQQ	ETF	30.58	30.66	30.55	30.57	2168700.0
2003-06-20 13:00:00	QQQ	ETF	30.58	30.6	30.34	30.35	3636300.0
2003-06-20 13:30:00	QQQ	ETF	30.35	30.43	30.3	30.331	3645600.0
2003-06-20 14:00:00	QQQ	ETF	30.331	30.49	30.32	30.44	3644700.0
2003-06-20 14:30:00	QQQ	ETF	30.43	30.46	30.378	30.44	3384100.0
2003-06-20 15:00:00	QQQ	ETF	30.46	30.46	30.31	30.32	4081300.0
2003-06-20 15:30:00	QQQ	ETF	30.31	30.47	30.27	30.4	5135300.0
2003-06-20 16:00:00	QQQ	ETF	30.41	30.41	30.27	30.33	1498900.0
2003-06-20 16:30:00	QQQ	ETF	30.32	30.36	30.32	30.36	67200.0
2003-06-20 17:00:00	QQQ	ETF	30.37	30.38	30.35	30.38	19500.0
2003-06-20 17:30:00	QQQ	ETF	30.38	30.38	30.378	30.38	5000.0
2003-06-20 18:00:00	QQQ	ETF	30.38	30.38	30.32	30.35	49400.0
2003-06-20 18:30:00	QQQ	ETF	30.33	30.36	30.33	30.35	1400.0
2003-06-20 19:00:00	QQQ	ETF	30.36	30.37	30.36	30.36	2300.0
2003-06-20 19:30:00	QQQ	ETF	30.36	30.36	30.34	30.34	13800.0
2003-06-20 09:30:00	IWM	ETF	45.15	45.2	44.88	44.905	717000.0
2003-06-20 10:00:00	IWM	ETF	44.935	44.975	44.815	44.845	146800.0

> showing 50 of 693 rows — these rows as CSV

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