PREVIEW / stock_1hour / 2001-03-20

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-03-20.parquet
  size:    346 KB
  rows:    16,401
  symbols: 1,280

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-03-20 08:00:00	AAPL	Stock	0.3571	0.375	0.3571	0.3683	834400.0
2001-03-20 09:00:00	AAPL	Stock	0.3683	0.3728	0.365	0.365	45332000.0
2001-03-20 10:00:00	AAPL	Stock	0.3661	0.3717	0.365	0.3694	37368800.0
2001-03-20 11:00:00	AAPL	Stock	0.3694	0.3717	0.3661	0.3717	70868000.0
2001-03-20 12:00:00	AAPL	Stock	0.3717	0.3717	0.365	0.3661	75964000.0
2001-03-20 13:00:00	AAPL	Stock	0.365	0.3728	0.3638	0.3694	69434400.0
2001-03-20 14:00:00	AAPL	Stock	0.3694	0.3739	0.365	0.365	56072800.0
2001-03-20 15:00:00	AAPL	Stock	0.3661	0.3661	0.3516	0.3521	89482400.0
2001-03-20 16:00:00	AAPL	Stock	0.3516	0.3672	0.3504	0.3504	32967200.0
2001-03-20 17:00:00	AAPL	Stock	0.3504	0.3504	0.3493	0.3493	39200.0
2001-03-20 18:00:00	AAPL	Stock	0.3493	0.3527	0.3493	0.3527	56000.0
2001-03-20 08:00:00	MSFT	Stock	27.3438	27.5625	27.3125	27.3125	160800.0
2001-03-20 09:00:00	MSFT	Stock	27.4062	27.6875	27.1562	27.5625	12240200.0
2001-03-20 10:00:00	MSFT	Stock	27.5625	27.875	27.5	27.5312	9412200.0
2001-03-20 11:00:00	MSFT	Stock	27.5312	27.625	27.3438	27.5938	5732400.0
2001-03-20 12:00:00	MSFT	Stock	27.5938	27.6562	27.25	27.3438	7027400.0
2001-03-20 13:00:00	MSFT	Stock	27.3438	27.875	27.3125	27.7188	8721200.0
2001-03-20 14:00:00	MSFT	Stock	27.75	28.0625	26.9062	26.9375	20968600.0
2001-03-20 15:00:00	MSFT	Stock	26.9375	27.125	26.3125	26.3438	21282600.0
2001-03-20 16:00:00	MSFT	Stock	26.3438	27.7031	26.0938	26.3125	2752400.0
2001-03-20 17:00:00	MSFT	Stock	26.3125	26.3438	26.25	26.25	37000.0
2001-03-20 18:00:00	MSFT	Stock	26.375	26.375	26.25	26.3594	1600.0
2001-03-20 08:00:00	NVDA	Stock	0.2625	0.2625	0.2625	0.2625	480000.0
2001-03-20 09:00:00	NVDA	Stock	0.2609	0.2719	0.2583	0.2701	335808000.0
2001-03-20 10:00:00	NVDA	Stock	0.2701	0.275	0.2664	0.2727	263976000.0
2001-03-20 11:00:00	NVDA	Stock	0.2724	0.276	0.2667	0.274	197808000.0
2001-03-20 12:00:00	NVDA	Stock	0.274	0.2758	0.2708	0.2724	168912000.0
2001-03-20 13:00:00	NVDA	Stock	0.2711	0.2724	0.2667	0.2682	144768000.0
2001-03-20 14:00:00	NVDA	Stock	0.2682	0.2708	0.2521	0.2547	412080000.0
2001-03-20 15:00:00	NVDA	Stock	0.2547	0.2549	0.2354	0.2385	383784000.0
2001-03-20 16:00:00	NVDA	Stock	0.2384	0.2568	0.2359	0.2367	11928000.0
2001-03-20 17:00:00	NVDA	Stock	0.2375	0.2375	0.2375	0.2375	48000.0
2001-03-20 18:00:00	NVDA	Stock	0.2367	0.2367	0.2367	0.2367	72000.0
2001-03-20 08:00:00	AMZN	Stock	0.525	0.55	0.525	0.5375	592000.0
2001-03-20 09:00:00	AMZN	Stock	0.5344	0.5406	0.5188	0.5188	15500000.0
2001-03-20 10:00:00	AMZN	Stock	0.5219	0.5344	0.5156	0.5281	18758000.0
2001-03-20 11:00:00	AMZN	Stock	0.5281	0.5344	0.525	0.5344	7036000.0
2001-03-20 12:00:00	AMZN	Stock	0.5344	0.55	0.5312	0.5469	13212000.0
2001-03-20 13:00:00	AMZN	Stock	0.5438	0.5719	0.5438	0.5656	16428000.0
2001-03-20 14:00:00	AMZN	Stock	0.5688	0.575	0.5219	0.5281	28782000.0
2001-03-20 15:00:00	AMZN	Stock	0.525	0.5266	0.5062	0.5156	16796000.0
2001-03-20 16:00:00	AMZN	Stock	0.5125	0.5156	0.5062	0.5125	4194000.0
2001-03-20 17:00:00	AMZN	Stock	0.5125	0.5125	0.5125	0.5125	6000.0
2001-03-20 18:00:00	AMZN	Stock	0.5125	0.5125	0.5125	0.5125	50000.0
2001-03-20 09:00:00	CL	Stock	26.725	27.375	26.7	27.37	572400.0
2001-03-20 10:00:00	CL	Stock	27.37	27.49	27.28	27.3	480000.0
2001-03-20 11:00:00	CL	Stock	27.3	27.49	27.25	27.45	504000.0
2001-03-20 12:00:00	CL	Stock	27.44	27.465	27.275	27.38	253600.0
2001-03-20 13:00:00	CL	Stock	27.35	27.42	27.33	27.365	327200.0
2001-03-20 14:00:00	CL	Stock	27.35	27.375	27.075	27.185	468200.0

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

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