PREVIEW / stock_1hour / 2017-03-02

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-03-02.parquet
  size:    1.1 MB
  rows:    48,373
  symbols: 3,093

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-03-02 04:00:00	AAPL	Stock	35.0	35.0	34.89	34.89	4928.0
2017-03-02 05:00:00	AAPL	Stock	34.8875	34.975	34.8875	34.95	5252.0
2017-03-02 06:00:00	AAPL	Stock	34.92	34.9575	34.9075	34.95	19304.0
2017-03-02 07:00:00	AAPL	Stock	34.9575	34.9975	34.955	34.9875	36392.0
2017-03-02 08:00:00	AAPL	Stock	34.9875	35.02	34.95	35.0	400624.0
2017-03-02 09:00:00	AAPL	Stock	35.0025	35.0698	34.9075	34.97	18024388.0
2017-03-02 10:00:00	AAPL	Stock	34.97	34.975	34.9025	34.925	10581664.0
2017-03-02 11:00:00	AAPL	Stock	34.92	34.925	34.8075	34.9	12650888.0
2017-03-02 12:00:00	AAPL	Stock	34.9	34.9325	34.835	34.905	7553704.0
2017-03-02 13:00:00	AAPL	Stock	34.903	34.9075	34.7118	34.7638	13586536.0
2017-03-02 14:00:00	AAPL	Stock	34.765	34.815	34.7525	34.785	6920004.0
2017-03-02 15:00:00	AAPL	Stock	34.785	34.7925	34.69	34.7325	16642184.0
2017-03-02 16:00:00	AAPL	Stock	34.74	34.775	34.6525	34.7525	9727804.0
2017-03-02 17:00:00	AAPL	Stock	34.75	34.7675	34.75	34.76	21536.0
2017-03-02 18:00:00	AAPL	Stock	34.7525	34.77	34.745	34.75	40928.0
2017-03-02 19:00:00	AAPL	Stock	34.745	34.775	34.7425	34.75	13904.0
2017-03-02 06:00:00	MSFT	Stock	64.93	64.93	64.93	64.93	150.0
2017-03-02 08:00:00	MSFT	Stock	64.8	64.9	64.75	64.86	1112.0
2017-03-02 09:00:00	MSFT	Stock	64.77	64.79	64.17	64.245	2957979.0
2017-03-02 10:00:00	MSFT	Stock	64.245	64.246	64.02	64.15	3662745.0
2017-03-02 11:00:00	MSFT	Stock	64.15	64.2	63.99	64.132	2721598.0
2017-03-02 12:00:00	MSFT	Stock	64.13	64.14	63.96	63.98	1958402.0
2017-03-02 13:00:00	MSFT	Stock	63.98	64.02	63.88	64.005	2171915.0
2017-03-02 14:00:00	MSFT	Stock	64.01	64.15	64.0	64.08	2251789.0
2017-03-02 15:00:00	MSFT	Stock	64.085	64.09	63.9	64.0	5178492.0
2017-03-02 16:00:00	MSFT	Stock	64.01	64.01	63.9	63.9	2425625.0
2017-03-02 17:00:00	MSFT	Stock	63.94	63.94	63.94	63.94	950.0
2017-03-02 18:00:00	MSFT	Stock	63.93	63.98	63.91	63.94	3118.0
2017-03-02 19:00:00	MSFT	Stock	63.99	63.99	63.91	63.91	1906.0
2017-03-02 07:00:00	NVDA	Stock	2.566	2.5662	2.5595	2.5595	52440.0
2017-03-02 08:00:00	NVDA	Stock	2.555	2.5675	2.5545	2.5662	396600.0
2017-03-02 09:00:00	NVDA	Stock	2.56	2.57	2.5405	2.5683	55539040.0
2017-03-02 10:00:00	NVDA	Stock	2.568	2.571	2.513	2.523	124749000.0
2017-03-02 11:00:00	NVDA	Stock	2.5238	2.5268	2.5028	2.5178	83830040.0
2017-03-02 12:00:00	NVDA	Stock	2.518	2.5238	2.5015	2.5085	98388880.0
2017-03-02 13:00:00	NVDA	Stock	2.509	2.518	2.4962	2.5005	77933400.0
2017-03-02 14:00:00	NVDA	Stock	2.5008	2.502	2.4723	2.4933	125564880.0
2017-03-02 15:00:00	NVDA	Stock	2.4925	2.5035	2.4725	2.475	141824640.0
2017-03-02 16:00:00	NVDA	Stock	2.4745	2.5075	2.4688	2.4738	5108200.0
2017-03-02 17:00:00	NVDA	Stock	2.4728	2.4763	2.4725	2.4763	593440.0
2017-03-02 18:00:00	NVDA	Stock	2.475	2.4763	2.475	2.475	157040.0
2017-03-02 19:00:00	NVDA	Stock	2.475	2.4763	2.4742	2.4763	197080.0
2017-03-02 04:00:00	AMZN	Stock	42.6705	42.6705	42.6705	42.6705	2000.0
2017-03-02 07:00:00	AMZN	Stock	42.6975	42.7	42.6975	42.7	23000.0
2017-03-02 08:00:00	AMZN	Stock	42.6975	42.747	42.675	42.7295	62400.0
2017-03-02 09:00:00	AMZN	Stock	42.725	42.741	42.537	42.6935	6258300.0
2017-03-02 10:00:00	AMZN	Stock	42.6785	42.6865	42.4875	42.5443	5899380.0
2017-03-02 11:00:00	AMZN	Stock	42.54	42.5495	42.419	42.5275	4361040.0
2017-03-02 12:00:00	AMZN	Stock	42.5254	42.5595	42.4135	42.4925	2805380.0
2017-03-02 13:00:00	AMZN	Stock	42.49	42.496	42.441	42.441	1857240.0

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

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