PREVIEW / stock_1hour / 2018-01-18

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-01-18.parquet
  size:    1.1 MB
  rows:    49,892
  symbols: 2,898

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-01-18 04:00:00	AAPL	Stock	44.815	44.825	44.7	44.8	36736.0
2018-01-18 05:00:00	AAPL	Stock	44.775	44.8	44.775	44.8	8352.0
2018-01-18 06:00:00	AAPL	Stock	44.7775	44.8725	44.7725	44.87	38844.0
2018-01-18 07:00:00	AAPL	Stock	44.87	44.9325	44.7375	44.7375	228288.0
2018-01-18 08:00:00	AAPL	Stock	44.75	44.9325	44.6775	44.7375	539748.0
2018-01-18 09:00:00	AAPL	Stock	44.7525	45.0125	44.6775	44.9263	21731964.0
2018-01-18 10:00:00	AAPL	Stock	44.9275	44.9538	44.5625	44.7875	21840112.0
2018-01-18 11:00:00	AAPL	Stock	44.788	44.935	44.735	44.8215	9792508.0
2018-01-18 12:00:00	AAPL	Stock	44.82	44.9425	44.775	44.93	8647768.0
2018-01-18 13:00:00	AAPL	Stock	44.93	45.005	44.855	44.9825	7551008.0
2018-01-18 14:00:00	AAPL	Stock	44.9775	45.025	44.93	44.99	8066156.0
2018-01-18 15:00:00	AAPL	Stock	44.9908	44.9925	44.7525	44.8175	15482020.0
2018-01-18 16:00:00	AAPL	Stock	44.815	44.94	44.6875	44.7125	17751696.0
2018-01-18 17:00:00	AAPL	Stock	44.7125	44.815	44.7125	44.7675	98020.0
2018-01-18 18:00:00	AAPL	Stock	44.745	44.815	44.0625	44.675	257420.0
2018-01-18 19:00:00	AAPL	Stock	44.6675	44.745	44.6675	44.735	120664.0
2018-01-18 06:00:00	MSFT	Stock	90.15	90.15	90.15	90.15	100.0
2018-01-18 07:00:00	MSFT	Stock	90.44	90.44	90.12	90.12	3819.0
2018-01-18 08:00:00	MSFT	Stock	90.2	90.2	89.89	90.0	15556.0
2018-01-18 09:00:00	MSFT	Stock	90.0	90.39	89.66	90.364	2137212.0
2018-01-18 10:00:00	MSFT	Stock	90.36	90.55	90.2	90.31	2787725.0
2018-01-18 11:00:00	MSFT	Stock	90.31	90.67	90.25	90.55	1668251.0
2018-01-18 12:00:00	MSFT	Stock	90.55	90.66	90.49	90.55	1317895.0
2018-01-18 13:00:00	MSFT	Stock	90.555	90.6	90.47	90.505	1939536.0
2018-01-18 14:00:00	MSFT	Stock	90.505	90.61	90.46	90.485	3077101.0
2018-01-18 15:00:00	MSFT	Stock	90.48	90.54	90.05	90.12	4682683.0
2018-01-18 16:00:00	MSFT	Stock	90.1	90.58	90.0	90.0	4057127.0
2018-01-18 17:00:00	MSFT	Stock	90.1	90.2	90.02	90.2	10836.0
2018-01-18 18:00:00	MSFT	Stock	90.1	90.2	90.1	90.2	8359.0
2018-01-18 19:00:00	MSFT	Stock	90.1	90.13	90.1	90.13	2100.0
2018-01-18 04:00:00	NVDA	Stock	5.6	5.6	5.593	5.593	41560.0
2018-01-18 05:00:00	NVDA	Stock	5.5988	5.62	5.5988	5.62	106000.0
2018-01-18 06:00:00	NVDA	Stock	5.615	5.615	5.615	5.615	42280.0
2018-01-18 07:00:00	NVDA	Stock	5.6153	5.621	5.595	5.595	174440.0
2018-01-18 08:00:00	NVDA	Stock	5.615	5.63	5.591	5.5938	901240.0
2018-01-18 09:00:00	NVDA	Stock	5.5908	5.666	5.5862	5.6488	93792600.0
2018-01-18 10:00:00	NVDA	Stock	5.6483	5.6498	5.567	5.6388	97017040.0
2018-01-18 11:00:00	NVDA	Stock	5.6375	5.6625	5.62	5.6363	58015200.0
2018-01-18 12:00:00	NVDA	Stock	5.6363	5.6478	5.625	5.6263	19072200.0
2018-01-18 13:00:00	NVDA	Stock	5.6275	5.636	5.6088	5.625	28103680.0
2018-01-18 14:00:00	NVDA	Stock	5.6238	5.6448	5.6205	5.6332	31234960.0
2018-01-18 15:00:00	NVDA	Stock	5.6322	5.6355	5.6008	5.611	46243280.0
2018-01-18 16:00:00	NVDA	Stock	5.611	5.611	5.6	5.6075	4142960.0
2018-01-18 17:00:00	NVDA	Stock	5.6023	5.611	5.6023	5.6023	212000.0
2018-01-18 18:00:00	NVDA	Stock	5.605	5.611	5.605	5.6055	632160.0
2018-01-18 19:00:00	NVDA	Stock	5.6055	5.6123	5.6055	5.6088	418000.0
2018-01-18 05:00:00	AMZN	Stock	64.804	64.804	64.8	64.8	8800.0
2018-01-18 06:00:00	AMZN	Stock	64.8785	64.8785	64.8785	64.8785	2000.0
2018-01-18 07:00:00	AMZN	Stock	64.95	64.95	64.7155	64.75	61120.0
2018-01-18 08:00:00	AMZN	Stock	64.9413	64.9413	64.5205	64.53	342660.0

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

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