PREVIEW / stock_1hour / 2017-12-26

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-12-26.parquet
  size:    1.1 MB
  rows:    48,431
  symbols: 2,889

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-26 04:00:00	AAPL	Stock	43.625	43.625	42.9375	42.9375	28856.0
2017-12-26 05:00:00	AAPL	Stock	42.9375	43.0275	42.9375	43.0275	4388.0
2017-12-26 06:00:00	AAPL	Stock	43.005	43.0575	42.6875	42.7975	130708.0
2017-12-26 07:00:00	AAPL	Stock	42.895	42.925	42.4375	42.5625	1162956.0
2017-12-26 08:00:00	AAPL	Stock	42.575	42.9	42.4525	42.68	1240164.0
2017-12-26 09:00:00	AAPL	Stock	42.6725	42.8675	42.4198	42.55	33513276.0
2017-12-26 10:00:00	AAPL	Stock	42.55	42.8475	42.4975	42.6525	21447400.0
2017-12-26 11:00:00	AAPL	Stock	42.65	42.6825	42.555	42.585	13196876.0
2017-12-26 12:00:00	AAPL	Stock	42.585	42.71	42.5525	42.6425	9756392.0
2017-12-26 13:00:00	AAPL	Stock	42.64	42.6625	42.5625	42.64	9284776.0
2017-12-26 14:00:00	AAPL	Stock	42.6375	42.6738	42.5925	42.622	6831480.0
2017-12-26 15:00:00	AAPL	Stock	42.6225	42.65	42.5275	42.6425	16997956.0
2017-12-26 16:00:00	AAPL	Stock	42.6425	42.65	42.575	42.635	6457308.0
2017-12-26 17:00:00	AAPL	Stock	42.6425	42.735	42.63	42.7225	298572.0
2017-12-26 18:00:00	AAPL	Stock	42.7175	42.725	42.6525	42.67	50704.0
2017-12-26 19:00:00	AAPL	Stock	42.67	42.675	42.6425	42.65	29816.0
2017-12-26 07:00:00	MSFT	Stock	85.25	85.25	85.0	85.0	6813.0
2017-12-26 08:00:00	MSFT	Stock	85.22	85.49	85.01	85.12	3335.0
2017-12-26 09:00:00	MSFT	Stock	85.25	85.48	85.03	85.32	1214072.0
2017-12-26 10:00:00	MSFT	Stock	85.31	85.535	85.28	85.35	1092307.0
2017-12-26 11:00:00	MSFT	Stock	85.35	85.44	85.23	85.29	1021314.0
2017-12-26 12:00:00	MSFT	Stock	85.3	85.41	85.29	85.38	852155.0
2017-12-26 13:00:00	MSFT	Stock	85.375	85.4	85.27	85.385	869338.0
2017-12-26 14:00:00	MSFT	Stock	85.38	85.4	85.28	85.29	732783.0
2017-12-26 15:00:00	MSFT	Stock	85.3	85.43	85.19	85.4	1570423.0
2017-12-26 16:00:00	MSFT	Stock	85.4	85.45	85.3	85.4	1799037.0
2017-12-26 17:00:00	MSFT	Stock	85.44	85.57	85.44	85.53	9379.0
2017-12-26 18:00:00	MSFT	Stock	85.51	85.51	85.5	85.5	955.0
2017-12-26 19:00:00	MSFT	Stock	85.5	85.54	85.5	85.54	2044.0
2017-12-26 04:00:00	NVDA	Stock	4.8818	4.8818	4.85	4.85	64400.0
2017-12-26 07:00:00	NVDA	Stock	4.8575	4.8575	4.8425	4.8485	123480.0
2017-12-26 08:00:00	NVDA	Stock	4.8475	4.8525	4.791	4.795	1817800.0
2017-12-26 09:00:00	NVDA	Stock	4.7975	4.852	4.795	4.8316	54993520.0
2017-12-26 10:00:00	NVDA	Stock	4.8327	4.8688	4.829	4.8509	63086880.0
2017-12-26 11:00:00	NVDA	Stock	4.8508	4.9133	4.8465	4.9042	51892880.0
2017-12-26 12:00:00	NVDA	Stock	4.9053	4.9218	4.8958	4.9115	38354080.0
2017-12-26 13:00:00	NVDA	Stock	4.9111	4.935	4.908	4.934	28080560.0
2017-12-26 14:00:00	NVDA	Stock	4.9338	4.9343	4.9205	4.925	18944240.0
2017-12-26 15:00:00	NVDA	Stock	4.9243	4.9438	4.9183	4.9365	45884880.0
2017-12-26 16:00:00	NVDA	Stock	4.936	4.9418	4.935	4.9358	22950720.0
2017-12-26 17:00:00	NVDA	Stock	4.9328	4.938	4.932	4.938	225480.0
2017-12-26 18:00:00	NVDA	Stock	4.938	4.9412	4.932	4.9362	256440.0
2017-12-26 19:00:00	NVDA	Stock	4.9343	4.9412	4.934	4.9348	220080.0
2017-12-26 06:00:00	AMZN	Stock	58.375	58.375	58.3005	58.3005	8000.0
2017-12-26 07:00:00	AMZN	Stock	58.2125	58.2125	58.15	58.168	38980.0
2017-12-26 08:00:00	AMZN	Stock	58.225	58.225	58.1875	58.2125	31760.0
2017-12-26 09:00:00	AMZN	Stock	58.2775	58.5745	58.0275	58.2739	8176100.0
2017-12-26 10:00:00	AMZN	Stock	58.275	58.395	58.2125	58.2315	4035580.0
2017-12-26 11:00:00	AMZN	Stock	58.2205	58.703	58.2205	58.659	4990340.0
2017-12-26 12:00:00	AMZN	Stock	58.6585	58.912	58.6375	58.867	3660560.0

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

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