PREVIEW / stock_1hour / 2000-11-03

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-11-03.parquet
  size:    305 KB
  rows:    15,743
  symbols: 1,240

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-03 08:00:00	AAPL	Stock	0.3984	0.4085	0.3984	0.4063	3886400.0
2000-11-03 09:00:00	AAPL	Stock	0.4063	0.4107	0.3917	0.3929	112655200.0
2000-11-03 10:00:00	AAPL	Stock	0.394	0.4085	0.3917	0.4074	108539200.0
2000-11-03 11:00:00	AAPL	Stock	0.4085	0.4096	0.4007	0.4018	64304800.0
2000-11-03 12:00:00	AAPL	Stock	0.4018	0.404	0.3973	0.3996	34048000.0
2000-11-03 13:00:00	AAPL	Stock	0.4001	0.4018	0.3973	0.4007	25228000.0
2000-11-03 14:00:00	AAPL	Stock	0.4007	0.4018	0.3929	0.394	60200000.0
2000-11-03 15:00:00	AAPL	Stock	0.3951	0.3984	0.3929	0.3984	41574400.0
2000-11-03 16:00:00	AAPL	Stock	0.3984	0.4074	0.3951	0.3951	12493600.0
2000-11-03 17:00:00	AAPL	Stock	0.4007	0.4018	0.4007	0.4018	33600.0
2000-11-03 18:00:00	AAPL	Stock	0.3984	0.3984	0.3984	0.3984	56000.0
2000-11-03 08:00:00	MSFT	Stock	35.125	35.75	34.9375	35.7188	857400.0
2000-11-03 09:00:00	MSFT	Stock	35.6875	35.6875	34.25	34.7188	15587200.0
2000-11-03 10:00:00	MSFT	Stock	34.6875	34.8125	34.5312	34.7812	10138800.0
2000-11-03 11:00:00	MSFT	Stock	34.7812	34.8125	34.5312	34.5938	3972200.0
2000-11-03 12:00:00	MSFT	Stock	34.5938	34.625	34.3438	34.375	4164000.0
2000-11-03 13:00:00	MSFT	Stock	34.375	34.5	34.3125	34.375	5118800.0
2000-11-03 14:00:00	MSFT	Stock	34.3438	34.5	34.1875	34.3125	6305200.0
2000-11-03 15:00:00	MSFT	Stock	34.3438	34.5	34.0312	34.1562	14996200.0
2000-11-03 16:00:00	MSFT	Stock	34.1094	34.6562	34.1094	34.125	1684800.0
2000-11-03 17:00:00	MSFT	Stock	34.1875	34.3125	34.1562	34.1562	5800.0
2000-11-03 18:00:00	MSFT	Stock	34.2188	34.3125	34.1562	34.3125	3200.0
2000-11-03 08:00:00	NVDA	Stock	0.2766	0.2766	0.2766	0.2766	168000.0
2000-11-03 09:00:00	NVDA	Stock	0.2766	0.287	0.2729	0.2833	17088000.0
2000-11-03 10:00:00	NVDA	Stock	0.2841	0.2911	0.2828	0.2875	36552000.0
2000-11-03 11:00:00	NVDA	Stock	0.2872	0.3	0.287	0.2943	77496000.0
2000-11-03 12:00:00	NVDA	Stock	0.2943	0.2974	0.2919	0.2969	27048000.0
2000-11-03 13:00:00	NVDA	Stock	0.2954	0.3	0.2945	0.2977	23880000.0
2000-11-03 14:00:00	NVDA	Stock	0.2977	0.3021	0.2974	0.3	25272000.0
2000-11-03 15:00:00	NVDA	Stock	0.3	0.3016	0.2953	0.2971	39288000.0
2000-11-03 16:00:00	NVDA	Stock	0.2971	0.2977	0.2958	0.2969	4368000.0
2000-11-03 17:00:00	NVDA	Stock	0.2958	0.2958	0.2896	0.2896	72000.0
2000-11-03 18:00:00	NVDA	Stock	0.2979	0.2979	0.2979	0.2979	24000.0
2000-11-03 08:00:00	AMZN	Stock	1.975	1.9938	1.975	1.9875	76000.0
2000-11-03 09:00:00	AMZN	Stock	1.9875	2.0	1.9156	1.9438	10982000.0
2000-11-03 10:00:00	AMZN	Stock	1.9438	2.0188	1.9219	2.0062	30952000.0
2000-11-03 11:00:00	AMZN	Stock	2.0156	2.0438	1.9875	2.0	26684000.0
2000-11-03 12:00:00	AMZN	Stock	2.0	2.0188	1.9562	1.9719	9088000.0
2000-11-03 13:00:00	AMZN	Stock	1.975	1.9875	1.95	1.9625	5686000.0
2000-11-03 14:00:00	AMZN	Stock	1.9688	1.975	1.9156	1.925	8120000.0
2000-11-03 15:00:00	AMZN	Stock	1.9281	1.9312	1.8438	1.8781	16886000.0
2000-11-03 16:00:00	AMZN	Stock	1.8781	1.8875	1.875	1.8875	1768000.0
2000-11-03 17:00:00	AMZN	Stock	1.8906	1.925	1.8781	1.8781	84000.0
2000-11-03 18:00:00	AMZN	Stock	1.9938	1.9938	1.9	1.9	20000.0
2000-11-03 09:00:00	CL	Stock	29.18	29.575	29.15	29.565	535400.0
2000-11-03 10:00:00	CL	Stock	29.575	29.675	29.09	29.12	370800.0
2000-11-03 11:00:00	CL	Stock	29.12	29.35	28.975	29.255	252800.0
2000-11-03 12:00:00	CL	Stock	29.275	29.375	29.175	29.225	178400.0
2000-11-03 13:00:00	CL	Stock	29.215	29.37	29.2	29.35	141800.0
2000-11-03 14:00:00	CL	Stock	29.35	29.35	29.175	29.345	221800.0

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

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