PREVIEW / stock_1hour / 2016-05-27

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-05-27.parquet
  size:    1.0 MB
  rows:    47,495
  symbols: 3,286

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
2016-05-27 04:00:00	AAPL	Stock	25.1	25.115	25.1	25.115	1964.0
2016-05-27 05:00:00	AAPL	Stock	25.0875	25.1125	25.075	25.075	2700.0
2016-05-27 06:00:00	AAPL	Stock	25.09	25.09	25.075	25.08	14536.0
2016-05-27 07:00:00	AAPL	Stock	25.075	25.075	24.9	24.92	283536.0
2016-05-27 08:00:00	AAPL	Stock	24.9725	25.0875	24.8	24.8125	983552.0
2016-05-27 09:00:00	AAPL	Stock	24.8225	25.015	24.8112	25.0123	28214908.0
2016-05-27 10:00:00	AAPL	Stock	25.0075	25.1175	24.9275	24.9662	26680428.0
2016-05-27 11:00:00	AAPL	Stock	24.9675	25.05	24.93	24.9925	15302228.0
2016-05-27 12:00:00	AAPL	Stock	24.9912	25.005	24.975	24.9988	9395696.0
2016-05-27 13:00:00	AAPL	Stock	24.9985	25.01	24.95	24.9575	10994620.0
2016-05-27 14:00:00	AAPL	Stock	24.9575	25.0225	24.9375	25.02	9974232.0
2016-05-27 15:00:00	AAPL	Stock	25.0212	25.085	24.9825	25.085	18502928.0
2016-05-27 16:00:00	AAPL	Stock	25.085	25.0875	24.984	25.0625	8577272.0
2016-05-27 17:00:00	AAPL	Stock	25.04	25.0625	25.02	25.055	74352.0
2016-05-27 18:00:00	AAPL	Stock	25.0375	25.05	25.035	25.0425	86792.0
2016-05-27 19:00:00	AAPL	Stock	25.04	25.06	25.035	25.06	29468.0
2016-05-27 05:00:00	MSFT	Stock	52.0	52.0	52.0	52.0	100.0
2016-05-27 07:00:00	MSFT	Stock	51.99	51.99	51.99	51.99	100.0
2016-05-27 08:00:00	MSFT	Stock	52.13	52.13	51.8	51.95	3259.0
2016-05-27 09:00:00	MSFT	Stock	51.93	52.06	51.77	51.985	1819369.0
2016-05-27 10:00:00	MSFT	Stock	51.98	52.06	51.82	51.96	1799714.0
2016-05-27 11:00:00	MSFT	Stock	51.96	52.215	51.95	52.15	1558341.0
2016-05-27 12:00:00	MSFT	Stock	52.145	52.3	52.12	52.21	1290236.0
2016-05-27 13:00:00	MSFT	Stock	52.205	52.27	52.11	52.15	1210038.0
2016-05-27 14:00:00	MSFT	Stock	52.14	52.21	52.03	52.173	1411522.0
2016-05-27 15:00:00	MSFT	Stock	52.175	52.31	52.07	52.31	4584656.0
2016-05-27 16:00:00	MSFT	Stock	52.31	52.41	52.28	52.41	2966025.0
2016-05-27 17:00:00	MSFT	Stock	52.41	52.41	52.3	52.3	14794.0
2016-05-27 18:00:00	MSFT	Stock	52.3	52.3	52.3	52.3	175.0
2016-05-27 19:00:00	MSFT	Stock	52.3	52.3	52.3	52.3	300.0
2016-05-27 07:00:00	NVDA	Stock	1.1415	1.1415	1.1413	1.1413	72000.0
2016-05-27 08:00:00	NVDA	Stock	1.14	1.1413	1.1368	1.1368	54920.0
2016-05-27 09:00:00	NVDA	Stock	1.144	1.1489	1.1388	1.1483	29192120.0
2016-05-27 10:00:00	NVDA	Stock	1.1482	1.1493	1.142	1.1425	35637240.0
2016-05-27 11:00:00	NVDA	Stock	1.1425	1.1476	1.1405	1.1455	26346360.0
2016-05-27 12:00:00	NVDA	Stock	1.1458	1.1488	1.1441	1.1455	19024960.0
2016-05-27 13:00:00	NVDA	Stock	1.1456	1.1465	1.1438	1.1448	23719200.0
2016-05-27 14:00:00	NVDA	Stock	1.1445	1.1464	1.1438	1.1458	20143160.0
2016-05-27 15:00:00	NVDA	Stock	1.1455	1.1475	1.145	1.1475	37032480.0
2016-05-27 16:00:00	NVDA	Stock	1.1475	1.1488	1.1462	1.1462	42804440.0
2016-05-27 17:00:00	NVDA	Stock	1.1462	1.1462	1.1462	1.1462	40000.0
2016-05-27 18:00:00	NVDA	Stock	1.1475	1.1475	1.1475	1.1475	36000.0
2016-05-27 19:00:00	NVDA	Stock	1.1475	1.1475	1.1475	1.1475	9320.0
2016-05-27 07:00:00	AMZN	Stock	35.797	35.797	35.771	35.795	12080.0
2016-05-27 08:00:00	AMZN	Stock	35.8	35.8	35.7785	35.7975	107900.0
2016-05-27 09:00:00	AMZN	Stock	35.7585	35.83	35.6505	35.723	8985460.0
2016-05-27 10:00:00	AMZN	Stock	35.717	35.792	35.6305	35.7425	6536020.0
2016-05-27 11:00:00	AMZN	Stock	35.751	35.793	35.677	35.7435	3184940.0
2016-05-27 12:00:00	AMZN	Stock	35.7505	35.757	35.7125	35.7443	2315280.0
2016-05-27 13:00:00	AMZN	Stock	35.7391	35.7545	35.655	35.66	2516860.0

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

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