PREVIEW / stock_1hour / 2006-04-03

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-04-03.parquet
  size:    627 KB
  rows:    29,598
  symbols: 2,229

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
2006-04-03 05:00:00	AAPL	Stock	2.2596	2.26	2.2596	2.26	19600.0
2006-04-03 06:00:00	AAPL	Stock	2.2625	2.2625	2.2625	2.2625	2800.0
2006-04-03 07:00:00	AAPL	Stock	2.2589	2.2657	2.2589	2.2657	103600.0
2006-04-03 08:00:00	AAPL	Stock	2.2657	2.2657	2.2546	2.2586	3020024.0
2006-04-03 09:00:00	AAPL	Stock	2.2586	2.2768	2.2461	2.2736	126287728.0
2006-04-03 10:00:00	AAPL	Stock	2.2739	2.29	2.2675	2.2707	170135784.0
2006-04-03 11:00:00	AAPL	Stock	2.2707	2.28	2.2593	2.2736	109333504.0
2006-04-03 12:00:00	AAPL	Stock	2.2736	2.2757	2.2525	2.2629	90523888.0
2006-04-03 13:00:00	AAPL	Stock	2.2628	2.2707	2.2561	2.2636	70019040.0
2006-04-03 14:00:00	AAPL	Stock	2.2636	2.2781	2.2414	2.2507	113787688.0
2006-04-03 15:00:00	AAPL	Stock	2.2507	2.2589	2.2361	2.2375	121302692.0
2006-04-03 16:00:00	AAPL	Stock	2.2386	2.2393	2.2357	2.2361	2212196.0
2006-04-03 17:00:00	AAPL	Stock	2.2368	2.24	2.2364	2.24	409584.0
2006-04-03 18:00:00	AAPL	Stock	2.2382	2.2389	2.2357	2.2389	396200.0
2006-04-03 07:00:00	MSFT	Stock	27.51	27.6	27.51	27.55	9100.0
2006-04-03 08:00:00	MSFT	Stock	27.55	27.66	27.21	27.58	182304.0
2006-04-03 09:00:00	MSFT	Stock	27.6	27.73	27.21	27.56	8596704.0
2006-04-03 10:00:00	MSFT	Stock	27.56	27.7	27.47	27.7	8813489.0
2006-04-03 11:00:00	MSFT	Stock	27.69	27.72	27.6	27.641	6665795.0
2006-04-03 12:00:00	MSFT	Stock	27.65	27.68	27.55	27.57	4600457.0
2006-04-03 13:00:00	MSFT	Stock	27.57	27.68	27.54	27.64	5457260.0
2006-04-03 14:00:00	MSFT	Stock	27.65	27.66	27.56	27.57	4935581.0
2006-04-03 15:00:00	MSFT	Stock	27.58	27.607	27.44	27.57	13244285.0
2006-04-03 16:00:00	MSFT	Stock	27.53	27.605	27.52	27.59	2722364.0
2006-04-03 17:00:00	MSFT	Stock	27.59	27.59	27.55	27.55	25046.0
2006-04-03 18:00:00	MSFT	Stock	27.56	27.59	27.56	27.58	4619.0
2006-04-03 08:00:00	NVDA	Stock	0.4817	0.4817	0.48	0.4801	186000.0
2006-04-03 09:00:00	NVDA	Stock	0.4807	0.4813	0.4737	0.4779	133100880.0
2006-04-03 10:00:00	NVDA	Stock	0.4779	0.4857	0.4746	0.4845	164073960.0
2006-04-03 11:00:00	NVDA	Stock	0.4843	0.4892	0.4825	0.4862	122959800.0
2006-04-03 12:00:00	NVDA	Stock	0.486	0.4867	0.4833	0.4837	138099240.0
2006-04-03 13:00:00	NVDA	Stock	0.4837	0.4887	0.4833	0.4872	81704040.0
2006-04-03 14:00:00	NVDA	Stock	0.4872	0.4874	0.4817	0.4823	122372160.0
2006-04-03 15:00:00	NVDA	Stock	0.4823	0.4844	0.4822	0.4826	166335600.0
2006-04-03 16:00:00	NVDA	Stock	0.4827	0.483	0.4792	0.4807	10922640.0
2006-04-03 17:00:00	NVDA	Stock	0.4812	0.4825	0.4812	0.4812	102240.0
2006-04-03 18:00:00	NVDA	Stock	0.4807	0.4807	0.4803	0.4803	276000.0
2006-04-03 08:00:00	AMZN	Stock	1.8265	1.8265	1.8265	1.8265	873000.0
2006-04-03 09:00:00	AMZN	Stock	1.8335	1.8425	1.825	1.841	8706380.0
2006-04-03 10:00:00	AMZN	Stock	1.8405	1.8665	1.8345	1.8515	20877260.0
2006-04-03 11:00:00	AMZN	Stock	1.8515	1.8615	1.845	1.849	8992620.0
2006-04-03 12:00:00	AMZN	Stock	1.8485	1.8555	1.8395	1.841	6214900.0
2006-04-03 13:00:00	AMZN	Stock	1.8405	1.8425	1.835	1.8415	10996180.0
2006-04-03 14:00:00	AMZN	Stock	1.8415	1.8504	1.821	1.821	7988200.0
2006-04-03 15:00:00	AMZN	Stock	1.8215	1.8305	1.805	1.807	18386040.0
2006-04-03 16:00:00	AMZN	Stock	1.807	1.81	1.805	1.805	234860.0
2006-04-03 17:00:00	AMZN	Stock	1.805	1.81	1.805	1.807	89300.0
2006-04-03 08:00:00	CL	Stock	28.55	28.55	28.55	28.55	30800.0
2006-04-03 09:00:00	CL	Stock	28.75	28.755	28.655	28.68	324600.0
2006-04-03 10:00:00	CL	Stock	28.68	29.04	28.67	28.91	762400.0

> showing 50 of 29,598 rows — these rows as CSV

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