PREVIEW / stock_1hour / 2000-08-10

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-08-10.parquet
  size:    295 KB
  rows:    15,315
  symbols: 1,208

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-08-10 08:00:00	AAPL	Stock	0.8477	0.8482	0.846	0.846	1853600.0
2000-08-10 09:00:00	AAPL	Stock	0.846	0.8605	0.846	0.8549	25687200.0
2000-08-10 10:00:00	AAPL	Stock	0.8549	0.8571	0.846	0.8571	45052000.0
2000-08-10 11:00:00	AAPL	Stock	0.8571	0.8605	0.8538	0.8549	45147200.0
2000-08-10 12:00:00	AAPL	Stock	0.8549	0.865	0.8549	0.8616	33152000.0
2000-08-10 13:00:00	AAPL	Stock	0.8616	0.8638	0.8571	0.8594	17712800.0
2000-08-10 14:00:00	AAPL	Stock	0.8583	0.8605	0.8538	0.856	25933600.0
2000-08-10 15:00:00	AAPL	Stock	0.856	0.8571	0.8482	0.8493	49240800.0
2000-08-10 16:00:00	AAPL	Stock	0.8493	0.8611	0.846	0.8493	4110400.0
2000-08-10 18:00:00	AAPL	Stock	0.8482	0.8482	0.8482	0.8482	5600.0
2000-08-10 08:00:00	MSFT	Stock	36.9688	37.1406	36.9688	37.125	84200.0
2000-08-10 09:00:00	MSFT	Stock	37.0	37.125	36.5938	36.625	5447200.0
2000-08-10 10:00:00	MSFT	Stock	36.625	36.875	36.4688	36.875	7513000.0
2000-08-10 11:00:00	MSFT	Stock	36.875	36.9062	36.4062	36.4688	3970200.0
2000-08-10 12:00:00	MSFT	Stock	36.4688	36.5625	36.2812	36.375	6750400.0
2000-08-10 13:00:00	MSFT	Stock	36.3594	36.4062	36.0312	36.1875	6142600.0
2000-08-10 14:00:00	MSFT	Stock	36.1875	36.1875	35.875	36.0	8624400.0
2000-08-10 15:00:00	MSFT	Stock	36.0	36.4375	35.9688	36.3125	9167200.0
2000-08-10 16:00:00	MSFT	Stock	36.2969	36.375	36.1875	36.3438	1093000.0
2000-08-10 17:00:00	MSFT	Stock	36.3438	36.3438	36.125	36.125	9000.0
2000-08-10 18:00:00	MSFT	Stock	36.0625	36.0625	36.0625	36.0625	3400.0
2000-08-10 08:00:00	NVDA	Stock	0.2714	0.2714	0.2714	0.2714	24000.0
2000-08-10 09:00:00	NVDA	Stock	0.2706	0.2706	0.2607	0.2664	25824000.0
2000-08-10 10:00:00	NVDA	Stock	0.2654	0.2708	0.2604	0.2667	15576000.0
2000-08-10 11:00:00	NVDA	Stock	0.2677	0.2698	0.2667	0.2667	7464000.0
2000-08-10 12:00:00	NVDA	Stock	0.2685	0.2724	0.2669	0.2708	24744000.0
2000-08-10 13:00:00	NVDA	Stock	0.2708	0.2734	0.2703	0.2729	10368000.0
2000-08-10 14:00:00	NVDA	Stock	0.2729	0.275	0.2719	0.275	18576000.0
2000-08-10 15:00:00	NVDA	Stock	0.2771	0.2813	0.2729	0.275	48744000.0
2000-08-10 16:00:00	NVDA	Stock	0.275	0.275	0.275	0.275	2712000.0
2000-08-10 08:00:00	AMZN	Stock	1.5625	1.5906	1.55	1.5812	880000.0
2000-08-10 09:00:00	AMZN	Stock	1.5812	1.5875	1.5281	1.5531	21246000.0
2000-08-10 10:00:00	AMZN	Stock	1.55	1.5563	1.5312	1.5469	21758000.0
2000-08-10 11:00:00	AMZN	Stock	1.5469	1.55	1.5125	1.5188	12632000.0
2000-08-10 12:00:00	AMZN	Stock	1.525	1.525	1.5	1.5062	12396000.0
2000-08-10 13:00:00	AMZN	Stock	1.5062	1.5188	1.5031	1.5094	13908000.0
2000-08-10 14:00:00	AMZN	Stock	1.5125	1.525	1.5062	1.5219	16722000.0
2000-08-10 15:00:00	AMZN	Stock	1.5219	1.5312	1.5125	1.5234	10996000.0
2000-08-10 16:00:00	AMZN	Stock	1.5219	1.525	1.5156	1.5219	9990000.0
2000-08-10 17:00:00	AMZN	Stock	1.5219	1.525	1.5219	1.525	32000.0
2000-08-10 18:00:00	AMZN	Stock	1.5219	1.5219	1.5219	1.5219	12000.0
2000-08-10 09:00:00	CL	Stock	26.6562	26.6875	26.5938	26.6875	253200.0
2000-08-10 10:00:00	CL	Stock	26.75	26.9062	26.6875	26.7188	443400.0
2000-08-10 11:00:00	CL	Stock	26.75	26.8125	26.6562	26.7188	223600.0
2000-08-10 12:00:00	CL	Stock	26.6875	26.8438	26.6719	26.7812	229400.0
2000-08-10 13:00:00	CL	Stock	26.7812	26.8125	26.75	26.7812	158400.0
2000-08-10 14:00:00	CL	Stock	26.7812	26.9375	26.75	26.9062	204200.0
2000-08-10 15:00:00	CL	Stock	26.9375	27.0312	26.7812	26.8438	716800.0
2000-08-10 16:00:00	CL	Stock	26.8125	26.8125	26.7969	26.7969	101200.0

> showing 49 of 15,315 rows — these rows as CSV

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