PREVIEW / stock_1hour / 2000-07-20

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-07-20.parquet
  size:    298 KB
  rows:    15,205
  symbols: 1,196

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-07-20 08:00:00	AAPL	Stock	0.9554	0.9754	0.9464	0.9688	504000.0
2000-07-20 09:00:00	AAPL	Stock	0.9688	1.0089	0.9643	0.9922	98952000.0
2000-07-20 10:00:00	AAPL	Stock	0.9933	1.019	0.9922	0.9944	91593600.0
2000-07-20 11:00:00	AAPL	Stock	0.9944	0.9978	0.9766	0.981	82191200.0
2000-07-20 12:00:00	AAPL	Stock	0.9805	0.9855	0.9777	0.9855	35806400.0
2000-07-20 13:00:00	AAPL	Stock	0.9855	0.9877	0.9665	0.9721	43512000.0
2000-07-20 14:00:00	AAPL	Stock	0.9732	0.9866	0.9721	0.9799	35845600.0
2000-07-20 15:00:00	AAPL	Stock	0.9794	0.9911	0.9788	0.9833	44430400.0
2000-07-20 16:00:00	AAPL	Stock	0.9833	0.9955	0.9721	0.9844	3578400.0
2000-07-20 17:00:00	AAPL	Stock	0.9911	0.9933	0.9821	0.9933	884800.0
2000-07-20 18:00:00	AAPL	Stock	0.9833	0.9955	0.9833	0.9955	33600.0
2000-07-20 08:00:00	MSFT	Stock	36.6562	37.25	36.5	36.8125	163000.0
2000-07-20 09:00:00	MSFT	Stock	36.75	36.9688	36.5625	36.9688	8513200.0
2000-07-20 10:00:00	MSFT	Stock	36.9531	37.4375	36.875	37.1875	12338000.0
2000-07-20 11:00:00	MSFT	Stock	37.2188	37.4844	37.125	37.4688	7595800.0
2000-07-20 12:00:00	MSFT	Stock	37.4688	37.5	37.3125	37.3125	5124800.0
2000-07-20 13:00:00	MSFT	Stock	37.3438	37.4688	37.25	37.4062	3213400.0
2000-07-20 14:00:00	MSFT	Stock	37.4062	37.625	37.375	37.4375	8243200.0
2000-07-20 15:00:00	MSFT	Stock	37.5	37.5938	37.1875	37.4062	6605000.0
2000-07-20 16:00:00	MSFT	Stock	37.4062	37.5	36.7344	37.4375	1349400.0
2000-07-20 17:00:00	MSFT	Stock	37.25	37.5	37.25	37.4375	189800.0
2000-07-20 18:00:00	MSFT	Stock	37.4375	37.4375	37.4375	37.4375	800.0
2000-07-20 09:00:00	NVDA	Stock	0.2789	0.2938	0.2781	0.2875	23184000.0
2000-07-20 10:00:00	NVDA	Stock	0.2844	0.2927	0.2844	0.2885	16104000.0
2000-07-20 11:00:00	NVDA	Stock	0.2891	0.2906	0.2833	0.2875	13008000.0
2000-07-20 12:00:00	NVDA	Stock	0.2875	0.2885	0.2852	0.2883	27216000.0
2000-07-20 13:00:00	NVDA	Stock	0.2885	0.2888	0.2849	0.2854	14952000.0
2000-07-20 14:00:00	NVDA	Stock	0.2854	0.2917	0.2854	0.288	11352000.0
2000-07-20 15:00:00	NVDA	Stock	0.2896	0.2901	0.2844	0.2865	31584000.0
2000-07-20 16:00:00	NVDA	Stock	0.2865	0.2875	0.2865	0.2867	2472000.0
2000-07-20 08:00:00	AMZN	Stock	2.0406	2.05	2.0	2.0438	140000.0
2000-07-20 09:00:00	AMZN	Stock	2.05	2.1219	2.0438	2.0969	10528000.0
2000-07-20 10:00:00	AMZN	Stock	2.0969	2.1688	2.0969	2.1469	18084000.0
2000-07-20 11:00:00	AMZN	Stock	2.1469	2.1594	2.1219	2.1469	13868000.0
2000-07-20 12:00:00	AMZN	Stock	2.15	2.1562	2.1406	2.1469	8640000.0
2000-07-20 13:00:00	AMZN	Stock	2.1469	2.15	2.1062	2.1188	8756000.0
2000-07-20 14:00:00	AMZN	Stock	2.1188	2.1281	2.05	2.0562	24766000.0
2000-07-20 15:00:00	AMZN	Stock	2.0562	2.0625	1.975	2.0156	46940000.0
2000-07-20 16:00:00	AMZN	Stock	2.0125	2.0188	1.9875	2.0125	3126000.0
2000-07-20 17:00:00	AMZN	Stock	2.0219	2.0234	2.0219	2.0234	26000.0
2000-07-20 18:00:00	AMZN	Stock	2.0375	2.0375	2.0375	2.0375	2000.0
2000-07-20 09:00:00	CL	Stock	27.5625	28.0	27.0	27.0	926800.0
2000-07-20 10:00:00	CL	Stock	27.0312	27.5	27.0	27.4375	819000.0
2000-07-20 11:00:00	CL	Stock	27.4375	27.625	27.4062	27.5	458000.0
2000-07-20 12:00:00	CL	Stock	27.5	27.9688	27.4375	27.7188	761000.0
2000-07-20 13:00:00	CL	Stock	27.6875	27.7188	27.5	27.5312	421600.0
2000-07-20 14:00:00	CL	Stock	27.5312	27.625	27.5	27.5312	470600.0
2000-07-20 15:00:00	CL	Stock	27.5625	27.875	27.5312	27.6875	829800.0
2000-07-20 16:00:00	CL	Stock	27.6875	27.6875	27.6875	27.6875	38800.0
2000-07-20 17:00:00	CL	Stock	27.6875	27.6875	27.6875	27.6875	4000.0

> showing 50 of 15,205 rows — these rows as CSV

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