PREVIEW / stock_1hour / 2008-04-30

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-04-30.parquet
  size:    849 KB
  rows:    40,555
  symbols: 3,289

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
2008-04-30 04:00:00	AAPL	Stock	6.2318	6.2318	6.2318	6.2318	2800.0
2008-04-30 06:00:00	AAPL	Stock	6.2336	6.2336	6.2336	6.2336	2800.0
2008-04-30 07:00:00	AAPL	Stock	6.2668	6.2668	6.25	6.25	169400.0
2008-04-30 08:00:00	AAPL	Stock	6.2529	6.3071	6.2446	6.3011	7022680.0
2008-04-30 09:00:00	AAPL	Stock	6.3018	6.3782	6.2786	6.3582	181233500.0
2008-04-30 10:00:00	AAPL	Stock	6.3582	6.3757	6.3275	6.3663	138778752.0
2008-04-30 11:00:00	AAPL	Stock	6.3664	6.3875	6.3443	6.3614	104630176.0
2008-04-30 12:00:00	AAPL	Stock	6.3621	6.4286	6.3254	6.3479	73153780.0
2008-04-30 13:00:00	AAPL	Stock	6.3469	6.3686	6.3429	6.3529	57169112.0
2008-04-30 14:00:00	AAPL	Stock	6.3532	6.3711	6.2461	6.2468	199524612.0
2008-04-30 15:00:00	AAPL	Stock	6.2464	6.2643	6.1757	6.2179	328194328.0
2008-04-30 16:00:00	AAPL	Stock	6.2179	6.3302	6.2089	6.2196	20802432.0
2008-04-30 17:00:00	AAPL	Stock	6.2196	6.3426	6.2125	6.2318	1339940.0
2008-04-30 18:00:00	AAPL	Stock	6.2318	6.2371	6.1504	6.2357	396648.0
2008-04-30 19:00:00	AAPL	Stock	6.2343	6.2407	6.2325	6.2354	426048.0
2008-04-30 07:00:00	MSFT	Stock	28.7	28.78	28.69	28.78	700.0
2008-04-30 08:00:00	MSFT	Stock	28.7	28.85	28.7	28.79	30438.0
2008-04-30 09:00:00	MSFT	Stock	28.79	28.85	28.52	28.56	6549765.0
2008-04-30 10:00:00	MSFT	Stock	28.56	28.96	28.52	28.84	8677088.0
2008-04-30 11:00:00	MSFT	Stock	28.85	29.21	28.83	29.128	9029682.0
2008-04-30 12:00:00	MSFT	Stock	29.13	29.18	29.0	29.09	4908829.0
2008-04-30 13:00:00	MSFT	Stock	29.09	29.15	28.872	28.88	4920409.0
2008-04-30 14:00:00	MSFT	Stock	28.888	29.16	28.74	28.76	11811875.0
2008-04-30 15:00:00	MSFT	Stock	28.75	28.76	28.51	28.53	17864849.0
2008-04-30 16:00:00	MSFT	Stock	28.53	28.828	28.5	28.55	5609054.0
2008-04-30 17:00:00	MSFT	Stock	28.55	28.612	28.52	28.56	421226.0
2008-04-30 18:00:00	MSFT	Stock	28.59	28.805	28.235	28.55	79834.0
2008-04-30 19:00:00	MSFT	Stock	28.56	28.6	28.5	28.5	32018.0
2008-04-30 08:00:00	NVDA	Stock	0.5	0.51	0.5	0.51	2740600.0
2008-04-30 09:00:00	NVDA	Stock	0.5088	0.5142	0.5075	0.5138	103981200.0
2008-04-30 10:00:00	NVDA	Stock	0.5138	0.5165	0.5108	0.5127	156472880.0
2008-04-30 11:00:00	NVDA	Stock	0.5128	0.5168	0.512	0.5152	127746080.0
2008-04-30 12:00:00	NVDA	Stock	0.5155	0.5182	0.5142	0.5162	85623840.0
2008-04-30 13:00:00	NVDA	Stock	0.5165	0.5182	0.5158	0.5171	75507680.0
2008-04-30 14:00:00	NVDA	Stock	0.5173	0.5192	0.513	0.5138	211530320.0
2008-04-30 15:00:00	NVDA	Stock	0.5138	0.5178	0.5112	0.5138	259307520.0
2008-04-30 16:00:00	NVDA	Stock	0.5142	0.5152	0.505	0.505	25479120.0
2008-04-30 17:00:00	NVDA	Stock	0.515	0.515	0.5142	0.5145	112000.0
2008-04-30 18:00:00	NVDA	Stock	0.515	0.5162	0.5138	0.5142	456080.0
2008-04-30 19:00:00	NVDA	Stock	0.5142	0.5142	0.5142	0.5142	20000.0
2008-04-30 08:00:00	AMZN	Stock	4.0425	4.0425	4.02	4.0375	13400.0
2008-04-30 09:00:00	AMZN	Stock	4.046	4.048	3.9755	3.993	15387740.0
2008-04-30 10:00:00	AMZN	Stock	3.9925	4.0465	3.985	4.0375	18366660.0
2008-04-30 11:00:00	AMZN	Stock	4.0375	4.067	4.01	4.026	13265800.0
2008-04-30 12:00:00	AMZN	Stock	4.026	4.03	3.991	4.0175	11479660.0
2008-04-30 13:00:00	AMZN	Stock	4.0175	4.018	3.985	3.9885	10282700.0
2008-04-30 14:00:00	AMZN	Stock	3.9895	4.0225	3.957	3.957	34731880.0
2008-04-30 15:00:00	AMZN	Stock	3.9575	3.958	3.896	3.9375	45298600.0
2008-04-30 16:00:00	AMZN	Stock	3.9355	4.037	3.931	3.945	2163620.0
2008-04-30 17:00:00	AMZN	Stock	3.945	3.945	3.9315	3.94	904420.0

> showing 50 of 40,555 rows — these rows as CSV

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