PREVIEW / stock_1hour / 2017-09-07

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-09-07.parquet
  size:    1.0 MB
  rows:    48,149
  symbols: 2,978

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
2017-09-07 04:00:00	AAPL	Stock	40.5	40.5	40.5	40.5	592.0
2017-09-07 05:00:00	AAPL	Stock	40.5	40.55	40.4875	40.5	35836.0
2017-09-07 06:00:00	AAPL	Stock	40.515	40.56	40.515	40.56	18204.0
2017-09-07 07:00:00	AAPL	Stock	40.5325	40.5425	40.4875	40.4875	42176.0
2017-09-07 08:00:00	AAPL	Stock	40.5125	40.535	40.4375	40.5125	204436.0
2017-09-07 09:00:00	AAPL	Stock	40.5125	40.56	40.3462	40.3725	9149280.0
2017-09-07 10:00:00	AAPL	Stock	40.37	40.55	40.255	40.509	14270756.0
2017-09-07 11:00:00	AAPL	Stock	40.5075	40.536	40.4175	40.4625	7143756.0
2017-09-07 12:00:00	AAPL	Stock	40.465	40.5225	40.09	40.2612	19817716.0
2017-09-07 13:00:00	AAPL	Stock	40.26	40.375	40.235	40.3125	8097188.0
2017-09-07 14:00:00	AAPL	Stock	40.3125	40.355	40.2875	40.3325	5060696.0
2017-09-07 15:00:00	AAPL	Stock	40.3325	40.3625	40.255	40.3175	10847120.0
2017-09-07 16:00:00	AAPL	Stock	40.3175	40.325	40.3	40.3	3997808.0
2017-09-07 17:00:00	AAPL	Stock	40.3	40.315	40.2925	40.2925	101696.0
2017-09-07 18:00:00	AAPL	Stock	40.2975	40.315	40.2975	40.3	11956.0
2017-09-07 19:00:00	AAPL	Stock	40.315	40.33	40.3	40.32	27300.0
2017-09-07 05:00:00	MSFT	Stock	73.77	73.8	73.77	73.8	3755.0
2017-09-07 08:00:00	MSFT	Stock	73.55	73.57	73.39	73.57	35010.0
2017-09-07 09:00:00	MSFT	Stock	73.57	73.98	73.57	73.845	1570817.0
2017-09-07 10:00:00	MSFT	Stock	73.84	74.5	73.68	74.435	3341753.0
2017-09-07 11:00:00	MSFT	Stock	74.42	74.6	74.3	74.37	1833463.0
2017-09-07 12:00:00	MSFT	Stock	74.37	74.51	74.23	74.35	1533336.0
2017-09-07 13:00:00	MSFT	Stock	74.34	74.58	74.337	74.57	1168976.0
2017-09-07 14:00:00	MSFT	Stock	74.565	74.6	74.51	74.585	1218840.0
2017-09-07 15:00:00	MSFT	Stock	74.59	74.6	74.28	74.36	3686551.0
2017-09-07 16:00:00	MSFT	Stock	74.34	74.49	74.288	74.45	1365988.0
2017-09-07 17:00:00	MSFT	Stock	74.4	74.4	74.34	74.37	21674.0
2017-09-07 18:00:00	MSFT	Stock	74.35	74.36	74.35	74.35	1733.0
2017-09-07 19:00:00	MSFT	Stock	74.44	74.44	74.36	74.36	900.0
2017-09-07 06:00:00	NVDA	Stock	4.1486	4.1592	4.1486	4.158	88000.0
2017-09-07 07:00:00	NVDA	Stock	4.158	4.1584	4.1466	4.1525	215960.0
2017-09-07 08:00:00	NVDA	Stock	4.1548	4.1548	4.1375	4.1528	413000.0
2017-09-07 09:00:00	NVDA	Stock	4.1502	4.165	4.13	4.1353	47578520.0
2017-09-07 10:00:00	NVDA	Stock	4.1355	4.1873	4.1238	4.1825	89274680.0
2017-09-07 11:00:00	NVDA	Stock	4.1825	4.1972	4.171	4.1752	52802400.0
2017-09-07 12:00:00	NVDA	Stock	4.175	4.1859	4.163	4.1708	33102280.0
2017-09-07 13:00:00	NVDA	Stock	4.1705	4.1828	4.1667	4.17	25597480.0
2017-09-07 14:00:00	NVDA	Stock	4.1715	4.1715	4.152	4.1546	26698360.0
2017-09-07 15:00:00	NVDA	Stock	4.1545	4.1693	4.1465	4.1648	48441800.0
2017-09-07 16:00:00	NVDA	Stock	4.1645	4.167	4.159	4.163	6569800.0
2017-09-07 17:00:00	NVDA	Stock	4.165	4.165	4.1628	4.163	266200.0
2017-09-07 18:00:00	NVDA	Stock	4.1628	4.1663	4.1625	4.1625	218040.0
2017-09-07 19:00:00	NVDA	Stock	4.161	4.163	4.161	4.1615	43720.0
2017-09-07 07:00:00	AMZN	Stock	48.5	48.5	48.5	48.5	4000.0
2017-09-07 08:00:00	AMZN	Stock	48.5435	48.75	48.539	48.75	108060.0
2017-09-07 09:00:00	AMZN	Stock	48.7235	48.95	48.6275	48.7862	8380980.0
2017-09-07 10:00:00	AMZN	Stock	48.7955	48.9875	48.676	48.9505	7968020.0
2017-09-07 11:00:00	AMZN	Stock	48.9525	49.0295	48.8365	48.971	5610640.0
2017-09-07 12:00:00	AMZN	Stock	48.971	48.989	48.855	48.9062	4714760.0
2017-09-07 13:00:00	AMZN	Stock	48.908	49.028	48.895	48.98	3341720.0

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

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