PREVIEW / stock_1hour / 2000-01-28

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-01-28.parquet
  size:    272 KB
  rows:    14,100
  symbols: 1,123

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-28 09:00:00	AAPL	Stock	0.966	0.99	0.9643	0.9855	36993600.0
2000-01-28 10:00:00	AAPL	Stock	0.9855	0.9872	0.9576	0.9609	50769600.0
2000-01-28 11:00:00	AAPL	Stock	0.9615	0.9643	0.9475	0.952	44027200.0
2000-01-28 12:00:00	AAPL	Stock	0.952	0.9554	0.9347	0.9397	45281600.0
2000-01-28 13:00:00	AAPL	Stock	0.9392	0.9403	0.9263	0.9353	58811200.0
2000-01-28 14:00:00	AAPL	Stock	0.935	0.9353	0.9018	0.9079	66281600.0
2000-01-28 15:00:00	AAPL	Stock	0.909	0.9174	0.8984	0.9079	101796800.0
2000-01-28 16:00:00	AAPL	Stock	0.9079	0.9079	0.9074	0.9074	1108800.0
2000-01-28 09:00:00	MSFT	Stock	49.0625	49.9062	49.0	49.8125	6733400.0
2000-01-28 10:00:00	MSFT	Stock	49.75	50.125	49.0625	49.3125	11160400.0
2000-01-28 11:00:00	MSFT	Stock	49.3438	49.7812	49.125	49.4375	7693600.0
2000-01-28 12:00:00	MSFT	Stock	49.4688	49.5	48.8438	48.875	6387800.0
2000-01-28 13:00:00	MSFT	Stock	48.875	49.625	48.625	49.4062	6430800.0
2000-01-28 14:00:00	MSFT	Stock	49.375	49.75	49.1562	49.375	5545200.0
2000-01-28 15:00:00	MSFT	Stock	49.375	49.4688	48.625	49.1562	10095000.0
2000-01-28 16:00:00	MSFT	Stock	49.125	49.25	49.125	49.125	691800.0
2000-01-28 09:00:00	NVDA	Stock	0.0792	0.0797	0.0773	0.0779	14160000.0
2000-01-28 10:00:00	NVDA	Stock	0.0777	0.0789	0.0771	0.0786	25536000.0
2000-01-28 11:00:00	NVDA	Stock	0.0786	0.0786	0.0771	0.0779	36768000.0
2000-01-28 12:00:00	NVDA	Stock	0.0771	0.0781	0.0747	0.0779	38640000.0
2000-01-28 13:00:00	NVDA	Stock	0.0779	0.0781	0.0758	0.0771	16608000.0
2000-01-28 14:00:00	NVDA	Stock	0.0771	0.0781	0.0771	0.0779	20016000.0
2000-01-28 15:00:00	NVDA	Stock	0.0779	0.0781	0.0757	0.0779	33168000.0
2000-01-28 09:00:00	AMZN	Stock	3.25	3.3219	3.25	3.2969	12412000.0
2000-01-28 10:00:00	AMZN	Stock	3.2969	3.3062	3.1375	3.1406	34700000.0
2000-01-28 11:00:00	AMZN	Stock	3.1438	3.1625	3.0062	3.05	65152000.0
2000-01-28 12:00:00	AMZN	Stock	3.0469	3.0625	3.0	3.0312	49350000.0
2000-01-28 13:00:00	AMZN	Stock	3.0344	3.0938	3.0094	3.0813	31200000.0
2000-01-28 14:00:00	AMZN	Stock	3.0781	3.1875	3.0375	3.1031	38170000.0
2000-01-28 15:00:00	AMZN	Stock	3.1062	3.1344	3.0281	3.0781	33718000.0
2000-01-28 16:00:00	AMZN	Stock	3.0813	3.0875	3.0813	3.0844	302000.0
2000-01-28 09:00:00	CL	Stock	30.2812	30.4375	29.875	30.0	237400.0
2000-01-28 10:00:00	CL	Stock	29.9375	29.9375	29.25	29.375	356600.0
2000-01-28 11:00:00	CL	Stock	29.375	30.2188	29.2812	29.9375	479400.0
2000-01-28 12:00:00	CL	Stock	29.9375	30.5625	29.6875	30.0938	419200.0
2000-01-28 13:00:00	CL	Stock	30.0938	30.1562	29.6875	29.7812	630200.0
2000-01-28 14:00:00	CL	Stock	29.75	29.8125	29.5312	29.625	535400.0
2000-01-28 15:00:00	CL	Stock	29.6875	29.75	29.5	29.75	309200.0
2000-01-28 16:00:00	CL	Stock	29.7812	29.7812	29.75	29.75	112400.0

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

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