PREVIEW / stock_1hour / 2009-03-30

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-03-30.parquet
  size:    803 KB
  rows:    39,819
  symbols: 3,305

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-03-30 04:00:00	AAPL	Stock	3.7321	3.7321	3.6861	3.6861	50960.0
2009-03-30 05:00:00	AAPL	Stock	3.6675	3.6718	3.6675	3.6718	8400.0
2009-03-30 06:00:00	AAPL	Stock	3.6704	3.6704	3.6686	3.6686	16800.0
2009-03-30 07:00:00	AAPL	Stock	3.6893	3.7321	3.6893	3.7214	140504.0
2009-03-30 08:00:00	AAPL	Stock	3.7214	3.7336	3.71	3.7268	1215508.0
2009-03-30 09:00:00	AAPL	Stock	3.7311	3.7504	3.7143	3.7336	70790300.0
2009-03-30 10:00:00	AAPL	Stock	3.7321	3.74	3.6646	3.6818	87977708.0
2009-03-30 11:00:00	AAPL	Stock	3.6811	3.7079	3.6761	3.6925	52578176.0
2009-03-30 12:00:00	AAPL	Stock	3.6918	3.7125	3.6825	3.6961	36240092.0
2009-03-30 13:00:00	AAPL	Stock	3.6964	3.7	3.6664	3.6868	48397300.0
2009-03-30 14:00:00	AAPL	Stock	3.6864	3.7082	3.6711	3.6757	57137024.0
2009-03-30 15:00:00	AAPL	Stock	3.6764	3.7321	3.6732	3.7304	114480604.0
2009-03-30 16:00:00	AAPL	Stock	3.7307	3.7449	3.6875	3.7318	26587736.0
2009-03-30 17:00:00	AAPL	Stock	3.7375	3.7389	3.7357	3.7357	220892.0
2009-03-30 18:00:00	AAPL	Stock	3.7375	3.7411	3.7357	3.7411	121856.0
2009-03-30 19:00:00	AAPL	Stock	3.7446	3.7496	3.7446	3.7496	48020.0
2009-03-30 04:00:00	MSFT	Stock	17.96	18.01	17.8	17.8	1500.0
2009-03-30 07:00:00	MSFT	Stock	17.81	17.86	17.8	17.8	1219.0
2009-03-30 08:00:00	MSFT	Stock	17.89	18.02	17.75	17.76	34007.0
2009-03-30 09:00:00	MSFT	Stock	17.76	17.79	17.33	17.44	6998818.0
2009-03-30 10:00:00	MSFT	Stock	17.45	17.54	17.41	17.41	7686429.0
2009-03-30 11:00:00	MSFT	Stock	17.42	17.47	17.27	17.39	6791146.0
2009-03-30 12:00:00	MSFT	Stock	17.39	17.54	17.38	17.44	4445118.0
2009-03-30 13:00:00	MSFT	Stock	17.44	17.45	17.34	17.44	3881618.0
2009-03-30 14:00:00	MSFT	Stock	17.44	17.52	17.34	17.34	4296410.0
2009-03-30 15:00:00	MSFT	Stock	17.35	17.61	17.34	17.49	10615459.0
2009-03-30 16:00:00	MSFT	Stock	17.48	17.55	17.4	17.55	3849425.0
2009-03-30 17:00:00	MSFT	Stock	17.5	17.56	17.48	17.56	2281.0
2009-03-30 18:00:00	MSFT	Stock	17.48	17.6	17.48	17.52	202172.0
2009-03-30 19:00:00	MSFT	Stock	17.54	17.6	17.54	17.6	2550.0
2009-03-30 08:00:00	NVDA	Stock	0.2575	0.2575	0.2505	0.2505	422000.0
2009-03-30 09:00:00	NVDA	Stock	0.251	0.256	0.2461	0.2485	90782680.0
2009-03-30 10:00:00	NVDA	Stock	0.2485	0.2503	0.2425	0.243	161227160.0
2009-03-30 11:00:00	NVDA	Stock	0.2432	0.2455	0.2412	0.2442	121850000.0
2009-03-30 12:00:00	NVDA	Stock	0.2445	0.2468	0.2432	0.2455	62379920.0
2009-03-30 13:00:00	NVDA	Stock	0.2458	0.247	0.2447	0.2458	57996120.0
2009-03-30 14:00:00	NVDA	Stock	0.246	0.2468	0.2422	0.2422	59199560.0
2009-03-30 15:00:00	NVDA	Stock	0.2425	0.2455	0.2412	0.245	207634000.0
2009-03-30 16:00:00	NVDA	Stock	0.245	0.2453	0.2447	0.2448	16942160.0
2009-03-30 17:00:00	NVDA	Stock	0.2453	0.2453	0.2453	0.2453	5400.0
2009-03-30 18:00:00	NVDA	Stock	0.2453	0.2453	0.2453	0.2453	14600.0
2009-03-30 19:00:00	NVDA	Stock	0.246	0.2462	0.246	0.2462	160000.0
2009-03-30 04:00:00	AMZN	Stock	3.4515	3.4515	3.4515	3.4515	6000.0
2009-03-30 05:00:00	AMZN	Stock	3.4505	3.4505	3.4505	3.4505	2000.0
2009-03-30 06:00:00	AMZN	Stock	3.4715	3.525	3.4715	3.525	54000.0
2009-03-30 07:00:00	AMZN	Stock	3.5235	3.5375	3.505	3.505	198120.0
2009-03-30 08:00:00	AMZN	Stock	3.5055	3.5225	3.5	3.515	216040.0
2009-03-30 09:00:00	AMZN	Stock	3.508	3.5735	3.508	3.5705	34087040.0
2009-03-30 10:00:00	AMZN	Stock	3.571	3.5795	3.4955	3.517	35640560.0
2009-03-30 11:00:00	AMZN	Stock	3.516	3.5435	3.4875	3.5415	20927500.0

> showing 50 of 39,819 rows — these rows as CSV

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