PREVIEW / stock_1hour / 2005-07-07

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-07-07.parquet
  size:    562 KB
  rows:    26,597
  symbols: 2,014

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-07-07 08:00:00	AAPL	Stock	1.3018	1.3289	1.2964	1.3068	4648420.0
2005-07-07 09:00:00	AAPL	Stock	1.3071	1.3364	1.3057	1.3189	83089412.0
2005-07-07 10:00:00	AAPL	Stock	1.3182	1.3286	1.3157	1.3182	79158912.0
2005-07-07 11:00:00	AAPL	Stock	1.3189	1.3286	1.3157	1.3282	47346096.0
2005-07-07 12:00:00	AAPL	Stock	1.3282	1.3332	1.3261	1.3282	31883096.0
2005-07-07 13:00:00	AAPL	Stock	1.3279	1.3375	1.3268	1.3325	28027832.0
2005-07-07 14:00:00	AAPL	Stock	1.3329	1.3346	1.3286	1.3339	30133572.0
2005-07-07 15:00:00	AAPL	Stock	1.3339	1.3486	1.3336	1.345	73926048.0
2005-07-07 16:00:00	AAPL	Stock	1.3446	1.35	1.34	1.3464	1120560.0
2005-07-07 17:00:00	AAPL	Stock	1.3482	1.3482	1.3475	1.3479	49840.0
2005-07-07 18:00:00	AAPL	Stock	1.3461	1.3475	1.3454	1.3475	77000.0
2005-07-07 07:00:00	MSFT	Stock	24.24	24.5	24.22	24.45	42030.0
2005-07-07 08:00:00	MSFT	Stock	24.45	24.7	24.41	24.55	396402.0
2005-07-07 09:00:00	MSFT	Stock	24.55	24.66	24.5	24.51	10771546.0
2005-07-07 10:00:00	MSFT	Stock	24.51	24.63	24.51	24.53	16475337.0
2005-07-07 11:00:00	MSFT	Stock	24.54	24.63	24.51	24.61	9226110.0
2005-07-07 12:00:00	MSFT	Stock	24.62	24.71	24.56	24.57	9240904.0
2005-07-07 13:00:00	MSFT	Stock	24.57	24.67	24.54	24.59	6399688.0
2005-07-07 14:00:00	MSFT	Stock	24.58	24.621	24.54	24.59	7875608.0
2005-07-07 15:00:00	MSFT	Stock	24.59	24.69	24.57	24.62	16290583.0
2005-07-07 16:00:00	MSFT	Stock	24.63	24.7	24.63	24.69	1082721.0
2005-07-07 17:00:00	MSFT	Stock	24.69	24.69	24.67	24.67	5900.0
2005-07-07 18:00:00	MSFT	Stock	24.66	24.68	24.65	24.67	3796.0
2005-07-07 08:00:00	NVDA	Stock	0.2281	0.2285	0.2258	0.2282	1450800.0
2005-07-07 09:00:00	NVDA	Stock	0.2283	0.2333	0.2279	0.2297	86634720.0
2005-07-07 10:00:00	NVDA	Stock	0.2296	0.2312	0.2289	0.2295	67024320.0
2005-07-07 11:00:00	NVDA	Stock	0.2295	0.2302	0.2288	0.2296	73611120.0
2005-07-07 12:00:00	NVDA	Stock	0.2296	0.2302	0.229	0.2291	55990800.0
2005-07-07 13:00:00	NVDA	Stock	0.2291	0.2317	0.229	0.2308	37666080.0
2005-07-07 14:00:00	NVDA	Stock	0.2307	0.2308	0.2296	0.2303	61082160.0
2005-07-07 15:00:00	NVDA	Stock	0.2302	0.2316	0.23	0.2315	72488880.0
2005-07-07 16:00:00	NVDA	Stock	0.2312	0.2312	0.231	0.231	90120.0
2005-07-07 17:00:00	NVDA	Stock	0.2312	0.2316	0.2312	0.2314	576000.0
2005-07-07 18:00:00	NVDA	Stock	0.2314	0.2314	0.2312	0.2312	600000.0
2005-07-07 08:00:00	AMZN	Stock	1.675	1.6875	1.675	1.6825	124000.0
2005-07-07 09:00:00	AMZN	Stock	1.685	1.7255	1.683	1.7085	16891920.0
2005-07-07 10:00:00	AMZN	Stock	1.7085	1.721	1.704	1.706	16045940.0
2005-07-07 11:00:00	AMZN	Stock	1.706	1.7065	1.6945	1.702	11339100.0
2005-07-07 12:00:00	AMZN	Stock	1.7035	1.7115	1.695	1.696	8842940.0
2005-07-07 13:00:00	AMZN	Stock	1.6965	1.71	1.6948	1.7005	8193460.0
2005-07-07 14:00:00	AMZN	Stock	1.7005	1.702	1.695	1.6995	6959020.0
2005-07-07 15:00:00	AMZN	Stock	1.7	1.7035	1.696	1.698	14169260.0
2005-07-07 16:00:00	AMZN	Stock	1.6975	1.7005	1.697	1.6975	351760.0
2005-07-07 17:00:00	AMZN	Stock	1.6975	1.6975	1.6965	1.6965	212880.0
2005-07-07 18:00:00	AMZN	Stock	1.6992	1.6992	1.6992	1.6992	8000.0
2005-07-07 09:00:00	CL	Stock	24.75	24.825	24.525	24.82	895400.0
2005-07-07 10:00:00	CL	Stock	24.83	24.9	24.785	24.835	1037000.0
2005-07-07 11:00:00	CL	Stock	24.835	24.895	24.755	24.89	767800.0
2005-07-07 12:00:00	CL	Stock	24.89	24.925	24.815	24.875	694800.0
2005-07-07 13:00:00	CL	Stock	24.895	24.925	24.84	24.845	512200.0

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

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