PREVIEW / stock_1hour / 2018-05-07

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-05-07.parquet
  size:    1.1 MB
  rows:    49,185
  symbols: 2,866

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-05-07 04:00:00	AAPL	Stock	46.115	46.215	46.0575	46.185	42904.0
2018-05-07 05:00:00	AAPL	Stock	46.2	46.2225	46.125	46.125	45236.0
2018-05-07 06:00:00	AAPL	Stock	46.125	46.2	46.115	46.115	17724.0
2018-05-07 07:00:00	AAPL	Stock	46.1475	46.225	46.1125	46.175	619404.0
2018-05-07 08:00:00	AAPL	Stock	46.1925	46.375	46.13	46.27	1505700.0
2018-05-07 09:00:00	AAPL	Stock	46.27	46.72	46.2575	46.6175	31268600.0
2018-05-07 10:00:00	AAPL	Stock	46.6225	46.9175	46.4775	46.8412	32033708.0
2018-05-07 11:00:00	AAPL	Stock	46.845	46.87	46.705	46.8452	14267520.0
2018-05-07 12:00:00	AAPL	Stock	46.8462	46.8528	46.2925	46.4175	18390404.0
2018-05-07 13:00:00	AAPL	Stock	46.42	46.6	46.2075	46.565	14680692.0
2018-05-07 14:00:00	AAPL	Stock	46.5675	46.645	46.3225	46.3775	13129396.0
2018-05-07 15:00:00	AAPL	Stock	46.3772	46.495	46.1875	46.2825	21756068.0
2018-05-07 16:00:00	AAPL	Stock	46.29	46.5698	46.2525	46.275	6450728.0
2018-05-07 17:00:00	AAPL	Stock	46.275	46.275	46.2275	46.2275	69628.0
2018-05-07 18:00:00	AAPL	Stock	46.23	46.25	46.2275	46.25	45020.0
2018-05-07 19:00:00	AAPL	Stock	46.25	46.275	46.2375	46.2375	71808.0
2018-05-07 04:00:00	MSFT	Stock	95.48	95.48	95.48	95.48	100.0
2018-05-07 06:00:00	MSFT	Stock	95.6	95.6	95.6	95.6	300.0
2018-05-07 07:00:00	MSFT	Stock	95.57	95.79	95.56	95.75	13965.0
2018-05-07 08:00:00	MSFT	Stock	95.7	95.85	95.48	95.58	29873.0
2018-05-07 09:00:00	MSFT	Stock	95.51	96.29	95.1	96.05	3397939.0
2018-05-07 10:00:00	MSFT	Stock	96.05	96.26	95.78	96.13	2680603.0
2018-05-07 11:00:00	MSFT	Stock	96.135	96.55	95.93	96.488	3076944.0
2018-05-07 12:00:00	MSFT	Stock	96.49	96.62	96.253	96.46	2196943.0
2018-05-07 13:00:00	MSFT	Stock	96.458	96.71	96.27	96.605	2037996.0
2018-05-07 14:00:00	MSFT	Stock	96.605	96.69	96.11	96.255	2073972.0
2018-05-07 15:00:00	MSFT	Stock	96.256	96.37	95.67	96.23	4136346.0
2018-05-07 16:00:00	MSFT	Stock	96.22	96.3	96.15	96.3	1872907.0
2018-05-07 17:00:00	MSFT	Stock	96.2	96.22	96.18	96.22	4429.0
2018-05-07 18:00:00	MSFT	Stock	96.11	96.2	96.0	96.01	5337.0
2018-05-07 19:00:00	MSFT	Stock	96.03	96.12	96.01	96.03	2627.0
2018-05-07 04:00:00	NVDA	Stock	5.9875	6.0238	5.9875	6.0235	199080.0
2018-05-07 05:00:00	NVDA	Stock	6.0238	6.0275	6.0178	6.0205	143400.0
2018-05-07 06:00:00	NVDA	Stock	6.0188	6.02	6.0188	6.02	47960.0
2018-05-07 07:00:00	NVDA	Stock	6.0205	6.0948	6.02	6.0888	3303200.0
2018-05-07 08:00:00	NVDA	Stock	6.0875	6.096	5.9888	6.0903	4508720.0
2018-05-07 09:00:00	NVDA	Stock	6.0905	6.2022	6.0723	6.1884	128447680.0
2018-05-07 10:00:00	NVDA	Stock	6.189	6.2498	6.1765	6.2355	142176080.0
2018-05-07 11:00:00	NVDA	Stock	6.2365	6.2705	6.2238	6.2585	97513680.0
2018-05-07 12:00:00	NVDA	Stock	6.259	6.2748	6.2078	6.2238	69694880.0
2018-05-07 13:00:00	NVDA	Stock	6.2238	6.245	6.2175	6.2365	33431080.0
2018-05-07 14:00:00	NVDA	Stock	6.2367	6.2535	6.205	6.2154	46017160.0
2018-05-07 15:00:00	NVDA	Stock	6.2145	6.2338	6.1661	6.2172	93095280.0
2018-05-07 16:00:00	NVDA	Stock	6.217	6.2245	6.217	6.2238	16242520.0
2018-05-07 17:00:00	NVDA	Stock	6.224	6.2315	6.219	6.2315	1372640.0
2018-05-07 18:00:00	NVDA	Stock	6.2333	6.2362	6.2225	6.2252	871680.0
2018-05-07 19:00:00	NVDA	Stock	6.2312	6.2362	6.225	6.2362	830400.0
2018-05-07 05:00:00	AMZN	Stock	79.715	79.715	79.225	79.225	63380.0
2018-05-07 06:00:00	AMZN	Stock	79.225	79.25	79.05	79.075	99440.0
2018-05-07 07:00:00	AMZN	Stock	79.225	79.495	79.15	79.4	260680.0

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

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