PREVIEW / stock_1hour / 2000-04-04

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-04-04.parquet
  size:    292 KB
  rows:    14,950
  symbols: 1,150

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-04 09:00:00	AAPL	Stock	1.1842	1.1875	1.1317	1.1348	38897600.0
2000-04-04 10:00:00	AAPL	Stock	1.1373	1.1574	1.1166	1.1311	80472000.0
2000-04-04 11:00:00	AAPL	Stock	1.1311	1.1535	1.0714	1.0717	77705600.0
2000-04-04 12:00:00	AAPL	Stock	1.072	1.1004	1.0424	1.067	131712000.0
2000-04-04 13:00:00	AAPL	Stock	1.0692	1.1496	1.0435	1.1484	102099200.0
2000-04-04 14:00:00	AAPL	Stock	1.1487	1.1839	1.1217	1.1278	88289600.0
2000-04-04 15:00:00	AAPL	Stock	1.1339	1.1719	1.1272	1.1384	86307200.0
2000-04-04 16:00:00	AAPL	Stock	1.1367	1.1384	1.1367	1.1367	1332800.0
2000-04-04 09:00:00	MSFT	Stock	45.7812	46.0	45.0	45.3125	21030000.0
2000-04-04 10:00:00	MSFT	Stock	45.3438	45.75	43.9531	44.2188	38571200.0
2000-04-04 11:00:00	MSFT	Stock	44.2188	44.625	43.7812	43.7812	22737000.0
2000-04-04 12:00:00	MSFT	Stock	43.8281	44.375	42.9688	43.0156	23510400.0
2000-04-04 13:00:00	MSFT	Stock	43.0	44.125	42.4688	43.3125	23309600.0
2000-04-04 14:00:00	MSFT	Stock	43.3125	44.25	43.125	43.3438	16065000.0
2000-04-04 15:00:00	MSFT	Stock	43.5	44.5312	43.375	44.2812	19562600.0
2000-04-04 16:00:00	MSFT	Stock	44.2812	44.3125	44.25	44.2812	131400.0
2000-04-04 09:00:00	NVDA	Stock	0.1708	0.1737	0.1638	0.1664	50496000.0
2000-04-04 10:00:00	NVDA	Stock	0.1667	0.1708	0.1604	0.1604	35424000.0
2000-04-04 11:00:00	NVDA	Stock	0.1615	0.163	0.1474	0.1479	70416000.0
2000-04-04 12:00:00	NVDA	Stock	0.1471	0.148	0.1187	0.1315	119136000.0
2000-04-04 13:00:00	NVDA	Stock	0.1315	0.1531	0.1237	0.1521	74688000.0
2000-04-04 14:00:00	NVDA	Stock	0.1536	0.1634	0.1477	0.1508	82128000.0
2000-04-04 15:00:00	NVDA	Stock	0.15	0.1621	0.15	0.1565	37824000.0
2000-04-04 16:00:00	NVDA	Stock	0.1553	0.1562	0.1553	0.1562	1296000.0
2000-04-04 09:00:00	AMZN	Stock	3.1438	3.1875	3.0469	3.0563	18478000.0
2000-04-04 10:00:00	AMZN	Stock	3.0625	3.1438	3.0531	3.0781	48374000.0
2000-04-04 11:00:00	AMZN	Stock	3.075	3.1219	3.0	3.0031	28546000.0
2000-04-04 12:00:00	AMZN	Stock	3.0031	3.0438	2.7875	2.8375	54126000.0
2000-04-04 13:00:00	AMZN	Stock	2.8469	3.0	2.8	2.9875	41926000.0
2000-04-04 14:00:00	AMZN	Stock	2.9875	3.0875	2.9563	3.0375	27750000.0
2000-04-04 15:00:00	AMZN	Stock	3.0406	3.2719	3.0375	3.2	37160000.0
2000-04-04 16:00:00	AMZN	Stock	3.1969	3.1969	3.1969	3.1969	82000.0
2000-04-04 09:00:00	CL	Stock	30.0	30.5	29.875	30.0	1143400.0
2000-04-04 10:00:00	CL	Stock	29.9688	30.2188	29.875	29.9688	748400.0
2000-04-04 11:00:00	CL	Stock	30.0	30.1562	29.875	29.875	571200.0
2000-04-04 12:00:00	CL	Stock	29.9062	30.8125	29.8438	30.375	815000.0
2000-04-04 13:00:00	CL	Stock	30.3125	30.7812	29.8125	29.9375	1044400.0
2000-04-04 14:00:00	CL	Stock	29.8125	30.1562	29.625	29.9688	768600.0
2000-04-04 15:00:00	CL	Stock	30.0	30.4375	30.0	30.3125	610200.0
2000-04-04 16:00:00	CL	Stock	30.3438	30.3438	30.3438	30.3438	64000.0

> showing 40 of 14,950 rows — these rows as CSV

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