PREVIEW / stock_1hour / 2000-01-24

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-01-24.parquet
  size:    283 KB
  rows:    14,583
  symbols: 1,129

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-24 09:00:00	AAPL	Stock	0.9682	0.9933	0.9643	0.9844	44027200.0
2000-01-24 10:00:00	AAPL	Stock	0.9844	1.0067	0.9788	0.9821	87192000.0
2000-01-24 11:00:00	AAPL	Stock	0.9816	0.9877	0.9777	0.9833	58172800.0
2000-01-24 12:00:00	AAPL	Stock	0.9821	0.9944	0.9816	0.9922	34832000.0
2000-01-24 13:00:00	AAPL	Stock	0.9911	0.9911	0.9688	0.9766	28996800.0
2000-01-24 14:00:00	AAPL	Stock	0.9749	0.9766	0.952	0.9542	58979200.0
2000-01-24 15:00:00	AAPL	Stock	0.9542	0.9676	0.9386	0.9489	86979200.0
2000-01-24 16:00:00	AAPL	Stock	0.9487	0.9492	0.9487	0.9487	1355200.0
2000-01-24 09:00:00	MSFT	Stock	51.8906	52.2812	51.375	51.6875	9176000.0
2000-01-24 10:00:00	MSFT	Stock	51.6875	52.625	51.5312	52.1875	10482000.0
2000-01-24 11:00:00	MSFT	Stock	52.1875	52.8438	52.1562	52.5938	7176600.0
2000-01-24 12:00:00	MSFT	Stock	52.5625	52.8125	52.1875	52.2188	4038400.0
2000-01-24 13:00:00	MSFT	Stock	52.2188	52.4375	51.5625	51.8125	5763200.0
2000-01-24 14:00:00	MSFT	Stock	51.9062	52.0	50.6562	50.7188	9905400.0
2000-01-24 15:00:00	MSFT	Stock	50.6875	51.6875	50.4062	50.625	12164600.0
2000-01-24 16:00:00	MSFT	Stock	50.6562	50.6562	50.625	50.625	155600.0
2000-01-24 09:00:00	NVDA	Stock	0.0962	0.0962	0.0937	0.0937	25344000.0
2000-01-24 10:00:00	NVDA	Stock	0.0937	0.0937	0.0917	0.0922	26592000.0
2000-01-24 11:00:00	NVDA	Stock	0.0922	0.0927	0.0911	0.0917	42144000.0
2000-01-24 12:00:00	NVDA	Stock	0.0914	0.0917	0.0909	0.0915	18048000.0
2000-01-24 13:00:00	NVDA	Stock	0.0915	0.0935	0.0914	0.0927	45792000.0
2000-01-24 14:00:00	NVDA	Stock	0.0935	0.0935	0.0927	0.0927	11520000.0
2000-01-24 15:00:00	NVDA	Stock	0.0927	0.0928	0.0885	0.0891	65520000.0
2000-01-24 16:00:00	NVDA	Stock	0.0891	0.0891	0.0891	0.0891	1776000.0
2000-01-24 09:00:00	AMZN	Stock	3.3781	3.55	3.375	3.5172	98370000.0
2000-01-24 10:00:00	AMZN	Stock	3.5172	3.6688	3.5	3.5281	158378000.0
2000-01-24 11:00:00	AMZN	Stock	3.5297	3.6094	3.5094	3.55	57428000.0
2000-01-24 12:00:00	AMZN	Stock	3.55	3.5938	3.5281	3.5875	17102000.0
2000-01-24 13:00:00	AMZN	Stock	3.5875	3.65	3.575	3.6	50530000.0
2000-01-24 14:00:00	AMZN	Stock	3.6	3.6125	3.5	3.5062	50530000.0
2000-01-24 15:00:00	AMZN	Stock	3.5062	3.5375	3.4	3.5188	90774000.0
2000-01-24 16:00:00	AMZN	Stock	3.525	3.525	3.5062	3.5062	340000.0
2000-01-24 09:00:00	CL	Stock	31.375	31.375	31.0625	31.0938	567200.0
2000-01-24 10:00:00	CL	Stock	31.0625	31.5	31.0625	31.3125	492400.0
2000-01-24 11:00:00	CL	Stock	31.3125	31.375	30.8125	30.875	445400.0
2000-01-24 12:00:00	CL	Stock	30.875	31.4375	30.8125	31.1562	412400.0
2000-01-24 13:00:00	CL	Stock	31.1562	31.2812	30.75	30.9375	287800.0
2000-01-24 14:00:00	CL	Stock	31.0	31.0312	30.5	30.5312	264200.0
2000-01-24 15:00:00	CL	Stock	30.5625	30.7812	30.25	30.3125	493800.0
2000-01-24 16:00:00	CL	Stock	30.3438	30.3438	30.3438	30.3438	43200.0

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

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