PREVIEW / stock_1hour / 2018-06-25

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-06-25.parquet
  size:    1.1 MB
  rows:    50,978
  symbols: 2,815

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-06-25 04:00:00	AAPL	Stock	46.125	46.125	45.8775	45.8775	12036.0
2018-06-25 05:00:00	AAPL	Stock	45.8	45.8875	45.675	45.7125	26360.0
2018-06-25 06:00:00	AAPL	Stock	45.75	45.775	45.6875	45.75	48612.0
2018-06-25 07:00:00	AAPL	Stock	45.75	45.8475	45.6775	45.83	232784.0
2018-06-25 08:00:00	AAPL	Stock	45.7025	45.9125	45.7	45.8075	457392.0
2018-06-25 09:00:00	AAPL	Stock	45.8025	46.23	45.745	45.835	13349924.0
2018-06-25 10:00:00	AAPL	Stock	45.825	46.025	45.7825	45.84	14036828.0
2018-06-25 11:00:00	AAPL	Stock	45.84	45.8725	45.545	45.58	13001148.0
2018-06-25 12:00:00	AAPL	Stock	45.5825	45.595	45.1875	45.3025	14926500.0
2018-06-25 13:00:00	AAPL	Stock	45.3	45.5675	45.21	45.4425	10187664.0
2018-06-25 14:00:00	AAPL	Stock	45.445	45.4762	45.1825	45.275	8210428.0
2018-06-25 15:00:00	AAPL	Stock	45.2775	45.71	45.23	45.545	21132316.0
2018-06-25 16:00:00	AAPL	Stock	45.5425	45.7005	45.4275	45.5252	10788584.0
2018-06-25 17:00:00	AAPL	Stock	45.5425	45.5425	45.505	45.5075	14352.0
2018-06-25 18:00:00	AAPL	Stock	45.5375	45.575	45.525	45.5625	22120.0
2018-06-25 19:00:00	AAPL	Stock	45.5625	45.5625	45.515	45.5425	60372.0
2018-06-25 05:00:00	MSFT	Stock	99.8	99.8	99.63	99.69	3369.0
2018-06-25 06:00:00	MSFT	Stock	99.7	100.2	99.7	99.89	21518.0
2018-06-25 07:00:00	MSFT	Stock	99.86	100.0	99.86	100.0	11573.0
2018-06-25 08:00:00	MSFT	Stock	99.99	100.29	99.91	100.05	42402.0
2018-06-25 09:00:00	MSFT	Stock	100.01	100.22	99.01	99.43	3549933.0
2018-06-25 10:00:00	MSFT	Stock	99.42	99.6	98.67	98.93	5043249.0
2018-06-25 11:00:00	MSFT	Stock	98.93	99.09	98.45	98.48	3270584.0
2018-06-25 12:00:00	MSFT	Stock	98.48	98.53	97.67	98.09	5011024.0
2018-06-25 13:00:00	MSFT	Stock	98.08	98.4	97.75	98.09	2768882.0
2018-06-25 14:00:00	MSFT	Stock	98.09	98.2	97.3	97.505	3308373.0
2018-06-25 15:00:00	MSFT	Stock	97.5	98.68	97.46	98.39	5900607.0
2018-06-25 16:00:00	MSFT	Stock	98.39	98.75	98.34	98.4	2999941.0
2018-06-25 17:00:00	MSFT	Stock	98.51	98.59	98.35	98.59	2094.0
2018-06-25 18:00:00	MSFT	Stock	98.58	98.59	98.5	98.59	1300.0
2018-06-25 19:00:00	MSFT	Stock	98.41	98.5	98.4	98.5	1265.0
2018-06-25 04:00:00	NVDA	Stock	6.1942	6.1942	6.1595	6.1595	52160.0
2018-06-25 05:00:00	NVDA	Stock	6.1592	6.1592	6.15	6.1538	210160.0
2018-06-25 06:00:00	NVDA	Stock	6.155	6.1675	6.1415	6.1415	145560.0
2018-06-25 07:00:00	NVDA	Stock	6.1532	6.1875	6.15	6.1795	921040.0
2018-06-25 08:00:00	NVDA	Stock	6.1675	6.1988	6.1538	6.1748	1463520.0
2018-06-25 09:00:00	NVDA	Stock	6.174	6.1758	6.042	6.0798	79809400.0
2018-06-25 10:00:00	NVDA	Stock	6.0798	6.0958	5.9858	5.9959	94259200.0
2018-06-25 11:00:00	NVDA	Stock	5.995	5.9953	5.93	5.9435	89095960.0
2018-06-25 12:00:00	NVDA	Stock	5.9437	5.9475	5.8885	5.9465	88113880.0
2018-06-25 13:00:00	NVDA	Stock	5.9461	5.981	5.913	5.9553	56180320.0
2018-06-25 14:00:00	NVDA	Stock	5.9553	5.9625	5.8992	5.9211	39938720.0
2018-06-25 15:00:00	NVDA	Stock	5.9208	5.995	5.9065	5.979	84993080.0
2018-06-25 16:00:00	NVDA	Stock	5.978	5.9988	5.975	5.9988	24863200.0
2018-06-25 17:00:00	NVDA	Stock	5.9888	5.9898	5.9725	5.9746	310520.0
2018-06-25 18:00:00	NVDA	Stock	5.9793	5.9875	5.9778	5.98	396280.0
2018-06-25 19:00:00	NVDA	Stock	5.9812	5.9838	5.9725	5.9725	102280.0
2018-06-25 04:00:00	AMZN	Stock	85.1425	85.1425	84.81	84.9235	40060.0
2018-06-25 05:00:00	AMZN	Stock	84.8	84.87	84.675	84.8575	48600.0
2018-06-25 06:00:00	AMZN	Stock	84.8575	84.8575	84.75	84.7755	13460.0

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

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