PREVIEW / stock_1hour / 2015-12-03

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-12-03.parquet
  size:    1.0 MB
  rows:    48,769
  symbols: 3,408

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-12-03 04:00:00	AAPL	Stock	29.1775	29.2375	29.175	29.2375	16556.0
2015-12-03 05:00:00	AAPL	Stock	29.2075	29.235	29.135	29.235	32988.0
2015-12-03 06:00:00	AAPL	Stock	29.22	29.325	29.2025	29.28	45920.0
2015-12-03 07:00:00	AAPL	Stock	29.275	29.2875	29.125	29.215	189596.0
2015-12-03 08:00:00	AAPL	Stock	29.215	29.325	29.05	29.19	758584.0
2015-12-03 09:00:00	AAPL	Stock	29.19	29.21	28.935	29.105	19014332.0
2015-12-03 10:00:00	AAPL	Stock	29.1075	29.1225	28.9275	29.01	19566284.0
2015-12-03 11:00:00	AAPL	Stock	29.0125	29.17	28.99	29.0475	13541984.0
2015-12-03 12:00:00	AAPL	Stock	29.0475	29.0575	28.7878	28.815	18720180.0
2015-12-03 13:00:00	AAPL	Stock	28.815	28.895	28.705	28.7075	17119720.0
2015-12-03 14:00:00	AAPL	Stock	28.708	28.7525	28.555	28.7222	23742196.0
2015-12-03 15:00:00	AAPL	Stock	28.7225	28.8175	28.61	28.8	26668348.0
2015-12-03 16:00:00	AAPL	Stock	28.8	28.8475	28.7925	28.8425	14135148.0
2015-12-03 17:00:00	AAPL	Stock	28.8425	28.8425	28.825	28.8375	65476.0
2015-12-03 18:00:00	AAPL	Stock	28.8425	28.85	28.84	28.8475	64136.0
2015-12-03 19:00:00	AAPL	Stock	28.845	28.8675	28.845	28.865	46528.0
2015-12-03 05:00:00	MSFT	Stock	55.65	55.7	55.65	55.7	3700.0
2015-12-03 07:00:00	MSFT	Stock	55.56	55.6	55.39	55.55	6752.0
2015-12-03 08:00:00	MSFT	Stock	55.4	55.5	55.03	55.25	54562.0
2015-12-03 09:00:00	MSFT	Stock	55.35	55.77	54.992	55.18	2903237.0
2015-12-03 10:00:00	MSFT	Stock	55.175	55.225	54.85	55.06	3933562.0
2015-12-03 11:00:00	MSFT	Stock	55.06	55.65	54.73	54.89	3529271.0
2015-12-03 12:00:00	MSFT	Stock	54.88	54.92	54.2	54.22	4708060.0
2015-12-03 13:00:00	MSFT	Stock	54.22	54.44	54.031	54.07	4355760.0
2015-12-03 14:00:00	MSFT	Stock	54.08	54.29	53.97	54.25	4863914.0
2015-12-03 15:00:00	MSFT	Stock	54.25	54.28	53.93	54.2	8777031.0
2015-12-03 16:00:00	MSFT	Stock	54.21	54.516	54.2	54.2	3244213.0
2015-12-03 17:00:00	MSFT	Stock	54.3	54.3	54.3	54.3	2512.0
2015-12-03 18:00:00	MSFT	Stock	54.25	54.34	54.25	54.34	284.0
2015-12-03 19:00:00	MSFT	Stock	54.3	54.3	54.3	54.3	450.0
2015-12-03 08:00:00	NVDA	Stock	0.8252	0.8305	0.8132	0.8132	59440.0
2015-12-03 09:00:00	NVDA	Stock	0.8218	0.8275	0.8185	0.8236	33458600.0
2015-12-03 10:00:00	NVDA	Stock	0.8235	0.8236	0.8155	0.8178	23261720.0
2015-12-03 11:00:00	NVDA	Stock	0.8179	0.8228	0.8152	0.818	21694200.0
2015-12-03 12:00:00	NVDA	Stock	0.8178	0.818	0.8092	0.8132	34523760.0
2015-12-03 13:00:00	NVDA	Stock	0.8135	0.8159	0.8123	0.8126	21693840.0
2015-12-03 14:00:00	NVDA	Stock	0.8125	0.8128	0.807	0.8095	30929920.0
2015-12-03 15:00:00	NVDA	Stock	0.8095	0.8113	0.8068	0.8109	40273520.0
2015-12-03 16:00:00	NVDA	Stock	0.8108	0.8154	0.8108	0.8152	28741360.0
2015-12-03 19:00:00	NVDA	Stock	0.8108	0.8108	0.8108	0.8108	6000.0
2015-12-03 07:00:00	AMZN	Stock	34.05	34.093	33.95	34.0025	200740.0
2015-12-03 08:00:00	AMZN	Stock	34.05	34.1245	33.85	33.944	322220.0
2015-12-03 09:00:00	AMZN	Stock	33.9745	34.05	33.7615	33.9145	9890040.0
2015-12-03 10:00:00	AMZN	Stock	33.9325	34.0	33.806	33.911	8437740.0
2015-12-03 11:00:00	AMZN	Stock	33.9105	34.1395	33.8876	33.975	10015840.0
2015-12-03 12:00:00	AMZN	Stock	33.975	33.9855	33.5165	33.575	11978380.0
2015-12-03 13:00:00	AMZN	Stock	33.5747	33.5907	33.344	33.3825	12729560.0
2015-12-03 14:00:00	AMZN	Stock	33.3948	33.493	33.2	33.3245	12816940.0
2015-12-03 15:00:00	AMZN	Stock	33.3188	33.39	33.074	33.325	18485000.0
2015-12-03 16:00:00	AMZN	Stock	33.3125	33.5398	33.3125	33.4961	3856580.0

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

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