PREVIEW / stock_1hour / 2006-04-24

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-04-24.parquet
  size:    613 KB
  rows:    28,975
  symbols: 2,246

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
2006-04-24 08:00:00	AAPL	Stock	2.3864	2.3964	2.3857	2.3893	1822492.0
2006-04-24 09:00:00	AAPL	Stock	2.3896	2.3925	2.3486	2.3543	100924292.0
2006-04-24 10:00:00	AAPL	Stock	2.3546	2.3889	2.3532	2.3779	128714684.0
2006-04-24 11:00:00	AAPL	Stock	2.3775	2.3811	2.3514	2.3546	101918152.0
2006-04-24 12:00:00	AAPL	Stock	2.3543	2.37	2.345	2.3632	72317140.0
2006-04-24 13:00:00	AAPL	Stock	2.3636	2.3636	2.3521	2.3528	52595144.0
2006-04-24 14:00:00	AAPL	Stock	2.3525	2.36	2.3414	2.3432	75941600.0
2006-04-24 15:00:00	AAPL	Stock	2.3432	2.3621	2.3393	2.3496	124716284.0
2006-04-24 16:00:00	AAPL	Stock	2.3511	2.3529	2.3482	2.3507	2954084.0
2006-04-24 17:00:00	AAPL	Stock	2.3511	2.3518	2.3482	2.3511	3970988.0
2006-04-24 18:00:00	AAPL	Stock	2.3511	2.3536	2.3511	2.3536	135212.0
2006-04-24 06:00:00	MSFT	Stock	27.03	27.03	27.03	27.03	900.0
2006-04-24 07:00:00	MSFT	Stock	27.1	27.1	27.1	27.1	500.0
2006-04-24 08:00:00	MSFT	Stock	27.1	27.11	27.06	27.08	20565.0
2006-04-24 09:00:00	MSFT	Stock	27.08	27.25	27.04	27.06	3357850.0
2006-04-24 10:00:00	MSFT	Stock	27.06	27.13	26.99	26.99	9733644.0
2006-04-24 11:00:00	MSFT	Stock	27.0	27.1	26.98	27.08	4575076.0
2006-04-24 12:00:00	MSFT	Stock	27.09	27.25	27.05	27.23	5376748.0
2006-04-24 13:00:00	MSFT	Stock	27.23	27.24	27.14	27.23	3590299.0
2006-04-24 14:00:00	MSFT	Stock	27.23	27.25	27.14	27.16	2986134.0
2006-04-24 15:00:00	MSFT	Stock	27.15	27.25	27.1	27.14	9584689.0
2006-04-24 16:00:00	MSFT	Stock	27.14	27.164	27.11	27.11	76943.0
2006-04-24 17:00:00	MSFT	Stock	27.11	27.11	27.11	27.11	510675.0
2006-04-24 18:00:00	MSFT	Stock	27.12	27.12	27.11	27.11	2380.0
2006-04-24 08:00:00	NVDA	Stock	0.4678	0.4718	0.4678	0.4707	386340.0
2006-04-24 09:00:00	NVDA	Stock	0.4692	0.4767	0.4625	0.4707	90324660.0
2006-04-24 10:00:00	NVDA	Stock	0.4707	0.4833	0.4697	0.4783	133866300.0
2006-04-24 11:00:00	NVDA	Stock	0.4784	0.4828	0.4738	0.4813	93791220.0
2006-04-24 12:00:00	NVDA	Stock	0.4813	0.4863	0.4798	0.4853	59984100.0
2006-04-24 13:00:00	NVDA	Stock	0.4855	0.4868	0.4823	0.485	60194760.0
2006-04-24 14:00:00	NVDA	Stock	0.4852	0.4855	0.4792	0.4795	77255340.0
2006-04-24 15:00:00	NVDA	Stock	0.4795	0.4868	0.479	0.4823	133767180.0
2006-04-24 16:00:00	NVDA	Stock	0.4822	0.4833	0.4822	0.4833	513720.0
2006-04-24 17:00:00	NVDA	Stock	0.4833	0.4858	0.4783	0.4787	997500.0
2006-04-24 18:00:00	NVDA	Stock	0.4807	0.4807	0.4768	0.4775	312120.0
2006-04-24 09:00:00	AMZN	Stock	1.8005	1.8058	1.7755	1.7775	8732820.0
2006-04-24 10:00:00	AMZN	Stock	1.7775	1.8	1.775	1.779	10835600.0
2006-04-24 11:00:00	AMZN	Stock	1.78	1.781	1.766	1.7805	10731740.0
2006-04-24 12:00:00	AMZN	Stock	1.7805	1.795	1.7775	1.7935	6254160.0
2006-04-24 13:00:00	AMZN	Stock	1.7935	1.7955	1.7815	1.79	5365760.0
2006-04-24 14:00:00	AMZN	Stock	1.79	1.796	1.785	1.7895	6655780.0
2006-04-24 15:00:00	AMZN	Stock	1.7895	1.8	1.789	1.7895	11228120.0
2006-04-24 16:00:00	AMZN	Stock	1.7795	1.7925	1.7795	1.79	366000.0
2006-04-24 17:00:00	AMZN	Stock	1.7855	1.7855	1.785	1.785	58000.0
2006-04-24 18:00:00	AMZN	Stock	1.785	1.785	1.785	1.785	10000.0
2006-04-24 09:00:00	CL	Stock	28.545	28.65	28.515	28.595	355200.0
2006-04-24 10:00:00	CL	Stock	28.58	28.965	28.58	28.84	708000.0
2006-04-24 11:00:00	CL	Stock	28.84	28.87	28.745	28.825	512000.0
2006-04-24 12:00:00	CL	Stock	28.83	28.845	28.715	28.8125	470600.0
2006-04-24 13:00:00	CL	Stock	28.8	28.85	28.76	28.825	156200.0

> showing 50 of 28,975 rows — these rows as CSV

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