PREVIEW / stock_1hour / 2009-06-02

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-06-02.parquet
  size:    867 KB
  rows:    42,097
  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-06-02 08:00:00	AAPL	Stock	4.9818	4.9821	4.9464	4.9607	630560.0
2009-06-02 09:00:00	AAPL	Stock	4.9557	5.0293	4.9411	5.0218	69880608.0
2009-06-02 10:00:00	AAPL	Stock	5.0246	5.0479	4.9811	4.9861	96630856.0
2009-06-02 11:00:00	AAPL	Stock	4.9861	5.0061	4.9621	4.9775	55382544.0
2009-06-02 12:00:00	AAPL	Stock	4.977	4.9843	4.9571	4.9796	46009460.0
2009-06-02 13:00:00	AAPL	Stock	4.9793	4.9818	4.9411	4.9811	43729392.0
2009-06-02 14:00:00	AAPL	Stock	4.9811	5.0029	4.9757	4.9846	41808928.0
2009-06-02 15:00:00	AAPL	Stock	4.9846	5.0132	4.9696	4.9814	85143352.0
2009-06-02 16:00:00	AAPL	Stock	4.9814	4.9914	4.975	4.9811	9456048.0
2009-06-02 17:00:00	AAPL	Stock	4.9814	4.9829	4.9804	4.9818	400008.0
2009-06-02 18:00:00	AAPL	Stock	4.9839	5.0304	4.9818	5.0218	2136736.0
2009-06-02 19:00:00	AAPL	Stock	5.0218	5.0261	5.0107	5.0132	602392.0
2009-06-02 07:00:00	MSFT	Stock	21.5	21.5	21.45	21.5	1400.0
2009-06-02 08:00:00	MSFT	Stock	21.36	21.5	21.3	21.3	26746.0
2009-06-02 09:00:00	MSFT	Stock	21.29	21.78	21.17	21.76	5382069.0
2009-06-02 10:00:00	MSFT	Stock	21.76	21.98	21.57	21.61	9381310.0
2009-06-02 11:00:00	MSFT	Stock	21.62	21.83	21.52	21.52	7272022.0
2009-06-02 12:00:00	MSFT	Stock	21.525	21.54	21.25	21.43	6174794.0
2009-06-02 13:00:00	MSFT	Stock	21.431	21.5	21.31	21.49	4174345.0
2009-06-02 14:00:00	MSFT	Stock	21.5	21.53	21.41	21.43	4930895.0
2009-06-02 15:00:00	MSFT	Stock	21.43	21.54	21.37	21.4	8572620.0
2009-06-02 16:00:00	MSFT	Stock	21.4	21.8	21.34	21.4	1997782.0
2009-06-02 17:00:00	MSFT	Stock	21.561	21.561	21.4	21.4	17949.0
2009-06-02 18:00:00	MSFT	Stock	21.4	21.4	21.38	21.38	1391.0
2009-06-02 19:00:00	MSFT	Stock	21.4	21.45	21.4	21.45	4693.0
2009-06-02 08:00:00	NVDA	Stock	0.273	0.273	0.272	0.272	16000.0
2009-06-02 09:00:00	NVDA	Stock	0.272	0.2752	0.2675	0.2752	127649960.0
2009-06-02 10:00:00	NVDA	Stock	0.2752	0.2795	0.2728	0.2745	238105720.0
2009-06-02 11:00:00	NVDA	Stock	0.2745	0.275	0.2688	0.2698	96288680.0
2009-06-02 12:00:00	NVDA	Stock	0.2698	0.2708	0.2678	0.2695	87968360.0
2009-06-02 13:00:00	NVDA	Stock	0.2692	0.272	0.2663	0.2718	101545840.0
2009-06-02 14:00:00	NVDA	Stock	0.272	0.272	0.27	0.2712	61260920.0
2009-06-02 15:00:00	NVDA	Stock	0.2712	0.273	0.27	0.2712	174369280.0
2009-06-02 16:00:00	NVDA	Stock	0.2712	0.2735	0.2692	0.2712	13524280.0
2009-06-02 17:00:00	NVDA	Stock	0.2712	0.2712	0.2712	0.2712	24520.0
2009-06-02 08:00:00	AMZN	Stock	4.148	4.148	4.125	4.125	8000.0
2009-06-02 09:00:00	AMZN	Stock	4.1215	4.185	4.105	4.179	26121840.0
2009-06-02 10:00:00	AMZN	Stock	4.1795	4.25	4.1585	4.1805	40761260.0
2009-06-02 11:00:00	AMZN	Stock	4.181	4.24	4.1705	4.2235	25764100.0
2009-06-02 12:00:00	AMZN	Stock	4.2245	4.234	4.1865	4.2193	11223440.0
2009-06-02 13:00:00	AMZN	Stock	4.218	4.23	4.1945	4.2295	8762600.0
2009-06-02 14:00:00	AMZN	Stock	4.2295	4.2725	4.2175	4.246	27544300.0
2009-06-02 15:00:00	AMZN	Stock	4.2455	4.258	4.2285	4.2455	37531980.0
2009-06-02 16:00:00	AMZN	Stock	4.246	4.2465	4.1525	4.2465	6541220.0
2009-06-02 17:00:00	AMZN	Stock	4.2141	4.2465	4.2141	4.2425	19320.0
2009-06-02 18:00:00	AMZN	Stock	4.2425	4.2425	4.2425	4.2425	6000.0
2009-06-02 19:00:00	AMZN	Stock	4.2425	4.2465	4.2375	4.2375	9000.0
2009-06-02 07:00:00	TLT	Stock	91.3	91.3	91.3	91.3	800.0
2009-06-02 08:00:00	TLT	Stock	91.2	91.73	91.2	91.61	14530.0
2009-06-02 09:00:00	TLT	Stock	91.57	91.7	91.222	91.41	624620.0

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

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