PREVIEW / stock_1hour / 2018-06-13

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-06-13.parquet
  size:    1.1 MB
  rows:    49,671
  symbols: 2,837

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-13 04:00:00	AAPL	Stock	48.125	48.125	48.125	48.125	600.0
2018-06-13 05:00:00	AAPL	Stock	48.075	48.075	48.075	48.075	2800.0
2018-06-13 06:00:00	AAPL	Stock	48.0775	48.1	48.055	48.1	21012.0
2018-06-13 07:00:00	AAPL	Stock	48.1	48.1675	48.1	48.1375	96672.0
2018-06-13 08:00:00	AAPL	Stock	48.155	48.155	48.0725	48.08	112412.0
2018-06-13 09:00:00	AAPL	Stock	48.085	48.1575	47.9525	48.0875	7853484.0
2018-06-13 10:00:00	AAPL	Stock	48.09	48.1438	48.015	48.125	7625236.0
2018-06-13 11:00:00	AAPL	Stock	48.1275	48.22	48.1275	48.1862	5599956.0
2018-06-13 12:00:00	AAPL	Stock	48.1875	48.19	48.0325	48.0468	4668052.0
2018-06-13 13:00:00	AAPL	Stock	48.0475	48.0725	47.99	48.0425	3941996.0
2018-06-13 14:00:00	AAPL	Stock	48.0425	48.065	47.675	47.8675	14579660.0
2018-06-13 15:00:00	AAPL	Stock	47.8675	47.975	47.61	47.6775	16688400.0
2018-06-13 16:00:00	AAPL	Stock	47.675	47.8892	47.6395	47.65	12642712.0
2018-06-13 17:00:00	AAPL	Stock	47.655	47.675	47.6525	47.67	226216.0
2018-06-13 18:00:00	AAPL	Stock	47.67	47.675	47.66	47.675	37576.0
2018-06-13 19:00:00	AAPL	Stock	47.6675	47.6875	47.6625	47.6625	16812.0
2018-06-13 05:00:00	MSFT	Stock	101.85	101.88	101.85	101.88	300.0
2018-06-13 06:00:00	MSFT	Stock	101.83	101.83	101.73	101.79	500.0
2018-06-13 07:00:00	MSFT	Stock	101.45	101.75	101.45	101.49	3158.0
2018-06-13 08:00:00	MSFT	Stock	101.59	101.76	101.35	101.41	7753.0
2018-06-13 09:00:00	MSFT	Stock	101.55	101.79	101.07	101.21	2558167.0
2018-06-13 10:00:00	MSFT	Stock	101.21	101.63	101.14	101.565	2824839.0
2018-06-13 11:00:00	MSFT	Stock	101.565	102.01	101.565	101.7	2079694.0
2018-06-13 12:00:00	MSFT	Stock	101.705	101.715	101.38	101.38	1524872.0
2018-06-13 13:00:00	MSFT	Stock	101.38	101.53	101.21	101.48	1242222.0
2018-06-13 14:00:00	MSFT	Stock	101.48	101.5	100.56	101.185	3945847.0
2018-06-13 15:00:00	MSFT	Stock	101.18	101.43	100.76	100.9	4972237.0
2018-06-13 16:00:00	MSFT	Stock	100.85	101.325	100.8	100.8	4800460.0
2018-06-13 17:00:00	MSFT	Stock	100.83	101.0	100.77	101.0	407980.0
2018-06-13 18:00:00	MSFT	Stock	101.0	101.0	101.0	101.0	960.0
2018-06-13 19:00:00	MSFT	Stock	100.96	100.96	100.86	100.86	2164.0
2018-06-13 04:00:00	NVDA	Stock	6.57	6.57	6.57	6.57	10000.0
2018-06-13 06:00:00	NVDA	Stock	6.579	6.579	6.577	6.577	31600.0
2018-06-13 07:00:00	NVDA	Stock	6.5775	6.5812	6.5732	6.5732	280280.0
2018-06-13 08:00:00	NVDA	Stock	6.576	6.5812	6.57	6.57	1120000.0
2018-06-13 09:00:00	NVDA	Stock	6.5722	6.6216	6.5508	6.615	50678160.0
2018-06-13 10:00:00	NVDA	Stock	6.6145	6.6373	6.6145	6.6188	60075760.0
2018-06-13 11:00:00	NVDA	Stock	6.6205	6.6418	6.6188	6.6238	24542360.0
2018-06-13 12:00:00	NVDA	Stock	6.6248	6.626	6.6072	6.613	20986960.0
2018-06-13 13:00:00	NVDA	Stock	6.6125	6.6312	6.5985	6.6222	18435840.0
2018-06-13 14:00:00	NVDA	Stock	6.6215	6.628	6.5545	6.5975	52806360.0
2018-06-13 15:00:00	NVDA	Stock	6.598	6.614	6.5542	6.5592	58547320.0
2018-06-13 16:00:00	NVDA	Stock	6.56	6.5995	6.553	6.5545	27134520.0
2018-06-13 17:00:00	NVDA	Stock	6.5538	6.56	6.5538	6.56	4156480.0
2018-06-13 18:00:00	NVDA	Stock	6.5562	6.561	6.555	6.56	220680.0
2018-06-13 19:00:00	NVDA	Stock	6.561	6.561	6.5588	6.56	96000.0
2018-06-13 06:00:00	AMZN	Stock	85.0715	85.0715	85.0715	85.0715	4000.0
2018-06-13 07:00:00	AMZN	Stock	85.108	85.285	85.108	85.281	189260.0
2018-06-13 08:00:00	AMZN	Stock	85.175	85.3	85.1075	85.2055	365180.0
2018-06-13 09:00:00	AMZN	Stock	85.2245	85.45	85.054	85.131	7494480.0

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

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