PREVIEW / stock_1hour / 2005-11-10

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-11-10.parquet
  size:    572 KB
  rows:    26,776
  symbols: 2,105

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-10 07:00:00	AAPL	Stock	2.15	2.1536	2.15	2.1514	8400.0
2005-11-10 08:00:00	AAPL	Stock	2.1536	2.1607	2.15	2.1568	545580.0
2005-11-10 09:00:00	AAPL	Stock	2.1568	2.1757	2.1254	2.1368	86802464.0
2005-11-10 10:00:00	AAPL	Stock	2.1371	2.1571	2.1075	2.1214	132111756.0
2005-11-10 11:00:00	AAPL	Stock	2.1214	2.1346	2.1143	2.1264	75605964.0
2005-11-10 12:00:00	AAPL	Stock	2.1264	2.1286	2.1164	2.1254	45613876.0
2005-11-10 13:00:00	AAPL	Stock	2.1254	2.1786	2.1236	2.1754	114528176.0
2005-11-10 14:00:00	AAPL	Stock	2.1757	2.1796	2.1671	2.1761	100156504.0
2005-11-10 15:00:00	AAPL	Stock	2.1764	2.1857	2.1671	2.185	102639376.0
2005-11-10 16:00:00	AAPL	Stock	2.185	2.1904	2.1793	2.1868	2291996.0
2005-11-10 17:00:00	AAPL	Stock	2.1875	2.1896	2.1836	2.1893	379596.0
2005-11-10 18:00:00	AAPL	Stock	2.1496	2.1857	2.1496	2.1854	57652.0
2005-11-10 08:00:00	MSFT	Stock	26.89	26.96	26.85	26.9	2322410.0
2005-11-10 09:00:00	MSFT	Stock	26.93	27.03	26.87	26.91	5829138.0
2005-11-10 10:00:00	MSFT	Stock	26.91	26.99	26.64	26.939	18347970.0
2005-11-10 11:00:00	MSFT	Stock	26.93	26.95	26.85	26.92	8131358.0
2005-11-10 12:00:00	MSFT	Stock	26.92	26.97	26.85	26.92	6079076.0
2005-11-10 13:00:00	MSFT	Stock	26.92	27.15	26.92	27.07	10490685.0
2005-11-10 14:00:00	MSFT	Stock	27.07	27.11	27.0	27.03	6677839.0
2005-11-10 15:00:00	MSFT	Stock	27.04	27.1	26.94	27.09	14290088.0
2005-11-10 16:00:00	MSFT	Stock	27.09	27.1	26.96	27.09	191395.0
2005-11-10 17:00:00	MSFT	Stock	27.09	27.1	27.08	27.1	162000.0
2005-11-10 18:00:00	MSFT	Stock	27.09	27.09	27.09	27.09	100.0
2005-11-10 07:00:00	NVDA	Stock	0.305	0.3051	0.3034	0.3034	75000.0
2005-11-10 08:00:00	NVDA	Stock	0.3032	0.3046	0.2946	0.2971	27093360.0
2005-11-10 09:00:00	NVDA	Stock	0.2971	0.3064	0.2964	0.3002	553365720.0
2005-11-10 10:00:00	NVDA	Stock	0.3004	0.3004	0.2927	0.2937	351596400.0
2005-11-10 11:00:00	NVDA	Stock	0.2938	0.305	0.2737	0.2767	621975120.0
2005-11-10 12:00:00	NVDA	Stock	0.2768	0.2832	0.2765	0.2803	252753840.0
2005-11-10 13:00:00	NVDA	Stock	0.2804	0.2846	0.278	0.2823	166272840.0
2005-11-10 14:00:00	NVDA	Stock	0.2823	0.2832	0.2792	0.2827	175743840.0
2005-11-10 15:00:00	NVDA	Stock	0.2827	0.2856	0.2785	0.2791	324980160.0
2005-11-10 16:00:00	NVDA	Stock	0.2791	0.2794	0.2785	0.2792	3062160.0
2005-11-10 17:00:00	NVDA	Stock	0.2792	0.2792	0.2787	0.2791	379200.0
2005-11-10 18:00:00	NVDA	Stock	0.2792	0.2792	0.2792	0.2792	12000.0
2005-11-10 08:00:00	AMZN	Stock	2.07	2.07	2.07	2.07	4000.0
2005-11-10 09:00:00	AMZN	Stock	2.075	2.0885	2.062	2.069	6575940.0
2005-11-10 10:00:00	AMZN	Stock	2.069	2.07	2.043	2.0585	18277340.0
2005-11-10 11:00:00	AMZN	Stock	2.059	2.061	2.0485	2.054	10596120.0
2005-11-10 12:00:00	AMZN	Stock	2.054	2.0625	2.043	2.06	9235880.0
2005-11-10 13:00:00	AMZN	Stock	2.06	2.09	2.059	2.0845	16472980.0
2005-11-10 14:00:00	AMZN	Stock	2.0845	2.0955	2.079	2.094	14974460.0
2005-11-10 15:00:00	AMZN	Stock	2.094	2.1225	2.0935	2.1105	32980040.0
2005-11-10 16:00:00	AMZN	Stock	2.109	2.111	2.0735	2.1095	722760.0
2005-11-10 17:00:00	AMZN	Stock	2.109	2.109	2.109	2.109	38000.0
2005-11-10 18:00:00	AMZN	Stock	2.1095	2.1095	2.1075	2.1095	64000.0
2005-11-10 09:00:00	CL	Stock	26.485	26.7	26.47	26.635	277000.0
2005-11-10 10:00:00	CL	Stock	26.655	26.675	26.525	26.59	509400.0
2005-11-10 11:00:00	CL	Stock	26.59	26.73	26.575	26.725	324400.0
2005-11-10 12:00:00	CL	Stock	26.725	26.725	26.665	26.675	448000.0

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

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