PREVIEW / stock_1hour / 2005-02-24

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-02-24.parquet
  size:    542 KB
  rows:    25,674
  symbols: 1,937

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
2005-02-24 08:00:00	AAPL	Stock	1.5771	1.582	1.5643	1.5671	9481808.0
2005-02-24 09:00:00	AAPL	Stock	1.5661	1.5918	1.5646	1.5757	237919024.0
2005-02-24 10:00:00	AAPL	Stock	1.5757	1.5948	1.5711	1.5821	289903040.0
2005-02-24 11:00:00	AAPL	Stock	1.5821	1.5938	1.5789	1.5863	117524344.0
2005-02-24 12:00:00	AAPL	Stock	1.5859	1.5859	1.567	1.578	171292128.0
2005-02-24 13:00:00	AAPL	Stock	1.5779	1.5864	1.5696	1.5816	123868248.0
2005-02-24 14:00:00	AAPL	Stock	1.582	1.5921	1.5786	1.582	357489272.0
2005-02-24 15:00:00	AAPL	Stock	1.582	1.5904	1.5805	1.5875	198176608.0
2005-02-24 16:00:00	AAPL	Stock	1.5875	1.5893	1.5857	1.5889	6522936.0
2005-02-24 17:00:00	AAPL	Stock	1.588	1.5905	1.5871	1.5871	896112.0
2005-02-24 18:00:00	AAPL	Stock	1.5889	1.5889	1.5857	1.5884	181664.0
2005-02-24 08:00:00	MSFT	Stock	25.18	25.2	25.15	25.17	18727.0
2005-02-24 09:00:00	MSFT	Stock	25.17	25.34	25.14	25.33	10701814.0
2005-02-24 10:00:00	MSFT	Stock	25.33	25.38	25.25	25.261	13798732.0
2005-02-24 11:00:00	MSFT	Stock	25.25	25.3	25.2	25.22	9945904.0
2005-02-24 12:00:00	MSFT	Stock	25.23	25.24	25.179	25.2	8105076.0
2005-02-24 13:00:00	MSFT	Stock	25.2	25.38	25.19	25.321	11120008.0
2005-02-24 14:00:00	MSFT	Stock	25.33	25.44	25.32	25.41	11071973.0
2005-02-24 15:00:00	MSFT	Stock	25.4	25.44	25.31	25.37	12757157.0
2005-02-24 16:00:00	MSFT	Stock	25.36	25.45	25.36	25.45	1775286.0
2005-02-24 17:00:00	MSFT	Stock	25.4	25.47	25.36	25.41	221974.0
2005-02-24 18:00:00	MSFT	Stock	25.37	25.42	25.37	25.42	10180.0
2005-02-24 08:00:00	NVDA	Stock	0.23	0.23	0.23	0.23	60000.0
2005-02-24 09:00:00	NVDA	Stock	0.2289	0.2359	0.2274	0.2318	154601040.0
2005-02-24 10:00:00	NVDA	Stock	0.2317	0.2355	0.2307	0.2338	135542040.0
2005-02-24 11:00:00	NVDA	Stock	0.2338	0.235	0.2329	0.2334	102639840.0
2005-02-24 12:00:00	NVDA	Stock	0.2335	0.2335	0.2307	0.2317	60617160.0
2005-02-24 13:00:00	NVDA	Stock	0.2317	0.2346	0.2312	0.2336	47981760.0
2005-02-24 14:00:00	NVDA	Stock	0.2336	0.235	0.2335	0.2343	57438360.0
2005-02-24 15:00:00	NVDA	Stock	0.2344	0.2372	0.2327	0.2369	131207040.0
2005-02-24 16:00:00	NVDA	Stock	0.2367	0.237	0.233	0.2359	3082800.0
2005-02-24 17:00:00	NVDA	Stock	0.2366	0.2366	0.2366	0.2366	30000.0
2005-02-24 18:00:00	NVDA	Stock	0.2364	0.2364	0.2364	0.2364	18000.0
2005-02-24 08:00:00	AMZN	Stock	1.6985	1.6985	1.6795	1.681	455040.0
2005-02-24 09:00:00	AMZN	Stock	1.6825	1.717	1.6825	1.693	32428340.0
2005-02-24 10:00:00	AMZN	Stock	1.6925	1.706	1.683	1.6845	30579660.0
2005-02-24 11:00:00	AMZN	Stock	1.684	1.6975	1.683	1.694	14670520.0
2005-02-24 12:00:00	AMZN	Stock	1.6935	1.698	1.6895	1.6955	10805380.0
2005-02-24 13:00:00	AMZN	Stock	1.6955	1.717	1.6915	1.715	19066760.0
2005-02-24 14:00:00	AMZN	Stock	1.715	1.7425	1.714	1.724	31520220.0
2005-02-24 15:00:00	AMZN	Stock	1.724	1.736	1.7225	1.735	22552540.0
2005-02-24 16:00:00	AMZN	Stock	1.735	1.7365	1.7295	1.7304	1398340.0
2005-02-24 17:00:00	AMZN	Stock	1.7345	1.7395	1.7345	1.7395	216480.0
2005-02-24 18:00:00	AMZN	Stock	1.7375	1.7375	1.7315	1.7315	16000.0
2005-02-24 09:00:00	CL	Stock	26.25	26.295	26.13	26.18	332800.0
2005-02-24 10:00:00	CL	Stock	26.175	26.33	26.04	26.255	772000.0
2005-02-24 11:00:00	CL	Stock	26.26	26.36	26.255	26.305	304400.0
2005-02-24 12:00:00	CL	Stock	26.3	26.325	26.26	26.32	361800.0
2005-02-24 13:00:00	CL	Stock	26.325	26.33	26.25	26.255	356200.0
2005-02-24 14:00:00	CL	Stock	26.255	26.34	26.255	26.33	433000.0

> showing 50 of 25,674 rows — these rows as CSV

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