PREVIEW / etf_1hour / 2007-05-31

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-05-31.parquet
  size:    78 KB
  rows:    2,638

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
2007-05-31 06:00:00	SPY	ETF	153.49	153.6	153.49	153.6	34500.0
2007-05-31 07:00:00	SPY	ETF	153.58	153.76	153.57	153.72	241300.0
2007-05-31 08:00:00	SPY	ETF	153.56	153.88	153.56	153.75	3635700.0
2007-05-31 09:00:00	SPY	ETF	153.73	153.87	153.58	153.73	12285386.0
2007-05-31 10:00:00	SPY	ETF	153.73	153.89	153.38	153.69	22043589.0
2007-05-31 11:00:00	SPY	ETF	153.68	153.69	153.28	153.46	12614374.0
2007-05-31 12:00:00	SPY	ETF	153.46	153.71	153.3421	153.62	9134100.0
2007-05-31 13:00:00	SPY	ETF	153.61	153.67	153.12	153.38	14458213.0
2007-05-31 14:00:00	SPY	ETF	153.38	153.7	153.37	153.48	7464249.0
2007-05-31 15:00:00	SPY	ETF	153.49	153.54	153.31	153.35	15776606.0
2007-05-31 16:00:00	SPY	ETF	153.36	153.6	153.3	153.32	8541900.0
2007-05-31 17:00:00	SPY	ETF	153.44	153.5	153.3419	153.46	3676600.0
2007-05-31 18:00:00	SPY	ETF	153.46	153.46	153.38	153.38	908100.0
2007-05-31 19:00:00	SPY	ETF	153.44	153.47	153.44	153.47	2400.0
2007-05-31 07:00:00	QQQ	ETF	47.26	47.35	47.26	47.34	47569.0
2007-05-31 08:00:00	QQQ	ETF	47.32	47.39	47.29	47.33	1480593.0
2007-05-31 09:00:00	QQQ	ETF	47.33	47.47	47.29	47.4	20998246.0
2007-05-31 10:00:00	QQQ	ETF	47.403	47.5	47.29	47.47	19334398.0
2007-05-31 11:00:00	QQQ	ETF	47.47	47.48	47.29	47.4	12626466.0
2007-05-31 12:00:00	QQQ	ETF	47.41	47.52	47.37	47.49	5314824.0
2007-05-31 13:00:00	QQQ	ETF	47.49	47.5	47.21	47.34	16471767.0
2007-05-31 14:00:00	QQQ	ETF	47.33	47.48	47.32	47.42	10688858.0
2007-05-31 15:00:00	QQQ	ETF	47.42	47.49	47.3	47.44	16110206.0
2007-05-31 16:00:00	QQQ	ETF	47.44	47.53	47.41	47.49	4036455.0
2007-05-31 17:00:00	QQQ	ETF	47.48	47.51	47.44	47.47	637364.0
2007-05-31 18:00:00	QQQ	ETF	47.47	47.48	47.46	47.48	1240690.0
2007-05-31 19:00:00	QQQ	ETF	47.47	47.47	47.45	47.47	29972.0
2007-05-31 07:00:00	IWM	ETF	83.98	83.98	83.98	83.98	200.0
2007-05-31 08:00:00	IWM	ETF	84.06	84.12	84.0	84.05	393200.0
2007-05-31 09:00:00	IWM	ETF	84.03	84.39	83.94	84.35	8152746.0
2007-05-31 10:00:00	IWM	ETF	84.35	84.45	84.08	84.27	14431300.0
2007-05-31 11:00:00	IWM	ETF	84.27	84.28	83.9	84.15	8152890.0
2007-05-31 12:00:00	IWM	ETF	84.14	84.34	84.07	84.2	4620300.0
2007-05-31 13:00:00	IWM	ETF	84.21	84.26	83.78	83.98	7274500.0
2007-05-31 14:00:00	IWM	ETF	83.98	84.2	83.98	84.03	8305600.0
2007-05-31 15:00:00	IWM	ETF	84.03	84.15	83.88	84.06	12168740.0
2007-05-31 16:00:00	IWM	ETF	84.06	84.27	84.01	84.2	1848700.0
2007-05-31 18:00:00	IWM	ETF	84.2	84.2	84.2	84.2	35400.0
2007-05-31 07:00:00	DIA	ETF	136.28	136.61	136.28	136.61	2200.0
2007-05-31 08:00:00	DIA	ETF	136.57	136.69	136.48	136.53	68300.0
2007-05-31 09:00:00	DIA	ETF	136.48	136.66	136.35	136.51	1540000.0
2007-05-31 10:00:00	DIA	ETF	136.52	136.65	136.27	136.5	1788900.0
2007-05-31 11:00:00	DIA	ETF	136.51	136.51	136.21	136.4	814100.0
2007-05-31 12:00:00	DIA	ETF	136.39	136.6	136.31	136.49	922173.0
2007-05-31 13:00:00	DIA	ETF	136.49	136.54	136.08	136.24	1376400.0
2007-05-31 14:00:00	DIA	ETF	136.24	136.49	136.21	136.32	787500.0
2007-05-31 15:00:00	DIA	ETF	136.32	136.37	136.17	136.18	1151400.0
2007-05-31 16:00:00	DIA	ETF	136.18	136.33	136.11	136.29	455400.0
2007-05-31 18:00:00	DIA	ETF	136.29	136.29	136.29	136.29	29500.0
2007-05-31 19:00:00	DIA	ETF	136.37	136.37	136.37	136.37	100.0

> showing 50 of 2,638 rows — these rows as CSV

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