PREVIEW / stock_1hour / 2001-07-24

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-07-24.parquet
  size:    364 KB
  rows:    17,262
  symbols: 1,316

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-07-24 08:00:00	AAPL	Stock	0.3488	0.3491	0.3488	0.3489	190400.0
2001-07-24 09:00:00	AAPL	Stock	0.3488	0.3557	0.3452	0.3536	25788000.0
2001-07-24 10:00:00	AAPL	Stock	0.3536	0.3546	0.3491	0.3521	43355200.0
2001-07-24 11:00:00	AAPL	Stock	0.352	0.3532	0.3468	0.3484	39653600.0
2001-07-24 12:00:00	AAPL	Stock	0.3486	0.3493	0.3464	0.3479	40891200.0
2001-07-24 13:00:00	AAPL	Stock	0.3479	0.3488	0.3438	0.3439	36405600.0
2001-07-24 14:00:00	AAPL	Stock	0.3438	0.3463	0.3366	0.3377	59108000.0
2001-07-24 15:00:00	AAPL	Stock	0.3371	0.3418	0.3345	0.3411	81071200.0
2001-07-24 16:00:00	AAPL	Stock	0.3405	0.3448	0.337	0.3416	12863200.0
2001-07-24 17:00:00	AAPL	Stock	0.3409	0.3409	0.3409	0.3409	72800.0
2001-07-24 18:00:00	AAPL	Stock	0.3418	0.3418	0.3418	0.3418	5600.0
2001-07-24 08:00:00	MSFT	Stock	33.69	33.69	33.485	33.5	57600.0
2001-07-24 09:00:00	MSFT	Stock	33.55	33.75	33.335	33.69	8576000.0
2001-07-24 10:00:00	MSFT	Stock	33.69	33.995	33.445	33.92	12611000.0
2001-07-24 11:00:00	MSFT	Stock	33.915	33.975	33.55	33.63	8556000.0
2001-07-24 12:00:00	MSFT	Stock	33.63	33.635	33.4	33.555	4545400.0
2001-07-24 13:00:00	MSFT	Stock	33.555	33.69	33.265	33.31	8522800.0
2001-07-24 14:00:00	MSFT	Stock	33.295	33.35	33.09	33.195	7295000.0
2001-07-24 15:00:00	MSFT	Stock	33.2	33.235	32.875	33.155	12675800.0
2001-07-24 16:00:00	MSFT	Stock	33.155	33.455	32.95	33.275	1131600.0
2001-07-24 17:00:00	MSFT	Stock	33.295	33.46	33.16	33.425	82200.0
2001-07-24 18:00:00	MSFT	Stock	33.425	33.44	33.4	33.4	3800.0
2001-07-24 08:00:00	NVDA	Stock	0.2917	0.2917	0.2843	0.2865	1968000.0
2001-07-24 09:00:00	NVDA	Stock	0.2865	0.2896	0.2803	0.2833	252264000.0
2001-07-24 10:00:00	NVDA	Stock	0.2838	0.2966	0.2826	0.2938	402096000.0
2001-07-24 11:00:00	NVDA	Stock	0.2936	0.2942	0.2878	0.2917	147120000.0
2001-07-24 12:00:00	NVDA	Stock	0.2917	0.2919	0.2893	0.2911	74880000.0
2001-07-24 13:00:00	NVDA	Stock	0.2913	0.2958	0.2913	0.2922	98040000.0
2001-07-24 14:00:00	NVDA	Stock	0.2926	0.2961	0.2912	0.2926	114456000.0
2001-07-24 15:00:00	NVDA	Stock	0.293	0.3019	0.2925	0.3015	185544000.0
2001-07-24 16:00:00	NVDA	Stock	0.3015	0.3016	0.2962	0.3016	38808000.0
2001-07-24 17:00:00	NVDA	Stock	0.3005	0.3016	0.3003	0.3015	1080000.0
2001-07-24 18:00:00	NVDA	Stock	0.3006	0.3006	0.3006	0.3006	48000.0
2001-07-24 08:00:00	AMZN	Stock	0.742	0.753	0.7	0.717	16598000.0
2001-07-24 09:00:00	AMZN	Stock	0.715	0.75	0.63	0.637	179844000.0
2001-07-24 10:00:00	AMZN	Stock	0.6375	0.6625	0.63	0.6615	119964000.0
2001-07-24 11:00:00	AMZN	Stock	0.661	0.662	0.6445	0.645	58980000.0
2001-07-24 12:00:00	AMZN	Stock	0.645	0.6455	0.6205	0.628	56958000.0
2001-07-24 13:00:00	AMZN	Stock	0.6275	0.631	0.613	0.613	55646000.0
2001-07-24 14:00:00	AMZN	Stock	0.6135	0.614	0.595	0.6055	67118000.0
2001-07-24 15:00:00	AMZN	Stock	0.605	0.6125	0.596	0.6035	55536000.0
2001-07-24 16:00:00	AMZN	Stock	0.603	0.6865	0.603	0.6075	4792000.0
2001-07-24 17:00:00	AMZN	Stock	0.61	0.617	0.603	0.617	406000.0
2001-07-24 18:00:00	AMZN	Stock	0.615	0.615	0.6125	0.614	126000.0
2001-07-24 09:00:00	CL	Stock	27.25	27.25	26.925	26.975	554400.0
2001-07-24 10:00:00	CL	Stock	26.97	27.075	26.86	27.025	663800.0
2001-07-24 11:00:00	CL	Stock	27.045	27.115	26.995	27.04	279000.0
2001-07-24 12:00:00	CL	Stock	27.045	27.09	27.0	27.09	440800.0
2001-07-24 13:00:00	CL	Stock	27.09	27.295	27.09	27.1	489400.0
2001-07-24 14:00:00	CL	Stock	27.11	27.2	27.025	27.115	386800.0

> showing 50 of 17,262 rows — these rows as CSV

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