PREVIEW / stock_1hour / 2016-08-12

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-08-12.parquet
  size:    1.0 MB
  rows:    47,767
  symbols: 3,245

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-08-12 04:00:00	AAPL	Stock	27.03	27.0425	27.0175	27.0175	5436.0
2016-08-12 05:00:00	AAPL	Stock	27.0225	27.0225	27.0225	27.0225	400.0
2016-08-12 06:00:00	AAPL	Stock	27.025	27.025	27.025	27.025	400.0
2016-08-12 07:00:00	AAPL	Stock	27.025	27.025	27.0	27.025	10792.0
2016-08-12 08:00:00	AAPL	Stock	27.0425	27.055	27.0025	27.04	270948.0
2016-08-12 09:00:00	AAPL	Stock	27.0425	27.1	26.9425	27.055	14493420.0
2016-08-12 10:00:00	AAPL	Stock	27.0562	27.11	27.005	27.095	12127748.0
2016-08-12 11:00:00	AAPL	Stock	27.095	27.0975	26.9725	26.9925	7706420.0
2016-08-12 12:00:00	AAPL	Stock	26.993	27.03	26.985	26.9962	6900708.0
2016-08-12 13:00:00	AAPL	Stock	26.9975	27.005	26.95	26.981	6053836.0
2016-08-12 14:00:00	AAPL	Stock	26.9802	27.034	26.975	27.0305	6278932.0
2016-08-12 15:00:00	AAPL	Stock	27.03	27.0525	27.0275	27.04	11066888.0
2016-08-12 16:00:00	AAPL	Stock	27.045	27.05	27.025	27.0375	3872368.0
2016-08-12 17:00:00	AAPL	Stock	27.0375	27.0375	27.03	27.035	21996.0
2016-08-12 18:00:00	AAPL	Stock	27.0325	27.0325	27.0175	27.0175	22940.0
2016-08-12 19:00:00	AAPL	Stock	27.0275	27.03	27.015	27.0275	11940.0
2016-08-12 06:00:00	MSFT	Stock	58.16	58.16	58.16	58.16	100.0
2016-08-12 08:00:00	MSFT	Stock	58.3	58.3	58.21	58.21	1100.0
2016-08-12 09:00:00	MSFT	Stock	58.21	58.21	57.7	57.722	3151692.0
2016-08-12 10:00:00	MSFT	Stock	57.73	57.91	57.71	57.827	3130553.0
2016-08-12 11:00:00	MSFT	Stock	57.825	57.88	57.62	57.72	2553994.0
2016-08-12 12:00:00	MSFT	Stock	57.73	57.78	57.66	57.74	1785678.0
2016-08-12 13:00:00	MSFT	Stock	57.745	57.835	57.63	57.72	2111003.0
2016-08-12 14:00:00	MSFT	Stock	57.73	57.835	57.685	57.785	1910391.0
2016-08-12 15:00:00	MSFT	Stock	57.79	57.94	57.75	57.94	3932085.0
2016-08-12 16:00:00	MSFT	Stock	57.94	57.94	57.87	57.93	1672139.0
2016-08-12 17:00:00	MSFT	Stock	57.91	57.91	57.9	57.91	1779.0
2016-08-12 18:00:00	MSFT	Stock	57.92	57.93	57.92	57.93	600.0
2016-08-12 19:00:00	MSFT	Stock	57.93	57.93	57.91	57.93	1100.0
2016-08-12 05:00:00	NVDA	Stock	1.5492	1.556	1.5438	1.551	212680.0
2016-08-12 06:00:00	NVDA	Stock	1.551	1.563	1.55	1.5575	411240.0
2016-08-12 07:00:00	NVDA	Stock	1.555	1.56	1.5363	1.555	2851800.0
2016-08-12 08:00:00	NVDA	Stock	1.5505	1.5613	1.5288	1.5363	11116080.0
2016-08-12 09:00:00	NVDA	Stock	1.5373	1.5845	1.5228	1.5228	390116640.0
2016-08-12 10:00:00	NVDA	Stock	1.5228	1.5478	1.5158	1.539	280427960.0
2016-08-12 11:00:00	NVDA	Stock	1.5395	1.562	1.5385	1.556	143859880.0
2016-08-12 12:00:00	NVDA	Stock	1.5559	1.5582	1.5435	1.5455	80558600.0
2016-08-12 13:00:00	NVDA	Stock	1.5453	1.5575	1.544	1.5543	59889080.0
2016-08-12 14:00:00	NVDA	Stock	1.5545	1.575	1.5541	1.5732	116799080.0
2016-08-12 15:00:00	NVDA	Stock	1.5732	1.581	1.5725	1.5758	203969320.0
2016-08-12 16:00:00	NVDA	Stock	1.576	1.58	1.5703	1.574	44188800.0
2016-08-12 17:00:00	NVDA	Stock	1.575	1.577	1.5738	1.575	758600.0
2016-08-12 18:00:00	NVDA	Stock	1.575	1.575	1.5735	1.5745	142240.0
2016-08-12 19:00:00	NVDA	Stock	1.5745	1.5745	1.571	1.573	526880.0
2016-08-12 07:00:00	AMZN	Stock	38.5775	38.5775	38.5775	38.5775	2980.0
2016-08-12 08:00:00	AMZN	Stock	38.5855	38.586	38.52	38.52	61820.0
2016-08-12 09:00:00	AMZN	Stock	38.5195	38.5395	38.4211	38.5165	4679800.0
2016-08-12 10:00:00	AMZN	Stock	38.522	38.5515	38.4565	38.5495	3670800.0
2016-08-12 11:00:00	AMZN	Stock	38.5525	38.6075	38.5256	38.5655	2983980.0
2016-08-12 12:00:00	AMZN	Stock	38.5705	38.604	38.5209	38.58	2192840.0

> showing 50 of 47,767 rows — these rows as CSV

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