PREVIEW / etf_30min / 2005-01-07

all etf 30-min files

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

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-01-07 08:00:00	SPY	ETF	118.75	119.05	118.62	119.01	60800.0
2005-01-07 08:30:00	SPY	ETF	118.98	119.17	118.42	119.06	1001000.0
2005-01-07 09:00:00	SPY	ETF	119.07	119.13	118.98	118.98	165000.0
2005-01-07 09:30:00	SPY	ETF	118.97	119.11	118.74	118.85	6835300.0
2005-01-07 10:00:00	SPY	ETF	118.81	119.12	118.41	118.51	6188000.0
2005-01-07 10:30:00	SPY	ETF	118.51	118.59	118.13	118.36	8048500.0
2005-01-07 11:00:00	SPY	ETF	118.34	119.06	118.34	118.93	6030600.0
2005-01-07 11:30:00	SPY	ETF	118.93	119.06	118.76	118.96	2720500.0
2005-01-07 12:00:00	SPY	ETF	118.96	119.07	118.76	119.05	1567800.0
2005-01-07 12:30:00	SPY	ETF	119.06	119.23	118.96	119.05	3268600.0
2005-01-07 13:00:00	SPY	ETF	119.05	119.15	118.88	118.93	1589600.0
2005-01-07 13:30:00	SPY	ETF	118.93	119.11	118.9	118.97	1196500.0
2005-01-07 14:00:00	SPY	ETF	118.98	119.07	118.8	118.84	1331600.0
2005-01-07 14:30:00	SPY	ETF	118.84	118.95	118.57	118.79	3518300.0
2005-01-07 15:00:00	SPY	ETF	118.79	118.9	118.7	118.76	2899100.0
2005-01-07 15:30:00	SPY	ETF	118.76	118.83	118.49	118.56	4387500.0
2005-01-07 16:00:00	SPY	ETF	118.57	118.76	118.34	118.37	744900.0
2005-01-07 16:30:00	SPY	ETF	118.36	119.08	118.33	118.36	728900.0
2005-01-07 17:00:00	SPY	ETF	118.39	118.39	118.36	118.37	10900.0
2005-01-07 17:30:00	SPY	ETF	118.37	118.37	118.33	118.37	4900.0
2005-01-07 18:00:00	SPY	ETF	118.36	118.36	118.35	118.35	900.0
2005-01-07 18:30:00	SPY	ETF	118.37	118.37	118.32	118.32	2700.0
2005-01-07 19:00:00	SPY	ETF	118.32	118.32	118.31	118.31	300.0
2005-01-07 19:30:00	SPY	ETF	118.37	118.37	118.36	118.36	800.0
2005-01-07 09:30:00	QQQ	ETF	38.56	38.65	38.47	38.54	15117900.0
2005-01-07 10:00:00	QQQ	ETF	38.54	38.64	38.35	38.4	15456000.0
2005-01-07 10:30:00	QQQ	ETF	38.4	38.43	38.21	38.35	15066000.0
2005-01-07 11:00:00	QQQ	ETF	38.35	39.01	38.34	38.55	9563200.0
2005-01-07 11:30:00	QQQ	ETF	38.55	38.62	38.5	38.6	6204300.0
2005-01-07 12:00:00	QQQ	ETF	38.61	38.77	38.54	38.74	6775300.0
2005-01-07 12:30:00	QQQ	ETF	38.74	38.87	38.72	38.76	7703800.0
2005-01-07 13:00:00	QQQ	ETF	38.76	38.8	38.63	38.66	3744800.0
2005-01-07 13:30:00	QQQ	ETF	38.65	38.75	38.63	38.73	3838800.0
2005-01-07 14:00:00	QQQ	ETF	38.73	38.78	38.65	38.71	14230300.0
2005-01-07 14:30:00	QQQ	ETF	38.7	38.75	38.58	38.68	7425700.0
2005-01-07 15:00:00	QQQ	ETF	38.68	38.74	38.62	38.66	4422400.0
2005-01-07 15:30:00	QQQ	ETF	38.65	38.71	38.53	38.55	7198700.0
2005-01-07 08:30:00	IWM	ETF	61.855	61.985	61.855	61.93	52600.0
2005-01-07 09:00:00	IWM	ETF	61.91	61.975	61.79	61.79	33800.0
2005-01-07 09:30:00	IWM	ETF	61.755	61.95	61.405	61.45	2948200.0
2005-01-07 10:00:00	IWM	ETF	61.485	61.69	61.085	61.115	2633600.0
2005-01-07 10:30:00	IWM	ETF	61.105	61.18	60.895	61.02	2885800.0
2005-01-07 11:00:00	IWM	ETF	61.02	61.69	61.015	61.4	1839400.0
2005-01-07 11:30:00	IWM	ETF	61.385	61.46	61.225	61.35	1194400.0
2005-01-07 12:00:00	IWM	ETF	61.36	61.52	61.28	61.495	347800.0
2005-01-07 12:30:00	IWM	ETF	61.495	61.65	61.495	61.6	1400800.0
2005-01-07 13:00:00	IWM	ETF	61.605	61.66	61.34	61.355	531600.0
2005-01-07 13:30:00	IWM	ETF	61.345	61.505	61.325	61.48	449400.0
2005-01-07 14:00:00	IWM	ETF	61.48	61.6	61.41	61.415	590600.0
2005-01-07 14:30:00	IWM	ETF	61.42	61.46	61.29	61.41	1196800.0

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

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