PREVIEW / etf_30min / 2005-07-01

all etf 30-min files

  file:    by_date/etf_30min/2005/2005-07-01.parquet
  size:    42 KB
  rows:    1,512

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-01 07:00:00	SPY	ETF	119.56	119.59	119.54	119.57	7500.0
2005-07-01 07:30:00	SPY	ETF	119.57	119.57	119.54	119.54	23000.0
2005-07-01 08:00:00	SPY	ETF	119.49	119.5	119.45	119.5	76500.0
2005-07-01 08:30:00	SPY	ETF	119.47	119.47	119.37	119.42	25900.0
2005-07-01 09:00:00	SPY	ETF	119.42	119.47	119.38	119.47	49100.0
2005-07-01 09:30:00	SPY	ETF	119.45	119.53	119.35	119.5	6034200.0
2005-07-01 10:00:00	SPY	ETF	119.45	119.75	119.33	119.6	7701500.0
2005-07-01 10:30:00	SPY	ETF	119.6	119.8	119.52	119.55	7833800.0
2005-07-01 11:00:00	SPY	ETF	119.57	119.66	119.27	119.58	3634900.0
2005-07-01 11:30:00	SPY	ETF	119.58	119.6	119.32	119.33	2971600.0
2005-07-01 12:00:00	SPY	ETF	119.34	119.45	119.29	119.36	1713100.0
2005-07-01 12:30:00	SPY	ETF	119.37	119.45	119.32	119.4	1614200.0
2005-07-01 13:00:00	SPY	ETF	119.41	119.53	119.29	119.39	1929000.0
2005-07-01 13:30:00	SPY	ETF	119.39	119.53	119.34	119.4	2224400.0
2005-07-01 14:00:00	SPY	ETF	119.4	119.54	119.33	119.34	2881700.0
2005-07-01 14:30:00	SPY	ETF	119.35	119.43	119.3	119.35	1093200.0
2005-07-01 15:00:00	SPY	ETF	119.35	119.37	119.21	119.24	2593700.0
2005-07-01 15:30:00	SPY	ETF	119.25	119.54	119.22	119.5	3943900.0
2005-07-01 16:00:00	SPY	ETF	119.51	119.6	119.43	119.54	2350700.0
2005-07-01 16:30:00	SPY	ETF	119.59	119.61	119.58	119.6	4400.0
2005-07-01 17:00:00	SPY	ETF	119.61	119.61	119.54	119.59	1700.0
2005-07-01 17:30:00	SPY	ETF	119.54	119.54	119.43	119.43	13200.0
2005-07-01 18:00:00	SPY	ETF	119.45	119.46	119.45	119.45	8500.0
2005-07-01 18:30:00	SPY	ETF	119.51	119.53	119.5	119.53	400.0
2005-07-01 09:30:00	QQQ	ETF	36.87	36.94	36.82	36.86	8458600.0
2005-07-01 10:00:00	QQQ	ETF	36.87	36.96	36.84	36.93	6723800.0
2005-07-01 10:30:00	QQQ	ETF	36.94	37.0	36.88	36.89	4753500.0
2005-07-01 11:00:00	QQQ	ETF	36.89	36.93	36.81	36.89	3960200.0
2005-07-01 11:30:00	QQQ	ETF	36.89	36.91	36.79	36.8	2258200.0
2005-07-01 12:00:00	QQQ	ETF	36.79	36.86	36.77	36.81	3667000.0
2005-07-01 12:30:00	QQQ	ETF	36.81	36.81	36.76	36.79	2217800.0
2005-07-01 13:00:00	QQQ	ETF	36.79	36.86	36.74	36.83	2521800.0
2005-07-01 13:30:00	QQQ	ETF	36.82	36.86	36.8	36.82	2197000.0
2005-07-01 14:00:00	QQQ	ETF	36.82	36.87	36.8	36.81	1598100.0
2005-07-01 14:30:00	QQQ	ETF	36.81	36.82	36.77	36.77	1917000.0
2005-07-01 15:00:00	QQQ	ETF	36.77	36.77	36.68	36.7	3799300.0
2005-07-01 15:30:00	QQQ	ETF	36.7	36.79	36.69	36.72	6652700.0
2005-07-01 08:00:00	IWM	ETF	63.79	63.79	63.77	63.77	500.0
2005-07-01 08:30:00	IWM	ETF	63.72	63.72	63.72	63.72	500.0
2005-07-01 09:00:00	IWM	ETF	63.8	63.8	63.8	63.8	1000.0
2005-07-01 09:30:00	IWM	ETF	63.7	63.75	63.53	63.65	2554800.0
2005-07-01 10:00:00	IWM	ETF	63.65	63.89	63.63	63.85	2716400.0
2005-07-01 10:30:00	IWM	ETF	63.85	63.9	63.73	63.74	573300.0
2005-07-01 11:00:00	IWM	ETF	63.74	63.79	63.63	63.74	635900.0
2005-07-01 11:30:00	IWM	ETF	63.74	63.75	63.45	63.47	1080200.0
2005-07-01 12:00:00	IWM	ETF	63.48	63.57	63.44	63.52	419000.0
2005-07-01 12:30:00	IWM	ETF	63.51	63.55	63.46	63.51	529100.0
2005-07-01 13:00:00	IWM	ETF	63.52	63.63	63.47	63.6	225700.0
2005-07-01 13:30:00	IWM	ETF	63.6	63.65	63.5	63.64	724300.0
2005-07-01 14:00:00	IWM	ETF	63.62	63.69	63.56	63.64	655900.0

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

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