PREVIEW / stock_1hour / 2000-01-21

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-01-21.parquet
  size:    278 KB
  rows:    14,504
  symbols: 1,130

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-01-21 09:00:00	AAPL	Stock	1.0201	1.0201	0.9983	1.0045	109177600.0
2000-01-21 10:00:00	AAPL	Stock	1.0022	1.0089	0.99	1.0	126952000.0
2000-01-21 11:00:00	AAPL	Stock	1.0017	1.0045	0.9955	0.9994	50691200.0
2000-01-21 12:00:00	AAPL	Stock	1.0	1.005	0.9978	1.005	29220800.0
2000-01-21 13:00:00	AAPL	Stock	1.005	1.0084	0.9978	0.9983	36142400.0
2000-01-21 14:00:00	AAPL	Stock	0.9983	1.0	0.9838	0.9905	45113600.0
2000-01-21 15:00:00	AAPL	Stock	0.9905	0.9955	0.9855	0.9936	50019200.0
2000-01-21 16:00:00	AAPL	Stock	0.9936	0.9939	0.9933	0.9939	985600.0
2000-01-21 09:00:00	MSFT	Stock	53.5	53.625	52.8438	52.8438	11572800.0
2000-01-21 10:00:00	MSFT	Stock	52.875	52.9375	51.8438	52.4688	14687400.0
2000-01-21 11:00:00	MSFT	Stock	52.4375	52.625	51.9375	52.0	7865000.0
2000-01-21 12:00:00	MSFT	Stock	51.9688	52.5	51.9688	52.375	5435400.0
2000-01-21 13:00:00	MSFT	Stock	52.375	52.5938	52.25	52.3438	4546200.0
2000-01-21 14:00:00	MSFT	Stock	52.3125	52.4062	52.0312	52.0625	5408000.0
2000-01-21 15:00:00	MSFT	Stock	52.0625	52.375	51.625	51.9375	9008000.0
2000-01-21 16:00:00	MSFT	Stock	51.9062	51.9375	51.75	51.875	162000.0
2000-01-21 09:00:00	NVDA	Stock	0.094	0.0944	0.0927	0.0927	16032000.0
2000-01-21 10:00:00	NVDA	Stock	0.0935	0.0935	0.0909	0.0914	27168000.0
2000-01-21 11:00:00	NVDA	Stock	0.0917	0.093	0.0914	0.093	272784000.0
2000-01-21 12:00:00	NVDA	Stock	0.0927	0.093	0.0917	0.0919	29040000.0
2000-01-21 13:00:00	NVDA	Stock	0.0919	0.093	0.0918	0.0924	71376000.0
2000-01-21 14:00:00	NVDA	Stock	0.0927	0.0927	0.0922	0.0927	78528000.0
2000-01-21 15:00:00	NVDA	Stock	0.0924	0.094	0.0923	0.0932	47232000.0
2000-01-21 09:00:00	AMZN	Stock	3.2312	3.2312	3.175	3.1875	18176000.0
2000-01-21 10:00:00	AMZN	Stock	3.1906	3.1938	3.15	3.1594	25752000.0
2000-01-21 11:00:00	AMZN	Stock	3.1625	3.2	3.1562	3.1813	11022000.0
2000-01-21 12:00:00	AMZN	Stock	3.1813	3.1969	3.1688	3.1781	15810000.0
2000-01-21 13:00:00	AMZN	Stock	3.175	3.2063	3.175	3.1781	14210000.0
2000-01-21 14:00:00	AMZN	Stock	3.1781	3.1875	3.0	3.0625	67386000.0
2000-01-21 15:00:00	AMZN	Stock	3.0625	3.1125	3.0062	3.1	57740000.0
2000-01-21 16:00:00	AMZN	Stock	3.1047	3.1062	3.1	3.1031	564000.0
2000-01-21 09:00:00	CL	Stock	31.625	31.625	31.0625	31.1562	812200.0
2000-01-21 10:00:00	CL	Stock	31.1562	31.4375	30.875	31.25	513800.0
2000-01-21 11:00:00	CL	Stock	31.1875	31.5	31.125	31.4062	283200.0
2000-01-21 12:00:00	CL	Stock	31.4062	31.5938	31.1875	31.1875	218800.0
2000-01-21 13:00:00	CL	Stock	31.2188	31.375	30.7188	30.75	539000.0
2000-01-21 14:00:00	CL	Stock	30.75	30.8125	30.1875	30.6875	675000.0
2000-01-21 15:00:00	CL	Stock	30.6562	30.6875	30.3125	30.6562	393600.0
2000-01-21 16:00:00	CL	Stock	30.6562	30.6562	30.6562	30.6562	158800.0

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

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