PREVIEW / stock_1hour / 2016-01-06

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-01-06.parquet
  size:    1.0 MB
  rows:    49,135
  symbols: 3,400

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
2016-01-06 04:00:00	AAPL	Stock	25.56	25.56	25.1225	25.16	71872.0
2016-01-06 05:00:00	AAPL	Stock	25.1875	25.1875	24.915	24.9975	180204.0
2016-01-06 06:00:00	AAPL	Stock	24.9975	25.1075	24.955	25.06	301076.0
2016-01-06 07:00:00	AAPL	Stock	25.0625	25.1875	25.025	25.0525	705476.0
2016-01-06 08:00:00	AAPL	Stock	25.05	25.17	25.0075	25.17	1983904.0
2016-01-06 09:00:00	AAPL	Stock	25.1675	25.6902	25.055	25.3525	40752432.0
2016-01-06 10:00:00	AAPL	Stock	25.3475	25.5925	25.2475	25.3775	37166500.0
2016-01-06 11:00:00	AAPL	Stock	25.3775	25.54	25.2925	25.295	24504384.0
2016-01-06 12:00:00	AAPL	Stock	25.2962	25.329	25.089	25.0915	33226900.0
2016-01-06 13:00:00	AAPL	Stock	25.0925	25.19	25.0188	25.074	24702848.0
2016-01-06 14:00:00	AAPL	Stock	25.075	25.2342	24.99	25.025	36289840.0
2016-01-06 15:00:00	AAPL	Stock	25.0275	25.185	24.9675	25.175	45167132.0
2016-01-06 16:00:00	AAPL	Stock	25.175	25.4545	25.06	25.2	8988900.0
2016-01-06 17:00:00	AAPL	Stock	25.21	25.235	25.1925	25.22	125360.0
2016-01-06 18:00:00	AAPL	Stock	25.215	25.235	25.1875	25.2225	108584.0
2016-01-06 19:00:00	AAPL	Stock	25.215	25.2425	25.205	25.24	86480.0
2016-01-06 04:00:00	MSFT	Stock	54.9	54.9	54.9	54.9	1000.0
2016-01-06 05:00:00	MSFT	Stock	54.4	54.4	54.35	54.38	3600.0
2016-01-06 06:00:00	MSFT	Stock	54.38	54.4	54.0	54.4	4877.0
2016-01-06 07:00:00	MSFT	Stock	54.4	54.4	54.13	54.13	41628.0
2016-01-06 08:00:00	MSFT	Stock	54.2	54.35	54.01	54.24	46778.0
2016-01-06 09:00:00	MSFT	Stock	54.26	55.078	54.14	54.29	4925996.0
2016-01-06 10:00:00	MSFT	Stock	54.28	54.305	54.05	54.207	5959048.0
2016-01-06 11:00:00	MSFT	Stock	54.2	54.27	53.77	54.14	5594973.0
2016-01-06 12:00:00	MSFT	Stock	54.15	54.31	54.1	54.185	2516270.0
2016-01-06 13:00:00	MSFT	Stock	54.18	54.22	53.96	54.05	2810200.0
2016-01-06 14:00:00	MSFT	Stock	54.05	54.24	53.64	53.746	5141742.0
2016-01-06 15:00:00	MSFT	Stock	53.75	54.11	53.71	54.075	7768867.0
2016-01-06 16:00:00	MSFT	Stock	54.05	54.15	54.039	54.1	2641293.0
2016-01-06 17:00:00	MSFT	Stock	54.12	54.15	54.04	54.04	14373.0
2016-01-06 19:00:00	MSFT	Stock	54.13	54.15	54.1	54.15	5962.0
2016-01-06 08:00:00	NVDA	Stock	0.814	0.8162	0.8052	0.8115	87400.0
2016-01-06 09:00:00	NVDA	Stock	0.8115	0.8155	0.8015	0.8058	52785040.0
2016-01-06 10:00:00	NVDA	Stock	0.8058	0.8123	0.8052	0.8069	45406840.0
2016-01-06 11:00:00	NVDA	Stock	0.807	0.8095	0.8025	0.8025	41057080.0
2016-01-06 12:00:00	NVDA	Stock	0.8028	0.803	0.7948	0.795	53085640.0
2016-01-06 13:00:00	NVDA	Stock	0.7948	0.7955	0.7885	0.7895	39321160.0
2016-01-06 14:00:00	NVDA	Stock	0.7892	0.792	0.779	0.7815	57858720.0
2016-01-06 15:00:00	NVDA	Stock	0.7815	0.7898	0.7798	0.7883	100928600.0
2016-01-06 16:00:00	NVDA	Stock	0.7883	0.7949	0.788	0.7912	14785600.0
2016-01-06 18:00:00	NVDA	Stock	0.7898	0.7898	0.7898	0.7898	80000.0
2016-01-06 19:00:00	NVDA	Stock	0.7912	0.7912	0.7895	0.7895	49600.0
2016-01-06 07:00:00	AMZN	Stock	31.1885	31.275	31.1	31.1	157740.0
2016-01-06 08:00:00	AMZN	Stock	31.0985	31.25	30.932	31.041	695540.0
2016-01-06 09:00:00	AMZN	Stock	31.0375	31.88	30.957	31.8525	20542700.0
2016-01-06 10:00:00	AMZN	Stock	31.844	31.9895	31.6125	31.8627	14411240.0
2016-01-06 11:00:00	AMZN	Stock	31.87	31.925	31.6505	31.738	8138400.0
2016-01-06 12:00:00	AMZN	Stock	31.744	31.779	31.477	31.5065	7878940.0
2016-01-06 13:00:00	AMZN	Stock	31.5081	31.6205	31.3225	31.443	8934500.0
2016-01-06 14:00:00	AMZN	Stock	31.4525	31.55	31.209	31.2272	10329480.0

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

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