PREVIEW / etf_1hour / 2007-06-19

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-06-19.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-06-19 06:00:00	SPY	ETF	152.76	152.76	152.76	152.76	2000.0
2007-06-19 07:00:00	SPY	ETF	152.84	152.88	152.72	152.81	313100.0
2007-06-19 08:00:00	SPY	ETF	152.72	152.81	152.48	152.56	1994500.0
2007-06-19 09:00:00	SPY	ETF	152.55	152.72	152.36	152.51	13893326.0
2007-06-19 10:00:00	SPY	ETF	152.52	152.94	152.39	152.87	16706091.0
2007-06-19 11:00:00	SPY	ETF	152.86	152.88	152.53	152.78	9476060.0
2007-06-19 12:00:00	SPY	ETF	152.79	153.27	152.79	153.2	14441389.0
2007-06-19 13:00:00	SPY	ETF	153.2	153.38	152.93	152.95	11019682.0
2007-06-19 14:00:00	SPY	ETF	152.95	153.07	152.68	152.86	16274900.0
2007-06-19 15:00:00	SPY	ETF	152.86	153.27	152.77	153.2	19272207.0
2007-06-19 16:00:00	SPY	ETF	153.23	153.28	153.09	153.25	3023200.0
2007-06-19 17:00:00	SPY	ETF	153.24	153.24	153.09	153.14	619700.0
2007-06-19 18:00:00	SPY	ETF	153.14	153.18	153.06	153.06	30500.0
2007-06-19 19:00:00	SPY	ETF	153.05	153.08	153.05	153.07	2400.0
2007-06-19 04:00:00	QQQ	ETF	47.76	47.76	47.76	47.76	100.0
2007-06-19 06:00:00	QQQ	ETF	47.7	47.7	47.7	47.7	5000.0
2007-06-19 07:00:00	QQQ	ETF	47.7	47.71	47.64	47.68	168300.0
2007-06-19 08:00:00	QQQ	ETF	47.69	47.69	47.56	47.58	1792741.0
2007-06-19 09:00:00	QQQ	ETF	47.59	47.7	47.55	47.61	15650499.0
2007-06-19 10:00:00	QQQ	ETF	47.6	47.6994	47.51	47.67	17978121.0
2007-06-19 11:00:00	QQQ	ETF	47.6686	47.68	47.59	47.67	6786754.0
2007-06-19 12:00:00	QQQ	ETF	47.67	47.86	47.67	47.83	13981525.0
2007-06-19 13:00:00	QQQ	ETF	47.83	47.86	47.68	47.71	11707938.0
2007-06-19 14:00:00	QQQ	ETF	47.7005	47.72	47.63	47.68	9299361.0
2007-06-19 15:00:00	QQQ	ETF	47.671	47.82	47.65	47.77	21556474.0
2007-06-19 16:00:00	QQQ	ETF	47.77	47.797	47.74	47.76	3085061.0
2007-06-19 17:00:00	QQQ	ETF	47.76	47.77	47.74	47.75	40734.0
2007-06-19 18:00:00	QQQ	ETF	47.76	47.76	47.72	47.74	28835.0
2007-06-19 19:00:00	QQQ	ETF	47.72	47.72	47.69	47.7	27782.0
2007-06-19 07:00:00	IWM	ETF	83.95	83.99	83.86	83.91	44400.0
2007-06-19 08:00:00	IWM	ETF	83.9	83.9	83.73	83.75	703600.0
2007-06-19 09:00:00	IWM	ETF	83.76	83.91	83.55	83.64	6842500.0
2007-06-19 10:00:00	IWM	ETF	83.63	84.08	83.49	84.02	8026045.0
2007-06-19 11:00:00	IWM	ETF	84.02	84.05	83.75	83.91	5423396.0
2007-06-19 12:00:00	IWM	ETF	83.91	84.32	83.91	84.31	6240800.0
2007-06-19 13:00:00	IWM	ETF	84.31	84.41	84.15	84.27	9576761.0
2007-06-19 14:00:00	IWM	ETF	84.27	84.29	84.07	84.18	8716345.0
2007-06-19 15:00:00	IWM	ETF	84.18	84.51	84.17	84.39	13068700.0
2007-06-19 16:00:00	IWM	ETF	84.39	84.5	84.1526	84.1526	2231400.0
2007-06-19 17:00:00	IWM	ETF	84.39	84.41	84.39	84.41	37700.0
2007-06-19 18:00:00	IWM	ETF	84.35	84.35	84.35	84.35	500.0
2007-06-19 19:00:00	IWM	ETF	84.33	84.33	84.33	84.33	200.0
2007-06-19 07:00:00	DIA	ETF	135.95	135.95	135.89	135.94	6100.0
2007-06-19 08:00:00	DIA	ETF	135.89	135.92	135.67	135.72	32800.0
2007-06-19 09:00:00	DIA	ETF	135.73	135.95	135.62	135.75	1056700.0
2007-06-19 10:00:00	DIA	ETF	135.73	136.08	135.66	136.04	1578202.0
2007-06-19 11:00:00	DIA	ETF	136.04	136.06	135.77	136.0	1669700.0
2007-06-19 12:00:00	DIA	ETF	136.0	136.39	135.99	136.27	1902400.0
2007-06-19 13:00:00	DIA	ETF	136.27	136.4	136.0	136.01	1048400.0
2007-06-19 14:00:00	DIA	ETF	136.0	136.03	135.79	135.99	1036500.0

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

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