PREVIEW / stock_1hour / 2017-01-18

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-01-18.parquet
  size:    1.0 MB
  rows:    47,970
  symbols: 3,127

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-01-18 04:00:00	AAPL	Stock	30.0	30.0	30.0	30.0	2632.0
2017-01-18 05:00:00	AAPL	Stock	30.0	30.0325	30.0	30.0325	3476.0
2017-01-18 06:00:00	AAPL	Stock	29.9775	30.05	29.975	30.0025	22516.0
2017-01-18 07:00:00	AAPL	Stock	30.0025	30.025	29.975	30.015	33832.0
2017-01-18 08:00:00	AAPL	Stock	30.0175	30.04	29.9975	30.0275	159232.0
2017-01-18 09:00:00	AAPL	Stock	30.0325	30.125	29.9925	30.06	16560640.0
2017-01-18 10:00:00	AAPL	Stock	30.0625	30.065	29.9275	29.9975	12538184.0
2017-01-18 11:00:00	AAPL	Stock	29.9975	30.0225	29.9525	29.965	14714640.0
2017-01-18 12:00:00	AAPL	Stock	29.965	30.0125	29.9575	29.9725	5467420.0
2017-01-18 13:00:00	AAPL	Stock	29.9725	30.0172	29.965	29.9962	5520104.0
2017-01-18 14:00:00	AAPL	Stock	29.9962	30.0225	29.99	30.02	6634640.0
2017-01-18 15:00:00	AAPL	Stock	30.0185	30.0625	29.9875	29.9925	13001444.0
2017-01-18 16:00:00	AAPL	Stock	29.9975	30.0175	29.9825	29.9875	9617872.0
2017-01-18 17:00:00	AAPL	Stock	29.9825	29.9975	29.9825	29.99	140852.0
2017-01-18 18:00:00	AAPL	Stock	29.995	29.995	29.98	29.99	21472.0
2017-01-18 19:00:00	AAPL	Stock	29.9875	29.995	29.985	29.995	31492.0
2017-01-18 05:00:00	MSFT	Stock	62.73	62.83	62.7	62.7	807.0
2017-01-18 06:00:00	MSFT	Stock	62.7	62.7	62.7	62.7	159.0
2017-01-18 07:00:00	MSFT	Stock	62.6	62.6	62.56	62.59	1200.0
2017-01-18 08:00:00	MSFT	Stock	62.5	62.65	62.5	62.65	200.0
2017-01-18 09:00:00	MSFT	Stock	62.66	62.8	62.12	62.44	2577030.0
2017-01-18 10:00:00	MSFT	Stock	62.435	62.53	62.2	62.37	2747501.0
2017-01-18 11:00:00	MSFT	Stock	62.36	62.386	62.21	62.24	1766183.0
2017-01-18 12:00:00	MSFT	Stock	62.23	62.46	62.23	62.385	1259857.0
2017-01-18 13:00:00	MSFT	Stock	62.38	62.44	62.34	62.38	752134.0
2017-01-18 14:00:00	MSFT	Stock	62.385	62.45	62.31	62.425	1169878.0
2017-01-18 15:00:00	MSFT	Stock	62.42	62.53	62.345	62.49	3168600.0
2017-01-18 16:00:00	MSFT	Stock	62.5	62.66	62.5	62.52	3956569.0
2017-01-18 17:00:00	MSFT	Stock	62.52	62.52	62.5	62.5	391.0
2017-01-18 19:00:00	MSFT	Stock	62.5	62.55	62.5	62.55	2100.0
2017-01-18 04:00:00	NVDA	Stock	2.53	2.5555	2.53	2.5555	8000.0
2017-01-18 06:00:00	NVDA	Stock	2.53	2.53	2.5262	2.5262	48000.0
2017-01-18 07:00:00	NVDA	Stock	2.5225	2.5225	2.515	2.515	40720.0
2017-01-18 08:00:00	NVDA	Stock	2.5225	2.5275	2.5028	2.5032	1065440.0
2017-01-18 09:00:00	NVDA	Stock	2.504	2.5613	2.4778	2.5585	153532160.0
2017-01-18 10:00:00	NVDA	Stock	2.5579	2.5725	2.5413	2.5565	118957040.0
2017-01-18 11:00:00	NVDA	Stock	2.5568	2.5672	2.5468	2.5558	64748440.0
2017-01-18 12:00:00	NVDA	Stock	2.5548	2.5675	2.5545	2.5602	39126440.0
2017-01-18 13:00:00	NVDA	Stock	2.5598	2.5808	2.559	2.5662	46155000.0
2017-01-18 14:00:00	NVDA	Stock	2.566	2.572	2.5582	2.5617	37461480.0
2017-01-18 15:00:00	NVDA	Stock	2.5618	2.5745	2.5548	2.574	60369840.0
2017-01-18 16:00:00	NVDA	Stock	2.5735	2.5832	2.567	2.58	109275040.0
2017-01-18 17:00:00	NVDA	Stock	2.5782	2.5875	2.5782	2.585	357280.0
2017-01-18 18:00:00	NVDA	Stock	2.585	2.5925	2.585	2.5922	534680.0
2017-01-18 19:00:00	NVDA	Stock	2.5913	2.5922	2.5875	2.5922	293720.0
2017-01-18 06:00:00	AMZN	Stock	40.4625	40.4625	40.285	40.3	31220.0
2017-01-18 07:00:00	AMZN	Stock	40.3	40.326	40.3	40.3	49180.0
2017-01-18 08:00:00	AMZN	Stock	40.3	40.4175	40.3	40.365	139860.0
2017-01-18 09:00:00	AMZN	Stock	40.3655	40.5865	40.259	40.527	7993340.0
2017-01-18 10:00:00	AMZN	Stock	40.533	40.575	40.42	40.473	8347980.0

> showing 50 of 47,970 rows — these rows as CSV

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