PREVIEW / stock_1hour / 2005-11-29

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-11-29.parquet
  size:    571 KB
  rows:    26,950
  symbols: 2,123

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-11-29 07:00:00	AAPL	Stock	2.4996	2.5014	2.4964	2.4986	47600.0
2005-11-29 08:00:00	AAPL	Stock	2.4986	2.5157	2.4964	2.5021	3789128.0
2005-11-29 09:00:00	AAPL	Stock	2.5018	2.5107	2.4732	2.4814	134389780.0
2005-11-29 10:00:00	AAPL	Stock	2.4814	2.5032	2.45	2.465	214179504.0
2005-11-29 11:00:00	AAPL	Stock	2.465	2.5068	2.4596	2.4778	78580908.0
2005-11-29 12:00:00	AAPL	Stock	2.4779	2.4804	2.425	2.4261	122847424.0
2005-11-29 13:00:00	AAPL	Stock	2.4264	2.4339	2.4054	2.4232	120639288.0
2005-11-29 14:00:00	AAPL	Stock	2.4232	2.4496	2.4214	2.4432	104822088.0
2005-11-29 15:00:00	AAPL	Stock	2.4436	2.4532	2.4275	2.4329	95348540.0
2005-11-29 16:00:00	AAPL	Stock	2.4321	2.4346	2.4218	2.4268	2028152.0
2005-11-29 17:00:00	AAPL	Stock	2.4268	2.4321	2.4214	2.425	711284.0
2005-11-29 18:00:00	AAPL	Stock	2.425	2.4264	2.4232	2.4232	191352.0
2005-11-29 08:00:00	MSFT	Stock	27.8	27.83	27.73	27.75	45367.0
2005-11-29 09:00:00	MSFT	Stock	27.71	27.82	27.62	27.65	10362061.0
2005-11-29 10:00:00	MSFT	Stock	27.66	27.769	27.6	27.65	8820778.0
2005-11-29 11:00:00	MSFT	Stock	27.65	27.74	27.64	27.72	6882090.0
2005-11-29 12:00:00	MSFT	Stock	27.72	27.79	27.69	27.75	7585212.0
2005-11-29 13:00:00	MSFT	Stock	27.76	27.76	27.66	27.7	9046793.0
2005-11-29 14:00:00	MSFT	Stock	27.71	27.78	27.66	27.73	7827782.0
2005-11-29 15:00:00	MSFT	Stock	27.74	27.78	27.68	27.68	8839561.0
2005-11-29 16:00:00	MSFT	Stock	27.68	27.75	27.55	27.64	430126.0
2005-11-29 17:00:00	MSFT	Stock	27.64	27.687	27.64	27.64	16456.0
2005-11-29 18:00:00	MSFT	Stock	27.64	27.68	27.64	27.65	1930.0
2005-11-29 07:00:00	NVDA	Stock	0.3029	0.3032	0.3	0.3	630120.0
2005-11-29 08:00:00	NVDA	Stock	0.2997	0.3008	0.2967	0.2986	11278200.0
2005-11-29 09:00:00	NVDA	Stock	0.2984	0.3038	0.2943	0.3023	260896920.0
2005-11-29 10:00:00	NVDA	Stock	0.3024	0.3054	0.2967	0.2971	223268880.0
2005-11-29 11:00:00	NVDA	Stock	0.2971	0.3	0.2969	0.2992	103278360.0
2005-11-29 12:00:00	NVDA	Stock	0.2992	0.3002	0.2979	0.2982	66515040.0
2005-11-29 13:00:00	NVDA	Stock	0.2981	0.2998	0.2963	0.2976	99252480.0
2005-11-29 14:00:00	NVDA	Stock	0.2976	0.2982	0.2959	0.2979	94325280.0
2005-11-29 15:00:00	NVDA	Stock	0.2979	0.2979	0.2945	0.2957	153146280.0
2005-11-29 16:00:00	NVDA	Stock	0.2957	0.2967	0.2955	0.2967	8769600.0
2005-11-29 17:00:00	NVDA	Stock	0.2966	0.2967	0.2962	0.2962	160560.0
2005-11-29 18:00:00	NVDA	Stock	0.2962	0.2962	0.2958	0.2958	36000.0
2005-11-29 08:00:00	AMZN	Stock	2.405	2.4225	2.405	2.42	77000.0
2005-11-29 09:00:00	AMZN	Stock	2.42	2.465	2.406	2.4625	24311300.0
2005-11-29 10:00:00	AMZN	Stock	2.4635	2.4715	2.412	2.429	45213440.0
2005-11-29 11:00:00	AMZN	Stock	2.429	2.434	2.4135	2.434	21101800.0
2005-11-29 12:00:00	AMZN	Stock	2.4345	2.44	2.4265	2.43	28270200.0
2005-11-29 13:00:00	AMZN	Stock	2.43	2.4335	2.414	2.429	23506140.0
2005-11-29 14:00:00	AMZN	Stock	2.429	2.442	2.406	2.4345	29845680.0
2005-11-29 15:00:00	AMZN	Stock	2.4345	2.4399	2.426	2.428	28880920.0
2005-11-29 16:00:00	AMZN	Stock	2.4295	2.43	2.4055	2.415	1611240.0
2005-11-29 17:00:00	AMZN	Stock	2.4175	2.419	2.415	2.419	164200.0
2005-11-29 18:00:00	AMZN	Stock	2.419	2.419	2.419	2.419	10000.0
2005-11-29 09:00:00	CL	Stock	27.15	27.225	27.04	27.185	362000.0
2005-11-29 10:00:00	CL	Stock	27.18	27.205	27.08	27.14	393000.0
2005-11-29 11:00:00	CL	Stock	27.135	27.185	27.095	27.17	483600.0
2005-11-29 12:00:00	CL	Stock	27.165	27.235	27.13	27.235	606800.0

> showing 50 of 26,950 rows — these rows as CSV

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