PREVIEW / stock_1hour / 2017-07-19

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-07-19.parquet
  size:    1.0 MB
  rows:    48,108
  symbols: 2,996

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-07-19 04:00:00	AAPL	Stock	37.5875	37.6125	37.575	37.6125	4800.0
2017-07-19 05:00:00	AAPL	Stock	37.565	37.5925	37.525	37.5925	4952.0
2017-07-19 06:00:00	AAPL	Stock	37.585	37.5875	37.585	37.5875	3808.0
2017-07-19 07:00:00	AAPL	Stock	37.5875	37.6175	37.5625	37.565	61936.0
2017-07-19 08:00:00	AAPL	Stock	37.6125	37.615	37.4375	37.5875	118392.0
2017-07-19 09:00:00	AAPL	Stock	37.6	37.7375	37.4875	37.6625	10624952.0
2017-07-19 10:00:00	AAPL	Stock	37.66	37.7025	37.5625	37.6025	10539332.0
2017-07-19 11:00:00	AAPL	Stock	37.6025	37.69	37.6025	37.6825	6658480.0
2017-07-19 12:00:00	AAPL	Stock	37.685	37.7575	37.6675	37.7525	7065984.0
2017-07-19 13:00:00	AAPL	Stock	37.7525	37.855	37.7175	37.76	11821956.0
2017-07-19 14:00:00	AAPL	Stock	37.7615	37.825	37.7615	37.7625	5529432.0
2017-07-19 15:00:00	AAPL	Stock	37.765	37.775	37.685	37.755	12562388.0
2017-07-19 16:00:00	AAPL	Stock	37.755	37.7625	37.7	37.7	9459256.0
2017-07-19 17:00:00	AAPL	Stock	37.6925	37.755	37.675	37.7	222396.0
2017-07-19 18:00:00	AAPL	Stock	37.7	37.7125	37.7	37.7125	11508.0
2017-07-19 19:00:00	AAPL	Stock	37.7125	37.7125	37.6975	37.6975	6408.0
2017-07-19 04:00:00	MSFT	Stock	73.53	73.53	73.5	73.5	2800.0
2017-07-19 06:00:00	MSFT	Stock	73.52	73.52	73.4	73.51	1780.0
2017-07-19 07:00:00	MSFT	Stock	73.5	73.52	73.43	73.48	5313.0
2017-07-19 08:00:00	MSFT	Stock	73.45	73.59	73.43	73.5	19667.0
2017-07-19 09:00:00	MSFT	Stock	73.54	73.78	73.43	73.68	2810682.0
2017-07-19 10:00:00	MSFT	Stock	73.68	73.735	73.54	73.71	2805330.0
2017-07-19 11:00:00	MSFT	Stock	73.71	73.85	73.702	73.81	2196722.0
2017-07-19 12:00:00	MSFT	Stock	73.82	73.97	73.815	73.94	2257852.0
2017-07-19 13:00:00	MSFT	Stock	73.94	74.04	73.875	73.895	2088772.0
2017-07-19 14:00:00	MSFT	Stock	73.89	74.03	73.88	73.88	2057763.0
2017-07-19 15:00:00	MSFT	Stock	73.88	73.955	73.8	73.85	3846789.0
2017-07-19 16:00:00	MSFT	Stock	73.86	74.06	73.81	73.92	1905638.0
2017-07-19 17:00:00	MSFT	Stock	74.0	74.04	73.86	74.04	79258.0
2017-07-19 18:00:00	MSFT	Stock	73.95	74.04	73.95	74.0	7052.0
2017-07-19 19:00:00	MSFT	Stock	74.0	74.06	73.86	74.0	222668.0
2017-07-19 04:00:00	NVDA	Stock	4.16	4.185	4.16	4.175	69160.0
2017-07-19 05:00:00	NVDA	Stock	4.175	4.175	4.175	4.175	20000.0
2017-07-19 06:00:00	NVDA	Stock	4.163	4.163	4.1598	4.1598	91240.0
2017-07-19 07:00:00	NVDA	Stock	4.159	4.1715	4.159	4.1638	377680.0
2017-07-19 08:00:00	NVDA	Stock	4.165	4.1712	4.16	4.1667	2468000.0
2017-07-19 09:00:00	NVDA	Stock	4.167	4.1752	4.1283	4.1518	117984000.0
2017-07-19 10:00:00	NVDA	Stock	4.1523	4.1592	4.1175	4.1311	151946000.0
2017-07-19 11:00:00	NVDA	Stock	4.1315	4.1618	4.1255	4.1594	75980920.0
2017-07-19 12:00:00	NVDA	Stock	4.1595	4.1725	4.1532	4.1682	64149240.0
2017-07-19 13:00:00	NVDA	Stock	4.1683	4.185	4.1603	4.161	79654400.0
2017-07-19 14:00:00	NVDA	Stock	4.1612	4.1715	4.155	4.1592	48303560.0
2017-07-19 15:00:00	NVDA	Stock	4.1598	4.1672	4.1153	4.1275	95409000.0
2017-07-19 16:00:00	NVDA	Stock	4.1275	4.1292	4.12	4.128	12554640.0
2017-07-19 17:00:00	NVDA	Stock	4.1285	4.1388	4.1275	4.135	539400.0
2017-07-19 18:00:00	NVDA	Stock	4.134	4.1385	4.13	4.13	353280.0
2017-07-19 19:00:00	NVDA	Stock	4.1275	4.1388	4.1275	4.1302	1329000.0
2017-07-19 07:00:00	AMZN	Stock	51.263	51.32	51.263	51.32	92360.0
2017-07-19 08:00:00	AMZN	Stock	51.287	51.32	51.225	51.25	234740.0
2017-07-19 09:00:00	AMZN	Stock	51.29	51.5145	51.125	51.476	14747220.0

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

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