PREVIEW / stock_1hour / 2010-11-23

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-11-23.parquet
  size:    906 KB
  rows:    43,569
  symbols: 3,498

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
2010-11-23 04:00:00	AAPL	Stock	11.1071	11.1307	11.1011	11.1307	44800.0
2010-11-23 05:00:00	AAPL	Stock	11.1071	11.1071	11.1071	11.1071	33600.0
2010-11-23 06:00:00	AAPL	Stock	11.125	11.1321	11.0982	11.1071	33600.0
2010-11-23 07:00:00	AAPL	Stock	11.1071	11.1071	11.0789	11.0896	373296.0
2010-11-23 08:00:00	AAPL	Stock	11.0929	11.1607	11.0893	11.1296	5265848.0
2010-11-23 09:00:00	AAPL	Stock	11.1286	11.1339	11.0286	11.0382	78731828.0
2010-11-23 10:00:00	AAPL	Stock	11.0382	11.07	11.0071	11.05	88440520.0
2010-11-23 11:00:00	AAPL	Stock	11.05	11.0518	10.9714	11.0103	84082208.0
2010-11-23 12:00:00	AAPL	Stock	11.0104	11.0196	10.9821	11.0071	40583032.0
2010-11-23 13:00:00	AAPL	Stock	11.0089	11.0118	10.9764	10.9793	32382476.0
2010-11-23 14:00:00	AAPL	Stock	10.9793	11.0068	10.9486	10.9893	53917612.0
2010-11-23 15:00:00	AAPL	Stock	10.9896	11.0479	10.9771	11.0257	84931168.0
2010-11-23 16:00:00	AAPL	Stock	11.0261	11.1861	10.9946	11.0221	45429356.0
2010-11-23 17:00:00	AAPL	Stock	11.0232	11.0311	11.0086	11.0096	767452.0
2010-11-23 18:00:00	AAPL	Stock	11.0161	11.0357	11.0161	11.0321	1285732.0
2010-11-23 19:00:00	AAPL	Stock	11.0336	11.0357	11.0214	11.025	293328.0
2010-11-23 08:00:00	MSFT	Stock	25.56	25.65	25.55	25.58	19983.0
2010-11-23 09:00:00	MSFT	Stock	25.57	25.6	25.26	25.27	9950648.0
2010-11-23 10:00:00	MSFT	Stock	25.27	25.38	25.1	25.275	15029968.0
2010-11-23 11:00:00	MSFT	Stock	25.28	25.28	25.1	25.12	6875485.0
2010-11-23 12:00:00	MSFT	Stock	25.13	25.268	25.11	25.251	6104683.0
2010-11-23 13:00:00	MSFT	Stock	25.26	25.34	25.192	25.26	5382386.0
2010-11-23 14:00:00	MSFT	Stock	25.26	25.32	25.17	25.22	5354740.0
2010-11-23 15:00:00	MSFT	Stock	25.22	25.28	25.09	25.12	15205854.0
2010-11-23 16:00:00	MSFT	Stock	25.12	25.888	25.098	25.14	2645946.0
2010-11-23 17:00:00	MSFT	Stock	25.14	25.15	25.13	25.14	18241.0
2010-11-23 18:00:00	MSFT	Stock	25.14	25.15	25.1	25.15	35781.0
2010-11-23 19:00:00	MSFT	Stock	25.15	25.15	25.13	25.13	30710.0
2010-11-23 07:00:00	NVDA	Stock	0.335	0.335	0.335	0.335	40000.0
2010-11-23 08:00:00	NVDA	Stock	0.34	0.34	0.3398	0.3398	65800.0
2010-11-23 09:00:00	NVDA	Stock	0.3395	0.3435	0.3388	0.3405	53560880.0
2010-11-23 10:00:00	NVDA	Stock	0.3402	0.3415	0.3375	0.3402	61817680.0
2010-11-23 11:00:00	NVDA	Stock	0.3402	0.3402	0.3345	0.3348	76567600.0
2010-11-23 12:00:00	NVDA	Stock	0.3348	0.3375	0.3342	0.337	82134240.0
2010-11-23 13:00:00	NVDA	Stock	0.3373	0.3375	0.3338	0.3342	53003320.0
2010-11-23 14:00:00	NVDA	Stock	0.3342	0.3355	0.3335	0.3349	48209040.0
2010-11-23 15:00:00	NVDA	Stock	0.335	0.3368	0.3345	0.336	66868360.0
2010-11-23 16:00:00	NVDA	Stock	0.336	0.34	0.3345	0.337	4385880.0
2010-11-23 17:00:00	NVDA	Stock	0.337	0.337	0.336	0.337	244000.0
2010-11-23 19:00:00	NVDA	Stock	0.337	0.337	0.337	0.337	16560.0
2010-11-23 04:00:00	AMZN	Stock	8.4195	8.463	8.4195	8.463	4000.0
2010-11-23 05:00:00	AMZN	Stock	8.409	8.435	8.39	8.425	24000.0
2010-11-23 06:00:00	AMZN	Stock	8.435	8.458	8.435	8.458	6000.0
2010-11-23 07:00:00	AMZN	Stock	8.4575	8.4575	8.4225	8.4225	37500.0
2010-11-23 08:00:00	AMZN	Stock	8.4225	8.444	8.387	8.4285	486520.0
2010-11-23 09:00:00	AMZN	Stock	8.4195	8.4445	8.3715	8.3915	16719520.0
2010-11-23 10:00:00	AMZN	Stock	8.3855	8.398	8.3215	8.3382	22770000.0
2010-11-23 11:00:00	AMZN	Stock	8.3382	8.3386	8.231	8.27	20090800.0
2010-11-23 12:00:00	AMZN	Stock	8.269	8.35	8.242	8.3445	15018620.0
2010-11-23 13:00:00	AMZN	Stock	8.3445	8.3755	8.327	8.363	13006160.0

> showing 50 of 43,569 rows — these rows as CSV

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