PREVIEW / stock_1hour / 2014-05-02

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-05-02.parquet
  size:    1.0 MB
  rows:    47,338
  symbols: 3,533

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-02 04:00:00	AAPL	Stock	21.1429	21.1429	21.1429	21.1429	5600.0
2014-05-02 06:00:00	AAPL	Stock	21.1786	21.1786	21.1786	21.1786	5600.0
2014-05-02 07:00:00	AAPL	Stock	21.1768	21.1768	21.1607	21.1696	96320.0
2014-05-02 08:00:00	AAPL	Stock	21.1611	21.2107	21.1429	21.1639	648984.0
2014-05-02 09:00:00	AAPL	Stock	21.1646	21.2214	21.0911	21.1529	32048044.0
2014-05-02 10:00:00	AAPL	Stock	21.1489	21.1964	21.0611	21.1164	29226372.0
2014-05-02 11:00:00	AAPL	Stock	21.115	21.1896	21.1029	21.1732	15471568.0
2014-05-02 12:00:00	AAPL	Stock	21.1729	21.1946	21.1557	21.1621	10068772.0
2014-05-02 13:00:00	AAPL	Stock	21.1614	21.1654	21.1132	21.1132	11891460.0
2014-05-02 14:00:00	AAPL	Stock	21.112	21.155	21.1054	21.1336	12189856.0
2014-05-02 15:00:00	AAPL	Stock	21.1354	21.1875	21.1282	21.1636	32170068.0
2014-05-02 16:00:00	AAPL	Stock	21.1636	21.1686	21.0896	21.1636	6859356.0
2014-05-02 17:00:00	AAPL	Stock	21.1589	21.1636	21.1393	21.1393	505848.0
2014-05-02 18:00:00	AAPL	Stock	21.14	21.1514	21.1375	21.1514	269444.0
2014-05-02 19:00:00	AAPL	Stock	21.1464	21.1589	21.1429	21.1439	136808.0
2014-05-02 07:00:00	MSFT	Stock	40.09	40.1	40.09	40.09	1350.0
2014-05-02 08:00:00	MSFT	Stock	40.09	40.14	40.07	40.07	10447.0
2014-05-02 09:00:00	MSFT	Stock	40.07	40.4	39.84	39.875	5385028.0
2014-05-02 10:00:00	MSFT	Stock	39.87	40.04	39.84	39.86	5464999.0
2014-05-02 11:00:00	MSFT	Stock	39.86	39.96	39.77	39.92	2403017.0
2014-05-02 12:00:00	MSFT	Stock	39.92	39.97	39.83	39.91	1466517.0
2014-05-02 13:00:00	MSFT	Stock	39.911	39.945	39.76	39.79	5195966.0
2014-05-02 14:00:00	MSFT	Stock	39.796	39.82	39.66	39.756	8575743.0
2014-05-02 15:00:00	MSFT	Stock	39.76	39.815	39.67	39.69	11544449.0
2014-05-02 16:00:00	MSFT	Stock	39.69	39.913	39.68	39.73	2368863.0
2014-05-02 17:00:00	MSFT	Stock	39.73	39.88	39.7	39.7	15231.0
2014-05-02 18:00:00	MSFT	Stock	39.7	39.71	39.69	39.71	400.0
2014-05-02 19:00:00	MSFT	Stock	39.75	39.75	39.75	39.75	750.0
2014-05-02 07:00:00	NVDA	Stock	0.4798	0.4798	0.4798	0.4798	27600.0
2014-05-02 08:00:00	NVDA	Stock	0.4698	0.47	0.4698	0.47	54200.0
2014-05-02 09:00:00	NVDA	Stock	0.4665	0.4665	0.458	0.4595	34081440.0
2014-05-02 10:00:00	NVDA	Stock	0.4595	0.4662	0.4582	0.462	25574480.0
2014-05-02 11:00:00	NVDA	Stock	0.4622	0.4647	0.461	0.4638	14188360.0
2014-05-02 12:00:00	NVDA	Stock	0.4638	0.464	0.4625	0.4633	6261920.0
2014-05-02 13:00:00	NVDA	Stock	0.4631	0.4634	0.4605	0.4608	13896920.0
2014-05-02 14:00:00	NVDA	Stock	0.4608	0.462	0.4603	0.4618	22505920.0
2014-05-02 15:00:00	NVDA	Stock	0.4618	0.4625	0.4603	0.4605	29972760.0
2014-05-02 16:00:00	NVDA	Stock	0.4608	0.4635	0.4608	0.4608	6959480.0
2014-05-02 17:00:00	NVDA	Stock	0.462	0.462	0.462	0.462	8000.0
2014-05-02 07:00:00	AMZN	Stock	15.3875	15.3875	15.3875	15.3875	2000.0
2014-05-02 08:00:00	AMZN	Stock	15.425	15.476	15.3945	15.465	817060.0
2014-05-02 09:00:00	AMZN	Stock	15.452	15.6645	15.31	15.352	17722380.0
2014-05-02 10:00:00	AMZN	Stock	15.3532	15.419	15.2155	15.2532	18689100.0
2014-05-02 11:00:00	AMZN	Stock	15.2505	15.4055	15.24	15.3716	9385720.0
2014-05-02 12:00:00	AMZN	Stock	15.379	15.3945	15.318	15.3745	5883920.0
2014-05-02 13:00:00	AMZN	Stock	15.3728	15.3905	15.32	15.3705	4681380.0
2014-05-02 14:00:00	AMZN	Stock	15.374	15.421	15.343	15.3855	4844860.0
2014-05-02 15:00:00	AMZN	Stock	15.3815	15.41	15.3635	15.4	11558740.0
2014-05-02 16:00:00	AMZN	Stock	15.4005	15.4125	15.3153	15.4025	431140.0
2014-05-02 17:00:00	AMZN	Stock	15.3875	15.4005	15.375	15.4005	31100.0

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

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