PREVIEW / stock_1hour / 2019-04-09

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-04-09.parquet
  size:    1.1 MB
  rows:    49,097
  symbols: 2,630

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-04-09 04:00:00	AAPL	Stock	50.025	50.075	49.9825	50.0375	11060.0
2019-04-09 05:00:00	AAPL	Stock	50.09	50.125	50.0775	50.1	17656.0
2019-04-09 06:00:00	AAPL	Stock	50.0975	50.13	50.055	50.1075	24268.0
2019-04-09 07:00:00	AAPL	Stock	50.1225	50.3725	50.105	50.3175	306432.0
2019-04-09 08:00:00	AAPL	Stock	50.12	50.3875	50.105	50.1925	687880.0
2019-04-09 09:00:00	AAPL	Stock	50.1675	50.4875	49.92	50.415	24933880.0
2019-04-09 10:00:00	AAPL	Stock	50.4175	50.7125	50.3675	50.6075	25844600.0
2019-04-09 11:00:00	AAPL	Stock	50.6058	50.675	50.4275	50.4875	10818040.0
2019-04-09 12:00:00	AAPL	Stock	50.4825	50.57	50.4025	50.41	7455368.0
2019-04-09 13:00:00	AAPL	Stock	50.41	50.415	49.88	50.0	17887988.0
2019-04-09 14:00:00	AAPL	Stock	50.0	50.0075	49.825	49.905	13341660.0
2019-04-09 15:00:00	AAPL	Stock	49.9075	50.0	49.8075	49.875	16231596.0
2019-04-09 16:00:00	AAPL	Stock	49.875	49.92	49.805	49.845	7252124.0
2019-04-09 17:00:00	AAPL	Stock	49.825	49.845	49.825	49.8375	43396.0
2019-04-09 18:00:00	AAPL	Stock	49.8375	49.8375	49.825	49.835	42504.0
2019-04-09 19:00:00	AAPL	Stock	49.825	49.84	49.775	49.775	25144.0
2019-04-09 04:00:00	MSFT	Stock	120.18	120.18	119.94	119.94	200.0
2019-04-09 05:00:00	MSFT	Stock	119.85	119.85	119.85	119.85	419.0
2019-04-09 06:00:00	MSFT	Stock	119.76	119.84	119.7	119.84	1905.0
2019-04-09 07:00:00	MSFT	Stock	119.74	119.74	119.35	119.4	25095.0
2019-04-09 08:00:00	MSFT	Stock	119.4	119.4	119.05	119.3	27833.0
2019-04-09 09:00:00	MSFT	Stock	119.141	119.33	118.58	119.09	2449141.0
2019-04-09 10:00:00	MSFT	Stock	119.1	119.54	118.91	119.065	2406059.0
2019-04-09 11:00:00	MSFT	Stock	119.07	119.3	119.02	119.15	1740023.0
2019-04-09 12:00:00	MSFT	Stock	119.16	119.41	119.155	119.175	1051302.0
2019-04-09 13:00:00	MSFT	Stock	119.171	119.22	119.01	119.11	907545.0
2019-04-09 14:00:00	MSFT	Stock	119.115	119.2	118.99	119.1	1218640.0
2019-04-09 15:00:00	MSFT	Stock	119.098	119.4	118.965	119.31	2990764.0
2019-04-09 16:00:00	MSFT	Stock	119.28	119.63	119.09	119.2	1899865.0
2019-04-09 17:00:00	MSFT	Stock	119.2	119.2	119.11	119.11	3924.0
2019-04-09 18:00:00	MSFT	Stock	119.15	119.16	119.15	119.16	1460.0
2019-04-09 19:00:00	MSFT	Stock	119.14	119.14	119.09	119.09	1764.0
2019-04-09 04:00:00	NVDA	Stock	4.7818	4.7925	4.7818	4.7925	17400.0
2019-04-09 06:00:00	NVDA	Stock	4.7925	4.7925	4.7925	4.7925	16160.0
2019-04-09 07:00:00	NVDA	Stock	4.7952	4.801	4.7928	4.8	384520.0
2019-04-09 08:00:00	NVDA	Stock	4.8	4.8065	4.7768	4.7805	1231040.0
2019-04-09 09:00:00	NVDA	Stock	4.7805	4.7805	4.7175	4.7233	88361320.0
2019-04-09 10:00:00	NVDA	Stock	4.7231	4.7472	4.689	4.7085	87388240.0
2019-04-09 11:00:00	NVDA	Stock	4.7094	4.722	4.7	4.7118	43329840.0
2019-04-09 12:00:00	NVDA	Stock	4.7114	4.7348	4.7075	4.7298	32989200.0
2019-04-09 13:00:00	NVDA	Stock	4.7296	4.7328	4.7148	4.723	33723880.0
2019-04-09 14:00:00	NVDA	Stock	4.7238	4.7362	4.7135	4.7285	43509440.0
2019-04-09 15:00:00	NVDA	Stock	4.729	4.7398	4.723	4.732	57855880.0
2019-04-09 16:00:00	NVDA	Stock	4.7315	4.7315	4.722	4.7315	10288160.0
2019-04-09 17:00:00	NVDA	Stock	4.734	4.7362	4.73	4.73	148320.0
2019-04-09 18:00:00	NVDA	Stock	4.73	4.73	4.7255	4.7265	119520.0
2019-04-09 19:00:00	NVDA	Stock	4.726	4.726	4.72	4.725	328840.0
2019-04-09 06:00:00	AMZN	Stock	92.5	92.5	92.425	92.425	5640.0
2019-04-09 07:00:00	AMZN	Stock	92.5375	92.6375	92.4185	92.42	154960.0
2019-04-09 08:00:00	AMZN	Stock	92.5878	92.6	92.275	92.342	415540.0

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

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