PREVIEW / etf_1hour / 2007-08-07

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-08-07.parquet
  size:    85 KB
  rows:    2,804

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-07 06:00:00	SPY	ETF	146.47	146.47	146.47	146.47	7500.0
2007-08-07 07:00:00	SPY	ETF	146.32	146.48	146.12	146.42	526000.0
2007-08-07 08:00:00	SPY	ETF	146.4	146.5	145.92	146.02	3322700.0
2007-08-07 09:00:00	SPY	ETF	146.02	146.4	145.23	146.4	24837180.0
2007-08-07 10:00:00	SPY	ETF	146.39	146.85	146.2	146.45	25607293.0
2007-08-07 11:00:00	SPY	ETF	146.46	147.21	146.34	147.13	19716475.0
2007-08-07 12:00:00	SPY	ETF	147.13	147.53	147.04	147.09	17017708.0
2007-08-07 13:00:00	SPY	ETF	147.08	147.73	147.06	147.54	16635883.0
2007-08-07 14:00:00	SPY	ETF	147.54	147.81	145.6	147.7	88992093.0
2007-08-07 15:00:00	SPY	ETF	147.7	149.0	147.36	147.68	68504367.0
2007-08-07 16:00:00	SPY	ETF	147.69	148.69	145.8318	148.12	8092100.0
2007-08-07 17:00:00	SPY	ETF	148.07	148.11	148.0	148.08	280900.0
2007-08-07 18:00:00	SPY	ETF	148.02	148.02	145.8318	147.92	384900.0
2007-08-07 19:00:00	SPY	ETF	147.93	147.93	147.81	147.81	15200.0
2007-08-07 04:00:00	QQQ	ETF	47.94	47.94	47.94	47.94	200.0
2007-08-07 07:00:00	QQQ	ETF	47.91	47.99	47.88	47.98	179161.0
2007-08-07 08:00:00	QQQ	ETF	47.99	48.06	47.82	47.85	4331217.0
2007-08-07 09:00:00	QQQ	ETF	47.86	48.0	47.72	47.96	11661676.0
2007-08-07 10:00:00	QQQ	ETF	47.96	48.07	47.8	47.89	14489145.0
2007-08-07 11:00:00	QQQ	ETF	47.89	48.02	47.82	47.93	9712290.0
2007-08-07 12:00:00	QQQ	ETF	47.93	48.06	47.89	47.9	9527706.0
2007-08-07 13:00:00	QQQ	ETF	47.9	48.08	47.89	48.0	9169538.0
2007-08-07 14:00:00	QQQ	ETF	48.01	48.12	47.48	48.08	53205307.0
2007-08-07 15:00:00	QQQ	ETF	48.07	48.62	48.0485	48.17	38365081.0
2007-08-07 16:00:00	QQQ	ETF	48.17	48.59	47.57	48.54	5148503.0
2007-08-07 17:00:00	QQQ	ETF	48.53	48.56	48.47	48.49	463638.0
2007-08-07 18:00:00	QQQ	ETF	48.5	48.52	47.98	48.48	254214.0
2007-08-07 19:00:00	QQQ	ETF	48.47	48.47	48.45	48.47	58915.0
2007-08-07 07:00:00	IWM	ETF	76.01	76.13	76.01	76.12	89000.0
2007-08-07 08:00:00	IWM	ETF	76.15	76.22	75.85	75.98	1522300.0
2007-08-07 09:00:00	IWM	ETF	75.98	76.28	75.58	76.26	15640899.0
2007-08-07 10:00:00	IWM	ETF	76.26	76.47	71.37	76.13	19762326.0
2007-08-07 11:00:00	IWM	ETF	76.13	76.49	76.01	76.45	12235793.0
2007-08-07 12:00:00	IWM	ETF	76.45	77.0	76.42	76.5	11522939.0
2007-08-07 13:00:00	IWM	ETF	76.5	76.93	76.49	76.86	13513288.0
2007-08-07 14:00:00	IWM	ETF	76.86	77.05	75.5	76.85	51719233.0
2007-08-07 15:00:00	IWM	ETF	76.86	77.67	76.7	77.15	27081626.0
2007-08-07 16:00:00	IWM	ETF	77.16	77.41	75.97	77.4	1523500.0
2007-08-07 17:00:00	IWM	ETF	77.4	77.45	77.31	77.33	1206400.0
2007-08-07 18:00:00	IWM	ETF	77.28	77.29	77.28	77.28	4300.0
2007-08-07 19:00:00	IWM	ETF	77.32	77.32	77.28	77.28	1800.0
2007-08-07 07:00:00	DIA	ETF	134.16	134.16	134.16	134.16	4000.0
2007-08-07 08:00:00	DIA	ETF	134.2	134.21	133.86	133.96	172700.0
2007-08-07 09:00:00	DIA	ETF	133.97	134.18	133.65	134.12	2260600.0
2007-08-07 10:00:00	DIA	ETF	134.12	134.39	133.84	133.98	3110800.0
2007-08-07 11:00:00	DIA	ETF	133.99	134.58	133.97	134.46	1881500.0
2007-08-07 12:00:00	DIA	ETF	134.47	134.82	134.41	134.57	2178700.0
2007-08-07 13:00:00	DIA	ETF	134.55	135.1	134.54	134.99	1692100.0
2007-08-07 14:00:00	DIA	ETF	135.0	135.4	133.39	134.89	10413000.0
2007-08-07 15:00:00	DIA	ETF	134.89	136.03	134.53	134.86	7522600.0

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

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