PREVIEW / stock_1hour / 2016-01-19

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-01-19.parquet
  size:    1.1 MB
  rows:    50,432
  symbols: 3,404

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-19 04:00:00	AAPL	Stock	24.47	24.7475	24.47	24.71	28452.0
2016-01-19 05:00:00	AAPL	Stock	24.75	24.7775	24.6875	24.775	35796.0
2016-01-19 06:00:00	AAPL	Stock	24.78	24.8125	24.7575	24.7575	127960.0
2016-01-19 07:00:00	AAPL	Stock	24.715	24.7375	24.57	24.575	309396.0
2016-01-19 08:00:00	AAPL	Stock	24.575	24.78	24.5525	24.6975	625984.0
2016-01-19 09:00:00	AAPL	Stock	24.675	24.695	24.4125	24.47	25687176.0
2016-01-19 10:00:00	AAPL	Stock	24.47	24.525	24.2225	24.2512	29237100.0
2016-01-19 11:00:00	AAPL	Stock	24.2505	24.295	24.0575	24.1175	25236660.0
2016-01-19 12:00:00	AAPL	Stock	24.1162	24.2125	24.0425	24.1475	18565172.0
2016-01-19 13:00:00	AAPL	Stock	24.1475	24.2175	24.0475	24.0675	16115544.0
2016-01-19 14:00:00	AAPL	Stock	24.0675	24.0825	23.875	23.9775	25837516.0
2016-01-19 15:00:00	AAPL	Stock	23.975	24.25	23.9475	24.17	33648708.0
2016-01-19 16:00:00	AAPL	Stock	24.165	24.2242	24.1275	24.15	9180860.0
2016-01-19 17:00:00	AAPL	Stock	24.15	24.165	24.085	24.085	351276.0
2016-01-19 18:00:00	AAPL	Stock	24.0975	24.1875	24.0975	24.15	89736.0
2016-01-19 19:00:00	AAPL	Stock	24.15	24.15	24.0775	24.125	62212.0
2016-01-19 04:00:00	MSFT	Stock	51.6	51.6	51.6	51.6	2100.0
2016-01-19 05:00:00	MSFT	Stock	51.62	51.9	51.62	51.88	2460.0
2016-01-19 06:00:00	MSFT	Stock	51.9	51.9	51.83	51.9	6600.0
2016-01-19 07:00:00	MSFT	Stock	51.85	51.96	51.7	51.79	20733.0
2016-01-19 08:00:00	MSFT	Stock	51.84	51.9	50.99	51.76	136533.0
2016-01-19 09:00:00	MSFT	Stock	51.76	51.76	51.005	51.17	5455468.0
2016-01-19 10:00:00	MSFT	Stock	51.18	51.33	50.67	50.71	5840781.0
2016-01-19 11:00:00	MSFT	Stock	50.705	50.93	50.555	50.88	5380044.0
2016-01-19 12:00:00	MSFT	Stock	50.87	50.91	50.43	50.534	4036061.0
2016-01-19 13:00:00	MSFT	Stock	50.54	50.64	50.42	50.5	3439906.0
2016-01-19 14:00:00	MSFT	Stock	50.5	50.55	50.06	50.21	4751749.0
2016-01-19 15:00:00	MSFT	Stock	50.21	50.9	50.13	50.56	8631681.0
2016-01-19 16:00:00	MSFT	Stock	50.56	50.729	50.43	50.56	3576511.0
2016-01-19 17:00:00	MSFT	Stock	50.49	50.49	50.46	50.46	2200.0
2016-01-19 18:00:00	MSFT	Stock	50.46	50.5	50.46	50.5	12151.0
2016-01-19 19:00:00	MSFT	Stock	50.5	50.5	50.25	50.25	10412.0
2016-01-19 04:00:00	NVDA	Stock	0.678	0.678	0.678	0.678	11360.0
2016-01-19 07:00:00	NVDA	Stock	0.6888	0.6888	0.6888	0.6888	8000.0
2016-01-19 08:00:00	NVDA	Stock	0.7038	0.7038	0.6875	0.696	196120.0
2016-01-19 09:00:00	NVDA	Stock	0.694	0.7113	0.6918	0.6942	89418200.0
2016-01-19 10:00:00	NVDA	Stock	0.6945	0.7058	0.694	0.6966	64734000.0
2016-01-19 11:00:00	NVDA	Stock	0.6965	0.6978	0.689	0.6892	42710640.0
2016-01-19 12:00:00	NVDA	Stock	0.6892	0.6936	0.6862	0.6899	35608400.0
2016-01-19 13:00:00	NVDA	Stock	0.69	0.6926	0.687	0.688	28460080.0
2016-01-19 14:00:00	NVDA	Stock	0.6879	0.688	0.6808	0.6839	58036760.0
2016-01-19 15:00:00	NVDA	Stock	0.6839	0.6882	0.6804	0.6832	91240320.0
2016-01-19 16:00:00	NVDA	Stock	0.6832	0.6962	0.6828	0.6838	27556200.0
2016-01-19 17:00:00	NVDA	Stock	0.6838	0.6838	0.6838	0.6838	44000.0
2016-01-19 19:00:00	NVDA	Stock	0.6778	0.6778	0.6778	0.6778	3372000.0
2016-01-19 05:00:00	AMZN	Stock	29.0495	29.05	29.0495	29.05	16000.0
2016-01-19 06:00:00	AMZN	Stock	28.9865	29.09	28.9865	29.05	40720.0
2016-01-19 07:00:00	AMZN	Stock	29.1	29.1	28.95	28.95	166680.0
2016-01-19 08:00:00	AMZN	Stock	28.938	29.0975	28.875	28.95	297360.0
2016-01-19 09:00:00	AMZN	Stock	28.9325	29.2	28.8165	28.9464	15107680.0

> showing 50 of 50,432 rows — these rows as CSV

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