PREVIEW / stock_1hour / 2009-06-10

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-06-10.parquet
  size:    862 KB
  rows:    42,081
  symbols: 3,349

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-06-10 04:00:00	AAPL	Stock	5.1304	5.1425	5.1304	5.1425	11956.0
2009-06-10 05:00:00	AAPL	Stock	5.1318	5.1421	5.1318	5.1421	5600.0
2009-06-10 06:00:00	AAPL	Stock	5.1425	5.1425	5.1425	5.1425	2800.0
2009-06-10 07:00:00	AAPL	Stock	5.1425	5.1507	5.1079	5.1086	356944.0
2009-06-10 08:00:00	AAPL	Stock	5.1196	5.12	5.0839	5.1064	2035432.0
2009-06-10 09:00:00	AAPL	Stock	5.1039	5.1071	4.9964	5.0214	113291528.0
2009-06-10 10:00:00	AAPL	Stock	5.0212	5.0268	4.96	4.9625	138729024.0
2009-06-10 11:00:00	AAPL	Stock	4.9625	4.9836	4.9393	4.9594	97166888.0
2009-06-10 12:00:00	AAPL	Stock	4.9586	4.9854	4.9521	4.9557	63330680.0
2009-06-10 13:00:00	AAPL	Stock	4.9557	4.962	4.9446	4.96	55531028.0
2009-06-10 14:00:00	AAPL	Stock	4.96	4.9775	4.945	4.9686	69793864.0
2009-06-10 15:00:00	AAPL	Stock	4.9682	5.0125	4.9482	5.0071	111833540.0
2009-06-10 16:00:00	AAPL	Stock	5.0075	5.0143	4.9556	5.0061	25013240.0
2009-06-10 17:00:00	AAPL	Stock	5.0043	5.0089	4.9893	4.9968	474516.0
2009-06-10 18:00:00	AAPL	Stock	5.0	5.0089	5.0	5.005	752108.0
2009-06-10 19:00:00	AAPL	Stock	5.0068	5.0086	5.0021	5.0036	113064.0
2009-06-10 05:00:00	MSFT	Stock	22.32	22.32	22.32	22.32	200.0
2009-06-10 07:00:00	MSFT	Stock	22.33	22.33	22.3	22.3	200.0
2009-06-10 08:00:00	MSFT	Stock	22.25	22.29	22.17	22.18	27373.0
2009-06-10 09:00:00	MSFT	Stock	22.17	22.3	22.12	22.28	4955185.0
2009-06-10 10:00:00	MSFT	Stock	22.28	22.31	22.2	22.25	7594352.0
2009-06-10 11:00:00	MSFT	Stock	22.24	22.28	22.15	22.221	6853862.0
2009-06-10 12:00:00	MSFT	Stock	22.22	22.37	22.22	22.351	4395893.0
2009-06-10 13:00:00	MSFT	Stock	22.35	22.37	22.23	22.26	8608186.0
2009-06-10 14:00:00	MSFT	Stock	22.26	22.44	22.13	22.41	7080969.0
2009-06-10 15:00:00	MSFT	Stock	22.415	22.62	22.32	22.56	15927877.0
2009-06-10 16:00:00	MSFT	Stock	22.56	22.62	22.254	22.58	3707969.0
2009-06-10 17:00:00	MSFT	Stock	22.59	22.62	22.55	22.6	45762.0
2009-06-10 18:00:00	MSFT	Stock	22.55	22.65	22.55	22.6	8026.0
2009-06-10 19:00:00	MSFT	Stock	22.6	22.62	22.57	22.57	4709.0
2009-06-10 20:00:00	MSFT	Stock	22.25	22.25	22.25	22.25	89400.0
2009-06-10 08:00:00	NVDA	Stock	0.289	0.29	0.2868	0.29	155000.0
2009-06-10 09:00:00	NVDA	Stock	0.2892	0.2892	0.2812	0.2835	59711360.0
2009-06-10 10:00:00	NVDA	Stock	0.2835	0.284	0.2792	0.2831	101559920.0
2009-06-10 11:00:00	NVDA	Stock	0.2832	0.2862	0.28	0.2862	82175120.0
2009-06-10 12:00:00	NVDA	Stock	0.2862	0.2892	0.2858	0.2858	101156240.0
2009-06-10 13:00:00	NVDA	Stock	0.286	0.286	0.2829	0.2846	71578840.0
2009-06-10 14:00:00	NVDA	Stock	0.2845	0.2888	0.2836	0.2885	70200040.0
2009-06-10 15:00:00	NVDA	Stock	0.2885	0.2948	0.2875	0.2936	268695440.0
2009-06-10 16:00:00	NVDA	Stock	0.2932	0.294	0.2832	0.293	37682360.0
2009-06-10 17:00:00	NVDA	Stock	0.2932	0.2932	0.2932	0.2932	16000.0
2009-06-10 19:00:00	NVDA	Stock	0.295	0.295	0.2942	0.2945	108000.0
2009-06-10 07:00:00	AMZN	Stock	4.3895	4.3995	4.3895	4.3995	10000.0
2009-06-10 08:00:00	AMZN	Stock	4.37	4.389	4.37	4.3725	140300.0
2009-06-10 09:00:00	AMZN	Stock	4.374	4.428	4.322	4.3348	24419980.0
2009-06-10 10:00:00	AMZN	Stock	4.3375	4.3405	4.268	4.279	20956300.0
2009-06-10 11:00:00	AMZN	Stock	4.279	4.2905	4.2415	4.2805	17608440.0
2009-06-10 12:00:00	AMZN	Stock	4.2782	4.3225	4.2765	4.3145	8929040.0
2009-06-10 13:00:00	AMZN	Stock	4.3145	4.3145	4.255	4.2695	11879880.0
2009-06-10 14:00:00	AMZN	Stock	4.2675	4.303	4.2612	4.288	11625080.0

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

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