PREVIEW / stock_1hour / 2015-11-04

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-11-04.parquet
  size:    1.0 MB
  rows:    48,478
  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
2015-11-04 04:00:00	AAPL	Stock	30.675	30.75	30.675	30.75	8700.0
2015-11-04 05:00:00	AAPL	Stock	30.7475	30.75	30.725	30.75	4804.0
2015-11-04 06:00:00	AAPL	Stock	30.7675	30.7875	30.725	30.7775	34060.0
2015-11-04 07:00:00	AAPL	Stock	30.7725	30.785	30.75	30.7675	190296.0
2015-11-04 08:00:00	AAPL	Stock	30.7675	30.8425	30.575	30.83	993220.0
2015-11-04 09:00:00	AAPL	Stock	30.825	30.955	30.725	30.8125	28789700.0
2015-11-04 10:00:00	AAPL	Stock	30.8125	30.8425	30.49	30.525	34042264.0
2015-11-04 11:00:00	AAPL	Stock	30.5275	30.693	30.4425	30.605	24315532.0
2015-11-04 12:00:00	AAPL	Stock	30.6025	30.7075	30.5075	30.56	13036320.0
2015-11-04 13:00:00	AAPL	Stock	30.5625	30.575	30.47	30.555	15213252.0
2015-11-04 14:00:00	AAPL	Stock	30.5532	30.6375	30.5325	30.5475	15520800.0
2015-11-04 15:00:00	AAPL	Stock	30.5475	30.5725	30.405	30.5025	23657588.0
2015-11-04 16:00:00	AAPL	Stock	30.5	30.6672	30.455	30.4875	9075880.0
2015-11-04 17:00:00	AAPL	Stock	30.4875	30.545	30.4875	30.545	1662632.0
2015-11-04 18:00:00	AAPL	Stock	30.5375	30.5475	30.52	30.5475	39284.0
2015-11-04 19:00:00	AAPL	Stock	30.54	30.5625	30.525	30.5625	125436.0
2015-11-04 04:00:00	MSFT	Stock	54.23	54.23	54.23	54.23	100.0
2015-11-04 06:00:00	MSFT	Stock	54.15	54.15	54.15	54.15	100.0
2015-11-04 07:00:00	MSFT	Stock	54.19	54.21	54.14	54.2	2488.0
2015-11-04 08:00:00	MSFT	Stock	54.2	54.3	54.2	54.26	26892.0
2015-11-04 09:00:00	MSFT	Stock	54.29	54.88	54.1	54.645	6719170.0
2015-11-04 10:00:00	MSFT	Stock	54.65	54.66	54.255	54.292	5388401.0
2015-11-04 11:00:00	MSFT	Stock	54.29	54.405	54.06	54.235	3898108.0
2015-11-04 12:00:00	MSFT	Stock	54.235	54.56	54.21	54.25	3699846.0
2015-11-04 13:00:00	MSFT	Stock	54.25	54.315	54.09	54.29	2612160.0
2015-11-04 14:00:00	MSFT	Stock	54.29	54.59	54.16	54.49	5891368.0
2015-11-04 15:00:00	MSFT	Stock	54.485	54.54	54.23	54.41	5417998.0
2015-11-04 16:00:00	MSFT	Stock	54.4	54.42	54.3	54.38	1517333.0
2015-11-04 17:00:00	MSFT	Stock	54.38	54.39	54.3	54.3	3200.0
2015-11-04 18:00:00	MSFT	Stock	54.29	54.38	54.29	54.38	200.0
2015-11-04 19:00:00	MSFT	Stock	54.37	54.38	54.29	54.29	2093.0
2015-11-04 08:00:00	NVDA	Stock	0.7128	0.7145	0.7128	0.7145	11240.0
2015-11-04 09:00:00	NVDA	Stock	0.7123	0.7158	0.7068	0.7075	26659200.0
2015-11-04 10:00:00	NVDA	Stock	0.7075	0.71	0.6975	0.705	119735400.0
2015-11-04 11:00:00	NVDA	Stock	0.7049	0.708	0.7022	0.7071	34035240.0
2015-11-04 12:00:00	NVDA	Stock	0.7072	0.7109	0.707	0.7093	22650440.0
2015-11-04 13:00:00	NVDA	Stock	0.7093	0.7095	0.705	0.7068	28196440.0
2015-11-04 14:00:00	NVDA	Stock	0.7068	0.7093	0.7058	0.7061	27840680.0
2015-11-04 15:00:00	NVDA	Stock	0.7062	0.7068	0.6992	0.7008	134697520.0
2015-11-04 16:00:00	NVDA	Stock	0.7008	0.7052	0.6999	0.7	17429640.0
2015-11-04 04:00:00	AMZN	Stock	31.35	31.35	31.35	31.35	2500.0
2015-11-04 07:00:00	AMZN	Stock	31.3925	31.435	31.3925	31.435	54260.0
2015-11-04 08:00:00	AMZN	Stock	31.408	31.415	31.3502	31.415	225200.0
2015-11-04 09:00:00	AMZN	Stock	31.4235	31.682	31.3675	31.6103	12507680.0
2015-11-04 10:00:00	AMZN	Stock	31.6	31.8	31.5355	31.7505	12680700.0
2015-11-04 11:00:00	AMZN	Stock	31.7505	31.9675	31.6925	31.9601	9436560.0
2015-11-04 12:00:00	AMZN	Stock	31.97	32.2385	31.9335	32.2162	16906600.0
2015-11-04 13:00:00	AMZN	Stock	32.2174	32.2965	32.0605	32.122	12103680.0
2015-11-04 14:00:00	AMZN	Stock	32.1245	32.24	32.0249	32.0775	7676840.0
2015-11-04 15:00:00	AMZN	Stock	32.0841	32.095	31.911	32.0585	11509060.0

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

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