PREVIEW / stock_1hour / 2018-06-04

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-06-04.parquet
  size:    1.1 MB
  rows:    50,062
  symbols: 2,835

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-04 04:00:00	AAPL	Stock	47.69	47.86	47.69	47.86	17824.0
2018-06-04 05:00:00	AAPL	Stock	47.805	47.8625	47.805	47.845	7672.0
2018-06-04 06:00:00	AAPL	Stock	47.825	47.825	47.75	47.75	60156.0
2018-06-04 07:00:00	AAPL	Stock	47.685	47.8075	47.67	47.7975	334872.0
2018-06-04 08:00:00	AAPL	Stock	47.7	47.9475	47.6875	47.915	643216.0
2018-06-04 09:00:00	AAPL	Stock	47.905	48.2275	47.8225	48.0575	19058452.0
2018-06-04 10:00:00	AAPL	Stock	48.06	48.1225	47.9025	48.0375	13069048.0
2018-06-04 11:00:00	AAPL	Stock	48.04	48.12	47.965	48.1093	7202944.0
2018-06-04 12:00:00	AAPL	Stock	48.11	48.355	48.105	48.2075	14185720.0
2018-06-04 13:00:00	AAPL	Stock	48.2062	48.2975	48.0025	48.06	10061024.0
2018-06-04 14:00:00	AAPL	Stock	48.0575	48.085	47.91	48.0175	9702964.0
2018-06-04 15:00:00	AAPL	Stock	48.0155	48.055	47.86	47.9525	12735072.0
2018-06-04 16:00:00	AAPL	Stock	47.9575	47.985	47.95	47.98	4963788.0
2018-06-04 17:00:00	AAPL	Stock	47.98	48.07	47.98	48.06	185596.0
2018-06-04 18:00:00	AAPL	Stock	48.06	48.1075	48.06	48.0875	131604.0
2018-06-04 19:00:00	AAPL	Stock	48.0925	48.1075	48.0675	48.0875	46932.0
2018-06-04 04:00:00	MSFT	Stock	101.0	102.0	101.0	101.62	2147.0
2018-06-04 05:00:00	MSFT	Stock	101.4	101.4	101.39	101.39	1300.0
2018-06-04 06:00:00	MSFT	Stock	101.66	101.66	101.56	101.6	848.0
2018-06-04 07:00:00	MSFT	Stock	101.59	101.6	101.21	101.39	17731.0
2018-06-04 08:00:00	MSFT	Stock	101.37	101.69	101.0	101.47	37192.0
2018-06-04 09:00:00	MSFT	Stock	101.47	101.96	101.05	101.37	4449422.0
2018-06-04 10:00:00	MSFT	Stock	101.37	101.52	100.851	101.45	3897361.0
2018-06-04 11:00:00	MSFT	Stock	101.46	101.69	101.08	101.31	2425174.0
2018-06-04 12:00:00	MSFT	Stock	101.315	101.86	101.24	101.68	2537862.0
2018-06-04 13:00:00	MSFT	Stock	101.676	101.72	101.4	101.41	2078403.0
2018-06-04 14:00:00	MSFT	Stock	101.42	101.65	101.33	101.47	2293664.0
2018-06-04 15:00:00	MSFT	Stock	101.46	101.75	101.35	101.66	4585974.0
2018-06-04 16:00:00	MSFT	Stock	101.67	101.67	101.51	101.6	2474179.0
2018-06-04 17:00:00	MSFT	Stock	101.67	101.67	101.63	101.65	5487.0
2018-06-04 18:00:00	MSFT	Stock	101.6	101.65	101.6	101.65	3527.0
2018-06-04 19:00:00	MSFT	Stock	101.64	101.7	101.63	101.7	7703.0
2018-06-04 04:00:00	NVDA	Stock	6.4548	6.4575	6.45	6.4575	196640.0
2018-06-04 05:00:00	NVDA	Stock	6.46	6.4685	6.4548	6.4683	73680.0
2018-06-04 06:00:00	NVDA	Stock	6.475	6.4905	6.4728	6.4728	156920.0
2018-06-04 07:00:00	NVDA	Stock	6.4688	6.4808	6.4662	6.4675	784400.0
2018-06-04 08:00:00	NVDA	Stock	6.475	6.485	6.4662	6.4812	2160960.0
2018-06-04 09:00:00	NVDA	Stock	6.478	6.4958	6.4425	6.491	78625800.0
2018-06-04 10:00:00	NVDA	Stock	6.4908	6.531	6.4526	6.5272	97749800.0
2018-06-04 11:00:00	NVDA	Stock	6.528	6.5925	6.5082	6.5908	97349240.0
2018-06-04 12:00:00	NVDA	Stock	6.5907	6.625	6.5855	6.6115	73253960.0
2018-06-04 13:00:00	NVDA	Stock	6.6105	6.6248	6.5975	6.6201	40868680.0
2018-06-04 14:00:00	NVDA	Stock	6.6207	6.6435	6.6112	6.6309	55307000.0
2018-06-04 15:00:00	NVDA	Stock	6.6305	6.6325	6.5988	6.6213	75960840.0
2018-06-04 16:00:00	NVDA	Stock	6.6213	6.6215	6.6113	6.6188	18856960.0
2018-06-04 17:00:00	NVDA	Stock	6.6152	6.6213	6.6152	6.6213	491120.0
2018-06-04 18:00:00	NVDA	Stock	6.62	6.6248	6.62	6.6213	147920.0
2018-06-04 19:00:00	NVDA	Stock	6.6225	6.63	6.6225	6.625	467720.0
2018-06-04 04:00:00	AMZN	Stock	82.451	82.451	82.4	82.45	14980.0
2018-06-04 05:00:00	AMZN	Stock	82.477	82.4855	82.45	82.45	26080.0

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

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