PREVIEW / etf_1hour / 2007-08-21

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-08-21.parquet
  size:    82 KB
  rows:    2,741

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-08-21 04:00:00	SPY	ETF	144.01	144.01	144.01	144.01	900.0
2007-08-21 05:00:00	SPY	ETF	144.78	144.78	144.33	144.39	19000.0
2007-08-21 06:00:00	SPY	ETF	144.43	145.01	144.33	145.01	64300.0
2007-08-21 07:00:00	SPY	ETF	145.02	145.48	144.76	145.45	1940400.0
2007-08-21 08:00:00	SPY	ETF	145.41	145.65	144.375	144.71	5295200.0
2007-08-21 09:00:00	SPY	ETF	144.7	145.21	144.14	144.98	22854436.0
2007-08-21 10:00:00	SPY	ETF	144.98	145.04	144.2	144.86	23236500.0
2007-08-21 11:00:00	SPY	ETF	144.86	145.7	144.48	145.56	28533200.0
2007-08-21 12:00:00	SPY	ETF	145.55	145.97	144.86	145.22	23585100.0
2007-08-21 13:00:00	SPY	ETF	145.22	145.48	144.94	145.08	9940300.0
2007-08-21 14:00:00	SPY	ETF	145.08	145.33	144.52	144.91	18021906.0
2007-08-21 15:00:00	SPY	ETF	144.91	145.32	144.69	144.94	16847000.0
2007-08-21 16:00:00	SPY	ETF	144.95	145.09	144.8	144.8	2508700.0
2007-08-21 17:00:00	SPY	ETF	144.81	144.85	144.7	144.78	318700.0
2007-08-21 18:00:00	SPY	ETF	144.77	144.95	144.75	144.8	44500.0
2007-08-21 19:00:00	SPY	ETF	144.8	144.9	144.75	144.9	60700.0
2007-08-21 04:00:00	QQQ	ETF	46.38	46.38	46.38	46.38	200.0
2007-08-21 05:00:00	QQQ	ETF	46.37	46.37	46.33	46.33	300.0
2007-08-21 06:00:00	QQQ	ETF	46.36	46.5	46.36	46.5	12500.0
2007-08-21 07:00:00	QQQ	ETF	46.55	46.68	46.45	46.67	1218599.0
2007-08-21 08:00:00	QQQ	ETF	46.65	46.75	46.44	46.47	2519527.0
2007-08-21 09:00:00	QQQ	ETF	46.47	46.72	46.37	46.65	16558504.0
2007-08-21 10:00:00	QQQ	ETF	46.642	46.71	46.45	46.68	15495618.0
2007-08-21 11:00:00	QQQ	ETF	46.68	46.9695	46.6	46.9	19489181.0
2007-08-21 12:00:00	QQQ	ETF	46.91	47.1272	46.55	46.97	19190584.0
2007-08-21 13:00:00	QQQ	ETF	46.97	47.07	46.5642	46.9785	9194603.0
2007-08-21 14:00:00	QQQ	ETF	46.97	47.05	46.8	46.89	9803202.0
2007-08-21 15:00:00	QQQ	ETF	46.89	47.05	46.85	47.04	11954682.0
2007-08-21 16:00:00	QQQ	ETF	47.03	47.07	46.99	47.0	6408179.0
2007-08-21 17:00:00	QQQ	ETF	47.0	47.02	46.98	46.99	263709.0
2007-08-21 18:00:00	QQQ	ETF	46.99	47.0	46.98	46.98	30332.0
2007-08-21 19:00:00	QQQ	ETF	46.99	47.02	46.99	47.01	9723.0
2007-08-21 07:00:00	IWM	ETF	78.53	78.91	78.53	78.91	197400.0
2007-08-21 08:00:00	IWM	ETF	78.89	79.08	78.57	78.57	1463000.0
2007-08-21 09:00:00	IWM	ETF	78.59	79.06	78.08	78.9	9354799.0
2007-08-21 10:00:00	IWM	ETF	78.89	78.91	78.0	78.47	20312900.0
2007-08-21 11:00:00	IWM	ETF	78.46	79.03	78.15	78.95	14917000.0
2007-08-21 12:00:00	IWM	ETF	78.95	79.09	78.56	78.72	11033500.0
2007-08-21 13:00:00	IWM	ETF	78.73	78.98	78.62	78.74	7677500.0
2007-08-21 14:00:00	IWM	ETF	78.74	78.89	78.39	78.55	8217500.0
2007-08-21 15:00:00	IWM	ETF	78.55	78.85	78.43	78.5	8287100.0
2007-08-21 16:00:00	IWM	ETF	78.49	78.74	78.4467	78.7	2232600.0
2007-08-21 17:00:00	IWM	ETF	78.61	78.61	78.61	78.61	100.0
2007-08-21 18:00:00	IWM	ETF	78.64	78.64	78.64	78.64	4700.0
2007-08-21 19:00:00	IWM	ETF	78.62	78.66	78.55	78.66	42100.0
2007-08-21 07:00:00	DIA	ETF	131.29	131.42	131.27	131.32	33000.0
2007-08-21 08:00:00	DIA	ETF	131.41	131.6	130.93	131.0	130100.0
2007-08-21 09:00:00	DIA	ETF	130.98	131.31	130.54	131.08	1710000.0
2007-08-21 10:00:00	DIA	ETF	131.08	131.14	130.42	130.93	2403800.0
2007-08-21 11:00:00	DIA	ETF	130.93	131.55	130.71	131.43	2653400.0

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

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