PREVIEW / stock_1hour / 2001-04-09

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-04-09.parquet
  size:    335 KB
  rows:    15,936
  symbols: 1,283

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-04-09 08:00:00	AAPL	Stock	0.3675	0.3691	0.3675	0.3684	487200.0
2001-04-09 09:00:00	AAPL	Stock	0.3691	0.3804	0.3677	0.3768	31287200.0
2001-04-09 10:00:00	AAPL	Stock	0.3768	0.3811	0.3705	0.3705	49856800.0
2001-04-09 11:00:00	AAPL	Stock	0.3705	0.3745	0.3679	0.3745	30816800.0
2001-04-09 12:00:00	AAPL	Stock	0.3743	0.3761	0.3705	0.3709	20344800.0
2001-04-09 13:00:00	AAPL	Stock	0.3709	0.3709	0.3582	0.3618	28845600.0
2001-04-09 14:00:00	AAPL	Stock	0.3616	0.3698	0.3609	0.3673	26292000.0
2001-04-09 15:00:00	AAPL	Stock	0.3671	0.3704	0.3639	0.3666	50041600.0
2001-04-09 16:00:00	AAPL	Stock	0.367	0.3704	0.3661	0.3664	12532800.0
2001-04-09 08:00:00	MSFT	Stock	28.045	28.405	27.95	28.375	48800.0
2001-04-09 09:00:00	MSFT	Stock	28.445	28.7	28.15	28.525	7497400.0
2001-04-09 10:00:00	MSFT	Stock	28.51	28.71	28.265	28.315	8536000.0
2001-04-09 11:00:00	MSFT	Stock	28.31	28.36	28.1	28.23	7625600.0
2001-04-09 12:00:00	MSFT	Stock	28.23	28.315	28.025	28.155	3823800.0
2001-04-09 13:00:00	MSFT	Stock	28.155	28.185	27.83	28.02	6553800.0
2001-04-09 14:00:00	MSFT	Stock	28.02	28.28	27.9	28.205	6195600.0
2001-04-09 15:00:00	MSFT	Stock	28.2	28.595	28.175	28.575	11976800.0
2001-04-09 16:00:00	MSFT	Stock	28.58	28.75	28.275	28.525	3037600.0
2001-04-09 17:00:00	MSFT	Stock	28.45	28.69	28.45	28.6	6800.0
2001-04-09 08:00:00	NVDA	Stock	0.2642	0.2667	0.2642	0.2667	408000.0
2001-04-09 09:00:00	NVDA	Stock	0.2667	0.2727	0.2646	0.2694	162336000.0
2001-04-09 10:00:00	NVDA	Stock	0.2695	0.2697	0.2575	0.2583	170376000.0
2001-04-09 11:00:00	NVDA	Stock	0.2582	0.2599	0.251	0.257	188568000.0
2001-04-09 12:00:00	NVDA	Stock	0.2567	0.2583	0.2544	0.2556	74016000.0
2001-04-09 13:00:00	NVDA	Stock	0.2554	0.257	0.2532	0.2538	82056000.0
2001-04-09 14:00:00	NVDA	Stock	0.2541	0.2563	0.25	0.2529	129336000.0
2001-04-09 15:00:00	NVDA	Stock	0.2525	0.2533	0.2444	0.2487	249312000.0
2001-04-09 16:00:00	NVDA	Stock	0.2487	0.2494	0.248	0.2485	17136000.0
2001-04-09 17:00:00	NVDA	Stock	0.249	0.2508	0.2479	0.2508	192000.0
2001-04-09 18:00:00	NVDA	Stock	0.251	0.251	0.249	0.249	216000.0
2001-04-09 08:00:00	AMZN	Stock	0.4825	0.6	0.45	0.596	52960000.0
2001-04-09 09:00:00	AMZN	Stock	0.596	0.61	0.4825	0.54	156806000.0
2001-04-09 10:00:00	AMZN	Stock	0.54	0.5645	0.535	0.552	106252000.0
2001-04-09 11:00:00	AMZN	Stock	0.552	0.5575	0.5465	0.5555	38160000.0
2001-04-09 12:00:00	AMZN	Stock	0.555	0.559	0.55	0.555	12874000.0
2001-04-09 13:00:00	AMZN	Stock	0.555	0.555	0.548	0.5525	22890000.0
2001-04-09 14:00:00	AMZN	Stock	0.551	0.5645	0.547	0.5615	34816000.0
2001-04-09 15:00:00	AMZN	Stock	0.5615	0.5685	0.5555	0.5585	35384000.0
2001-04-09 16:00:00	AMZN	Stock	0.559	0.5915	0.538	0.557	2936000.0
2001-04-09 17:00:00	AMZN	Stock	0.557	0.559	0.5565	0.558	288000.0
2001-04-09 18:00:00	AMZN	Stock	0.5595	0.5595	0.55	0.5575	40000.0
2001-04-09 09:00:00	CL	Stock	26.0	26.6	26.0	26.48	746400.0
2001-04-09 10:00:00	CL	Stock	26.5	26.71	26.475	26.5	931000.0
2001-04-09 11:00:00	CL	Stock	26.5	26.5	26.18	26.275	601400.0
2001-04-09 12:00:00	CL	Stock	26.29	26.3	26.005	26.025	636400.0
2001-04-09 13:00:00	CL	Stock	26.03	26.125	26.0	26.115	633400.0
2001-04-09 14:00:00	CL	Stock	26.12	26.325	26.115	26.265	539400.0
2001-04-09 15:00:00	CL	Stock	26.25	26.275	26.0	26.05	1118400.0
2001-04-09 16:00:00	CL	Stock	26.075	26.24	26.025	26.24	340000.0
2001-04-09 17:00:00	CL	Stock	26.05	26.05	26.05	26.05	34000.0

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

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