PREVIEW / stock_1hour / 2006-05-23

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-05-23.parquet
  size:    610 KB
  rows:    28,908
  symbols: 2,268

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-05-23 05:00:00	AAPL	Stock	2.2696	2.2696	2.2696	2.2696	2800.0
2006-05-23 07:00:00	AAPL	Stock	2.2696	2.2818	2.2696	2.2786	125384.0
2006-05-23 08:00:00	AAPL	Stock	2.2821	2.2896	2.2768	2.2857	1386252.0
2006-05-23 09:00:00	AAPL	Stock	2.2857	2.3282	2.2854	2.2971	140739088.0
2006-05-23 10:00:00	AAPL	Stock	2.2971	2.3164	2.2718	2.2979	165642344.0
2006-05-23 11:00:00	AAPL	Stock	2.2979	2.3161	2.2821	2.2899	78825460.0
2006-05-23 12:00:00	AAPL	Stock	2.2896	2.2964	2.2832	2.2875	42632996.0
2006-05-23 13:00:00	AAPL	Stock	2.2879	2.3046	2.2868	2.2932	47185880.0
2006-05-23 14:00:00	AAPL	Stock	2.2939	2.2946	2.2796	2.2832	65489704.0
2006-05-23 15:00:00	AAPL	Stock	2.2836	2.29	2.25	2.2504	139272056.0
2006-05-23 16:00:00	AAPL	Stock	2.2504	2.2521	2.2293	2.2432	5673388.0
2006-05-23 17:00:00	AAPL	Stock	2.2432	2.2443	2.2411	2.2429	1030344.0
2006-05-23 18:00:00	AAPL	Stock	2.2421	2.25	2.2393	2.2411	333816.0
2006-05-23 07:00:00	MSFT	Stock	22.92	22.92	22.89	22.89	2000.0
2006-05-23 08:00:00	MSFT	Stock	22.92	23.1	22.92	23.06	125634.0
2006-05-23 09:00:00	MSFT	Stock	23.06	23.38	23.05	23.26	16903334.0
2006-05-23 10:00:00	MSFT	Stock	23.26	23.29	23.22	23.26	11463193.0
2006-05-23 11:00:00	MSFT	Stock	23.26	23.26	23.14	23.18	9983835.0
2006-05-23 12:00:00	MSFT	Stock	23.17	23.24	23.1	23.15	7122233.0
2006-05-23 13:00:00	MSFT	Stock	23.14	23.18	23.11	23.14	5005745.0
2006-05-23 14:00:00	MSFT	Stock	23.14	23.27	23.06	23.12	12202553.0
2006-05-23 15:00:00	MSFT	Stock	23.12	23.18	22.77	22.77	14898924.0
2006-05-23 16:00:00	MSFT	Stock	22.77	23.05	22.67	22.67	569032.0
2006-05-23 17:00:00	MSFT	Stock	22.67	22.76	22.67	22.7	47849.0
2006-05-23 18:00:00	MSFT	Stock	22.73	22.77	22.7	22.76	15231.0
2006-05-23 08:00:00	NVDA	Stock	0.405	0.4092	0.405	0.409	150000.0
2006-05-23 09:00:00	NVDA	Stock	0.409	0.4178	0.4075	0.4108	140719920.0
2006-05-23 10:00:00	NVDA	Stock	0.411	0.4137	0.4103	0.4125	59020740.0
2006-05-23 11:00:00	NVDA	Stock	0.4125	0.4138	0.4063	0.4075	71358900.0
2006-05-23 12:00:00	NVDA	Stock	0.4077	0.4082	0.4042	0.4051	33480300.0
2006-05-23 13:00:00	NVDA	Stock	0.4052	0.4077	0.405	0.4052	32179620.0
2006-05-23 14:00:00	NVDA	Stock	0.4053	0.4083	0.4012	0.4023	48539040.0
2006-05-23 15:00:00	NVDA	Stock	0.4025	0.4028	0.394	0.3952	119638740.0
2006-05-23 16:00:00	NVDA	Stock	0.3953	0.3995	0.3947	0.3958	14131200.0
2006-05-23 17:00:00	NVDA	Stock	0.3975	0.3975	0.3972	0.3972	18000.0
2006-05-23 18:00:00	NVDA	Stock	0.3958	0.3958	0.3955	0.3955	78600.0
2006-05-23 09:00:00	AMZN	Stock	1.7435	1.8	1.7425	1.7645	32877100.0
2006-05-23 10:00:00	AMZN	Stock	1.7645	1.773	1.752	1.7525	24645060.0
2006-05-23 11:00:00	AMZN	Stock	1.752	1.757	1.737	1.755	28951920.0
2006-05-23 12:00:00	AMZN	Stock	1.755	1.7625	1.7465	1.75	13168360.0
2006-05-23 13:00:00	AMZN	Stock	1.75	1.768	1.737	1.737	15565700.0
2006-05-23 14:00:00	AMZN	Stock	1.737	1.743	1.715	1.7225	21050840.0
2006-05-23 15:00:00	AMZN	Stock	1.7225	1.7335	1.688	1.688	35707760.0
2006-05-23 16:00:00	AMZN	Stock	1.689	1.691	1.67	1.67	1419780.0
2006-05-23 18:00:00	AMZN	Stock	1.688	1.688	1.67	1.67	41540.0
2006-05-23 09:00:00	CL	Stock	30.01	30.1	29.95	30.065	822000.0
2006-05-23 10:00:00	CL	Stock	30.06	30.195	30.0	30.13	508000.0
2006-05-23 11:00:00	CL	Stock	30.145	30.195	30.065	30.125	399200.0
2006-05-23 12:00:00	CL	Stock	30.12	30.12	29.905	29.905	553000.0
2006-05-23 13:00:00	CL	Stock	29.91	29.96	29.82	29.83	349800.0

> showing 50 of 28,908 rows — these rows as CSV

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