PREVIEW / stock_1hour / 2000-01-04

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-01-04.parquet
  size:    277 KB
  rows:    14,459
  symbols: 1,131

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-04 09:00:00	AAPL	Stock	0.9665	0.9877	0.9665	0.981	69776000.0
2000-01-04 10:00:00	AAPL	Stock	0.9805	0.981	0.9565	0.9643	86889600.0
2000-01-04 11:00:00	AAPL	Stock	0.964	0.964	0.9381	0.9632	65396800.0
2000-01-04 12:00:00	AAPL	Stock	0.9637	0.9721	0.9542	0.9609	61028800.0
2000-01-04 13:00:00	AAPL	Stock	0.9609	0.9621	0.9291	0.9475	56257600.0
2000-01-04 14:00:00	AAPL	Stock	0.947	0.9643	0.9375	0.9526	43310400.0
2000-01-04 15:00:00	AAPL	Stock	0.9526	0.9531	0.9035	0.9163	96308800.0
2000-01-04 16:00:00	AAPL	Stock	0.9146	0.9152	0.9146	0.9152	1142400.0
2000-01-04 09:00:00	MSFT	Stock	56.7812	58.375	56.75	58.1562	9086800.0
2000-01-04 10:00:00	MSFT	Stock	58.1562	58.1562	57.6875	58.0312	8033600.0
2000-01-04 11:00:00	MSFT	Stock	58.0625	58.5625	57.8125	58.4062	5943400.0
2000-01-04 12:00:00	MSFT	Stock	58.4219	58.4688	57.75	57.7812	5116000.0
2000-01-04 13:00:00	MSFT	Stock	57.7812	57.9375	57.25	57.5625	7661200.0
2000-01-04 14:00:00	MSFT	Stock	57.5312	57.75	57.25	57.375	4623000.0
2000-01-04 15:00:00	MSFT	Stock	57.4062	57.4375	56.125	56.3125	10320200.0
2000-01-04 16:00:00	MSFT	Stock	56.3125	56.4688	56.3125	56.3125	482200.0
2000-01-04 09:00:00	NVDA	Stock	0.0958	0.0961	0.0932	0.0939	46368000.0
2000-01-04 10:00:00	NVDA	Stock	0.094	0.0952	0.094	0.0952	68112000.0
2000-01-04 11:00:00	NVDA	Stock	0.0952	0.0961	0.0944	0.0951	18384000.0
2000-01-04 12:00:00	NVDA	Stock	0.0951	0.0961	0.0943	0.0943	30624000.0
2000-01-04 13:00:00	NVDA	Stock	0.0943	0.0945	0.0901	0.0928	49536000.0
2000-01-04 14:00:00	NVDA	Stock	0.0924	0.0939	0.0917	0.0937	16176000.0
2000-01-04 15:00:00	NVDA	Stock	0.0937	0.0949	0.093	0.0949	60240000.0
2000-01-04 16:00:00	NVDA	Stock	0.0949	0.0949	0.0949	0.0949	1824000.0
2000-01-04 09:00:00	AMZN	Stock	4.2688	4.575	4.25	4.5156	47672000.0
2000-01-04 10:00:00	AMZN	Stock	4.5188	4.5375	4.35	4.475	65208000.0
2000-01-04 11:00:00	AMZN	Stock	4.475	4.5	4.3813	4.425	39406000.0
2000-01-04 12:00:00	AMZN	Stock	4.4219	4.4531	4.4	4.4125	19884000.0
2000-01-04 13:00:00	AMZN	Stock	4.4125	4.4156	4.2312	4.2656	59634000.0
2000-01-04 14:00:00	AMZN	Stock	4.2688	4.2875	4.1875	4.1875	36560000.0
2000-01-04 15:00:00	AMZN	Stock	4.1906	4.2188	4.0875	4.0969	49384000.0
2000-01-04 16:00:00	AMZN	Stock	4.1	4.1	4.0969	4.0969	168000.0
2000-01-04 09:00:00	CL	Stock	30.625	30.8125	30.4062	30.4062	315800.0
2000-01-04 10:00:00	CL	Stock	30.4062	30.75	30.2812	30.3438	400600.0
2000-01-04 11:00:00	CL	Stock	30.2812	30.9688	30.25	30.875	379000.0
2000-01-04 12:00:00	CL	Stock	30.875	30.9375	30.6562	30.6875	244400.0
2000-01-04 13:00:00	CL	Stock	30.6562	30.6875	30.25	30.5312	305000.0
2000-01-04 14:00:00	CL	Stock	30.5625	30.6875	30.4375	30.5	215000.0
2000-01-04 15:00:00	CL	Stock	30.5312	30.5625	30.3125	30.4062	470600.0
2000-01-04 16:00:00	CL	Stock	30.4375	30.4375	30.3125	30.3125	20200.0

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

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