PREVIEW / etf_1hour / 2007-05-25

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-05-25.parquet
  size:    74 KB
  rows:    2,552

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-25 04:00:00	SPY	ETF	151.54	151.54	151.3	151.3	6100.0
2007-05-25 06:00:00	SPY	ETF	151.55	151.55	151.44	151.45	30000.0
2007-05-25 07:00:00	SPY	ETF	151.43	151.61	151.41	151.6	156900.0
2007-05-25 08:00:00	SPY	ETF	151.55	151.66	151.2	151.55	1958700.0
2007-05-25 09:00:00	SPY	ETF	151.54	151.64	151.35	151.49	11924454.0
2007-05-25 10:00:00	SPY	ETF	151.48	152.02	151.29	151.84	24143093.0
2007-05-25 11:00:00	SPY	ETF	151.84	151.87	151.65	151.74	7260007.0
2007-05-25 12:00:00	SPY	ETF	151.74	151.74	151.18	151.38	9719435.0
2007-05-25 13:00:00	SPY	ETF	151.38	151.76	151.37	151.55	5679514.0
2007-05-25 14:00:00	SPY	ETF	151.55	151.82	151.44	151.74	8592806.0
2007-05-25 15:00:00	SPY	ETF	151.74	151.89	151.63	151.86	11826412.0
2007-05-25 16:00:00	SPY	ETF	151.84	151.85	151.63	151.79	1397900.0
2007-05-25 17:00:00	SPY	ETF	151.8	151.8	151.77	151.8	4200.0
2007-05-25 18:00:00	SPY	ETF	151.81	151.82	151.8	151.8	700.0
2007-05-25 19:00:00	SPY	ETF	151.8	151.82	151.8	151.82	500.0
2007-05-25 05:00:00	QQQ	ETF	46.28	46.28	46.28	46.28	200.0
2007-05-25 06:00:00	QQQ	ETF	46.27	46.27	46.27	46.27	200.0
2007-05-25 07:00:00	QQQ	ETF	46.27	46.34	46.27	46.32	454726.0
2007-05-25 08:00:00	QQQ	ETF	46.31	46.35	46.29	46.29	835275.0
2007-05-25 09:00:00	QQQ	ETF	46.29	46.33	46.2	46.285	12811155.0
2007-05-25 10:00:00	QQQ	ETF	46.28	46.5	46.18	46.41	21830402.0
2007-05-25 11:00:00	QQQ	ETF	46.4005	46.43	46.33	46.43	5783519.0
2007-05-25 12:00:00	QQQ	ETF	46.43	46.43	46.27	46.32	7134141.0
2007-05-25 13:00:00	QQQ	ETF	46.31	46.47	46.31	46.4101	5012978.0
2007-05-25 14:00:00	QQQ	ETF	46.42	46.55	46.39	46.52	8677616.0
2007-05-25 15:00:00	QQQ	ETF	46.51	46.56	46.45	46.46	21067611.0
2007-05-25 16:00:00	QQQ	ETF	46.46	46.5	46.42	46.48	996406.0
2007-05-25 17:00:00	QQQ	ETF	46.48	46.49	46.47	46.48	10855.0
2007-05-25 18:00:00	QQQ	ETF	46.46	46.49	46.46	46.49	645.0
2007-05-25 19:00:00	QQQ	ETF	46.48	46.5	46.46	46.5	10900.0
2007-05-25 07:00:00	IWM	ETF	82.25	82.27	82.25	82.27	11500.0
2007-05-25 08:00:00	IWM	ETF	82.27	82.3	82.22	82.3	176300.0
2007-05-25 09:00:00	IWM	ETF	82.24	82.48	82.13	82.32	7162799.0
2007-05-25 10:00:00	IWM	ETF	82.32	82.71	82.1	82.55	12130108.0
2007-05-25 11:00:00	IWM	ETF	82.55	84.43	82.28	82.4	4503600.0
2007-05-25 12:00:00	IWM	ETF	82.4	82.41	82.12	82.18	3807400.0
2007-05-25 13:00:00	IWM	ETF	82.19	82.41	82.15	82.2	2715300.0
2007-05-25 14:00:00	IWM	ETF	82.19	82.45	82.04	82.4	4790557.0
2007-05-25 15:00:00	IWM	ETF	82.4	82.55	82.35	82.53	5538394.0
2007-05-25 16:00:00	IWM	ETF	82.54	82.59	82.45	82.5	502800.0
2007-05-25 17:00:00	IWM	ETF	82.5	82.5	82.5	82.5	560000.0
2007-05-25 07:00:00	DIA	ETF	134.7	134.79	134.7	134.78	7900.0
2007-05-25 08:00:00	DIA	ETF	134.81	134.86	134.78	134.78	22700.0
2007-05-25 09:00:00	DIA	ETF	134.76	134.84	131.83	134.66	1982900.0
2007-05-25 10:00:00	DIA	ETF	134.65	135.05	134.51	134.95	3193050.0
2007-05-25 11:00:00	DIA	ETF	134.96	134.98	134.79	134.88	904600.0
2007-05-25 12:00:00	DIA	ETF	134.87	134.87	134.39	134.58	1299300.0
2007-05-25 13:00:00	DIA	ETF	134.58	134.88	134.58	134.7	564099.0
2007-05-25 14:00:00	DIA	ETF	134.71	134.91	134.62	134.84	929000.0
2007-05-25 15:00:00	DIA	ETF	134.84	135.01	134.73	135.0	1251295.0

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

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