PREVIEW / stock_1hour / 2000-07-24

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-07-24.parquet
  size:    298 KB
  rows:    15,332
  symbols: 1,197

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-24 08:00:00	AAPL	Stock	0.9565	0.9565	0.9554	0.9554	140000.0
2000-07-24 09:00:00	AAPL	Stock	0.9576	0.9587	0.9275	0.933	31343200.0
2000-07-24 10:00:00	AAPL	Stock	0.9308	0.942	0.9275	0.9308	46799200.0
2000-07-24 11:00:00	AAPL	Stock	0.9308	0.9308	0.8996	0.9018	54521600.0
2000-07-24 12:00:00	AAPL	Stock	0.9018	0.9018	0.885	0.8973	68073600.0
2000-07-24 13:00:00	AAPL	Stock	0.8984	0.904	0.8895	0.8895	27238400.0
2000-07-24 14:00:00	AAPL	Stock	0.8895	0.8906	0.8571	0.8661	84028000.0
2000-07-24 15:00:00	AAPL	Stock	0.8661	0.8828	0.8504	0.8683	69406400.0
2000-07-24 16:00:00	AAPL	Stock	0.8694	0.8828	0.8683	0.8694	10718400.0
2000-07-24 17:00:00	AAPL	Stock	0.8694	0.8817	0.8694	0.8795	352800.0
2000-07-24 18:00:00	AAPL	Stock	0.8795	0.8817	0.8795	0.8795	67200.0
2000-07-24 08:00:00	MSFT	Stock	36.0625	36.2812	36.0625	36.0938	31600.0
2000-07-24 09:00:00	MSFT	Stock	36.0625	36.125	35.625	35.7812	6422600.0
2000-07-24 10:00:00	MSFT	Stock	35.7812	35.8438	35.4688	35.5312	9927600.0
2000-07-24 11:00:00	MSFT	Stock	35.5312	35.5625	35.3438	35.4375	5542400.0
2000-07-24 12:00:00	MSFT	Stock	35.4688	35.4688	35.0625	35.1875	7516800.0
2000-07-24 13:00:00	MSFT	Stock	35.2188	35.2188	35.0	35.125	6672800.0
2000-07-24 14:00:00	MSFT	Stock	35.125	35.4375	35.0312	35.1562	7346600.0
2000-07-24 15:00:00	MSFT	Stock	35.1562	35.5625	35.0625	35.3125	10716400.0
2000-07-24 16:00:00	MSFT	Stock	35.3125	35.5	35.0938	35.375	1308200.0
2000-07-24 17:00:00	MSFT	Stock	35.375	35.5	35.2812	35.375	175000.0
2000-07-24 18:00:00	MSFT	Stock	35.375	35.375	35.3125	35.3125	600.0
2000-07-24 09:00:00	NVDA	Stock	0.2904	0.2927	0.2865	0.2896	23952000.0
2000-07-24 10:00:00	NVDA	Stock	0.2891	0.2906	0.2854	0.2854	20472000.0
2000-07-24 11:00:00	NVDA	Stock	0.2854	0.2854	0.2802	0.281	14064000.0
2000-07-24 12:00:00	NVDA	Stock	0.2807	0.2823	0.2594	0.2633	48072000.0
2000-07-24 13:00:00	NVDA	Stock	0.2625	0.2708	0.2596	0.2635	42096000.0
2000-07-24 14:00:00	NVDA	Stock	0.2635	0.2646	0.2594	0.2615	44208000.0
2000-07-24 15:00:00	NVDA	Stock	0.2615	0.2674	0.2542	0.2659	78720000.0
2000-07-24 16:00:00	NVDA	Stock	0.2659	0.2661	0.2594	0.2656	2616000.0
2000-07-24 17:00:00	NVDA	Stock	0.2625	0.2659	0.2625	0.2659	144000.0
2000-07-24 18:00:00	NVDA	Stock	0.2656	0.2656	0.2656	0.2656	24000.0
2000-07-24 08:00:00	AMZN	Stock	2.05	2.0625	2.05	2.0562	92000.0
2000-07-24 09:00:00	AMZN	Stock	2.05	2.0813	2.0062	2.0188	15332000.0
2000-07-24 10:00:00	AMZN	Stock	2.0188	2.0562	2.0125	2.0406	14674000.0
2000-07-24 11:00:00	AMZN	Stock	2.0438	2.0688	2.025	2.0438	7730000.0
2000-07-24 12:00:00	AMZN	Stock	2.0438	2.0469	2.0	2.0	13366000.0
2000-07-24 13:00:00	AMZN	Stock	2.0	2.0062	1.9812	1.9938	15082000.0
2000-07-24 14:00:00	AMZN	Stock	1.9938	2.0	1.9594	1.9594	15370000.0
2000-07-24 15:00:00	AMZN	Stock	1.9594	1.9625	1.9031	1.9375	28410000.0
2000-07-24 16:00:00	AMZN	Stock	1.9438	1.9625	1.925	1.9438	4446000.0
2000-07-24 17:00:00	AMZN	Stock	1.9312	1.9375	1.9312	1.9312	56000.0
2000-07-24 18:00:00	AMZN	Stock	1.95	1.95	1.95	1.95	2000.0
2000-07-24 09:00:00	CL	Stock	28.2812	28.4688	28.2812	28.4062	297000.0
2000-07-24 10:00:00	CL	Stock	28.4062	28.4062	28.0625	28.0938	364400.0
2000-07-24 11:00:00	CL	Stock	28.0625	28.1875	27.875	28.1562	400400.0
2000-07-24 12:00:00	CL	Stock	28.125	28.25	27.9375	27.9688	246200.0
2000-07-24 13:00:00	CL	Stock	28.0	28.0	27.8125	27.9062	205200.0
2000-07-24 14:00:00	CL	Stock	27.8125	28.1562	27.8125	28.125	274800.0
2000-07-24 15:00:00	CL	Stock	28.125	28.125	27.9375	28.0	355600.0

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

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