PREVIEW / etf_30min / 2005-06-17

all etf 30-min files

  file:    by_date/etf_30min/2005/2005-06-17.parquet
  size:    43 KB
  rows:    1,566

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-06-17 07:00:00	SPY	ETF	121.27	121.27	121.24	121.24	500.0
2005-06-17 07:30:00	SPY	ETF	121.3	121.32	121.3	121.31	35400.0
2005-06-17 08:00:00	SPY	ETF	121.31	121.32	121.22	121.25	41700.0
2005-06-17 08:30:00	SPY	ETF	121.25	121.25	121.22	121.25	198800.0
2005-06-17 09:00:00	SPY	ETF	121.29	121.64	121.29	121.54	408400.0
2005-06-17 09:30:00	SPY	ETF	121.54	121.9	121.47	121.52	12594200.0
2005-06-17 10:00:00	SPY	ETF	121.53	121.86	121.26	121.52	6178800.0
2005-06-17 10:30:00	SPY	ETF	121.51	121.72	121.42	121.46	3308900.0
2005-06-17 11:00:00	SPY	ETF	121.47	121.68	121.27	121.38	4022000.0
2005-06-17 11:30:00	SPY	ETF	121.38	121.46	121.2	121.34	2929900.0
2005-06-17 12:00:00	SPY	ETF	121.35	121.43	121.27	121.3	1532000.0
2005-06-17 12:30:00	SPY	ETF	121.31	121.45	121.3	121.4	1938300.0
2005-06-17 13:00:00	SPY	ETF	121.41	121.62	121.36	121.51	2042000.0
2005-06-17 13:30:00	SPY	ETF	121.51	121.63	121.43	121.6	1167200.0
2005-06-17 14:00:00	SPY	ETF	121.6	121.74	121.51	121.53	3426000.0
2005-06-17 14:30:00	SPY	ETF	121.53	121.56	121.39	121.46	3446300.0
2005-06-17 15:00:00	SPY	ETF	121.45	121.69	121.45	121.64	1540700.0
2005-06-17 15:30:00	SPY	ETF	121.64	121.89	121.58	121.6	3341500.0
2005-06-17 16:00:00	SPY	ETF	121.59	121.61	121.36	121.42	1436800.0
2005-06-17 16:30:00	SPY	ETF	121.42	121.45	121.4	121.44	103600.0
2005-06-17 17:00:00	SPY	ETF	121.44	121.52	121.44	121.52	41500.0
2005-06-17 17:30:00	SPY	ETF	121.46	121.52	121.45	121.45	1040600.0
2005-06-17 18:00:00	SPY	ETF	121.45	121.46	121.45	121.45	1300.0
2005-06-17 18:30:00	SPY	ETF	121.44	121.45	121.44	121.44	6600.0
2005-06-17 19:00:00	SPY	ETF	121.44	121.44	121.44	121.44	17500.0
2005-06-17 19:30:00	SPY	ETF	121.44	121.44	121.44	121.44	100.0
2005-06-17 09:30:00	QQQ	ETF	38.11	38.21	37.9	37.93	19876800.0
2005-06-17 10:00:00	QQQ	ETF	37.93	38.29	37.75	37.89	17446000.0
2005-06-17 10:30:00	QQQ	ETF	37.89	37.97	37.86	37.88	6434600.0
2005-06-17 11:00:00	QQQ	ETF	37.87	37.9	37.76	37.82	6526200.0
2005-06-17 11:30:00	QQQ	ETF	37.83	37.87	37.78	37.86	5158500.0
2005-06-17 12:00:00	QQQ	ETF	37.85	37.9	37.81	37.85	2726600.0
2005-06-17 12:30:00	QQQ	ETF	37.84	37.9	37.84	37.9	2399200.0
2005-06-17 13:00:00	QQQ	ETF	37.89	37.97	37.87	37.9	1875600.0
2005-06-17 13:30:00	QQQ	ETF	37.91	37.96	37.87	37.94	2481000.0
2005-06-17 14:00:00	QQQ	ETF	37.94	37.99	37.87	37.87	2135700.0
2005-06-17 14:30:00	QQQ	ETF	37.88	37.88	37.82	37.86	3513300.0
2005-06-17 15:00:00	QQQ	ETF	37.86	37.93	37.85	37.9	2813700.0
2005-06-17 15:30:00	QQQ	ETF	37.9	37.96	37.88	37.88	6775900.0
2005-06-17 07:30:00	IWM	ETF	64.1	64.1	64.1	64.1	100.0
2005-06-17 08:30:00	IWM	ETF	64.2	64.27	64.2	64.26	9100.0
2005-06-17 09:00:00	IWM	ETF	64.3	64.31	64.27	64.3	5000.0
2005-06-17 09:30:00	IWM	ETF	64.32	64.65	64.32	64.38	5052900.0
2005-06-17 10:00:00	IWM	ETF	64.38	64.4	64.07	64.18	2900200.0
2005-06-17 10:30:00	IWM	ETF	64.19	64.28	64.13	64.14	1247300.0
2005-06-17 11:00:00	IWM	ETF	64.14	64.2	63.94	64.0	1139800.0
2005-06-17 11:30:00	IWM	ETF	63.99	64.08	63.88	63.96	1530700.0
2005-06-17 12:00:00	IWM	ETF	63.96	64.01	63.92	63.97	329600.0
2005-06-17 12:30:00	IWM	ETF	63.96	64.14	63.96	64.1	611100.0
2005-06-17 13:00:00	IWM	ETF	64.1	64.23	64.05	64.18	1303700.0

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

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