PREVIEW / stock_1hour / 2016-02-02

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-02-02.parquet
  size:    1.0 MB
  rows:    48,476
  symbols: 3,366

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-02 04:00:00	AAPL	Stock	23.9675	23.9675	23.8025	23.835	6472.0
2016-02-02 05:00:00	AAPL	Stock	23.8775	23.8775	23.8175	23.8175	1320.0
2016-02-02 06:00:00	AAPL	Stock	23.8125	23.9125	23.7775	23.91	38420.0
2016-02-02 07:00:00	AAPL	Stock	23.8375	23.8825	23.8125	23.835	50272.0
2016-02-02 08:00:00	AAPL	Stock	23.84	24.1075	23.805	23.85	480676.0
2016-02-02 09:00:00	AAPL	Stock	23.835	24.01	23.7625	23.8225	18660364.0
2016-02-02 10:00:00	AAPL	Stock	23.8225	23.925	23.76	23.8625	19277316.0
2016-02-02 11:00:00	AAPL	Stock	23.865	23.9725	23.8263	23.8325	16541520.0
2016-02-02 12:00:00	AAPL	Stock	23.8345	23.8725	23.78	23.8288	13846532.0
2016-02-02 13:00:00	AAPL	Stock	23.8275	23.85	23.7275	23.7325	14097556.0
2016-02-02 14:00:00	AAPL	Stock	23.733	23.7722	23.57	23.575	17854824.0
2016-02-02 15:00:00	AAPL	Stock	23.574	23.7275	23.57	23.62	25469260.0
2016-02-02 16:00:00	AAPL	Stock	23.62	23.7125	23.6025	23.6775	8681792.0
2016-02-02 17:00:00	AAPL	Stock	23.68	23.695	23.6575	23.695	87888.0
2016-02-02 18:00:00	AAPL	Stock	23.675	23.695	23.675	23.675	49176.0
2016-02-02 19:00:00	AAPL	Stock	23.675	23.7	23.665	23.6925	66600.0
2016-02-02 04:00:00	MSFT	Stock	54.35	54.35	53.9	53.99	4511.0
2016-02-02 06:00:00	MSFT	Stock	54.03	54.03	53.99	53.99	7280.0
2016-02-02 07:00:00	MSFT	Stock	54.24	54.26	54.14	54.25	37041.0
2016-02-02 08:00:00	MSFT	Stock	54.28	54.3	54.02	54.05	40849.0
2016-02-02 09:00:00	MSFT	Stock	54.02	54.26	53.66	53.775	7217087.0
2016-02-02 10:00:00	MSFT	Stock	53.77	53.88	53.46	53.63	7984885.0
2016-02-02 11:00:00	MSFT	Stock	53.63	54.0	53.6	53.72	6317322.0
2016-02-02 12:00:00	MSFT	Stock	53.725	53.77	53.49	53.65	5024315.0
2016-02-02 13:00:00	MSFT	Stock	53.65	53.66	53.2	53.2	5542854.0
2016-02-02 14:00:00	MSFT	Stock	53.21	53.295	52.72	52.72	5913145.0
2016-02-02 15:00:00	MSFT	Stock	52.725	53.09	52.65	53.0	10318740.0
2016-02-02 16:00:00	MSFT	Stock	53.0	53.944	52.8	52.9	2953235.0
2016-02-02 17:00:00	MSFT	Stock	53.0	53.0	52.84	52.88	14046.0
2016-02-02 18:00:00	MSFT	Stock	52.88	52.9	52.82	52.88	8560.0
2016-02-02 19:00:00	MSFT	Stock	52.88	52.9	52.84	52.9	10300.0
2016-02-02 08:00:00	NVDA	Stock	0.7253	0.7253	0.7253	0.7253	9000.0
2016-02-02 09:00:00	NVDA	Stock	0.725	0.7288	0.7143	0.7161	24969520.0
2016-02-02 10:00:00	NVDA	Stock	0.716	0.7205	0.7159	0.716	24040840.0
2016-02-02 11:00:00	NVDA	Stock	0.7163	0.7183	0.713	0.7145	28523840.0
2016-02-02 12:00:00	NVDA	Stock	0.7145	0.7158	0.7105	0.7138	36737800.0
2016-02-02 13:00:00	NVDA	Stock	0.7135	0.7135	0.703	0.7031	35552040.0
2016-02-02 14:00:00	NVDA	Stock	0.703	0.7038	0.6988	0.6988	48428600.0
2016-02-02 15:00:00	NVDA	Stock	0.6988	0.702	0.6965	0.7015	107225520.0
2016-02-02 16:00:00	NVDA	Stock	0.7015	0.7071	0.7	0.7	1542240.0
2016-02-02 17:00:00	NVDA	Stock	0.7005	0.7005	0.7005	0.7005	16000.0
2016-02-02 04:00:00	AMZN	Stock	28.505	28.505	28.5	28.5	4000.0
2016-02-02 05:00:00	AMZN	Stock	28.499	28.499	28.499	28.499	2000.0
2016-02-02 06:00:00	AMZN	Stock	28.351	28.4885	28.351	28.4885	4000.0
2016-02-02 07:00:00	AMZN	Stock	28.5	28.532	28.4285	28.4285	121860.0
2016-02-02 08:00:00	AMZN	Stock	28.5125	28.535	28.4015	28.4105	228500.0
2016-02-02 09:00:00	AMZN	Stock	28.406	28.578	27.9195	28.406	19299340.0
2016-02-02 10:00:00	AMZN	Stock	28.406	28.495	27.9895	28.0757	14594760.0
2016-02-02 11:00:00	AMZN	Stock	28.0725	28.113	27.9375	28.0265	10343540.0
2016-02-02 12:00:00	AMZN	Stock	28.024	28.0575	27.8915	27.9422	9254160.0

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

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