PREVIEW / stock_1hour / 2008-09-24

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-09-24.parquet
  size:    830 KB
  rows:    40,939
  symbols: 3,323

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-24 05:00:00	AAPL	Stock	4.6071	4.6071	4.5732	4.5732	15680.0
2008-09-24 06:00:00	AAPL	Stock	4.6071	4.6071	4.5714	4.5893	54880.0
2008-09-24 07:00:00	AAPL	Stock	4.5893	4.6246	4.5375	4.5614	428988.0
2008-09-24 08:00:00	AAPL	Stock	4.5607	4.5889	4.5464	4.5857	4372452.0
2008-09-24 09:00:00	AAPL	Stock	4.5857	4.5929	4.4696	4.5614	164378564.0
2008-09-24 10:00:00	AAPL	Stock	4.5618	4.6429	4.5043	4.6396	193036872.0
2008-09-24 11:00:00	AAPL	Stock	4.6382	4.6539	4.5639	4.5945	135447396.0
2008-09-24 12:00:00	AAPL	Stock	4.5949	4.6321	4.5714	4.6121	80715964.0
2008-09-24 13:00:00	AAPL	Stock	4.6114	4.6511	4.5936	4.6093	125856500.0
2008-09-24 14:00:00	AAPL	Stock	4.61	4.6768	4.6011	4.6318	122292072.0
2008-09-24 15:00:00	AAPL	Stock	4.6314	4.6518	4.5318	4.5971	194311684.0
2008-09-24 16:00:00	AAPL	Stock	4.6032	4.6214	4.5536	4.5543	14551712.0
2008-09-24 17:00:00	AAPL	Stock	4.5543	4.5968	4.5536	4.5857	1808128.0
2008-09-24 18:00:00	AAPL	Stock	4.5886	4.6071	4.5821	4.5964	243208.0
2008-09-24 19:00:00	AAPL	Stock	4.6	4.6036	4.5821	4.5946	193564.0
2008-09-24 07:00:00	MSFT	Stock	25.7	25.7	25.69	25.69	300.0
2008-09-24 08:00:00	MSFT	Stock	25.66	25.84	25.61	25.75	79505.0
2008-09-24 09:00:00	MSFT	Stock	25.75	25.77	25.44	25.53	8648666.0
2008-09-24 10:00:00	MSFT	Stock	25.52	25.8	25.46	25.76	11117741.0
2008-09-24 11:00:00	MSFT	Stock	25.75	25.76	25.5	25.63	7627032.0
2008-09-24 12:00:00	MSFT	Stock	25.64	25.78	25.54	25.714	8313207.0
2008-09-24 13:00:00	MSFT	Stock	25.725	26.09	25.7	25.918	11685946.0
2008-09-24 14:00:00	MSFT	Stock	25.92	26.05	25.82	25.85	8123891.0
2008-09-24 15:00:00	MSFT	Stock	25.84	25.99	25.53	25.75	13831013.0
2008-09-24 16:00:00	MSFT	Stock	25.72	25.93	25.64	25.85	9769665.0
2008-09-24 17:00:00	MSFT	Stock	25.85	25.89	25.72	25.85	416873.0
2008-09-24 18:00:00	MSFT	Stock	25.83	25.83	25.79	25.79	1586.0
2008-09-24 19:00:00	MSFT	Stock	25.75	25.81	25.75	25.81	3875.0
2008-09-24 07:00:00	NVDA	Stock	0.3223	0.3223	0.3223	0.3223	20000.0
2008-09-24 08:00:00	NVDA	Stock	0.282	0.2822	0.282	0.2822	159600.0
2008-09-24 09:00:00	NVDA	Stock	0.28	0.281	0.2663	0.2768	70033520.0
2008-09-24 10:00:00	NVDA	Stock	0.277	0.282	0.273	0.281	151181600.0
2008-09-24 11:00:00	NVDA	Stock	0.281	0.284	0.2788	0.2829	97409360.0
2008-09-24 12:00:00	NVDA	Stock	0.2828	0.283	0.2788	0.282	105502400.0
2008-09-24 13:00:00	NVDA	Stock	0.282	0.2868	0.2812	0.2841	98954400.0
2008-09-24 14:00:00	NVDA	Stock	0.284	0.2868	0.2825	0.2848	144125880.0
2008-09-24 15:00:00	NVDA	Stock	0.2848	0.2862	0.279	0.2815	169170960.0
2008-09-24 16:00:00	NVDA	Stock	0.2835	0.285	0.281	0.281	1417360.0
2008-09-24 17:00:00	NVDA	Stock	0.2812	0.2812	0.2812	0.2812	1091520.0
2008-09-24 18:00:00	NVDA	Stock	0.2805	0.2805	0.2805	0.2805	12000.0
2008-09-24 19:00:00	NVDA	Stock	0.281	0.281	0.281	0.281	36000.0
2008-09-24 08:00:00	AMZN	Stock	3.625	3.66	3.625	3.6405	26000.0
2008-09-24 09:00:00	AMZN	Stock	3.6405	3.6825	3.547	3.581	27618780.0
2008-09-24 10:00:00	AMZN	Stock	3.5795	3.6035	3.55	3.5785	26973260.0
2008-09-24 11:00:00	AMZN	Stock	3.5785	3.6285	3.5515	3.5665	21335040.0
2008-09-24 12:00:00	AMZN	Stock	3.5665	3.5985	3.554	3.5636	8502060.0
2008-09-24 13:00:00	AMZN	Stock	3.565	3.586	3.491	3.512	21172540.0
2008-09-24 14:00:00	AMZN	Stock	3.512	3.543	3.473	3.4908	27979400.0
2008-09-24 15:00:00	AMZN	Stock	3.4905	3.5	3.447	3.498	47249580.0
2008-09-24 16:00:00	AMZN	Stock	3.5005	3.5443	3.4799	3.52	4358660.0

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

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