PREVIEW / stock_1hour / 2016-02-01

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-02-01.parquet
  size:    1.0 MB
  rows:    48,613
  symbols: 3,372

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-02-01 04:00:00	AAPL	Stock	24.275	24.275	24.1375	24.1375	8268.0
2016-02-01 05:00:00	AAPL	Stock	24.1375	24.19	24.135	24.1875	8720.0
2016-02-01 06:00:00	AAPL	Stock	24.1875	24.205	24.15	24.15	16400.0
2016-02-01 07:00:00	AAPL	Stock	24.15	24.15	24.0325	24.075	63616.0
2016-02-01 08:00:00	AAPL	Stock	24.075	24.335	24.0525	24.1375	581772.0
2016-02-01 09:00:00	AAPL	Stock	24.335	24.335	23.965	24.015	21748144.0
2016-02-01 10:00:00	AAPL	Stock	24.0125	24.11	23.85	24.0962	27616052.0
2016-02-01 11:00:00	AAPL	Stock	24.095	24.1675	23.9975	24.1025	21825960.0
2016-02-01 12:00:00	AAPL	Stock	24.1075	24.1262	23.9562	23.98	14070056.0
2016-02-01 13:00:00	AAPL	Stock	23.9825	24.0625	23.9375	24.0535	15040880.0
2016-02-01 14:00:00	AAPL	Stock	24.0535	24.1325	24.0158	24.1175	15086264.0
2016-02-01 15:00:00	AAPL	Stock	24.115	24.1775	24.0625	24.095	23355616.0
2016-02-01 16:00:00	AAPL	Stock	24.1075	24.335	24.075	24.09	11409536.0
2016-02-01 17:00:00	AAPL	Stock	24.0975	24.1	24.07	24.07	37308.0
2016-02-01 18:00:00	AAPL	Stock	24.075	24.075	24.015	24.05	55052.0
2016-02-01 19:00:00	AAPL	Stock	24.0575	24.07	24.045	24.0625	27680.0
2016-02-01 04:00:00	MSFT	Stock	54.9	54.9	54.9	54.9	600.0
2016-02-01 05:00:00	MSFT	Stock	54.77	54.77	54.77	54.77	400.0
2016-02-01 06:00:00	MSFT	Stock	54.77	54.87	54.7	54.77	1800.0
2016-02-01 07:00:00	MSFT	Stock	54.71	54.72	54.46	54.46	6601.0
2016-02-01 08:00:00	MSFT	Stock	54.55	55.09	54.49	54.58	39387.0
2016-02-01 09:00:00	MSFT	Stock	55.09	55.09	54.585	54.692	5054692.0
2016-02-01 10:00:00	MSFT	Stock	54.7	55.08	54.5	54.95	6017907.0
2016-02-01 11:00:00	MSFT	Stock	54.95	55.01	54.71	54.76	4008250.0
2016-02-01 12:00:00	MSFT	Stock	54.77	54.835	54.59	54.697	3337186.0
2016-02-01 13:00:00	MSFT	Stock	54.695	54.83	54.6	54.735	3561487.0
2016-02-01 14:00:00	MSFT	Stock	54.73	54.86	54.495	54.85	5559654.0
2016-02-01 15:00:00	MSFT	Stock	54.855	55.05	54.64	54.67	10189212.0
2016-02-01 16:00:00	MSFT	Stock	54.71	54.83	54.6	54.65	3581657.0
2016-02-01 17:00:00	MSFT	Stock	54.7	54.71	54.65	54.7	7100.0
2016-02-01 18:00:00	MSFT	Stock	54.65	54.65	54.55	54.55	7390.0
2016-02-01 19:00:00	MSFT	Stock	54.6	54.6	54.55	54.55	904.0
2016-02-01 08:00:00	NVDA	Stock	0.7308	0.74	0.725	0.725	208360.0
2016-02-01 09:00:00	NVDA	Stock	0.7275	0.74	0.7253	0.7268	34299160.0
2016-02-01 10:00:00	NVDA	Stock	0.7272	0.7363	0.7255	0.7345	38825480.0
2016-02-01 11:00:00	NVDA	Stock	0.7345	0.7363	0.7313	0.7318	32033000.0
2016-02-01 12:00:00	NVDA	Stock	0.7318	0.7332	0.7273	0.7286	26033200.0
2016-02-01 13:00:00	NVDA	Stock	0.7285	0.7313	0.7258	0.7273	27745680.0
2016-02-01 14:00:00	NVDA	Stock	0.7273	0.7328	0.7253	0.7325	39583120.0
2016-02-01 15:00:00	NVDA	Stock	0.7323	0.7355	0.7308	0.7323	51356840.0
2016-02-01 16:00:00	NVDA	Stock	0.7325	0.7325	0.7309	0.7325	1624720.0
2016-02-01 17:00:00	NVDA	Stock	0.731	0.731	0.731	0.731	4560.0
2016-02-01 18:00:00	NVDA	Stock	0.7313	0.7313	0.7313	0.7313	8000.0
2016-02-01 04:00:00	AMZN	Stock	29.3	29.3	29.3	29.3	2200.0
2016-02-01 05:00:00	AMZN	Stock	29.15	29.15	29.15	29.15	6600.0
2016-02-01 07:00:00	AMZN	Stock	29.1245	29.1745	29.002	29.0135	228000.0
2016-02-01 08:00:00	AMZN	Stock	29.003	29.1	28.8015	28.833	1061240.0
2016-02-01 09:00:00	AMZN	Stock	28.8325	29.09	28.5155	28.9465	31594100.0
2016-02-01 10:00:00	AMZN	Stock	28.946	28.9745	28.75	28.9108	16669260.0
2016-02-01 11:00:00	AMZN	Stock	28.913	28.9865	28.75	28.8806	10135940.0

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

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