PREVIEW / stock_1hour / 2017-10-26

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-10-26.parquet
  size:    1.1 MB
  rows:    48,645
  symbols: 2,940

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-10-26 04:00:00	AAPL	Stock	39.155	39.155	39.155	39.155	800.0
2017-10-26 05:00:00	AAPL	Stock	39.175	39.175	39.175	39.175	400.0
2017-10-26 06:00:00	AAPL	Stock	39.245	39.25	39.185	39.185	20732.0
2017-10-26 07:00:00	AAPL	Stock	39.185	39.2975	39.185	39.2525	103388.0
2017-10-26 08:00:00	AAPL	Stock	39.25	39.3225	39.235	39.25	293888.0
2017-10-26 09:00:00	AAPL	Stock	39.2675	39.4575	39.2025	39.315	10566076.0
2017-10-26 10:00:00	AAPL	Stock	39.315	39.4325	39.195	39.3852	9753200.0
2017-10-26 11:00:00	AAPL	Stock	39.385	39.425	39.3198	39.374	5907460.0
2017-10-26 12:00:00	AAPL	Stock	39.3725	39.4225	39.3125	39.3425	3579588.0
2017-10-26 13:00:00	AAPL	Stock	39.3448	39.37	39.2725	39.35	3662784.0
2017-10-26 14:00:00	AAPL	Stock	39.35	39.4375	39.325	39.4175	5123400.0
2017-10-26 15:00:00	AAPL	Stock	39.4175	39.43	39.3475	39.355	11101240.0
2017-10-26 16:00:00	AAPL	Stock	39.3525	39.45	39.3025	39.435	11774804.0
2017-10-26 17:00:00	AAPL	Stock	39.435	39.465	39.3525	39.465	157672.0
2017-10-26 18:00:00	AAPL	Stock	39.4625	39.4875	39.4625	39.47	112960.0
2017-10-26 19:00:00	AAPL	Stock	39.47	39.4875	39.425	39.4825	122932.0
2017-10-26 04:00:00	MSFT	Stock	78.85	79.03	78.85	79.03	427.0
2017-10-26 06:00:00	MSFT	Stock	78.9	78.9	78.9	78.9	100.0
2017-10-26 07:00:00	MSFT	Stock	78.9	78.95	78.89	78.95	6371.0
2017-10-26 08:00:00	MSFT	Stock	78.95	79.1	78.84	78.88	80726.0
2017-10-26 09:00:00	MSFT	Stock	78.93	79.42	78.85	79.12	3829634.0
2017-10-26 10:00:00	MSFT	Stock	79.115	79.27	78.85	79.19	3738599.0
2017-10-26 11:00:00	MSFT	Stock	79.195	79.23	78.95	79.02	2439261.0
2017-10-26 12:00:00	MSFT	Stock	79.026	79.25	79.025	79.12	2039804.0
2017-10-26 13:00:00	MSFT	Stock	79.12	79.27	79.04	79.125	1691870.0
2017-10-26 14:00:00	MSFT	Stock	79.125	79.25	79.06	79.07	2701951.0
2017-10-26 15:00:00	MSFT	Stock	79.07	79.15	78.75	78.75	6466286.0
2017-10-26 16:00:00	MSFT	Stock	78.75	82.18	78.0	81.62	5472746.0
2017-10-26 17:00:00	MSFT	Stock	81.65	82.15	81.07	81.25	447759.0
2017-10-26 18:00:00	MSFT	Stock	81.29	82.41	81.25	82.2	388682.0
2017-10-26 19:00:00	MSFT	Stock	82.22	82.35	82.02	82.34	53345.0
2017-10-26 04:00:00	NVDA	Stock	4.865	4.87	4.865	4.87	46400.0
2017-10-26 05:00:00	NVDA	Stock	4.8675	4.87	4.8675	4.87	12000.0
2017-10-26 06:00:00	NVDA	Stock	4.8578	4.8682	4.8575	4.8682	55880.0
2017-10-26 07:00:00	NVDA	Stock	4.8588	4.8748	4.8553	4.861	702640.0
2017-10-26 08:00:00	NVDA	Stock	4.8623	4.8715	4.8562	4.8688	1507080.0
2017-10-26 09:00:00	NVDA	Stock	4.865	4.899	4.8452	4.886	62756320.0
2017-10-26 10:00:00	NVDA	Stock	4.883	4.904	4.8474	4.8855	76345760.0
2017-10-26 11:00:00	NVDA	Stock	4.8852	4.8925	4.862	4.8718	32125920.0
2017-10-26 12:00:00	NVDA	Stock	4.8711	4.8898	4.8703	4.8848	22800760.0
2017-10-26 13:00:00	NVDA	Stock	4.8854	4.8948	4.878	4.8865	18444800.0
2017-10-26 14:00:00	NVDA	Stock	4.8868	4.897	4.882	4.8964	19398800.0
2017-10-26 15:00:00	NVDA	Stock	4.895	4.8988	4.8845	4.8898	37893280.0
2017-10-26 16:00:00	NVDA	Stock	4.8923	4.9175	4.8808	4.895	16259400.0
2017-10-26 17:00:00	NVDA	Stock	4.912	4.912	4.9038	4.91	496400.0
2017-10-26 18:00:00	NVDA	Stock	4.9108	4.9163	4.91	4.9125	690160.0
2017-10-26 19:00:00	NVDA	Stock	4.9168	4.9325	4.9168	4.9288	1048000.0
2017-10-26 07:00:00	AMZN	Stock	48.92	48.945	48.9125	48.9125	38580.0
2017-10-26 08:00:00	AMZN	Stock	48.925	49.02	48.9125	48.9665	259680.0
2017-10-26 09:00:00	AMZN	Stock	48.951	49.145	48.55	48.635	10084380.0

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

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