PREVIEW / stock_1hour / 2018-06-15

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-06-15.parquet
  size:    1.1 MB
  rows:    49,934
  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-15 04:00:00	AAPL	Stock	47.545	47.6825	47.545	47.6825	2452.0
2018-06-15 05:00:00	AAPL	Stock	47.625	47.625	47.5725	47.5725	8164.0
2018-06-15 06:00:00	AAPL	Stock	47.5725	47.575	47.4525	47.505	36148.0
2018-06-15 07:00:00	AAPL	Stock	47.5475	47.6375	47.5	47.6025	92592.0
2018-06-15 08:00:00	AAPL	Stock	47.575	47.8	47.45	47.4725	389552.0
2018-06-15 09:00:00	AAPL	Stock	47.4625	47.68	47.2178	47.315	40593156.0
2018-06-15 10:00:00	AAPL	Stock	47.3175	47.3725	47.065	47.183	15979756.0
2018-06-15 11:00:00	AAPL	Stock	47.1825	47.3175	47.075	47.2775	11679172.0
2018-06-15 12:00:00	AAPL	Stock	47.275	47.28	47.175	47.21	6461696.0
2018-06-15 13:00:00	AAPL	Stock	47.21	47.305	47.1575	47.1675	8360128.0
2018-06-15 14:00:00	AAPL	Stock	47.1675	47.3725	47.1375	47.3075	10199284.0
2018-06-15 15:00:00	AAPL	Stock	47.3065	47.3175	47.1375	47.23	21554396.0
2018-06-15 16:00:00	AAPL	Stock	47.21	47.2475	47.15	47.2	90631596.0
2018-06-15 17:00:00	AAPL	Stock	47.185	47.21	46.922	47.17	346532.0
2018-06-15 18:00:00	AAPL	Stock	47.1925	47.2225	47.17	47.2225	21640.0
2018-06-15 19:00:00	AAPL	Stock	47.2	47.205	47.1875	47.2	11860.0
2018-06-15 07:00:00	MSFT	Stock	101.3	101.39	101.04	101.34	2032.0
2018-06-15 08:00:00	MSFT	Stock	101.047	101.38	100.9	101.02	32032.0
2018-06-15 09:00:00	MSFT	Stock	101.05	102.0	100.26	100.84	13971813.0
2018-06-15 10:00:00	MSFT	Stock	100.85	101.24	100.64	101.11	3554728.0
2018-06-15 11:00:00	MSFT	Stock	101.105	101.18	100.62	100.758	2280021.0
2018-06-15 12:00:00	MSFT	Stock	100.75	100.99	100.62	100.96	1485595.0
2018-06-15 13:00:00	MSFT	Stock	100.96	100.99	100.62	100.67	1402179.0
2018-06-15 14:00:00	MSFT	Stock	100.68	101.15	100.64	101.09	1889970.0
2018-06-15 15:00:00	MSFT	Stock	101.085	101.235	100.07	100.22	8753178.0
2018-06-15 16:00:00	MSFT	Stock	100.17	100.29	100.06	100.17	26757518.0
2018-06-15 17:00:00	MSFT	Stock	100.15	100.19	100.0	100.1	29425.0
2018-06-15 18:00:00	MSFT	Stock	100.06	100.13	100.06	100.07	3943.0
2018-06-15 19:00:00	MSFT	Stock	100.06	100.13	100.05	100.1	7421.0
2018-06-15 04:00:00	NVDA	Stock	6.6692	6.6875	6.6565	6.6565	258000.0
2018-06-15 05:00:00	NVDA	Stock	6.659	6.659	6.6543	6.6543	72280.0
2018-06-15 06:00:00	NVDA	Stock	6.6578	6.6588	6.6578	6.6588	16000.0
2018-06-15 07:00:00	NVDA	Stock	6.6658	6.6675	6.65	6.6675	551320.0
2018-06-15 08:00:00	NVDA	Stock	6.6552	6.6735	6.6262	6.63	1873160.0
2018-06-15 09:00:00	NVDA	Stock	6.6275	6.6546	6.5837	6.6515	87051160.0
2018-06-15 10:00:00	NVDA	Stock	6.6512	6.687	6.6395	6.6625	62874480.0
2018-06-15 11:00:00	NVDA	Stock	6.663	6.6728	6.6252	6.6474	35646760.0
2018-06-15 12:00:00	NVDA	Stock	6.6468	6.6514	6.6238	6.6495	25151200.0
2018-06-15 13:00:00	NVDA	Stock	6.649	6.6568	6.6328	6.6368	19489720.0
2018-06-15 14:00:00	NVDA	Stock	6.638	6.6613	6.6275	6.647	29565680.0
2018-06-15 15:00:00	NVDA	Stock	6.6475	6.6475	6.6215	6.6345	49442720.0
2018-06-15 16:00:00	NVDA	Stock	6.6323	6.639	6.6218	6.6288	56605600.0
2018-06-15 17:00:00	NVDA	Stock	6.6238	6.6375	6.6238	6.631	391200.0
2018-06-15 18:00:00	NVDA	Stock	6.635	6.635	6.6268	6.627	291760.0
2018-06-15 19:00:00	NVDA	Stock	6.627	6.6318	6.6262	6.6262	101040.0
2018-06-15 04:00:00	AMZN	Stock	86.0025	86.0025	86.0025	86.0025	2000.0
2018-06-15 06:00:00	AMZN	Stock	85.9645	85.9645	85.9645	85.9645	2000.0
2018-06-15 07:00:00	AMZN	Stock	85.9375	86.1	85.9255	86.1	46260.0
2018-06-15 08:00:00	AMZN	Stock	86.005	86.39	85.75	85.775	297980.0
2018-06-15 09:00:00	AMZN	Stock	85.7995	85.999	85.426	85.898	21902800.0

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

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