PREVIEW / stock_1hour / 2018-02-07

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-02-07.parquet
  size:    1.1 MB
  rows:    50,034
  symbols: 2,901

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-02-07 04:00:00	AAPL	Stock	40.4125	40.45	40.315	40.315	23860.0
2018-02-07 05:00:00	AAPL	Stock	40.375	40.4925	40.365	40.4125	35656.0
2018-02-07 06:00:00	AAPL	Stock	40.4075	40.59	40.25	40.5625	64588.0
2018-02-07 07:00:00	AAPL	Stock	40.56	40.6875	40.55	40.63	352580.0
2018-02-07 08:00:00	AAPL	Stock	40.5438	40.7375	40.3325	40.6625	500620.0
2018-02-07 09:00:00	AAPL	Stock	40.6575	40.85	40.2775	40.4903	28013644.0
2018-02-07 10:00:00	AAPL	Stock	40.49	40.655	40.3375	40.4975	25093096.0
2018-02-07 11:00:00	AAPL	Stock	40.5	40.5975	40.3175	40.4138	20078232.0
2018-02-07 12:00:00	AAPL	Stock	40.4225	40.455	40.0275	40.1225	19651212.0
2018-02-07 13:00:00	AAPL	Stock	40.125	40.3475	39.767	40.2875	25091928.0
2018-02-07 14:00:00	AAPL	Stock	40.2925	40.355	39.9578	40.11	18127612.0
2018-02-07 15:00:00	AAPL	Stock	40.12	40.325	39.88	39.88	28703360.0
2018-02-07 16:00:00	AAPL	Stock	39.88	40.4242	39.69	39.7125	10944584.0
2018-02-07 17:00:00	AAPL	Stock	39.75	39.8125	39.73	39.79	215440.0
2018-02-07 18:00:00	AAPL	Stock	39.79	39.795	39.69	39.7075	251868.0
2018-02-07 19:00:00	AAPL	Stock	39.725	39.78	39.7	39.725	125432.0
2018-02-07 04:00:00	MSFT	Stock	91.14	91.14	90.3	90.4	1448.0
2018-02-07 05:00:00	MSFT	Stock	90.15	90.4	89.75	90.31	3494.0
2018-02-07 06:00:00	MSFT	Stock	90.49	90.61	90.32	90.61	7040.0
2018-02-07 07:00:00	MSFT	Stock	90.61	90.99	90.5	90.7	21585.0
2018-02-07 08:00:00	MSFT	Stock	90.84	90.95	90.5	90.79	19093.0
2018-02-07 09:00:00	MSFT	Stock	90.77	90.99	89.88	90.51	5643415.0
2018-02-07 10:00:00	MSFT	Stock	90.5	91.425	90.375	91.216	4739654.0
2018-02-07 11:00:00	MSFT	Stock	91.23	91.77	90.95	91.294	4422829.0
2018-02-07 12:00:00	MSFT	Stock	91.3	91.3	90.17	90.47	3486809.0
2018-02-07 13:00:00	MSFT	Stock	90.47	90.74	89.48	90.365	5495794.0
2018-02-07 14:00:00	MSFT	Stock	90.36	90.52	89.2	89.75	3120407.0
2018-02-07 15:00:00	MSFT	Stock	89.74	90.76	89.57	89.58	7282682.0
2018-02-07 16:00:00	MSFT	Stock	89.61	89.83	89.05	89.18	3123618.0
2018-02-07 17:00:00	MSFT	Stock	89.19	89.39	89.08	89.3	7327.0
2018-02-07 18:00:00	MSFT	Stock	89.3	89.33	88.81	88.81	8389.0
2018-02-07 19:00:00	MSFT	Stock	89.24	89.24	88.85	89.2	1250.0
2018-02-07 04:00:00	NVDA	Stock	5.6635	5.6668	5.6175	5.6175	561520.0
2018-02-07 05:00:00	NVDA	Stock	5.6175	5.6325	5.615	5.6175	248160.0
2018-02-07 06:00:00	NVDA	Stock	5.6125	5.6492	5.6125	5.6492	122560.0
2018-02-07 07:00:00	NVDA	Stock	5.6693	5.7582	5.6693	5.7018	1806800.0
2018-02-07 08:00:00	NVDA	Stock	5.7125	5.7342	5.655	5.705	3402520.0
2018-02-07 09:00:00	NVDA	Stock	5.705	5.758	5.607	5.7303	134524120.0
2018-02-07 10:00:00	NVDA	Stock	5.7265	5.8125	5.7175	5.771	141727440.0
2018-02-07 11:00:00	NVDA	Stock	5.7728	5.8742	5.7675	5.8648	98550240.0
2018-02-07 12:00:00	NVDA	Stock	5.8634	5.865	5.7568	5.7613	64957000.0
2018-02-07 13:00:00	NVDA	Stock	5.761	5.8023	5.6734	5.777	92767320.0
2018-02-07 14:00:00	NVDA	Stock	5.7755	5.7862	5.7095	5.7462	52655840.0
2018-02-07 15:00:00	NVDA	Stock	5.746	5.7965	5.7128	5.7202	88279600.0
2018-02-07 16:00:00	NVDA	Stock	5.7215	5.7726	5.6825	5.7	4698240.0
2018-02-07 17:00:00	NVDA	Stock	5.695	5.7225	5.6775	5.7075	591920.0
2018-02-07 18:00:00	NVDA	Stock	5.7075	5.7125	5.6752	5.6812	677160.0
2018-02-07 19:00:00	NVDA	Stock	5.69	5.7225	5.6875	5.71	375520.0
2018-02-07 04:00:00	AMZN	Stock	71.769	71.769	71.769	71.769	2000.0
2018-02-07 05:00:00	AMZN	Stock	71.654	71.654	71.501	71.5215	19000.0

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

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