PREVIEW / stock_1hour / 2019-10-03

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-10-03.parquet
  size:    1.1 MB
  rows:    48,727
  symbols: 2,517

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-10-03 04:00:00	AAPL	Stock	54.825	54.95	54.775	54.95	13700.0
2019-10-03 05:00:00	AAPL	Stock	54.805	54.825	54.805	54.825	5524.0
2019-10-03 06:00:00	AAPL	Stock	54.8125	54.815	54.75	54.75	20548.0
2019-10-03 07:00:00	AAPL	Stock	54.795	54.795	54.525	54.5525	167656.0
2019-10-03 08:00:00	AAPL	Stock	54.7	54.8125	54.525	54.56	271356.0
2019-10-03 09:00:00	AAPL	Stock	54.585	54.835	54.415	54.5725	12459060.0
2019-10-03 10:00:00	AAPL	Stock	54.5725	54.58	53.783	54.365	25729580.0
2019-10-03 11:00:00	AAPL	Stock	54.3625	54.92	54.3	54.7075	14716776.0
2019-10-03 12:00:00	AAPL	Stock	54.7062	55.2075	54.7062	55.1475	11508432.0
2019-10-03 13:00:00	AAPL	Stock	55.1525	55.24	55.0062	55.1628	7161784.0
2019-10-03 14:00:00	AAPL	Stock	55.1675	55.17	54.965	55.005	5938604.0
2019-10-03 15:00:00	AAPL	Stock	55.005	55.2375	54.9225	55.2025	8885224.0
2019-10-03 16:00:00	AAPL	Stock	55.205	55.2875	55.17	55.2	8133176.0
2019-10-03 17:00:00	AAPL	Stock	55.195	55.2	55.1225	55.1575	68348.0
2019-10-03 18:00:00	AAPL	Stock	55.145	55.15	55.0775	55.1175	41252.0
2019-10-03 19:00:00	AAPL	Stock	55.1125	55.1375	55.075	55.125	69692.0
2019-10-03 04:00:00	MSFT	Stock	135.44	135.44	134.9	134.9	1393.0
2019-10-03 06:00:00	MSFT	Stock	135.1	135.1	134.8	134.8	1800.0
2019-10-03 07:00:00	MSFT	Stock	134.77	134.78	134.09	134.21	13700.0
2019-10-03 08:00:00	MSFT	Stock	134.75	134.9	134.03	134.42	29833.0
2019-10-03 09:00:00	MSFT	Stock	134.42	135.3	134.31	135.06	1750918.0
2019-10-03 10:00:00	MSFT	Stock	135.03	135.18	133.22	135.05	4648927.0
2019-10-03 11:00:00	MSFT	Stock	135.06	136.505	134.9	135.76	3277213.0
2019-10-03 12:00:00	MSFT	Stock	135.76	136.34	135.73	136.21	2113312.0
2019-10-03 13:00:00	MSFT	Stock	136.215	136.75	136.188	136.53	1772661.0
2019-10-03 14:00:00	MSFT	Stock	136.54	136.56	136.18	136.308	1365874.0
2019-10-03 15:00:00	MSFT	Stock	136.305	136.37	135.82	136.3	3358362.0
2019-10-03 16:00:00	MSFT	Stock	136.28	136.48	136.11	136.36	2141159.0
2019-10-03 17:00:00	MSFT	Stock	136.37	136.393	136.11	136.25	8561.0
2019-10-03 18:00:00	MSFT	Stock	136.12	136.35	136.12	136.24	4245.0
2019-10-03 19:00:00	MSFT	Stock	136.21	136.28	135.95	135.95	12193.0
2019-10-03 04:00:00	NVDA	Stock	4.33	4.33	4.33	4.33	4000.0
2019-10-03 07:00:00	NVDA	Stock	4.3175	4.3312	4.3118	4.3118	433160.0
2019-10-03 08:00:00	NVDA	Stock	4.3326	4.3375	4.31	4.3225	192280.0
2019-10-03 09:00:00	NVDA	Stock	4.3263	4.4023	4.3263	4.3933	44403200.0
2019-10-03 10:00:00	NVDA	Stock	4.3912	4.3932	4.3	4.3813	101817400.0
2019-10-03 11:00:00	NVDA	Stock	4.3805	4.4689	4.3765	4.4505	47815040.0
2019-10-03 12:00:00	NVDA	Stock	4.4506	4.5015	4.4506	4.495	42913560.0
2019-10-03 13:00:00	NVDA	Stock	4.4951	4.516	4.4881	4.505	38045040.0
2019-10-03 14:00:00	NVDA	Stock	4.5052	4.5238	4.5	4.5145	26792880.0
2019-10-03 15:00:00	NVDA	Stock	4.5148	4.539	4.502	4.533	64985880.0
2019-10-03 16:00:00	NVDA	Stock	4.533	4.5417	4.5275	4.5388	21504840.0
2019-10-03 17:00:00	NVDA	Stock	4.539	4.539	4.5328	4.5328	679840.0
2019-10-03 18:00:00	NVDA	Stock	4.5338	4.534	4.53	4.5308	135400.0
2019-10-03 19:00:00	NVDA	Stock	4.53	4.5362	4.528	4.5295	202760.0
2019-10-03 07:00:00	AMZN	Stock	85.675	85.7	85.675	85.7	5400.0
2019-10-03 08:00:00	AMZN	Stock	85.7	85.75	85.45	85.65	72460.0
2019-10-03 09:00:00	AMZN	Stock	85.6475	85.899	85.3905	85.5451	6724320.0
2019-10-03 10:00:00	AMZN	Stock	85.532	85.532	84.253	85.0748	12529880.0
2019-10-03 11:00:00	AMZN	Stock	85.046	85.5765	84.981	85.2738	7421260.0

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

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