PREVIEW / stock_1hour / 2000-11-10

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-11-10.parquet
  size:    296 KB
  rows:    15,263
  symbols: 1,226

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-11-10 08:00:00	AAPL	Stock	0.3393	0.3527	0.3326	0.3393	3987200.0
2000-11-10 09:00:00	AAPL	Stock	0.3393	0.3549	0.3348	0.3493	71747200.0
2000-11-10 10:00:00	AAPL	Stock	0.3493	0.3549	0.3471	0.3527	98644000.0
2000-11-10 11:00:00	AAPL	Stock	0.3527	0.3549	0.3493	0.3493	56408800.0
2000-11-10 12:00:00	AAPL	Stock	0.3493	0.3516	0.3477	0.3493	36332800.0
2000-11-10 13:00:00	AAPL	Stock	0.3493	0.3504	0.3482	0.3493	30531200.0
2000-11-10 14:00:00	AAPL	Stock	0.3493	0.3504	0.3482	0.3493	30133600.0
2000-11-10 15:00:00	AAPL	Stock	0.3493	0.3493	0.3404	0.3404	64092000.0
2000-11-10 16:00:00	AAPL	Stock	0.3415	0.346	0.3393	0.3404	5068000.0
2000-11-10 17:00:00	AAPL	Stock	0.3432	0.3527	0.3432	0.3482	291200.0
2000-11-10 18:00:00	AAPL	Stock	0.3477	0.3482	0.3477	0.3482	33600.0
2000-11-10 08:00:00	MSFT	Stock	34.4375	34.9375	34.25	34.6562	614600.0
2000-11-10 09:00:00	MSFT	Stock	34.6875	35.1562	34.5625	34.75	12964000.0
2000-11-10 10:00:00	MSFT	Stock	34.7812	35.0625	34.3438	34.3438	13792400.0
2000-11-10 11:00:00	MSFT	Stock	34.375	34.4688	33.9375	34.0	10067600.0
2000-11-10 12:00:00	MSFT	Stock	34.0	34.0625	33.4062	33.6875	13826000.0
2000-11-10 13:00:00	MSFT	Stock	33.6875	34.0625	33.5	33.9062	7000400.0
2000-11-10 14:00:00	MSFT	Stock	33.9375	34.125	33.4062	33.9375	11512400.0
2000-11-10 15:00:00	MSFT	Stock	33.9062	34.0938	33.6562	33.6875	14847400.0
2000-11-10 16:00:00	MSFT	Stock	33.6875	34.125	33.625	33.6875	2673000.0
2000-11-10 17:00:00	MSFT	Stock	33.6875	33.875	33.6875	33.8594	8000.0
2000-11-10 18:00:00	MSFT	Stock	33.8438	33.8594	33.8438	33.8438	2400.0
2000-11-10 08:00:00	NVDA	Stock	0.2625	0.2625	0.2531	0.2578	4392000.0
2000-11-10 09:00:00	NVDA	Stock	0.256	0.2813	0.25	0.2516	206016000.0
2000-11-10 10:00:00	NVDA	Stock	0.2523	0.2531	0.2443	0.2496	259944000.0
2000-11-10 11:00:00	NVDA	Stock	0.25	0.2526	0.2453	0.2458	75552000.0
2000-11-10 12:00:00	NVDA	Stock	0.2458	0.2495	0.2453	0.2477	38568000.0
2000-11-10 13:00:00	NVDA	Stock	0.2471	0.2477	0.2404	0.2448	62160000.0
2000-11-10 14:00:00	NVDA	Stock	0.2448	0.2477	0.2385	0.2474	39528000.0
2000-11-10 15:00:00	NVDA	Stock	0.2474	0.2474	0.2406	0.2451	55248000.0
2000-11-10 16:00:00	NVDA	Stock	0.2453	0.2453	0.2401	0.2401	1680000.0
2000-11-10 17:00:00	NVDA	Stock	0.2458	0.2458	0.2406	0.2406	72000.0
2000-11-10 18:00:00	NVDA	Stock	0.2406	0.2406	0.2406	0.2406	48000.0
2000-11-10 08:00:00	AMZN	Stock	1.5031	1.525	1.5031	1.525	316000.0
2000-11-10 09:00:00	AMZN	Stock	1.525	1.5625	1.5	1.5188	14370000.0
2000-11-10 10:00:00	AMZN	Stock	1.5188	1.5938	1.5188	1.55	21256000.0
2000-11-10 11:00:00	AMZN	Stock	1.55	1.5531	1.5031	1.5031	11714000.0
2000-11-10 12:00:00	AMZN	Stock	1.5062	1.5375	1.5	1.5281	9738000.0
2000-11-10 13:00:00	AMZN	Stock	1.525	1.5312	1.5	1.5188	10880000.0
2000-11-10 14:00:00	AMZN	Stock	1.5188	1.55	1.5062	1.5219	11410000.0
2000-11-10 15:00:00	AMZN	Stock	1.5219	1.5375	1.5031	1.5031	17208000.0
2000-11-10 16:00:00	AMZN	Stock	1.5031	1.5125	1.4938	1.5	1842000.0
2000-11-10 17:00:00	AMZN	Stock	1.4938	1.525	1.4938	1.5125	22000.0
2000-11-10 18:00:00	AMZN	Stock	1.5	1.5	1.5	1.5	12000.0
2000-11-10 09:00:00	CL	Stock	29.43	29.7	29.275	29.33	571600.0
2000-11-10 10:00:00	CL	Stock	29.325	29.975	29.275	29.96	840000.0
2000-11-10 11:00:00	CL	Stock	29.96	29.98	29.75	29.815	696400.0
2000-11-10 12:00:00	CL	Stock	29.825	29.825	29.625	29.645	662800.0
2000-11-10 13:00:00	CL	Stock	29.645	29.935	29.63	29.825	499200.0
2000-11-10 14:00:00	CL	Stock	29.825	29.9	29.745	29.9	302200.0

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

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