PREVIEW / stock_1hour / 2002-04-03

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-04-03.parquet
  size:    398 KB
  rows:    18,799
  symbols: 1,405

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
2002-04-03 08:00:00	AAPL	Stock	0.43	0.433	0.43	0.433	218400.0
2002-04-03 09:00:00	AAPL	Stock	0.433	0.4373	0.4245	0.4366	28487200.0
2002-04-03 10:00:00	AAPL	Stock	0.4364	0.4366	0.4241	0.427	32541600.0
2002-04-03 11:00:00	AAPL	Stock	0.427	0.4271	0.4246	0.4259	14750400.0
2002-04-03 12:00:00	AAPL	Stock	0.4261	0.4266	0.4223	0.4239	19880000.0
2002-04-03 13:00:00	AAPL	Stock	0.4241	0.4255	0.4223	0.4232	20714400.0
2002-04-03 14:00:00	AAPL	Stock	0.4232	0.4241	0.4214	0.4225	18816000.0
2002-04-03 15:00:00	AAPL	Stock	0.4225	0.425	0.4214	0.4239	51760800.0
2002-04-03 16:00:00	AAPL	Stock	0.4241	0.4304	0.4191	0.4241	23755200.0
2002-04-03 17:00:00	AAPL	Stock	0.4284	0.4284	0.4241	0.4261	78400.0
2002-04-03 08:00:00	MSFT	Stock	28.755	28.81	28.635	28.8	171000.0
2002-04-03 09:00:00	MSFT	Stock	28.795	28.82	28.4945	28.675	9569000.0
2002-04-03 10:00:00	MSFT	Stock	28.685	28.7	28.05	28.155	12810000.0
2002-04-03 11:00:00	MSFT	Stock	28.155	28.2	27.93	28.025	10958000.0
2002-04-03 12:00:00	MSFT	Stock	28.0	28.09	27.915	28.07	6515000.0
2002-04-03 13:00:00	MSFT	Stock	28.07	28.225	27.945	27.99	6973200.0
2002-04-03 14:00:00	MSFT	Stock	27.9895	28.1005	27.805	27.8705	10129000.0
2002-04-03 15:00:00	MSFT	Stock	27.8745	28.175	27.75	28.17	12871800.0
2002-04-03 16:00:00	MSFT	Stock	28.17	28.5	27.895	28.355	3921800.0
2002-04-03 17:00:00	MSFT	Stock	28.35	28.465	28.165	28.415	66000.0
2002-04-03 18:00:00	MSFT	Stock	28.415	28.415	28.15	28.35	37600.0
2002-04-03 08:00:00	NVDA	Stock	0.3577	0.3582	0.353	0.3577	924000.0
2002-04-03 09:00:00	NVDA	Stock	0.3577	0.3611	0.3417	0.3593	178140000.0
2002-04-03 10:00:00	NVDA	Stock	0.3593	0.3607	0.3483	0.3527	219000000.0
2002-04-03 11:00:00	NVDA	Stock	0.3524	0.3578	0.3496	0.3529	115692000.0
2002-04-03 12:00:00	NVDA	Stock	0.353	0.358	0.3521	0.358	70644000.0
2002-04-03 13:00:00	NVDA	Stock	0.3576	0.3653	0.3568	0.3612	182316000.0
2002-04-03 14:00:00	NVDA	Stock	0.3611	0.3624	0.3559	0.3593	117468000.0
2002-04-03 15:00:00	NVDA	Stock	0.359	0.3617	0.3567	0.3607	152952000.0
2002-04-03 16:00:00	NVDA	Stock	0.3607	0.3646	0.3541	0.3645	16356000.0
2002-04-03 17:00:00	NVDA	Stock	0.3642	0.3646	0.3607	0.3637	432000.0
2002-04-03 18:00:00	NVDA	Stock	0.3642	0.3647	0.3642	0.3647	84000.0
2002-04-03 08:00:00	AMZN	Stock	0.715	0.7175	0.715	0.7175	60000.0
2002-04-03 09:00:00	AMZN	Stock	0.7175	0.7225	0.703	0.72	13232000.0
2002-04-03 10:00:00	AMZN	Stock	0.721	0.721	0.7025	0.7085	14034000.0
2002-04-03 11:00:00	AMZN	Stock	0.708	0.709	0.6975	0.7035	14664000.0
2002-04-03 12:00:00	AMZN	Stock	0.7035	0.704	0.6925	0.7	9586000.0
2002-04-03 13:00:00	AMZN	Stock	0.7	0.7055	0.696	0.697	6346000.0
2002-04-03 14:00:00	AMZN	Stock	0.697	0.7005	0.683	0.687	9568000.0
2002-04-03 15:00:00	AMZN	Stock	0.686	0.694	0.68	0.6835	19462000.0
2002-04-03 16:00:00	AMZN	Stock	0.685	0.7008	0.683	0.686	2396000.0
2002-04-03 17:00:00	AMZN	Stock	0.6925	0.6925	0.6835	0.6835	74000.0
2002-04-03 09:00:00	CL	Stock	28.35	28.4	28.25	28.295	184800.0
2002-04-03 10:00:00	CL	Stock	28.31	28.35	28.04	28.05	449200.0
2002-04-03 11:00:00	CL	Stock	28.065	28.075	28.01	28.07	301600.0
2002-04-03 12:00:00	CL	Stock	28.08	28.21	28.065	28.185	157200.0
2002-04-03 13:00:00	CL	Stock	28.185	28.25	28.15	28.21	247400.0
2002-04-03 14:00:00	CL	Stock	28.21	28.28	28.165	28.175	267400.0
2002-04-03 15:00:00	CL	Stock	28.19	28.255	28.14	28.23	764800.0
2002-04-03 16:00:00	CL	Stock	28.23	28.24	28.23	28.24	150000.0

> showing 50 of 18,799 rows — these rows as CSV

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