PREVIEW / stock_1hour / 2006-08-10

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-08-10.parquet
  size:    618 KB
  rows:    29,529
  symbols: 2,312

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-10 04:00:00	AAPL	Stock	2.2618	2.2618	2.2614	2.2614	56000.0
2006-08-10 07:00:00	AAPL	Stock	2.2536	2.2536	2.2536	2.2536	2800.0
2006-08-10 08:00:00	AAPL	Stock	2.2571	2.2625	2.2511	2.2589	844424.0
2006-08-10 09:00:00	AAPL	Stock	2.2607	2.2921	2.2393	2.2807	114415112.0
2006-08-10 10:00:00	AAPL	Stock	2.2807	2.3007	2.2621	2.2986	146883380.0
2006-08-10 11:00:00	AAPL	Stock	2.2989	2.3146	2.2929	2.3036	118290340.0
2006-08-10 12:00:00	AAPL	Stock	2.3036	2.3043	2.2782	2.2854	80065692.0
2006-08-10 13:00:00	AAPL	Stock	2.2854	2.2961	2.2775	2.2893	50576876.0
2006-08-10 14:00:00	AAPL	Stock	2.2893	2.3029	2.2779	2.2814	75623688.0
2006-08-10 15:00:00	AAPL	Stock	2.2814	2.2911	2.2718	2.2875	106895152.0
2006-08-10 16:00:00	AAPL	Stock	2.2871	2.2882	2.2843	2.2843	434812.0
2006-08-10 17:00:00	AAPL	Stock	2.2857	2.2877	2.2857	2.2857	172480.0
2006-08-10 18:00:00	AAPL	Stock	2.2864	2.2864	2.2857	2.2857	71484.0
2006-08-10 06:00:00	MSFT	Stock	24.27	24.27	24.27	24.27	1000.0
2006-08-10 07:00:00	MSFT	Stock	24.34	24.34	24.34	24.34	200.0
2006-08-10 08:00:00	MSFT	Stock	24.25	24.36	24.25	24.32	35990.0
2006-08-10 09:00:00	MSFT	Stock	24.44	24.6	24.33	24.43	5024312.0
2006-08-10 10:00:00	MSFT	Stock	24.43	24.53	24.36	24.41	4298943.0
2006-08-10 11:00:00	MSFT	Stock	24.41	24.49	24.39	24.46	2582024.0
2006-08-10 12:00:00	MSFT	Stock	24.47	24.49	24.389	24.41	2926602.0
2006-08-10 13:00:00	MSFT	Stock	24.4	24.44	24.34	24.39	3691717.0
2006-08-10 14:00:00	MSFT	Stock	24.392	24.49	24.36	24.38	3781823.0
2006-08-10 15:00:00	MSFT	Stock	24.39	24.47	24.36	24.45	5794623.0
2006-08-10 16:00:00	MSFT	Stock	24.44	24.47	24.43	24.46	1352269.0
2006-08-10 17:00:00	MSFT	Stock	24.455	24.455	24.455	24.455	3101.0
2006-08-10 18:00:00	MSFT	Stock	24.43	24.43	24.4	24.4	15369.0
2006-08-10 08:00:00	NVDA	Stock	0.4003	0.4043	0.4003	0.4037	144000.0
2006-08-10 09:00:00	NVDA	Stock	0.402	0.4037	0.3942	0.3993	81492840.0
2006-08-10 10:00:00	NVDA	Stock	0.3993	0.3997	0.3945	0.3967	95871000.0
2006-08-10 11:00:00	NVDA	Stock	0.3967	0.4007	0.3948	0.3997	110854260.0
2006-08-10 12:00:00	NVDA	Stock	0.3997	0.4008	0.3977	0.3998	60275160.0
2006-08-10 13:00:00	NVDA	Stock	0.4	0.4022	0.3983	0.4017	73316040.0
2006-08-10 14:00:00	NVDA	Stock	0.4017	0.405	0.3987	0.3995	94341660.0
2006-08-10 15:00:00	NVDA	Stock	0.3995	0.4033	0.3962	0.4025	248019600.0
2006-08-10 16:00:00	NVDA	Stock	0.4012	0.4092	0.356	0.3665	207218760.0
2006-08-10 17:00:00	NVDA	Stock	0.3662	0.4026	0.3625	0.3717	96213600.0
2006-08-10 18:00:00	NVDA	Stock	0.3718	0.3763	0.3702	0.3702	11119200.0
2006-08-10 08:00:00	AMZN	Stock	1.3005	1.3005	1.298	1.3	13340.0
2006-08-10 09:00:00	AMZN	Stock	1.306	1.3125	1.294	1.3095	13295280.0
2006-08-10 10:00:00	AMZN	Stock	1.309	1.3105	1.295	1.301	15138380.0
2006-08-10 11:00:00	AMZN	Stock	1.3015	1.3125	1.2975	1.2995	16839340.0
2006-08-10 12:00:00	AMZN	Stock	1.2995	1.3055	1.295	1.3005	17002680.0
2006-08-10 13:00:00	AMZN	Stock	1.3005	1.3065	1.297	1.3005	11731760.0
2006-08-10 14:00:00	AMZN	Stock	1.301	1.3105	1.299	1.3059	22610080.0
2006-08-10 15:00:00	AMZN	Stock	1.3055	1.326	1.305	1.323	28599520.0
2006-08-10 16:00:00	AMZN	Stock	1.3235	1.3235	1.3195	1.32	700380.0
2006-08-10 17:00:00	AMZN	Stock	1.322	1.3242	1.322	1.3242	17200.0
2006-08-10 09:00:00	CL	Stock	29.555	29.685	29.515	29.655	221800.0
2006-08-10 10:00:00	CL	Stock	29.655	29.76	29.5515	29.65	459200.0
2006-08-10 11:00:00	CL	Stock	29.655	29.835	29.615	29.83	394200.0

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

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