PREVIEW / stock_1hour / 2007-11-30

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-11-30.parquet
  size:    834 KB
  rows:    41,148
  symbols: 3,229

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-11-30 04:00:00	AAPL	Stock	6.6786	6.7029	6.665	6.7029	16800.0
2007-11-30 05:00:00	AAPL	Stock	6.7036	6.7086	6.6579	6.6579	102452.0
2007-11-30 06:00:00	AAPL	Stock	6.6704	6.6704	6.6521	6.6521	75992.0
2007-11-30 07:00:00	AAPL	Stock	6.6554	6.725	6.6554	6.6971	2322264.0
2007-11-30 08:00:00	AAPL	Stock	6.6964	6.7089	6.6718	6.6964	9448544.0
2007-11-30 09:00:00	AAPL	Stock	6.6964	6.7036	6.6607	6.6846	173351696.0
2007-11-30 10:00:00	AAPL	Stock	6.685	6.6975	6.5804	6.6111	244861456.0
2007-11-30 11:00:00	AAPL	Stock	6.6121	6.6139	6.4393	6.5254	242107992.0
2007-11-30 12:00:00	AAPL	Stock	6.5257	6.5429	6.4582	6.5386	101888724.0
2007-11-30 13:00:00	AAPL	Stock	6.5393	6.5464	6.4825	6.5218	83339564.0
2007-11-30 14:00:00	AAPL	Stock	6.5193	6.535	6.4829	6.5004	91277872.0
2007-11-30 15:00:00	AAPL	Stock	6.4989	6.5071	6.4179	6.5054	208001332.0
2007-11-30 16:00:00	AAPL	Stock	6.5021	6.5555	6.4964	6.5204	29224048.0
2007-11-30 17:00:00	AAPL	Stock	6.5196	6.5818	6.5079	6.5171	2413096.0
2007-11-30 18:00:00	AAPL	Stock	6.5168	6.5196	6.5079	6.5143	344344.0
2007-11-30 19:00:00	AAPL	Stock	6.5143	6.5225	6.5143	6.5143	243348.0
2007-11-30 05:00:00	MSFT	Stock	33.77	33.77	33.77	33.77	100.0
2007-11-30 07:00:00	MSFT	Stock	33.87	33.91	33.84	33.9	20600.0
2007-11-30 08:00:00	MSFT	Stock	33.91	33.99	33.59	33.9	189748.0
2007-11-30 09:00:00	MSFT	Stock	33.91	34.12	33.74	33.85	9460956.0
2007-11-30 10:00:00	MSFT	Stock	33.84	33.93	33.73	33.75	7998284.0
2007-11-30 11:00:00	MSFT	Stock	33.75	33.95	33.54	33.69	8444818.0
2007-11-30 12:00:00	MSFT	Stock	33.69	33.8	33.46	33.61	4408657.0
2007-11-30 13:00:00	MSFT	Stock	33.6	33.62	33.4	33.42	4561459.0
2007-11-30 14:00:00	MSFT	Stock	33.41	33.58	33.35	33.51	5923242.0
2007-11-30 15:00:00	MSFT	Stock	33.5	33.7	33.19	33.59	14171120.0
2007-11-30 16:00:00	MSFT	Stock	33.56	33.812	33.436	33.6	14639484.0
2007-11-30 17:00:00	MSFT	Stock	33.6	33.632	33.55	33.6	1008398.0
2007-11-30 18:00:00	MSFT	Stock	33.6	33.607	33.57	33.6	199435.0
2007-11-30 19:00:00	MSFT	Stock	33.6	33.6	33.6	33.6	1442.0
2007-11-30 08:00:00	NVDA	Stock	0.835	0.846	0.835	0.8415	377800.0
2007-11-30 09:00:00	NVDA	Stock	0.8438	0.8575	0.8288	0.8368	61752760.0
2007-11-30 10:00:00	NVDA	Stock	0.8365	0.84	0.8295	0.8312	81146840.0
2007-11-30 11:00:00	NVDA	Stock	0.8315	0.835	0.8208	0.8275	55716200.0
2007-11-30 12:00:00	NVDA	Stock	0.8273	0.8328	0.8212	0.8252	39720160.0
2007-11-30 13:00:00	NVDA	Stock	0.8252	0.826	0.8185	0.8194	32072560.0
2007-11-30 14:00:00	NVDA	Stock	0.8195	0.8218	0.8085	0.8113	56438720.0
2007-11-30 15:00:00	NVDA	Stock	0.811	0.8113	0.786	0.788	208561960.0
2007-11-30 16:00:00	NVDA	Stock	0.7878	0.8165	0.7875	0.7885	13026440.0
2007-11-30 17:00:00	NVDA	Stock	0.7885	0.828	0.7885	0.7942	1795400.0
2007-11-30 18:00:00	NVDA	Stock	0.7938	0.7942	0.7885	0.7942	1761680.0
2007-11-30 19:00:00	NVDA	Stock	0.7938	0.7942	0.7938	0.7938	43400.0
2007-11-30 08:00:00	AMZN	Stock	4.4995	4.5745	4.4995	4.5375	628200.0
2007-11-30 09:00:00	AMZN	Stock	4.5375	4.543	4.475	4.528	21342920.0
2007-11-30 10:00:00	AMZN	Stock	4.528	4.554	4.4745	4.493	27038920.0
2007-11-30 11:00:00	AMZN	Stock	4.495	4.5025	4.4158	4.499	23422680.0
2007-11-30 12:00:00	AMZN	Stock	4.4978	4.507	4.4615	4.507	9651820.0
2007-11-30 13:00:00	AMZN	Stock	4.5065	4.5118	4.4795	4.4885	9621120.0
2007-11-30 14:00:00	AMZN	Stock	4.489	4.4985	4.476	4.4856	11869080.0
2007-11-30 15:00:00	AMZN	Stock	4.485	4.527	4.451	4.527	25444980.0

> showing 50 of 41,148 rows — these rows as CSV

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