PREVIEW / stock_1hour / 2000-01-06

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-01-06.parquet
  size:    276 KB
  rows:    14,164
  symbols: 1,119

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-06 09:00:00	AAPL	Stock	0.9475	0.9554	0.9152	0.9152	101169600.0
2000-01-06 10:00:00	AAPL	Stock	0.9152	0.923	0.8839	0.8962	169780800.0
2000-01-06 11:00:00	AAPL	Stock	0.8962	0.8962	0.885	0.8895	90720000.0
2000-01-06 12:00:00	AAPL	Stock	0.8884	0.9063	0.8884	0.904	66808000.0
2000-01-06 13:00:00	AAPL	Stock	0.9051	0.9051	0.8917	0.8929	42481600.0
2000-01-06 14:00:00	AAPL	Stock	0.894	0.894	0.875	0.8806	71400000.0
2000-01-06 15:00:00	AAPL	Stock	0.8806	0.8834	0.8482	0.8485	181697600.0
2000-01-06 16:00:00	AAPL	Stock	0.8488	0.8488	0.8482	0.8482	1881600.0
2000-01-06 09:00:00	MSFT	Stock	56.0938	56.9375	56.0	56.125	6126800.0
2000-01-06 10:00:00	MSFT	Stock	56.0625	56.5469	55.7812	56.2812	7475400.0
2000-01-06 11:00:00	MSFT	Stock	56.2812	56.4062	55.8125	55.9375	3759400.0
2000-01-06 12:00:00	MSFT	Stock	55.9531	56.125	55.7188	56.0312	3282600.0
2000-01-06 13:00:00	MSFT	Stock	56.0312	56.1562	55.5	55.7188	3568000.0
2000-01-06 14:00:00	MSFT	Stock	55.75	55.75	54.9688	55.25	6768800.0
2000-01-06 15:00:00	MSFT	Stock	55.2812	55.875	54.1875	54.9688	18316000.0
2000-01-06 16:00:00	MSFT	Stock	55.0	55.0	54.9688	55.0	455000.0
2000-01-06 09:00:00	NVDA	Stock	0.0918	0.0918	0.0901	0.091	6816000.0
2000-01-06 10:00:00	NVDA	Stock	0.0909	0.091	0.0823	0.087	44304000.0
2000-01-06 11:00:00	NVDA	Stock	0.0872	0.0875	0.0861	0.087	9936000.0
2000-01-06 12:00:00	NVDA	Stock	0.0871	0.0875	0.0865	0.0867	13584000.0
2000-01-06 13:00:00	NVDA	Stock	0.0867	0.0875	0.0865	0.0875	8112000.0
2000-01-06 14:00:00	NVDA	Stock	0.0871	0.0875	0.0858	0.0861	9024000.0
2000-01-06 15:00:00	NVDA	Stock	0.0862	0.0862	0.0844	0.0859	22272000.0
2000-01-06 16:00:00	NVDA	Stock	0.0859	0.0859	0.0858	0.0858	1920000.0
2000-01-06 09:00:00	AMZN	Stock	3.5656	3.6344	3.45	3.4812	65618000.0
2000-01-06 10:00:00	AMZN	Stock	3.5	3.5562	3.3469	3.3625	72962000.0
2000-01-06 11:00:00	AMZN	Stock	3.3625	3.4	3.3469	3.3781	24820000.0
2000-01-06 12:00:00	AMZN	Stock	3.3781	3.425	3.3281	3.4219	33910000.0
2000-01-06 13:00:00	AMZN	Stock	3.425	3.425	3.3625	3.3719	23170000.0
2000-01-06 14:00:00	AMZN	Stock	3.3719	3.3812	3.2625	3.2688	47414000.0
2000-01-06 15:00:00	AMZN	Stock	3.2656	3.3625	3.2469	3.275	79482000.0
2000-01-06 16:00:00	AMZN	Stock	3.2781	3.2812	3.275	3.2781	278000.0
2000-01-06 09:00:00	CL	Stock	29.0	29.4688	29.0	29.4062	261200.0
2000-01-06 10:00:00	CL	Stock	29.375	30.0	29.375	29.75	1045600.0
2000-01-06 11:00:00	CL	Stock	29.75	30.0	29.625	29.8125	386000.0
2000-01-06 12:00:00	CL	Stock	29.8125	29.8125	28.9375	29.1562	628000.0
2000-01-06 13:00:00	CL	Stock	29.1875	29.5	29.0	29.5	593400.0
2000-01-06 14:00:00	CL	Stock	29.5	29.75	29.5	29.5	1090000.0
2000-01-06 15:00:00	CL	Stock	29.5	29.5625	29.0312	29.2188	1638400.0
2000-01-06 16:00:00	CL	Stock	29.2188	29.2188	29.2188	29.2188	132400.0

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

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