PREVIEW / stock_1hour / 2001-01-04

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-01-04.parquet
  size:    325 KB
  rows:    16,719
  symbols: 1,265

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-04 08:00:00	AAPL	Stock	0.2857	0.2924	0.2857	0.2913	1120000.0
2001-01-04 09:00:00	AAPL	Stock	0.2913	0.3304	0.2879	0.3114	219828000.0
2001-01-04 10:00:00	AAPL	Stock	0.3119	0.3147	0.3002	0.3103	142419200.0
2001-01-04 11:00:00	AAPL	Stock	0.3114	0.317	0.3092	0.3158	71282400.0
2001-01-04 12:00:00	AAPL	Stock	0.3158	0.3192	0.3114	0.3125	66673600.0
2001-01-04 13:00:00	AAPL	Stock	0.3114	0.3125	0.3047	0.308	44240000.0
2001-01-04 14:00:00	AAPL	Stock	0.308	0.3092	0.3025	0.3058	41585600.0
2001-01-04 15:00:00	AAPL	Stock	0.3047	0.3092	0.3047	0.3047	50814400.0
2001-01-04 16:00:00	AAPL	Stock	0.3047	0.3259	0.3036	0.3248	5000800.0
2001-01-04 17:00:00	AAPL	Stock	0.3058	0.3058	0.3047	0.3058	324800.0
2001-01-04 18:00:00	AAPL	Stock	0.3058	0.308	0.3058	0.3058	106400.0
2001-01-04 08:00:00	MSFT	Stock	24.25	24.375	23.5312	23.625	1022800.0
2001-01-04 09:00:00	MSFT	Stock	23.6094	24.1406	23.375	23.6562	14795200.0
2001-01-04 10:00:00	MSFT	Stock	23.9062	24.9375	23.8438	24.4375	21486400.0
2001-01-04 11:00:00	MSFT	Stock	24.4375	24.6875	24.1562	24.4375	11809000.0
2001-01-04 12:00:00	MSFT	Stock	24.4062	24.7812	24.3438	24.4062	13457000.0
2001-01-04 13:00:00	MSFT	Stock	24.4062	24.625	24.1875	24.5	8692000.0
2001-01-04 14:00:00	MSFT	Stock	24.5	24.5625	23.875	24.25	15274800.0
2001-01-04 15:00:00	MSFT	Stock	24.2188	24.4375	24.0625	24.25	15372800.0
2001-01-04 16:00:00	MSFT	Stock	24.2188	24.375	24.1094	24.25	2830800.0
2001-01-04 17:00:00	MSFT	Stock	24.0625	24.6875	24.0625	24.5938	236200.0
2001-01-04 18:00:00	MSFT	Stock	24.5938	24.875	24.4375	24.5	6000.0
2001-01-04 08:00:00	NVDA	Stock	0.1667	0.1667	0.1583	0.1604	936000.0
2001-01-04 09:00:00	NVDA	Stock	0.1604	0.1745	0.1557	0.168	88488000.0
2001-01-04 10:00:00	NVDA	Stock	0.168	0.1721	0.1638	0.1693	73824000.0
2001-01-04 11:00:00	NVDA	Stock	0.1693	0.1771	0.1688	0.1768	44952000.0
2001-01-04 12:00:00	NVDA	Stock	0.1768	0.1833	0.1753	0.1813	79848000.0
2001-01-04 13:00:00	NVDA	Stock	0.1807	0.1859	0.176	0.1802	90768000.0
2001-01-04 14:00:00	NVDA	Stock	0.1802	0.1805	0.1734	0.176	120984000.0
2001-01-04 15:00:00	NVDA	Stock	0.1759	0.1841	0.1714	0.1818	220656000.0
2001-01-04 16:00:00	NVDA	Stock	0.1815	0.1818	0.1599	0.1792	18504000.0
2001-01-04 17:00:00	NVDA	Stock	0.1771	0.1771	0.1771	0.1771	72000.0
2001-01-04 08:00:00	AMZN	Stock	0.8781	0.8781	0.825	0.8375	196000.0
2001-01-04 09:00:00	AMZN	Stock	0.8375	0.8781	0.825	0.85	23048000.0
2001-01-04 10:00:00	AMZN	Stock	0.85	0.8625	0.7906	0.8062	27764000.0
2001-01-04 11:00:00	AMZN	Stock	0.8062	0.8531	0.8	0.85	24330000.0
2001-01-04 12:00:00	AMZN	Stock	0.8531	0.8656	0.8406	0.8406	18292000.0
2001-01-04 13:00:00	AMZN	Stock	0.8406	0.85	0.8281	0.8281	23230000.0
2001-01-04 14:00:00	AMZN	Stock	0.8281	0.8344	0.7875	0.7875	40368000.0
2001-01-04 15:00:00	AMZN	Stock	0.7875	0.8	0.7719	0.7719	37296000.0
2001-01-04 16:00:00	AMZN	Stock	0.775	0.7812	0.7656	0.7719	5008000.0
2001-01-04 17:00:00	AMZN	Stock	0.7719	0.7859	0.7688	0.7688	62000.0
2001-01-04 18:00:00	AMZN	Stock	0.7688	0.7875	0.7688	0.775	76000.0
2001-01-04 09:00:00	CL	Stock	30.25	30.25	29.775	29.8	497000.0
2001-01-04 10:00:00	CL	Stock	29.8	29.825	28.78	28.975	1140200.0
2001-01-04 11:00:00	CL	Stock	29.0	29.0	28.15	28.405	694800.0
2001-01-04 12:00:00	CL	Stock	28.41	28.8	28.245	28.325	964400.0
2001-01-04 13:00:00	CL	Stock	28.315	28.5	28.0	28.0	1218600.0
2001-01-04 14:00:00	CL	Stock	28.0	28.425	27.875	28.225	1526000.0
2001-01-04 15:00:00	CL	Stock	28.25	28.28	27.9	27.955	1869400.0

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

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