PREVIEW / stock_1hour / 2000-08-23

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-08-23.parquet
  size:    296 KB
  rows:    15,293
  symbols: 1,213

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-08-23 08:00:00	AAPL	Stock	0.9236	0.9236	0.9129	0.9129	543200.0
2000-08-23 09:00:00	AAPL	Stock	0.9129	0.9286	0.9129	0.9196	19174400.0
2000-08-23 10:00:00	AAPL	Stock	0.9208	0.9297	0.9118	0.9252	38304000.0
2000-08-23 11:00:00	AAPL	Stock	0.9263	0.9475	0.9252	0.9431	28806400.0
2000-08-23 12:00:00	AAPL	Stock	0.9431	0.9442	0.9386	0.9431	14778400.0
2000-08-23 13:00:00	AAPL	Stock	0.9442	0.9554	0.942	0.942	15713600.0
2000-08-23 14:00:00	AAPL	Stock	0.942	0.9654	0.942	0.9587	41552000.0
2000-08-23 15:00:00	AAPL	Stock	0.9587	0.9777	0.9576	0.971	72357600.0
2000-08-23 16:00:00	AAPL	Stock	0.971	0.9721	0.9643	0.9643	3124800.0
2000-08-23 17:00:00	AAPL	Stock	0.9643	0.9643	0.9643	0.9643	5600.0
2000-08-23 08:00:00	MSFT	Stock	35.6406	35.75	35.3438	35.5	1000400.0
2000-08-23 09:00:00	MSFT	Stock	35.5	35.5	35.2188	35.2812	5723200.0
2000-08-23 10:00:00	MSFT	Stock	35.2812	35.4688	35.1875	35.4062	6527800.0
2000-08-23 11:00:00	MSFT	Stock	35.4062	35.5625	35.3125	35.3438	3852600.0
2000-08-23 12:00:00	MSFT	Stock	35.375	35.4375	35.25	35.2812	3486400.0
2000-08-23 13:00:00	MSFT	Stock	35.3125	35.4062	35.2812	35.375	4463000.0
2000-08-23 14:00:00	MSFT	Stock	35.375	35.4375	35.25	35.375	4089000.0
2000-08-23 15:00:00	MSFT	Stock	35.4062	35.5	35.25	35.4062	6264800.0
2000-08-23 16:00:00	MSFT	Stock	35.375	35.4688	35.3125	35.3125	927400.0
2000-08-23 17:00:00	MSFT	Stock	35.3125	35.375	35.3125	35.375	2400.0
2000-08-23 18:00:00	MSFT	Stock	35.375	35.375	35.3125	35.3125	2200.0
2000-08-23 08:00:00	NVDA	Stock	0.2883	0.2922	0.2883	0.2922	408000.0
2000-08-23 09:00:00	NVDA	Stock	0.2922	0.3021	0.2844	0.2995	84408000.0
2000-08-23 10:00:00	NVDA	Stock	0.3003	0.3042	0.2969	0.3021	68520000.0
2000-08-23 11:00:00	NVDA	Stock	0.302	0.3104	0.3009	0.3049	54264000.0
2000-08-23 12:00:00	NVDA	Stock	0.3049	0.3081	0.3039	0.3078	16080000.0
2000-08-23 13:00:00	NVDA	Stock	0.3068	0.3122	0.3068	0.312	36120000.0
2000-08-23 14:00:00	NVDA	Stock	0.3118	0.3128	0.3086	0.312	38448000.0
2000-08-23 15:00:00	NVDA	Stock	0.312	0.3128	0.3086	0.312	48984000.0
2000-08-23 16:00:00	NVDA	Stock	0.3122	0.3125	0.3104	0.3122	3624000.0
2000-08-23 17:00:00	NVDA	Stock	0.3125	0.3125	0.3104	0.3104	192000.0
2000-08-23 18:00:00	NVDA	Stock	0.3104	0.3104	0.3104	0.3104	144000.0
2000-08-23 08:00:00	AMZN	Stock	1.8125	1.8125	1.775	1.8016	58000.0
2000-08-23 09:00:00	AMZN	Stock	1.8016	1.8219	1.775	1.7875	10644000.0
2000-08-23 10:00:00	AMZN	Stock	1.7906	1.825	1.775	1.825	9696000.0
2000-08-23 11:00:00	AMZN	Stock	1.825	1.8312	1.8156	1.8281	13028000.0
2000-08-23 12:00:00	AMZN	Stock	1.825	1.825	1.8062	1.8156	3192000.0
2000-08-23 13:00:00	AMZN	Stock	1.8156	1.9	1.8125	1.8906	13476000.0
2000-08-23 14:00:00	AMZN	Stock	1.8906	1.9438	1.8781	1.9438	20762000.0
2000-08-23 15:00:00	AMZN	Stock	1.9438	1.975	1.925	1.9438	22012000.0
2000-08-23 16:00:00	AMZN	Stock	1.9406	1.95	1.8203	1.9438	1104000.0
2000-08-23 17:00:00	AMZN	Stock	1.9406	1.9438	1.9375	1.9375	14000.0
2000-08-23 18:00:00	AMZN	Stock	1.95	1.95	1.9406	1.9406	12000.0
2000-08-23 09:00:00	CL	Stock	26.0	26.5	26.0	26.375	1266200.0
2000-08-23 10:00:00	CL	Stock	26.375	26.4062	26.0625	26.2188	1050400.0
2000-08-23 11:00:00	CL	Stock	26.2188	26.2812	26.1562	26.2188	378200.0
2000-08-23 12:00:00	CL	Stock	26.25	26.375	26.1875	26.3125	191000.0
2000-08-23 13:00:00	CL	Stock	26.3125	26.375	26.2188	26.3438	196800.0
2000-08-23 14:00:00	CL	Stock	26.375	26.4688	26.3125	26.4062	275800.0
2000-08-23 15:00:00	CL	Stock	26.4062	26.6875	26.3438	26.5625	588800.0

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

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