PREVIEW / stock_1hour / 2008-08-11

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-08-11.parquet
  size:    838 KB
  rows:    40,191
  symbols: 3,324

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-08-11 06:00:00	AAPL	Stock	6.0721	6.0721	6.0721	6.0721	8400.0
2008-08-11 07:00:00	AAPL	Stock	6.1011	6.1011	6.0714	6.0907	220640.0
2008-08-11 08:00:00	AAPL	Stock	6.0911	6.1161	6.0679	6.0946	3733184.0
2008-08-11 09:00:00	AAPL	Stock	6.0943	6.1246	6.0596	6.0939	120867572.0
2008-08-11 10:00:00	AAPL	Stock	6.0929	6.1739	6.0811	6.1679	136572072.0
2008-08-11 11:00:00	AAPL	Stock	6.1679	6.2346	6.1643	6.2029	145337360.0
2008-08-11 12:00:00	AAPL	Stock	6.2029	6.2457	6.1982	6.2393	73081680.0
2008-08-11 13:00:00	AAPL	Stock	6.2389	6.3029	6.2268	6.2818	111579888.0
2008-08-11 14:00:00	AAPL	Stock	6.2818	6.3036	6.1786	6.2011	134357664.0
2008-08-11 15:00:00	AAPL	Stock	6.2004	6.2293	6.135	6.1982	148352736.0
2008-08-11 16:00:00	AAPL	Stock	6.1976	6.2607	6.1894	6.1907	8583680.0
2008-08-11 17:00:00	AAPL	Stock	6.1904	6.1946	6.1893	6.1893	265664.0
2008-08-11 18:00:00	AAPL	Stock	6.1946	6.2032	6.1861	6.2032	305004.0
2008-08-11 19:00:00	AAPL	Stock	6.1943	6.1964	6.1864	6.1868	190400.0
2008-08-11 08:00:00	MSFT	Stock	28.13	28.15	28.07	28.15	5128.0
2008-08-11 09:00:00	MSFT	Stock	28.12	28.12	27.7	28.03	5655744.0
2008-08-11 10:00:00	MSFT	Stock	28.02	28.34	28.0	28.21	11126067.0
2008-08-11 11:00:00	MSFT	Stock	28.21	28.3	28.07	28.29	8421238.0
2008-08-11 12:00:00	MSFT	Stock	28.3	28.4	28.23	28.305	6103210.0
2008-08-11 13:00:00	MSFT	Stock	28.3	28.34	28.2	28.21	8590358.0
2008-08-11 14:00:00	MSFT	Stock	28.22	28.24	27.79	27.82	10988491.0
2008-08-11 15:00:00	MSFT	Stock	27.81	27.9	27.66	27.9	12888372.0
2008-08-11 16:00:00	MSFT	Stock	27.89	28.077	27.59	27.8	2286138.0
2008-08-11 17:00:00	MSFT	Stock	27.72	27.81	27.72	27.81	1147.0
2008-08-11 18:00:00	MSFT	Stock	27.79	27.9	27.71	27.71	16813.0
2008-08-11 19:00:00	MSFT	Stock	27.75	27.79	27.74	27.79	3698.0
2008-08-11 07:00:00	NVDA	Stock	0.276	0.276	0.276	0.276	4000.0
2008-08-11 08:00:00	NVDA	Stock	0.276	0.2805	0.276	0.28	1502800.0
2008-08-11 09:00:00	NVDA	Stock	0.2795	0.2835	0.276	0.2822	167983640.0
2008-08-11 10:00:00	NVDA	Stock	0.2825	0.283	0.2783	0.2798	164305240.0
2008-08-11 11:00:00	NVDA	Stock	0.28	0.2828	0.2788	0.282	167766560.0
2008-08-11 12:00:00	NVDA	Stock	0.282	0.2848	0.2808	0.2835	203599120.0
2008-08-11 13:00:00	NVDA	Stock	0.2835	0.2875	0.2815	0.2852	157793320.0
2008-08-11 14:00:00	NVDA	Stock	0.2852	0.2865	0.2795	0.28	169580440.0
2008-08-11 15:00:00	NVDA	Stock	0.28	0.2818	0.2785	0.281	136716920.0
2008-08-11 16:00:00	NVDA	Stock	0.2808	0.2818	0.2799	0.2805	10805360.0
2008-08-11 17:00:00	NVDA	Stock	0.2812	0.2812	0.2805	0.2805	187200.0
2008-08-11 18:00:00	NVDA	Stock	0.2805	0.284	0.2805	0.284	115200.0
2008-08-11 19:00:00	NVDA	Stock	0.2825	0.2825	0.2803	0.2803	168000.0
2008-08-11 20:00:00	NVDA	Stock	0.2852	0.2852	0.2852	0.2852	980000.0
2008-08-11 08:00:00	AMZN	Stock	4.0	4.022	3.9695	4.022	502200.0
2008-08-11 09:00:00	AMZN	Stock	4.0215	4.2645	3.989	4.255	54000720.0
2008-08-11 10:00:00	AMZN	Stock	4.2545	4.375	4.2535	4.351	117174200.0
2008-08-11 11:00:00	AMZN	Stock	4.3525	4.4485	4.344	4.4466	64285900.0
2008-08-11 12:00:00	AMZN	Stock	4.4465	4.5875	4.428	4.5615	84466260.0
2008-08-11 13:00:00	AMZN	Stock	4.5615	4.5615	4.4445	4.4568	57736940.0
2008-08-11 14:00:00	AMZN	Stock	4.456	4.482	4.3795	4.424	43121260.0
2008-08-11 15:00:00	AMZN	Stock	4.4255	4.4825	4.38	4.403	69468960.0
2008-08-11 16:00:00	AMZN	Stock	4.4045	4.4676	4.3858	4.4	3885800.0
2008-08-11 17:00:00	AMZN	Stock	4.41	4.4165	4.405	4.4055	60380.0

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

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