PREVIEW / stock_1hour / 2001-05-02

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-05-02.parquet
  size:    355 KB
  rows:    16,601
  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-05-02 08:00:00	AAPL	Stock	0.463	0.4673	0.463	0.4643	896000.0
2001-05-02 09:00:00	AAPL	Stock	0.467	0.4755	0.4657	0.4673	46972800.0
2001-05-02 10:00:00	AAPL	Stock	0.4675	0.4716	0.46	0.4657	83512800.0
2001-05-02 11:00:00	AAPL	Stock	0.465	0.4673	0.4607	0.4648	58452800.0
2001-05-02 12:00:00	AAPL	Stock	0.465	0.4759	0.4648	0.4671	45544800.0
2001-05-02 13:00:00	AAPL	Stock	0.467	0.4741	0.4655	0.4736	22898400.0
2001-05-02 14:00:00	AAPL	Stock	0.4732	0.4768	0.4689	0.4725	31640000.0
2001-05-02 15:00:00	AAPL	Stock	0.4721	0.4763	0.4661	0.4746	40090400.0
2001-05-02 16:00:00	AAPL	Stock	0.4746	0.4748	0.4689	0.4748	9413600.0
2001-05-02 17:00:00	AAPL	Stock	0.4743	0.4743	0.4743	0.4743	5600.0
2001-05-02 08:00:00	MSFT	Stock	35.05	35.855	35.05	35.525	981400.0
2001-05-02 09:00:00	MSFT	Stock	35.525	35.625	34.97	35.125	14123200.0
2001-05-02 10:00:00	MSFT	Stock	35.15	35.175	34.75	34.88	15168000.0
2001-05-02 11:00:00	MSFT	Stock	34.86	35.0	34.675	34.97	6752200.0
2001-05-02 12:00:00	MSFT	Stock	34.97	35.25	34.88	34.92	7745600.0
2001-05-02 13:00:00	MSFT	Stock	34.92	35.26	34.86	35.2	7335600.0
2001-05-02 14:00:00	MSFT	Stock	35.2	35.5	35.005	35.35	9873800.0
2001-05-02 15:00:00	MSFT	Stock	35.355	35.47	34.68	34.88	21867200.0
2001-05-02 16:00:00	MSFT	Stock	34.88	35.5	34.78	35.44	1998600.0
2001-05-02 17:00:00	MSFT	Stock	35.015	35.015	34.805	34.825	110600.0
2001-05-02 08:00:00	NVDA	Stock	0.3792	0.3888	0.3792	0.3881	5280000.0
2001-05-02 09:00:00	NVDA	Stock	0.3876	0.3896	0.3698	0.3801	336576000.0
2001-05-02 10:00:00	NVDA	Stock	0.374	0.3802	0.3713	0.3764	247152000.0
2001-05-02 11:00:00	NVDA	Stock	0.3764	0.3771	0.3704	0.3718	186336000.0
2001-05-02 12:00:00	NVDA	Stock	0.3717	0.3748	0.3683	0.373	89568000.0
2001-05-02 13:00:00	NVDA	Stock	0.373	0.3778	0.3719	0.3775	108000000.0
2001-05-02 14:00:00	NVDA	Stock	0.3771	0.3833	0.3735	0.3776	181680000.0
2001-05-02 15:00:00	NVDA	Stock	0.3775	0.3783	0.3658	0.3708	232344000.0
2001-05-02 16:00:00	NVDA	Stock	0.3706	0.3755	0.3703	0.3724	8544000.0
2001-05-02 17:00:00	NVDA	Stock	0.3724	0.3725	0.3708	0.3708	336000.0
2001-05-02 18:00:00	NVDA	Stock	0.3705	0.3705	0.3705	0.3705	24000.0
2001-05-02 08:00:00	AMZN	Stock	0.86	0.875	0.856	0.863	140000.0
2001-05-02 09:00:00	AMZN	Stock	0.865	0.865	0.8495	0.8545	21882000.0
2001-05-02 10:00:00	AMZN	Stock	0.855	0.8615	0.845	0.854	24706000.0
2001-05-02 11:00:00	AMZN	Stock	0.851	0.857	0.842	0.8495	14548000.0
2001-05-02 12:00:00	AMZN	Stock	0.8495	0.8525	0.846	0.847	16424000.0
2001-05-02 13:00:00	AMZN	Stock	0.8465	0.857	0.8455	0.855	14178000.0
2001-05-02 14:00:00	AMZN	Stock	0.8545	0.8625	0.853	0.858	18298000.0
2001-05-02 15:00:00	AMZN	Stock	0.8585	0.8715	0.848	0.856	24240000.0
2001-05-02 16:00:00	AMZN	Stock	0.856	0.856	0.8525	0.8555	1412000.0
2001-05-02 17:00:00	AMZN	Stock	0.8555	0.8555	0.8555	0.8555	30000.0
2001-05-02 09:00:00	CL	Stock	28.125	28.13	27.6	27.775	418600.0
2001-05-02 10:00:00	CL	Stock	27.755	27.965	27.755	27.965	345000.0
2001-05-02 11:00:00	CL	Stock	27.975	27.975	27.8	27.865	274600.0
2001-05-02 12:00:00	CL	Stock	27.875	28.06	27.855	28.02	387000.0
2001-05-02 13:00:00	CL	Stock	28.02	28.13	27.915	28.09	210600.0
2001-05-02 14:00:00	CL	Stock	28.11	28.35	28.1	28.175	479600.0
2001-05-02 15:00:00	CL	Stock	28.15	28.215	27.99	28.035	754200.0
2001-05-02 16:00:00	CL	Stock	28.035	28.035	28.0	28.0	1645600.0
2001-05-02 17:00:00	CL	Stock	27.985	27.985	27.985	27.985	12400.0

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

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