PREVIEW / stock_1hour / 2012-11-27

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-11-27.parquet
  size:    948 KB
  rows:    44,666
  symbols: 3,492

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-11-27 04:00:00	AAPL	Stock	21.1425	21.2143	21.1425	21.2032	423584.0
2012-11-27 05:00:00	AAPL	Stock	21.2036	21.2036	21.1482	21.1786	311836.0
2012-11-27 06:00:00	AAPL	Stock	21.1786	21.1786	21.1179	21.1607	426748.0
2012-11-27 07:00:00	AAPL	Stock	21.16	21.1786	21.1357	21.1561	1037232.0
2012-11-27 08:00:00	AAPL	Stock	21.1536	21.1775	21.0129	21.0643	5800844.0
2012-11-27 09:00:00	AAPL	Stock	21.0414	21.0596	20.8107	20.9425	86495752.0
2012-11-27 10:00:00	AAPL	Stock	20.9454	20.9461	20.7179	20.8171	106154244.0
2012-11-27 11:00:00	AAPL	Stock	20.8193	20.9768	20.8171	20.945	52459456.0
2012-11-27 12:00:00	AAPL	Stock	20.9496	21.0864	20.8804	21.0393	64992760.0
2012-11-27 13:00:00	AAPL	Stock	21.0386	21.0386	20.9211	20.9843	38803772.0
2012-11-27 14:00:00	AAPL	Stock	20.9816	21.035	20.8268	20.8843	62967492.0
2012-11-27 15:00:00	AAPL	Stock	20.8786	20.9514	20.8321	20.8825	68432392.0
2012-11-27 16:00:00	AAPL	Stock	20.8889	21.0136	20.798	20.8707	7524356.0
2012-11-27 17:00:00	AAPL	Stock	20.8721	20.8929	20.8625	20.8675	759472.0
2012-11-27 18:00:00	AAPL	Stock	20.8661	20.8839	20.8643	20.8732	266672.0
2012-11-27 19:00:00	AAPL	Stock	20.8654	20.875	20.8396	20.8446	367136.0
2012-11-27 05:00:00	MSFT	Stock	27.42	27.42	27.42	27.42	1000.0
2012-11-27 07:00:00	MSFT	Stock	27.46	27.47	27.41	27.41	10305.0
2012-11-27 08:00:00	MSFT	Stock	27.47	27.49	27.43	27.43	24764.0
2012-11-27 09:00:00	MSFT	Stock	27.43	27.47	27.23	27.285	4562083.0
2012-11-27 10:00:00	MSFT	Stock	27.285	27.3	27.08	27.12	6366909.0
2012-11-27 11:00:00	MSFT	Stock	27.125	27.3	27.115	27.27	5635260.0
2012-11-27 12:00:00	MSFT	Stock	27.27	27.3	27.165	27.228	3984441.0
2012-11-27 13:00:00	MSFT	Stock	27.22	27.225	27.14	27.165	4897063.0
2012-11-27 14:00:00	MSFT	Stock	27.16	27.19	27.1	27.15	6323231.0
2012-11-27 15:00:00	MSFT	Stock	27.15	27.27	27.07	27.095	9475021.0
2012-11-27 16:00:00	MSFT	Stock	27.09	27.302	27.075	27.17	2148939.0
2012-11-27 17:00:00	MSFT	Stock	27.18	27.2	27.08	27.08	25008.0
2012-11-27 18:00:00	MSFT	Stock	27.14	27.15	27.14	27.14	3725.0
2012-11-27 19:00:00	MSFT	Stock	27.14	27.14	27.12	27.12	1640.0
2012-11-27 09:00:00	NVDA	Stock	0.3028	0.304	0.299	0.304	48075520.0
2012-11-27 10:00:00	NVDA	Stock	0.304	0.3042	0.3005	0.303	70953600.0
2012-11-27 11:00:00	NVDA	Stock	0.303	0.3068	0.3029	0.3062	80962720.0
2012-11-27 12:00:00	NVDA	Stock	0.3062	0.3065	0.3052	0.3062	36155120.0
2012-11-27 13:00:00	NVDA	Stock	0.3062	0.3075	0.3056	0.3075	44761480.0
2012-11-27 14:00:00	NVDA	Stock	0.3074	0.3085	0.3042	0.3055	63348120.0
2012-11-27 15:00:00	NVDA	Stock	0.3055	0.3065	0.3038	0.304	81555000.0
2012-11-27 16:00:00	NVDA	Stock	0.3038	0.3073	0.3037	0.3052	23529680.0
2012-11-27 06:00:00	AMZN	Stock	12.203	12.22	12.203	12.22	4000.0
2012-11-27 07:00:00	AMZN	Stock	12.22	12.22	12.2125	12.215	7400.0
2012-11-27 08:00:00	AMZN	Stock	12.2175	12.2175	12.1825	12.1895	195640.0
2012-11-27 09:00:00	AMZN	Stock	12.184	12.2835	12.131	12.138	15090300.0
2012-11-27 10:00:00	AMZN	Stock	12.138	12.195	12.077	12.1745	12634720.0
2012-11-27 11:00:00	AMZN	Stock	12.169	12.2465	12.1685	12.222	5551160.0
2012-11-27 12:00:00	AMZN	Stock	12.221	12.263	12.184	12.237	5212940.0
2012-11-27 13:00:00	AMZN	Stock	12.241	12.256	12.2025	12.215	3746340.0
2012-11-27 14:00:00	AMZN	Stock	12.222	12.253	12.16	12.21	7099400.0
2012-11-27 15:00:00	AMZN	Stock	12.214	12.24	12.165	12.1745	8769600.0
2012-11-27 16:00:00	AMZN	Stock	12.176	12.1994	12.1645	12.1725	1986100.0
2012-11-27 17:00:00	AMZN	Stock	12.1645	12.1885	12.1645	12.1885	23580.0

> showing 50 of 44,666 rows — these rows as CSV

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