PREVIEW / stock_1hour / 2001-04-03

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-04-03.parquet
  size:    357 KB
  rows:    16,670
  symbols: 1,285

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-03 08:00:00	AAPL	Stock	0.3838	0.3838	0.3838	0.3838	106400.0
2001-04-03 09:00:00	AAPL	Stock	0.383	0.383	0.3745	0.3752	52528000.0
2001-04-03 10:00:00	AAPL	Stock	0.3752	0.3784	0.3723	0.3739	47891200.0
2001-04-03 11:00:00	AAPL	Stock	0.3729	0.3739	0.367	0.367	67569600.0
2001-04-03 12:00:00	AAPL	Stock	0.3671	0.3757	0.3661	0.3757	52348800.0
2001-04-03 13:00:00	AAPL	Stock	0.3759	0.3766	0.3696	0.3718	26818400.0
2001-04-03 14:00:00	AAPL	Stock	0.3718	0.3734	0.3643	0.3668	33885600.0
2001-04-03 15:00:00	AAPL	Stock	0.3663	0.3675	0.3595	0.3614	65284800.0
2001-04-03 16:00:00	AAPL	Stock	0.3613	0.3704	0.3573	0.3614	12622400.0
2001-04-03 17:00:00	AAPL	Stock	0.3614	0.3614	0.3571	0.3571	733600.0
2001-04-03 08:00:00	MSFT	Stock	27.4375	27.75	27.375	27.5	62424.0
2001-04-03 09:00:00	MSFT	Stock	27.5625	27.7812	27.2188	27.2188	11892000.0
2001-04-03 10:00:00	MSFT	Stock	27.2188	27.75	27.0625	27.125	17204800.0
2001-04-03 11:00:00	MSFT	Stock	27.0938	27.2188	26.8438	27.0312	12015400.0
2001-04-03 12:00:00	MSFT	Stock	27.0469	27.5	26.9688	27.375	9247600.0
2001-04-03 13:00:00	MSFT	Stock	27.3438	27.375	26.9688	27.0	7378200.0
2001-04-03 14:00:00	MSFT	Stock	26.9688	27.0312	26.5625	26.7812	11161000.0
2001-04-03 15:00:00	MSFT	Stock	26.7812	26.8438	26.375	26.7031	20371800.0
2001-04-03 16:00:00	MSFT	Stock	26.6875	27.5	26.4531	26.7812	3461800.0
2001-04-03 17:00:00	MSFT	Stock	26.8594	26.875	26.6875	26.7188	489800.0
2001-04-03 18:00:00	MSFT	Stock	26.6875	26.75	26.6875	26.75	1600.0
2001-04-03 08:00:00	NVDA	Stock	0.2563	0.2594	0.2563	0.2583	792000.0
2001-04-03 09:00:00	NVDA	Stock	0.2568	0.2646	0.2549	0.263	180264000.0
2001-04-03 10:00:00	NVDA	Stock	0.2629	0.2721	0.2625	0.2661	381744000.0
2001-04-03 11:00:00	NVDA	Stock	0.2659	0.2695	0.2633	0.2677	255480000.0
2001-04-03 12:00:00	NVDA	Stock	0.2677	0.2747	0.2674	0.274	242016000.0
2001-04-03 13:00:00	NVDA	Stock	0.274	0.2745	0.2703	0.2729	197280000.0
2001-04-03 14:00:00	NVDA	Stock	0.2732	0.2747	0.2693	0.2701	283272000.0
2001-04-03 15:00:00	NVDA	Stock	0.2701	0.2717	0.262	0.2678	408312000.0
2001-04-03 16:00:00	NVDA	Stock	0.268	0.2688	0.2651	0.2672	19608000.0
2001-04-03 17:00:00	NVDA	Stock	0.268	0.2688	0.2628	0.2628	4200000.0
2001-04-03 18:00:00	NVDA	Stock	0.2625	0.2641	0.256	0.262	2064000.0
2001-04-03 08:00:00	AMZN	Stock	0.445	0.45	0.445	0.45	22000.0
2001-04-03 09:00:00	AMZN	Stock	0.44	0.442	0.425	0.4335	14126000.0
2001-04-03 10:00:00	AMZN	Stock	0.4335	0.45	0.4315	0.44	16856000.0
2001-04-03 11:00:00	AMZN	Stock	0.4405	0.4415	0.425	0.436	9798000.0
2001-04-03 12:00:00	AMZN	Stock	0.436	0.4525	0.433	0.45	14178000.0
2001-04-03 13:00:00	AMZN	Stock	0.45	0.4575	0.4485	0.452	6060000.0
2001-04-03 14:00:00	AMZN	Stock	0.4525	0.4565	0.435	0.439	10628000.0
2001-04-03 15:00:00	AMZN	Stock	0.439	0.45	0.4275	0.432	18242000.0
2001-04-03 16:00:00	AMZN	Stock	0.4315	0.442	0.425	0.43	2586000.0
2001-04-03 17:00:00	AMZN	Stock	0.4315	0.4325	0.4315	0.4325	14000.0
2001-04-03 09:00:00	CL	Stock	27.35	27.4	26.75	26.75	436400.0
2001-04-03 10:00:00	CL	Stock	26.75	27.285	26.675	27.11	526000.0
2001-04-03 11:00:00	CL	Stock	27.1	27.11	26.88	26.99	299600.0
2001-04-03 12:00:00	CL	Stock	26.97	27.07	26.8	26.8	282000.0
2001-04-03 13:00:00	CL	Stock	26.775	26.88	26.64	26.83	348400.0
2001-04-03 14:00:00	CL	Stock	26.8	26.845	26.675	26.7	344400.0
2001-04-03 15:00:00	CL	Stock	26.7	26.7	26.55	26.645	810200.0
2001-04-03 16:00:00	CL	Stock	26.65	26.8	26.645	26.8	140000.0

> showing 50 of 16,670 rows — these rows as CSV

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