PREVIEW / stock_1hour / 2006-08-11

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-08-11.parquet
  size:    571 KB
  rows:    27,663
  symbols: 2,305

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-08-11 06:00:00	AAPL	Stock	2.2839	2.2839	2.2839	2.2839	2800.0
2006-08-11 07:00:00	AAPL	Stock	2.2786	2.2821	2.2696	2.2736	236880.0
2006-08-11 08:00:00	AAPL	Stock	2.2818	2.2821	2.2214	2.2689	14093464.0
2006-08-11 09:00:00	AAPL	Stock	2.2689	2.2721	2.235	2.265	188694436.0
2006-08-11 10:00:00	AAPL	Stock	2.265	2.2904	2.2507	2.2768	163153424.0
2006-08-11 11:00:00	AAPL	Stock	2.2764	2.2864	2.2646	2.2682	72161152.0
2006-08-11 12:00:00	AAPL	Stock	2.2682	2.2732	2.255	2.2629	76208748.0
2006-08-11 13:00:00	AAPL	Stock	2.2629	2.2679	2.2554	2.2657	52951220.0
2006-08-11 14:00:00	AAPL	Stock	2.2654	2.2675	2.2457	2.2611	100381400.0
2006-08-11 15:00:00	AAPL	Stock	2.2611	2.2768	2.2561	2.2736	97642104.0
2006-08-11 16:00:00	AAPL	Stock	2.2736	2.275	2.2661	2.2682	5457704.0
2006-08-11 17:00:00	AAPL	Stock	2.2707	2.2725	2.2679	2.2725	299768.0
2006-08-11 18:00:00	AAPL	Stock	2.2696	2.2696	2.2696	2.2696	2800.0
2006-08-11 07:00:00	MSFT	Stock	24.37	24.38	24.37	24.37	3000.0
2006-08-11 08:00:00	MSFT	Stock	24.4	24.43	24.37	24.42	1850.0
2006-08-11 09:00:00	MSFT	Stock	24.39	24.43	24.23	24.26	3396668.0
2006-08-11 10:00:00	MSFT	Stock	24.26	24.37	24.2	24.33	4430817.0
2006-08-11 11:00:00	MSFT	Stock	24.33	24.36	24.25	24.27	4660735.0
2006-08-11 12:00:00	MSFT	Stock	24.27	24.3	24.25	24.28	2857044.0
2006-08-11 13:00:00	MSFT	Stock	24.28	24.33	24.23	24.3	3592188.0
2006-08-11 14:00:00	MSFT	Stock	24.3	24.35	24.29	24.34	3024603.0
2006-08-11 15:00:00	MSFT	Stock	24.34	24.45	24.31	24.43	6330542.0
2006-08-11 16:00:00	MSFT	Stock	24.42	24.5	24.35	24.38	574811.0
2006-08-11 17:00:00	MSFT	Stock	24.43	24.43	24.43	24.43	450.0
2006-08-11 07:00:00	NVDA	Stock	0.3672	0.3672	0.3625	0.3637	1188000.0
2006-08-11 08:00:00	NVDA	Stock	0.365	0.3772	0.3617	0.3725	54093300.0
2006-08-11 09:00:00	NVDA	Stock	0.374	0.3957	0.3713	0.3898	478819920.0
2006-08-11 10:00:00	NVDA	Stock	0.39	0.4002	0.388	0.3937	311892660.0
2006-08-11 11:00:00	NVDA	Stock	0.3937	0.3965	0.3883	0.3932	158953740.0
2006-08-11 12:00:00	NVDA	Stock	0.3932	0.3948	0.3917	0.3933	107816460.0
2006-08-11 13:00:00	NVDA	Stock	0.3933	0.3935	0.385	0.388	114037800.0
2006-08-11 14:00:00	NVDA	Stock	0.388	0.3907	0.3875	0.389	98490420.0
2006-08-11 15:00:00	NVDA	Stock	0.3888	0.3933	0.3882	0.3902	175556400.0
2006-08-11 16:00:00	NVDA	Stock	0.3905	0.3922	0.3903	0.3913	2526960.0
2006-08-11 17:00:00	NVDA	Stock	0.3922	0.3922	0.3917	0.3922	126000.0
2006-08-11 18:00:00	NVDA	Stock	0.391	0.391	0.391	0.391	30000.0
2006-08-11 09:00:00	AMZN	Stock	1.3185	1.3215	1.301	1.3015	7531260.0
2006-08-11 10:00:00	AMZN	Stock	1.3015	1.302	1.295	1.3006	14766800.0
2006-08-11 11:00:00	AMZN	Stock	1.3005	1.3025	1.2955	1.2955	6648740.0
2006-08-11 12:00:00	AMZN	Stock	1.2955	1.296	1.288	1.2894	14243740.0
2006-08-11 13:00:00	AMZN	Stock	1.2895	1.2945	1.288	1.292	11362280.0
2006-08-11 14:00:00	AMZN	Stock	1.2915	1.3046	1.291	1.303	12400260.0
2006-08-11 15:00:00	AMZN	Stock	1.303	1.312	1.2995	1.304	33136040.0
2006-08-11 16:00:00	AMZN	Stock	1.302	1.306	1.2995	1.3	107700.0
2006-08-11 17:00:00	AMZN	Stock	1.304	1.304	1.304	1.304	15700.0
2006-08-11 09:00:00	CL	Stock	29.8	29.87	29.655	29.665	351000.0
2006-08-11 10:00:00	CL	Stock	29.665	29.695	29.57	29.65	391400.0
2006-08-11 11:00:00	CL	Stock	29.655	29.675	29.575	29.625	264800.0
2006-08-11 12:00:00	CL	Stock	29.615	29.65	29.55	29.56	351600.0
2006-08-11 13:00:00	CL	Stock	29.56	29.67	29.505	29.665	389800.0

> showing 50 of 27,663 rows — these rows as CSV

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