PREVIEW / stock_1hour / 2018-03-20

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-03-20.parquet
  size:    1.1 MB
  rows:    48,439
  symbols: 2,889

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-03-20 04:00:00	AAPL	Stock	43.8775	43.8775	43.875	43.875	1200.0
2018-03-20 05:00:00	AAPL	Stock	43.8675	43.8725	43.8675	43.8725	5196.0
2018-03-20 06:00:00	AAPL	Stock	43.835	43.895	43.7875	43.895	3424.0
2018-03-20 07:00:00	AAPL	Stock	43.85	44.0575	43.85	44.0	102096.0
2018-03-20 08:00:00	AAPL	Stock	44.045	44.0625	43.835	43.9725	305516.0
2018-03-20 09:00:00	AAPL	Stock	43.975	44.2	43.8	44.0575	10722768.0
2018-03-20 10:00:00	AAPL	Stock	44.0612	44.1	43.88	44.035	10838328.0
2018-03-20 11:00:00	AAPL	Stock	44.04	44.09	43.8425	43.915	8826336.0
2018-03-20 12:00:00	AAPL	Stock	43.9225	44.075	43.89	43.965	6503216.0
2018-03-20 13:00:00	AAPL	Stock	43.965	43.9875	43.7488	43.7775	7453812.0
2018-03-20 14:00:00	AAPL	Stock	43.7825	43.9425	43.735	43.925	6166748.0
2018-03-20 15:00:00	AAPL	Stock	43.92	43.9875	43.785	43.8125	10921728.0
2018-03-20 16:00:00	AAPL	Stock	43.81	43.84	43.8075	43.8375	8257384.0
2018-03-20 17:00:00	AAPL	Stock	43.8275	43.84	43.8175	43.84	35028.0
2018-03-20 18:00:00	AAPL	Stock	43.835	43.8425	43.8125	43.825	58196.0
2018-03-20 19:00:00	AAPL	Stock	43.815	43.8425	43.815	43.8425	12716.0
2018-03-20 04:00:00	MSFT	Stock	93.05	93.11	93.02	93.02	441.0
2018-03-20 05:00:00	MSFT	Stock	93.02	93.02	92.88	93.02	1148.0
2018-03-20 06:00:00	MSFT	Stock	92.98	92.98	92.98	92.98	100.0
2018-03-20 07:00:00	MSFT	Stock	93.08	93.4	93.08	93.4	800.0
2018-03-20 08:00:00	MSFT	Stock	93.467	93.49	93.15	93.26	30367.0
2018-03-20 09:00:00	MSFT	Stock	93.25	93.77	93.0	93.54	2471780.0
2018-03-20 10:00:00	MSFT	Stock	93.545	93.66	93.07	93.425	2941162.0
2018-03-20 11:00:00	MSFT	Stock	93.42	93.55	93.09	93.27	2177436.0
2018-03-20 12:00:00	MSFT	Stock	93.28	93.62	93.19	93.46	1895084.0
2018-03-20 13:00:00	MSFT	Stock	93.466	93.59	93.23	93.255	1560177.0
2018-03-20 14:00:00	MSFT	Stock	93.26	93.6	93.16	93.49	1805890.0
2018-03-20 15:00:00	MSFT	Stock	93.48	93.65	93.09	93.14	3902376.0
2018-03-20 16:00:00	MSFT	Stock	93.13	93.28	93.06	93.25	3125411.0
2018-03-20 17:00:00	MSFT	Stock	93.21	93.22	93.15	93.15	615.0
2018-03-20 18:00:00	MSFT	Stock	93.16	93.29	93.16	93.17	1598.0
2018-03-20 04:00:00	NVDA	Stock	6.0392	6.0392	6.0392	6.0392	20360.0
2018-03-20 05:00:00	NVDA	Stock	6.0392	6.0392	6.025	6.0275	327000.0
2018-03-20 06:00:00	NVDA	Stock	6.03	6.045	6.03	6.045	227000.0
2018-03-20 07:00:00	NVDA	Stock	6.05	6.075	6.0438	6.0675	983600.0
2018-03-20 08:00:00	NVDA	Stock	6.0682	6.075	6.0478	6.053	2392320.0
2018-03-20 09:00:00	NVDA	Stock	6.053	6.1255	6.0165	6.0785	87072360.0
2018-03-20 10:00:00	NVDA	Stock	6.0798	6.1562	6.0798	6.1562	113828800.0
2018-03-20 11:00:00	NVDA	Stock	6.156	6.1658	6.107	6.133	58033800.0
2018-03-20 12:00:00	NVDA	Stock	6.1338	6.183	6.1199	6.17	43549520.0
2018-03-20 13:00:00	NVDA	Stock	6.1698	6.199	6.1568	6.1855	47117560.0
2018-03-20 14:00:00	NVDA	Stock	6.186	6.2585	6.1752	6.2525	80231240.0
2018-03-20 15:00:00	NVDA	Stock	6.2533	6.2788	6.2305	6.2395	102941120.0
2018-03-20 16:00:00	NVDA	Stock	6.2395	6.2408	6.225	6.2395	3315000.0
2018-03-20 17:00:00	NVDA	Stock	6.239	6.239	6.23	6.2312	1007760.0
2018-03-20 18:00:00	NVDA	Stock	6.235	6.2395	6.2328	6.239	848080.0
2018-03-20 19:00:00	NVDA	Stock	6.2388	6.2438	6.2338	6.2438	605920.0
2018-03-20 04:00:00	AMZN	Stock	77.462	77.4625	77.462	77.4625	4000.0
2018-03-20 05:00:00	AMZN	Stock	77.4	77.4	77.4	77.4	2000.0
2018-03-20 06:00:00	AMZN	Stock	77.386	77.386	77.386	77.386	2380.0

> showing 50 of 48,439 rows — these rows as CSV

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