PREVIEW / stock_1hour / 2000-04-14

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-04-14.parquet
  size:    289 KB
  rows:    14,840
  symbols: 1,162

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-04-14 09:00:00	AAPL	Stock	0.976	1.0525	0.9732	1.0452	51262400.0
2000-04-14 10:00:00	AAPL	Stock	1.0452	1.0513	1.0212	1.0276	112907200.0
2000-04-14 11:00:00	AAPL	Stock	1.0276	1.0276	0.9933	0.9989	86206400.0
2000-04-14 12:00:00	AAPL	Stock	1.0011	1.024	0.9833	0.9955	90328000.0
2000-04-14 13:00:00	AAPL	Stock	0.9961	1.0396	0.9922	1.0374	73942400.0
2000-04-14 14:00:00	AAPL	Stock	1.0357	1.0368	1.0073	1.0251	76328000.0
2000-04-14 15:00:00	AAPL	Stock	1.0246	1.0536	0.99	0.9989	120624000.0
2000-04-14 16:00:00	AAPL	Stock	0.9994	0.9994	0.9989	0.9989	246400.0
2000-04-14 09:00:00	MSFT	Stock	39.5625	39.625	38.75	39.0938	13076000.0
2000-04-14 10:00:00	MSFT	Stock	39.0938	39.1875	38.375	38.7812	18665600.0
2000-04-14 11:00:00	MSFT	Stock	38.7812	38.7812	37.5312	37.5312	24327800.0
2000-04-14 12:00:00	MSFT	Stock	37.5625	38.0	37.4844	37.5625	23562600.0
2000-04-14 13:00:00	MSFT	Stock	37.5625	37.9688	37.5625	37.75	15484400.0
2000-04-14 14:00:00	MSFT	Stock	37.75	37.8125	37.2188	37.3438	22002200.0
2000-04-14 15:00:00	MSFT	Stock	37.3125	37.5625	36.625	37.0625	22036600.0
2000-04-14 16:00:00	MSFT	Stock	37.0312	37.2344	36.9688	37.0625	39000.0
2000-04-14 09:00:00	NVDA	Stock	0.1471	0.1542	0.1417	0.1542	26352000.0
2000-04-14 10:00:00	NVDA	Stock	0.1553	0.1585	0.151	0.1566	31728000.0
2000-04-14 11:00:00	NVDA	Stock	0.1566	0.1572	0.138	0.1419	88368000.0
2000-04-14 12:00:00	NVDA	Stock	0.1413	0.1507	0.1396	0.1482	61200000.0
2000-04-14 13:00:00	NVDA	Stock	0.1479	0.1529	0.1437	0.149	47952000.0
2000-04-14 14:00:00	NVDA	Stock	0.1492	0.1492	0.1375	0.1419	70368000.0
2000-04-14 15:00:00	NVDA	Stock	0.1427	0.1474	0.1365	0.1433	62160000.0
2000-04-14 09:00:00	AMZN	Stock	2.3938	2.6188	2.35	2.5969	24872000.0
2000-04-14 10:00:00	AMZN	Stock	2.6062	2.6125	2.3062	2.3125	44998000.0
2000-04-14 11:00:00	AMZN	Stock	2.3219	2.325	2.0406	2.1531	104600000.0
2000-04-14 12:00:00	AMZN	Stock	2.15	2.3438	2.1375	2.1938	48198000.0
2000-04-14 13:00:00	AMZN	Stock	2.1969	2.3844	2.1875	2.3625	53594000.0
2000-04-14 14:00:00	AMZN	Stock	2.3594	2.4062	2.275	2.3094	47380000.0
2000-04-14 15:00:00	AMZN	Stock	2.3031	2.3688	2.2312	2.3438	43106000.0
2000-04-14 16:00:00	AMZN	Stock	2.3453	2.3469	2.3438	2.3438	300000.0
2000-04-14 09:00:00	CL	Stock	27.875	28.125	27.875	27.9062	528800.0
2000-04-14 10:00:00	CL	Stock	27.875	28.5	27.875	28.4375	821800.0
2000-04-14 11:00:00	CL	Stock	28.4375	28.6875	28.0	28.0312	605800.0
2000-04-14 12:00:00	CL	Stock	28.0625	28.4062	28.0312	28.2812	422400.0
2000-04-14 13:00:00	CL	Stock	28.3125	28.3125	27.8125	27.9688	437000.0
2000-04-14 14:00:00	CL	Stock	28.0625	28.0625	27.8125	27.9688	690600.0
2000-04-14 15:00:00	CL	Stock	27.9688	28.0	27.2188	27.5312	1142200.0
2000-04-14 16:00:00	CL	Stock	27.5	27.875	27.5	27.875	348600.0

> showing 39 of 14,840 rows — these rows as CSV

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