PREVIEW / stock_1hour / 2008-10-23

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-10-23.parquet
  size:    803 KB
  rows:    40,675
  symbols: 3,312

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
2008-10-23 04:00:00	AAPL	Stock	3.4643	3.5	3.4643	3.5	16800.0
2008-10-23 07:00:00	AAPL	Stock	3.4536	3.4643	3.395	3.4125	224420.0
2008-10-23 08:00:00	AAPL	Stock	3.4107	3.4571	3.4	3.4571	3099656.0
2008-10-23 09:00:00	AAPL	Stock	3.4586	3.5089	3.4011	3.4757	198074408.0
2008-10-23 10:00:00	AAPL	Stock	3.4771	3.5161	3.4446	3.5082	269577952.0
2008-10-23 11:00:00	AAPL	Stock	3.5082	3.5446	3.4893	3.5161	206474828.0
2008-10-23 12:00:00	AAPL	Stock	3.515	3.5168	3.4171	3.42	168086604.0
2008-10-23 13:00:00	AAPL	Stock	3.4196	3.4625	3.3929	3.4046	183471456.0
2008-10-23 14:00:00	AAPL	Stock	3.4043	3.4057	3.2821	3.3639	287382312.0
2008-10-23 15:00:00	AAPL	Stock	3.3654	3.5246	3.345	3.5079	326087636.0
2008-10-23 16:00:00	AAPL	Stock	3.5082	3.5429	3.4294	3.5196	22741488.0
2008-10-23 17:00:00	AAPL	Stock	3.5204	3.5204	3.4886	3.4975	911904.0
2008-10-23 18:00:00	AAPL	Stock	3.4982	3.5057	3.4957	3.5043	619752.0
2008-10-23 19:00:00	AAPL	Stock	3.5029	3.5086	3.4929	3.4929	670432.0
2008-10-23 04:00:00	MSFT	Stock	21.95	21.95	21.95	21.95	200.0
2008-10-23 07:00:00	MSFT	Stock	21.89	21.89	21.53	21.55	1175.0
2008-10-23 08:00:00	MSFT	Stock	21.62	21.65	21.3	21.65	96172.0
2008-10-23 09:00:00	MSFT	Stock	21.63	22.2	21.01	21.44	13829242.0
2008-10-23 10:00:00	MSFT	Stock	21.45	22.21	21.31	22.06	23266967.0
2008-10-23 11:00:00	MSFT	Stock	22.06	22.22	21.7	21.96	15417429.0
2008-10-23 12:00:00	MSFT	Stock	21.96	21.962	21.27	21.35	12817660.0
2008-10-23 13:00:00	MSFT	Stock	21.35	21.5	21.03	21.13	13943908.0
2008-10-23 14:00:00	MSFT	Stock	21.12	21.32	20.89	21.1	18638931.0
2008-10-23 15:00:00	MSFT	Stock	21.11	22.59	21.0	22.33	38779961.0
2008-10-23 16:00:00	MSFT	Stock	22.39	23.7	21.05	22.73	13054093.0
2008-10-23 17:00:00	MSFT	Stock	22.73	22.73	21.557	22.42	1548938.0
2008-10-23 18:00:00	MSFT	Stock	22.47	22.52	22.25	22.27	131369.0
2008-10-23 19:00:00	MSFT	Stock	22.31	22.35	22.11	22.11	85500.0
2008-10-23 08:00:00	NVDA	Stock	0.1748	0.1748	0.1718	0.1728	151600.0
2008-10-23 09:00:00	NVDA	Stock	0.1738	0.1765	0.1665	0.17	62751080.0
2008-10-23 10:00:00	NVDA	Stock	0.1698	0.177	0.1688	0.1765	90327800.0
2008-10-23 11:00:00	NVDA	Stock	0.1768	0.177	0.1715	0.1718	46809840.0
2008-10-23 12:00:00	NVDA	Stock	0.1718	0.172	0.1642	0.1648	82398000.0
2008-10-23 13:00:00	NVDA	Stock	0.1645	0.1668	0.1628	0.1635	81650640.0
2008-10-23 14:00:00	NVDA	Stock	0.1637	0.1637	0.1565	0.1575	155708120.0
2008-10-23 15:00:00	NVDA	Stock	0.1578	0.1645	0.1565	0.1638	294324560.0
2008-10-23 16:00:00	NVDA	Stock	0.1635	0.167	0.1625	0.1642	14939120.0
2008-10-23 17:00:00	NVDA	Stock	0.1642	0.1665	0.1635	0.1665	735880.0
2008-10-23 19:00:00	NVDA	Stock	0.1662	0.1662	0.1648	0.1648	36000.0
2008-10-23 07:00:00	AMZN	Stock	2.181	2.181	2.09	2.0925	478580.0
2008-10-23 08:00:00	AMZN	Stock	2.0995	2.1815	2.09	2.15	2844880.0
2008-10-23 09:00:00	AMZN	Stock	2.15	2.297	2.135	2.209	118134320.0
2008-10-23 10:00:00	AMZN	Stock	2.208	2.439	2.201	2.437	152354540.0
2008-10-23 11:00:00	AMZN	Stock	2.433	2.4475	2.3285	2.359	78427800.0
2008-10-23 12:00:00	AMZN	Stock	2.3585	2.41	2.3275	2.3585	56936420.0
2008-10-23 13:00:00	AMZN	Stock	2.358	2.375	2.3215	2.3605	51173400.0
2008-10-23 14:00:00	AMZN	Stock	2.3605	2.3765	2.2945	2.3705	56740060.0
2008-10-23 15:00:00	AMZN	Stock	2.3715	2.5455	2.3535	2.516	121014920.0
2008-10-23 16:00:00	AMZN	Stock	2.55	2.55	2.3441	2.5005	5836400.0
2008-10-23 17:00:00	AMZN	Stock	2.51	2.512	2.49	2.4975	126880.0

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

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