PREVIEW / stock_1hour / 2016-08-23

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-08-23.parquet
  size:    1.0 MB
  rows:    48,178
  symbols: 3,255

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-08-23 04:00:00	AAPL	Stock	27.1	27.175	27.1	27.17	7200.0
2016-08-23 05:00:00	AAPL	Stock	27.185	27.1925	27.1675	27.1925	5036.0
2016-08-23 06:00:00	AAPL	Stock	27.2	27.2	27.175	27.175	1672.0
2016-08-23 07:00:00	AAPL	Stock	27.17	27.175	27.1575	27.1675	19760.0
2016-08-23 08:00:00	AAPL	Stock	27.15	27.175	27.125	27.1425	139700.0
2016-08-23 09:00:00	AAPL	Stock	27.15	27.33	27.1225	27.325	16260116.0
2016-08-23 10:00:00	AAPL	Stock	27.3248	27.33	27.2625	27.28	11199596.0
2016-08-23 11:00:00	AAPL	Stock	27.278	27.28	27.2025	27.219	9862380.0
2016-08-23 12:00:00	AAPL	Stock	27.2175	27.28	27.2	27.22	7866532.0
2016-08-23 13:00:00	AAPL	Stock	27.2175	27.2675	27.21	27.255	4654776.0
2016-08-23 14:00:00	AAPL	Stock	27.255	27.275	27.2175	27.2365	5744276.0
2016-08-23 15:00:00	AAPL	Stock	27.235	27.245	27.2	27.2075	10407460.0
2016-08-23 16:00:00	AAPL	Stock	27.2025	27.2875	27.2	27.2125	7212104.0
2016-08-23 17:00:00	AAPL	Stock	27.21	27.2225	27.205	27.2225	17252.0
2016-08-23 18:00:00	AAPL	Stock	27.205	27.2275	27.205	27.2075	21200.0
2016-08-23 19:00:00	AAPL	Stock	27.2075	27.22	27.2075	27.22	7924.0
2016-08-23 08:00:00	MSFT	Stock	57.75	57.8	57.75	57.8	1491.0
2016-08-23 09:00:00	MSFT	Stock	57.8	58.18	57.76	58.13	2195231.0
2016-08-23 10:00:00	MSFT	Stock	58.125	58.17	57.98	58.03	2180073.0
2016-08-23 11:00:00	MSFT	Stock	58.03	58.06	57.9	57.95	1803008.0
2016-08-23 12:00:00	MSFT	Stock	57.94	57.99	57.86	57.907	1349218.0
2016-08-23 13:00:00	MSFT	Stock	57.91	58.04	57.9	57.95	1583837.0
2016-08-23 14:00:00	MSFT	Stock	57.95	57.99	57.88	57.94	1902699.0
2016-08-23 15:00:00	MSFT	Stock	57.92	57.98	57.85	57.9	3899283.0
2016-08-23 16:00:00	MSFT	Stock	57.9	57.9	57.89	57.89	2447374.0
2016-08-23 04:00:00	NVDA	Stock	1.5668	1.5668	1.5668	1.5668	4000.0
2016-08-23 07:00:00	NVDA	Stock	1.566	1.5698	1.566	1.5698	42400.0
2016-08-23 08:00:00	NVDA	Stock	1.5688	1.572	1.56	1.57	249160.0
2016-08-23 09:00:00	NVDA	Stock	1.57	1.583	1.57	1.5732	59824240.0
2016-08-23 10:00:00	NVDA	Stock	1.5734	1.5798	1.5682	1.5716	55536800.0
2016-08-23 11:00:00	NVDA	Stock	1.5715	1.5758	1.5689	1.5741	55859040.0
2016-08-23 12:00:00	NVDA	Stock	1.5741	1.5773	1.5703	1.5723	32408720.0
2016-08-23 13:00:00	NVDA	Stock	1.572	1.5788	1.571	1.5759	29826600.0
2016-08-23 14:00:00	NVDA	Stock	1.5758	1.578	1.5721	1.5728	27380520.0
2016-08-23 15:00:00	NVDA	Stock	1.5725	1.5744	1.5708	1.5728	57116440.0
2016-08-23 16:00:00	NVDA	Stock	1.5728	1.5738	1.5725	1.5725	8009640.0
2016-08-23 17:00:00	NVDA	Stock	1.5725	1.5745	1.5725	1.5745	103600.0
2016-08-23 18:00:00	NVDA	Stock	1.575	1.579	1.5745	1.5775	202360.0
2016-08-23 19:00:00	NVDA	Stock	1.5762	1.5762	1.573	1.5752	69720.0
2016-08-23 04:00:00	AMZN	Stock	37.9875	37.9875	37.9875	37.9875	2900.0
2016-08-23 08:00:00	AMZN	Stock	38.1025	38.137	38.1025	38.137	96140.0
2016-08-23 09:00:00	AMZN	Stock	38.13	38.235	38.05	38.1855	5082820.0
2016-08-23 10:00:00	AMZN	Stock	38.186	38.2335	38.1255	38.156	4920120.0
2016-08-23 11:00:00	AMZN	Stock	38.166	38.1966	38.1126	38.18	2201860.0
2016-08-23 12:00:00	AMZN	Stock	38.179	38.182	38.0794	38.095	2153800.0
2016-08-23 13:00:00	AMZN	Stock	38.0965	38.1545	38.0805	38.1222	1824140.0
2016-08-23 14:00:00	AMZN	Stock	38.1153	38.199	38.0915	38.162	1720180.0
2016-08-23 15:00:00	AMZN	Stock	38.152	38.191	38.0922	38.122	3792740.0
2016-08-23 16:00:00	AMZN	Stock	38.1225	38.1602	38.0925	38.12	3520020.0
2016-08-23 17:00:00	AMZN	Stock	38.117	38.1245	38.0915	38.11	27020.0

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

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