PREVIEW / stock_1hour / 2000-01-20

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-01-20.parquet
  size:    283 KB
  rows:    14,763
  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-20 09:00:00	AAPL	Stock	1.0313	1.0491	1.0268	1.0368	368659200.0
2000-01-20 10:00:00	AAPL	Stock	1.0379	1.058	1.0377	1.0552	384608000.0
2000-01-20 11:00:00	AAPL	Stock	1.0558	1.0848	1.0536	1.0792	490156800.0
2000-01-20 12:00:00	AAPL	Stock	1.0792	1.0798	1.0569	1.0653	174921600.0
2000-01-20 13:00:00	AAPL	Stock	1.0653	1.0653	1.0474	1.053	78724800.0
2000-01-20 14:00:00	AAPL	Stock	1.0525	1.0625	1.0485	1.0541	81312000.0
2000-01-20 15:00:00	AAPL	Stock	1.0539	1.0552	1.0134	1.0134	154705600.0
2000-01-20 16:00:00	AAPL	Stock	1.014	1.0156	1.0134	1.0134	1456000.0
2000-01-20 09:00:00	MSFT	Stock	53.5312	54.5	53.0	54.2812	8681200.0
2000-01-20 10:00:00	MSFT	Stock	54.25	54.8438	54.2188	54.5469	10896800.0
2000-01-20 11:00:00	MSFT	Stock	54.5312	54.5938	53.7812	53.875	7669000.0
2000-01-20 12:00:00	MSFT	Stock	53.9062	53.9688	53.125	53.5625	6058800.0
2000-01-20 13:00:00	MSFT	Stock	53.5312	53.8125	53.3125	53.375	5483800.0
2000-01-20 14:00:00	MSFT	Stock	53.3438	53.875	53.0312	53.125	6138800.0
2000-01-20 15:00:00	MSFT	Stock	53.125	53.5	52.9375	52.9688	8163800.0
2000-01-20 16:00:00	MSFT	Stock	53.0312	53.0312	52.9688	53.0	110600.0
2000-01-20 09:00:00	NVDA	Stock	0.0953	0.0992	0.0948	0.099	26256000.0
2000-01-20 10:00:00	NVDA	Stock	0.0992	0.1005	0.098	0.0995	24960000.0
2000-01-20 11:00:00	NVDA	Stock	0.0999	0.1005	0.0993	0.0995	19920000.0
2000-01-20 12:00:00	NVDA	Stock	0.0997	0.0997	0.0948	0.0958	56736000.0
2000-01-20 13:00:00	NVDA	Stock	0.0958	0.0958	0.0948	0.0956	12480000.0
2000-01-20 14:00:00	NVDA	Stock	0.0956	0.0958	0.0952	0.0956	17472000.0
2000-01-20 15:00:00	NVDA	Stock	0.0956	0.0958	0.0935	0.0943	16464000.0
2000-01-20 09:00:00	AMZN	Stock	3.3469	3.35	3.2562	3.2688	16870000.0
2000-01-20 10:00:00	AMZN	Stock	3.2688	3.2906	3.25	3.275	17890000.0
2000-01-20 11:00:00	AMZN	Stock	3.275	3.2844	3.25	3.2531	20924000.0
2000-01-20 12:00:00	AMZN	Stock	3.2531	3.2625	3.1969	3.2	23020000.0
2000-01-20 13:00:00	AMZN	Stock	3.2063	3.2469	3.2	3.2375	8196000.0
2000-01-20 14:00:00	AMZN	Stock	3.2344	3.2875	3.2312	3.2688	12186000.0
2000-01-20 15:00:00	AMZN	Stock	3.2688	3.2781	3.2375	3.2438	15798000.0
2000-01-20 16:00:00	AMZN	Stock	3.2406	3.2406	3.2375	3.2375	590000.0
2000-01-20 09:00:00	CL	Stock	30.6875	30.8125	30.25	30.75	220400.0
2000-01-20 10:00:00	CL	Stock	30.7188	31.6875	30.7188	31.375	750200.0
2000-01-20 11:00:00	CL	Stock	31.375	31.5	31.2188	31.3125	343800.0
2000-01-20 12:00:00	CL	Stock	31.3125	31.3125	30.75	30.8438	257400.0
2000-01-20 13:00:00	CL	Stock	30.875	31.125	30.5625	31.125	281400.0
2000-01-20 14:00:00	CL	Stock	31.125	31.875	31.0625	31.625	337200.0
2000-01-20 15:00:00	CL	Stock	31.5938	31.625	30.875	30.9688	795400.0
2000-01-20 16:00:00	CL	Stock	30.9688	30.9688	30.9688	30.9688	59800.0

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

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