PREVIEW / stock_1hour / 2012-01-17

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-01-17.parquet
  size:    975 KB
  rows:    46,500
  symbols: 3,528

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
2012-01-17 04:00:00	AAPL	Stock	15.1429	15.1782	15.1429	15.1743	29400.0
2012-01-17 05:00:00	AAPL	Stock	15.1782	15.1786	15.1429	15.1429	72800.0
2012-01-17 06:00:00	AAPL	Stock	15.1154	15.1154	15.0907	15.1079	51240.0
2012-01-17 07:00:00	AAPL	Stock	15.125	15.1382	15.0896	15.0904	380940.0
2012-01-17 08:00:00	AAPL	Stock	15.1061	15.1239	15.0814	15.1054	1419992.0
2012-01-17 09:00:00	AAPL	Stock	15.1036	15.1854	15.1011	15.1757	49159908.0
2012-01-17 10:00:00	AAPL	Stock	15.1757	15.2082	15.1571	15.1982	43414084.0
2012-01-17 11:00:00	AAPL	Stock	15.1979	15.2139	15.1932	15.2082	23758812.0
2012-01-17 12:00:00	AAPL	Stock	15.2089	15.2121	15.185	15.1964	17997252.0
2012-01-17 13:00:00	AAPL	Stock	15.1964	15.2021	15.1857	15.1875	18838792.0
2012-01-17 14:00:00	AAPL	Stock	15.1879	15.1886	15.125	15.1397	30888172.0
2012-01-17 15:00:00	AAPL	Stock	15.1396	15.1729	15.1057	15.1679	41046488.0
2012-01-17 16:00:00	AAPL	Stock	15.1671	15.1939	15.1573	15.175	13617352.0
2012-01-17 17:00:00	AAPL	Stock	15.1743	15.1854	15.1648	15.1768	441672.0
2012-01-17 18:00:00	AAPL	Stock	15.1679	15.1775	15.1657	15.1661	288680.0
2012-01-17 19:00:00	AAPL	Stock	15.1661	15.1786	15.165	15.1786	208824.0
2012-01-17 04:00:00	MSFT	Stock	28.5	28.5	28.5	28.5	930.0
2012-01-17 06:00:00	MSFT	Stock	28.43	28.45	28.43	28.45	590.0
2012-01-17 07:00:00	MSFT	Stock	28.5	28.5	28.47	28.5	13980.0
2012-01-17 08:00:00	MSFT	Stock	28.47	28.5	28.24	28.42	58317.0
2012-01-17 09:00:00	MSFT	Stock	28.42	28.5	28.35	28.5	10754448.0
2012-01-17 10:00:00	MSFT	Stock	28.49	28.59	28.47	28.57	11839027.0
2012-01-17 11:00:00	MSFT	Stock	28.58	28.65	28.53	28.59	10963492.0
2012-01-17 12:00:00	MSFT	Stock	28.585	28.6	28.44	28.505	8294153.0
2012-01-17 13:00:00	MSFT	Stock	28.505	28.53	28.34	28.42	5609257.0
2012-01-17 14:00:00	MSFT	Stock	28.425	28.43	28.3	28.34	6213558.0
2012-01-17 15:00:00	MSFT	Stock	28.34	28.36	28.17	28.26	12839722.0
2012-01-17 16:00:00	MSFT	Stock	28.245	28.648	28.219	28.25	4336169.0
2012-01-17 17:00:00	MSFT	Stock	28.21	28.29	28.21	28.29	10741.0
2012-01-17 18:00:00	MSFT	Stock	28.25	28.29	28.25	28.29	2310.0
2012-01-17 19:00:00	MSFT	Stock	28.3	28.31	28.29	28.31	10300.0
2012-01-17 07:00:00	NVDA	Stock	0.35	0.351	0.35	0.351	48000.0
2012-01-17 08:00:00	NVDA	Stock	0.3493	0.35	0.3433	0.3433	686000.0
2012-01-17 09:00:00	NVDA	Stock	0.3488	0.3488	0.3445	0.3448	55972200.0
2012-01-17 10:00:00	NVDA	Stock	0.3448	0.3448	0.3378	0.3393	131115120.0
2012-01-17 11:00:00	NVDA	Stock	0.3393	0.3433	0.338	0.339	85888120.0
2012-01-17 12:00:00	NVDA	Stock	0.339	0.3408	0.3385	0.3402	75995920.0
2012-01-17 13:00:00	NVDA	Stock	0.3402	0.3422	0.3395	0.3417	57687320.0
2012-01-17 14:00:00	NVDA	Stock	0.3418	0.3422	0.339	0.3395	63802120.0
2012-01-17 15:00:00	NVDA	Stock	0.3393	0.3398	0.3375	0.3382	130432840.0
2012-01-17 16:00:00	NVDA	Stock	0.3382	0.3437	0.338	0.338	7322880.0
2012-01-17 17:00:00	NVDA	Stock	0.338	0.342	0.3378	0.342	780760.0
2012-01-17 18:00:00	NVDA	Stock	0.3393	0.3415	0.3393	0.3415	30000.0
2012-01-17 19:00:00	NVDA	Stock	0.339	0.339	0.339	0.339	8000.0
2012-01-17 04:00:00	AMZN	Stock	9.07	9.07	9.07	9.07	2400.0
2012-01-17 05:00:00	AMZN	Stock	9.0	9.0175	9.0	9.0175	6000.0
2012-01-17 07:00:00	AMZN	Stock	9.015	9.0405	9.012	9.0365	28000.0
2012-01-17 08:00:00	AMZN	Stock	9.008	9.035	8.921	8.988	217400.0
2012-01-17 09:00:00	AMZN	Stock	8.987	9.04	8.9255	8.9615	13859560.0
2012-01-17 10:00:00	AMZN	Stock	8.9588	9.09	8.95	9.0895	17228280.0

> showing 50 of 46,500 rows — these rows as CSV

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