PREVIEW / stock_1hour / 2000-06-29

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-06-29.parquet
  size:    301 KB
  rows:    15,618
  symbols: 1,189

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-06-29 08:00:00	AAPL	Stock	0.9721	0.9721	0.9721	0.9721	39200.0
2000-06-29 09:00:00	AAPL	Stock	0.9554	0.9632	0.9386	0.9475	28761600.0
2000-06-29 10:00:00	AAPL	Stock	0.9464	0.9576	0.9196	0.9353	42498400.0
2000-06-29 11:00:00	AAPL	Stock	0.9342	0.9386	0.9196	0.9297	16469600.0
2000-06-29 12:00:00	AAPL	Stock	0.9297	0.9319	0.9208	0.9275	13876800.0
2000-06-29 13:00:00	AAPL	Stock	0.9275	0.9397	0.923	0.9353	12751200.0
2000-06-29 14:00:00	AAPL	Stock	0.9353	0.952	0.9196	0.9208	27232800.0
2000-06-29 15:00:00	AAPL	Stock	0.9219	0.9442	0.9118	0.9163	54012000.0
2000-06-29 16:00:00	AAPL	Stock	0.9163	0.9241	0.9152	0.9196	5303200.0
2000-06-29 17:00:00	AAPL	Stock	0.9152	0.9286	0.9152	0.9286	117600.0
2000-06-29 18:00:00	AAPL	Stock	0.9263	0.9286	0.9263	0.9286	117600.0
2000-06-29 08:00:00	MSFT	Stock	39.5	39.5	39.0	39.125	40600.0
2000-06-29 09:00:00	MSFT	Stock	39.2188	39.4688	38.9062	39.3125	5450000.0
2000-06-29 10:00:00	MSFT	Stock	39.3438	39.375	38.7812	39.125	6412800.0
2000-06-29 11:00:00	MSFT	Stock	39.0938	39.1562	38.5625	38.8125	6467800.0
2000-06-29 12:00:00	MSFT	Stock	38.8438	39.0938	38.75	39.0	3838000.0
2000-06-29 13:00:00	MSFT	Stock	38.9688	39.125	38.8125	39.0	2286000.0
2000-06-29 14:00:00	MSFT	Stock	39.0	39.375	39.0	39.0938	4420000.0
2000-06-29 15:00:00	MSFT	Stock	39.0938	39.25	38.5625	38.5625	6745800.0
2000-06-29 16:00:00	MSFT	Stock	38.5625	39.0938	38.5156	38.5938	2284400.0
2000-06-29 17:00:00	MSFT	Stock	38.8125	38.8125	38.75	38.8125	1600.0
2000-06-29 18:00:00	MSFT	Stock	38.75	38.75	38.75	38.75	400.0
2000-06-29 08:00:00	NVDA	Stock	0.2906	0.2906	0.2849	0.2854	360000.0
2000-06-29 09:00:00	NVDA	Stock	0.2854	0.2865	0.2625	0.2745	117720000.0
2000-06-29 10:00:00	NVDA	Stock	0.2745	0.2745	0.2536	0.2583	175344000.0
2000-06-29 11:00:00	NVDA	Stock	0.2583	0.2602	0.2479	0.2542	173256000.0
2000-06-29 12:00:00	NVDA	Stock	0.2549	0.2549	0.2477	0.2521	134016000.0
2000-06-29 13:00:00	NVDA	Stock	0.2529	0.2573	0.2505	0.2542	107424000.0
2000-06-29 14:00:00	NVDA	Stock	0.2536	0.2568	0.2417	0.2458	157320000.0
2000-06-29 15:00:00	NVDA	Stock	0.2453	0.251	0.2396	0.2443	268152000.0
2000-06-29 16:00:00	NVDA	Stock	0.2443	0.2469	0.2406	0.2458	6960000.0
2000-06-29 17:00:00	NVDA	Stock	0.2469	0.2474	0.2469	0.2471	216000.0
2000-06-29 18:00:00	NVDA	Stock	0.2469	0.2471	0.2469	0.2469	216000.0
2000-06-29 08:00:00	AMZN	Stock	1.875	1.9	1.825	1.8531	894000.0
2000-06-29 09:00:00	AMZN	Stock	1.8562	1.8969	1.8125	1.8406	34574000.0
2000-06-29 10:00:00	AMZN	Stock	1.8406	1.8656	1.8062	1.8375	35142000.0
2000-06-29 11:00:00	AMZN	Stock	1.8344	1.8562	1.825	1.8375	20024000.0
2000-06-29 12:00:00	AMZN	Stock	1.8375	1.8844	1.8281	1.8656	21336000.0
2000-06-29 13:00:00	AMZN	Stock	1.8656	1.8812	1.85	1.8719	11830000.0
2000-06-29 14:00:00	AMZN	Stock	1.8781	1.925	1.8625	1.8875	28116000.0
2000-06-29 15:00:00	AMZN	Stock	1.9	1.9094	1.8562	1.8562	24262000.0
2000-06-29 16:00:00	AMZN	Stock	1.8656	1.8656	1.825	1.85	1926000.0
2000-06-29 17:00:00	AMZN	Stock	1.8531	1.8875	1.8344	1.8438	44000.0
2000-06-29 18:00:00	AMZN	Stock	1.8359	1.8531	1.8344	1.8531	10000.0
2000-06-29 09:00:00	CL	Stock	28.2812	28.3125	28.125	28.25	267000.0
2000-06-29 10:00:00	CL	Stock	28.25	28.625	28.1875	28.5938	529800.0
2000-06-29 11:00:00	CL	Stock	28.5625	28.625	28.375	28.4062	493800.0
2000-06-29 12:00:00	CL	Stock	28.375	28.4062	28.1875	28.25	419200.0
2000-06-29 13:00:00	CL	Stock	28.25	28.25	28.0312	28.25	216800.0
2000-06-29 14:00:00	CL	Stock	28.25	28.5	28.1875	28.4375	386600.0

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

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