PREVIEW / stock_1hour / 2020-11-12

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-11-12.parquet
  size:    1.3 MB
  rows:    58,162
  symbols: 2,509

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
2020-11-12 04:00:00	AAPL	Stock	119.22	119.97	118.7	119.83	56712.0
2020-11-12 05:00:00	AAPL	Stock	119.94	120.16	119.61	119.95	69511.0
2020-11-12 06:00:00	AAPL	Stock	119.98	120.0	119.68	119.8	18500.0
2020-11-12 07:00:00	AAPL	Stock	119.89	119.89	119.19	119.35	223681.0
2020-11-12 08:00:00	AAPL	Stock	119.55	119.89	119.15	119.65	584711.0
2020-11-12 09:00:00	AAPL	Stock	119.66	120.05	118.81	119.72	14533482.0
2020-11-12 10:00:00	AAPL	Stock	119.73	120.53	119.5	120.21	15243738.0
2020-11-12 11:00:00	AAPL	Stock	120.22	120.52	119.03	119.595	12285929.0
2020-11-12 12:00:00	AAPL	Stock	119.6	120.205	118.97	119.49	13712182.0
2020-11-12 13:00:00	AAPL	Stock	119.48	119.495	118.57	119.135	10086181.0
2020-11-12 14:00:00	AAPL	Stock	119.13	119.29	118.58	119.07	9290083.0
2020-11-12 15:00:00	AAPL	Stock	119.065	119.47	118.8	119.235	12437264.0
2020-11-12 16:00:00	AAPL	Stock	119.21	119.776	119.13	119.28	5146872.0
2020-11-12 17:00:00	AAPL	Stock	119.29	119.3	119.07	119.15	74626.0
2020-11-12 18:00:00	AAPL	Stock	119.22	119.29	119.05	119.1	68821.0
2020-11-12 19:00:00	AAPL	Stock	119.06	119.15	118.9	119.0	117590.0
2020-11-12 04:00:00	MSFT	Stock	216.0	217.96	215.98	217.95	3850.0
2020-11-12 05:00:00	MSFT	Stock	218.2	218.48	217.59	217.7	4257.0
2020-11-12 06:00:00	MSFT	Stock	217.5	217.88	217.06	217.88	2883.0
2020-11-12 07:00:00	MSFT	Stock	217.78	217.78	215.98	216.55	40447.0
2020-11-12 08:00:00	MSFT	Stock	216.36	217.6	216.002	217.15	46902.0
2020-11-12 09:00:00	MSFT	Stock	217.0	219.04	216.1	218.575	2681993.0
2020-11-12 10:00:00	MSFT	Stock	218.56	219.11	217.67	217.78	2434739.0
2020-11-12 11:00:00	MSFT	Stock	217.79	218.29	216.2	217.0	1594377.0
2020-11-12 12:00:00	MSFT	Stock	217.0	217.4	215.27	215.72	1663742.0
2020-11-12 13:00:00	MSFT	Stock	215.7	216.608	215.13	216.585	1665617.0
2020-11-12 14:00:00	MSFT	Stock	216.59	216.9	215.28	215.5	1462190.0
2020-11-12 15:00:00	MSFT	Stock	215.5	215.86	214.46	215.47	3206834.0
2020-11-12 16:00:00	MSFT	Stock	215.44	215.87	215.44	215.81	2539918.0
2020-11-12 17:00:00	MSFT	Stock	215.85	215.93	215.7	215.78	2488.0
2020-11-12 18:00:00	MSFT	Stock	215.69	215.79	215.6	215.68	6641.0
2020-11-12 19:00:00	MSFT	Stock	215.56	215.56	215.1	215.3	10128.0
2020-11-12 04:00:00	NVDA	Stock	13.4245	13.5455	13.4245	13.5455	14680.0
2020-11-12 05:00:00	NVDA	Stock	13.55	13.575	13.55	13.575	16440.0
2020-11-12 06:00:00	NVDA	Stock	13.5832	13.5832	13.5815	13.5815	12520.0
2020-11-12 07:00:00	NVDA	Stock	13.5382	13.55	13.475	13.4868	505280.0
2020-11-12 08:00:00	NVDA	Stock	13.5438	13.55	13.3863	13.4475	2569120.0
2020-11-12 09:00:00	NVDA	Stock	13.445	13.5875	13.316	13.5333	63257160.0
2020-11-12 10:00:00	NVDA	Stock	13.5352	13.766	13.486	13.646	75250400.0
2020-11-12 11:00:00	NVDA	Stock	13.6445	13.7328	13.5253	13.6275	42405320.0
2020-11-12 12:00:00	NVDA	Stock	13.625	13.6691	13.4888	13.531	30411160.0
2020-11-12 13:00:00	NVDA	Stock	13.5294	13.555	13.4568	13.5425	26286800.0
2020-11-12 14:00:00	NVDA	Stock	13.5492	13.5698	13.3659	13.433	30947720.0
2020-11-12 15:00:00	NVDA	Stock	13.43	13.4838	13.3838	13.4625	25671640.0
2020-11-12 16:00:00	NVDA	Stock	13.4568	13.5286	13.4554	13.48	10333160.0
2020-11-12 17:00:00	NVDA	Stock	13.4795	13.4855	13.4625	13.4628	209200.0
2020-11-12 18:00:00	NVDA	Stock	13.474	13.5	13.4625	13.48	726680.0
2020-11-12 19:00:00	NVDA	Stock	13.4875	13.5125	13.475	13.475	198400.0
2020-11-12 04:00:00	AMZN	Stock	157.9995	157.9995	157.9995	157.9995	6260.0
2020-11-12 05:00:00	AMZN	Stock	158.1775	158.1775	157.656	157.656	7140.0

> showing 50 of 58,162 rows — these rows as CSV

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