PREVIEW / stock_1hour / 2001-06-19

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-06-19.parquet
  size:    350 KB
  rows:    16,893
  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-06-19 08:00:00	AAPL	Stock	0.363	0.3795	0.363	0.3768	576800.0
2001-06-19 09:00:00	AAPL	Stock	0.3768	0.3786	0.3707	0.3763	58514400.0
2001-06-19 10:00:00	AAPL	Stock	0.3763	0.3821	0.3757	0.3763	76552000.0
2001-06-19 11:00:00	AAPL	Stock	0.3763	0.3773	0.3713	0.3763	30794400.0
2001-06-19 12:00:00	AAPL	Stock	0.3763	0.3798	0.3754	0.3764	23648800.0
2001-06-19 13:00:00	AAPL	Stock	0.3766	0.3786	0.3675	0.3704	23648800.0
2001-06-19 14:00:00	AAPL	Stock	0.3702	0.3711	0.3598	0.3611	44044000.0
2001-06-19 15:00:00	AAPL	Stock	0.3607	0.3638	0.3573	0.3605	45024000.0
2001-06-19 16:00:00	AAPL	Stock	0.3602	0.3734	0.3571	0.3589	4799200.0
2001-06-19 08:00:00	MSFT	Stock	34.005	34.25	33.875	34.05	317600.0
2001-06-19 09:00:00	MSFT	Stock	34.05	34.385	33.875	34.205	12228200.0
2001-06-19 10:00:00	MSFT	Stock	34.205	34.425	34.045	34.2	12119000.0
2001-06-19 11:00:00	MSFT	Stock	34.15	34.315	33.92	34.315	8901800.0
2001-06-19 12:00:00	MSFT	Stock	34.315	34.395	34.175	34.175	3851400.0
2001-06-19 13:00:00	MSFT	Stock	34.175	34.345	34.06	34.075	4596400.0
2001-06-19 14:00:00	MSFT	Stock	34.085	34.13	33.6	33.665	7558800.0
2001-06-19 15:00:00	MSFT	Stock	33.67	33.79	33.45	33.66	7577200.0
2001-06-19 16:00:00	MSFT	Stock	33.655	34.305	33.53	33.625	2316800.0
2001-06-19 17:00:00	MSFT	Stock	33.55	33.6	33.51	33.6	9200.0
2001-06-19 18:00:00	MSFT	Stock	33.675	33.675	33.555	33.555	800.0
2001-06-19 08:00:00	NVDA	Stock	0.3896	0.3917	0.3892	0.3902	1248000.0
2001-06-19 09:00:00	NVDA	Stock	0.3897	0.3966	0.3858	0.3929	174792000.0
2001-06-19 10:00:00	NVDA	Stock	0.3929	0.3948	0.3667	0.369	287808000.0
2001-06-19 11:00:00	NVDA	Stock	0.3688	0.3712	0.3607	0.3671	325800000.0
2001-06-19 12:00:00	NVDA	Stock	0.3667	0.37	0.3648	0.3667	102528000.0
2001-06-19 13:00:00	NVDA	Stock	0.3667	0.3678	0.3567	0.3567	119568000.0
2001-06-19 14:00:00	NVDA	Stock	0.3567	0.3605	0.3543	0.3565	175344000.0
2001-06-19 15:00:00	NVDA	Stock	0.3568	0.3603	0.3519	0.3596	233376000.0
2001-06-19 16:00:00	NVDA	Stock	0.3596	0.3601	0.3563	0.3596	12600000.0
2001-06-19 17:00:00	NVDA	Stock	0.3583	0.3601	0.3583	0.3588	312000.0
2001-06-19 18:00:00	NVDA	Stock	0.3601	0.3601	0.3588	0.3588	72000.0
2001-06-19 08:00:00	AMZN	Stock	0.608	0.625	0.608	0.615	140000.0
2001-06-19 09:00:00	AMZN	Stock	0.6225	0.6325	0.6125	0.6155	17184000.0
2001-06-19 10:00:00	AMZN	Stock	0.615	0.623	0.6035	0.6085	20006000.0
2001-06-19 11:00:00	AMZN	Stock	0.6095	0.62	0.5855	0.5925	25604000.0
2001-06-19 12:00:00	AMZN	Stock	0.5925	0.5925	0.582	0.5855	12048000.0
2001-06-19 13:00:00	AMZN	Stock	0.5855	0.59	0.5835	0.585	9064000.0
2001-06-19 14:00:00	AMZN	Stock	0.5835	0.5875	0.5705	0.5725	13270000.0
2001-06-19 15:00:00	AMZN	Stock	0.5735	0.576	0.56	0.5685	15556000.0
2001-06-19 16:00:00	AMZN	Stock	0.5685	0.575	0.5675	0.5715	2490000.0
2001-06-19 17:00:00	AMZN	Stock	0.57	0.57	0.57	0.57	10000.0
2001-06-19 18:00:00	AMZN	Stock	0.575	0.576	0.5675	0.5675	62000.0
2001-06-19 09:00:00	CL	Stock	28.95	29.125	28.9	28.98	312400.0
2001-06-19 10:00:00	CL	Stock	28.975	29.025	28.795	28.8	238000.0
2001-06-19 11:00:00	CL	Stock	28.8	28.99	28.745	28.975	270600.0
2001-06-19 12:00:00	CL	Stock	28.975	29.075	28.95	28.995	223000.0
2001-06-19 13:00:00	CL	Stock	29.0	29.075	29.0	29.075	484400.0
2001-06-19 14:00:00	CL	Stock	29.07	29.155	29.015	29.02	554600.0
2001-06-19 15:00:00	CL	Stock	29.02	29.115	29.0	29.09	542800.0
2001-06-19 16:00:00	CL	Stock	29.09	29.09	29.09	29.09	54600.0

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

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