PREVIEW / stock_1hour / 2005-05-13

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-05-13.parquet
  size:    556 KB
  rows:    26,336
  symbols: 1,975

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-05-13 07:00:00	AAPL	Stock	1.225	1.225	1.225	1.225	22400.0
2005-05-13 08:00:00	AAPL	Stock	1.225	1.2293	1.225	1.2286	1659504.0
2005-05-13 09:00:00	AAPL	Stock	1.2275	1.2318	1.2168	1.2207	82770436.0
2005-05-13 10:00:00	AAPL	Stock	1.2207	1.2496	1.2189	1.2489	156760800.0
2005-05-13 11:00:00	AAPL	Stock	1.2493	1.2582	1.2411	1.2543	112078288.0
2005-05-13 12:00:00	AAPL	Stock	1.255	1.2561	1.2393	1.2411	81200056.0
2005-05-13 13:00:00	AAPL	Stock	1.2411	1.2446	1.2339	1.2368	54132288.0
2005-05-13 14:00:00	AAPL	Stock	1.2368	1.2386	1.2214	1.2257	93046156.0
2005-05-13 15:00:00	AAPL	Stock	1.2261	1.2418	1.2225	1.2414	106837612.0
2005-05-13 16:00:00	AAPL	Stock	1.2414	1.2418	1.2261	1.2389	3063424.0
2005-05-13 17:00:00	AAPL	Stock	1.2333	1.2418	1.2328	1.2414	373856.0
2005-05-13 07:00:00	MSFT	Stock	25.1	25.1	25.1	25.1	500.0
2005-05-13 08:00:00	MSFT	Stock	25.08	25.12	25.08	25.12	25612.0
2005-05-13 09:00:00	MSFT	Stock	25.13	25.15	24.99	25.1	9545233.0
2005-05-13 10:00:00	MSFT	Stock	25.11	25.3	25.06	25.27	17589672.0
2005-05-13 11:00:00	MSFT	Stock	25.27	25.32	25.23	25.3	8191729.0
2005-05-13 12:00:00	MSFT	Stock	25.298	25.38	25.24	25.25	8482938.0
2005-05-13 13:00:00	MSFT	Stock	25.24	25.351	25.22	25.26	6750961.0
2005-05-13 14:00:00	MSFT	Stock	25.26	25.28	25.07	25.17	13705091.0
2005-05-13 15:00:00	MSFT	Stock	25.17	25.3	25.13	25.3	11503059.0
2005-05-13 16:00:00	MSFT	Stock	25.3	25.34	25.228	25.25	808718.0
2005-05-13 17:00:00	MSFT	Stock	25.29	25.3	25.191	25.29	20331.0
2005-05-13 18:00:00	MSFT	Stock	25.29	25.29	25.27	25.27	2452.0
2005-05-13 07:00:00	NVDA	Stock	0.2075	0.2075	0.2067	0.2067	1461000.0
2005-05-13 08:00:00	NVDA	Stock	0.2068	0.2077	0.2057	0.2067	59441040.0
2005-05-13 09:00:00	NVDA	Stock	0.2069	0.2093	0.1983	0.207	629852400.0
2005-05-13 10:00:00	NVDA	Stock	0.2072	0.21	0.2065	0.2071	584400840.0
2005-05-13 11:00:00	NVDA	Stock	0.2071	0.2105	0.207	0.2087	312099600.0
2005-05-13 12:00:00	NVDA	Stock	0.2087	0.21	0.2082	0.2088	344494680.0
2005-05-13 13:00:00	NVDA	Stock	0.2088	0.2092	0.2067	0.2076	195362040.0
2005-05-13 14:00:00	NVDA	Stock	0.2076	0.2087	0.2069	0.2077	157786080.0
2005-05-13 15:00:00	NVDA	Stock	0.2077	0.2122	0.2073	0.2112	339791160.0
2005-05-13 16:00:00	NVDA	Stock	0.2112	0.2118	0.2105	0.2108	5353320.0
2005-05-13 17:00:00	NVDA	Stock	0.2112	0.2112	0.2101	0.2112	372000.0
2005-05-13 18:00:00	NVDA	Stock	0.2112	0.212	0.2108	0.212	508320.0
2005-05-13 08:00:00	AMZN	Stock	1.6925	1.706	1.6925	1.7035	79000.0
2005-05-13 09:00:00	AMZN	Stock	1.6975	1.7	1.6905	1.696	6787800.0
2005-05-13 10:00:00	AMZN	Stock	1.6955	1.7075	1.694	1.702	13907460.0
2005-05-13 11:00:00	AMZN	Stock	1.7025	1.7125	1.7005	1.7125	13852900.0
2005-05-13 12:00:00	AMZN	Stock	1.7125	1.7175	1.706	1.706	7758360.0
2005-05-13 13:00:00	AMZN	Stock	1.7065	1.707	1.697	1.6985	5355300.0
2005-05-13 14:00:00	AMZN	Stock	1.699	1.699	1.69	1.6925	14658680.0
2005-05-13 15:00:00	AMZN	Stock	1.6925	1.7035	1.691	1.6955	15758620.0
2005-05-13 16:00:00	AMZN	Stock	1.6955	1.6965	1.693	1.695	754920.0
2005-05-13 17:00:00	AMZN	Stock	1.695	1.695	1.695	1.695	40000.0
2005-05-13 09:00:00	CL	Stock	24.675	24.675	24.5	24.52	530800.0
2005-05-13 10:00:00	CL	Stock	24.52	24.55	24.43	24.5	793800.0
2005-05-13 11:00:00	CL	Stock	24.495	24.515	24.425	24.475	589200.0
2005-05-13 12:00:00	CL	Stock	24.475	24.5	24.375	24.375	496200.0
2005-05-13 13:00:00	CL	Stock	24.375	24.39	24.23	24.25	488400.0

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

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