PREVIEW / stock_1hour / 2001-01-16

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-01-16.parquet
  size:    327 KB
  rows:    16,662
  symbols: 1,260

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
2001-01-16 08:00:00	AAPL	Stock	0.308	0.308	0.308	0.308	212800.0
2001-01-16 09:00:00	AAPL	Stock	0.3092	0.3125	0.3047	0.3069	44783200.0
2001-01-16 10:00:00	AAPL	Stock	0.3069	0.3092	0.3047	0.308	44912000.0
2001-01-16 11:00:00	AAPL	Stock	0.3069	0.308	0.3047	0.3047	47650400.0
2001-01-16 12:00:00	AAPL	Stock	0.3058	0.3069	0.3047	0.3058	25205600.0
2001-01-16 13:00:00	AAPL	Stock	0.3069	0.3092	0.3058	0.3092	26633600.0
2001-01-16 14:00:00	AAPL	Stock	0.308	0.3092	0.3058	0.3058	25984000.0
2001-01-16 15:00:00	AAPL	Stock	0.3058	0.3092	0.3036	0.3047	50999200.0
2001-01-16 16:00:00	AAPL	Stock	0.3047	0.3069	0.3036	0.3036	5437600.0
2001-01-16 17:00:00	AAPL	Stock	0.3058	0.3069	0.3058	0.3069	207200.0
2001-01-16 18:00:00	AAPL	Stock	0.3069	0.3108	0.3058	0.3108	1069600.0
2001-01-16 08:00:00	MSFT	Stock	26.75	27.25	26.625	26.75	20800.0
2001-01-16 09:00:00	MSFT	Stock	26.7812	26.8125	26.2188	26.5	7155200.0
2001-01-16 10:00:00	MSFT	Stock	26.5312	26.75	25.9375	26.0312	12340600.0
2001-01-16 11:00:00	MSFT	Stock	26.0312	26.125	25.8125	25.875	7273000.0
2001-01-16 12:00:00	MSFT	Stock	25.8438	25.9062	25.5625	25.75	6671000.0
2001-01-16 13:00:00	MSFT	Stock	25.7188	25.9688	25.7188	25.9375	6653400.0
2001-01-16 14:00:00	MSFT	Stock	25.9688	26.125	25.875	25.9375	6224600.0
2001-01-16 15:00:00	MSFT	Stock	25.875	26.4375	25.8438	26.3125	11094800.0
2001-01-16 16:00:00	MSFT	Stock	26.2812	26.375	26.0	26.3438	3052400.0
2001-01-16 17:00:00	MSFT	Stock	26.375	26.5	26.125	26.5	132000.0
2001-01-16 18:00:00	MSFT	Stock	26.4688	26.75	26.4688	26.625	66000.0
2001-01-16 08:00:00	NVDA	Stock	0.196	0.196	0.1958	0.1958	2112000.0
2001-01-16 09:00:00	NVDA	Stock	0.1958	0.1969	0.1922	0.1927	35664000.0
2001-01-16 10:00:00	NVDA	Stock	0.1927	0.1953	0.1813	0.1828	55920000.0
2001-01-16 11:00:00	NVDA	Stock	0.1823	0.1859	0.1823	0.1833	28632000.0
2001-01-16 12:00:00	NVDA	Stock	0.1841	0.1854	0.1826	0.1833	7608000.0
2001-01-16 13:00:00	NVDA	Stock	0.1831	0.1854	0.1799	0.1813	76248000.0
2001-01-16 14:00:00	NVDA	Stock	0.181	0.1823	0.1779	0.181	42168000.0
2001-01-16 15:00:00	NVDA	Stock	0.1797	0.1854	0.1779	0.1805	82752000.0
2001-01-16 16:00:00	NVDA	Stock	0.1802	0.1924	0.1797	0.1924	29160000.0
2001-01-16 17:00:00	NVDA	Stock	0.1844	0.187	0.1844	0.187	816000.0
2001-01-16 18:00:00	NVDA	Stock	0.1854	0.1854	0.1854	0.1854	24000.0
2001-01-16 08:00:00	AMZN	Stock	0.8938	0.9031	0.8844	0.8969	38000.0
2001-01-16 09:00:00	AMZN	Stock	0.8875	0.9219	0.8625	0.8781	20336000.0
2001-01-16 10:00:00	AMZN	Stock	0.875	0.8812	0.8656	0.8719	15388000.0
2001-01-16 11:00:00	AMZN	Stock	0.875	0.8969	0.8719	0.8906	20436000.0
2001-01-16 12:00:00	AMZN	Stock	0.8906	0.8938	0.8812	0.8938	12468000.0
2001-01-16 13:00:00	AMZN	Stock	0.8938	0.9062	0.8875	0.9	9412000.0
2001-01-16 14:00:00	AMZN	Stock	0.9	0.9	0.8875	0.8906	9528000.0
2001-01-16 15:00:00	AMZN	Stock	0.8906	0.9094	0.8875	0.9062	15914000.0
2001-01-16 16:00:00	AMZN	Stock	0.9047	0.9125	0.8938	0.9125	1948000.0
2001-01-16 17:00:00	AMZN	Stock	0.9062	0.9125	0.9062	0.9125	48000.0
2001-01-16 18:00:00	AMZN	Stock	0.9125	0.9125	0.9094	0.9125	20000.0
2001-01-16 09:00:00	CL	Stock	28.95	28.955	28.725	28.725	236800.0
2001-01-16 10:00:00	CL	Stock	28.72	29.225	28.65	29.105	586800.0
2001-01-16 11:00:00	CL	Stock	29.115	29.115	28.81	28.915	400000.0
2001-01-16 12:00:00	CL	Stock	28.915	28.925	28.5	28.53	364000.0
2001-01-16 13:00:00	CL	Stock	28.53	28.75	28.53	28.75	311800.0
2001-01-16 14:00:00	CL	Stock	28.75	28.85	28.55	28.65	344800.0

> showing 50 of 16,662 rows — these rows as CSV

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