PREVIEW / etf_30min / 2005-01-20

all etf 30-min files

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

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-20 08:00:00	SPY	ETF	117.82	117.86	117.8	117.85	247200.0
2005-01-20 08:30:00	SPY	ETF	117.85	117.89	117.85	117.86	69400.0
2005-01-20 09:00:00	SPY	ETF	117.86	117.94	117.81	117.9	243700.0
2005-01-20 09:30:00	SPY	ETF	117.89	118.05	117.67	117.77	8575900.0
2005-01-20 10:00:00	SPY	ETF	117.76	118.2	117.7	117.88	10338700.0
2005-01-20 10:30:00	SPY	ETF	117.88	118.0	117.73	117.88	3935300.0
2005-01-20 11:00:00	SPY	ETF	117.89	118.15	117.87	117.97	2212500.0
2005-01-20 11:30:00	SPY	ETF	117.98	118.19	117.93	118.01	2347400.0
2005-01-20 12:00:00	SPY	ETF	118.02	118.03	117.81	117.85	3825600.0
2005-01-20 12:30:00	SPY	ETF	117.84	117.96	117.71	117.75	1932300.0
2005-01-20 13:00:00	SPY	ETF	117.75	117.85	117.29	117.52	6725900.0
2005-01-20 13:30:00	SPY	ETF	117.54	117.67	117.42	117.5	4203800.0
2005-01-20 14:00:00	SPY	ETF	117.54	118.09	117.54	117.78	7942500.0
2005-01-20 14:30:00	SPY	ETF	117.78	118.0	117.68	117.88	4293000.0
2005-01-20 15:00:00	SPY	ETF	117.88	117.95	117.57	117.6	4615900.0
2005-01-20 15:30:00	SPY	ETF	117.6	117.85	117.42	117.56	7046300.0
2005-01-20 16:00:00	SPY	ETF	117.53	117.65	117.45	117.6	1487000.0
2005-01-20 16:30:00	SPY	ETF	117.5	117.64	117.5	117.55	412700.0
2005-01-20 17:00:00	SPY	ETF	117.55	117.6	117.54	117.6	27800.0
2005-01-20 17:30:00	SPY	ETF	117.6	117.65	117.6	117.61	10700.0
2005-01-20 18:00:00	SPY	ETF	117.63	117.68	117.63	117.65	8600.0
2005-01-20 18:30:00	SPY	ETF	117.63	117.63	117.61	117.61	5400.0
2005-01-20 19:00:00	SPY	ETF	117.62	117.62	117.59	117.59	300.0
2005-01-20 19:30:00	SPY	ETF	117.62	117.62	117.59	117.59	200.0
2005-01-20 09:30:00	QQQ	ETF	37.65	37.73	37.53	37.57	18216400.0
2005-01-20 10:00:00	QQQ	ETF	37.57	37.81	37.56	37.7	17325500.0
2005-01-20 10:30:00	QQQ	ETF	37.7	37.72	37.64	37.69	6314600.0
2005-01-20 11:00:00	QQQ	ETF	37.69	37.76	37.66	37.69	5611800.0
2005-01-20 11:30:00	QQQ	ETF	37.69	37.81	37.66	37.75	6210500.0
2005-01-20 12:00:00	QQQ	ETF	37.75	37.75	37.66	37.69	5969600.0
2005-01-20 12:30:00	QQQ	ETF	37.68	37.71	37.56	37.57	4400600.0
2005-01-20 13:00:00	QQQ	ETF	37.57	37.62	37.4	37.49	10229800.0
2005-01-20 13:30:00	QQQ	ETF	37.48	37.67	37.44	37.48	5631700.0
2005-01-20 14:00:00	QQQ	ETF	37.48	37.67	37.48	37.54	9160100.0
2005-01-20 14:30:00	QQQ	ETF	37.54	37.63	37.47	37.57	4516600.0
2005-01-20 15:00:00	QQQ	ETF	37.56	37.57	37.41	37.42	7154200.0
2005-01-20 15:30:00	QQQ	ETF	37.43	37.5	37.32	37.36	12438700.0
2005-01-20 08:00:00	IWM	ETF	61.015	61.025	60.975	60.975	4400.0
2005-01-20 08:30:00	IWM	ETF	60.975	61.025	60.975	61.02	4200.0
2005-01-20 09:00:00	IWM	ETF	61.005	61.08	61.005	61.045	20600.0
2005-01-20 09:30:00	IWM	ETF	61.07	61.23	60.865	60.92	4603600.0
2005-01-20 10:00:00	IWM	ETF	60.9	61.17	60.815	60.955	3477400.0
2005-01-20 10:30:00	IWM	ETF	60.95	61.175	60.88	61.065	1479200.0
2005-01-20 11:00:00	IWM	ETF	61.05	61.475	61.05	61.195	2289000.0
2005-01-20 11:30:00	IWM	ETF	61.195	61.485	61.19	61.385	1244200.0
2005-01-20 12:00:00	IWM	ETF	61.365	61.385	61.275	61.325	827800.0
2005-01-20 12:30:00	IWM	ETF	61.325	61.39	61.165	61.185	634400.0
2005-01-20 13:00:00	IWM	ETF	61.19	61.325	60.865	60.975	3324000.0
2005-01-20 13:30:00	IWM	ETF	60.965	61.1	60.925	61.06	1314000.0
2005-01-20 14:00:00	IWM	ETF	61.06	61.405	61.06	61.24	2348000.0

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

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