PREVIEW / stock_1hour / 2008-01-07

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-01-07.parquet
  size:    844 KB
  rows:    41,968
  symbols: 3,246

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-01-07 04:00:00	AAPL	Stock	6.4643	6.4643	6.4643	6.4643	11312.0
2008-01-07 05:00:00	AAPL	Stock	6.4911	6.4911	6.4911	6.4911	11200.0
2008-01-07 06:00:00	AAPL	Stock	6.4821	6.5268	6.4821	6.5268	105420.0
2008-01-07 07:00:00	AAPL	Stock	6.5268	6.5357	6.5007	6.5132	2079420.0
2008-01-07 08:00:00	AAPL	Stock	6.5107	6.5207	6.4304	6.48	12584124.0
2008-01-07 09:00:00	AAPL	Stock	6.4746	6.5571	6.4361	6.5229	223289920.0
2008-01-07 10:00:00	AAPL	Stock	6.5243	6.5471	6.0796	6.1804	540178940.0
2008-01-07 11:00:00	AAPL	Stock	6.1793	6.4721	6.175	6.3804	354518500.0
2008-01-07 12:00:00	AAPL	Stock	6.3796	6.4357	6.2964	6.4154	205734928.0
2008-01-07 13:00:00	AAPL	Stock	6.4154	6.4282	6.2971	6.3271	160992048.0
2008-01-07 14:00:00	AAPL	Stock	6.3271	6.3436	6.2043	6.2736	240080820.0
2008-01-07 15:00:00	AAPL	Stock	6.2725	6.3861	6.1429	6.3421	318821748.0
2008-01-07 16:00:00	AAPL	Stock	6.3481	6.3884	6.3007	6.3571	12458180.0
2008-01-07 17:00:00	AAPL	Stock	6.355	6.5188	6.3285	6.3464	703668.0
2008-01-07 18:00:00	AAPL	Stock	6.3464	6.3468	6.3393	6.3457	528444.0
2008-01-07 19:00:00	AAPL	Stock	6.3446	6.3514	6.3357	6.3357	474292.0
2008-01-07 07:00:00	MSFT	Stock	34.45	34.45	34.45	34.45	100.0
2008-01-07 08:00:00	MSFT	Stock	34.46	34.97	34.38	34.65	205636.0
2008-01-07 09:00:00	MSFT	Stock	34.68	34.8	34.43	34.66	7670549.0
2008-01-07 10:00:00	MSFT	Stock	34.66	34.67	34.25	34.48	16582272.0
2008-01-07 11:00:00	MSFT	Stock	34.49	34.74	34.42	34.65	11816532.0
2008-01-07 12:00:00	MSFT	Stock	34.64	34.76	34.49	34.68	8334782.0
2008-01-07 13:00:00	MSFT	Stock	34.68	34.77	34.44	34.46	7173431.0
2008-01-07 14:00:00	MSFT	Stock	34.46	34.59	34.31	34.44	9917119.0
2008-01-07 15:00:00	MSFT	Stock	34.44	34.78	34.26	34.65	16781286.0
2008-01-07 16:00:00	MSFT	Stock	34.62	34.7	34.505	34.65	1750192.0
2008-01-07 17:00:00	MSFT	Stock	34.68	34.73	34.58	34.58	5110.0
2008-01-07 18:00:00	MSFT	Stock	34.65	34.65	34.6	34.6	8092.0
2008-01-07 19:00:00	MSFT	Stock	34.6	34.62	34.6	34.62	1100.0
2008-01-07 08:00:00	NVDA	Stock	0.7578	0.7625	0.75	0.7575	22780200.0
2008-01-07 09:00:00	NVDA	Stock	0.7595	0.7612	0.7375	0.749	80594520.0
2008-01-07 10:00:00	NVDA	Stock	0.7492	0.7492	0.7125	0.723	123484840.0
2008-01-07 11:00:00	NVDA	Stock	0.723	0.7348	0.722	0.7303	83566080.0
2008-01-07 12:00:00	NVDA	Stock	0.7303	0.7328	0.7208	0.7265	66934120.0
2008-01-07 13:00:00	NVDA	Stock	0.7268	0.728	0.6978	0.7005	124099120.0
2008-01-07 14:00:00	NVDA	Stock	0.7008	0.728	0.6848	0.6895	172699360.0
2008-01-07 15:00:00	NVDA	Stock	0.6892	0.726	0.6588	0.6722	284725920.0
2008-01-07 16:00:00	NVDA	Stock	0.6722	0.7324	0.6705	0.675	55874320.0
2008-01-07 17:00:00	NVDA	Stock	0.6745	0.7479	0.67	0.677	631400.0
2008-01-07 18:00:00	NVDA	Stock	0.677	0.6795	0.6765	0.6795	51600.0
2008-01-07 19:00:00	NVDA	Stock	0.6793	0.6793	0.677	0.677	56400.0
2008-01-07 08:00:00	AMZN	Stock	4.475	4.5	4.4395	4.4615	271000.0
2008-01-07 09:00:00	AMZN	Stock	4.4525	4.4685	4.3755	4.4095	27984520.0
2008-01-07 10:00:00	AMZN	Stock	4.4115	4.4255	4.2735	4.363	38259780.0
2008-01-07 11:00:00	AMZN	Stock	4.364	4.4935	4.364	4.444	24274080.0
2008-01-07 12:00:00	AMZN	Stock	4.442	4.5285	4.421	4.5105	24163860.0
2008-01-07 13:00:00	AMZN	Stock	4.5125	4.5235	4.45	4.4605	20385500.0
2008-01-07 14:00:00	AMZN	Stock	4.4615	4.479	4.403	4.4285	19815680.0
2008-01-07 15:00:00	AMZN	Stock	4.4295	4.4925	4.3885	4.442	37207240.0
2008-01-07 16:00:00	AMZN	Stock	4.4415	4.464	4.4275	4.441	5489040.0

> showing 50 of 41,968 rows — these rows as CSV

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