PREVIEW / stock_1hour / 2019-04-02

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-04-02.parquet
  size:    1.1 MB
  rows:    50,088
  symbols: 2,640

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-04-02 04:00:00	AAPL	Stock	47.7025	47.7025	47.64	47.6425	3400.0
2019-04-02 05:00:00	AAPL	Stock	47.6975	47.6975	47.6975	47.6975	4000.0
2019-04-02 06:00:00	AAPL	Stock	47.7025	47.705	47.67	47.7	10904.0
2019-04-02 07:00:00	AAPL	Stock	47.7375	47.79	47.73	47.7525	30948.0
2019-04-02 08:00:00	AAPL	Stock	47.7375	47.9275	47.7	47.725	137232.0
2019-04-02 09:00:00	AAPL	Stock	47.7125	48.27	47.7	47.925	15121932.0
2019-04-02 10:00:00	AAPL	Stock	47.9225	48.2475	47.8825	48.1925	11557056.0
2019-04-02 11:00:00	AAPL	Stock	48.1925	48.2125	48.0275	48.145	7929696.0
2019-04-02 12:00:00	AAPL	Stock	48.1475	48.255	48.1275	48.2092	5800764.0
2019-04-02 13:00:00	AAPL	Stock	48.2075	48.4538	48.165	48.42	8060332.0
2019-04-02 14:00:00	AAPL	Stock	48.42	48.495	48.33	48.4925	7589536.0
2019-04-02 15:00:00	AAPL	Stock	48.4925	48.615	48.475	48.51	15334788.0
2019-04-02 16:00:00	AAPL	Stock	48.505	48.555	48.405	48.42	7396832.0
2019-04-02 17:00:00	AAPL	Stock	48.4375	48.45	48.4175	48.4175	33724.0
2019-04-02 18:00:00	AAPL	Stock	48.425	48.45	48.415	48.43	51224.0
2019-04-02 19:00:00	AAPL	Stock	48.43	48.45	48.3775	48.3775	69816.0
2019-04-02 05:00:00	MSFT	Stock	118.82	118.82	118.82	118.82	400.0
2019-04-02 06:00:00	MSFT	Stock	119.12	119.19	119.12	119.19	400.0
2019-04-02 07:00:00	MSFT	Stock	119.19	119.19	118.97	118.97	5679.0
2019-04-02 08:00:00	MSFT	Stock	119.1	119.19	119.0	119.1	3837.0
2019-04-02 09:00:00	MSFT	Stock	119.12	119.28	118.56	118.66	2164817.0
2019-04-02 10:00:00	MSFT	Stock	118.65	119.03	118.52	118.99	1989037.0
2019-04-02 11:00:00	MSFT	Stock	118.99	119.12	118.7	119.08	1361358.0
2019-04-02 12:00:00	MSFT	Stock	119.085	119.3	118.97	119.195	1399442.0
2019-04-02 13:00:00	MSFT	Stock	119.194	119.26	119.1	119.17	892642.0
2019-04-02 14:00:00	MSFT	Stock	119.174	119.32	119.05	119.273	1169954.0
2019-04-02 15:00:00	MSFT	Stock	119.27	119.48	119.14	119.18	2605656.0
2019-04-02 16:00:00	MSFT	Stock	119.19	119.3	119.022	119.07	1855288.0
2019-04-02 17:00:00	MSFT	Stock	119.03	119.14	119.03	119.14	1612.0
2019-04-02 18:00:00	MSFT	Stock	119.08	119.17	119.08	119.17	1294.0
2019-04-02 19:00:00	MSFT	Stock	119.17	119.17	119.08	119.08	2385.0
2019-04-02 04:00:00	NVDA	Stock	4.5788	4.5788	4.5785	4.5788	26000.0
2019-04-02 05:00:00	NVDA	Stock	4.576	4.5765	4.5588	4.576	31360.0
2019-04-02 06:00:00	NVDA	Stock	4.575	4.5862	4.5742	4.5862	43560.0
2019-04-02 07:00:00	NVDA	Stock	4.5778	4.5875	4.5678	4.5848	502400.0
2019-04-02 08:00:00	NVDA	Stock	4.575	4.5972	4.575	4.5862	1544240.0
2019-04-02 09:00:00	NVDA	Stock	4.585	4.6197	4.538	4.5467	102043080.0
2019-04-02 10:00:00	NVDA	Stock	4.5498	4.6092	4.5462	4.6065	76495880.0
2019-04-02 11:00:00	NVDA	Stock	4.6072	4.6098	4.5602	4.5758	54772520.0
2019-04-02 12:00:00	NVDA	Stock	4.5758	4.5803	4.553	4.559	34805840.0
2019-04-02 13:00:00	NVDA	Stock	4.559	4.5742	4.552	4.5595	37184520.0
2019-04-02 14:00:00	NVDA	Stock	4.56	4.574	4.5535	4.572	33553240.0
2019-04-02 15:00:00	NVDA	Stock	4.572	4.5833	4.572	4.575	58050760.0
2019-04-02 16:00:00	NVDA	Stock	4.575	4.575	4.5653	4.568	1578960.0
2019-04-02 17:00:00	NVDA	Stock	4.5718	4.5718	4.5665	4.5698	167720.0
2019-04-02 18:00:00	NVDA	Stock	4.5718	4.5745	4.5688	4.5737	109600.0
2019-04-02 19:00:00	NVDA	Stock	4.5737	4.5803	4.5708	4.575	424320.0
2019-04-02 05:00:00	AMZN	Stock	90.682	90.7445	90.682	90.7445	6000.0
2019-04-02 06:00:00	AMZN	Stock	90.7445	90.8	90.7445	90.755	14560.0
2019-04-02 07:00:00	AMZN	Stock	90.85	90.874	90.7165	90.7945	84380.0

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

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