PREVIEW / stock_1hour / 2000-06-12

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-06-12.parquet
  size:    294 KB
  rows:    15,205
  symbols: 1,171

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-12 08:00:00	AAPL	Stock	0.8588	0.8588	0.8588	0.8588	11200.0
2000-06-12 09:00:00	AAPL	Stock	0.8588	0.861	0.8438	0.8482	29758400.0
2000-06-12 10:00:00	AAPL	Stock	0.8482	0.851	0.827	0.8348	52068800.0
2000-06-12 11:00:00	AAPL	Stock	0.8337	0.8343	0.8237	0.8259	29982400.0
2000-06-12 12:00:00	AAPL	Stock	0.8259	0.8337	0.822	0.8304	27126400.0
2000-06-12 13:00:00	AAPL	Stock	0.8309	0.8309	0.8214	0.827	38584000.0
2000-06-12 14:00:00	AAPL	Stock	0.8248	0.8281	0.8131	0.8186	38236800.0
2000-06-12 15:00:00	AAPL	Stock	0.8181	0.827	0.8114	0.8147	62260800.0
2000-06-12 16:00:00	AAPL	Stock	0.8147	0.8214	0.8142	0.8192	9598400.0
2000-06-12 17:00:00	AAPL	Stock	0.8192	0.8192	0.8142	0.8142	369600.0
2000-06-12 18:00:00	AAPL	Stock	0.8237	0.8237	0.8237	0.8237	11200.0
2000-06-12 08:00:00	MSFT	Stock	34.5	34.5	34.375	34.375	4000.0
2000-06-12 09:00:00	MSFT	Stock	34.4688	34.5	33.75	33.7812	9451400.0
2000-06-12 10:00:00	MSFT	Stock	33.7812	33.8438	33.4062	33.5312	10591200.0
2000-06-12 11:00:00	MSFT	Stock	33.5	33.5938	33.1875	33.375	6748000.0
2000-06-12 12:00:00	MSFT	Stock	33.375	33.5	33.25	33.5	4102800.0
2000-06-12 13:00:00	MSFT	Stock	33.4688	33.5625	33.1875	33.2812	4644000.0
2000-06-12 14:00:00	MSFT	Stock	33.25	33.4375	33.2188	33.3438	4489400.0
2000-06-12 15:00:00	MSFT	Stock	33.3438	33.5312	33.25	33.4688	7021000.0
2000-06-12 16:00:00	MSFT	Stock	33.4688	33.9219	33.375	33.5312	1666800.0
2000-06-12 17:00:00	MSFT	Stock	33.4062	33.5312	33.4062	33.4062	115200.0
2000-06-12 18:00:00	MSFT	Stock	33.5312	33.5312	33.4375	33.4375	600.0
2000-06-12 09:00:00	NVDA	Stock	0.2646	0.2668	0.2583	0.2637	56736000.0
2000-06-12 10:00:00	NVDA	Stock	0.2641	0.2647	0.2604	0.2612	66288000.0
2000-06-12 11:00:00	NVDA	Stock	0.2613	0.2624	0.2505	0.2539	95328000.0
2000-06-12 12:00:00	NVDA	Stock	0.2544	0.2557	0.2518	0.2555	28128000.0
2000-06-12 13:00:00	NVDA	Stock	0.2557	0.2562	0.2512	0.2526	35520000.0
2000-06-12 14:00:00	NVDA	Stock	0.2523	0.2531	0.251	0.2526	27744000.0
2000-06-12 15:00:00	NVDA	Stock	0.2526	0.2595	0.251	0.2562	51072000.0
2000-06-12 16:00:00	NVDA	Stock	0.2561	0.2594	0.2555	0.2594	10080000.0
2000-06-12 17:00:00	NVDA	Stock	0.2594	0.2594	0.2594	0.2594	48000.0
2000-06-12 09:00:00	AMZN	Stock	2.625	2.6312	2.525	2.5406	7278000.0
2000-06-12 10:00:00	AMZN	Stock	2.5406	2.5563	2.4938	2.5125	12404000.0
2000-06-12 11:00:00	AMZN	Stock	2.5062	2.5125	2.4406	2.4438	8572000.0
2000-06-12 12:00:00	AMZN	Stock	2.4438	2.4438	2.4	2.4375	10090000.0
2000-06-12 13:00:00	AMZN	Stock	2.4375	2.4563	2.425	2.425	6956000.0
2000-06-12 14:00:00	AMZN	Stock	2.425	2.4438	2.4062	2.425	7514000.0
2000-06-12 15:00:00	AMZN	Stock	2.4219	2.4375	2.3688	2.4188	24304000.0
2000-06-12 16:00:00	AMZN	Stock	2.4156	2.4219	2.375	2.375	2120000.0
2000-06-12 17:00:00	AMZN	Stock	2.3875	2.4219	2.3688	2.3875	134000.0
2000-06-12 09:00:00	CL	Stock	28.5	29.2812	28.5	29.25	247200.0
2000-06-12 10:00:00	CL	Stock	29.25	29.2812	29.0312	29.0938	287400.0
2000-06-12 11:00:00	CL	Stock	29.0625	29.0938	29.0	29.0625	175000.0
2000-06-12 12:00:00	CL	Stock	29.0312	29.0938	29.0	29.0625	197000.0
2000-06-12 13:00:00	CL	Stock	29.0312	29.0469	28.75	28.8438	214200.0
2000-06-12 14:00:00	CL	Stock	28.8438	28.9375	28.75	28.9062	164000.0
2000-06-12 15:00:00	CL	Stock	28.9375	29.0	28.6875	28.7188	517200.0
2000-06-12 16:00:00	CL	Stock	28.75	28.75	28.7188	28.7188	32000.0
2000-06-12 17:00:00	CL	Stock	28.7188	28.7188	28.7188	28.7188	8000.0
2000-06-12 18:00:00	CL	Stock	28.7188	28.7188	28.7188	28.7188	200.0

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

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