PREVIEW / stock_1hour / 2019-01-14

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-01-14.parquet
  size:    1.1 MB
  rows:    49,448
  symbols: 2,674

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
2019-01-14 04:00:00	AAPL	Stock	37.9	37.9	37.74	37.74	10540.0
2019-01-14 05:00:00	AAPL	Stock	37.7	37.7	37.625	37.625	13316.0
2019-01-14 06:00:00	AAPL	Stock	37.7	37.7125	37.65	37.7125	13400.0
2019-01-14 07:00:00	AAPL	Stock	37.71	37.7775	37.6525	37.7	169744.0
2019-01-14 08:00:00	AAPL	Stock	37.689	38.0725	37.65	37.775	240804.0
2019-01-14 09:00:00	AAPL	Stock	37.7775	37.8175	37.4525	37.5	19333944.0
2019-01-14 10:00:00	AAPL	Stock	37.505	37.6175	37.465	37.516	16962036.0
2019-01-14 11:00:00	AAPL	Stock	37.5125	37.5425	37.305	37.4425	16093684.0
2019-01-14 12:00:00	AAPL	Stock	37.4445	37.7	37.39	37.5775	10800292.0
2019-01-14 13:00:00	AAPL	Stock	37.575	37.5928	37.4675	37.5125	7452292.0
2019-01-14 14:00:00	AAPL	Stock	37.51	37.5295	37.4175	37.5	8301184.0
2019-01-14 15:00:00	AAPL	Stock	37.4988	37.525	37.3675	37.4975	18933912.0
2019-01-14 16:00:00	AAPL	Stock	37.4975	37.5375	37.4275	37.4925	16527420.0
2019-01-14 17:00:00	AAPL	Stock	37.4775	37.5	37.45	37.475	34268.0
2019-01-14 18:00:00	AAPL	Stock	37.4625	37.495	37.45	37.4925	23596.0
2019-01-14 19:00:00	AAPL	Stock	37.495	37.58	37.49	37.5625	129888.0
2019-01-14 04:00:00	MSFT	Stock	102.05	102.05	101.87	102.01	1560.0
2019-01-14 05:00:00	MSFT	Stock	102.01	102.01	101.6	101.6	3925.0
2019-01-14 06:00:00	MSFT	Stock	101.6	101.78	101.6	101.78	1992.0
2019-01-14 07:00:00	MSFT	Stock	101.92	102.0	101.73	101.9	5838.0
2019-01-14 08:00:00	MSFT	Stock	101.86	102.05	101.75	102.03	14552.0
2019-01-14 09:00:00	MSFT	Stock	102.03	102.2	101.36	101.37	2921240.0
2019-01-14 10:00:00	MSFT	Stock	101.39	102.152	101.26	102.01	3653389.0
2019-01-14 11:00:00	MSFT	Stock	102.01	102.185	101.51	102.03	2739433.0
2019-01-14 12:00:00	MSFT	Stock	102.03	102.07	101.83	101.91	1476143.0
2019-01-14 13:00:00	MSFT	Stock	101.9	102.0	101.7	101.745	1671300.0
2019-01-14 14:00:00	MSFT	Stock	101.75	102.21	101.64	102.184	1704964.0
2019-01-14 15:00:00	MSFT	Stock	102.18	102.44	101.91	102.05	4113253.0
2019-01-14 16:00:00	MSFT	Stock	102.05	102.19	101.9	102.05	6752699.0
2019-01-14 17:00:00	MSFT	Stock	101.94	102.11	101.94	102.0	5691.0
2019-01-14 18:00:00	MSFT	Stock	102.0	102.1	101.95	102.1	2609.0
2019-01-14 19:00:00	MSFT	Stock	102.03	102.36	102.03	102.34	5653.0
2019-01-14 04:00:00	NVDA	Stock	3.702	3.702	3.6758	3.685	40600.0
2019-01-14 05:00:00	NVDA	Stock	3.668	3.668	3.6575	3.6575	64960.0
2019-01-14 06:00:00	NVDA	Stock	3.655	3.665	3.6525	3.665	71480.0
2019-01-14 07:00:00	NVDA	Stock	3.665	3.6775	3.656	3.6675	581120.0
2019-01-14 08:00:00	NVDA	Stock	3.6565	3.6775	3.654	3.6675	1756320.0
2019-01-14 09:00:00	NVDA	Stock	3.6662	3.71	3.6443	3.6942	106478520.0
2019-01-14 10:00:00	NVDA	Stock	3.695	3.7447	3.6897	3.74	132524640.0
2019-01-14 11:00:00	NVDA	Stock	3.7398	3.7758	3.7355	3.7475	97988240.0
2019-01-14 12:00:00	NVDA	Stock	3.7478	3.7788	3.733	3.7672	76180400.0
2019-01-14 13:00:00	NVDA	Stock	3.7675	3.7715	3.743	3.7698	67218680.0
2019-01-14 14:00:00	NVDA	Stock	3.7687	3.775	3.7428	3.7595	63870080.0
2019-01-14 15:00:00	NVDA	Stock	3.7595	3.7865	3.7585	3.7595	120366600.0
2019-01-14 16:00:00	NVDA	Stock	3.7615	3.7688	3.76	3.7638	5339880.0
2019-01-14 17:00:00	NVDA	Stock	3.767	3.7675	3.7612	3.7672	152800.0
2019-01-14 18:00:00	NVDA	Stock	3.765	3.7675	3.7625	3.7675	193920.0
2019-01-14 19:00:00	NVDA	Stock	3.7682	3.7912	3.7682	3.79	444760.0
2019-01-14 04:00:00	AMZN	Stock	81.076	81.265	81.0675	81.0675	6400.0
2019-01-14 05:00:00	AMZN	Stock	81.05	81.05	80.7385	80.8145	28000.0

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

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