PREVIEW / etf_30min / 2005-09-09

all etf 30-min files

  file:    by_date/etf_30min/2005/2005-09-09.parquet
  size:    46 KB
  rows:    1,647

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-09-09 07:00:00	SPY	ETF	123.61	123.7	123.61	123.7	20100.0
2005-09-09 07:30:00	SPY	ETF	123.75	123.79	123.75	123.76	1500.0
2005-09-09 08:00:00	SPY	ETF	123.76	123.86	123.74	123.76	115600.0
2005-09-09 08:30:00	SPY	ETF	123.77	123.81	123.68	123.81	270800.0
2005-09-09 09:00:00	SPY	ETF	123.81	123.89	123.57	123.84	409100.0
2005-09-09 09:30:00	SPY	ETF	123.83	124.01	123.8	123.86	5081000.0
2005-09-09 10:00:00	SPY	ETF	123.86	124.13	123.84	124.02	2825500.0
2005-09-09 10:30:00	SPY	ETF	124.02	124.05	123.91	123.97	1872200.0
2005-09-09 11:00:00	SPY	ETF	123.96	124.24	123.87	124.15	3256300.0
2005-09-09 11:30:00	SPY	ETF	124.15	124.46	124.14	124.43	4160800.0
2005-09-09 12:00:00	SPY	ETF	124.44	124.57	124.39	124.53	3397100.0
2005-09-09 12:30:00	SPY	ETF	124.532	124.54	124.45	124.45	915200.0
2005-09-09 13:00:00	SPY	ETF	124.45	124.68	124.4	124.6	4496800.0
2005-09-09 13:30:00	SPY	ETF	124.6088	124.74	124.57	124.63	2887300.0
2005-09-09 14:00:00	SPY	ETF	124.63	124.64	124.5	124.6	2053300.0
2005-09-09 14:30:00	SPY	ETF	124.6	124.68	124.52	124.6	788600.0
2005-09-09 15:00:00	SPY	ETF	124.6	124.66	124.48	124.63	2358800.0
2005-09-09 15:30:00	SPY	ETF	124.63	124.66	124.44	124.48	5056900.0
2005-09-09 16:00:00	SPY	ETF	124.48	124.65	124.45	124.64	189800.0
2005-09-09 16:30:00	SPY	ETF	124.63	124.66	124.53	124.61	513100.0
2005-09-09 17:00:00	SPY	ETF	124.65	124.69	124.61	124.69	7500.0
2005-09-09 17:30:00	SPY	ETF	124.68	124.69	124.62	124.62	600.0
2005-09-09 18:00:00	SPY	ETF	124.61	124.62	124.6	124.6	1800.0
2005-09-09 18:30:00	SPY	ETF	124.6	124.6	124.6	124.6	1000.0
2005-09-09 19:30:00	SPY	ETF	124.67	124.67	124.67	124.67	100.0
2005-09-09 09:30:00	QQQ	ETF	39.41	39.46	39.31	39.36	7840000.0
2005-09-09 10:00:00	QQQ	ETF	39.36	39.47	39.34	39.44	4311600.0
2005-09-09 10:30:00	QQQ	ETF	39.43	39.45	39.38	39.39	3761700.0
2005-09-09 11:00:00	QQQ	ETF	39.39	39.5	39.37	39.47	5514500.0
2005-09-09 11:30:00	QQQ	ETF	39.47	39.62	39.47	39.59	5397400.0
2005-09-09 12:00:00	QQQ	ETF	39.59	39.67	39.58	39.65	6026800.0
2005-09-09 12:30:00	QQQ	ETF	39.65	39.65	39.6	39.6	2109800.0
2005-09-09 13:00:00	QQQ	ETF	39.6	39.66	39.57	39.65	2365000.0
2005-09-09 13:30:00	QQQ	ETF	39.64	39.69	39.62	39.66	3204500.0
2005-09-09 14:00:00	QQQ	ETF	39.66	39.67	39.58	39.63	2682900.0
2005-09-09 14:30:00	QQQ	ETF	39.62	39.64	39.55	39.62	3832300.0
2005-09-09 15:00:00	QQQ	ETF	39.62	39.65	39.59	39.65	3154500.0
2005-09-09 15:30:00	QQQ	ETF	39.65	39.68	39.6	39.63	13027200.0
2005-09-09 08:00:00	IWM	ETF	67.02	67.02	67.02	67.02	1500000.0
2005-09-09 09:00:00	IWM	ETF	67.18	67.23	67.18	67.2	6100.0
2005-09-09 09:30:00	IWM	ETF	67.215	67.35	67.09	67.12	878700.0
2005-09-09 10:00:00	IWM	ETF	67.12	67.31	67.05	67.24	2245600.0
2005-09-09 10:30:00	IWM	ETF	67.23	67.26	67.17	67.21	615200.0
2005-09-09 11:00:00	IWM	ETF	67.21	67.32	67.14	67.26	3253500.0
2005-09-09 11:30:00	IWM	ETF	67.28	67.48	67.28	67.48	2674300.0
2005-09-09 12:00:00	IWM	ETF	67.47	67.5	67.42	67.46	799500.0
2005-09-09 12:30:00	IWM	ETF	67.46	67.47	67.38	67.39	637900.0
2005-09-09 13:00:00	IWM	ETF	67.38	67.41	67.31	67.39	1794100.0
2005-09-09 13:30:00	IWM	ETF	67.39	67.45	67.35	67.43	1030800.0
2005-09-09 14:00:00	IWM	ETF	67.43	67.46	67.36	67.43	607900.0

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

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