PREVIEW / stock_1hour / 2017-06-15

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-06-15.parquet
  size:    1.0 MB
  rows:    48,171
  symbols: 3,029

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-06-15 04:00:00	AAPL	Stock	35.975	35.975	35.8125	35.9	45240.0
2017-06-15 05:00:00	AAPL	Stock	35.86	35.9	35.845	35.845	34248.0
2017-06-15 06:00:00	AAPL	Stock	35.8275	35.8825	35.775	35.8175	90372.0
2017-06-15 07:00:00	AAPL	Stock	35.825	35.8625	35.785	35.8125	142844.0
2017-06-15 08:00:00	AAPL	Stock	35.8375	35.9425	35.72	35.9425	830576.0
2017-06-15 09:00:00	AAPL	Stock	35.9375	36.045	35.7175	35.9575	21045296.0
2017-06-15 10:00:00	AAPL	Stock	35.9575	36.02	35.5525	35.805	28256368.0
2017-06-15 11:00:00	AAPL	Stock	35.8025	35.8975	35.7325	35.775	12577024.0
2017-06-15 12:00:00	AAPL	Stock	35.7775	35.955	35.7575	35.935	9760176.0
2017-06-15 13:00:00	AAPL	Stock	35.935	36.005	35.8545	35.9225	8881248.0
2017-06-15 14:00:00	AAPL	Stock	35.92	36.03	35.8775	35.95	10141160.0
2017-06-15 15:00:00	AAPL	Stock	35.9475	36.12	35.9325	36.075	18235056.0
2017-06-15 16:00:00	AAPL	Stock	36.075	36.0975	35.9875	36.085	5501300.0
2017-06-15 17:00:00	AAPL	Stock	36.085	36.095	36.0675	36.07	63808.0
2017-06-15 18:00:00	AAPL	Stock	36.0625	36.0825	36.05	36.05	59196.0
2017-06-15 19:00:00	AAPL	Stock	36.0725	36.1225	36.05	36.1225	134012.0
2017-06-15 04:00:00	MSFT	Stock	69.25	69.25	69.25	69.25	100.0
2017-06-15 07:00:00	MSFT	Stock	69.65	69.65	69.42	69.42	12101.0
2017-06-15 08:00:00	MSFT	Stock	69.41	69.6	69.31	69.6	24956.0
2017-06-15 09:00:00	MSFT	Stock	69.6	69.89	68.88	69.29	4187886.0
2017-06-15 10:00:00	MSFT	Stock	69.28	69.73	68.8	69.73	4672469.0
2017-06-15 11:00:00	MSFT	Stock	69.72	70.07	69.64	69.82	3260196.0
2017-06-15 12:00:00	MSFT	Stock	69.83	70.07	69.74	70.035	2359939.0
2017-06-15 13:00:00	MSFT	Stock	70.04	70.056	69.8	69.91	1344767.0
2017-06-15 14:00:00	MSFT	Stock	69.91	70.21	69.88	70.06	2025150.0
2017-06-15 15:00:00	MSFT	Stock	70.06	70.15	69.85	69.9	4339481.0
2017-06-15 16:00:00	MSFT	Stock	69.9	69.99	69.85	69.97	2067630.0
2017-06-15 17:00:00	MSFT	Stock	69.9	69.98	69.87	69.87	3099.0
2017-06-15 18:00:00	MSFT	Stock	69.98	69.98	69.9	69.9	7165.0
2017-06-15 19:00:00	MSFT	Stock	69.97	69.98	69.97	69.98	552.0
2017-06-15 04:00:00	NVDA	Stock	3.725	3.725	3.7	3.7172	52440.0
2017-06-15 05:00:00	NVDA	Stock	3.7008	3.7008	3.6835	3.6875	67640.0
2017-06-15 06:00:00	NVDA	Stock	3.6875	3.6945	3.6825	3.6938	280400.0
2017-06-15 07:00:00	NVDA	Stock	3.695	3.7215	3.686	3.6875	752480.0
2017-06-15 08:00:00	NVDA	Stock	3.6875	3.72	3.6428	3.661	11535920.0
2017-06-15 09:00:00	NVDA	Stock	3.661	3.7695	3.66	3.7612	211263920.0
2017-06-15 10:00:00	NVDA	Stock	3.76	3.762	3.705	3.7538	156143120.0
2017-06-15 11:00:00	NVDA	Stock	3.755	3.7912	3.7484	3.766	129619440.0
2017-06-15 12:00:00	NVDA	Stock	3.7662	3.8218	3.7568	3.815	105992920.0
2017-06-15 13:00:00	NVDA	Stock	3.8144	3.8245	3.795	3.8068	83554920.0
2017-06-15 14:00:00	NVDA	Stock	3.8068	3.84	3.7975	3.8175	91574800.0
2017-06-15 15:00:00	NVDA	Stock	3.8168	3.8242	3.792	3.8093	112809120.0
2017-06-15 16:00:00	NVDA	Stock	3.8093	3.8095	3.7992	3.8088	17689080.0
2017-06-15 17:00:00	NVDA	Stock	3.81	3.815	3.807	3.8108	2110080.0
2017-06-15 18:00:00	NVDA	Stock	3.812	3.8218	3.8093	3.8218	1219240.0
2017-06-15 19:00:00	NVDA	Stock	3.8215	3.825	3.8178	3.8242	752960.0
2017-06-15 04:00:00	AMZN	Stock	48.1655	48.1655	48.1655	48.1655	3900.0
2017-06-15 05:00:00	AMZN	Stock	48.25	48.25	48.183	48.183	37160.0
2017-06-15 06:00:00	AMZN	Stock	48.2	48.201	48.0	48.0995	125780.0
2017-06-15 07:00:00	AMZN	Stock	48.1895	48.2	48.05	48.105	94100.0

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

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