PREVIEW / stock_1hour / 2013-12-10

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-12-10.parquet
  size:    1.0 MB
  rows:    48,034
  symbols: 3,527

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
2013-12-10 04:00:00	AAPL	Stock	20.2721	20.2721	20.2721	20.2721	2800.0
2013-12-10 05:00:00	AAPL	Stock	20.25	20.25	20.25	20.25	2800.0
2013-12-10 06:00:00	AAPL	Stock	20.2589	20.2589	20.2264	20.2264	74452.0
2013-12-10 07:00:00	AAPL	Stock	20.2396	20.2396	20.1696	20.1836	279132.0
2013-12-10 08:00:00	AAPL	Stock	20.1929	20.2329	20.125	20.1429	1742496.0
2013-12-10 09:00:00	AAPL	Stock	20.1432	20.1636	20.0429	20.0932	46680004.0
2013-12-10 10:00:00	AAPL	Stock	20.0919	20.2257	20.0479	20.2007	43707944.0
2013-12-10 11:00:00	AAPL	Stock	20.1986	20.2814	20.1602	20.1711	36917132.0
2013-12-10 12:00:00	AAPL	Stock	20.1711	20.2389	20.1436	20.2225	28218344.0
2013-12-10 13:00:00	AAPL	Stock	20.2229	20.2346	20.1793	20.1959	14206332.0
2013-12-10 14:00:00	AAPL	Stock	20.1921	20.2129	20.1557	20.2061	12700380.0
2013-12-10 15:00:00	AAPL	Stock	20.2086	20.2536	20.1979	20.2014	27582072.0
2013-12-10 16:00:00	AAPL	Stock	20.1982	20.2296	20.0705	20.1946	12520032.0
2013-12-10 17:00:00	AAPL	Stock	20.2007	20.2032	20.1839	20.1839	161868.0
2013-12-10 18:00:00	AAPL	Stock	20.1946	20.2804	20.1864	20.2643	1082396.0
2013-12-10 19:00:00	AAPL	Stock	20.2614	20.275	20.2411	20.2661	416276.0
2013-12-10 08:00:00	MSFT	Stock	38.66	38.68	38.53	38.57	121110.0
2013-12-10 09:00:00	MSFT	Stock	38.57	38.9	38.41	38.505	4326727.0
2013-12-10 10:00:00	MSFT	Stock	38.505	38.51	38.095	38.2	5036726.0
2013-12-10 11:00:00	MSFT	Stock	38.21	38.33	38.02	38.13	6383774.0
2013-12-10 12:00:00	MSFT	Stock	38.13	38.29	38.04	38.25	5460370.0
2013-12-10 13:00:00	MSFT	Stock	38.25	38.25	38.12	38.16	2463229.0
2013-12-10 14:00:00	MSFT	Stock	38.166	38.22	38.13	38.16	2493953.0
2013-12-10 15:00:00	MSFT	Stock	38.16	38.22	38.08	38.115	6191107.0
2013-12-10 16:00:00	MSFT	Stock	38.12	38.67	38.09	38.11	2257767.0
2013-12-10 17:00:00	MSFT	Stock	38.15	38.18	38.11	38.18	2159.0
2013-12-10 18:00:00	MSFT	Stock	38.2	38.2	38.11	38.11	23048.0
2013-12-10 19:00:00	MSFT	Stock	38.14	38.2	38.14	38.2	1635.0
2013-12-10 09:00:00	NVDA	Stock	0.3803	0.3882	0.3798	0.388	45472400.0
2013-12-10 10:00:00	NVDA	Stock	0.3878	0.3908	0.385	0.3893	63865360.0
2013-12-10 11:00:00	NVDA	Stock	0.3893	0.3898	0.3875	0.3875	27855240.0
2013-12-10 12:00:00	NVDA	Stock	0.3876	0.3885	0.3866	0.3882	18389440.0
2013-12-10 13:00:00	NVDA	Stock	0.3884	0.389	0.3873	0.3886	46531880.0
2013-12-10 14:00:00	NVDA	Stock	0.3885	0.3893	0.3878	0.3881	30338960.0
2013-12-10 15:00:00	NVDA	Stock	0.3882	0.389	0.386	0.389	243925120.0
2013-12-10 16:00:00	NVDA	Stock	0.389	0.3891	0.3806	0.3891	11875560.0
2013-12-10 18:00:00	NVDA	Stock	0.387	0.387	0.387	0.387	4000.0
2013-12-10 06:00:00	AMZN	Stock	19.3075	19.359	19.3075	19.359	7000.0
2013-12-10 07:00:00	AMZN	Stock	19.2815	19.283	19.281	19.283	23460.0
2013-12-10 08:00:00	AMZN	Stock	19.2745	19.2745	19.175	19.175	252760.0
2013-12-10 09:00:00	AMZN	Stock	19.159	19.227	19.151	19.197	8414840.0
2013-12-10 10:00:00	AMZN	Stock	19.1925	19.35	19.1925	19.345	12606140.0
2013-12-10 11:00:00	AMZN	Stock	19.3445	19.4025	19.34	19.3635	5806680.0
2013-12-10 12:00:00	AMZN	Stock	19.368	19.4425	19.3488	19.4315	4420100.0
2013-12-10 13:00:00	AMZN	Stock	19.4325	19.453	19.413	19.437	3757560.0
2013-12-10 14:00:00	AMZN	Stock	19.4385	19.4385	19.378	19.4081	3458340.0
2013-12-10 15:00:00	AMZN	Stock	19.4085	19.4435	19.3705	19.3895	6197460.0
2013-12-10 16:00:00	AMZN	Stock	19.389	19.4	19.2445	19.4	890300.0
2013-12-10 17:00:00	AMZN	Stock	19.4	19.405	19.389	19.405	73480.0
2013-12-10 18:00:00	AMZN	Stock	19.406	19.4125	19.406	19.4125	10000.0

> showing 50 of 48,034 rows — these rows as CSV

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