PREVIEW / stock_1hour / 2021-05-10

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-05-10.parquet
  size:    1.4 MB
  rows:    66,622
  symbols: 2,983

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
2021-05-10 04:00:00	AAPL	Stock	129.98	130.18	129.7	129.7	17300.0
2021-05-10 05:00:00	AAPL	Stock	129.6	129.9	129.6	129.9	6563.0
2021-05-10 06:00:00	AAPL	Stock	129.85	130.16	129.85	130.16	9400.0
2021-05-10 07:00:00	AAPL	Stock	130.14	130.17	129.7	129.78	100086.0
2021-05-10 08:00:00	AAPL	Stock	129.9599	130.18	129.7	129.86	230595.0
2021-05-10 09:00:00	AAPL	Stock	129.86	130.04	128.174	128.45	10701227.0
2021-05-10 10:00:00	AAPL	Stock	128.46	128.65	127.865	128.185	11706684.0
2021-05-10 11:00:00	AAPL	Stock	128.19	128.5471	127.89	128.5339	7552168.0
2021-05-10 12:00:00	AAPL	Stock	128.54	128.705	128.16	128.32	5616356.0
2021-05-10 13:00:00	AAPL	Stock	128.32	128.5	127.97	128.055	5182049.0
2021-05-10 14:00:00	AAPL	Stock	128.06	128.11	126.82	127.06	11154161.0
2021-05-10 15:00:00	AAPL	Stock	127.065	127.5	126.81	126.86	14142265.0
2021-05-10 16:00:00	AAPL	Stock	126.85	127.9881	126.324	126.45	9428257.0
2021-05-10 17:00:00	AAPL	Stock	126.5	126.61	126.31	126.46	145339.0
2021-05-10 18:00:00	AAPL	Stock	126.46	126.53	126.31	126.42	142679.0
2021-05-10 19:00:00	AAPL	Stock	126.41	126.47	126.3	126.32	128851.0
2021-05-10 04:00:00	MSFT	Stock	251.83	252.03	251.79	251.87	5383.0
2021-05-10 05:00:00	MSFT	Stock	251.76	251.98	251.0	251.0	9613.0
2021-05-10 06:00:00	MSFT	Stock	251.05	251.5	251.03	251.23	5169.0
2021-05-10 07:00:00	MSFT	Stock	251.45	251.7	250.59	250.87	18967.0
2021-05-10 08:00:00	MSFT	Stock	251.5001	251.9	250.76	251.45	39674.0
2021-05-10 09:00:00	MSFT	Stock	251.44	251.55	249.34	251.38	2269936.0
2021-05-10 10:00:00	MSFT	Stock	251.41	251.73	250.01	250.31	1893282.0
2021-05-10 11:00:00	MSFT	Stock	250.33	250.74	249.83	250.3529	1730606.0
2021-05-10 12:00:00	MSFT	Stock	250.36	251.08	249.916	249.96	1268475.0
2021-05-10 13:00:00	MSFT	Stock	249.96	250.34	249.56	249.82	1296484.0
2021-05-10 14:00:00	MSFT	Stock	249.82	249.89	247.43	247.83	2605113.0
2021-05-10 15:00:00	MSFT	Stock	247.83	248.73	247.12	247.18	3912809.0
2021-05-10 16:00:00	MSFT	Stock	247.18	247.49	246.43	246.6	5408369.0
2021-05-10 17:00:00	MSFT	Stock	246.53	246.85	246.5	246.8	10041.0
2021-05-10 18:00:00	MSFT	Stock	246.8	247.14	246.6	246.85	6158.0
2021-05-10 19:00:00	MSFT	Stock	246.84	247.16	246.6	247.14	12100.0
2021-05-10 04:00:00	NVDA	Stock	14.7465	14.7475	14.7	14.7235	25960.0
2021-05-10 05:00:00	NVDA	Stock	14.7245	14.7245	14.7245	14.7245	4280.0
2021-05-10 07:00:00	NVDA	Stock	14.7038	14.746	14.7038	14.7055	102760.0
2021-05-10 08:00:00	NVDA	Stock	14.7125	14.75	14.7068	14.713	232960.0
2021-05-10 09:00:00	NVDA	Stock	14.725	14.806	14.3648	14.42	24117480.0
2021-05-10 10:00:00	NVDA	Stock	14.412	14.5248	14.3367	14.3854	24837360.0
2021-05-10 11:00:00	NVDA	Stock	14.3873	14.466	14.3415	14.462	17538520.0
2021-05-10 12:00:00	NVDA	Stock	14.458	14.4961	14.3863	14.398	11617000.0
2021-05-10 13:00:00	NVDA	Stock	14.398	14.4528	14.3718	14.4075	10555240.0
2021-05-10 14:00:00	NVDA	Stock	14.403	14.4055	14.2825	14.341	21977760.0
2021-05-10 15:00:00	NVDA	Stock	14.3382	14.3751	14.25	14.2708	30768560.0
2021-05-10 16:00:00	NVDA	Stock	14.2708	14.3976	14.2125	14.225	27880960.0
2021-05-10 17:00:00	NVDA	Stock	14.2188	14.25	14.1882	14.195	289400.0
2021-05-10 18:00:00	NVDA	Stock	14.1995	14.2085	14.1875	14.1892	210480.0
2021-05-10 19:00:00	NVDA	Stock	14.1972	14.2038	14.1762	14.195	67680.0
2021-05-10 07:00:00	AMZN	Stock	164.2525	164.325	163.863	164.05	54420.0
2021-05-10 08:00:00	AMZN	Stock	164.0995	164.3	164.0	164.1825	27420.0
2021-05-10 09:00:00	AMZN	Stock	164.025	164.15	161.3525	161.6503	10574120.0

> showing 50 of 66,622 rows — these rows as CSV

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