PREVIEW / stock_1hour / 2001-05-07

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-05-07.parquet
  size:    350 KB
  rows:    16,477
  symbols: 1,288

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
2001-05-07 08:00:00	AAPL	Stock	0.4589	0.4596	0.4589	0.4596	11200.0
2001-05-07 09:00:00	AAPL	Stock	0.4591	0.4598	0.45	0.4534	30391200.0
2001-05-07 10:00:00	AAPL	Stock	0.4536	0.46	0.4513	0.4529	48400800.0
2001-05-07 11:00:00	AAPL	Stock	0.453	0.4589	0.4514	0.4529	23525600.0
2001-05-07 12:00:00	AAPL	Stock	0.4527	0.4577	0.4484	0.4536	36080800.0
2001-05-07 13:00:00	AAPL	Stock	0.4538	0.455	0.445	0.4477	29601600.0
2001-05-07 14:00:00	AAPL	Stock	0.4477	0.4579	0.4464	0.4521	51290400.0
2001-05-07 15:00:00	AAPL	Stock	0.4521	0.4543	0.4436	0.4457	36629600.0
2001-05-07 16:00:00	AAPL	Stock	0.4457	0.4527	0.442	0.4498	8584800.0
2001-05-07 17:00:00	AAPL	Stock	0.4498	0.4504	0.4498	0.4504	134400.0
2001-05-07 18:00:00	AAPL	Stock	0.4504	0.4504	0.4504	0.4504	11200.0
2001-05-07 08:00:00	MSFT	Stock	35.4	35.625	35.395	35.55	140000.0
2001-05-07 09:00:00	MSFT	Stock	35.56	36.015	35.125	35.99	19396600.0
2001-05-07 10:00:00	MSFT	Stock	36.0	36.075	35.55	35.745	23804400.0
2001-05-07 11:00:00	MSFT	Stock	35.745	35.92	35.35	35.53	18090200.0
2001-05-07 12:00:00	MSFT	Stock	35.525	35.65	35.455	35.565	7237800.0
2001-05-07 13:00:00	MSFT	Stock	35.55	35.7	35.485	35.675	7188200.0
2001-05-07 14:00:00	MSFT	Stock	35.675	35.865	35.625	35.675	7463200.0
2001-05-07 15:00:00	MSFT	Stock	35.675	35.88	35.67	35.69	17552400.0
2001-05-07 16:00:00	MSFT	Stock	35.7	36.0	35.53	35.725	2112000.0
2001-05-07 17:00:00	MSFT	Stock	35.72	35.875	35.72	35.875	23600.0
2001-05-07 18:00:00	MSFT	Stock	35.855	35.855	35.75	35.75	600.0
2001-05-07 08:00:00	NVDA	Stock	0.3746	0.3809	0.3708	0.3729	2064000.0
2001-05-07 09:00:00	NVDA	Stock	0.373	0.375	0.3685	0.375	94008000.0
2001-05-07 10:00:00	NVDA	Stock	0.3749	0.3868	0.3748	0.3783	158136000.0
2001-05-07 11:00:00	NVDA	Stock	0.3779	0.3809	0.3728	0.375	64728000.0
2001-05-07 12:00:00	NVDA	Stock	0.375	0.381	0.375	0.3804	40704000.0
2001-05-07 13:00:00	NVDA	Stock	0.38	0.3883	0.3781	0.3878	102168000.0
2001-05-07 14:00:00	NVDA	Stock	0.3882	0.3925	0.3863	0.3897	173712000.0
2001-05-07 15:00:00	NVDA	Stock	0.3897	0.3938	0.3851	0.391	290568000.0
2001-05-07 16:00:00	NVDA	Stock	0.391	0.3917	0.3885	0.3917	19824000.0
2001-05-07 17:00:00	NVDA	Stock	0.3916	0.3916	0.3908	0.3908	936000.0
2001-05-07 08:00:00	AMZN	Stock	0.875	0.875	0.87	0.87	8000.0
2001-05-07 09:00:00	AMZN	Stock	0.869	0.875	0.867	0.8695	13410000.0
2001-05-07 10:00:00	AMZN	Stock	0.869	0.8765	0.8615	0.865	22378000.0
2001-05-07 11:00:00	AMZN	Stock	0.865	0.868	0.85	0.8505	14792000.0
2001-05-07 12:00:00	AMZN	Stock	0.8505	0.8535	0.833	0.837	11154000.0
2001-05-07 13:00:00	AMZN	Stock	0.8385	0.8495	0.8275	0.8395	9858000.0
2001-05-07 14:00:00	AMZN	Stock	0.84	0.866	0.8365	0.8405	12086000.0
2001-05-07 15:00:00	AMZN	Stock	0.8405	0.849	0.8255	0.846	13394000.0
2001-05-07 16:00:00	AMZN	Stock	0.8455	0.8655	0.8375	0.845	2496000.0
2001-05-07 09:00:00	CL	Stock	28.435	28.575	28.435	28.555	199400.0
2001-05-07 10:00:00	CL	Stock	28.545	28.615	28.38	28.4	358600.0
2001-05-07 11:00:00	CL	Stock	28.4	28.535	28.395	28.475	136800.0
2001-05-07 12:00:00	CL	Stock	28.475	28.49	28.4	28.475	104200.0
2001-05-07 13:00:00	CL	Stock	28.48	28.515	28.4	28.5	160200.0
2001-05-07 14:00:00	CL	Stock	28.5	28.67	28.47	28.53	298400.0
2001-05-07 15:00:00	CL	Stock	28.555	28.65	28.465	28.55	403600.0
2001-05-07 16:00:00	CL	Stock	28.59	28.59	28.425	28.59	52000.0

> showing 49 of 16,477 rows — these rows as CSV

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