PREVIEW / stock_1hour / 2018-04-17

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-04-17.parquet
  size:    1.1 MB
  rows:    49,195
  symbols: 2,853

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-04-17 04:00:00	AAPL	Stock	44.1275	44.3	44.1275	44.165	31428.0
2018-04-17 05:00:00	AAPL	Stock	44.15	44.25	44.15	44.25	7376.0
2018-04-17 06:00:00	AAPL	Stock	44.27	44.275	44.195	44.25	19524.0
2018-04-17 07:00:00	AAPL	Stock	44.2	44.25	44.1575	44.23	79868.0
2018-04-17 08:00:00	AAPL	Stock	44.17	44.2625	44.17	44.18	219064.0
2018-04-17 09:00:00	AAPL	Stock	44.175	44.345	44.1025	44.2475	12860148.0
2018-04-17 10:00:00	AAPL	Stock	44.2495	44.4625	44.2425	44.4465	13698948.0
2018-04-17 11:00:00	AAPL	Stock	44.4525	44.6225	44.4512	44.595	12400428.0
2018-04-17 12:00:00	AAPL	Stock	44.5975	44.665	44.5	44.5425	7909476.0
2018-04-17 13:00:00	AAPL	Stock	44.5425	44.6225	44.4575	44.6125	7403076.0
2018-04-17 14:00:00	AAPL	Stock	44.6075	44.665	44.555	44.62	8450868.0
2018-04-17 15:00:00	AAPL	Stock	44.6198	44.734	44.515	44.56	14977808.0
2018-04-17 16:00:00	AAPL	Stock	44.56	44.625	44.5375	44.555	10742112.0
2018-04-17 17:00:00	AAPL	Stock	44.5575	44.5625	44.5	44.5	165708.0
2018-04-17 18:00:00	AAPL	Stock	44.525	44.53	44.5	44.53	20948.0
2018-04-17 19:00:00	AAPL	Stock	44.53	44.5575	44.525	44.5575	20488.0
2018-04-17 04:00:00	MSFT	Stock	94.61	94.7	94.61	94.7	5033.0
2018-04-17 05:00:00	MSFT	Stock	94.79	94.82	94.78	94.78	1788.0
2018-04-17 06:00:00	MSFT	Stock	94.73	94.73	94.73	94.73	150.0
2018-04-17 07:00:00	MSFT	Stock	94.78	94.96	94.75	94.95	7358.0
2018-04-17 08:00:00	MSFT	Stock	94.84	95.1	94.75	95.01	51750.0
2018-04-17 09:00:00	MSFT	Stock	95.0	95.42	94.87	95.34	2856165.0
2018-04-17 10:00:00	MSFT	Stock	95.34	96.05	95.32	96.03	3865100.0
2018-04-17 11:00:00	MSFT	Stock	96.03	96.53	96.03	96.395	3376547.0
2018-04-17 12:00:00	MSFT	Stock	96.4	96.515	96.17	96.29	2148503.0
2018-04-17 13:00:00	MSFT	Stock	96.3	96.49	96.12	96.35	1967170.0
2018-04-17 14:00:00	MSFT	Stock	96.345	96.54	96.2	96.405	2198082.0
2018-04-17 15:00:00	MSFT	Stock	96.405	96.47	95.98	96.06	4027815.0
2018-04-17 16:00:00	MSFT	Stock	96.07	96.2	95.95	96.14	2638590.0
2018-04-17 17:00:00	MSFT	Stock	96.06	96.09	95.96	95.96	9427.0
2018-04-17 18:00:00	MSFT	Stock	96.0	96.07	96.0	96.07	805.0
2018-04-17 19:00:00	MSFT	Stock	96.15	96.15	96.05	96.06	3182.0
2018-04-17 05:00:00	NVDA	Stock	5.8218	5.8218	5.8215	5.8215	78200.0
2018-04-17 06:00:00	NVDA	Stock	5.825	5.825	5.825	5.825	48000.0
2018-04-17 07:00:00	NVDA	Stock	5.825	5.8463	5.825	5.8375	409720.0
2018-04-17 08:00:00	NVDA	Stock	5.8313	5.8468	5.8263	5.8338	1185640.0
2018-04-17 09:00:00	NVDA	Stock	5.8338	5.865	5.8062	5.8355	51066640.0
2018-04-17 10:00:00	NVDA	Stock	5.837	5.8413	5.7838	5.794	67968280.0
2018-04-17 11:00:00	NVDA	Stock	5.794	5.8988	5.794	5.8817	72629240.0
2018-04-17 12:00:00	NVDA	Stock	5.8825	5.9194	5.88	5.9103	44535880.0
2018-04-17 13:00:00	NVDA	Stock	5.9092	5.9268	5.8948	5.9223	31314240.0
2018-04-17 14:00:00	NVDA	Stock	5.9228	5.95	5.9103	5.9406	54977080.0
2018-04-17 15:00:00	NVDA	Stock	5.9402	5.96	5.9268	5.9388	61700800.0
2018-04-17 16:00:00	NVDA	Stock	5.9385	5.95	5.9285	5.9325	12852840.0
2018-04-17 17:00:00	NVDA	Stock	5.937	5.937	5.8978	5.8978	800960.0
2018-04-17 18:00:00	NVDA	Stock	5.8975	5.911	5.8975	5.9025	210040.0
2018-04-17 19:00:00	NVDA	Stock	5.9002	5.9138	5.9002	5.904	200400.0
2018-04-17 04:00:00	AMZN	Stock	72.55	72.55	72.55	72.55	2000.0
2018-04-17 07:00:00	AMZN	Stock	72.632	72.765	72.576	72.755	132140.0
2018-04-17 08:00:00	AMZN	Stock	72.795	72.95	72.576	72.775	354740.0

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

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