PREVIEW / stock_1hour / 2019-01-24

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-01-24.parquet
  size:    1.1 MB
  rows:    48,979
  symbols: 2,676

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-24 04:00:00	AAPL	Stock	38.5475	38.6275	38.5475	38.5625	22224.0
2019-01-24 05:00:00	AAPL	Stock	38.6975	38.75	38.6625	38.7225	28204.0
2019-01-24 06:00:00	AAPL	Stock	38.7875	38.7875	38.6625	38.675	35232.0
2019-01-24 07:00:00	AAPL	Stock	38.675	38.7	38.585	38.585	73476.0
2019-01-24 08:00:00	AAPL	Stock	38.6875	38.7	38.3925	38.425	428220.0
2019-01-24 09:00:00	AAPL	Stock	38.4225	38.6625	38.2425	38.2625	11821204.0
2019-01-24 10:00:00	AAPL	Stock	38.265	38.41	38.07	38.0775	15248224.0
2019-01-24 11:00:00	AAPL	Stock	38.075	38.2575	37.9675	38.2388	12137932.0
2019-01-24 12:00:00	AAPL	Stock	38.2375	38.2375	38.035	38.055	6615872.0
2019-01-24 13:00:00	AAPL	Stock	38.0525	38.1	37.955	38.0075	7712736.0
2019-01-24 14:00:00	AAPL	Stock	38.0075	38.08	37.935	38.0562	9453628.0
2019-01-24 15:00:00	AAPL	Stock	38.055	38.1875	38.0212	38.1775	13515592.0
2019-01-24 16:00:00	AAPL	Stock	38.175	38.1875	38.04	38.125	15551012.0
2019-01-24 17:00:00	AAPL	Stock	38.11	38.1225	38.06	38.1	34628.0
2019-01-24 18:00:00	AAPL	Stock	38.09	38.09	38.05	38.0725	40984.0
2019-01-24 19:00:00	AAPL	Stock	38.055	38.15	38.055	38.15	26612.0
2019-01-24 04:00:00	MSFT	Stock	106.8	107.15	106.8	107.15	300.0
2019-01-24 05:00:00	MSFT	Stock	107.18	107.18	106.85	107.0	5152.0
2019-01-24 06:00:00	MSFT	Stock	107.0	107.1	106.71	106.96	9249.0
2019-01-24 07:00:00	MSFT	Stock	107.04	107.08	106.88	106.9	6671.0
2019-01-24 08:00:00	MSFT	Stock	107.06	107.15	106.59	106.71	231414.0
2019-01-24 09:00:00	MSFT	Stock	106.82	107.16	105.76	106.08	2650088.0
2019-01-24 10:00:00	MSFT	Stock	106.07	106.75	105.94	106.03	3444822.0
2019-01-24 11:00:00	MSFT	Stock	106.02	106.41	105.34	106.26	2921185.0
2019-01-24 12:00:00	MSFT	Stock	106.26	106.33	105.73	105.83	1632856.0
2019-01-24 13:00:00	MSFT	Stock	105.83	105.955	105.49	105.662	1871838.0
2019-01-24 14:00:00	MSFT	Stock	105.66	105.98	105.51	105.82	2202489.0
2019-01-24 15:00:00	MSFT	Stock	105.81	106.35	105.763	106.19	3876865.0
2019-01-24 16:00:00	MSFT	Stock	106.2	106.34	105.47	105.95	2158080.0
2019-01-24 17:00:00	MSFT	Stock	105.81	105.91	105.75	105.8	6954.0
2019-01-24 18:00:00	MSFT	Stock	105.89	105.89	105.47	105.5	24663.0
2019-01-24 19:00:00	MSFT	Stock	105.7	105.85	105.55	105.75	6143.0
2019-01-24 04:00:00	NVDA	Stock	3.8125	3.8188	3.8125	3.8188	90760.0
2019-01-24 05:00:00	NVDA	Stock	3.8348	3.836	3.825	3.825	39720.0
2019-01-24 06:00:00	NVDA	Stock	3.8375	3.8478	3.827	3.8373	91720.0
2019-01-24 07:00:00	NVDA	Stock	3.8373	3.8438	3.8248	3.825	735240.0
2019-01-24 08:00:00	NVDA	Stock	3.83	3.8378	3.7775	3.7968	4455880.0
2019-01-24 09:00:00	NVDA	Stock	3.7932	3.946	3.7875	3.9418	160312000.0
2019-01-24 10:00:00	NVDA	Stock	3.9403	3.945	3.8752	3.8967	129922520.0
2019-01-24 11:00:00	NVDA	Stock	3.896	3.9303	3.875	3.9232	60355680.0
2019-01-24 12:00:00	NVDA	Stock	3.923	3.9638	3.9128	3.9505	73246040.0
2019-01-24 13:00:00	NVDA	Stock	3.9505	3.9525	3.903	3.9315	56533800.0
2019-01-24 14:00:00	NVDA	Stock	3.9331	3.9388	3.9182	3.9372	40450440.0
2019-01-24 15:00:00	NVDA	Stock	3.9368	3.9509	3.93	3.9458	77561600.0
2019-01-24 16:00:00	NVDA	Stock	3.9452	3.9462	3.825	3.8595	44163160.0
2019-01-24 17:00:00	NVDA	Stock	3.8598	3.8875	3.855	3.8738	8790200.0
2019-01-24 18:00:00	NVDA	Stock	3.8738	3.9098	3.8725	3.892	1351440.0
2019-01-24 19:00:00	NVDA	Stock	3.895	3.9025	3.8943	3.8978	855400.0
2019-01-24 04:00:00	AMZN	Stock	82.7	82.7	82.7	82.7	4200.0
2019-01-24 05:00:00	AMZN	Stock	82.7055	82.708	82.6695	82.6695	10000.0

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

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