PREVIEW / stock_1hour / 2007-12-19

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-12-19.parquet
  size:    813 KB
  rows:    40,419
  symbols: 3,230

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-12-19 05:00:00	AAPL	Stock	6.5286	6.5286	6.5271	6.5271	30800.0
2007-12-19 06:00:00	AAPL	Stock	6.5179	6.5286	6.5	6.5286	47600.0
2007-12-19 07:00:00	AAPL	Stock	6.5179	6.5325	6.5107	6.5325	60956.0
2007-12-19 08:00:00	AAPL	Stock	6.5318	6.5446	6.5196	6.525	1949052.0
2007-12-19 09:00:00	AAPL	Stock	6.525	6.5746	6.4971	6.56	115492692.0
2007-12-19 10:00:00	AAPL	Stock	6.5604	6.5942	6.5161	6.5279	162239616.0
2007-12-19 11:00:00	AAPL	Stock	6.5271	6.5282	6.4611	6.475	130576068.0
2007-12-19 12:00:00	AAPL	Stock	6.4755	6.5214	6.4607	6.5107	87913252.0
2007-12-19 13:00:00	AAPL	Stock	6.5104	6.5193	6.4707	6.4793	57720544.0
2007-12-19 14:00:00	AAPL	Stock	6.4793	6.5839	6.4771	6.5643	136170552.0
2007-12-19 15:00:00	AAPL	Stock	6.5632	6.5729	6.5357	6.5368	116294136.0
2007-12-19 16:00:00	AAPL	Stock	6.5364	6.5586	6.5216	6.5496	15051876.0
2007-12-19 17:00:00	AAPL	Stock	6.5496	6.5982	6.54	6.5725	2583140.0
2007-12-19 18:00:00	AAPL	Stock	6.5768	6.5839	6.54	6.5768	781060.0
2007-12-19 19:00:00	AAPL	Stock	6.5793	6.5946	6.5793	6.5893	1035608.0
2007-12-19 07:00:00	MSFT	Stock	34.5	34.67	34.5	34.67	600.0
2007-12-19 08:00:00	MSFT	Stock	34.68	34.79	34.66	34.71	18010.0
2007-12-19 09:00:00	MSFT	Stock	34.72	34.99	34.65	34.96	4956892.0
2007-12-19 10:00:00	MSFT	Stock	34.96	35.14	34.75	34.86	9133901.0
2007-12-19 11:00:00	MSFT	Stock	34.86	34.89	34.7	34.8	6540278.0
2007-12-19 12:00:00	MSFT	Stock	34.8	34.85	34.52	34.63	5868560.0
2007-12-19 13:00:00	MSFT	Stock	34.63	34.64	34.38	34.49	4487976.0
2007-12-19 14:00:00	MSFT	Stock	34.48	34.83	34.46	34.779	10182484.0
2007-12-19 15:00:00	MSFT	Stock	34.77	34.83	34.72	34.76	14112112.0
2007-12-19 16:00:00	MSFT	Stock	34.76	34.98	34.705	34.89	2180815.0
2007-12-19 17:00:00	MSFT	Stock	34.89	35.04	34.79	34.96	1071754.0
2007-12-19 18:00:00	MSFT	Stock	34.97	34.97	34.79	34.91	13400.0
2007-12-19 19:00:00	MSFT	Stock	34.96	34.99	34.96	34.99	620.0
2007-12-19 08:00:00	NVDA	Stock	0.8578	0.858	0.8578	0.858	20000.0
2007-12-19 09:00:00	NVDA	Stock	0.8568	0.8625	0.8478	0.8612	21898120.0
2007-12-19 10:00:00	NVDA	Stock	0.8615	0.8618	0.8545	0.8552	27131120.0
2007-12-19 11:00:00	NVDA	Stock	0.855	0.8568	0.8475	0.8485	28632480.0
2007-12-19 12:00:00	NVDA	Stock	0.8485	0.8612	0.8468	0.8598	22245040.0
2007-12-19 13:00:00	NVDA	Stock	0.8598	0.8598	0.8518	0.854	18852880.0
2007-12-19 14:00:00	NVDA	Stock	0.8538	0.8692	0.8523	0.8665	38596160.0
2007-12-19 15:00:00	NVDA	Stock	0.8662	0.8685	0.8588	0.8605	78275160.0
2007-12-19 16:00:00	NVDA	Stock	0.8612	0.8633	0.858	0.8599	17704440.0
2007-12-19 17:00:00	NVDA	Stock	0.863	0.866	0.863	0.866	176680.0
2007-12-19 07:00:00	AMZN	Stock	4.3035	4.305	4.3035	4.305	8000.0
2007-12-19 08:00:00	AMZN	Stock	4.322	4.35	4.322	4.35	33000.0
2007-12-19 09:00:00	AMZN	Stock	4.35	4.4145	4.333	4.3845	13078780.0
2007-12-19 10:00:00	AMZN	Stock	4.387	4.4275	4.3715	4.413	22454380.0
2007-12-19 11:00:00	AMZN	Stock	4.4125	4.4425	4.388	4.399	21831820.0
2007-12-19 12:00:00	AMZN	Stock	4.3985	4.461	4.3935	4.455	18510260.0
2007-12-19 13:00:00	AMZN	Stock	4.455	4.4555	4.4125	4.4285	13017520.0
2007-12-19 14:00:00	AMZN	Stock	4.4285	4.4975	4.422	4.486	24945700.0
2007-12-19 15:00:00	AMZN	Stock	4.4865	4.4975	4.458	4.4695	28716200.0
2007-12-19 16:00:00	AMZN	Stock	4.469	4.485	4.436	4.4768	9591380.0
2007-12-19 17:00:00	AMZN	Stock	4.469	4.4845	4.469	4.4825	138220.0
2007-12-19 18:00:00	AMZN	Stock	4.482	4.4925	4.482	4.4915	29660.0

> showing 50 of 40,419 rows — these rows as CSV

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