PREVIEW / stock_1hour / 2000-10-18

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-10-18.parquet
  size:    298 KB
  rows:    15,601
  symbols: 1,238

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
2000-10-18 08:00:00	AAPL	Stock	0.3583	0.3588	0.3438	0.3482	1568000.0
2000-10-18 09:00:00	AAPL	Stock	0.3482	0.3594	0.3348	0.3415	93021600.0
2000-10-18 10:00:00	AAPL	Stock	0.3415	0.3683	0.3404	0.3672	94612000.0
2000-10-18 11:00:00	AAPL	Stock	0.3683	0.3761	0.356	0.3661	124773600.0
2000-10-18 12:00:00	AAPL	Stock	0.3661	0.3683	0.3605	0.3661	64680000.0
2000-10-18 13:00:00	AAPL	Stock	0.3661	0.3672	0.3605	0.3633	59404800.0
2000-10-18 14:00:00	AAPL	Stock	0.3638	0.3739	0.3605	0.3694	114066400.0
2000-10-18 15:00:00	AAPL	Stock	0.3683	0.3717	0.3571	0.3583	110432000.0
2000-10-18 16:00:00	AAPL	Stock	0.3583	0.3862	0.308	0.3281	28364000.0
2000-10-18 17:00:00	AAPL	Stock	0.3281	0.3393	0.2924	0.3103	44889600.0
2000-10-18 18:00:00	AAPL	Stock	0.3103	0.3125	0.308	0.3086	4037600.0
2000-10-18 08:00:00	MSFT	Stock	25.0	25.2344	24.2188	24.375	405600.0
2000-10-18 09:00:00	MSFT	Stock	24.375	25.2188	24.2188	24.375	13927400.0
2000-10-18 10:00:00	MSFT	Stock	24.375	25.3125	24.3125	25.0938	15283600.0
2000-10-18 11:00:00	MSFT	Stock	25.125	25.75	25.0625	25.5312	12678000.0
2000-10-18 12:00:00	MSFT	Stock	25.5312	25.9375	25.1875	25.7812	7911800.0
2000-10-18 13:00:00	MSFT	Stock	25.75	26.125	25.5938	26.125	11267600.0
2000-10-18 14:00:00	MSFT	Stock	26.0938	26.625	25.9688	26.4062	15263000.0
2000-10-18 15:00:00	MSFT	Stock	26.375	26.5312	25.8438	25.875	13533800.0
2000-10-18 16:00:00	MSFT	Stock	25.875	27.5	24.3125	26.625	7060800.0
2000-10-18 17:00:00	MSFT	Stock	26.5625	27.5	24.3438	27.4375	1352200.0
2000-10-18 18:00:00	MSFT	Stock	27.4219	32.8438	25.9062	27.9688	887400.0
2000-10-18 09:00:00	NVDA	Stock	0.2333	0.2354	0.219	0.2289	39504000.0
2000-10-18 10:00:00	NVDA	Stock	0.2297	0.2542	0.2292	0.251	92448000.0
2000-10-18 11:00:00	NVDA	Stock	0.2484	0.256	0.2409	0.2438	73200000.0
2000-10-18 12:00:00	NVDA	Stock	0.2438	0.2484	0.2438	0.2448	28800000.0
2000-10-18 13:00:00	NVDA	Stock	0.2448	0.2456	0.2396	0.2438	40464000.0
2000-10-18 14:00:00	NVDA	Stock	0.244	0.25	0.2417	0.2477	22368000.0
2000-10-18 15:00:00	NVDA	Stock	0.2475	0.2479	0.2388	0.2419	29688000.0
2000-10-18 16:00:00	NVDA	Stock	0.2419	0.2419	0.2396	0.2396	2112000.0
2000-10-18 17:00:00	NVDA	Stock	0.2318	0.2318	0.2318	0.2318	24000.0
2000-10-18 08:00:00	AMZN	Stock	1.0688	1.0953	0.9	1.0	2280000.0
2000-10-18 09:00:00	AMZN	Stock	1.0	1.05	0.9688	0.9875	34824000.0
2000-10-18 10:00:00	AMZN	Stock	0.9938	1.1781	0.9812	1.1719	54210000.0
2000-10-18 11:00:00	AMZN	Stock	1.1688	1.1875	1.0688	1.0984	50732000.0
2000-10-18 12:00:00	AMZN	Stock	1.0969	1.1625	1.0812	1.1531	29386000.0
2000-10-18 13:00:00	AMZN	Stock	1.1625	1.2375	1.1188	1.2281	37954000.0
2000-10-18 14:00:00	AMZN	Stock	1.2281	1.2562	1.1875	1.2469	43788000.0
2000-10-18 15:00:00	AMZN	Stock	1.2438	1.2688	1.2188	1.2562	66348000.0
2000-10-18 16:00:00	AMZN	Stock	1.2562	1.2812	1.2406	1.2406	6688000.0
2000-10-18 17:00:00	AMZN	Stock	0.9906	1.2875	0.9906	1.2875	200000.0
2000-10-18 18:00:00	AMZN	Stock	1.2906	1.3	1.2875	1.3	98000.0
2000-10-18 09:00:00	CL	Stock	25.5	25.75	25.5	25.7	481600.0
2000-10-18 10:00:00	CL	Stock	25.715	25.72	25.31	25.32	895000.0
2000-10-18 11:00:00	CL	Stock	25.29	25.325	25.125	25.25	385000.0
2000-10-18 12:00:00	CL	Stock	25.24	25.32	25.15	25.32	424000.0
2000-10-18 13:00:00	CL	Stock	25.285	25.425	25.25	25.365	444400.0
2000-10-18 14:00:00	CL	Stock	25.395	25.495	25.35	25.475	208600.0
2000-10-18 15:00:00	CL	Stock	25.45	25.6	25.43	25.52	520600.0
2000-10-18 16:00:00	CL	Stock	25.52	25.585	25.42	25.42	65200.0

> showing 50 of 15,601 rows — these rows as CSV

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