PREVIEW / stock_1hour / 2009-07-16

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-07-16.parquet
  size:    832 KB
  rows:    40,516
  symbols: 3,335

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-07-16 05:00:00	AAPL	Stock	5.2643	5.2643	5.2643	5.2643	2800.0
2009-07-16 07:00:00	AAPL	Stock	5.2625	5.2625	5.1904	5.1929	743624.0
2009-07-16 08:00:00	AAPL	Stock	5.1929	5.2268	5.1929	5.2089	2566620.0
2009-07-16 09:00:00	AAPL	Stock	5.2057	5.2825	5.1946	5.2652	82699820.0
2009-07-16 10:00:00	AAPL	Stock	5.2664	5.2693	5.2286	5.2536	56485688.0
2009-07-16 11:00:00	AAPL	Stock	5.2537	5.2693	5.2429	5.2511	35332500.0
2009-07-16 12:00:00	AAPL	Stock	5.2518	5.2546	5.2386	5.24	21575764.0
2009-07-16 13:00:00	AAPL	Stock	5.2404	5.2539	5.2357	5.2539	32663148.0
2009-07-16 14:00:00	AAPL	Stock	5.2537	5.2639	5.2461	5.2589	62532344.0
2009-07-16 15:00:00	AAPL	Stock	5.2589	5.2864	5.2525	5.2675	81817652.0
2009-07-16 16:00:00	AAPL	Stock	5.2682	5.2807	5.2232	5.2507	10526040.0
2009-07-16 17:00:00	AAPL	Stock	5.2518	5.255	5.2429	5.2464	283164.0
2009-07-16 18:00:00	AAPL	Stock	5.2686	5.2686	5.245	5.2604	845348.0
2009-07-16 19:00:00	AAPL	Stock	5.2589	5.2611	5.2561	5.2589	135156.0
2009-07-16 07:00:00	MSFT	Stock	24.13	24.25	23.92	23.92	14720.0
2009-07-16 08:00:00	MSFT	Stock	23.92	24.15	23.83	23.98	93240.0
2009-07-16 09:00:00	MSFT	Stock	23.92	24.16	23.86	24.082	7651996.0
2009-07-16 10:00:00	MSFT	Stock	24.085	24.29	23.93	24.22	11861644.0
2009-07-16 11:00:00	MSFT	Stock	24.23	24.27	24.13	24.23	5345464.0
2009-07-16 12:00:00	MSFT	Stock	24.24	24.25	24.11	24.138	5935585.0
2009-07-16 13:00:00	MSFT	Stock	24.14	24.3	24.11	24.292	5835063.0
2009-07-16 14:00:00	MSFT	Stock	24.3	24.37	24.26	24.27	7791692.0
2009-07-16 15:00:00	MSFT	Stock	24.27	24.44	24.22	24.44	16169566.0
2009-07-16 16:00:00	MSFT	Stock	24.44	24.48	24.196	24.25	2160360.0
2009-07-16 17:00:00	MSFT	Stock	24.25	24.34	24.21	24.27	12605.0
2009-07-16 18:00:00	MSFT	Stock	24.44	24.44	24.2	24.36	20742.0
2009-07-16 19:00:00	MSFT	Stock	24.35	24.35	24.31	24.31	800.0
2009-07-16 08:00:00	NVDA	Stock	0.2818	0.2835	0.2788	0.281	424400.0
2009-07-16 09:00:00	NVDA	Stock	0.281	0.287	0.2803	0.2865	159373800.0
2009-07-16 10:00:00	NVDA	Stock	0.2868	0.287	0.2832	0.2855	208586400.0
2009-07-16 11:00:00	NVDA	Stock	0.2855	0.2882	0.2851	0.2874	119751880.0
2009-07-16 12:00:00	NVDA	Stock	0.2872	0.2918	0.2872	0.2895	122080960.0
2009-07-16 13:00:00	NVDA	Stock	0.2892	0.2918	0.288	0.2918	95305320.0
2009-07-16 14:00:00	NVDA	Stock	0.2918	0.2942	0.2915	0.2932	96774120.0
2009-07-16 15:00:00	NVDA	Stock	0.2932	0.2942	0.292	0.2938	128063520.0
2009-07-16 16:00:00	NVDA	Stock	0.2932	0.295	0.2884	0.2938	6352560.0
2009-07-16 17:00:00	NVDA	Stock	0.2938	0.2948	0.2925	0.2925	161520.0
2009-07-16 18:00:00	NVDA	Stock	0.2925	0.2925	0.292	0.292	44880.0
2009-07-16 19:00:00	NVDA	Stock	0.292	0.2925	0.292	0.2925	72000.0
2009-07-16 07:00:00	AMZN	Stock	4.2275	4.2275	4.2275	4.2275	4000.0
2009-07-16 08:00:00	AMZN	Stock	4.1895	4.2275	4.1895	4.2035	44000.0
2009-07-16 09:00:00	AMZN	Stock	4.205	4.244	4.186	4.2425	15699240.0
2009-07-16 10:00:00	AMZN	Stock	4.242	4.242	4.209	4.224	14820820.0
2009-07-16 11:00:00	AMZN	Stock	4.225	4.2385	4.203	4.238	8360320.0
2009-07-16 12:00:00	AMZN	Stock	4.238	4.2415	4.223	4.2245	6242320.0
2009-07-16 13:00:00	AMZN	Stock	4.2255	4.28	4.225	4.28	12870120.0
2009-07-16 14:00:00	AMZN	Stock	4.2795	4.2885	4.2685	4.286	13134600.0
2009-07-16 15:00:00	AMZN	Stock	4.286	4.312	4.285	4.3055	31776020.0
2009-07-16 16:00:00	AMZN	Stock	4.3055	4.3105	4.2541	4.2975	3100920.0
2009-07-16 17:00:00	AMZN	Stock	4.2835	4.2835	4.2725	4.2725	70800.0

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

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