PREVIEW / stock_1hour / 2009-01-29

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-01-29.parquet
  size:    811 KB
  rows:    40,746
  symbols: 3,290

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
2009-01-29 05:00:00	AAPL	Stock	3.3096	3.3096	3.3096	3.3096	6132.0
2009-01-29 08:00:00	AAPL	Stock	3.3214	3.3371	3.3214	3.325	753480.0
2009-01-29 09:00:00	AAPL	Stock	3.3268	3.3454	3.3146	3.3275	84378112.0
2009-01-29 10:00:00	AAPL	Stock	3.3275	3.3575	3.3168	3.3504	112376404.0
2009-01-29 11:00:00	AAPL	Stock	3.3504	3.3693	3.3439	3.3518	73784816.0
2009-01-29 12:00:00	AAPL	Stock	3.3514	3.3564	3.325	3.3271	63434280.0
2009-01-29 13:00:00	AAPL	Stock	3.3271	3.3304	3.3111	3.3232	64523172.0
2009-01-29 14:00:00	AAPL	Stock	3.3225	3.3368	3.3146	3.3293	59598532.0
2009-01-29 15:00:00	AAPL	Stock	3.3289	3.3414	3.3071	3.3214	118016360.0
2009-01-29 16:00:00	AAPL	Stock	3.3189	3.3332	3.3082	3.3282	4545492.0
2009-01-29 17:00:00	AAPL	Stock	3.3243	3.3439	3.3214	3.325	5985840.0
2009-01-29 18:00:00	AAPL	Stock	3.3214	3.325	3.32	3.3221	169120.0
2009-01-29 19:00:00	AAPL	Stock	3.3232	3.3232	3.3082	3.3179	181860.0
2009-01-29 20:00:00	AAPL	Stock	3.3539	3.3539	3.3539	3.3539	231868.0
2009-01-29 07:00:00	MSFT	Stock	18.0	18.02	17.75	17.99	3340.0
2009-01-29 08:00:00	MSFT	Stock	17.99	17.99	17.82	17.84	14460.0
2009-01-29 09:00:00	MSFT	Stock	17.82	17.93	17.7	17.81	5437259.0
2009-01-29 10:00:00	MSFT	Stock	17.8	17.93	17.75	17.91	5626230.0
2009-01-29 11:00:00	MSFT	Stock	17.91	17.96	17.77	17.812	4490481.0
2009-01-29 12:00:00	MSFT	Stock	17.81	17.83	17.68	17.69	4689015.0
2009-01-29 13:00:00	MSFT	Stock	17.69	17.7	17.56	17.66	4319647.0
2009-01-29 14:00:00	MSFT	Stock	17.66	17.87	17.64	17.785	6995153.0
2009-01-29 15:00:00	MSFT	Stock	17.79	17.89	17.58	17.6	13117898.0
2009-01-29 16:00:00	MSFT	Stock	17.6	17.93	17.59	17.63	3477632.0
2009-01-29 17:00:00	MSFT	Stock	17.68	17.792	17.59	17.64	676399.0
2009-01-29 18:00:00	MSFT	Stock	17.69	17.69	17.64	17.64	1600.0
2009-01-29 19:00:00	MSFT	Stock	17.63	17.66	17.61	17.61	1568.0
2009-01-29 20:00:00	MSFT	Stock	17.82	17.82	17.82	17.82	13664.0
2009-01-29 08:00:00	NVDA	Stock	0.2135	0.2135	0.2135	0.2135	20000.0
2009-01-29 09:00:00	NVDA	Stock	0.2128	0.215	0.2095	0.2095	55273320.0
2009-01-29 10:00:00	NVDA	Stock	0.2095	0.211	0.207	0.2108	87536400.0
2009-01-29 11:00:00	NVDA	Stock	0.2108	0.2115	0.2082	0.21	46967560.0
2009-01-29 12:00:00	NVDA	Stock	0.21	0.2102	0.207	0.2072	40235920.0
2009-01-29 13:00:00	NVDA	Stock	0.2072	0.208	0.206	0.2078	47521080.0
2009-01-29 14:00:00	NVDA	Stock	0.2078	0.209	0.2065	0.2078	40300160.0
2009-01-29 15:00:00	NVDA	Stock	0.208	0.209	0.206	0.2072	77427840.0
2009-01-29 16:00:00	NVDA	Stock	0.2065	0.2088	0.205	0.205	449000.0
2009-01-29 17:00:00	NVDA	Stock	0.207	0.207	0.2062	0.207	4388400.0
2009-01-29 18:00:00	NVDA	Stock	0.2075	0.2075	0.2075	0.2075	16000.0
2009-01-29 19:00:00	NVDA	Stock	0.2075	0.2075	0.2075	0.2075	20000.0
2009-01-29 08:00:00	AMZN	Stock	2.485	2.485	2.4575	2.4845	143540.0
2009-01-29 09:00:00	AMZN	Stock	2.4825	2.559	2.475	2.4885	29017740.0
2009-01-29 10:00:00	AMZN	Stock	2.488	2.5515	2.457	2.545	39034400.0
2009-01-29 11:00:00	AMZN	Stock	2.5445	2.574	2.541	2.5725	24485840.0
2009-01-29 12:00:00	AMZN	Stock	2.5725	2.5925	2.5295	2.53	25580840.0
2009-01-29 13:00:00	AMZN	Stock	2.5305	2.535	2.494	2.5045	28261640.0
2009-01-29 14:00:00	AMZN	Stock	2.505	2.5515	2.5025	2.54	24860100.0
2009-01-29 15:00:00	AMZN	Stock	2.54	2.561	2.492	2.5	69639640.0
2009-01-29 16:00:00	AMZN	Stock	2.5015	2.85	2.482	2.8155	94382920.0
2009-01-29 17:00:00	AMZN	Stock	2.8215	2.8435	2.5	2.8245	18473600.0

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

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