PREVIEW / etf_30min / 2005-05-04

all etf 30-min files

  file:    by_date/etf_30min/2005/2005-05-04.parquet
  size:    45 KB
  rows:    1,506

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-05-04 06:30:00	SPY	ETF	116.47	116.47	116.47	116.47	3500.0
2005-05-04 07:00:00	SPY	ETF	116.46	116.46	116.45	116.45	49300.0
2005-05-04 07:30:00	SPY	ETF	116.43	116.5	116.41	116.45	62600.0
2005-05-04 08:00:00	SPY	ETF	116.47	116.93	116.45	116.88	771500.0
2005-05-04 08:30:00	SPY	ETF	116.9	116.9	116.83	116.85	204300.0
2005-05-04 09:00:00	SPY	ETF	116.85	116.85	116.63	116.65	350200.0
2005-05-04 09:30:00	SPY	ETF	116.65	116.69	116.28	116.48	13148800.0
2005-05-04 10:00:00	SPY	ETF	116.46	116.77	116.37	116.76	7754000.0
2005-05-04 10:30:00	SPY	ETF	116.76	117.19	116.73	116.98	11162600.0
2005-05-04 11:00:00	SPY	ETF	116.97	117.72	116.88	117.07	3204600.0
2005-05-04 11:30:00	SPY	ETF	117.09	117.22	116.95	116.97	4276500.0
2005-05-04 12:00:00	SPY	ETF	116.98	116.99	116.75	116.84	5151000.0
2005-05-04 12:30:00	SPY	ETF	116.85	117.08	116.84	117.05	2054800.0
2005-05-04 13:00:00	SPY	ETF	117.04	117.15	116.99	117.06	2218500.0
2005-05-04 13:30:00	SPY	ETF	117.04	117.49	116.95	117.39	5063600.0
2005-05-04 14:00:00	SPY	ETF	117.39	117.51	117.31	117.37	3735400.0
2005-05-04 14:30:00	SPY	ETF	117.37	117.54	117.33	117.51	4932400.0
2005-05-04 15:00:00	SPY	ETF	117.51	117.68	117.36	117.64	4540300.0
2005-05-04 15:30:00	SPY	ETF	117.64	117.75	117.55	117.615	7304600.0
2005-05-04 16:00:00	SPY	ETF	117.62	117.71	117.47	117.53	674300.0
2005-05-04 16:30:00	SPY	ETF	117.53	117.59	117.51	117.59	107500.0
2005-05-04 17:00:00	SPY	ETF	117.58	117.59	117.54	117.57	151400.0
2005-05-04 17:30:00	SPY	ETF	117.54	117.58	117.52	117.54	7600.0
2005-05-04 18:00:00	SPY	ETF	117.52	117.55	117.46	117.46	12700.0
2005-05-04 18:30:00	SPY	ETF	117.43	117.45	117.43	117.43	3900.0
2005-05-04 19:30:00	SPY	ETF	117.46	117.48	117.46	117.48	8400.0
2005-05-04 09:30:00	QQQ	ETF	35.29	35.39	35.24	35.32	7768800.0
2005-05-04 10:00:00	QQQ	ETF	35.31	35.39	35.27	35.39	7281600.0
2005-05-04 10:30:00	QQQ	ETF	35.39	35.55	35.34	35.49	11805700.0
2005-05-04 11:00:00	QQQ	ETF	35.48	35.53	35.46	35.51	5063300.0
2005-05-04 11:30:00	QQQ	ETF	35.51	35.58	35.46	35.49	5713800.0
2005-05-04 12:00:00	QQQ	ETF	35.49	35.5	35.39	35.44	5444900.0
2005-05-04 12:30:00	QQQ	ETF	35.44	35.51	35.41	35.48	2730700.0
2005-05-04 13:00:00	QQQ	ETF	35.49	35.52	35.47	35.52	3289300.0
2005-05-04 13:30:00	QQQ	ETF	35.52	35.71	35.48	35.67	8617300.0
2005-05-04 14:00:00	QQQ	ETF	35.67	35.73	35.62	35.68	6928500.0
2005-05-04 14:30:00	QQQ	ETF	35.69	35.74	35.66	35.73	3718000.0
2005-05-04 15:00:00	QQQ	ETF	35.73	35.8	35.67	35.78	6357300.0
2005-05-04 15:30:00	QQQ	ETF	35.79	35.83	35.72	35.72	11071600.0
2005-05-04 08:00:00	IWM	ETF	58.435	58.47	58.0	58.465	181600.0
2005-05-04 08:30:00	IWM	ETF	58.525	58.525	58.515	58.515	1000.0
2005-05-04 09:00:00	IWM	ETF	58.525	58.6	58.38	58.4	18800.0
2005-05-04 09:30:00	IWM	ETF	58.385	58.465	58.215	58.41	2105200.0
2005-05-04 10:00:00	IWM	ETF	58.405	58.625	58.32	58.615	2175200.0
2005-05-04 10:30:00	IWM	ETF	58.615	58.805	58.61	58.715	2900400.0
2005-05-04 11:00:00	IWM	ETF	58.716	58.78	58.575	58.75	1066000.0
2005-05-04 11:30:00	IWM	ETF	58.76	58.87	58.72	58.745	1465200.0
2005-05-04 12:00:00	IWM	ETF	58.745	58.755	58.625	58.68	524000.0
2005-05-04 12:30:00	IWM	ETF	58.685	58.815	58.685	58.75	1093400.0
2005-05-04 13:00:00	IWM	ETF	58.755	58.915	58.75	58.86	1766800.0

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

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