PREVIEW / stock_1hour / 2005-03-04

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-03-04.parquet
  size:    549 KB
  rows:    25,484
  symbols: 1,936

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-03-04 08:00:00	AAPL	Stock	1.4932	1.5243	1.4821	1.5243	14453936.0
2005-03-04 09:00:00	AAPL	Stock	1.5232	1.5354	1.4946	1.5157	191380364.0
2005-03-04 10:00:00	AAPL	Stock	1.5161	1.5214	1.5043	1.515	122021116.0
2005-03-04 11:00:00	AAPL	Stock	1.515	1.5293	1.5143	1.52	83950972.0
2005-03-04 12:00:00	AAPL	Stock	1.5207	1.5361	1.5189	1.5304	96420856.0
2005-03-04 13:00:00	AAPL	Stock	1.5304	1.5318	1.5186	1.5304	65953832.0
2005-03-04 14:00:00	AAPL	Stock	1.53	1.5336	1.5271	1.5304	65776396.0
2005-03-04 15:00:00	AAPL	Stock	1.5304	1.5354	1.5268	1.5286	101464552.0
2005-03-04 16:00:00	AAPL	Stock	1.5314	1.5346	1.5275	1.5311	2967440.0
2005-03-04 17:00:00	AAPL	Stock	1.5311	1.5336	1.5289	1.5311	1116136.0
2005-03-04 18:00:00	AAPL	Stock	1.5314	1.5314	1.5293	1.5293	22680.0
2005-03-04 08:00:00	MSFT	Stock	25.17	25.23	25.16	25.2	176338.0
2005-03-04 09:00:00	MSFT	Stock	25.22	25.29	25.18	25.25	9019201.0
2005-03-04 10:00:00	MSFT	Stock	25.25	25.3	25.21	25.22	9380603.0
2005-03-04 11:00:00	MSFT	Stock	25.22	25.24	25.19	25.19	6495842.0
2005-03-04 12:00:00	MSFT	Stock	25.19	25.25	25.17	25.21	6792916.0
2005-03-04 13:00:00	MSFT	Stock	25.21	25.23	25.17	25.21	5051302.0
2005-03-04 14:00:00	MSFT	Stock	25.2	25.23	25.16	25.19	6586030.0
2005-03-04 15:00:00	MSFT	Stock	25.19	25.24	25.13	25.18	16748303.0
2005-03-04 16:00:00	MSFT	Stock	25.17	25.2	25.16	25.16	321704.0
2005-03-04 17:00:00	MSFT	Stock	25.18	25.219	25.17	25.19	9080.0
2005-03-04 18:00:00	MSFT	Stock	25.19	25.19	25.19	25.19	101627.0
2005-03-04 08:00:00	NVDA	Stock	0.2312	0.2324	0.2312	0.2324	60000.0
2005-03-04 09:00:00	NVDA	Stock	0.2327	0.233	0.2311	0.2318	58685760.0
2005-03-04 10:00:00	NVDA	Stock	0.2317	0.233	0.2303	0.2317	88915560.0
2005-03-04 11:00:00	NVDA	Stock	0.2317	0.2333	0.2311	0.2327	62286600.0
2005-03-04 12:00:00	NVDA	Stock	0.2326	0.2326	0.2314	0.2322	53507520.0
2005-03-04 13:00:00	NVDA	Stock	0.2322	0.2325	0.2312	0.2318	50209080.0
2005-03-04 14:00:00	NVDA	Stock	0.2318	0.2334	0.2297	0.2298	110807400.0
2005-03-04 15:00:00	NVDA	Stock	0.2298	0.2302	0.2278	0.2294	162136320.0
2005-03-04 16:00:00	NVDA	Stock	0.2296	0.2298	0.2293	0.2297	2886120.0
2005-03-04 17:00:00	NVDA	Stock	0.2297	0.2297	0.2296	0.2296	72000.0
2005-03-04 08:00:00	AMZN	Stock	1.7845	1.7845	1.784	1.784	4000.0
2005-03-04 09:00:00	AMZN	Stock	1.7905	1.8145	1.79	1.8096	23725180.0
2005-03-04 10:00:00	AMZN	Stock	1.809	1.8155	1.79	1.7945	24297080.0
2005-03-04 11:00:00	AMZN	Stock	1.794	1.7955	1.785	1.7865	12802640.0
2005-03-04 12:00:00	AMZN	Stock	1.7865	1.794	1.786	1.7905	5820360.0
2005-03-04 13:00:00	AMZN	Stock	1.7905	1.7965	1.7875	1.7945	10999260.0
2005-03-04 14:00:00	AMZN	Stock	1.795	1.798	1.7924	1.7955	12239320.0
2005-03-04 15:00:00	AMZN	Stock	1.795	1.7975	1.791	1.7925	17800820.0
2005-03-04 16:00:00	AMZN	Stock	1.793	1.794	1.791	1.7925	264600.0
2005-03-04 17:00:00	AMZN	Stock	1.7925	1.7925	1.792	1.792	22000.0
2005-03-04 09:00:00	CL	Stock	26.38	26.455	26.3	26.425	286200.0
2005-03-04 10:00:00	CL	Stock	26.43	26.48	26.315	26.32	516600.0
2005-03-04 11:00:00	CL	Stock	26.315	26.38	26.255	26.29	519600.0
2005-03-04 12:00:00	CL	Stock	26.29	26.3	26.185	26.205	414600.0
2005-03-04 13:00:00	CL	Stock	26.2	26.385	26.2	26.38	438000.0
2005-03-04 14:00:00	CL	Stock	26.385	26.46	26.36	26.425	464400.0
2005-03-04 15:00:00	CL	Stock	26.43	26.43	26.37	26.405	622800.0
2005-03-04 16:00:00	CL	Stock	26.42	26.42	26.42	26.42	3400.0

> showing 50 of 25,484 rows — these rows as CSV

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