PREVIEW / stock_1hour / 2018-04-12

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-04-12.parquet
  size:    1.1 MB
  rows:    48,329
  symbols: 2,849

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-04-12 04:00:00	AAPL	Stock	43.125	43.125	43.1025	43.1025	1600.0
2018-04-12 05:00:00	AAPL	Stock	43.1025	43.1025	43.05	43.0525	2684.0
2018-04-12 06:00:00	AAPL	Stock	43.005	43.2625	43.0	43.2625	10716.0
2018-04-12 07:00:00	AAPL	Stock	43.25	43.5	43.25	43.425	321408.0
2018-04-12 08:00:00	AAPL	Stock	43.45	43.48	43.3375	43.425	221736.0
2018-04-12 09:00:00	AAPL	Stock	43.4175	43.6325	43.26	43.6175	13993596.0
2018-04-12 10:00:00	AAPL	Stock	43.62	43.6875	43.549	43.59	13249696.0
2018-04-12 11:00:00	AAPL	Stock	43.5875	43.715	43.5275	43.64	10876312.0
2018-04-12 12:00:00	AAPL	Stock	43.6375	43.715	43.565	43.7038	6667944.0
2018-04-12 13:00:00	AAPL	Stock	43.705	43.7175	43.425	43.5125	9016732.0
2018-04-12 14:00:00	AAPL	Stock	43.5125	43.7025	43.49	43.685	6787896.0
2018-04-12 15:00:00	AAPL	Stock	43.6875	43.75	43.53	43.54	14534744.0
2018-04-12 16:00:00	AAPL	Stock	43.5375	43.57	43.525	43.55	7486936.0
2018-04-12 17:00:00	AAPL	Stock	43.5375	43.585	43.535	43.555	13960.0
2018-04-12 18:00:00	AAPL	Stock	43.5575	43.56	43.4525	43.4525	49952.0
2018-04-12 19:00:00	AAPL	Stock	43.4525	43.525	43.43	43.495	53724.0
2018-04-12 04:00:00	MSFT	Stock	92.09	92.09	92.0	92.0	300.0
2018-04-12 06:00:00	MSFT	Stock	92.0	92.0	92.0	92.0	200.0
2018-04-12 07:00:00	MSFT	Stock	92.45	92.6	92.34	92.5	21148.0
2018-04-12 08:00:00	MSFT	Stock	92.52	92.58	92.05	92.45	25017.0
2018-04-12 09:00:00	MSFT	Stock	92.45	93.61	92.4	93.6	2863194.0
2018-04-12 10:00:00	MSFT	Stock	93.59	93.85	93.36	93.51	3022274.0
2018-04-12 11:00:00	MSFT	Stock	93.49	93.71	93.2	93.435	2835590.0
2018-04-12 12:00:00	MSFT	Stock	93.44	93.73	93.254	93.695	1492310.0
2018-04-12 13:00:00	MSFT	Stock	93.69	93.775	92.84	93.1	2842719.0
2018-04-12 14:00:00	MSFT	Stock	93.1	93.7	93.04	93.68	2246228.0
2018-04-12 15:00:00	MSFT	Stock	93.67	94.16	93.56	93.6	4669291.0
2018-04-12 16:00:00	MSFT	Stock	93.58	93.63	93.455	93.49	4366594.0
2018-04-12 17:00:00	MSFT	Stock	93.59	93.79	93.51	93.63	3230.0
2018-04-12 18:00:00	MSFT	Stock	93.63	93.69	93.48	93.48	26206.0
2018-04-12 19:00:00	MSFT	Stock	93.45	93.48	93.4	93.48	21646.0
2018-04-12 04:00:00	NVDA	Stock	5.6625	5.6625	5.6625	5.6625	20000.0
2018-04-12 05:00:00	NVDA	Stock	5.6588	5.6713	5.6588	5.6713	17120.0
2018-04-12 06:00:00	NVDA	Stock	5.6973	5.701	5.6973	5.701	17120.0
2018-04-12 07:00:00	NVDA	Stock	5.6925	5.7175	5.6888	5.7145	619120.0
2018-04-12 08:00:00	NVDA	Stock	5.7	5.7435	5.6675	5.7312	2674400.0
2018-04-12 09:00:00	NVDA	Stock	5.7312	5.7613	5.7054	5.7455	73691600.0
2018-04-12 10:00:00	NVDA	Stock	5.746	5.7952	5.7375	5.7903	88989640.0
2018-04-12 11:00:00	NVDA	Stock	5.7905	5.8456	5.784	5.8326	78972160.0
2018-04-12 12:00:00	NVDA	Stock	5.8322	5.862	5.8175	5.8601	42654920.0
2018-04-12 13:00:00	NVDA	Stock	5.86	5.875	5.8005	5.8175	63241520.0
2018-04-12 14:00:00	NVDA	Stock	5.8185	5.8575	5.803	5.8498	36561720.0
2018-04-12 15:00:00	NVDA	Stock	5.8523	5.883	5.8493	5.8663	70937360.0
2018-04-12 16:00:00	NVDA	Stock	5.8658	5.8752	5.861	5.8738	31400200.0
2018-04-12 17:00:00	NVDA	Stock	5.8738	5.8863	5.8738	5.8795	538040.0
2018-04-12 18:00:00	NVDA	Stock	5.8775	5.879	5.8698	5.8725	812920.0
2018-04-12 19:00:00	NVDA	Stock	5.8703	5.8848	5.8675	5.8802	1258960.0
2018-04-12 05:00:00	AMZN	Stock	71.437	71.437	71.437	71.437	2000.0
2018-04-12 06:00:00	AMZN	Stock	71.7175	71.7175	71.7175	71.7175	3000.0
2018-04-12 07:00:00	AMZN	Stock	71.7165	72.5	71.7165	72.1125	252900.0

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

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