PREVIEW / etf_1hour / 2007-06-06

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-06-06.parquet
  size:    79 KB
  rows:    2,663

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-06 06:00:00	SPY	ETF	152.82	153.0	152.78	152.9	18100.0
2007-06-06 07:00:00	SPY	ETF	152.87	153.0	152.76	152.86	351100.0
2007-06-06 08:00:00	SPY	ETF	152.88	153.49	152.64	152.86	2796700.0
2007-06-06 09:00:00	SPY	ETF	152.86	152.95	152.43	152.58	19421255.0
2007-06-06 10:00:00	SPY	ETF	152.58	152.9	152.09	152.16	29707593.0
2007-06-06 11:00:00	SPY	ETF	152.16	152.45	152.0	152.13	18263262.0
2007-06-06 12:00:00	SPY	ETF	152.12	152.44	152.0	152.04	13181160.0
2007-06-06 13:00:00	SPY	ETF	152.05	152.11	151.76	152.01	20405292.0
2007-06-06 14:00:00	SPY	ETF	152.01	152.79	151.82	152.12	15539169.0
2007-06-06 15:00:00	SPY	ETF	152.12	152.4	151.96	152.1	24998084.0
2007-06-06 16:00:00	SPY	ETF	152.09	152.13	151.75	151.86	8438100.0
2007-06-06 17:00:00	SPY	ETF	151.89	151.89	151.84	151.88	20400.0
2007-06-06 18:00:00	SPY	ETF	151.88	151.89	151.84	151.88	25500.0
2007-06-06 19:00:00	SPY	ETF	151.89	152.09	151.89	152.09	18200.0
2007-06-06 05:00:00	QQQ	ETF	47.38	47.38	47.35	47.35	12000.0
2007-06-06 06:00:00	QQQ	ETF	47.33	47.33	47.3	47.31	97900.0
2007-06-06 07:00:00	QQQ	ETF	47.31	47.37	47.27	47.31	907025.0
2007-06-06 08:00:00	QQQ	ETF	47.33	47.37	47.25	47.32	2335563.0
2007-06-06 09:00:00	QQQ	ETF	47.32	47.38	47.16	47.3	32861022.0
2007-06-06 10:00:00	QQQ	ETF	47.3	47.31	47.08	47.1	34316698.0
2007-06-06 11:00:00	QQQ	ETF	47.1	47.23	47.07	47.11	16093750.0
2007-06-06 12:00:00	QQQ	ETF	47.11	47.24	47.07	47.09	18531827.0
2007-06-06 13:00:00	QQQ	ETF	47.09	47.11	46.9614	47.11	19179276.0
2007-06-06 14:00:00	QQQ	ETF	47.11	47.19	47.04	47.15	13971381.0
2007-06-06 15:00:00	QQQ	ETF	47.15	47.26	47.08	47.11	28313241.0
2007-06-06 16:00:00	QQQ	ETF	47.11	47.12	47.01	47.05	4076125.0
2007-06-06 17:00:00	QQQ	ETF	47.06	47.08	47.06	47.07	11650.0
2007-06-06 18:00:00	QQQ	ETF	47.08	47.09	47.07	47.09	29805.0
2007-06-06 19:00:00	QQQ	ETF	47.1	47.12	47.09	47.11	10306.0
2007-06-06 07:00:00	IWM	ETF	84.0	84.0	83.95	83.95	29400.0
2007-06-06 08:00:00	IWM	ETF	83.99	84.0	83.79	83.87	1297800.0
2007-06-06 09:00:00	IWM	ETF	83.87	83.96	83.0	83.64	17043815.0
2007-06-06 10:00:00	IWM	ETF	83.63	83.69	83.31	83.42	16559778.0
2007-06-06 11:00:00	IWM	ETF	83.42	83.6	83.26	83.31	6133750.0
2007-06-06 12:00:00	IWM	ETF	83.31	83.54	83.29	83.37	7473508.0
2007-06-06 13:00:00	IWM	ETF	83.37	83.44	83.14	83.44	9199041.0
2007-06-06 14:00:00	IWM	ETF	83.44	83.61	82.53	83.46	7527686.0
2007-06-06 15:00:00	IWM	ETF	83.47	83.72	83.36	83.52	14260341.0
2007-06-06 16:00:00	IWM	ETF	83.52	83.65	83.36	83.45	2762800.0
2007-06-06 17:00:00	IWM	ETF	83.51	83.53	83.47	83.5	6142800.0
2007-06-06 18:00:00	IWM	ETF	83.46	83.46	83.46	83.46	200.0
2007-06-06 07:00:00	DIA	ETF	135.47	135.53	135.41	135.49	14700.0
2007-06-06 08:00:00	DIA	ETF	135.45	135.49	135.27	135.45	78000.0
2007-06-06 09:00:00	DIA	ETF	135.46	135.51	135.13	135.17	1370300.0
2007-06-06 10:00:00	DIA	ETF	135.16	135.27	134.72	134.77	2911600.0
2007-06-06 11:00:00	DIA	ETF	134.77	135.04	134.6	134.71	2548930.0
2007-06-06 12:00:00	DIA	ETF	134.7	134.99	134.64	134.67	1128900.0
2007-06-06 13:00:00	DIA	ETF	134.68	134.75	134.32	134.52	2656300.0
2007-06-06 14:00:00	DIA	ETF	134.52	134.69	134.34	134.57	1358101.0
2007-06-06 15:00:00	DIA	ETF	134.57	134.95	134.44	134.6	2410650.0

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

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