PREVIEW / stock_1hour / 2014-05-13

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-05-13.parquet
  size:    1.0 MB
  rows:    47,868
  symbols: 3,551

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
2014-05-13 04:00:00	AAPL	Stock	21.1804	21.1836	21.1725	21.1836	8400.0
2014-05-13 05:00:00	AAPL	Stock	21.1511	21.1929	21.1511	21.1929	12320.0
2014-05-13 06:00:00	AAPL	Stock	21.1536	21.1536	21.1464	21.1464	11200.0
2014-05-13 07:00:00	AAPL	Stock	21.1607	21.1868	21.1607	21.1679	152124.0
2014-05-13 08:00:00	AAPL	Stock	21.1807	21.185	21.1071	21.1332	618072.0
2014-05-13 09:00:00	AAPL	Stock	21.1425	21.1875	21.0964	21.1196	24310944.0
2014-05-13 10:00:00	AAPL	Stock	21.1211	21.2054	21.1079	21.1675	21248164.0
2014-05-13 11:00:00	AAPL	Stock	21.1679	21.1925	21.1346	21.1629	10911964.0
2014-05-13 12:00:00	AAPL	Stock	21.1582	21.1871	21.1393	21.1836	8940288.0
2014-05-13 13:00:00	AAPL	Stock	21.1821	21.1964	21.1575	21.1714	10007732.0
2014-05-13 14:00:00	AAPL	Stock	21.1718	21.2336	21.1689	21.2136	16185120.0
2014-05-13 15:00:00	AAPL	Stock	21.2111	21.2202	21.1175	21.2036	19742128.0
2014-05-13 16:00:00	AAPL	Stock	21.2057	21.2057	21.1758	21.1886	9128224.0
2014-05-13 17:00:00	AAPL	Stock	21.1886	21.1911	21.1786	21.1786	79408.0
2014-05-13 18:00:00	AAPL	Stock	21.1811	21.2057	21.1807	21.2057	192752.0
2014-05-13 19:00:00	AAPL	Stock	21.1875	21.1893	21.1775	21.1893	56700.0
2014-05-13 04:00:00	MSFT	Stock	39.9	39.9	39.9	39.9	800.0
2014-05-13 06:00:00	MSFT	Stock	39.92	39.92	39.9	39.92	2700.0
2014-05-13 07:00:00	MSFT	Stock	39.9	40.0	39.86	39.91	16600.0
2014-05-13 08:00:00	MSFT	Stock	39.91	39.97	39.8	39.8	25104.0
2014-05-13 09:00:00	MSFT	Stock	39.79	40.38	39.79	40.32	4376098.0
2014-05-13 10:00:00	MSFT	Stock	40.32	40.5	40.31	40.425	5964775.0
2014-05-13 11:00:00	MSFT	Stock	40.42	40.44	40.2	40.285	3046184.0
2014-05-13 12:00:00	MSFT	Stock	40.28	40.39	40.23	40.36	1748305.0
2014-05-13 13:00:00	MSFT	Stock	40.36	40.4	40.31	40.37	1809976.0
2014-05-13 14:00:00	MSFT	Stock	40.38	40.5	40.33	40.46	2857636.0
2014-05-13 15:00:00	MSFT	Stock	40.469	40.48	40.29	40.42	4660024.0
2014-05-13 16:00:00	MSFT	Stock	40.42	40.57	40.336	40.42	1283315.0
2014-05-13 17:00:00	MSFT	Stock	40.45	40.45	40.42	40.45	650.0
2014-05-13 18:00:00	MSFT	Stock	40.42	40.42	40.42	40.42	9981.0
2014-05-13 19:00:00	MSFT	Stock	40.37	40.37	40.37	40.37	500.0
2014-05-13 09:00:00	NVDA	Stock	0.4662	0.4662	0.4582	0.4595	23051320.0
2014-05-13 10:00:00	NVDA	Stock	0.4595	0.464	0.4595	0.4618	27578760.0
2014-05-13 11:00:00	NVDA	Stock	0.4616	0.4618	0.457	0.4572	30711120.0
2014-05-13 12:00:00	NVDA	Stock	0.4572	0.4588	0.457	0.4576	18598480.0
2014-05-13 13:00:00	NVDA	Stock	0.4576	0.4578	0.4555	0.4558	13509400.0
2014-05-13 14:00:00	NVDA	Stock	0.4558	0.458	0.4555	0.4578	25937040.0
2014-05-13 15:00:00	NVDA	Stock	0.4575	0.458	0.4564	0.4568	67998840.0
2014-05-13 16:00:00	NVDA	Stock	0.457	0.4654	0.4558	0.457	3134880.0
2014-05-13 05:00:00	AMZN	Stock	15.2445	15.249	15.2425	15.249	13080.0
2014-05-13 06:00:00	AMZN	Stock	15.244	15.2485	15.244	15.2485	8000.0
2014-05-13 07:00:00	AMZN	Stock	15.2485	15.249	15.2335	15.249	12000.0
2014-05-13 08:00:00	AMZN	Stock	15.2325	15.2485	15.11	15.11	128540.0
2014-05-13 09:00:00	AMZN	Stock	15.1425	15.1635	15.0375	15.077	8705680.0
2014-05-13 10:00:00	AMZN	Stock	15.0815	15.249	15.064	15.1988	10901220.0
2014-05-13 11:00:00	AMZN	Stock	15.201	15.27	15.1922	15.235	11474820.0
2014-05-13 12:00:00	AMZN	Stock	15.2335	15.28	15.1975	15.2045	5951240.0
2014-05-13 13:00:00	AMZN	Stock	15.2045	15.225	15.192	15.203	4716440.0
2014-05-13 14:00:00	AMZN	Stock	15.2075	15.2205	15.1975	15.2045	5124640.0
2014-05-13 15:00:00	AMZN	Stock	15.2035	15.2525	15.195	15.237	15049040.0

> showing 50 of 47,868 rows — these rows as CSV

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