PREVIEW / stock_1hour / 2005-10-07

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-10-07.parquet
  size:    562 KB
  rows:    26,849
  symbols: 2,084

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-10-07 07:00:00	AAPL	Stock	1.8446	1.8446	1.8118	1.8143	716520.0
2005-10-07 08:00:00	AAPL	Stock	1.8129	1.8318	1.8018	1.8314	7725900.0
2005-10-07 09:00:00	AAPL	Stock	1.8314	1.8546	1.8082	1.8204	161278572.0
2005-10-07 10:00:00	AAPL	Stock	1.8204	1.8271	1.8054	1.8246	152746328.0
2005-10-07 11:00:00	AAPL	Stock	1.8246	1.83	1.8168	1.8214	78900276.0
2005-10-07 12:00:00	AAPL	Stock	1.8211	1.8214	1.8111	1.815	46323172.0
2005-10-07 13:00:00	AAPL	Stock	1.8146	1.8286	1.8111	1.825	62632780.0
2005-10-07 14:00:00	AAPL	Stock	1.825	1.8436	1.8214	1.84	77041972.0
2005-10-07 15:00:00	AAPL	Stock	1.8404	1.8404	1.8254	1.8321	83257972.0
2005-10-07 16:00:00	AAPL	Stock	1.8307	1.8321	1.8268	1.8321	825160.0
2005-10-07 17:00:00	AAPL	Stock	1.8321	1.8339	1.8321	1.8339	902944.0
2005-10-07 18:00:00	AAPL	Stock	1.835	1.8357	1.8236	1.8325	270956.0
2005-10-07 08:00:00	MSFT	Stock	24.79	24.89	24.76	24.84	73989.0
2005-10-07 09:00:00	MSFT	Stock	24.83	24.86	24.64	24.71	10755072.0
2005-10-07 10:00:00	MSFT	Stock	24.71	24.77	24.63	24.68	8450318.0
2005-10-07 11:00:00	MSFT	Stock	24.68	24.74	24.65	24.7	4946044.0
2005-10-07 12:00:00	MSFT	Stock	24.7	24.73	24.66	24.67	3141397.0
2005-10-07 13:00:00	MSFT	Stock	24.68	24.75	24.6	24.62	5659366.0
2005-10-07 14:00:00	MSFT	Stock	24.62	24.69	24.52	24.58	6760561.0
2005-10-07 15:00:00	MSFT	Stock	24.58	24.65	24.56	24.6	8612738.0
2005-10-07 16:00:00	MSFT	Stock	24.59	24.7	24.56	24.58	118984.0
2005-10-07 17:00:00	MSFT	Stock	24.59	24.59	24.56	24.59	350370.0
2005-10-07 18:00:00	MSFT	Stock	24.667	24.667	24.584	24.59	21486.0
2005-10-07 08:00:00	NVDA	Stock	0.2796	0.2796	0.2781	0.2781	114000.0
2005-10-07 09:00:00	NVDA	Stock	0.2792	0.2824	0.2789	0.2797	74569080.0
2005-10-07 10:00:00	NVDA	Stock	0.2797	0.2809	0.2733	0.2759	119097600.0
2005-10-07 11:00:00	NVDA	Stock	0.2759	0.2771	0.2737	0.2754	92676360.0
2005-10-07 12:00:00	NVDA	Stock	0.2756	0.2764	0.2741	0.2749	40104120.0
2005-10-07 13:00:00	NVDA	Stock	0.2749	0.2758	0.2746	0.2746	18523440.0
2005-10-07 14:00:00	NVDA	Stock	0.2747	0.2766	0.2742	0.2759	66292320.0
2005-10-07 15:00:00	NVDA	Stock	0.2758	0.2765	0.2747	0.2753	118835400.0
2005-10-07 16:00:00	NVDA	Stock	0.2753	0.2754	0.275	0.2754	1282440.0
2005-10-07 17:00:00	NVDA	Stock	0.2755	0.2755	0.2753	0.2753	800400.0
2005-10-07 18:00:00	NVDA	Stock	0.2755	0.2755	0.2755	0.2755	216000.0
2005-10-07 08:00:00	AMZN	Stock	2.19	2.19	2.1875	2.1875	21600.0
2005-10-07 09:00:00	AMZN	Stock	2.2085	2.2305	2.2065	2.212	8745440.0
2005-10-07 10:00:00	AMZN	Stock	2.212	2.22	2.1735	2.1885	15368560.0
2005-10-07 11:00:00	AMZN	Stock	2.1885	2.1945	2.1805	2.185	6789240.0
2005-10-07 12:00:00	AMZN	Stock	2.184	2.194	2.1825	2.19	4766600.0
2005-10-07 13:00:00	AMZN	Stock	2.1895	2.1925	2.183	2.183	4962840.0
2005-10-07 14:00:00	AMZN	Stock	2.183	2.187	2.172	2.1805	7366940.0
2005-10-07 15:00:00	AMZN	Stock	2.181	2.191	2.169	2.1855	19098620.0
2005-10-07 16:00:00	AMZN	Stock	2.185	2.1925	2.185	2.1925	103300.0
2005-10-07 18:00:00	AMZN	Stock	2.1798	2.186	2.1798	2.186	77920.0
2005-10-07 09:00:00	CL	Stock	26.225	26.255	25.99	26.095	402800.0
2005-10-07 10:00:00	CL	Stock	26.085	26.23	26.055	26.15	448200.0
2005-10-07 11:00:00	CL	Stock	26.15	26.215	26.08	26.19	331200.0
2005-10-07 12:00:00	CL	Stock	26.16	26.2	26.08	26.18	367000.0
2005-10-07 13:00:00	CL	Stock	26.18	26.215	26.165	26.205	322400.0
2005-10-07 14:00:00	CL	Stock	26.205	26.315	26.18	26.23	639000.0

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

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