PREVIEW / etf_1hour / 2007-08-20

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-08-20.parquet
  size:    86 KB
  rows:    2,839

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-20 05:00:00	SPY	ETF	145.0	145.0	144.88	144.88	1000.0
2007-08-20 06:00:00	SPY	ETF	144.9	145.37	144.8	145.37	49300.0
2007-08-20 07:00:00	SPY	ETF	145.27	145.33	144.9	145.18	373700.0
2007-08-20 08:00:00	SPY	ETF	145.2	145.38	144.98	145.15	1749800.0
2007-08-20 09:00:00	SPY	ETF	145.18	145.36	144.36	144.71	21520049.0
2007-08-20 10:00:00	SPY	ETF	144.71	145.1	144.32	144.88	24816146.0
2007-08-20 11:00:00	SPY	ETF	144.89	144.9	143.93	143.99	20465120.0
2007-08-20 12:00:00	SPY	ETF	143.97	144.17	143.46	143.49	31001393.0
2007-08-20 13:00:00	SPY	ETF	143.49	144.05	143.29	143.6	23017494.0
2007-08-20 14:00:00	SPY	ETF	143.6	144.48	143.32	144.46	22804250.0
2007-08-20 15:00:00	SPY	ETF	144.46	145.47	144.42	144.75	32258184.0
2007-08-20 16:00:00	SPY	ETF	144.74	144.8243	144.35	144.5	6759300.0
2007-08-20 17:00:00	SPY	ETF	144.55	144.55	144.44	144.5	58400.0
2007-08-20 18:00:00	SPY	ETF	144.52	144.71	144.52	144.63	154200.0
2007-08-20 19:00:00	SPY	ETF	144.63	144.64	144.45	144.49	239700.0
2007-08-20 04:00:00	QQQ	ETF	46.52	46.53	46.52	46.53	700.0
2007-08-20 05:00:00	QQQ	ETF	46.55	46.55	46.55	46.55	100.0
2007-08-20 06:00:00	QQQ	ETF	46.5	46.52	46.5	46.5	21000.0
2007-08-20 07:00:00	QQQ	ETF	46.5	46.5	46.31	46.42	444391.0
2007-08-20 08:00:00	QQQ	ETF	46.42	46.51	46.39	46.47	2467405.0
2007-08-20 09:00:00	QQQ	ETF	46.48	46.53	46.25	46.46	15112800.0
2007-08-20 10:00:00	QQQ	ETF	46.47	46.64	46.42	46.53	15877249.0
2007-08-20 11:00:00	QQQ	ETF	46.53	46.54	46.33	46.35	12134948.0
2007-08-20 12:00:00	QQQ	ETF	46.34	46.4	46.18	46.2	17314393.0
2007-08-20 13:00:00	QQQ	ETF	46.21	46.38	46.08	46.21	19922425.0
2007-08-20 14:00:00	QQQ	ETF	46.2095	46.51	46.11	46.5	15377583.0
2007-08-20 15:00:00	QQQ	ETF	46.5	46.72	46.47	46.546	21079736.0
2007-08-20 16:00:00	QQQ	ETF	46.55	46.55	46.38	46.46	17635383.0
2007-08-20 17:00:00	QQQ	ETF	46.46	46.56	46.44	46.5	239673.0
2007-08-20 18:00:00	QQQ	ETF	46.49	46.54	46.48	46.54	21431.0
2007-08-20 19:00:00	QQQ	ETF	46.5	46.5	46.44	46.45	35657.0
2007-08-20 06:00:00	IWM	ETF	78.38	78.51	78.38	78.51	9000.0
2007-08-20 07:00:00	IWM	ETF	78.61	78.61	78.5	78.53	19600.0
2007-08-20 08:00:00	IWM	ETF	78.5	78.77	78.5	78.7	909100.0
2007-08-20 09:00:00	IWM	ETF	78.69	79.07	78.19	78.57	14699814.0
2007-08-20 10:00:00	IWM	ETF	78.58	78.99	78.28	78.54	14769842.0
2007-08-20 11:00:00	IWM	ETF	78.55	78.56	77.76	77.84	10539584.0
2007-08-20 12:00:00	IWM	ETF	77.84	77.99	77.47	77.68	8194152.0
2007-08-20 13:00:00	IWM	ETF	77.67	78.27	77.57	77.77	11904649.0
2007-08-20 14:00:00	IWM	ETF	77.78	78.33	77.63	78.33	9022787.0
2007-08-20 15:00:00	IWM	ETF	78.33	78.75	78.17	78.49	13899202.0
2007-08-20 16:00:00	IWM	ETF	78.51	78.51	78.24	78.3	16043500.0
2007-08-20 17:00:00	IWM	ETF	78.25	78.47	78.25	78.47	5039100.0
2007-08-20 18:00:00	IWM	ETF	78.38	78.38	78.38	78.38	500.0
2007-08-20 19:00:00	IWM	ETF	78.43	78.43	78.4	78.4	900.0
2007-08-20 07:00:00	DIA	ETF	131.09	131.09	130.85	131.08	55200.0
2007-08-20 08:00:00	DIA	ETF	130.98	131.11	130.89	130.97	13100.0
2007-08-20 09:00:00	DIA	ETF	131.0	131.16	130.53	130.76	1906300.0
2007-08-20 10:00:00	DIA	ETF	130.78	131.02	130.4	130.96	2117400.0
2007-08-20 11:00:00	DIA	ETF	130.96	130.96	130.28	130.32	2228800.0

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

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