PREVIEW / stock_1hour / 2019-12-13

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-12-13.parquet
  size:    1.1 MB
  rows:    50,755
  symbols: 2,500

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-12-13 04:00:00	AAPL	Stock	68.285	68.4575	68.2525	68.325	18400.0
2019-12-13 05:00:00	AAPL	Stock	68.33	68.4	68.33	68.3875	18828.0
2019-12-13 06:00:00	AAPL	Stock	68.385	68.385	68.15	68.195	47176.0
2019-12-13 07:00:00	AAPL	Stock	68.2375	68.2975	67.675	67.875	314372.0
2019-12-13 08:00:00	AAPL	Stock	67.9475	68.2975	67.7475	68.1425	655708.0
2019-12-13 09:00:00	AAPL	Stock	68.14	68.3925	67.7	68.2275	15044440.0
2019-12-13 10:00:00	AAPL	Stock	68.2325	68.7	68.08	68.175	29457836.0
2019-12-13 11:00:00	AAPL	Stock	68.175	68.58	68.0075	68.565	16580824.0
2019-12-13 12:00:00	AAPL	Stock	68.565	68.745	68.49	68.7382	11713576.0
2019-12-13 13:00:00	AAPL	Stock	68.7375	68.75	68.5775	68.68	7558504.0
2019-12-13 14:00:00	AAPL	Stock	68.675	68.69	68.4325	68.6188	7327292.0
2019-12-13 15:00:00	AAPL	Stock	68.6175	68.825	68.5575	68.815	16594292.0
2019-12-13 16:00:00	AAPL	Stock	68.8175	68.8225	68.76	68.775	8009940.0
2019-12-13 17:00:00	AAPL	Stock	68.765	68.805	68.75	68.79	102260.0
2019-12-13 18:00:00	AAPL	Stock	68.7925	68.795	68.775	68.775	57992.0
2019-12-13 19:00:00	AAPL	Stock	68.7925	68.825	68.775	68.825	67204.0
2019-12-13 04:00:00	MSFT	Stock	153.88	154.0	153.8	153.9	4189.0
2019-12-13 05:00:00	MSFT	Stock	153.9	154.12	153.9	154.07	3648.0
2019-12-13 06:00:00	MSFT	Stock	154.0	154.04	153.9	153.9	2127.0
2019-12-13 07:00:00	MSFT	Stock	153.88	153.88	153.21	153.35	24057.0
2019-12-13 08:00:00	MSFT	Stock	153.884	153.9	153.21	153.508	46919.0
2019-12-13 09:00:00	MSFT	Stock	153.617	153.79	152.5	153.6	2026703.0
2019-12-13 10:00:00	MSFT	Stock	153.59	154.6	153.43	153.93	5209374.0
2019-12-13 11:00:00	MSFT	Stock	153.94	154.66	153.87	154.66	2413896.0
2019-12-13 12:00:00	MSFT	Stock	154.67	154.89	154.565	154.835	1748678.0
2019-12-13 13:00:00	MSFT	Stock	154.85	154.85	154.4	154.515	1479239.0
2019-12-13 14:00:00	MSFT	Stock	154.52	154.637	154.34	154.56	1339798.0
2019-12-13 15:00:00	MSFT	Stock	154.56	154.67	154.32	154.54	2881599.0
2019-12-13 16:00:00	MSFT	Stock	154.53	154.665	154.35	154.55	3570767.0
2019-12-13 17:00:00	MSFT	Stock	154.48	154.55	154.48	154.53	1341.0
2019-12-13 18:00:00	MSFT	Stock	154.45	154.53	154.45	154.5	1385.0
2019-12-13 19:00:00	MSFT	Stock	154.53	154.53	154.5	154.5	2363.0
2019-12-13 04:00:00	NVDA	Stock	5.675	5.68	5.667	5.6675	149200.0
2019-12-13 05:00:00	NVDA	Stock	5.6675	5.6795	5.6663	5.6795	250240.0
2019-12-13 06:00:00	NVDA	Stock	5.675	5.675	5.653	5.654	349280.0
2019-12-13 07:00:00	NVDA	Stock	5.666	5.699	5.6375	5.6375	2602040.0
2019-12-13 08:00:00	NVDA	Stock	5.6642	5.6995	5.6495	5.6745	2917600.0
2019-12-13 09:00:00	NVDA	Stock	5.677	5.677	5.5455	5.642	63774440.0
2019-12-13 10:00:00	NVDA	Stock	5.6415	5.7245	5.5822	5.588	128836320.0
2019-12-13 11:00:00	NVDA	Stock	5.589	5.619	5.5535	5.6188	55038720.0
2019-12-13 12:00:00	NVDA	Stock	5.6182	5.6393	5.6065	5.6382	31730840.0
2019-12-13 13:00:00	NVDA	Stock	5.6387	5.645	5.6027	5.61	24171440.0
2019-12-13 14:00:00	NVDA	Stock	5.61	5.6182	5.6027	5.6149	21118440.0
2019-12-13 15:00:00	NVDA	Stock	5.6148	5.6235	5.5928	5.5998	47145200.0
2019-12-13 16:00:00	NVDA	Stock	5.5998	5.6038	5.5925	5.5925	2021520.0
2019-12-13 17:00:00	NVDA	Stock	5.5965	5.6	5.5928	5.5928	52280.0
2019-12-13 18:00:00	NVDA	Stock	5.5925	5.597	5.5925	5.5925	60720.0
2019-12-13 19:00:00	NVDA	Stock	5.5928	5.5988	5.5925	5.5988	166400.0
2019-12-13 05:00:00	AMZN	Stock	88.4	88.5	88.4	88.5	6980.0
2019-12-13 06:00:00	AMZN	Stock	88.4	88.45	88.4	88.432	25000.0

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

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