PREVIEW / etf_1hour / 2007-05-18

all etf 1-hour files

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

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-18 06:00:00	SPY	ETF	151.63	151.67	151.56	151.56	37600.0
2007-05-18 07:00:00	SPY	ETF	151.52	151.78	151.52	151.78	238200.0
2007-05-18 08:00:00	SPY	ETF	151.76	151.95	151.75	151.87	1764800.0
2007-05-18 09:00:00	SPY	ETF	151.9	152.07	151.81	151.95	14164699.0
2007-05-18 10:00:00	SPY	ETF	151.95	152.33	151.85	152.09	22946817.0
2007-05-18 11:00:00	SPY	ETF	152.09	152.18	151.92	152.03	10016650.0
2007-05-18 12:00:00	SPY	ETF	152.02	152.44	151.98	152.35	10340450.0
2007-05-18 13:00:00	SPY	ETF	152.35	152.41	152.21	152.31	5665964.0
2007-05-18 14:00:00	SPY	ETF	152.31	152.5	152.1	152.2	13686575.0
2007-05-18 15:00:00	SPY	ETF	152.21	152.5	152.12	152.5	14766886.0
2007-05-18 16:00:00	SPY	ETF	152.5	152.65	152.46	152.56	2761200.0
2007-05-18 17:00:00	SPY	ETF	152.54	152.6	152.51	152.51	601900.0
2007-05-18 18:00:00	SPY	ETF	152.53	152.54	152.53	152.54	900.0
2007-05-18 19:00:00	SPY	ETF	152.59	152.59	152.54	152.58	5000.0
2007-05-18 06:00:00	QQQ	ETF	46.46	46.46	46.46	46.46	200.0
2007-05-18 07:00:00	QQQ	ETF	46.46	46.49	46.43	46.48	492801.0
2007-05-18 08:00:00	QQQ	ETF	46.46	46.55	46.45	46.51	2214758.0
2007-05-18 09:00:00	QQQ	ETF	46.51	46.57	46.38	46.44	19060567.0
2007-05-18 10:00:00	QQQ	ETF	46.45	46.65	46.44	46.5	22857134.0
2007-05-18 11:00:00	QQQ	ETF	46.5	46.52	46.44	46.48	8673987.0
2007-05-18 12:00:00	QQQ	ETF	46.47	46.7	46.45	46.64	14548670.0
2007-05-18 13:00:00	QQQ	ETF	46.64	46.7	46.6	46.65	5727785.0
2007-05-18 14:00:00	QQQ	ETF	46.65	46.7	46.5	46.55	14265713.0
2007-05-18 15:00:00	QQQ	ETF	46.543	46.68	46.51	46.68	12163328.0
2007-05-18 16:00:00	QQQ	ETF	46.68	46.76	46.67	46.75	3814334.0
2007-05-18 17:00:00	QQQ	ETF	46.76	46.76	46.72	46.73	16201.0
2007-05-18 18:00:00	QQQ	ETF	46.73	46.74	46.72	46.72	5955.0
2007-05-18 19:00:00	QQQ	ETF	46.71	46.71	46.7	46.71	25362.0
2007-05-18 07:00:00	IWM	ETF	81.0	81.06	80.91	81.02	67000.0
2007-05-18 08:00:00	IWM	ETF	81.06	81.24	81.02	81.16	532800.0
2007-05-18 09:00:00	IWM	ETF	81.17	81.29	80.86	80.96	11547664.0
2007-05-18 10:00:00	IWM	ETF	80.96	81.27	80.88	81.1	15536650.0
2007-05-18 11:00:00	IWM	ETF	81.11	81.17	81.02	81.12	5663200.0
2007-05-18 12:00:00	IWM	ETF	81.11	81.66	81.06	81.6	8748732.0
2007-05-18 13:00:00	IWM	ETF	81.61	81.76	81.45	81.69	5602800.0
2007-05-18 14:00:00	IWM	ETF	81.69	82.05	80.78	81.75	14557600.0
2007-05-18 15:00:00	IWM	ETF	81.75	82.0	81.59	81.75	12898859.0
2007-05-18 16:00:00	IWM	ETF	81.75	81.8	81.71	81.8	2474800.0
2007-05-18 19:00:00	IWM	ETF	81.72	81.72	81.72	81.72	600.0
2007-05-18 07:00:00	DIA	ETF	134.85	134.88	134.76	134.88	25800.0
2007-05-18 08:00:00	DIA	ETF	134.9	135.05	134.9	134.99	106600.0
2007-05-18 09:00:00	DIA	ETF	135.0	135.27	135.0	135.07	1809065.0
2007-05-18 10:00:00	DIA	ETF	135.08	135.39	135.0	135.16	2303100.0
2007-05-18 11:00:00	DIA	ETF	135.15	135.29	135.03	135.1	940700.0
2007-05-18 12:00:00	DIA	ETF	135.11	135.35	135.08	135.27	718400.0
2007-05-18 13:00:00	DIA	ETF	135.27	135.35	135.15	135.27	584400.0
2007-05-18 14:00:00	DIA	ETF	135.28	135.38	135.11	135.21	964300.0
2007-05-18 15:00:00	DIA	ETF	135.21	135.43	135.09	135.43	1888050.0
2007-05-18 16:00:00	DIA	ETF	135.42	135.53	135.41	135.5	102700.0
2007-05-18 17:00:00	DIA	ETF	135.45	135.45	135.45	135.45	200.0

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

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