PREVIEW / stock_1hour / 2018-12-27

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-12-27.parquet
  size:    1.1 MB
  rows:    51,239
  symbols: 2,724

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-12-27 04:00:00	AAPL	Stock	38.745	39.0175	38.5875	38.625	50096.0
2018-12-27 05:00:00	AAPL	Stock	38.6125	38.8	38.58	38.66	63836.0
2018-12-27 06:00:00	AAPL	Stock	38.745	38.8	38.68	38.68	17376.0
2018-12-27 07:00:00	AAPL	Stock	38.68	38.8575	38.5625	38.7725	171164.0
2018-12-27 08:00:00	AAPL	Stock	38.7575	39.3875	38.595	38.78	508224.0
2018-12-27 09:00:00	AAPL	Stock	38.7875	39.0625	38.2725	38.4075	23394816.0
2018-12-27 10:00:00	AAPL	Stock	38.3975	38.5425	37.8575	37.9188	30047232.0
2018-12-27 11:00:00	AAPL	Stock	37.905	38.2775	37.835	38.1385	20546120.0
2018-12-27 12:00:00	AAPL	Stock	38.1425	38.165	37.7425	38.0175	15653712.0
2018-12-27 13:00:00	AAPL	Stock	38.0188	38.039	37.5375	37.6025	13388652.0
2018-12-27 14:00:00	AAPL	Stock	37.6025	38.1025	37.5175	38.1025	17968000.0
2018-12-27 15:00:00	AAPL	Stock	38.105	39.1925	37.92	39.1325	47538912.0
2018-12-27 16:00:00	AAPL	Stock	39.1325	39.2	38.97	39.05	16768684.0
2018-12-27 17:00:00	AAPL	Stock	39.075	39.075	39.0325	39.0325	200640.0
2018-12-27 18:00:00	AAPL	Stock	39.0375	39.0375	38.7675	38.825	5600488.0
2018-12-27 19:00:00	AAPL	Stock	38.85	39.025	38.85	39.0	65956.0
2018-12-27 04:00:00	MSFT	Stock	99.01	99.06	98.0	98.53	8109.0
2018-12-27 05:00:00	MSFT	Stock	98.26	98.93	98.24	98.6	2174.0
2018-12-27 06:00:00	MSFT	Stock	98.8	98.98	98.6	98.6	4697.0
2018-12-27 07:00:00	MSFT	Stock	98.87	99.25	98.47	99.06	31301.0
2018-12-27 08:00:00	MSFT	Stock	98.901	100.8	98.7	98.9	57729.0
2018-12-27 09:00:00	MSFT	Stock	98.781	99.75	98.39	98.72	3927957.0
2018-12-27 10:00:00	MSFT	Stock	98.7	99.02	97.13	97.89	6998125.0
2018-12-27 11:00:00	MSFT	Stock	97.88	98.81	97.63	98.28	4422106.0
2018-12-27 12:00:00	MSFT	Stock	98.29	98.33	97.32	97.97	3878805.0
2018-12-27 13:00:00	MSFT	Stock	97.96	98.1	96.85	97.05	3185926.0
2018-12-27 14:00:00	MSFT	Stock	97.05	98.26	96.4	98.26	5161411.0
2018-12-27 15:00:00	MSFT	Stock	98.26	101.19	97.77	101.175	10310984.0
2018-12-27 16:00:00	MSFT	Stock	101.18	101.75	98.385	101.24	6756820.0
2018-12-27 17:00:00	MSFT	Stock	101.25	101.3	101.13	101.2	20488.0
2018-12-27 18:00:00	MSFT	Stock	101.2	101.2	100.5	100.64	12886.0
2018-12-27 19:00:00	MSFT	Stock	100.71	101.27	100.71	101.2	12521.0
2018-12-27 04:00:00	NVDA	Stock	3.2812	3.2812	3.2265	3.2265	87200.0
2018-12-27 05:00:00	NVDA	Stock	3.2373	3.2475	3.2373	3.2403	82200.0
2018-12-27 06:00:00	NVDA	Stock	3.2475	3.267	3.2475	3.25	126080.0
2018-12-27 07:00:00	NVDA	Stock	3.255	3.2875	3.25	3.2875	1074440.0
2018-12-27 08:00:00	NVDA	Stock	3.286	3.335	3.2486	3.2688	1474360.0
2018-12-27 09:00:00	NVDA	Stock	3.2725	3.3095	3.24	3.2918	61454960.0
2018-12-27 10:00:00	NVDA	Stock	3.292	3.3042	3.185	3.1866	94167440.0
2018-12-27 11:00:00	NVDA	Stock	3.1858	3.224	3.1733	3.1915	64952920.0
2018-12-27 12:00:00	NVDA	Stock	3.1914	3.193	3.1503	3.1758	60850000.0
2018-12-27 13:00:00	NVDA	Stock	3.174	3.1813	3.1352	3.1438	50004640.0
2018-12-27 14:00:00	NVDA	Stock	3.1438	3.2015	3.1295	3.1927	57132960.0
2018-12-27 15:00:00	NVDA	Stock	3.1912	3.291	3.1765	3.2905	137626040.0
2018-12-27 16:00:00	NVDA	Stock	3.2905	3.295	3.275	3.28	50903880.0
2018-12-27 17:00:00	NVDA	Stock	3.2803	3.2838	3.2737	3.2755	284960.0
2018-12-27 18:00:00	NVDA	Stock	3.2725	3.275	3.2575	3.2698	219080.0
2018-12-27 19:00:00	NVDA	Stock	3.2665	3.276	3.2625	3.2675	291520.0
2018-12-27 04:00:00	AMZN	Stock	72.855	72.855	72.0	72.0	51980.0
2018-12-27 05:00:00	AMZN	Stock	72.05	72.35	72.05	72.35	14320.0

> showing 50 of 51,239 rows — these rows as CSV

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