PREVIEW / stock_1hour / 2001-06-07

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-06-07.parquet
  size:    356 KB
  rows:    16,694
  symbols: 1,297

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-07 09:00:00	AAPL	Stock	0.3709	0.3725	0.3652	0.3691	24483200.0
2001-06-07 10:00:00	AAPL	Stock	0.3691	0.3821	0.3679	0.3786	77050400.0
2001-06-07 11:00:00	AAPL	Stock	0.3786	0.3796	0.3755	0.378	32552800.0
2001-06-07 12:00:00	AAPL	Stock	0.378	0.3786	0.3736	0.3763	23010400.0
2001-06-07 13:00:00	AAPL	Stock	0.3763	0.3816	0.375	0.3805	26297600.0
2001-06-07 14:00:00	AAPL	Stock	0.3804	0.3839	0.3782	0.3795	35677600.0
2001-06-07 15:00:00	AAPL	Stock	0.3795	0.3875	0.3795	0.387	73959200.0
2001-06-07 16:00:00	AAPL	Stock	0.387	0.3964	0.3788	0.3964	9161600.0
2001-06-07 17:00:00	AAPL	Stock	0.3943	0.3968	0.3875	0.3875	823200.0
2001-06-07 08:00:00	MSFT	Stock	36.1	36.175	35.99	36.05	774000.0
2001-06-07 09:00:00	MSFT	Stock	36.18	36.445	36.02	36.335	7953800.0
2001-06-07 10:00:00	MSFT	Stock	36.325	36.64	36.245	36.45	11462600.0
2001-06-07 11:00:00	MSFT	Stock	36.455	36.55	36.405	36.47	5425200.0
2001-06-07 12:00:00	MSFT	Stock	36.47	36.48	36.33	36.42	4017200.0
2001-06-07 13:00:00	MSFT	Stock	36.415	36.745	36.375	36.725	8672600.0
2001-06-07 14:00:00	MSFT	Stock	36.725	36.78	36.565	36.68	7369800.0
2001-06-07 15:00:00	MSFT	Stock	36.685	36.865	36.58	36.84	10741400.0
2001-06-07 16:00:00	MSFT	Stock	36.845	37.25	36.395	37.15	6612200.0
2001-06-07 17:00:00	MSFT	Stock	37.185	37.375	36.695	37.35	265200.0
2001-06-07 18:00:00	MSFT	Stock	37.26	37.495	37.15	37.375	21200.0
2001-06-07 08:00:00	NVDA	Stock	0.3903	0.3904	0.3894	0.3896	312000.0
2001-06-07 09:00:00	NVDA	Stock	0.3904	0.4013	0.3854	0.4004	125016000.0
2001-06-07 10:00:00	NVDA	Stock	0.4001	0.411	0.4	0.4068	271320000.0
2001-06-07 11:00:00	NVDA	Stock	0.4068	0.4094	0.4034	0.4048	110016000.0
2001-06-07 12:00:00	NVDA	Stock	0.4048	0.4048	0.4017	0.4031	82224000.0
2001-06-07 13:00:00	NVDA	Stock	0.4033	0.4085	0.4005	0.4082	110184000.0
2001-06-07 14:00:00	NVDA	Stock	0.4081	0.4106	0.4058	0.4085	159624000.0
2001-06-07 15:00:00	NVDA	Stock	0.4085	0.415	0.4073	0.4139	216984000.0
2001-06-07 16:00:00	NVDA	Stock	0.4138	0.42	0.4022	0.4169	26136000.0
2001-06-07 17:00:00	NVDA	Stock	0.4172	0.421	0.417	0.4208	2328000.0
2001-06-07 18:00:00	NVDA	Stock	0.4208	0.4208	0.4188	0.42	360000.0
2001-06-07 08:00:00	AMZN	Stock	0.7995	0.7995	0.7995	0.7995	54000.0
2001-06-07 09:00:00	AMZN	Stock	0.794	0.8115	0.775	0.805	11664000.0
2001-06-07 10:00:00	AMZN	Stock	0.806	0.81	0.795	0.7965	9622000.0
2001-06-07 11:00:00	AMZN	Stock	0.7965	0.797	0.787	0.7915	9070000.0
2001-06-07 12:00:00	AMZN	Stock	0.7905	0.7925	0.7845	0.7905	8834000.0
2001-06-07 13:00:00	AMZN	Stock	0.79	0.8015	0.789	0.8015	8022000.0
2001-06-07 14:00:00	AMZN	Stock	0.8015	0.803	0.795	0.799	5274000.0
2001-06-07 15:00:00	AMZN	Stock	0.7965	0.8075	0.795	0.807	10870000.0
2001-06-07 16:00:00	AMZN	Stock	0.806	0.8095	0.7895	0.8065	2036000.0
2001-06-07 17:00:00	AMZN	Stock	0.809	0.8125	0.8065	0.8065	230000.0
2001-06-07 18:00:00	AMZN	Stock	0.8075	0.8115	0.8075	0.8075	32000.0
2001-06-07 09:00:00	CL	Stock	29.35	29.42	29.3	29.3	281400.0
2001-06-07 10:00:00	CL	Stock	29.32	29.495	29.305	29.475	353000.0
2001-06-07 11:00:00	CL	Stock	29.475	29.475	29.325	29.325	255400.0
2001-06-07 12:00:00	CL	Stock	29.325	29.39	29.28	29.345	219600.0
2001-06-07 13:00:00	CL	Stock	29.335	29.575	29.31	29.49	424400.0
2001-06-07 14:00:00	CL	Stock	29.49	29.5	29.4	29.49	266200.0
2001-06-07 15:00:00	CL	Stock	29.46	29.625	29.365	29.38	689400.0
2001-06-07 16:00:00	CL	Stock	29.375	29.38	29.375	29.375	44400.0

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

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