PREVIEW / stock_1hour / 2001-01-17

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-01-17.parquet
  size:    323 KB
  rows:    16,745
  symbols: 1,269

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-17 08:00:00	AAPL	Stock	0.3147	0.317	0.3125	0.3125	470400.0
2001-01-17 09:00:00	AAPL	Stock	0.3125	0.317	0.3058	0.3069	59819200.0
2001-01-17 10:00:00	AAPL	Stock	0.308	0.308	0.3025	0.3047	93604000.0
2001-01-17 11:00:00	AAPL	Stock	0.3036	0.3047	0.298	0.2991	127999200.0
2001-01-17 12:00:00	AAPL	Stock	0.2991	0.3013	0.298	0.3002	73208800.0
2001-01-17 13:00:00	AAPL	Stock	0.3002	0.3069	0.2991	0.3058	76148800.0
2001-01-17 14:00:00	AAPL	Stock	0.3058	0.3069	0.2991	0.2991	95054400.0
2001-01-17 15:00:00	AAPL	Stock	0.2991	0.3013	0.2946	0.2991	88155200.0
2001-01-17 16:00:00	AAPL	Stock	0.2991	0.327	0.2958	0.3125	68622400.0
2001-01-17 17:00:00	AAPL	Stock	0.3147	0.3209	0.3125	0.3136	37984800.0
2001-01-17 18:00:00	AAPL	Stock	0.3136	0.3158	0.3136	0.3136	1719200.0
2001-01-17 08:00:00	MSFT	Stock	26.9375	27.25	26.5312	27.125	414000.0
2001-01-17 09:00:00	MSFT	Stock	27.0	27.125	26.2812	26.9688	8165800.0
2001-01-17 10:00:00	MSFT	Stock	26.9688	27.375	26.9375	27.3125	10086200.0
2001-01-17 11:00:00	MSFT	Stock	27.3125	27.4375	27.125	27.2812	8592000.0
2001-01-17 12:00:00	MSFT	Stock	27.2812	27.4375	27.1875	27.1875	5863200.0
2001-01-17 13:00:00	MSFT	Stock	27.1875	27.25	27.0	27.125	7038400.0
2001-01-17 14:00:00	MSFT	Stock	27.1406	27.1875	26.6875	26.75	6966400.0
2001-01-17 15:00:00	MSFT	Stock	26.75	26.7812	26.2812	26.4375	13606400.0
2001-01-17 16:00:00	MSFT	Stock	26.4375	27.0	26.375	26.75	1506800.0
2001-01-17 17:00:00	MSFT	Stock	26.75	26.7812	26.4688	26.75	2848400.0
2001-01-17 18:00:00	MSFT	Stock	26.75	26.75	26.5625	26.75	9200.0
2001-01-17 08:00:00	NVDA	Stock	0.1803	0.1875	0.1803	0.1875	5112000.0
2001-01-17 09:00:00	NVDA	Stock	0.1938	0.1984	0.1876	0.1914	71640000.0
2001-01-17 10:00:00	NVDA	Stock	0.1919	0.1969	0.1906	0.1958	104424000.0
2001-01-17 11:00:00	NVDA	Stock	0.1951	0.2	0.1945	0.1984	59808000.0
2001-01-17 12:00:00	NVDA	Stock	0.1984	0.2	0.194	0.1948	50544000.0
2001-01-17 13:00:00	NVDA	Stock	0.1948	0.1953	0.1917	0.1948	35184000.0
2001-01-17 14:00:00	NVDA	Stock	0.1951	0.1953	0.188	0.188	74376000.0
2001-01-17 15:00:00	NVDA	Stock	0.188	0.1896	0.1862	0.1867	60960000.0
2001-01-17 16:00:00	NVDA	Stock	0.1874	0.1917	0.1793	0.1888	22320000.0
2001-01-17 17:00:00	NVDA	Stock	0.1917	0.1917	0.1917	0.1917	72000.0
2001-01-17 08:00:00	AMZN	Stock	0.9188	0.9469	0.9125	0.9406	686000.0
2001-01-17 09:00:00	AMZN	Stock	0.9375	0.9781	0.9375	0.9438	21226000.0
2001-01-17 10:00:00	AMZN	Stock	0.9438	0.9625	0.9312	0.9344	25774000.0
2001-01-17 11:00:00	AMZN	Stock	0.9344	0.9562	0.9188	0.9469	28706000.0
2001-01-17 12:00:00	AMZN	Stock	0.9453	0.9656	0.9406	0.9562	20504000.0
2001-01-17 13:00:00	AMZN	Stock	0.9531	0.9625	0.9406	0.95	9056000.0
2001-01-17 14:00:00	AMZN	Stock	0.95	0.9531	0.9344	0.9375	16222000.0
2001-01-17 15:00:00	AMZN	Stock	0.9375	0.9406	0.8875	0.9188	31004000.0
2001-01-17 16:00:00	AMZN	Stock	0.9188	0.925	0.9062	0.9188	1518000.0
2001-01-17 17:00:00	AMZN	Stock	0.9188	0.9234	0.9188	0.9188	38000.0
2001-01-17 18:00:00	AMZN	Stock	0.9125	0.9156	0.9125	0.9156	48000.0
2001-01-17 09:00:00	CL	Stock	28.95	28.95	28.55	28.65	370400.0
2001-01-17 10:00:00	CL	Stock	28.65	28.65	28.3	28.32	426800.0
2001-01-17 11:00:00	CL	Stock	28.3	28.45	28.125	28.21	250600.0
2001-01-17 12:00:00	CL	Stock	28.225	28.225	27.95	27.995	421000.0
2001-01-17 13:00:00	CL	Stock	27.995	28.4	27.945	28.39	352000.0
2001-01-17 14:00:00	CL	Stock	28.415	28.54	28.4	28.475	362400.0
2001-01-17 15:00:00	CL	Stock	28.49	28.5	28.27	28.275	399600.0

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

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