PREVIEW / stock_1hour / 2018-06-18

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-06-18.parquet
  size:    1.1 MB
  rows:    50,197
  symbols: 2,835

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-18 04:00:00	AAPL	Stock	47.08	47.08	46.9525	46.9525	4528.0
2018-06-18 05:00:00	AAPL	Stock	47.0	47.0475	46.9625	47.0025	12052.0
2018-06-18 06:00:00	AAPL	Stock	47.0	47.0	46.9	46.9025	12280.0
2018-06-18 07:00:00	AAPL	Stock	46.935	46.9525	46.875	46.875	143788.0
2018-06-18 08:00:00	AAPL	Stock	46.9125	46.9625	46.8525	46.9625	227820.0
2018-06-18 09:00:00	AAPL	Stock	46.96	47.0825	46.8	47.0188	9647896.0
2018-06-18 10:00:00	AAPL	Stock	47.015	47.305	46.93	47.2262	10591556.0
2018-06-18 11:00:00	AAPL	Stock	47.225	47.305	47.1825	47.23	6092424.0
2018-06-18 12:00:00	AAPL	Stock	47.2275	47.2825	47.1575	47.1975	4672772.0
2018-06-18 13:00:00	AAPL	Stock	47.1975	47.305	47.185	47.265	4458564.0
2018-06-18 14:00:00	AAPL	Stock	47.265	47.3025	47.2075	47.2425	4621820.0
2018-06-18 15:00:00	AAPL	Stock	47.2425	47.275	47.1675	47.19	10047508.0
2018-06-18 16:00:00	AAPL	Stock	47.185	47.2425	47.0925	47.175	13162520.0
2018-06-18 17:00:00	AAPL	Stock	47.2	47.207	47.1875	47.2	11984.0
2018-06-18 18:00:00	AAPL	Stock	47.1875	47.1875	47.1875	47.1875	500.0
2018-06-18 19:00:00	AAPL	Stock	47.1925	47.2	46.925	47.0825	69008.0
2018-06-18 04:00:00	MSFT	Stock	100.01	100.01	99.7	99.7	1203.0
2018-06-18 05:00:00	MSFT	Stock	99.89	99.89	99.86	99.86	600.0
2018-06-18 06:00:00	MSFT	Stock	99.72	99.79	99.52	99.55	1373.0
2018-06-18 07:00:00	MSFT	Stock	99.69	99.7	99.04	99.36	15233.0
2018-06-18 08:00:00	MSFT	Stock	99.601	100.13	99.3	99.95	101280.0
2018-06-18 09:00:00	MSFT	Stock	99.95	100.54	99.42	100.3	3619227.0
2018-06-18 10:00:00	MSFT	Stock	100.3	101.1	100.09	100.94	3598281.0
2018-06-18 11:00:00	MSFT	Stock	100.93	101.11	100.48	100.49	2361937.0
2018-06-18 12:00:00	MSFT	Stock	100.48	100.68	100.48	100.6	1840636.0
2018-06-18 13:00:00	MSFT	Stock	100.595	100.99	100.57	100.97	1617928.0
2018-06-18 14:00:00	MSFT	Stock	100.96	100.98	100.73	100.77	1987199.0
2018-06-18 15:00:00	MSFT	Stock	100.775	100.97	100.66	100.88	3142327.0
2018-06-18 16:00:00	MSFT	Stock	100.86	100.92	100.8	100.9	2209511.0
2018-06-18 17:00:00	MSFT	Stock	100.88	100.91	100.8	100.88	3146.0
2018-06-18 18:00:00	MSFT	Stock	100.86	100.86	100.86	100.86	126.0
2018-06-18 19:00:00	MSFT	Stock	100.9	100.9	100.26	100.26	4812.0
2018-06-18 04:00:00	NVDA	Stock	6.592	6.6125	6.592	6.6125	76440.0
2018-06-18 05:00:00	NVDA	Stock	6.595	6.5978	6.5938	6.5938	26400.0
2018-06-18 06:00:00	NVDA	Stock	6.5938	6.6045	6.5938	6.6002	214520.0
2018-06-18 07:00:00	NVDA	Stock	6.6075	6.625	6.5938	6.6	268520.0
2018-06-18 08:00:00	NVDA	Stock	6.6087	6.624	6.5888	6.605	1291480.0
2018-06-18 09:00:00	NVDA	Stock	6.6	6.645	6.5625	6.5775	59696240.0
2018-06-18 10:00:00	NVDA	Stock	6.5775	6.6098	6.5595	6.602	60435840.0
2018-06-18 11:00:00	NVDA	Stock	6.6032	6.6235	6.5759	6.58	38411160.0
2018-06-18 12:00:00	NVDA	Stock	6.5812	6.5876	6.5646	6.5711	24653240.0
2018-06-18 13:00:00	NVDA	Stock	6.5702	6.6002	6.5688	6.5968	22061280.0
2018-06-18 14:00:00	NVDA	Stock	6.5975	6.6135	6.584	6.6105	24914680.0
2018-06-18 15:00:00	NVDA	Stock	6.6102	6.6448	6.606	6.627	50391640.0
2018-06-18 16:00:00	NVDA	Stock	6.6272	6.6272	6.61	6.6115	14321880.0
2018-06-18 17:00:00	NVDA	Stock	6.618	6.6238	6.611	6.6238	7112840.0
2018-06-18 18:00:00	NVDA	Stock	6.625	6.6262	6.6178	6.625	117200.0
2018-06-18 19:00:00	NVDA	Stock	6.625	6.6275	6.575	6.5825	304560.0
2018-06-18 05:00:00	AMZN	Stock	85.5	85.5	85.5	85.5	2000.0
2018-06-18 07:00:00	AMZN	Stock	85.4	85.4	85.1535	85.1655	100980.0

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

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