PREVIEW / stock_1hour / 2018-12-28

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-12-28.parquet
  size:    1.1 MB
  rows:    51,206
  symbols: 2,737

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-12-28 04:00:00	AAPL	Stock	38.75	39.25	38.75	39.25	17148.0
2018-12-28 05:00:00	AAPL	Stock	39.3125	39.3625	39.3125	39.3575	25480.0
2018-12-28 06:00:00	AAPL	Stock	39.3125	39.45	39.2875	39.3425	34584.0
2018-12-28 07:00:00	AAPL	Stock	39.305	39.375	39.125	39.285	135448.0
2018-12-28 08:00:00	AAPL	Stock	39.1875	39.3705	39.1875	39.31	516012.0
2018-12-28 09:00:00	AAPL	Stock	39.3075	39.4125	38.7975	39.1825	21532948.0
2018-12-28 10:00:00	AAPL	Stock	39.1862	39.21	38.6375	38.8262	24550748.0
2018-12-28 11:00:00	AAPL	Stock	38.83	39.298	38.75	39.23	18498900.0
2018-12-28 12:00:00	AAPL	Stock	39.2312	39.3075	39.0075	39.0525	13970208.0
2018-12-28 13:00:00	AAPL	Stock	39.0543	39.105	38.8175	39.0075	11205036.0
2018-12-28 14:00:00	AAPL	Stock	39.0125	39.63	39.0125	39.6025	18879156.0
2018-12-28 15:00:00	AAPL	Stock	39.6	39.6275	38.9175	39.0575	26238984.0
2018-12-28 16:00:00	AAPL	Stock	39.0575	39.125	39.0575	39.125	9384920.0
2018-12-28 17:00:00	AAPL	Stock	39.0925	39.1375	39.0925	39.1225	43644.0
2018-12-28 18:00:00	AAPL	Stock	39.125	39.15	39.005	39.0825	2130800.0
2018-12-28 19:00:00	AAPL	Stock	39.0825	39.095	39.05	39.095	21484.0
2018-12-28 04:00:00	MSFT	Stock	101.15	101.72	101.15	101.6	840.0
2018-12-28 05:00:00	MSFT	Stock	101.79	102.07	101.74	101.99	5859.0
2018-12-28 06:00:00	MSFT	Stock	101.98	102.29	101.89	102.1	12273.0
2018-12-28 07:00:00	MSFT	Stock	102.0	102.17	101.46	101.69	23782.0
2018-12-28 08:00:00	MSFT	Stock	102.252	102.252	101.52	101.84	45362.0
2018-12-28 09:00:00	MSFT	Stock	101.85	102.41	100.5	101.15	4696033.0
2018-12-28 10:00:00	MSFT	Stock	101.141	101.22	99.52	100.11	5612488.0
2018-12-28 11:00:00	MSFT	Stock	100.11	101.1	99.768	100.9	4303534.0
2018-12-28 12:00:00	MSFT	Stock	100.91	101.285	100.524	100.75	2668643.0
2018-12-28 13:00:00	MSFT	Stock	100.75	101.08	100.26	100.9	2575395.0
2018-12-28 14:00:00	MSFT	Stock	100.91	102.29	100.9	102.121	4137115.0
2018-12-28 15:00:00	MSFT	Stock	102.126	102.251	100.0	100.4	6691631.0
2018-12-28 16:00:00	MSFT	Stock	100.39	100.41	100.1	100.25	3313690.0
2018-12-28 17:00:00	MSFT	Stock	100.4	100.48	100.33	100.37	2734.0
2018-12-28 18:00:00	MSFT	Stock	100.33	100.48	100.25	100.48	1240.0
2018-12-28 19:00:00	MSFT	Stock	100.31	100.44	100.26	100.31	3359.0
2018-12-28 04:00:00	NVDA	Stock	3.2805	3.2805	3.2805	3.2805	31400.0
2018-12-28 05:00:00	NVDA	Stock	3.3075	3.325	3.3075	3.3182	75320.0
2018-12-28 06:00:00	NVDA	Stock	3.319	3.319	3.3132	3.3132	15600.0
2018-12-28 07:00:00	NVDA	Stock	3.3108	3.3175	3.295	3.3112	678080.0
2018-12-28 08:00:00	NVDA	Stock	3.3062	3.315	3.2875	3.2955	1849640.0
2018-12-28 09:00:00	NVDA	Stock	3.2955	3.3685	3.2578	3.362	87525920.0
2018-12-28 10:00:00	NVDA	Stock	3.3604	3.3672	3.2925	3.3353	99829880.0
2018-12-28 11:00:00	NVDA	Stock	3.337	3.3568	3.3165	3.3388	62066600.0
2018-12-28 12:00:00	NVDA	Stock	3.341	3.3845	3.3405	3.36	69902040.0
2018-12-28 13:00:00	NVDA	Stock	3.3598	3.3715	3.3343	3.3628	42544920.0
2018-12-28 14:00:00	NVDA	Stock	3.362	3.4312	3.362	3.4288	80814920.0
2018-12-28 15:00:00	NVDA	Stock	3.4288	3.4348	3.325	3.3413	106100920.0
2018-12-28 16:00:00	NVDA	Stock	3.3413	3.3438	3.33	3.3413	3483120.0
2018-12-28 17:00:00	NVDA	Stock	3.342	3.3455	3.3383	3.3425	345960.0
2018-12-28 18:00:00	NVDA	Stock	3.3438	3.3468	3.3408	3.3425	60960.0
2018-12-28 19:00:00	NVDA	Stock	3.3413	3.3462	3.3413	3.3462	253640.0
2018-12-28 04:00:00	AMZN	Stock	73.6215	73.7495	73.6215	73.7495	9600.0
2018-12-28 05:00:00	AMZN	Stock	73.919	74.05	73.919	74.0	15240.0

> showing 50 of 51,206 rows — these rows as CSV

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