PREVIEW / stock_1hour / 2017-12-27

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-12-27.parquet
  size:    1.1 MB
  rows:    49,015
  symbols: 2,918

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
2017-12-27 04:00:00	AAPL	Stock	42.7775	42.7775	42.725	42.725	11464.0
2017-12-27 05:00:00	AAPL	Stock	42.6875	42.7	42.6875	42.7	7272.0
2017-12-27 06:00:00	AAPL	Stock	42.7	42.7	42.6375	42.6375	4188.0
2017-12-27 07:00:00	AAPL	Stock	42.6625	42.7	42.5975	42.6425	116412.0
2017-12-27 08:00:00	AAPL	Stock	42.6375	42.6975	42.545	42.6425	287428.0
2017-12-27 09:00:00	AAPL	Stock	42.6625	42.695	42.4275	42.5305	17248328.0
2017-12-27 10:00:00	AAPL	Stock	42.5325	42.5775	42.46	42.482	14585108.0
2017-12-27 11:00:00	AAPL	Stock	42.485	42.6312	42.485	42.5975	9246316.0
2017-12-27 12:00:00	AAPL	Stock	42.5975	42.6475	42.575	42.6325	4793788.0
2017-12-27 13:00:00	AAPL	Stock	42.6325	42.6475	42.5625	42.595	4358444.0
2017-12-27 14:00:00	AAPL	Stock	42.5925	42.6	42.4975	42.545	5400988.0
2017-12-27 15:00:00	AAPL	Stock	42.5475	42.6575	42.5275	42.645	11085792.0
2017-12-27 16:00:00	AAPL	Stock	42.6475	42.6725	42.6025	42.65	9422468.0
2017-12-27 17:00:00	AAPL	Stock	42.6375	42.675	42.6375	42.65	55264.0
2017-12-27 18:00:00	AAPL	Stock	42.65	42.6675	42.65	42.6625	38796.0
2017-12-27 19:00:00	AAPL	Stock	42.6675	42.675	42.655	42.6625	27832.0
2017-12-27 07:00:00	MSFT	Stock	85.58	85.58	85.42	85.42	1666.0
2017-12-27 08:00:00	MSFT	Stock	85.52	85.55	85.4	85.53	4124.0
2017-12-27 09:00:00	MSFT	Stock	85.55	85.7	85.215	85.26	1246302.0
2017-12-27 10:00:00	MSFT	Stock	85.27	85.94	85.265	85.91	2247251.0
2017-12-27 11:00:00	MSFT	Stock	85.915	85.98	85.49	85.5	1575408.0
2017-12-27 12:00:00	MSFT	Stock	85.5	85.69	85.42	85.42	920424.0
2017-12-27 13:00:00	MSFT	Stock	85.42	85.55	85.366	85.545	733424.0
2017-12-27 14:00:00	MSFT	Stock	85.54	85.556	85.435	85.505	1014049.0
2017-12-27 15:00:00	MSFT	Stock	85.505	85.71	85.47	85.69	1979022.0
2017-12-27 16:00:00	MSFT	Stock	85.7	85.77	85.65	85.77	2130217.0
2017-12-27 17:00:00	MSFT	Stock	85.77	85.77	85.77	85.77	310.0
2017-12-27 18:00:00	MSFT	Stock	85.72	85.72	85.72	85.72	200.0
2017-12-27 19:00:00	MSFT	Stock	85.8	85.95	85.8	85.93	1500.0
2017-12-27 05:00:00	NVDA	Stock	4.9362	4.9362	4.9362	4.9362	12000.0
2017-12-27 06:00:00	NVDA	Stock	4.9338	4.9338	4.9338	4.9338	4000.0
2017-12-27 07:00:00	NVDA	Stock	4.936	4.936	4.895	4.9128	1564320.0
2017-12-27 08:00:00	NVDA	Stock	4.9405	4.9405	4.8875	4.9205	807480.0
2017-12-27 09:00:00	NVDA	Stock	4.9235	4.9992	4.9078	4.9983	79416920.0
2017-12-27 10:00:00	NVDA	Stock	4.9983	4.9983	4.9635	4.9663	66399880.0
2017-12-27 11:00:00	NVDA	Stock	4.9665	4.975	4.9408	4.943	45676160.0
2017-12-27 12:00:00	NVDA	Stock	4.943	4.9608	4.9358	4.9518	23170560.0
2017-12-27 13:00:00	NVDA	Stock	4.9521	4.9558	4.939	4.9428	16588360.0
2017-12-27 14:00:00	NVDA	Stock	4.9425	4.9488	4.9235	4.9325	23491360.0
2017-12-27 15:00:00	NVDA	Stock	4.9322	4.9327	4.9158	4.928	36363720.0
2017-12-27 16:00:00	NVDA	Stock	4.9292	4.9375	4.9275	4.9275	16098200.0
2017-12-27 17:00:00	NVDA	Stock	4.93	4.9358	4.93	4.9358	2972120.0
2017-12-27 18:00:00	NVDA	Stock	4.934	4.934	4.9288	4.9288	79840.0
2017-12-27 19:00:00	NVDA	Stock	4.9275	4.9298	4.9263	4.9288	364160.0
2017-12-27 04:00:00	AMZN	Stock	58.9	58.9	58.9	58.9	2980.0
2017-12-27 07:00:00	AMZN	Stock	58.935	58.935	58.8725	58.8725	19420.0
2017-12-27 08:00:00	AMZN	Stock	58.949	58.96	58.85	58.96	75520.0
2017-12-27 09:00:00	AMZN	Stock	58.96	59.1945	58.7805	59.1662	6187100.0
2017-12-27 10:00:00	AMZN	Stock	59.175	59.3645	59.175	59.2925	6228380.0
2017-12-27 11:00:00	AMZN	Stock	59.294	59.325	59.0615	59.0803	4687740.0

> showing 50 of 49,015 rows — these rows as CSV

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