PREVIEW / stock_1hour / 2005-10-17

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-10-17.parquet
  size:    563 KB
  rows:    26,739
  symbols: 2,095

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-17 08:00:00	AAPL	Stock	1.9214	1.9275	1.9071	1.9179	2904832.0
2005-10-17 09:00:00	AAPL	Stock	1.9186	1.9318	1.915	1.9214	99938972.0
2005-10-17 10:00:00	AAPL	Stock	1.9214	1.9368	1.9071	1.9143	133324016.0
2005-10-17 11:00:00	AAPL	Stock	1.9139	1.9182	1.8971	1.8982	76879684.0
2005-10-17 12:00:00	AAPL	Stock	1.8982	1.9032	1.8814	1.8925	100225244.0
2005-10-17 13:00:00	AAPL	Stock	1.8921	1.9179	1.8886	1.9004	59298792.0
2005-10-17 14:00:00	AAPL	Stock	1.9007	1.9018	1.8875	1.8946	56016660.0
2005-10-17 15:00:00	AAPL	Stock	1.8946	1.9104	1.8929	1.9086	81442340.0
2005-10-17 16:00:00	AAPL	Stock	1.9064	1.91	1.9025	1.9064	1580096.0
2005-10-17 17:00:00	AAPL	Stock	1.9061	1.9079	1.9046	1.9079	407400.0
2005-10-17 18:00:00	AAPL	Stock	1.9079	1.9079	1.9039	1.9046	95004.0
2005-10-17 08:00:00	MSFT	Stock	24.67	24.9	24.63	24.71	23501.0
2005-10-17 09:00:00	MSFT	Stock	24.72	24.75	24.5	24.53	7517626.0
2005-10-17 10:00:00	MSFT	Stock	24.53	24.61	24.509	24.53	7854950.0
2005-10-17 11:00:00	MSFT	Stock	24.53	24.57	24.5	24.56	5510927.0
2005-10-17 12:00:00	MSFT	Stock	24.57	24.57	24.44	24.48	4579326.0
2005-10-17 13:00:00	MSFT	Stock	24.48	24.53	24.46	24.5	4619398.0
2005-10-17 14:00:00	MSFT	Stock	24.5	24.5	24.44	24.47	5305053.0
2005-10-17 15:00:00	MSFT	Stock	24.46	24.53	24.45	24.52	9429146.0
2005-10-17 16:00:00	MSFT	Stock	24.52	24.55	24.49	24.53	701536.0
2005-10-17 17:00:00	MSFT	Stock	24.53	24.55	24.53	24.54	205915.0
2005-10-17 18:00:00	MSFT	Stock	24.54	24.54	24.53	24.53	3131.0
2005-10-17 09:00:00	NVDA	Stock	0.2675	0.2722	0.2671	0.2717	41845800.0
2005-10-17 10:00:00	NVDA	Stock	0.2714	0.2718	0.2692	0.2692	51120960.0
2005-10-17 11:00:00	NVDA	Stock	0.2692	0.2696	0.2685	0.2692	29397240.0
2005-10-17 12:00:00	NVDA	Stock	0.2693	0.2693	0.2675	0.2683	22869960.0
2005-10-17 13:00:00	NVDA	Stock	0.2682	0.2697	0.2682	0.2688	27249120.0
2005-10-17 14:00:00	NVDA	Stock	0.2689	0.2689	0.2671	0.2679	21275040.0
2005-10-17 15:00:00	NVDA	Stock	0.2679	0.2695	0.2677	0.2695	43867560.0
2005-10-17 16:00:00	NVDA	Stock	0.2695	0.2696	0.2692	0.2692	677040.0
2005-10-17 08:00:00	AMZN	Stock	2.1875	2.1965	2.1875	2.196	62000.0
2005-10-17 09:00:00	AMZN	Stock	2.175	2.218	2.175	2.2075	13094000.0
2005-10-17 10:00:00	AMZN	Stock	2.208	2.237	2.2055	2.2235	19530760.0
2005-10-17 11:00:00	AMZN	Stock	2.223	2.234	2.215	2.222	8355900.0
2005-10-17 12:00:00	AMZN	Stock	2.222	2.225	2.2105	2.2195	8939300.0
2005-10-17 13:00:00	AMZN	Stock	2.2195	2.2365	2.2155	2.2365	10615600.0
2005-10-17 14:00:00	AMZN	Stock	2.2355	2.249	2.2295	2.239	13428420.0
2005-10-17 15:00:00	AMZN	Stock	2.2385	2.251	2.2325	2.251	27508180.0
2005-10-17 16:00:00	AMZN	Stock	2.2495	2.252	2.2438	2.2485	1252920.0
2005-10-17 17:00:00	AMZN	Stock	2.2495	2.253	2.2495	2.253	4000.0
2005-10-17 18:00:00	AMZN	Stock	2.255	2.255	2.255	2.255	40000.0
2005-10-17 09:00:00	CL	Stock	26.08	26.17	25.98	26.11	239000.0
2005-10-17 10:00:00	CL	Stock	26.13	26.22	26.05	26.08	386400.0
2005-10-17 11:00:00	CL	Stock	26.085	26.14	26.055	26.08	823800.0
2005-10-17 12:00:00	CL	Stock	26.0785	26.08	25.92	25.925	464400.0
2005-10-17 13:00:00	CL	Stock	25.925	26.065	25.91	26.05	200200.0
2005-10-17 14:00:00	CL	Stock	26.06	26.1	26.0	26.05	282600.0
2005-10-17 15:00:00	CL	Stock	26.05	26.225	26.045	26.185	469000.0
2005-10-17 16:00:00	CL	Stock	26.195	26.195	26.195	26.195	74800.0

> showing 49 of 26,739 rows — these rows as CSV

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