PREVIEW / stock_1hour / 2019-04-18

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-04-18.parquet
  size:    1.1 MB
  rows:    49,520
  symbols: 2,622

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
2019-04-18 04:00:00	AAPL	Stock	50.4925	50.51	50.48	50.51	30836.0
2019-04-18 05:00:00	AAPL	Stock	50.5275	50.6725	50.5275	50.6375	7868.0
2019-04-18 06:00:00	AAPL	Stock	50.58	50.65	50.565	50.565	8480.0
2019-04-18 07:00:00	AAPL	Stock	50.5875	50.7875	50.58	50.75	151220.0
2019-04-18 08:00:00	AAPL	Stock	50.65	50.85	50.6025	50.6625	485076.0
2019-04-18 09:00:00	AAPL	Stock	50.6725	50.975	50.6175	50.7712	21806876.0
2019-04-18 10:00:00	AAPL	Stock	50.7725	50.875	50.63	50.8725	12658988.0
2019-04-18 11:00:00	AAPL	Stock	50.8725	50.985	50.76	50.8075	9027100.0
2019-04-18 12:00:00	AAPL	Stock	50.8075	50.915	50.785	50.8188	4880212.0
2019-04-18 13:00:00	AAPL	Stock	50.82	50.95	50.7875	50.93	4696940.0
2019-04-18 14:00:00	AAPL	Stock	50.935	51.0125	50.9225	50.9725	6102828.0
2019-04-18 15:00:00	AAPL	Stock	50.9725	51.0375	50.9025	50.965	9873728.0
2019-04-18 16:00:00	AAPL	Stock	50.9662	50.9825	50.935	50.9525	12412532.0
2019-04-18 17:00:00	AAPL	Stock	50.9575	50.9575	50.9375	50.94	25708.0
2019-04-18 18:00:00	AAPL	Stock	50.94	50.955	50.94	50.955	2104.0
2019-04-18 19:00:00	AAPL	Stock	50.955	50.9575	50.94	50.9575	15684.0
2019-04-18 04:00:00	MSFT	Stock	121.2	121.2	120.99	121.04	931.0
2019-04-18 05:00:00	MSFT	Stock	121.04	121.38	121.04	121.38	800.0
2019-04-18 06:00:00	MSFT	Stock	121.16	121.16	121.16	121.16	100.0
2019-04-18 07:00:00	MSFT	Stock	121.36	121.38	121.23	121.32	5368.0
2019-04-18 08:00:00	MSFT	Stock	121.3	121.7	121.23	121.59	14224.0
2019-04-18 09:00:00	MSFT	Stock	121.54	123.14	121.302	121.56	6095754.0
2019-04-18 10:00:00	MSFT	Stock	121.57	122.3	121.48	122.16	2921260.0
2019-04-18 11:00:00	MSFT	Stock	122.155	122.47	122.01	122.445	1982151.0
2019-04-18 12:00:00	MSFT	Stock	122.44	122.99	122.32	122.876	2935639.0
2019-04-18 13:00:00	MSFT	Stock	122.875	123.07	122.785	123.027	1639440.0
2019-04-18 14:00:00	MSFT	Stock	123.03	123.495	122.995	123.415	2127458.0
2019-04-18 15:00:00	MSFT	Stock	123.415	123.52	123.17	123.37	4269304.0
2019-04-18 16:00:00	MSFT	Stock	123.37	123.44	123.24	123.44	2703888.0
2019-04-18 17:00:00	MSFT	Stock	123.32	123.37	123.32	123.32	2382.0
2019-04-18 18:00:00	MSFT	Stock	123.37	123.48	123.33	123.37	2550.0
2019-04-18 19:00:00	MSFT	Stock	123.45	123.46	123.4	123.45	4394.0
2019-04-18 06:00:00	NVDA	Stock	4.6525	4.6525	4.6525	4.6525	5640.0
2019-04-18 07:00:00	NVDA	Stock	4.6625	4.6682	4.66	4.6663	137960.0
2019-04-18 08:00:00	NVDA	Stock	4.6618	4.68	4.6618	4.669	435720.0
2019-04-18 09:00:00	NVDA	Stock	4.676	4.7232	4.6625	4.7053	59200000.0
2019-04-18 10:00:00	NVDA	Stock	4.7062	4.7218	4.6525	4.672	59776240.0
2019-04-18 11:00:00	NVDA	Stock	4.6722	4.6792	4.6472	4.6665	46494360.0
2019-04-18 12:00:00	NVDA	Stock	4.6655	4.6718	4.6412	4.6415	24415880.0
2019-04-18 13:00:00	NVDA	Stock	4.6413	4.6535	4.6295	4.6535	30142480.0
2019-04-18 14:00:00	NVDA	Stock	4.6534	4.667	4.641	4.6458	32720240.0
2019-04-18 15:00:00	NVDA	Stock	4.6459	4.66	4.6332	4.6575	47315600.0
2019-04-18 16:00:00	NVDA	Stock	4.6578	4.6608	4.65	4.6588	18677520.0
2019-04-18 17:00:00	NVDA	Stock	4.659	4.6595	4.659	4.659	28240.0
2019-04-18 18:00:00	NVDA	Stock	4.659	4.6595	4.659	4.6595	106680.0
2019-04-18 19:00:00	NVDA	Stock	4.6612	4.6612	4.655	4.655	105800.0
2019-04-18 04:00:00	AMZN	Stock	92.7505	92.825	92.7505	92.825	4180.0
2019-04-18 05:00:00	AMZN	Stock	92.825	92.8695	92.825	92.8695	7360.0
2019-04-18 06:00:00	AMZN	Stock	92.95	92.95	92.95	92.95	2600.0
2019-04-18 07:00:00	AMZN	Stock	93.009	93.04	93.008	93.04	18060.0

> showing 50 of 49,520 rows — these rows as CSV

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