PREVIEW / stock_1hour / 2014-08-27

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-08-27.parquet
  size:    1.0 MB
  rows:    47,983
  symbols: 3,562

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-08-27 04:00:00	AAPL	Stock	25.2725	25.2725	25.2725	25.2725	400.0
2014-08-27 05:00:00	AAPL	Stock	25.3175	25.33	25.3175	25.325	2800.0
2014-08-27 06:00:00	AAPL	Stock	25.2925	25.315	25.2925	25.315	800.0
2014-08-27 07:00:00	AAPL	Stock	25.32	25.32	25.275	25.28	94628.0
2014-08-27 08:00:00	AAPL	Stock	25.2825	25.3125	25.2225	25.2625	398536.0
2014-08-27 09:00:00	AAPL	Stock	25.26	25.295	25.175	25.2125	18874000.0
2014-08-27 10:00:00	AAPL	Stock	25.2125	25.295	25.1775	25.2888	20522408.0
2014-08-27 11:00:00	AAPL	Stock	25.29	25.495	25.25	25.44	27660144.0
2014-08-27 12:00:00	AAPL	Stock	25.44	25.515	25.4328	25.515	21131540.0
2014-08-27 13:00:00	AAPL	Stock	25.5148	25.545	25.46	25.54	19407404.0
2014-08-27 14:00:00	AAPL	Stock	25.5375	25.6425	25.5175	25.52	31850436.0
2014-08-27 15:00:00	AAPL	Stock	25.5175	25.5625	25.485	25.53	27313040.0
2014-08-27 16:00:00	AAPL	Stock	25.5325	25.547	20.6265	25.4775	7544240.0
2014-08-27 17:00:00	AAPL	Stock	25.4925	25.5125	25.4925	25.4975	102216.0
2014-08-27 18:00:00	AAPL	Stock	25.51	25.5325	25.49	25.5	3211376.0
2014-08-27 19:00:00	AAPL	Stock	25.5	25.525	25.49	25.525	140828.0
2014-08-27 07:00:00	MSFT	Stock	45.1	45.1	45.1	45.1	100.0
2014-08-27 08:00:00	MSFT	Stock	45.11	45.11	45.0	45.0	550.0
2014-08-27 09:00:00	MSFT	Stock	45.01	45.01	44.85	44.88	1818044.0
2014-08-27 10:00:00	MSFT	Stock	44.875	44.95	44.86	44.88	2394963.0
2014-08-27 11:00:00	MSFT	Stock	44.88	44.95	44.83	44.88	1842923.0
2014-08-27 12:00:00	MSFT	Stock	44.88	44.93	44.85	44.87	1075452.0
2014-08-27 13:00:00	MSFT	Stock	44.87	44.91	44.76	44.76	1917429.0
2014-08-27 14:00:00	MSFT	Stock	44.76	44.83	44.76	44.77	2189592.0
2014-08-27 15:00:00	MSFT	Stock	44.765	44.87	44.76	44.86	4147752.0
2014-08-27 16:00:00	MSFT	Stock	44.87	44.87	44.74	44.87	4810795.0
2014-08-27 17:00:00	MSFT	Stock	44.8	44.8	44.8	44.8	100.0
2014-08-27 18:00:00	MSFT	Stock	44.87	44.87	44.8	44.8	464820.0
2014-08-27 09:00:00	NVDA	Stock	0.485	0.4869	0.4821	0.4822	25567480.0
2014-08-27 10:00:00	NVDA	Stock	0.4822	0.4832	0.48	0.4824	31724160.0
2014-08-27 11:00:00	NVDA	Stock	0.4825	0.4828	0.4818	0.4825	12275720.0
2014-08-27 12:00:00	NVDA	Stock	0.4825	0.4828	0.4815	0.4825	9179520.0
2014-08-27 13:00:00	NVDA	Stock	0.4825	0.485	0.482	0.485	21786840.0
2014-08-27 14:00:00	NVDA	Stock	0.4848	0.485	0.4812	0.4812	16993440.0
2014-08-27 15:00:00	NVDA	Stock	0.4815	0.482	0.4805	0.4809	49056920.0
2014-08-27 16:00:00	NVDA	Stock	0.4808	0.482	0.4805	0.4806	446920.0
2014-08-27 17:00:00	NVDA	Stock	0.4808	0.4808	0.48	0.48	102360.0
2014-08-27 18:00:00	NVDA	Stock	0.4847	0.4847	0.4847	0.4847	890400.0
2014-08-27 06:00:00	AMZN	Stock	17.109	17.125	17.109	17.125	6000.0
2014-08-27 07:00:00	AMZN	Stock	17.149	17.149	17.1275	17.1275	6000.0
2014-08-27 08:00:00	AMZN	Stock	17.1125	17.149	17.0875	17.11	243480.0
2014-08-27 09:00:00	AMZN	Stock	17.125	17.1864	17.067	17.1295	10667460.0
2014-08-27 10:00:00	AMZN	Stock	17.134	17.3335	17.123	17.314	12939620.0
2014-08-27 11:00:00	AMZN	Stock	17.312	17.3195	17.1585	17.1925	8149760.0
2014-08-27 12:00:00	AMZN	Stock	17.196	17.196	17.0955	17.145	4281320.0
2014-08-27 13:00:00	AMZN	Stock	17.1405	17.1825	17.0855	17.1664	3246100.0
2014-08-27 14:00:00	AMZN	Stock	17.1655	17.18	17.1465	17.1532	4084280.0
2014-08-27 15:00:00	AMZN	Stock	17.151	17.168	17.1254	17.159	7485140.0
2014-08-27 16:00:00	AMZN	Stock	17.159	17.1774	17.1465	17.159	4435720.0
2014-08-27 08:00:00	GOOGL	Stock	29.5	29.5	29.5	29.5	2000.0

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

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