PREVIEW / stock_1hour / 2018-07-26

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-07-26.parquet
  size:    1.1 MB
  rows:    49,453
  symbols: 2,832

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-07-26 04:00:00	AAPL	Stock	48.205	48.3175	48.205	48.3125	29844.0
2018-07-26 05:00:00	AAPL	Stock	48.3	48.3125	48.2475	48.3125	37032.0
2018-07-26 06:00:00	AAPL	Stock	48.2875	48.4125	48.2875	48.375	58524.0
2018-07-26 07:00:00	AAPL	Stock	48.38	48.45	48.3625	48.4475	109364.0
2018-07-26 08:00:00	AAPL	Stock	48.39	48.6875	48.39	48.5025	630096.0
2018-07-26 09:00:00	AAPL	Stock	48.4975	48.82	48.4025	48.7975	15615200.0
2018-07-26 10:00:00	AAPL	Stock	48.8025	48.99	48.715	48.7975	12149908.0
2018-07-26 11:00:00	AAPL	Stock	48.7975	48.82	48.6415	48.735	6642884.0
2018-07-26 12:00:00	AAPL	Stock	48.7362	48.755	48.505	48.5425	6040688.0
2018-07-26 13:00:00	AAPL	Stock	48.5425	48.7475	48.5225	48.6425	4458128.0
2018-07-26 14:00:00	AAPL	Stock	48.645	48.6975	48.6125	48.6562	3697880.0
2018-07-26 15:00:00	AAPL	Stock	48.6575	48.661	48.5	48.5575	9288636.0
2018-07-26 16:00:00	AAPL	Stock	48.56	48.7225	48.3725	48.5875	8218540.0
2018-07-26 17:00:00	AAPL	Stock	48.5875	48.6825	48.5525	48.6425	423800.0
2018-07-26 18:00:00	AAPL	Stock	48.6475	48.6775	48.625	48.65	84096.0
2018-07-26 19:00:00	AAPL	Stock	48.6675	48.7	48.65	48.65	55672.0
2018-07-26 04:00:00	MSFT	Stock	110.3	110.3	110.0	110.2	2220.0
2018-07-26 05:00:00	MSFT	Stock	109.94	110.2	109.88	110.2	5067.0
2018-07-26 06:00:00	MSFT	Stock	110.2	110.2	109.95	110.0	8825.0
2018-07-26 07:00:00	MSFT	Stock	110.06	110.2	110.0	110.2	16429.0
2018-07-26 08:00:00	MSFT	Stock	110.0	110.46	109.987	110.1	56125.0
2018-07-26 09:00:00	MSFT	Stock	110.12	110.75	109.52	110.06	5348034.0
2018-07-26 10:00:00	MSFT	Stock	110.08	111.0	110.06	110.23	4481803.0
2018-07-26 11:00:00	MSFT	Stock	110.225	110.43	109.985	110.36	2893307.0
2018-07-26 12:00:00	MSFT	Stock	110.365	110.37	109.78	109.98	2742658.0
2018-07-26 13:00:00	MSFT	Stock	109.98	110.15	109.72	109.87	1802356.0
2018-07-26 14:00:00	MSFT	Stock	109.87	110.01	109.78	109.935	2091889.0
2018-07-26 15:00:00	MSFT	Stock	109.93	109.94	109.5	109.61	4125585.0
2018-07-26 16:00:00	MSFT	Stock	109.62	110.0	109.25	109.75	5442350.0
2018-07-26 17:00:00	MSFT	Stock	109.85	109.94	109.78	109.94	19418.0
2018-07-26 18:00:00	MSFT	Stock	109.91	109.98	109.87	109.87	12658.0
2018-07-26 19:00:00	MSFT	Stock	109.87	110.0	109.85	110.0	7121.0
2018-07-26 04:00:00	NVDA	Stock	6.25	6.25	6.25	6.25	20000.0
2018-07-26 05:00:00	NVDA	Stock	6.271	6.2755	6.271	6.2755	44000.0
2018-07-26 07:00:00	NVDA	Stock	6.2668	6.3225	6.2625	6.3175	415600.0
2018-07-26 08:00:00	NVDA	Stock	6.32	6.32	6.2675	6.2795	492840.0
2018-07-26 09:00:00	NVDA	Stock	6.2788	6.3656	6.2595	6.3125	53418080.0
2018-07-26 10:00:00	NVDA	Stock	6.3145	6.3435	6.3042	6.3426	38281920.0
2018-07-26 11:00:00	NVDA	Stock	6.342	6.4082	6.3358	6.3952	50565720.0
2018-07-26 12:00:00	NVDA	Stock	6.3958	6.3978	6.339	6.3543	29792280.0
2018-07-26 13:00:00	NVDA	Stock	6.3535	6.385	6.351	6.3712	18260760.0
2018-07-26 14:00:00	NVDA	Stock	6.3712	6.3768	6.356	6.36	19345080.0
2018-07-26 15:00:00	NVDA	Stock	6.361	6.3788	6.3573	6.372	50624400.0
2018-07-26 16:00:00	NVDA	Stock	6.371	6.383	6.3535	6.375	18307600.0
2018-07-26 17:00:00	NVDA	Stock	6.3775	6.4172	6.3712	6.4075	1373200.0
2018-07-26 18:00:00	NVDA	Stock	6.409	6.4192	6.4	6.41	674400.0
2018-07-26 19:00:00	NVDA	Stock	6.4062	6.4198	6.4062	6.4188	186240.0
2018-07-26 04:00:00	AMZN	Stock	91.8	91.8	91.6	91.74	79320.0
2018-07-26 05:00:00	AMZN	Stock	91.675	91.7185	91.5025	91.7185	28200.0
2018-07-26 06:00:00	AMZN	Stock	91.6	91.6225	91.565	91.5885	18460.0

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

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