PREVIEW / stock_1hour / 2009-06-12

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-06-12.parquet
  size:    854 KB
  rows:    42,287
  symbols: 3,363

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-12 07:00:00	AAPL	Stock	4.9818	4.9818	4.98	4.98	9800.0
2009-06-12 08:00:00	AAPL	Stock	4.98	5.0	4.9536	4.9571	1124060.0
2009-06-12 09:00:00	AAPL	Stock	4.9571	4.9679	4.8964	4.8993	86215668.0
2009-06-12 10:00:00	AAPL	Stock	4.8993	4.9132	4.8764	4.8914	104716416.0
2009-06-12 11:00:00	AAPL	Stock	4.8914	4.8968	4.8789	4.8821	45196536.0
2009-06-12 12:00:00	AAPL	Stock	4.8825	4.8911	4.8625	4.875	64232112.0
2009-06-12 13:00:00	AAPL	Stock	4.875	4.88	4.8586	4.8632	55331416.0
2009-06-12 14:00:00	AAPL	Stock	4.8632	4.8925	4.8589	4.8869	79291912.0
2009-06-12 15:00:00	AAPL	Stock	4.8875	4.8986	4.8736	4.8864	111671308.0
2009-06-12 16:00:00	AAPL	Stock	4.8868	4.9	4.8808	4.8857	11275208.0
2009-06-12 17:00:00	AAPL	Stock	4.8839	4.8918	4.88	4.8821	538440.0
2009-06-12 18:00:00	AAPL	Stock	4.8836	4.8918	4.8807	4.8807	832552.0
2009-06-12 19:00:00	AAPL	Stock	4.8839	4.8889	4.8786	4.8793	274232.0
2009-06-12 07:00:00	MSFT	Stock	22.8	22.84	22.8	22.84	2200.0
2009-06-12 08:00:00	MSFT	Stock	22.74	22.86	22.7	22.81	513972.0
2009-06-12 09:00:00	MSFT	Stock	22.82	22.99	22.81	22.85	8382539.0
2009-06-12 10:00:00	MSFT	Stock	22.85	22.99	22.78	22.92	9108662.0
2009-06-12 11:00:00	MSFT	Stock	22.93	22.97	22.74	22.85	5728733.0
2009-06-12 12:00:00	MSFT	Stock	22.86	22.96	22.79	22.95	2985663.0
2009-06-12 13:00:00	MSFT	Stock	22.96	22.98	22.84	22.945	3080005.0
2009-06-12 14:00:00	MSFT	Stock	22.94	23.25	22.92	23.18	6308484.0
2009-06-12 15:00:00	MSFT	Stock	23.19	23.38	23.19	23.34	11955574.0
2009-06-12 16:00:00	MSFT	Stock	23.37	23.4	22.85	23.33	2077404.0
2009-06-12 17:00:00	MSFT	Stock	23.33	23.36	23.31	23.34	25828.0
2009-06-12 18:00:00	MSFT	Stock	23.33	23.35	23.27	23.3	21516.0
2009-06-12 19:00:00	MSFT	Stock	23.32	23.39	23.32	23.39	10316.0
2009-06-12 08:00:00	NVDA	Stock	0.2888	0.2888	0.2838	0.2838	225240.0
2009-06-12 09:00:00	NVDA	Stock	0.2812	0.2872	0.2785	0.28	110109120.0
2009-06-12 10:00:00	NVDA	Stock	0.28	0.2848	0.2788	0.2828	124176640.0
2009-06-12 11:00:00	NVDA	Stock	0.2828	0.2828	0.2805	0.2808	48805040.0
2009-06-12 12:00:00	NVDA	Stock	0.2808	0.2872	0.2806	0.2865	77771640.0
2009-06-12 13:00:00	NVDA	Stock	0.2868	0.287	0.2825	0.2845	50876280.0
2009-06-12 14:00:00	NVDA	Stock	0.2842	0.2885	0.2842	0.2878	57710840.0
2009-06-12 15:00:00	NVDA	Stock	0.288	0.2888	0.2855	0.288	105499040.0
2009-06-12 16:00:00	NVDA	Stock	0.2875	0.2882	0.2836	0.2878	8617640.0
2009-06-12 17:00:00	NVDA	Stock	0.2855	0.2878	0.2855	0.2878	121920.0
2009-06-12 08:00:00	AMZN	Stock	4.259	4.265	4.256	4.256	25000.0
2009-06-12 09:00:00	AMZN	Stock	4.256	4.2605	4.175	4.1805	17759740.0
2009-06-12 10:00:00	AMZN	Stock	4.1795	4.183	4.128	4.1425	28685240.0
2009-06-12 11:00:00	AMZN	Stock	4.142	4.1465	4.105	4.127	17779240.0
2009-06-12 12:00:00	AMZN	Stock	4.127	4.1365	4.1005	4.119	10724880.0
2009-06-12 13:00:00	AMZN	Stock	4.1175	4.158	4.1175	4.1575	11293140.0
2009-06-12 14:00:00	AMZN	Stock	4.1575	4.191	4.1365	4.162	11997360.0
2009-06-12 15:00:00	AMZN	Stock	4.1635	4.2105	4.1575	4.2035	21929420.0
2009-06-12 16:00:00	AMZN	Stock	4.205	4.205	4.1263	4.204	833480.0
2009-06-12 17:00:00	AMZN	Stock	4.1955	4.196	4.195	4.196	8000.0
2009-06-12 18:00:00	AMZN	Stock	4.1965	4.1965	4.1915	4.1915	4000.0
2009-06-12 07:00:00	TLT	Stock	89.47	89.47	89.47	89.47	100.0
2009-06-12 08:00:00	TLT	Stock	89.62	89.66	89.37	89.54	25069.0
2009-06-12 09:00:00	TLT	Stock	89.5	89.99	89.31	89.99	647296.0

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

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