PREVIEW / stock_1hour / 2021-08-17

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-08-17.parquet
  size:    1.4 MB
  rows:    65,885
  symbols: 2,848

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-08-17 04:00:00	AAPL	Stock	150.79	151.03	150.5	150.71	93192.0
2021-08-17 05:00:00	AAPL	Stock	150.75	150.89	150.16	150.58	38479.0
2021-08-17 06:00:00	AAPL	Stock	150.58	150.83	150.58	150.78	25160.0
2021-08-17 07:00:00	AAPL	Stock	150.82	151.03	150.65	150.89	204501.0
2021-08-17 08:00:00	AAPL	Stock	150.8301	151.12	150.39	150.43	812272.0
2021-08-17 09:00:00	AAPL	Stock	150.43	151.68	149.32	150.51	16701260.0
2021-08-17 10:00:00	AAPL	Stock	150.49	151.4899	149.7601	151.1	12942162.0
2021-08-17 11:00:00	AAPL	Stock	151.11	151.35	150.13	150.155	9403050.0
2021-08-17 12:00:00	AAPL	Stock	150.16	150.39	149.12	149.2292	9409050.0
2021-08-17 13:00:00	AAPL	Stock	149.221	149.67	149.09	149.49	6560201.0
2021-08-17 14:00:00	AAPL	Stock	149.485	150.1731	149.46	150.035	7819108.0
2021-08-17 15:00:00	AAPL	Stock	150.0301	150.29	149.72	150.23	10969150.0
2021-08-17 16:00:00	AAPL	Stock	150.19	150.25	149.8	149.85	6843050.0
2021-08-17 17:00:00	AAPL	Stock	149.91	150.04	149.9	149.9999	23510.0
2021-08-17 18:00:00	AAPL	Stock	149.96	150.02	149.81	149.81	37677.0
2021-08-17 19:00:00	AAPL	Stock	149.85	149.92	149.75	149.77	41490.0
2021-08-17 04:00:00	MSFT	Stock	294.0	294.05	293.96	293.96	3397.0
2021-08-17 05:00:00	MSFT	Stock	294.04	294.13	294.02	294.09	5683.0
2021-08-17 06:00:00	MSFT	Stock	294.0	294.48	293.91	294.2	6289.0
2021-08-17 07:00:00	MSFT	Stock	294.1	294.2	293.0	293.39	58408.0
2021-08-17 08:00:00	MSFT	Stock	294.1308	294.31	292.56	293.0	38621.0
2021-08-17 09:00:00	MSFT	Stock	292.99	293.43	291.62	292.12	1744834.0
2021-08-17 10:00:00	MSFT	Stock	292.08	293.2999	291.315	292.88	1919808.0
2021-08-17 11:00:00	MSFT	Stock	292.89	293.0688	291.21	291.26	1407498.0
2021-08-17 12:00:00	MSFT	Stock	291.26	292.57	291.08	292.1914	1785903.0
2021-08-17 13:00:00	MSFT	Stock	292.18	292.86	292.05	292.7	1300939.0
2021-08-17 14:00:00	MSFT	Stock	292.68	293.2893	292.63	293.24	1189367.0
2021-08-17 15:00:00	MSFT	Stock	293.25	293.4	292.53	293.22	2705605.0
2021-08-17 16:00:00	MSFT	Stock	293.08	293.18	292.5	292.5	3037795.0
2021-08-17 17:00:00	MSFT	Stock	292.53	292.68	292.31	292.51	8365.0
2021-08-17 18:00:00	MSFT	Stock	292.5	292.61	292.35	292.55	11904.0
2021-08-17 19:00:00	MSFT	Stock	292.69	292.85	292.55	292.85	19867.0
2021-08-17 04:00:00	NVDA	Stock	19.751	19.8	19.698	19.8	119270.0
2021-08-17 05:00:00	NVDA	Stock	19.798	19.81	19.736	19.736	71140.0
2021-08-17 06:00:00	NVDA	Stock	19.745	19.85	19.737	19.82	18790.0
2021-08-17 07:00:00	NVDA	Stock	19.81	19.82	19.745	19.769	172720.0
2021-08-17 08:00:00	NVDA	Stock	19.817	19.82	19.712	19.728	357890.0
2021-08-17 09:00:00	NVDA	Stock	19.7152	19.774	19.461	19.4945	20434160.0
2021-08-17 10:00:00	NVDA	Stock	19.4935	19.77	19.3795	19.6345	27878410.0
2021-08-17 11:00:00	NVDA	Stock	19.639	19.643	19.351	19.356	20600550.0
2021-08-17 12:00:00	NVDA	Stock	19.359	19.485	19.28	19.2916	17459180.0
2021-08-17 13:00:00	NVDA	Stock	19.292	19.4059	19.267	19.361	14589520.0
2021-08-17 14:00:00	NVDA	Stock	19.358	19.445	19.336	19.425	11945990.0
2021-08-17 15:00:00	NVDA	Stock	19.425	19.468	19.363	19.457	20885850.0
2021-08-17 16:00:00	NVDA	Stock	19.458	19.485	19.425	19.454	20806380.0
2021-08-17 17:00:00	NVDA	Stock	19.457	19.475	19.45	19.46	210330.0
2021-08-17 18:00:00	NVDA	Stock	19.47	19.47	19.401	19.406	302010.0
2021-08-17 19:00:00	NVDA	Stock	19.438	19.438	19.395	19.415	170190.0
2021-08-17 04:00:00	AMZN	Stock	161.75	161.75	161.75	161.75	2260.0
2021-08-17 05:00:00	AMZN	Stock	164.1	164.25	164.006	164.006	15960.0

> showing 50 of 65,885 rows — these rows as CSV

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