PREVIEW / stock_1hour / 2009-07-17

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-07-17.parquet
  size:    831 KB
  rows:    40,434
  symbols: 3,337

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-17 05:00:00	AAPL	Stock	5.2686	5.2686	5.2686	5.2686	2800.0
2009-07-17 06:00:00	AAPL	Stock	5.2664	5.2664	5.2664	5.2664	5600.0
2009-07-17 07:00:00	AAPL	Stock	5.2575	5.2714	5.2504	5.2525	230776.0
2009-07-17 08:00:00	AAPL	Stock	5.2571	5.3193	5.2511	5.3107	1318716.0
2009-07-17 09:00:00	AAPL	Stock	5.3107	5.35	5.3014	5.3414	122974404.0
2009-07-17 10:00:00	AAPL	Stock	5.3414	5.3732	5.3289	5.3576	119511112.0
2009-07-17 11:00:00	AAPL	Stock	5.3576	5.3661	5.35	5.3604	44242240.0
2009-07-17 12:00:00	AAPL	Stock	5.3596	5.3711	5.3589	5.3679	37240056.0
2009-07-17 13:00:00	AAPL	Stock	5.3678	5.4068	5.3668	5.4014	68087936.0
2009-07-17 14:00:00	AAPL	Stock	5.4018	5.4172	5.3943	5.4057	67842264.0
2009-07-17 15:00:00	AAPL	Stock	5.4064	5.4293	5.3554	5.4196	126511560.0
2009-07-17 16:00:00	AAPL	Stock	5.4186	5.4214	5.3789	5.4196	9067100.0
2009-07-17 17:00:00	AAPL	Stock	5.4193	5.4214	5.4	5.41	712852.0
2009-07-17 18:00:00	AAPL	Stock	5.4093	5.4118	5.4068	5.4079	116396.0
2009-07-17 19:00:00	AAPL	Stock	5.4089	5.4179	5.4089	5.4107	134344.0
2009-07-17 20:00:00	AAPL	Stock	5.3554	5.3554	5.3554	5.3554	333200.0
2009-07-17 07:00:00	MSFT	Stock	24.35	24.35	24.08	24.14	8190.0
2009-07-17 08:00:00	MSFT	Stock	24.14	24.22	24.08	24.2	28580.0
2009-07-17 09:00:00	MSFT	Stock	24.25	24.45	24.13	24.285	11722908.0
2009-07-17 10:00:00	MSFT	Stock	24.28	24.35	24.13	24.135	8277598.0
2009-07-17 11:00:00	MSFT	Stock	24.13	24.21	24.11	24.142	4090061.0
2009-07-17 12:00:00	MSFT	Stock	24.15	24.26	24.14	24.19	4452548.0
2009-07-17 13:00:00	MSFT	Stock	24.2	24.3	24.19	24.25	5069446.0
2009-07-17 14:00:00	MSFT	Stock	24.252	24.28	24.19	24.24	4223279.0
2009-07-17 15:00:00	MSFT	Stock	24.25	24.29	24.1	24.29	11500482.0
2009-07-17 16:00:00	MSFT	Stock	24.28	24.291	23.91	24.29	2535283.0
2009-07-17 17:00:00	MSFT	Stock	24.19	24.28	24.19	24.27	6450.0
2009-07-17 18:00:00	MSFT	Stock	24.25	24.27	24.23	24.25	7100.0
2009-07-17 19:00:00	MSFT	Stock	24.24	24.27	24.2	24.2	6815.0
2009-07-17 20:00:00	MSFT	Stock	24.16	24.16	24.16	24.16	6100.0
2009-07-17 08:00:00	NVDA	Stock	0.292	0.292	0.292	0.292	20000.0
2009-07-17 09:00:00	NVDA	Stock	0.292	0.2945	0.2902	0.2917	64217880.0
2009-07-17 10:00:00	NVDA	Stock	0.2915	0.2942	0.2905	0.292	90583640.0
2009-07-17 11:00:00	NVDA	Stock	0.2922	0.2968	0.292	0.2962	105439720.0
2009-07-17 12:00:00	NVDA	Stock	0.2964	0.2995	0.2962	0.2988	74704440.0
2009-07-17 13:00:00	NVDA	Stock	0.2988	0.3	0.2985	0.2995	93291320.0
2009-07-17 14:00:00	NVDA	Stock	0.2995	0.3005	0.2985	0.3005	81810960.0
2009-07-17 15:00:00	NVDA	Stock	0.3005	0.3028	0.2995	0.3018	290807000.0
2009-07-17 16:00:00	NVDA	Stock	0.302	0.3025	0.2938	0.3018	13048640.0
2009-07-17 17:00:00	NVDA	Stock	0.3025	0.3045	0.3022	0.3038	668000.0
2009-07-17 18:00:00	NVDA	Stock	0.3035	0.3035	0.3028	0.303	12400.0
2009-07-17 19:00:00	NVDA	Stock	0.3035	0.3035	0.3035	0.3035	28000.0
2009-07-17 08:00:00	AMZN	Stock	4.26	4.284	4.26	4.2825	26120.0
2009-07-17 09:00:00	AMZN	Stock	4.2775	4.317	4.26	4.3022	20020520.0
2009-07-17 10:00:00	AMZN	Stock	4.2985	4.325	4.2795	4.2935	13324240.0
2009-07-17 11:00:00	AMZN	Stock	4.2935	4.311	4.2815	4.293	7925920.0
2009-07-17 12:00:00	AMZN	Stock	4.293	4.3055	4.2665	4.2755	11416960.0
2009-07-17 13:00:00	AMZN	Stock	4.2755	4.3115	4.2735	4.2955	8011940.0
2009-07-17 14:00:00	AMZN	Stock	4.2945	4.305	4.284	4.2875	7708680.0
2009-07-17 15:00:00	AMZN	Stock	4.2875	4.2935	4.2655	4.292	28833040.0

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

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