PREVIEW / etf_30min / 2005-07-25

all etf 30-min files

  file:    by_date/etf_30min/2005/2005-07-25.parquet
  size:    45 KB
  rows:    1,597

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
2005-07-25 07:00:00	SPY	ETF	123.29	123.45	123.29	123.45	12900.0
2005-07-25 07:30:00	SPY	ETF	123.42	123.42	123.4	123.4	27000.0
2005-07-25 08:00:00	SPY	ETF	123.37	123.47	123.37	123.45	366400.0
2005-07-25 08:30:00	SPY	ETF	123.42	123.46	123.42	123.46	32500.0
2005-07-25 09:00:00	SPY	ETF	123.45	123.48	123.4	123.42	408700.0
2005-07-25 09:30:00	SPY	ETF	123.41	123.61	123.36	123.38	4162600.0
2005-07-25 10:00:00	SPY	ETF	123.38	123.59	123.27	123.5	6710700.0
2005-07-25 10:30:00	SPY	ETF	123.49	123.95	123.41	123.81	6617300.0
2005-07-25 11:00:00	SPY	ETF	123.82	123.82	123.59	123.64	2584700.0
2005-07-25 11:30:00	SPY	ETF	123.64	123.66	123.44	123.6	3094000.0
2005-07-25 12:00:00	SPY	ETF	123.6	123.62	123.39	123.42	2295400.0
2005-07-25 12:30:00	SPY	ETF	123.41	123.45	123.29	123.32	2095500.0
2005-07-25 13:00:00	SPY	ETF	123.32	123.49	123.25	123.45	2146100.0
2005-07-25 13:30:00	SPY	ETF	123.45	123.53	123.34	123.36	1770400.0
2005-07-25 14:00:00	SPY	ETF	123.39	123.41	123.25	123.29	1956900.0
2005-07-25 14:30:00	SPY	ETF	123.29	123.31	122.87	122.95	9038400.0
2005-07-25 15:00:00	SPY	ETF	122.95	123.06	122.85	122.99	5932200.0
2005-07-25 15:30:00	SPY	ETF	122.98	123.1	122.89	122.93	4574600.0
2005-07-25 16:00:00	SPY	ETF	122.92	123.2	122.92	123.15	766500.0
2005-07-25 16:30:00	SPY	ETF	123.15	123.18	123.13	123.17	156600.0
2005-07-25 17:00:00	SPY	ETF	123.19	123.2	122.97	123.2	138100.0
2005-07-25 17:30:00	SPY	ETF	123.21	123.23	123.11	123.23	2000.0
2005-07-25 18:00:00	SPY	ETF	123.22	123.26	123.22	123.26	6000.0
2005-07-25 18:30:00	SPY	ETF	123.18	123.18	123.18	123.18	100.0
2005-07-25 19:00:00	SPY	ETF	123.17	123.18	123.17	123.18	4700.0
2005-07-25 19:30:00	SPY	ETF	123.21	123.21	123.2	123.21	2600.0
2005-07-25 09:30:00	QQQ	ETF	39.45	39.54	39.43	39.44	5692200.0
2005-07-25 10:00:00	QQQ	ETF	39.44	39.53	39.38	39.47	4461200.0
2005-07-25 10:30:00	QQQ	ETF	39.48	39.63	39.44	39.58	4165500.0
2005-07-25 11:00:00	QQQ	ETF	39.58	39.58	39.46	39.46	3355000.0
2005-07-25 11:30:00	QQQ	ETF	39.47	39.47	39.38	39.43	3726200.0
2005-07-25 12:00:00	QQQ	ETF	39.43	39.47	39.31	39.33	2250600.0
2005-07-25 12:30:00	QQQ	ETF	39.33	39.4	39.28	39.29	2282200.0
2005-07-25 13:00:00	QQQ	ETF	39.29	39.33	39.28	39.33	2160100.0
2005-07-25 13:30:00	QQQ	ETF	39.33	39.37	39.3	39.31	1956100.0
2005-07-25 14:00:00	QQQ	ETF	39.31	39.37	39.28	39.32	1977800.0
2005-07-25 14:30:00	QQQ	ETF	39.32	39.32	39.21	39.23	3945000.0
2005-07-25 15:00:00	QQQ	ETF	39.23	39.28	39.2	39.25	4671900.0
2005-07-25 15:30:00	QQQ	ETF	39.25	39.31	39.23	39.25	4569400.0
2005-07-25 07:30:00	IWM	ETF	67.36	67.36	67.36	67.36	200.0
2005-07-25 08:00:00	IWM	ETF	67.34	67.34	67.3	67.3	2000.0
2005-07-25 08:30:00	IWM	ETF	67.28	67.28	67.28	67.28	400.0
2005-07-25 09:00:00	IWM	ETF	67.34	67.36	67.27	67.31	70000.0
2005-07-25 09:30:00	IWM	ETF	67.3	67.46	67.26	67.27	1731900.0
2005-07-25 10:00:00	IWM	ETF	67.27	67.54	67.17	67.46	1834200.0
2005-07-25 10:30:00	IWM	ETF	67.47	67.68	67.42	67.63	2676900.0
2005-07-25 11:00:00	IWM	ETF	67.63	67.65	67.42	67.45	938700.0
2005-07-25 11:30:00	IWM	ETF	67.45	67.5	67.27	67.4	839000.0
2005-07-25 12:00:00	IWM	ETF	67.41	67.47	67.18	67.19	2181400.0
2005-07-25 12:30:00	IWM	ETF	67.19	67.22	67.09	67.15	709600.0

> showing 50 of 1,597 rows — these rows as CSV

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