PREVIEW / stock_1hour / 2017-04-06

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-04-06.parquet
  size:    1.0 MB
  rows:    47,818
  symbols: 3,049

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-04-06 04:00:00	AAPL	Stock	35.9075	35.9375	35.9075	35.9375	13408.0
2017-04-06 05:00:00	AAPL	Stock	35.965	36.0	35.965	36.0	6268.0
2017-04-06 06:00:00	AAPL	Stock	35.9925	36.05	35.98	36.05	40980.0
2017-04-06 07:00:00	AAPL	Stock	36.04	36.06	36.025	36.025	86712.0
2017-04-06 08:00:00	AAPL	Stock	36.025	36.06	35.9875	36.0375	190296.0
2017-04-06 09:00:00	AAPL	Stock	36.0425	36.13	35.955	36.0775	14324004.0
2017-04-06 10:00:00	AAPL	Stock	36.08	36.0975	35.8675	36.0275	15735268.0
2017-04-06 11:00:00	AAPL	Stock	36.0288	36.0925	35.96	36.0178	7043976.0
2017-04-06 12:00:00	AAPL	Stock	36.0225	36.0368	35.9525	35.9775	4815432.0
2017-04-06 13:00:00	AAPL	Stock	35.975	36.105	35.9675	36.02	5322936.0
2017-04-06 14:00:00	AAPL	Stock	36.0225	36.0425	35.88	35.89	7491056.0
2017-04-06 15:00:00	AAPL	Stock	35.8888	35.9675	35.8625	35.9175	13975084.0
2017-04-06 16:00:00	AAPL	Stock	35.915	35.9732	35.9	35.915	7303928.0
2017-04-06 17:00:00	AAPL	Stock	35.9375	35.945	35.915	35.9375	34188.0
2017-04-06 18:00:00	AAPL	Stock	35.915	35.9375	35.9025	35.9025	6348.0
2017-04-06 19:00:00	AAPL	Stock	35.905	35.925	35.9	35.925	12896.0
2017-04-06 07:00:00	MSFT	Stock	65.63	65.63	65.63	65.63	1360.0
2017-04-06 08:00:00	MSFT	Stock	65.63	65.67	65.59	65.59	5422.0
2017-04-06 09:00:00	MSFT	Stock	65.59	65.825	65.48	65.8	2606144.0
2017-04-06 10:00:00	MSFT	Stock	65.8	65.98	65.56	65.93	2999012.0
2017-04-06 11:00:00	MSFT	Stock	65.93	66.055	65.845	65.92	1812524.0
2017-04-06 12:00:00	MSFT	Stock	65.925	65.945	65.67	65.728	1110391.0
2017-04-06 13:00:00	MSFT	Stock	65.73	65.87	65.7	65.705	902741.0
2017-04-06 14:00:00	MSFT	Stock	65.705	65.74	65.48	65.53	1692196.0
2017-04-06 15:00:00	MSFT	Stock	65.534	65.77	65.53	65.73	3624704.0
2017-04-06 16:00:00	MSFT	Stock	65.73	65.835	65.64	65.64	2021328.0
2017-04-06 18:00:00	MSFT	Stock	65.73	65.73	65.73	65.73	300.0
2017-04-06 19:00:00	MSFT	Stock	65.68	65.73	65.68	65.73	1250.0
2017-04-06 06:00:00	NVDA	Stock	2.5125	2.5125	2.5125	2.5125	8000.0
2017-04-06 07:00:00	NVDA	Stock	2.5122	2.515	2.5075	2.5078	130720.0
2017-04-06 08:00:00	NVDA	Stock	2.511	2.52	2.505	2.5135	1482320.0
2017-04-06 09:00:00	NVDA	Stock	2.5128	2.5175	2.4753	2.4885	103962600.0
2017-04-06 10:00:00	NVDA	Stock	2.4878	2.4955	2.4603	2.4933	155656880.0
2017-04-06 11:00:00	NVDA	Stock	2.4935	2.5185	2.4923	2.5173	93600160.0
2017-04-06 12:00:00	NVDA	Stock	2.517	2.5225	2.51	2.5208	49783200.0
2017-04-06 13:00:00	NVDA	Stock	2.5205	2.5312	2.5185	2.5225	58377480.0
2017-04-06 14:00:00	NVDA	Stock	2.5222	2.5259	2.5055	2.5068	43952840.0
2017-04-06 15:00:00	NVDA	Stock	2.5068	2.519	2.503	2.519	71977040.0
2017-04-06 16:00:00	NVDA	Stock	2.519	2.5255	2.4991	2.5255	12222240.0
2017-04-06 17:00:00	NVDA	Stock	2.525	2.526	2.525	2.526	203200.0
2017-04-06 18:00:00	NVDA	Stock	2.526	2.5295	2.526	2.5295	146600.0
2017-04-06 19:00:00	NVDA	Stock	2.526	2.5308	2.525	2.5308	161240.0
2017-04-06 04:00:00	AMZN	Stock	45.425	45.425	45.425	45.425	2000.0
2017-04-06 06:00:00	AMZN	Stock	45.4085	45.595	45.4085	45.595	8600.0
2017-04-06 07:00:00	AMZN	Stock	45.5995	45.5995	45.554	45.565	82440.0
2017-04-06 08:00:00	AMZN	Stock	45.5825	45.7245	45.36	45.7	797260.0
2017-04-06 09:00:00	AMZN	Stock	45.724	45.8595	45.1275	45.3015	24343540.0
2017-04-06 10:00:00	AMZN	Stock	45.3275	45.435	45.1384	45.2192	16971240.0
2017-04-06 11:00:00	AMZN	Stock	45.225	45.2545	44.8825	45.0275	17393940.0
2017-04-06 12:00:00	AMZN	Stock	45.0252	45.0975	44.8304	44.837	10500980.0

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

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