PREVIEW / stock_1hour / 2005-09-26

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-09-26.parquet
  size:    582 KB
  rows:    27,768
  symbols: 2,074

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-26 08:00:00	AAPL	Stock	1.9179	1.9357	1.9139	1.9325	3829140.0
2005-09-26 09:00:00	AAPL	Stock	1.9332	1.9393	1.9179	1.9279	98628376.0
2005-09-26 10:00:00	AAPL	Stock	1.9279	1.9486	1.9175	1.9361	144185188.0
2005-09-26 11:00:00	AAPL	Stock	1.9364	1.9414	1.9286	1.9343	54637856.0
2005-09-26 12:00:00	AAPL	Stock	1.9343	1.9436	1.9264	1.9304	45512796.0
2005-09-26 13:00:00	AAPL	Stock	1.93	1.9418	1.9154	1.9246	53282292.0
2005-09-26 14:00:00	AAPL	Stock	1.9246	1.9257	1.9043	1.9125	64450932.0
2005-09-26 15:00:00	AAPL	Stock	1.9121	1.9282	1.9107	1.9225	66986416.0
2005-09-26 16:00:00	AAPL	Stock	1.9229	1.9317	1.9218	1.9261	2093392.0
2005-09-26 17:00:00	AAPL	Stock	1.9209	1.9232	1.9209	1.9232	9800.0
2005-09-26 18:00:00	AAPL	Stock	1.9257	1.935	1.9236	1.9236	56000.0
2005-09-26 07:00:00	MSFT	Stock	25.35	25.35	25.35	25.35	4700.0
2005-09-26 08:00:00	MSFT	Stock	25.4	25.46	25.37	25.43	1208761.0
2005-09-26 09:00:00	MSFT	Stock	25.42	25.42	25.31	25.34	7278401.0
2005-09-26 10:00:00	MSFT	Stock	25.34	25.49	25.27	25.341	8120752.0
2005-09-26 11:00:00	MSFT	Stock	25.349	25.44	25.32	25.37	4438766.0
2005-09-26 12:00:00	MSFT	Stock	25.38	25.451	25.36	25.44	5398550.0
2005-09-26 13:00:00	MSFT	Stock	25.43	25.44	25.33	25.4	6131387.0
2005-09-26 14:00:00	MSFT	Stock	25.4	25.411	25.21	25.23	7471431.0
2005-09-26 15:00:00	MSFT	Stock	25.23	25.29	25.22	25.24	11401333.0
2005-09-26 16:00:00	MSFT	Stock	25.26	25.29	25.24	25.26	601087.0
2005-09-26 17:00:00	MSFT	Stock	25.25	25.29	25.24	25.29	2510.0
2005-09-26 18:00:00	MSFT	Stock	25.29	25.37	25.26	25.26	4796.0
2005-09-26 09:00:00	NVDA	Stock	0.2747	0.2767	0.2697	0.2707	93680760.0
2005-09-26 10:00:00	NVDA	Stock	0.2704	0.2737	0.2702	0.2726	91050360.0
2005-09-26 11:00:00	NVDA	Stock	0.2727	0.2728	0.2712	0.2724	50219760.0
2005-09-26 12:00:00	NVDA	Stock	0.2724	0.2737	0.2723	0.2731	17218920.0
2005-09-26 13:00:00	NVDA	Stock	0.2731	0.2751	0.2725	0.275	33002760.0
2005-09-26 14:00:00	NVDA	Stock	0.275	0.275	0.2728	0.2737	38070120.0
2005-09-26 15:00:00	NVDA	Stock	0.2737	0.2757	0.2732	0.2749	62127480.0
2005-09-26 16:00:00	NVDA	Stock	0.2745	0.275	0.2745	0.2748	428880.0
2005-09-26 17:00:00	NVDA	Stock	0.2754	0.2757	0.2754	0.2757	84000.0
2005-09-26 18:00:00	NVDA	Stock	0.2757	0.2757	0.275	0.275	120000.0
2005-09-26 08:00:00	AMZN	Stock	2.111	2.1225	2.111	2.1225	11200.0
2005-09-26 09:00:00	AMZN	Stock	2.1225	2.1605	2.12	2.1415	16227540.0
2005-09-26 10:00:00	AMZN	Stock	2.1415	2.17	2.1415	2.1575	17475540.0
2005-09-26 11:00:00	AMZN	Stock	2.1575	2.1625	2.15	2.1514	6560280.0
2005-09-26 12:00:00	AMZN	Stock	2.151	2.158	2.1485	2.1505	11899460.0
2005-09-26 13:00:00	AMZN	Stock	2.1505	2.1585	2.143	2.1575	18572020.0
2005-09-26 14:00:00	AMZN	Stock	2.1565	2.159	2.136	2.1395	13331500.0
2005-09-26 15:00:00	AMZN	Stock	2.1395	2.171	2.1385	2.167	20935380.0
2005-09-26 16:00:00	AMZN	Stock	2.1665	2.1675	2.1645	2.165	230000.0
2005-09-26 17:00:00	AMZN	Stock	2.1583	2.165	2.1583	2.165	20000.0
2005-09-26 09:00:00	CL	Stock	26.15	26.22	25.935	26.01	327400.0
2005-09-26 10:00:00	CL	Stock	26.01	26.12	26.005	26.05	227000.0
2005-09-26 11:00:00	CL	Stock	26.05	26.15	25.8905	25.945	384200.0
2005-09-26 12:00:00	CL	Stock	25.945	26.085	25.895	25.925	689200.0
2005-09-26 13:00:00	CL	Stock	25.92	25.93	25.825	25.83	251200.0
2005-09-26 14:00:00	CL	Stock	25.83	25.83	25.66	25.705	737400.0
2005-09-26 15:00:00	CL	Stock	25.705	25.72	25.595	25.665	1059200.0

> showing 50 of 27,768 rows — these rows as CSV

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