PREVIEW / stock_1hour / 2001-06-13

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-06-13.parquet
  size:    358 KB
  rows:    16,967
  symbols: 1,299

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-13 08:00:00	AAPL	Stock	0.3705	0.3821	0.3625	0.3786	2408000.0
2001-06-13 09:00:00	AAPL	Stock	0.3786	0.388	0.3625	0.3836	152896800.0
2001-06-13 10:00:00	AAPL	Stock	0.3838	0.385	0.3713	0.3825	76367200.0
2001-06-13 11:00:00	AAPL	Stock	0.3825	0.388	0.3804	0.3838	37973600.0
2001-06-13 12:00:00	AAPL	Stock	0.3843	0.387	0.3777	0.3779	27378400.0
2001-06-13 13:00:00	AAPL	Stock	0.3777	0.3796	0.3725	0.3734	26728800.0
2001-06-13 14:00:00	AAPL	Stock	0.3732	0.3754	0.3607	0.3643	65777600.0
2001-06-13 15:00:00	AAPL	Stock	0.3643	0.3688	0.3582	0.3655	76921600.0
2001-06-13 16:00:00	AAPL	Stock	0.3655	0.3668	0.3648	0.3655	8646400.0
2001-06-13 17:00:00	AAPL	Stock	0.3657	0.3661	0.3621	0.3661	257600.0
2001-06-13 18:00:00	AAPL	Stock	0.3625	0.3625	0.3625	0.3625	11200.0
2001-06-13 08:00:00	MSFT	Stock	36.025	36.475	36.025	36.245	75200.0
2001-06-13 09:00:00	MSFT	Stock	36.2	36.2	35.795	36.055	10086800.0
2001-06-13 10:00:00	MSFT	Stock	36.055	36.08	35.595	35.835	9757800.0
2001-06-13 11:00:00	MSFT	Stock	35.845	35.97	35.66	35.895	5666600.0
2001-06-13 12:00:00	MSFT	Stock	35.895	36.025	35.75	35.785	3687800.0
2001-06-13 13:00:00	MSFT	Stock	35.785	35.855	35.55	35.65	2994000.0
2001-06-13 14:00:00	MSFT	Stock	35.67	35.69	35.475	35.6	6838000.0
2001-06-13 15:00:00	MSFT	Stock	35.59	35.625	35.32	35.35	11155400.0
2001-06-13 16:00:00	MSFT	Stock	35.375	35.74	35.31	35.345	1778000.0
2001-06-13 17:00:00	MSFT	Stock	35.345	35.475	35.33	35.45	38600.0
2001-06-13 18:00:00	MSFT	Stock	35.475	35.55	35.31	35.31	30600.0
2001-06-13 08:00:00	NVDA	Stock	0.4052	0.4094	0.4021	0.4083	624000.0
2001-06-13 09:00:00	NVDA	Stock	0.4075	0.4135	0.4052	0.4108	157776000.0
2001-06-13 10:00:00	NVDA	Stock	0.41	0.4117	0.4008	0.406	204816000.0
2001-06-13 11:00:00	NVDA	Stock	0.406	0.4104	0.4043	0.4083	116184000.0
2001-06-13 12:00:00	NVDA	Stock	0.4083	0.4103	0.4046	0.4058	69312000.0
2001-06-13 13:00:00	NVDA	Stock	0.4058	0.4058	0.3938	0.3947	108552000.0
2001-06-13 14:00:00	NVDA	Stock	0.3946	0.3997	0.394	0.3956	110400000.0
2001-06-13 15:00:00	NVDA	Stock	0.3956	0.3975	0.3873	0.3908	132120000.0
2001-06-13 16:00:00	NVDA	Stock	0.3908	0.3908	0.3875	0.3908	9648000.0
2001-06-13 17:00:00	NVDA	Stock	0.3908	0.3908	0.3876	0.3876	504000.0
2001-06-13 08:00:00	AMZN	Stock	0.7315	0.7475	0.7315	0.7475	686000.0
2001-06-13 09:00:00	AMZN	Stock	0.7475	0.754	0.725	0.751	9784000.0
2001-06-13 10:00:00	AMZN	Stock	0.75	0.7575	0.7425	0.75	10874000.0
2001-06-13 11:00:00	AMZN	Stock	0.7505	0.7555	0.7475	0.753	6722000.0
2001-06-13 12:00:00	AMZN	Stock	0.753	0.7575	0.7475	0.748	5206000.0
2001-06-13 13:00:00	AMZN	Stock	0.748	0.75	0.7395	0.74	9070000.0
2001-06-13 14:00:00	AMZN	Stock	0.74	0.7405	0.7195	0.721	8186000.0
2001-06-13 15:00:00	AMZN	Stock	0.721	0.7265	0.7055	0.706	20322000.0
2001-06-13 16:00:00	AMZN	Stock	0.7065	0.7115	0.705	0.706	2012000.0
2001-06-13 17:00:00	AMZN	Stock	0.706	0.706	0.706	0.706	14000.0
2001-06-13 18:00:00	AMZN	Stock	0.706	0.706	0.706	0.706	6000.0
2001-06-13 09:00:00	CL	Stock	29.15	29.3	29.125	29.255	305000.0
2001-06-13 10:00:00	CL	Stock	29.255	29.3	29.2	29.285	285800.0
2001-06-13 11:00:00	CL	Stock	29.285	29.285	29.16	29.175	165000.0
2001-06-13 12:00:00	CL	Stock	29.175	29.18	29.15	29.155	201600.0
2001-06-13 13:00:00	CL	Stock	29.155	29.155	29.005	29.005	274000.0
2001-06-13 14:00:00	CL	Stock	29.005	29.055	28.945	29.05	244800.0
2001-06-13 15:00:00	CL	Stock	29.05	29.05	28.9	28.965	662200.0

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

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