PREVIEW / stock_1hour / 2001-04-02

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-04-02.parquet
  size:    355 KB
  rows:    16,640
  symbols: 1,287

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-02 08:00:00	AAPL	Stock	0.3941	0.395	0.3941	0.3943	196000.0
2001-04-02 09:00:00	AAPL	Stock	0.3941	0.4036	0.3941	0.4016	30749600.0
2001-04-02 10:00:00	AAPL	Stock	0.4014	0.4046	0.39	0.3916	40908000.0
2001-04-02 11:00:00	AAPL	Stock	0.3916	0.4018	0.3907	0.4011	37178400.0
2001-04-02 12:00:00	AAPL	Stock	0.4011	0.4011	0.3845	0.3866	51934400.0
2001-04-02 13:00:00	AAPL	Stock	0.3866	0.3905	0.3821	0.3829	36013600.0
2001-04-02 14:00:00	AAPL	Stock	0.3829	0.3873	0.3821	0.3848	27266400.0
2001-04-02 15:00:00	AAPL	Stock	0.385	0.3866	0.3821	0.3852	69272000.0
2001-04-02 16:00:00	AAPL	Stock	0.3854	0.3863	0.3777	0.3855	22859200.0
2001-04-02 17:00:00	AAPL	Stock	0.3855	0.3855	0.3855	0.3855	369600.0
2001-04-02 18:00:00	AAPL	Stock	0.3813	0.3813	0.3813	0.3813	11200.0
2001-04-02 08:00:00	MSFT	Stock	27.375	27.375	27.25	27.3438	84200.0
2001-04-02 09:00:00	MSFT	Stock	27.375	27.8438	27.3125	27.7812	8890200.0
2001-04-02 10:00:00	MSFT	Stock	27.8125	28.25	27.75	28.0625	15683800.0
2001-04-02 11:00:00	MSFT	Stock	28.0938	28.4688	28.0312	28.3438	8034400.0
2001-04-02 12:00:00	MSFT	Stock	28.375	28.375	27.875	28.0938	7655000.0
2001-04-02 13:00:00	MSFT	Stock	28.1094	28.125	27.5625	27.6875	8244200.0
2001-04-02 14:00:00	MSFT	Stock	27.7188	27.7812	27.5	27.5938	7562800.0
2001-04-02 15:00:00	MSFT	Stock	27.625	28.0	27.5	27.9062	14891200.0
2001-04-02 16:00:00	MSFT	Stock	27.9062	27.9375	27.5	27.9062	4232800.0
2001-04-02 17:00:00	MSFT	Stock	27.9062	27.9062	27.625	27.625	273800.0
2001-04-02 18:00:00	MSFT	Stock	27.5938	27.6406	27.5625	27.5625	6400.0
2001-04-02 08:00:00	NVDA	Stock	0.2704	0.276	0.2704	0.274	1104000.0
2001-04-02 09:00:00	NVDA	Stock	0.2698	0.2763	0.2682	0.2737	189048000.0
2001-04-02 10:00:00	NVDA	Stock	0.2732	0.2734	0.2615	0.2643	332424000.0
2001-04-02 11:00:00	NVDA	Stock	0.2643	0.2677	0.2625	0.2638	100632000.0
2001-04-02 12:00:00	NVDA	Stock	0.2641	0.2656	0.2596	0.2638	99192000.0
2001-04-02 13:00:00	NVDA	Stock	0.2638	0.2646	0.2594	0.2604	82872000.0
2001-04-02 14:00:00	NVDA	Stock	0.2607	0.262	0.2563	0.2581	156720000.0
2001-04-02 15:00:00	NVDA	Stock	0.2579	0.2609	0.2557	0.2586	198264000.0
2001-04-02 16:00:00	NVDA	Stock	0.2594	0.2599	0.2552	0.2591	11832000.0
2001-04-02 17:00:00	NVDA	Stock	0.2578	0.2578	0.2578	0.2578	600000.0
2001-04-02 18:00:00	NVDA	Stock	0.2568	0.2583	0.2568	0.2583	48000.0
2001-04-02 08:00:00	AMZN	Stock	0.52	0.52	0.515	0.515	4000.0
2001-04-02 09:00:00	AMZN	Stock	0.5175	0.5265	0.514	0.5195	5716000.0
2001-04-02 10:00:00	AMZN	Stock	0.5175	0.5205	0.4925	0.497	16964000.0
2001-04-02 11:00:00	AMZN	Stock	0.4975	0.499	0.493	0.495	15446000.0
2001-04-02 12:00:00	AMZN	Stock	0.495	0.4985	0.478	0.4825	23696000.0
2001-04-02 13:00:00	AMZN	Stock	0.482	0.4825	0.425	0.448	42216000.0
2001-04-02 14:00:00	AMZN	Stock	0.4475	0.4485	0.4275	0.438	31770000.0
2001-04-02 15:00:00	AMZN	Stock	0.4375	0.462	0.432	0.4555	31806000.0
2001-04-02 16:00:00	AMZN	Stock	0.4555	0.457	0.45	0.455	3178000.0
2001-04-02 17:00:00	AMZN	Stock	0.445	0.45	0.445	0.45	60000.0
2001-04-02 18:00:00	AMZN	Stock	0.45	0.45	0.45	0.45	4000.0
2001-04-02 09:00:00	CL	Stock	27.7	27.965	27.65	27.965	265800.0
2001-04-02 10:00:00	CL	Stock	27.915	28.165	27.91	27.99	395000.0
2001-04-02 11:00:00	CL	Stock	28.0	28.15	27.95	28.055	227000.0
2001-04-02 12:00:00	CL	Stock	28.055	28.055	27.275	27.35	529600.0
2001-04-02 13:00:00	CL	Stock	27.355	27.44	27.2	27.415	235400.0
2001-04-02 14:00:00	CL	Stock	27.45	27.5	27.3	27.325	368600.0

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

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