PREVIEW / stock_1hour / 2002-01-02

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-01-02.parquet
  size:    400 KB
  rows:    18,766
  symbols: 1,349

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-01-02 08:00:00	AAPL	Stock	0.395	0.395	0.3911	0.395	3438400.0
2002-01-02 09:00:00	AAPL	Stock	0.3955	0.4009	0.3936	0.3959	49156800.0
2002-01-02 10:00:00	AAPL	Stock	0.3955	0.3982	0.3921	0.3966	56263200.0
2002-01-02 11:00:00	AAPL	Stock	0.3964	0.4071	0.3961	0.403	57635200.0
2002-01-02 12:00:00	AAPL	Stock	0.4036	0.4063	0.4013	0.4023	39704000.0
2002-01-02 13:00:00	AAPL	Stock	0.4023	0.4059	0.4014	0.4041	25872000.0
2002-01-02 14:00:00	AAPL	Stock	0.4041	0.4088	0.4018	0.4055	54852000.0
2002-01-02 15:00:00	AAPL	Stock	0.4056	0.4161	0.4054	0.4152	169041600.0
2002-01-02 16:00:00	AAPL	Stock	0.4161	0.4166	0.4094	0.4161	9144800.0
2002-01-02 17:00:00	AAPL	Stock	0.416	0.416	0.4148	0.4154	834400.0
2002-01-02 18:00:00	AAPL	Stock	0.4147	0.4164	0.4147	0.4164	1792000.0
2002-01-02 08:00:00	MSFT	Stock	33.175	33.3005	33.125	33.3	184200.0
2002-01-02 09:00:00	MSFT	Stock	33.3	33.46	33.025	33.095	5883000.0
2002-01-02 10:00:00	MSFT	Stock	33.095	33.355	32.925	33.095	8562000.0
2002-01-02 11:00:00	MSFT	Stock	33.09	33.2	32.88	32.88	5784400.0
2002-01-02 12:00:00	MSFT	Stock	32.885	32.99	32.83	32.9145	4221600.0
2002-01-02 13:00:00	MSFT	Stock	32.91	33.12	32.755	33.095	5161000.0
2002-01-02 14:00:00	MSFT	Stock	33.09	33.25	32.825	32.91	6106800.0
2002-01-02 15:00:00	MSFT	Stock	32.91	33.555	32.86	33.525	9219400.0
2002-01-02 16:00:00	MSFT	Stock	33.525	33.575	33.0672	33.52	1844200.0
2002-01-02 17:00:00	MSFT	Stock	33.518	33.575	33.4198	33.55	256800.0
2002-01-02 08:00:00	NVDA	Stock	0.5584	0.5646	0.5575	0.5621	42060000.0
2002-01-02 09:00:00	NVDA	Stock	0.5614	0.5634	0.5542	0.5607	163080000.0
2002-01-02 10:00:00	NVDA	Stock	0.5607	0.5704	0.5592	0.5617	269688000.0
2002-01-02 11:00:00	NVDA	Stock	0.5617	0.5618	0.5552	0.5553	145392000.0
2002-01-02 12:00:00	NVDA	Stock	0.556	0.556	0.5487	0.5511	125844000.0
2002-01-02 13:00:00	NVDA	Stock	0.5511	0.5571	0.5458	0.5564	155952000.0
2002-01-02 14:00:00	NVDA	Stock	0.5567	0.5592	0.5501	0.5508	143736000.0
2002-01-02 15:00:00	NVDA	Stock	0.5508	0.5629	0.5492	0.5608	184608000.0
2002-01-02 16:00:00	NVDA	Stock	0.5608	0.562	0.5522	0.5608	14736000.0
2002-01-02 17:00:00	NVDA	Stock	0.5613	0.5613	0.5605	0.5605	3504000.0
2002-01-02 18:00:00	NVDA	Stock	0.5602	0.5608	0.5602	0.5608	1608000.0
2002-01-02 08:00:00	AMZN	Stock	0.5465	0.551	0.54	0.55	606000.0
2002-01-02 09:00:00	AMZN	Stock	0.55	0.55	0.535	0.5415	14298000.0
2002-01-02 10:00:00	AMZN	Stock	0.5415	0.55	0.537	0.539	17878000.0
2002-01-02 11:00:00	AMZN	Stock	0.539	0.542	0.538	0.539	7524000.0
2002-01-02 12:00:00	AMZN	Stock	0.5386	0.541	0.5285	0.529	20062000.0
2002-01-02 13:00:00	AMZN	Stock	0.5295	0.533	0.5245	0.5315	15024000.0
2002-01-02 14:00:00	AMZN	Stock	0.5314	0.532	0.5255	0.528	12736000.0
2002-01-02 15:00:00	AMZN	Stock	0.5275	0.5475	0.525	0.547	21796000.0
2002-01-02 16:00:00	AMZN	Stock	0.5475	0.548	0.5375	0.546	14110000.0
2002-01-02 17:00:00	AMZN	Stock	0.548	0.548	0.5425	0.5435	248000.0
2002-01-02 18:00:00	AMZN	Stock	0.545	0.545	0.5425	0.5425	36000.0
2002-01-02 09:00:00	CL	Stock	28.625	28.63	28.325	28.395	353400.0
2002-01-02 10:00:00	CL	Stock	28.395	28.545	28.35	28.425	444600.0
2002-01-02 11:00:00	CL	Stock	28.42	28.49	28.375	28.455	283400.0
2002-01-02 12:00:00	CL	Stock	28.445	28.625	28.425	28.6	218000.0
2002-01-02 13:00:00	CL	Stock	28.575	28.77	28.555	28.77	172800.0
2002-01-02 14:00:00	CL	Stock	28.75	28.8	28.675	28.735	263600.0
2002-01-02 15:00:00	CL	Stock	28.71	28.875	28.625	28.78	476400.0

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

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