PREVIEW / stock_1hour / 2019-01-17

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-01-17.parquet
  size:    1.1 MB
  rows:    49,719
  symbols: 2,683

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
2019-01-17 04:00:00	AAPL	Stock	38.5	38.5	38.4	38.4	28040.0
2019-01-17 05:00:00	AAPL	Stock	38.4	38.425	38.4	38.425	5512.0
2019-01-17 06:00:00	AAPL	Stock	38.425	38.48	38.4175	38.45	32676.0
2019-01-17 07:00:00	AAPL	Stock	38.48	38.525	38.425	38.485	69152.0
2019-01-17 08:00:00	AAPL	Stock	38.735	38.735	38.425	38.5475	406716.0
2019-01-17 09:00:00	AAPL	Stock	38.5475	38.735	38.315	38.4308	13794300.0
2019-01-17 10:00:00	AAPL	Stock	38.433	38.5525	38.365	38.47	13165296.0
2019-01-17 11:00:00	AAPL	Stock	38.47	38.6575	38.4012	38.5375	8776612.0
2019-01-17 12:00:00	AAPL	Stock	38.5375	38.65	38.4938	38.5668	6087820.0
2019-01-17 13:00:00	AAPL	Stock	38.5675	38.7175	38.5675	38.6575	6402052.0
2019-01-17 14:00:00	AAPL	Stock	38.655	39.415	38.515	38.9425	29793892.0
2019-01-17 15:00:00	AAPL	Stock	38.945	38.9675	38.77	38.965	20575612.0
2019-01-17 16:00:00	AAPL	Stock	38.965	38.975	38.75	38.9575	7665088.0
2019-01-17 17:00:00	AAPL	Stock	38.9575	38.965	38.9	38.95	73720.0
2019-01-17 18:00:00	AAPL	Stock	38.95	38.96	38.9125	38.95	74812.0
2019-01-17 19:00:00	AAPL	Stock	38.9525	39.1225	38.95	39.0	108768.0
2019-01-17 04:00:00	MSFT	Stock	104.75	104.75	104.75	104.75	100.0
2019-01-17 05:00:00	MSFT	Stock	104.55	104.73	104.55	104.73	200.0
2019-01-17 07:00:00	MSFT	Stock	105.0	105.0	104.75	104.83	2789.0
2019-01-17 08:00:00	MSFT	Stock	105.38	105.38	104.73	105.18	51820.0
2019-01-17 09:00:00	MSFT	Stock	105.2	106.08	104.76	106.02	2887799.0
2019-01-17 10:00:00	MSFT	Stock	106.028	106.129	105.03	105.365	3813339.0
2019-01-17 11:00:00	MSFT	Stock	105.37	105.54	105.3	105.505	2224473.0
2019-01-17 12:00:00	MSFT	Stock	105.505	105.73	105.24	105.32	1793935.0
2019-01-17 13:00:00	MSFT	Stock	105.32	105.575	105.3	105.56	1553595.0
2019-01-17 14:00:00	MSFT	Stock	105.55	106.625	105.35	105.91	4072765.0
2019-01-17 15:00:00	MSFT	Stock	105.91	106.18	105.61	106.15	4955336.0
2019-01-17 16:00:00	MSFT	Stock	106.12	106.36	105.84	106.3	3314142.0
2019-01-17 17:00:00	MSFT	Stock	106.27	106.31	106.15	106.31	18376.0
2019-01-17 18:00:00	MSFT	Stock	106.12	106.37	106.12	106.24	60543.0
2019-01-17 19:00:00	MSFT	Stock	106.21	106.5	106.15	106.35	14226.0
2019-01-17 04:00:00	NVDA	Stock	3.7	3.7	3.6925	3.6925	32640.0
2019-01-17 05:00:00	NVDA	Stock	3.6925	3.6995	3.6925	3.6995	57600.0
2019-01-17 06:00:00	NVDA	Stock	3.6975	3.6975	3.6875	3.69	83560.0
2019-01-17 07:00:00	NVDA	Stock	3.697	3.7	3.675	3.69	735440.0
2019-01-17 08:00:00	NVDA	Stock	3.721	3.721	3.682	3.6995	1010640.0
2019-01-17 09:00:00	NVDA	Stock	3.697	3.7163	3.6602	3.703	78669680.0
2019-01-17 10:00:00	NVDA	Stock	3.7028	3.7545	3.691	3.7527	60893880.0
2019-01-17 11:00:00	NVDA	Stock	3.7528	3.7745	3.7478	3.7584	56891520.0
2019-01-17 12:00:00	NVDA	Stock	3.758	3.77	3.7362	3.739	37724600.0
2019-01-17 13:00:00	NVDA	Stock	3.7382	3.765	3.7365	3.7637	32355960.0
2019-01-17 14:00:00	NVDA	Stock	3.7635	3.8333	3.7618	3.7827	90637960.0
2019-01-17 15:00:00	NVDA	Stock	3.7825	3.8	3.7678	3.793	73573440.0
2019-01-17 16:00:00	NVDA	Stock	3.793	3.806	3.7765	3.7998	18046920.0
2019-01-17 17:00:00	NVDA	Stock	3.7975	3.8025	3.7938	3.8	732960.0
2019-01-17 18:00:00	NVDA	Stock	3.7992	3.8105	3.795	3.8105	528040.0
2019-01-17 19:00:00	NVDA	Stock	3.805	3.8212	3.805	3.8088	469040.0
2019-01-17 05:00:00	AMZN	Stock	83.7395	83.7395	83.7395	83.7395	2000.0
2019-01-17 06:00:00	AMZN	Stock	83.7605	83.7605	83.75	83.75	10620.0
2019-01-17 07:00:00	AMZN	Stock	83.872	83.875	83.69	83.82	53320.0

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

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