PREVIEW / stock_1hour / 2018-06-06

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-06-06.parquet
  size:    1.1 MB
  rows:    50,306
  symbols: 2,841

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
2018-06-06 04:00:00	AAPL	Stock	48.375	48.5325	48.375	48.455	9536.0
2018-06-06 05:00:00	AAPL	Stock	48.445	48.475	48.4375	48.45	20336.0
2018-06-06 06:00:00	AAPL	Stock	48.47	48.475	48.4325	48.45	22504.0
2018-06-06 07:00:00	AAPL	Stock	48.4125	48.5	48.4025	48.4975	150936.0
2018-06-06 08:00:00	AAPL	Stock	48.45	48.5	48.3275	48.4225	713520.0
2018-06-06 09:00:00	AAPL	Stock	48.4125	48.4825	48.2365	48.2525	10606864.0
2018-06-06 10:00:00	AAPL	Stock	48.25	48.265	47.98	48.1075	11927052.0
2018-06-06 11:00:00	AAPL	Stock	48.11	48.3212	48.1075	48.2725	7456660.0
2018-06-06 12:00:00	AAPL	Stock	48.2722	48.2775	48.1725	48.2425	4275616.0
2018-06-06 13:00:00	AAPL	Stock	48.2425	48.275	48.115	48.1738	4408780.0
2018-06-06 14:00:00	AAPL	Stock	48.175	48.3838	48.175	48.36	6116280.0
2018-06-06 15:00:00	AAPL	Stock	48.36	48.52	48.3125	48.5125	14364720.0
2018-06-06 16:00:00	AAPL	Stock	48.5075	48.5075	48.425	48.4875	13701564.0
2018-06-06 17:00:00	AAPL	Stock	48.4625	48.4875	48.455	48.4775	19768.0
2018-06-06 18:00:00	AAPL	Stock	48.48	48.4825	48.465	48.4725	36216.0
2018-06-06 19:00:00	AAPL	Stock	48.4625	48.475	48.4375	48.4625	31976.0
2018-06-06 04:00:00	MSFT	Stock	102.33	102.7	102.33	102.7	1465.0
2018-06-06 05:00:00	MSFT	Stock	102.7	102.7	102.6	102.6	1368.0
2018-06-06 06:00:00	MSFT	Stock	102.74	102.74	102.74	102.74	176.0
2018-06-06 07:00:00	MSFT	Stock	102.51	102.85	102.51	102.7	6584.0
2018-06-06 08:00:00	MSFT	Stock	102.6	102.84	102.5	102.61	28573.0
2018-06-06 09:00:00	MSFT	Stock	102.65	102.65	102.2	102.24	2761710.0
2018-06-06 10:00:00	MSFT	Stock	102.245	102.33	101.92	102.095	2841790.0
2018-06-06 11:00:00	MSFT	Stock	102.095	102.55	102.08	102.5	1790126.0
2018-06-06 12:00:00	MSFT	Stock	102.5	102.55	102.15	102.22	1205061.0
2018-06-06 13:00:00	MSFT	Stock	102.23	102.27	101.9	102.06	1187739.0
2018-06-06 14:00:00	MSFT	Stock	102.07	102.47	102.066	102.425	1130180.0
2018-06-06 15:00:00	MSFT	Stock	102.435	102.59	102.27	102.57	3622904.0
2018-06-06 16:00:00	MSFT	Stock	102.57	102.57	102.3	102.31	4170246.0
2018-06-06 17:00:00	MSFT	Stock	102.35	102.49	102.35	102.45	1872.0
2018-06-06 18:00:00	MSFT	Stock	102.41	102.55	102.33	102.5	4565.0
2018-06-06 19:00:00	MSFT	Stock	102.49	102.49	102.32	102.47	3467.0
2018-06-06 04:00:00	NVDA	Stock	6.6395	6.6698	6.6395	6.665	45520.0
2018-06-06 05:00:00	NVDA	Stock	6.6438	6.6538	6.6438	6.65	29760.0
2018-06-06 06:00:00	NVDA	Stock	6.6525	6.6525	6.65	6.65	21440.0
2018-06-06 07:00:00	NVDA	Stock	6.655	6.6575	6.5878	6.5963	1279200.0
2018-06-06 08:00:00	NVDA	Stock	6.6	6.6575	6.5738	6.5775	3388760.0
2018-06-06 09:00:00	NVDA	Stock	6.5755	6.6248	6.5192	6.5721	103265640.0
2018-06-06 10:00:00	NVDA	Stock	6.5715	6.5942	6.5581	6.5853	59666640.0
2018-06-06 11:00:00	NVDA	Stock	6.5843	6.619	6.5775	6.5993	38041760.0
2018-06-06 12:00:00	NVDA	Stock	6.5985	6.6035	6.5775	6.5905	19896880.0
2018-06-06 13:00:00	NVDA	Stock	6.5916	6.597	6.5695	6.5736	19594880.0
2018-06-06 14:00:00	NVDA	Stock	6.5745	6.6112	6.5743	6.6082	31039320.0
2018-06-06 15:00:00	NVDA	Stock	6.608	6.632	6.6008	6.6318	49855560.0
2018-06-06 16:00:00	NVDA	Stock	6.6285	6.6355	6.6225	6.6275	6615120.0
2018-06-06 17:00:00	NVDA	Stock	6.6315	6.6315	6.6238	6.625	63840.0
2018-06-06 18:00:00	NVDA	Stock	6.625	6.63	6.625	6.6252	44600.0
2018-06-06 19:00:00	NVDA	Stock	6.6258	6.63	6.625	6.6252	101800.0
2018-06-06 04:00:00	AMZN	Stock	85.154	85.154	85.154	85.154	2000.0
2018-06-06 05:00:00	AMZN	Stock	85.25	85.25	85.1	85.1	25860.0

> showing 50 of 50,306 rows — these rows as CSV

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