PREVIEW / stock_1hour / 2008-09-17

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-09-17.parquet
  size:    925 KB
  rows:    46,225
  symbols: 3,365

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-09-17 06:00:00	AAPL	Stock	5.02	5.02	5.0132	5.0132	16800.0
2008-09-17 07:00:00	AAPL	Stock	5.0357	5.0357	4.9875	5.0107	191548.0
2008-09-17 08:00:00	AAPL	Stock	5.0007	5.025	4.9639	4.9757	2068808.0
2008-09-17 09:00:00	AAPL	Stock	4.9779	4.9814	4.7889	4.8771	125521060.0
2008-09-17 10:00:00	AAPL	Stock	4.8768	4.8971	4.7979	4.8409	159239024.0
2008-09-17 11:00:00	AAPL	Stock	4.8407	4.8489	4.6736	4.7443	152697160.0
2008-09-17 12:00:00	AAPL	Stock	4.7451	4.7839	4.6964	4.7296	106505196.0
2008-09-17 13:00:00	AAPL	Stock	4.7282	4.7696	4.6161	4.6596	135886660.0
2008-09-17 14:00:00	AAPL	Stock	4.6604	4.7479	4.5779	4.6864	193556412.0
2008-09-17 15:00:00	AAPL	Stock	4.685	4.7886	4.5664	4.5664	243555732.0
2008-09-17 16:00:00	AAPL	Stock	4.5714	4.748	4.5654	4.5654	55183632.0
2008-09-17 17:00:00	AAPL	Stock	4.6046	4.6805	4.5571	4.5786	1585472.0
2008-09-17 18:00:00	AAPL	Stock	4.5786	4.699	4.5714	4.5875	382704.0
2008-09-17 19:00:00	AAPL	Stock	4.585	4.5875	4.5639	4.5714	479052.0
2008-09-17 08:00:00	MSFT	Stock	26.0	26.1	25.8	25.84	32938.0
2008-09-17 09:00:00	MSFT	Stock	25.82	25.87	25.55	25.71	6457868.0
2008-09-17 10:00:00	MSFT	Stock	25.72	25.78	25.36	25.48	10558650.0
2008-09-17 11:00:00	MSFT	Stock	25.48	25.53	25.31	25.4	11307644.0
2008-09-17 12:00:00	MSFT	Stock	25.4	25.4	25.13	25.24	11534571.0
2008-09-17 13:00:00	MSFT	Stock	25.23	25.36	24.92	24.962	13836403.0
2008-09-17 14:00:00	MSFT	Stock	24.96	25.25	24.87	25.11	17015202.0
2008-09-17 15:00:00	MSFT	Stock	25.112	25.44	24.5	24.59	22416491.0
2008-09-17 16:00:00	MSFT	Stock	24.57	25.207	24.43	24.57	7231982.0
2008-09-17 17:00:00	MSFT	Stock	24.62	24.99	24.57	24.66	48943.0
2008-09-17 18:00:00	MSFT	Stock	24.66	24.83	24.54	24.6	3377348.0
2008-09-17 19:00:00	MSFT	Stock	24.63	24.63	24.58	24.6	12799.0
2008-09-17 08:00:00	NVDA	Stock	0.2425	0.2425	0.24	0.24	39000.0
2008-09-17 09:00:00	NVDA	Stock	0.2378	0.2435	0.232	0.2412	97064000.0
2008-09-17 10:00:00	NVDA	Stock	0.2412	0.2478	0.2402	0.246	248725760.0
2008-09-17 11:00:00	NVDA	Stock	0.2462	0.2464	0.239	0.2432	194244640.0
2008-09-17 12:00:00	NVDA	Stock	0.243	0.2488	0.2395	0.2438	194488680.0
2008-09-17 13:00:00	NVDA	Stock	0.244	0.2478	0.2425	0.2462	162989720.0
2008-09-17 14:00:00	NVDA	Stock	0.2465	0.2527	0.2453	0.2513	211440160.0
2008-09-17 15:00:00	NVDA	Stock	0.2513	0.2555	0.2495	0.2503	222860320.0
2008-09-17 16:00:00	NVDA	Stock	0.25	0.2525	0.2456	0.25	33823880.0
2008-09-17 17:00:00	NVDA	Stock	0.25	0.2523	0.25	0.2507	287800.0
2008-09-17 18:00:00	NVDA	Stock	0.25	0.2523	0.2498	0.2523	844800.0
2008-09-17 19:00:00	NVDA	Stock	0.25	0.2507	0.25	0.2503	1616880.0
2008-09-17 08:00:00	AMZN	Stock	3.9025	3.903	3.8715	3.8715	150300.0
2008-09-17 09:00:00	AMZN	Stock	3.875	3.912	3.75	3.775	20158620.0
2008-09-17 10:00:00	AMZN	Stock	3.7752	3.812	3.673	3.7145	46243240.0
2008-09-17 11:00:00	AMZN	Stock	3.714	3.7775	3.7	3.755	29272740.0
2008-09-17 12:00:00	AMZN	Stock	3.755	3.756	3.6795	3.712	24355300.0
2008-09-17 13:00:00	AMZN	Stock	3.711	3.7175	3.562	3.6255	36293080.0
2008-09-17 14:00:00	AMZN	Stock	3.626	3.699	3.6005	3.6805	35001100.0
2008-09-17 15:00:00	AMZN	Stock	3.6805	3.7705	3.5795	3.588	62285780.0
2008-09-17 16:00:00	AMZN	Stock	3.595	3.6984	3.575	3.577	905000.0
2008-09-17 17:00:00	AMZN	Stock	3.613	3.615	3.6	3.6	91540.0
2008-09-17 18:00:00	AMZN	Stock	3.6095	3.6105	3.598	3.6085	78000.0
2008-09-17 19:00:00	AMZN	Stock	3.577	3.6	3.577	3.6	75500.0

> showing 50 of 46,225 rows — these rows as CSV

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