PREVIEW / stock_1hour / 2005-09-27

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-09-27.parquet
  size:    569 KB
  rows:    27,033
  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-09-27 08:00:00	AAPL	Stock	1.9257	1.9339	1.9254	1.9289	696108.0
2005-09-27 09:00:00	AAPL	Stock	1.9289	1.9371	1.9193	1.9293	61507040.0
2005-09-27 10:00:00	AAPL	Stock	1.9282	1.9304	1.9154	1.9204	61749716.0
2005-09-27 11:00:00	AAPL	Stock	1.9207	1.9275	1.9179	1.9246	31963764.0
2005-09-27 12:00:00	AAPL	Stock	1.9246	1.9286	1.9214	1.9239	21949452.0
2005-09-27 13:00:00	AAPL	Stock	1.9246	1.9246	1.9146	1.9204	36604820.0
2005-09-27 14:00:00	AAPL	Stock	1.9211	1.9254	1.9146	1.9232	45719828.0
2005-09-27 15:00:00	AAPL	Stock	1.9232	1.9275	1.9082	1.9082	73295096.0
2005-09-27 16:00:00	AAPL	Stock	1.9082	1.9132	1.9068	1.9071	3120096.0
2005-09-27 17:00:00	AAPL	Stock	1.9079	1.9093	1.9064	1.9068	155988.0
2005-09-27 18:00:00	AAPL	Stock	1.9054	1.9075	1.9054	1.9071	97412.0
2005-09-27 06:00:00	MSFT	Stock	25.27	25.27	25.27	25.27	1000.0
2005-09-27 08:00:00	MSFT	Stock	25.32	25.35	25.27	25.33	41190.0
2005-09-27 09:00:00	MSFT	Stock	25.33	25.4	25.31	25.351	5161155.0
2005-09-27 10:00:00	MSFT	Stock	25.35	25.45	25.3	25.35	9479885.0
2005-09-27 11:00:00	MSFT	Stock	25.34	25.39	25.32	25.37	4142874.0
2005-09-27 12:00:00	MSFT	Stock	25.38	25.42	25.35	25.39	3620923.0
2005-09-27 13:00:00	MSFT	Stock	25.39	25.43	25.34	25.41	5891393.0
2005-09-27 14:00:00	MSFT	Stock	25.408	25.42	25.33	25.39	9232219.0
2005-09-27 15:00:00	MSFT	Stock	25.39	25.43	25.32	25.34	9140990.0
2005-09-27 16:00:00	MSFT	Stock	25.35	25.39	25.3	25.34	630480.0
2005-09-27 17:00:00	MSFT	Stock	25.33	25.37	25.33	25.344	8180.0
2005-09-27 18:00:00	MSFT	Stock	25.369	25.37	25.36	25.36	17585.0
2005-09-27 09:00:00	NVDA	Stock	0.2752	0.2771	0.2752	0.2766	40955640.0
2005-09-27 10:00:00	NVDA	Stock	0.2765	0.2766	0.2742	0.2755	56251920.0
2005-09-27 11:00:00	NVDA	Stock	0.2755	0.2757	0.2737	0.2751	66371040.0
2005-09-27 12:00:00	NVDA	Stock	0.2751	0.2757	0.2745	0.2746	28283520.0
2005-09-27 13:00:00	NVDA	Stock	0.2747	0.275	0.2737	0.275	37051080.0
2005-09-27 14:00:00	NVDA	Stock	0.2751	0.2774	0.275	0.2772	59148960.0
2005-09-27 15:00:00	NVDA	Stock	0.2772	0.2784	0.2757	0.2757	102659160.0
2005-09-27 16:00:00	NVDA	Stock	0.2757	0.276	0.2754	0.2757	3906000.0
2005-09-27 08:00:00	AMZN	Stock	2.133	2.15	2.133	2.15	28240.0
2005-09-27 09:00:00	AMZN	Stock	2.1625	2.1865	2.1555	2.163	9717860.0
2005-09-27 10:00:00	AMZN	Stock	2.163	2.1655	2.141	2.1465	16685260.0
2005-09-27 11:00:00	AMZN	Stock	2.1465	2.1585	2.146	2.156	8393960.0
2005-09-27 12:00:00	AMZN	Stock	2.157	2.1605	2.149	2.1502	4716580.0
2005-09-27 13:00:00	AMZN	Stock	2.1505	2.1555	2.141	2.1455	7476220.0
2005-09-27 14:00:00	AMZN	Stock	2.146	2.176	2.146	2.1715	16214440.0
2005-09-27 15:00:00	AMZN	Stock	2.1715	2.178	2.155	2.159	15730220.0
2005-09-27 16:00:00	AMZN	Stock	2.16	2.166	2.158	2.1635	105600.0
2005-09-27 17:00:00	AMZN	Stock	2.158	2.158	2.158	2.158	18600.0
2005-09-27 09:00:00	CL	Stock	25.645	25.875	25.63	25.835	358400.0
2005-09-27 10:00:00	CL	Stock	25.86	25.88	25.675	25.78	489000.0
2005-09-27 11:00:00	CL	Stock	25.78	25.82	25.74	25.785	309600.0
2005-09-27 12:00:00	CL	Stock	25.79	25.835	25.77	25.805	426000.0
2005-09-27 13:00:00	CL	Stock	25.81	25.89	25.795	25.845	450600.0
2005-09-27 14:00:00	CL	Stock	25.86	25.99	25.845	25.985	457200.0
2005-09-27 15:00:00	CL	Stock	25.99	26.065	25.955	25.995	916600.0
2005-09-27 16:00:00	CL	Stock	25.99	25.99	25.99	25.99	4200.0

> showing 49 of 27,033 rows — these rows as CSV

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