PREVIEW / stock_1hour / 2000-11-01

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-11-01.parquet
  size:    304 KB
  rows:    15,730
  symbols: 1,235

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-11-01 08:00:00	AAPL	Stock	0.3482	0.3488	0.3449	0.3449	3589600.0
2000-11-01 09:00:00	AAPL	Stock	0.3482	0.3594	0.3304	0.3571	48490400.0
2000-11-01 10:00:00	AAPL	Stock	0.3571	0.3705	0.3549	0.3705	144776800.0
2000-11-01 11:00:00	AAPL	Stock	0.3705	0.3728	0.3661	0.3705	92652000.0
2000-11-01 12:00:00	AAPL	Stock	0.3705	0.3705	0.3661	0.3661	49380800.0
2000-11-01 13:00:00	AAPL	Stock	0.3661	0.3694	0.3638	0.3638	34546400.0
2000-11-01 14:00:00	AAPL	Stock	0.365	0.3661	0.3605	0.3616	42705600.0
2000-11-01 15:00:00	AAPL	Stock	0.3616	0.3672	0.3594	0.3661	70660800.0
2000-11-01 16:00:00	AAPL	Stock	0.365	0.3683	0.3627	0.3661	4939200.0
2000-11-01 17:00:00	AAPL	Stock	0.3661	0.3694	0.3661	0.3694	694400.0
2000-11-01 18:00:00	AAPL	Stock	0.3694	0.3694	0.3694	0.3694	196000.0
2000-11-01 08:00:00	MSFT	Stock	34.25	34.5938	34.0	34.25	350800.0
2000-11-01 09:00:00	MSFT	Stock	34.25	34.75	33.8125	34.6562	7400200.0
2000-11-01 10:00:00	MSFT	Stock	34.6406	34.9688	34.2812	34.9688	12290400.0
2000-11-01 11:00:00	MSFT	Stock	34.9688	35.0	34.7188	34.75	9375800.0
2000-11-01 12:00:00	MSFT	Stock	34.75	34.9062	34.75	34.8438	6843600.0
2000-11-01 13:00:00	MSFT	Stock	34.8438	34.9688	34.8125	34.8438	10247400.0
2000-11-01 14:00:00	MSFT	Stock	34.875	34.9688	34.7188	34.875	7398200.0
2000-11-01 15:00:00	MSFT	Stock	34.875	35.0312	34.7812	34.8125	16703400.0
2000-11-01 16:00:00	MSFT	Stock	34.8125	35.0	34.25	34.7188	2675400.0
2000-11-01 17:00:00	MSFT	Stock	34.7188	34.9688	34.7188	34.9688	293200.0
2000-11-01 18:00:00	MSFT	Stock	34.9688	35.0	34.9688	34.9688	8800.0
2000-11-01 08:00:00	NVDA	Stock	0.2585	0.2585	0.2585	0.2585	4296000.0
2000-11-01 09:00:00	NVDA	Stock	0.2526	0.2542	0.2479	0.2504	15048000.0
2000-11-01 10:00:00	NVDA	Stock	0.2503	0.251	0.2438	0.2458	44448000.0
2000-11-01 11:00:00	NVDA	Stock	0.2458	0.2557	0.2458	0.2529	64824000.0
2000-11-01 12:00:00	NVDA	Stock	0.253	0.2539	0.251	0.2539	16392000.0
2000-11-01 13:00:00	NVDA	Stock	0.2534	0.2552	0.25	0.2521	22080000.0
2000-11-01 14:00:00	NVDA	Stock	0.2518	0.2518	0.249	0.2492	39240000.0
2000-11-01 15:00:00	NVDA	Stock	0.2492	0.2625	0.249	0.2589	48720000.0
2000-11-01 16:00:00	NVDA	Stock	0.2589	0.2615	0.2573	0.2615	8832000.0
2000-11-01 17:00:00	NVDA	Stock	0.2625	0.2625	0.2625	0.2625	24000.0
2000-11-01 08:00:00	AMZN	Stock	1.8328	1.8328	1.7875	1.7875	364000.0
2000-11-01 09:00:00	AMZN	Stock	1.7938	1.9219	1.7812	1.8875	26918000.0
2000-11-01 10:00:00	AMZN	Stock	1.8906	2.0	1.8719	1.9938	53354000.0
2000-11-01 11:00:00	AMZN	Stock	1.9969	1.9969	1.9125	1.9125	25930000.0
2000-11-01 12:00:00	AMZN	Stock	1.9125	1.9281	1.8719	1.9094	24950000.0
2000-11-01 13:00:00	AMZN	Stock	1.9094	1.9125	1.8875	1.9	15150000.0
2000-11-01 14:00:00	AMZN	Stock	1.9	1.9406	1.8969	1.8969	12650000.0
2000-11-01 15:00:00	AMZN	Stock	1.8969	1.9312	1.8625	1.8688	25654000.0
2000-11-01 16:00:00	AMZN	Stock	1.875	1.9062	1.8594	1.8688	2524000.0
2000-11-01 17:00:00	AMZN	Stock	1.8594	1.8688	1.8594	1.8688	56000.0
2000-11-01 18:00:00	AMZN	Stock	1.8594	1.8594	1.8594	1.8594	4000.0
2000-11-01 09:00:00	CL	Stock	29.45	29.645	29.255	29.325	830800.0
2000-11-01 10:00:00	CL	Stock	29.325	29.5	28.775	28.8	873800.0
2000-11-01 11:00:00	CL	Stock	28.8	28.8	28.125	28.175	1348800.0
2000-11-01 12:00:00	CL	Stock	28.175	28.2	28.09	28.115	692000.0
2000-11-01 13:00:00	CL	Stock	28.115	28.2	27.975	28.025	589400.0
2000-11-01 14:00:00	CL	Stock	28.025	28.075	27.875	28.06	682000.0
2000-11-01 15:00:00	CL	Stock	28.075	28.48	27.995	28.42	874400.0

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

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