PREVIEW / stock_1hour / 2017-08-11

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-08-11.parquet
  size:    1.0 MB
  rows:    48,000
  symbols: 2,971

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-08-11 04:00:00	AAPL	Stock	38.7375	38.75	38.5525	38.5775	35448.0
2017-08-11 05:00:00	AAPL	Stock	38.5875	38.7475	38.5625	38.5875	70468.0
2017-08-11 06:00:00	AAPL	Stock	38.6075	38.7325	38.565	38.685	42876.0
2017-08-11 07:00:00	AAPL	Stock	38.675	38.7225	38.625	38.675	124980.0
2017-08-11 08:00:00	AAPL	Stock	38.6875	39.0375	38.6375	39.0225	595528.0
2017-08-11 09:00:00	AAPL	Stock	39.02	39.495	39.0175	39.4575	23197292.0
2017-08-11 10:00:00	AAPL	Stock	39.4562	39.6432	39.2625	39.365	19174064.0
2017-08-11 11:00:00	AAPL	Stock	39.361	39.4675	39.28	39.4075	9176016.0
2017-08-11 12:00:00	AAPL	Stock	39.405	39.5125	39.355	39.4525	6246860.0
2017-08-11 13:00:00	AAPL	Stock	39.455	39.5075	39.38	39.4775	6422712.0
2017-08-11 14:00:00	AAPL	Stock	39.4775	39.5775	39.29	39.3125	9974820.0
2017-08-11 15:00:00	AAPL	Stock	39.3125	39.4	39.2175	39.3725	15792620.0
2017-08-11 16:00:00	AAPL	Stock	39.37	39.38	39.3	39.3225	3928612.0
2017-08-11 17:00:00	AAPL	Stock	39.325	39.3575	39.3175	39.3525	56660.0
2017-08-11 18:00:00	AAPL	Stock	39.345	39.355	39.34	39.35	20300.0
2017-08-11 19:00:00	AAPL	Stock	39.3525	39.355	39.3275	39.355	46836.0
2017-08-11 04:00:00	MSFT	Stock	71.3	71.3	71.26	71.26	725.0
2017-08-11 05:00:00	MSFT	Stock	71.0	71.28	71.0	71.28	16083.0
2017-08-11 06:00:00	MSFT	Stock	71.28	71.3	71.2	71.2	2986.0
2017-08-11 07:00:00	MSFT	Stock	71.25	71.25	71.11	71.23	4246.0
2017-08-11 08:00:00	MSFT	Stock	71.18	72.0	71.18	71.53	36451.0
2017-08-11 09:00:00	MSFT	Stock	71.55	71.84	71.28	71.714	2765839.0
2017-08-11 10:00:00	MSFT	Stock	71.71	72.0	71.61	71.92	2094667.0
2017-08-11 11:00:00	MSFT	Stock	71.92	72.145	71.8	72.04	2085815.0
2017-08-11 12:00:00	MSFT	Stock	72.04	72.44	72.0	72.4	2135014.0
2017-08-11 13:00:00	MSFT	Stock	72.4	72.57	72.37	72.555	1904356.0
2017-08-11 14:00:00	MSFT	Stock	72.555	72.7	72.43	72.46	2443741.0
2017-08-11 15:00:00	MSFT	Stock	72.46	72.68	72.4	72.51	4402516.0
2017-08-11 16:00:00	MSFT	Stock	72.5	72.52	72.47	72.49	2149206.0
2017-08-11 17:00:00	MSFT	Stock	72.5	72.5	72.5	72.5	2300.0
2017-08-11 18:00:00	MSFT	Stock	72.46	72.5	72.46	72.5	752.0
2017-08-11 19:00:00	MSFT	Stock	72.5	72.5	72.5	72.5	1000.0
2017-08-11 04:00:00	NVDA	Stock	3.925	3.925	3.8275	3.8375	468480.0
2017-08-11 05:00:00	NVDA	Stock	3.825	3.8252	3.8002	3.8075	428920.0
2017-08-11 06:00:00	NVDA	Stock	3.8078	3.8238	3.785	3.805	919280.0
2017-08-11 07:00:00	NVDA	Stock	3.807	3.8575	3.7852	3.7932	4966360.0
2017-08-11 08:00:00	NVDA	Stock	3.7968	3.8688	3.755	3.8438	31501800.0
2017-08-11 09:00:00	NVDA	Stock	3.8438	3.975	3.8413	3.8865	418956320.0
2017-08-11 10:00:00	NVDA	Stock	3.884	3.96	3.8755	3.8805	276860360.0
2017-08-11 11:00:00	NVDA	Stock	3.88	3.8862	3.8228	3.8308	209866640.0
2017-08-11 12:00:00	NVDA	Stock	3.8306	3.8945	3.8288	3.8775	132685840.0
2017-08-11 13:00:00	NVDA	Stock	3.8765	3.8992	3.8592	3.875	98807520.0
2017-08-11 14:00:00	NVDA	Stock	3.8754	3.8962	3.8615	3.8671	79310080.0
2017-08-11 15:00:00	NVDA	Stock	3.867	3.9	3.8475	3.8962	158488400.0
2017-08-11 16:00:00	NVDA	Stock	3.899	3.9053	3.8958	3.903	11984360.0
2017-08-11 17:00:00	NVDA	Stock	3.9058	3.9058	3.902	3.902	604400.0
2017-08-11 18:00:00	NVDA	Stock	3.9025	3.9068	3.9	3.9068	661280.0
2017-08-11 19:00:00	NVDA	Stock	3.9038	3.9072	3.9025	3.9025	633680.0
2017-08-11 04:00:00	AMZN	Stock	47.605	47.605	47.363	47.41	10520.0
2017-08-11 05:00:00	AMZN	Stock	47.41	47.565	47.35	47.565	26160.0

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

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