PREVIEW / stock_1hour / 2010-07-09

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-07-09.parquet
  size:    883 KB
  rows:    42,456
  symbols: 3,456

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-07-09 05:00:00	AAPL	Stock	9.2321	9.2321	9.2321	9.2321	2800.0
2010-07-09 07:00:00	AAPL	Stock	9.2282	9.25	9.1786	9.1875	245420.0
2010-07-09 08:00:00	AAPL	Stock	9.2032	9.2332	9.115	9.1536	2253804.0
2010-07-09 09:00:00	AAPL	Stock	9.1539	9.2282	9.1129	9.1814	70787416.0
2010-07-09 10:00:00	AAPL	Stock	9.1804	9.2286	9.1607	9.1686	77375956.0
2010-07-09 11:00:00	AAPL	Stock	9.1686	9.2286	9.1593	9.195	68744144.0
2010-07-09 12:00:00	AAPL	Stock	9.1975	9.2232	9.1757	9.1964	36891960.0
2010-07-09 13:00:00	AAPL	Stock	9.1957	9.2139	9.1857	9.2032	23266880.0
2010-07-09 14:00:00	AAPL	Stock	9.2036	9.2486	9.1832	9.2396	38299380.0
2010-07-09 15:00:00	AAPL	Stock	9.2396	9.2821	9.2311	9.275	107046968.0
2010-07-09 16:00:00	AAPL	Stock	9.2743	9.2796	9.1838	9.2729	6692868.0
2010-07-09 17:00:00	AAPL	Stock	9.2732	9.275	9.2679	9.2679	194992.0
2010-07-09 18:00:00	AAPL	Stock	9.2721	9.2818	9.2721	9.2786	312060.0
2010-07-09 19:00:00	AAPL	Stock	9.2786	9.2821	9.2739	9.2811	199220.0
2010-07-09 07:00:00	MSFT	Stock	24.5	24.51	24.5	24.5	6240.0
2010-07-09 08:00:00	MSFT	Stock	24.5	24.53	24.35	24.36	11515.0
2010-07-09 09:00:00	MSFT	Stock	24.37	24.41	24.23	24.31	4416603.0
2010-07-09 10:00:00	MSFT	Stock	24.307	24.33	24.17	24.25	8299898.0
2010-07-09 11:00:00	MSFT	Stock	24.26	24.32	24.19	24.24	6259116.0
2010-07-09 12:00:00	MSFT	Stock	24.24	24.28	24.2	24.21	3879107.0
2010-07-09 13:00:00	MSFT	Stock	24.21	24.29	24.15	24.21	6032541.0
2010-07-09 14:00:00	MSFT	Stock	24.22	24.26	24.15	24.21	6780210.0
2010-07-09 15:00:00	MSFT	Stock	24.215	24.29	24.15	24.27	13895916.0
2010-07-09 16:00:00	MSFT	Stock	24.27	24.32	24.216	24.26	2475693.0
2010-07-09 17:00:00	MSFT	Stock	24.18	24.27	24.18	24.26	3603.0
2010-07-09 18:00:00	MSFT	Stock	24.27	24.27	24.26	24.27	4331.0
2010-07-09 19:00:00	MSFT	Stock	24.26	24.28	24.25	24.26	5264.0
2010-07-09 07:00:00	NVDA	Stock	0.2583	0.2583	0.2583	0.2583	40000.0
2010-07-09 08:00:00	NVDA	Stock	0.2583	0.259	0.2583	0.2585	203600.0
2010-07-09 09:00:00	NVDA	Stock	0.2592	0.2595	0.2565	0.2578	55154440.0
2010-07-09 10:00:00	NVDA	Stock	0.2578	0.2605	0.2578	0.2592	105081480.0
2010-07-09 11:00:00	NVDA	Stock	0.259	0.2595	0.257	0.2575	81426680.0
2010-07-09 12:00:00	NVDA	Stock	0.2578	0.2595	0.2575	0.2585	43446640.0
2010-07-09 13:00:00	NVDA	Stock	0.2583	0.2588	0.2563	0.2565	52882520.0
2010-07-09 14:00:00	NVDA	Stock	0.2566	0.2583	0.2555	0.2575	86897080.0
2010-07-09 15:00:00	NVDA	Stock	0.2575	0.2595	0.2572	0.2588	127463880.0
2010-07-09 16:00:00	NVDA	Stock	0.2588	0.2598	0.2578	0.2588	10185320.0
2010-07-09 17:00:00	NVDA	Stock	0.2578	0.2578	0.2578	0.2578	76000.0
2010-07-09 18:00:00	NVDA	Stock	0.2588	0.2588	0.2588	0.2588	8000.0
2010-07-09 19:00:00	NVDA	Stock	0.2588	0.2592	0.2588	0.2592	133880.0
2010-07-09 08:00:00	AMZN	Stock	5.8011	5.825	5.777	5.785	69760.0
2010-07-09 09:00:00	AMZN	Stock	5.8045	5.8345	5.7325	5.7726	13086520.0
2010-07-09 10:00:00	AMZN	Stock	5.7715	5.8065	5.7515	5.776	15091700.0
2010-07-09 11:00:00	AMZN	Stock	5.7759	5.805	5.7595	5.785	6890800.0
2010-07-09 12:00:00	AMZN	Stock	5.7845	5.8105	5.784	5.798	6304160.0
2010-07-09 13:00:00	AMZN	Stock	5.795	5.808	5.7815	5.8045	5391180.0
2010-07-09 14:00:00	AMZN	Stock	5.803	5.832	5.791	5.826	9446640.0
2010-07-09 15:00:00	AMZN	Stock	5.8255	5.87	5.822	5.863	21320740.0
2010-07-09 16:00:00	AMZN	Stock	5.8655	5.8705	5.8058	5.863	781460.0
2010-07-09 17:00:00	AMZN	Stock	5.859	5.864	5.859	5.864	11820.0

> showing 50 of 42,456 rows — these rows as CSV

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