PREVIEW / stock_1hour / 2007-08-22

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-08-22.parquet
  size:    761 KB
  rows:    38,058
  symbols: 3,111

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-22 09:00:00	AAPL	Stock	4.6864	4.7368	4.6739	4.6968	195913788.0
2007-08-22 10:00:00	AAPL	Stock	4.6968	4.7054	4.6707	4.6796	170048284.0
2007-08-22 11:00:00	AAPL	Stock	4.68	4.6982	4.6661	4.6889	111838048.0
2007-08-22 12:00:00	AAPL	Stock	4.6886	4.7	4.6664	4.6689	89957196.0
2007-08-22 13:00:00	AAPL	Stock	4.6689	4.6964	4.6546	4.6929	108091508.0
2007-08-22 14:00:00	AAPL	Stock	4.6929	4.7196	4.6786	4.7171	112177464.0
2007-08-22 15:00:00	AAPL	Stock	4.7171	4.7411	4.7079	4.7325	181064268.0
2007-08-22 16:00:00	AAPL	Stock	4.7329	4.7329	4.7321	4.7325	9538928.0
2007-08-22 09:00:00	MSFT	Stock	28.27	28.32	28.06	28.09	3713734.0
2007-08-22 10:00:00	MSFT	Stock	28.09	28.2	28.07	28.13	4320057.0
2007-08-22 11:00:00	MSFT	Stock	28.132	28.25	28.091	28.2	5288983.0
2007-08-22 12:00:00	MSFT	Stock	28.191	28.21	28.07	28.11	4124697.0
2007-08-22 13:00:00	MSFT	Stock	28.103	28.15	28.06	28.13	3195253.0
2007-08-22 14:00:00	MSFT	Stock	28.13	28.14	28.01	28.063	4281580.0
2007-08-22 15:00:00	MSFT	Stock	28.07	28.25	28.05	28.21	11193197.0
2007-08-22 16:00:00	MSFT	Stock	28.22	28.22	28.22	28.22	1354429.0
2007-08-22 08:00:00	NVDA	Stock	0.7892	0.8025	0.7892	0.8025	1066920.0
2007-08-22 09:00:00	NVDA	Stock	0.8017	0.809	0.797	0.8017	94014420.0
2007-08-22 10:00:00	NVDA	Stock	0.8017	0.8071	0.7962	0.802	109571040.0
2007-08-22 11:00:00	NVDA	Stock	0.8023	0.8032	0.7948	0.799	61551780.0
2007-08-22 12:00:00	NVDA	Stock	0.799	0.8015	0.7925	0.7972	51976260.0
2007-08-22 13:00:00	NVDA	Stock	0.797	0.805	0.793	0.8015	61991820.0
2007-08-22 14:00:00	NVDA	Stock	0.8013	0.806	0.7958	0.8056	57386460.0
2007-08-22 15:00:00	NVDA	Stock	0.8055	0.8115	0.8052	0.8068	104754540.0
2007-08-22 16:00:00	NVDA	Stock	0.8067	0.809	0.8058	0.8062	1918020.0
2007-08-22 17:00:00	NVDA	Stock	0.8065	0.8065	0.8062	0.8062	149400.0
2007-08-22 18:00:00	NVDA	Stock	0.8068	0.8133	0.8065	0.813	5272080.0
2007-08-22 19:00:00	NVDA	Stock	0.8132	0.8208	0.8132	0.8208	176880.0
2007-08-22 08:00:00	AMZN	Stock	3.8925	3.9095	3.8825	3.9025	682000.0
2007-08-22 09:00:00	AMZN	Stock	3.9065	3.9745	3.9	3.925	31238300.0
2007-08-22 10:00:00	AMZN	Stock	3.925	3.9475	3.892	3.9435	28574100.0
2007-08-22 11:00:00	AMZN	Stock	3.9435	3.955	3.924	3.9295	14577880.0
2007-08-22 12:00:00	AMZN	Stock	3.9305	3.939	3.9105	3.915	10936520.0
2007-08-22 13:00:00	AMZN	Stock	3.915	3.93	3.9	3.9235	11040480.0
2007-08-22 14:00:00	AMZN	Stock	3.9235	3.935	3.912	3.926	10632660.0
2007-08-22 15:00:00	AMZN	Stock	3.926	3.9445	3.9165	3.923	19265440.0
2007-08-22 16:00:00	AMZN	Stock	3.9235	3.9325	3.9205	3.9325	3080400.0
2007-08-22 17:00:00	AMZN	Stock	3.9325	3.9325	3.93	3.93	34000.0
2007-08-22 18:00:00	AMZN	Stock	3.93	3.959	3.925	3.95	1642160.0
2007-08-22 19:00:00	AMZN	Stock	3.955	3.965	3.95	3.965	46940.0
2007-08-22 09:00:00	TLT	Stock	87.05	87.1	86.97	86.98	217500.0
2007-08-22 10:00:00	TLT	Stock	86.98	87.06	86.81	87.04	129600.0
2007-08-22 11:00:00	TLT	Stock	87.07	87.2	87.07	87.16	67400.0
2007-08-22 12:00:00	TLT	Stock	87.15	87.18	87.06	87.17	127187.0
2007-08-22 13:00:00	TLT	Stock	87.18	87.31	87.17	87.18	79200.0
2007-08-22 14:00:00	TLT	Stock	87.18	87.31	87.17	87.27	20600.0
2007-08-22 15:00:00	TLT	Stock	87.26	87.27	87.1	87.1	457500.0
2007-08-22 16:00:00	TLT	Stock	87.1	87.12	87.09	87.12	5100.0
2007-08-22 08:00:00	CL	Stock	33.15	33.15	33.15	33.15	800.0
2007-08-22 09:00:00	CL	Stock	33.5	33.53	33.33	33.33	324200.0

> showing 50 of 38,058 rows — these rows as CSV

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