PREVIEW / stock_1hour / 2000-03-29

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-03-29.parquet
  size:    286 KB
  rows:    14,571
  symbols: 1,145

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-03-29 09:00:00	AAPL	Stock	1.2444	1.245	1.2232	1.2235	27036800.0
2000-03-29 10:00:00	AAPL	Stock	1.2243	1.2355	1.2098	1.2143	40051200.0
2000-03-29 11:00:00	AAPL	Stock	1.2132	1.2188	1.2059	1.2148	33208000.0
2000-03-29 12:00:00	AAPL	Stock	1.2154	1.2171	1.1964	1.2015	20092800.0
2000-03-29 13:00:00	AAPL	Stock	1.2026	1.2093	1.1987	1.1987	23419200.0
2000-03-29 14:00:00	AAPL	Stock	1.1992	1.2243	1.1948	1.2176	42033600.0
2000-03-29 15:00:00	AAPL	Stock	1.2176	1.2333	1.2076	1.2132	37329600.0
2000-03-29 16:00:00	AAPL	Stock	1.2132	1.2137	1.2126	1.2132	649600.0
2000-03-29 09:00:00	MSFT	Stock	52.5938	53.2188	52.5625	52.75	6419600.0
2000-03-29 10:00:00	MSFT	Stock	52.75	53.5	52.625	53.1562	7768400.0
2000-03-29 11:00:00	MSFT	Stock	53.125	53.4375	52.8125	53.1562	10257600.0
2000-03-29 12:00:00	MSFT	Stock	53.1875	53.5	53.125	53.2656	6516600.0
2000-03-29 13:00:00	MSFT	Stock	53.25	53.75	53.0625	53.3125	7556200.0
2000-03-29 14:00:00	MSFT	Stock	53.3125	54.2812	53.1875	53.8125	10583600.0
2000-03-29 15:00:00	MSFT	Stock	53.8125	54.4688	53.5	53.5938	11155800.0
2000-03-29 16:00:00	MSFT	Stock	53.5938	53.5938	53.4375	53.5938	91000.0
2000-03-29 09:00:00	NVDA	Stock	0.1685	0.1724	0.1591	0.1591	36864000.0
2000-03-29 10:00:00	NVDA	Stock	0.1588	0.1646	0.1573	0.1618	60912000.0
2000-03-29 11:00:00	NVDA	Stock	0.1617	0.1617	0.15	0.1569	62976000.0
2000-03-29 12:00:00	NVDA	Stock	0.1573	0.1618	0.1573	0.1573	75408000.0
2000-03-29 13:00:00	NVDA	Stock	0.1573	0.1594	0.1573	0.1583	79392000.0
2000-03-29 14:00:00	NVDA	Stock	0.1583	0.1622	0.1573	0.1594	43056000.0
2000-03-29 15:00:00	NVDA	Stock	0.1602	0.1635	0.1551	0.1568	80784000.0
2000-03-29 16:00:00	NVDA	Stock	0.1562	0.1568	0.1562	0.1568	720000.0
2000-03-29 09:00:00	AMZN	Stock	3.475	3.4938	3.4062	3.4094	10980000.0
2000-03-29 10:00:00	AMZN	Stock	3.4062	3.4688	3.4	3.4375	11844000.0
2000-03-29 11:00:00	AMZN	Stock	3.4344	3.4375	3.375	3.3969	19174000.0
2000-03-29 12:00:00	AMZN	Stock	3.3969	3.4406	3.3	3.3062	13976000.0
2000-03-29 13:00:00	AMZN	Stock	3.3031	3.3438	3.25	3.3281	23648000.0
2000-03-29 14:00:00	AMZN	Stock	3.3281	3.4	3.3062	3.3562	11388000.0
2000-03-29 15:00:00	AMZN	Stock	3.3562	3.4125	3.3125	3.3125	20942000.0
2000-03-29 16:00:00	AMZN	Stock	3.3125	3.3156	3.3125	3.3125	220000.0
2000-03-29 09:00:00	CL	Stock	28.5	28.75	28.3125	28.375	807800.0
2000-03-29 10:00:00	CL	Stock	28.375	28.8125	28.3438	28.4688	777000.0
2000-03-29 11:00:00	CL	Stock	28.4375	28.5	27.9375	28.1875	663800.0
2000-03-29 12:00:00	CL	Stock	28.1562	28.2188	27.9062	27.9688	376800.0
2000-03-29 13:00:00	CL	Stock	27.9375	28.25	27.8438	28.125	492800.0
2000-03-29 14:00:00	CL	Stock	28.0938	28.25	27.9375	28.0	549400.0
2000-03-29 15:00:00	CL	Stock	28.0625	28.25	28.0625	28.1562	489400.0
2000-03-29 16:00:00	CL	Stock	28.1875	28.2188	28.1875	28.2188	160000.0

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

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