PREVIEW / stock_1hour / 2018-06-12

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-06-12.parquet
  size:    1.1 MB
  rows:    49,603
  symbols: 2,823

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
2018-06-12 04:00:00	AAPL	Stock	47.8725	47.8725	47.83	47.83	1600.0
2018-06-12 07:00:00	AAPL	Stock	47.75	47.83	47.75	47.825	59140.0
2018-06-12 08:00:00	AAPL	Stock	47.8075	47.9125	47.7525	47.885	230252.0
2018-06-12 09:00:00	AAPL	Stock	47.875	47.9475	47.7875	47.8075	8115308.0
2018-06-12 10:00:00	AAPL	Stock	47.8075	47.9725	47.8	47.871	8381496.0
2018-06-12 11:00:00	AAPL	Stock	47.8725	47.935	47.8	47.9225	5637576.0
2018-06-12 12:00:00	AAPL	Stock	47.9225	47.965	47.9075	47.955	5008560.0
2018-06-12 13:00:00	AAPL	Stock	47.955	48.1528	47.9538	48.106	7703420.0
2018-06-12 14:00:00	AAPL	Stock	48.105	48.105	47.8225	47.8275	6699316.0
2018-06-12 15:00:00	AAPL	Stock	47.8285	48.085	47.82	48.0625	9818508.0
2018-06-12 16:00:00	AAPL	Stock	48.07	48.0875	48.015	48.0875	7823156.0
2018-06-12 17:00:00	AAPL	Stock	48.07	48.075	48.0575	48.06	17300.0
2018-06-12 18:00:00	AAPL	Stock	48.075	48.0875	48.055	48.0875	21192.0
2018-06-12 19:00:00	AAPL	Stock	48.0875	48.125	48.075	48.125	57984.0
2018-06-12 04:00:00	MSFT	Stock	101.0	101.06	101.0	101.06	309.0
2018-06-12 06:00:00	MSFT	Stock	101.06	101.06	101.05	101.05	200.0
2018-06-12 07:00:00	MSFT	Stock	101.15	101.15	101.0	101.09	1698.0
2018-06-12 08:00:00	MSFT	Stock	101.2	101.34	101.05	101.24	14733.0
2018-06-12 09:00:00	MSFT	Stock	101.19	101.449	101.05	101.09	1832575.0
2018-06-12 10:00:00	MSFT	Stock	101.08	101.215	101.0	101.17	2068553.0
2018-06-12 11:00:00	MSFT	Stock	101.175	101.39	100.89	101.325	2051980.0
2018-06-12 12:00:00	MSFT	Stock	101.325	101.4	101.04	101.185	1279822.0
2018-06-12 13:00:00	MSFT	Stock	101.185	101.29	101.124	101.205	1578381.0
2018-06-12 14:00:00	MSFT	Stock	101.2	101.23	100.75	100.835	1756791.0
2018-06-12 15:00:00	MSFT	Stock	100.83	101.44	100.82	101.3	3432281.0
2018-06-12 16:00:00	MSFT	Stock	101.31	101.35	101.105	101.3	2217862.0
2018-06-12 17:00:00	MSFT	Stock	101.31	101.4	101.31	101.32	2897.0
2018-06-12 18:00:00	MSFT	Stock	101.4	101.4	101.31	101.32	2146.0
2018-06-12 19:00:00	MSFT	Stock	101.32	101.59	101.32	101.59	1538.0
2018-06-12 04:00:00	NVDA	Stock	6.542	6.542	6.525	6.525	62240.0
2018-06-12 06:00:00	NVDA	Stock	6.5233	6.5233	6.5233	6.5233	12000.0
2018-06-12 07:00:00	NVDA	Stock	6.5375	6.541	6.523	6.53	220720.0
2018-06-12 08:00:00	NVDA	Stock	6.5348	6.547	6.5213	6.547	729840.0
2018-06-12 09:00:00	NVDA	Stock	6.547	6.5648	6.5088	6.5287	41686000.0
2018-06-12 10:00:00	NVDA	Stock	6.5285	6.542	6.4915	6.5375	63206360.0
2018-06-12 11:00:00	NVDA	Stock	6.5378	6.5575	6.525	6.5501	33403400.0
2018-06-12 12:00:00	NVDA	Stock	6.5508	6.562	6.5412	6.5458	23974560.0
2018-06-12 13:00:00	NVDA	Stock	6.5467	6.5768	6.5445	6.5725	36212400.0
2018-06-12 14:00:00	NVDA	Stock	6.5719	6.5736	6.5168	6.5168	34292080.0
2018-06-12 15:00:00	NVDA	Stock	6.5175	6.5683	6.511	6.5683	58976640.0
2018-06-12 16:00:00	NVDA	Stock	6.5645	6.5645	6.5488	6.5635	3293360.0
2018-06-12 17:00:00	NVDA	Stock	6.5575	6.5629	6.5555	6.5618	137920.0
2018-06-12 18:00:00	NVDA	Stock	6.5625	6.5645	6.56	6.5625	159960.0
2018-06-12 19:00:00	NVDA	Stock	6.56	6.5698	6.5562	6.5698	152080.0
2018-06-12 04:00:00	AMZN	Stock	84.75	84.75	84.75	84.75	5180.0
2018-06-12 06:00:00	AMZN	Stock	84.612	84.612	84.612	84.612	3260.0
2018-06-12 07:00:00	AMZN	Stock	84.5685	84.5685	84.4935	84.519	50440.0
2018-06-12 08:00:00	AMZN	Stock	84.611	84.7	84.425	84.7	108880.0
2018-06-12 09:00:00	AMZN	Stock	84.7	84.9755	84.55	84.7175	8951400.0
2018-06-12 10:00:00	AMZN	Stock	84.738	84.9012	84.6005	84.797	5159720.0

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

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