PREVIEW / etf_30min / 2005-06-15

all etf 30-min files

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

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-15 08:00:00	SPY	ETF	120.88	120.88	120.75	120.75	89600.0
2005-06-15 08:30:00	SPY	ETF	120.78	121.27	120.78	121.26	624700.0
2005-06-15 09:00:00	SPY	ETF	121.24	121.27	121.16	121.16	158700.0
2005-06-15 09:30:00	SPY	ETF	121.16	121.24	120.94	121.0	5018000.0
2005-06-15 10:00:00	SPY	ETF	120.96	121.12	120.7	120.76	5088300.0
2005-06-15 10:30:00	SPY	ETF	120.76	120.78	120.29	120.35	7694200.0
2005-06-15 11:00:00	SPY	ETF	120.35	120.57	120.25	120.47	4720700.0
2005-06-15 11:30:00	SPY	ETF	120.48	120.62	120.23	120.29	3474500.0
2005-06-15 12:00:00	SPY	ETF	120.29	120.42	120.27	120.34	1936100.0
2005-06-15 12:30:00	SPY	ETF	120.35	120.54	120.35	120.45	2999100.0
2005-06-15 13:00:00	SPY	ETF	120.45	120.59	120.36	120.37	1920000.0
2005-06-15 13:30:00	SPY	ETF	120.38	120.61	120.25	120.56	2814600.0
2005-06-15 14:00:00	SPY	ETF	120.57	120.86	120.47	120.67	3138200.0
2005-06-15 14:30:00	SPY	ETF	120.67	120.89	120.6	120.73	2209200.0
2005-06-15 15:00:00	SPY	ETF	120.74	120.88	120.59	120.85	3581300.0
2005-06-15 15:30:00	SPY	ETF	120.86	121.12	120.85	121.06	4457000.0
2005-06-15 16:00:00	SPY	ETF	121.05	121.1	121.02	121.03	1920500.0
2005-06-15 16:30:00	SPY	ETF	121.03	121.06	121.0	121.05	92100.0
2005-06-15 17:00:00	SPY	ETF	121.06	121.06	121.02	121.02	9500.0
2005-06-15 17:30:00	SPY	ETF	121.02	121.09	121.02	121.07	622000.0
2005-06-15 18:00:00	SPY	ETF	121.05	121.06	121.02	121.05	49100.0
2005-06-15 18:30:00	SPY	ETF	121.04	121.04	121.04	121.04	900.0
2005-06-15 19:00:00	SPY	ETF	121.03	121.03	121.03	121.03	100.0
2005-06-15 19:30:00	SPY	ETF	121.05	121.05	121.05	121.05	900.0
2005-06-15 09:30:00	QQQ	ETF	37.83	37.87	37.73	37.76	10977200.0
2005-06-15 10:00:00	QQQ	ETF	37.75	37.77	37.55	37.59	11553100.0
2005-06-15 10:30:00	QQQ	ETF	37.59	37.59	37.33	37.37	13610300.0
2005-06-15 11:00:00	QQQ	ETF	37.37	37.43	37.33	37.42	5789400.0
2005-06-15 11:30:00	QQQ	ETF	37.42	37.42	37.26	37.26	4955300.0
2005-06-15 12:00:00	QQQ	ETF	37.27	37.31	37.25	37.26	5209400.0
2005-06-15 12:30:00	QQQ	ETF	37.25	37.34	37.25	37.33	3296100.0
2005-06-15 13:00:00	QQQ	ETF	37.32	37.39	37.31	37.31	1976700.0
2005-06-15 13:30:00	QQQ	ETF	37.32	37.41	37.28	37.37	4181800.0
2005-06-15 14:00:00	QQQ	ETF	37.38	37.5	37.35	37.46	6190700.0
2005-06-15 14:30:00	QQQ	ETF	37.45	37.55	37.43	37.49	5384500.0
2005-06-15 15:00:00	QQQ	ETF	37.49	37.57	37.44	37.56	5549000.0
2005-06-15 15:30:00	QQQ	ETF	37.56	37.73	37.56	37.7	13302500.0
2005-06-15 07:30:00	IWM	ETF	63.28	63.31	63.28	63.3	87000.0
2005-06-15 08:00:00	IWM	ETF	63.22	63.22	63.22	63.22	6400.0
2005-06-15 08:30:00	IWM	ETF	63.46	63.46	63.44	63.44	1200.0
2005-06-15 09:00:00	IWM	ETF	63.5	63.52	63.45	63.45	6200.0
2005-06-15 09:30:00	IWM	ETF	63.43	63.43	63.1	63.13	2663400.0
2005-06-15 10:00:00	IWM	ETF	63.13	63.15	62.95	63.02	1433100.0
2005-06-15 10:30:00	IWM	ETF	63.02	63.02	62.64	62.68	3107200.0
2005-06-15 11:00:00	IWM	ETF	62.68	62.96	62.64	62.91	1970700.0
2005-06-15 11:30:00	IWM	ETF	62.91	62.94	62.8	62.81	1309800.0
2005-06-15 12:00:00	IWM	ETF	62.81	62.9	62.8	62.87	586700.0
2005-06-15 12:30:00	IWM	ETF	62.86	63.02	62.86	62.96	397400.0
2005-06-15 13:00:00	IWM	ETF	62.97	63.02	62.86	62.87	956500.0
2005-06-15 13:30:00	IWM	ETF	62.88	63.06	62.85	63.0	838600.0

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

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