PREVIEW / stock_1hour / 2019-01-23

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-01-23.parquet
  size:    1.1 MB
  rows:    48,783
  symbols: 2,678

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-23 04:00:00	AAPL	Stock	38.4475	38.4475	38.4475	38.4475	1312.0
2019-01-23 06:00:00	AAPL	Stock	38.435	38.5	38.4	38.5	19008.0
2019-01-23 07:00:00	AAPL	Stock	38.5	38.5875	38.4875	38.5275	83756.0
2019-01-23 08:00:00	AAPL	Stock	38.5	38.595	38.4625	38.525	242136.0
2019-01-23 09:00:00	AAPL	Stock	38.5488	38.785	38.465	38.6525	11540976.0
2019-01-23 10:00:00	AAPL	Stock	38.654	38.7475	38.3425	38.4188	11786488.0
2019-01-23 11:00:00	AAPL	Stock	38.4185	38.43	38.01	38.0605	11827052.0
2019-01-23 12:00:00	AAPL	Stock	38.06	38.1975	37.925	38.165	9177324.0
2019-01-23 13:00:00	AAPL	Stock	38.17	38.3275	38.0375	38.31	7546684.0
2019-01-23 14:00:00	AAPL	Stock	38.3175	38.4025	38.165	38.275	9403128.0
2019-01-23 15:00:00	AAPL	Stock	38.275	38.4925	38.2575	38.4925	12067860.0
2019-01-23 16:00:00	AAPL	Stock	38.4925	38.5	38.425	38.4825	8513104.0
2019-01-23 17:00:00	AAPL	Stock	38.4775	38.4775	38.425	38.4375	24804.0
2019-01-23 18:00:00	AAPL	Stock	38.4475	38.4925	38.3975	38.3975	33176.0
2019-01-23 19:00:00	AAPL	Stock	38.38	38.49	38.38	38.49	24988.0
2019-01-23 05:00:00	MSFT	Stock	106.0	106.1	106.0	106.1	500.0
2019-01-23 06:00:00	MSFT	Stock	106.1	106.1	105.8	105.82	2297.0
2019-01-23 07:00:00	MSFT	Stock	106.16	106.45	106.1	106.32	16822.0
2019-01-23 08:00:00	MSFT	Stock	106.05	106.49	106.0	106.21	60665.0
2019-01-23 09:00:00	MSFT	Stock	106.21	106.92	106.05	106.755	3005784.0
2019-01-23 10:00:00	MSFT	Stock	106.74	107.04	106.01	106.11	3206819.0
2019-01-23 11:00:00	MSFT	Stock	106.12	106.45	105.55	105.69	2979032.0
2019-01-23 12:00:00	MSFT	Stock	105.675	106.1	105.34	106.055	2200266.0
2019-01-23 13:00:00	MSFT	Stock	106.064	106.18	105.76	106.05	1669281.0
2019-01-23 14:00:00	MSFT	Stock	106.06	106.38	105.67	105.95	2065327.0
2019-01-23 15:00:00	MSFT	Stock	105.94	106.79	105.91	106.79	4119750.0
2019-01-23 16:00:00	MSFT	Stock	106.79	106.79	106.48	106.71	2427662.0
2019-01-23 17:00:00	MSFT	Stock	106.71	106.71	106.6	106.6	36667.0
2019-01-23 18:00:00	MSFT	Stock	106.61	106.65	106.05	106.5	14029.0
2019-01-23 19:00:00	MSFT	Stock	106.45	106.7	106.24	106.6	15790.0
2019-01-23 04:00:00	NVDA	Stock	3.748	3.748	3.74	3.74	16000.0
2019-01-23 06:00:00	NVDA	Stock	3.7488	3.7495	3.74	3.7495	52200.0
2019-01-23 07:00:00	NVDA	Stock	3.7575	3.7718	3.7515	3.7638	1009120.0
2019-01-23 08:00:00	NVDA	Stock	3.76	3.7838	3.755	3.7788	2576240.0
2019-01-23 09:00:00	NVDA	Stock	3.7819	3.8645	3.7542	3.8425	101442520.0
2019-01-23 10:00:00	NVDA	Stock	3.8432	3.848	3.769	3.773	89404400.0
2019-01-23 11:00:00	NVDA	Stock	3.7722	3.7885	3.7105	3.7215	74660760.0
2019-01-23 12:00:00	NVDA	Stock	3.7205	3.7478	3.7125	3.7368	62696200.0
2019-01-23 13:00:00	NVDA	Stock	3.7358	3.742	3.713	3.7292	40595560.0
2019-01-23 14:00:00	NVDA	Stock	3.73	3.7492	3.7008	3.7093	50782120.0
2019-01-23 15:00:00	NVDA	Stock	3.7087	3.7435	3.707	3.7325	90734400.0
2019-01-23 16:00:00	NVDA	Stock	3.7322	3.7995	3.7238	3.798	37431200.0
2019-01-23 17:00:00	NVDA	Stock	3.7962	3.7988	3.7712	3.79	7805200.0
2019-01-23 18:00:00	NVDA	Stock	3.7905	3.8	3.7875	3.7962	1407320.0
2019-01-23 19:00:00	NVDA	Stock	3.7962	3.8072	3.793	3.8	1159800.0
2019-01-23 04:00:00	AMZN	Stock	81.75	82.0025	81.75	82.0025	10240.0
2019-01-23 05:00:00	AMZN	Stock	82.0655	82.145	82.0655	82.066	18000.0
2019-01-23 06:00:00	AMZN	Stock	82.082	82.1425	81.835	81.9895	38760.0
2019-01-23 07:00:00	AMZN	Stock	82.1	82.55	82.1	82.55	478880.0
2019-01-23 08:00:00	AMZN	Stock	82.2019	82.6925	82.15	82.6375	787280.0

> showing 50 of 48,783 rows — these rows as CSV

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