PREVIEW / stock_1hour / 2021-09-10

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-09-10.parquet
  size:    1.4 MB
  rows:    64,199
  symbols: 2,701

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-09-10 04:00:00	AAPL	Stock	154.94	155.03	154.8	154.91	12473.0
2021-09-10 05:00:00	AAPL	Stock	154.91	154.91	154.77	154.83	9870.0
2021-09-10 06:00:00	AAPL	Stock	154.93	154.93	154.75	154.9	8128.0
2021-09-10 07:00:00	AAPL	Stock	154.9	154.98	154.65	154.97	112848.0
2021-09-10 08:00:00	AAPL	Stock	154.76	155.08	154.455	154.88	241687.0
2021-09-10 09:00:00	AAPL	Stock	154.88	155.48	154.76	155.3499	9239541.0
2021-09-10 10:00:00	AAPL	Stock	155.355	155.43	153.91	154.345	9610673.0
2021-09-10 11:00:00	AAPL	Stock	154.345	154.39	148.7	149.21	40859347.0
2021-09-10 12:00:00	AAPL	Stock	149.2009	150.8038	148.92	150.26	21604074.0
2021-09-10 13:00:00	AAPL	Stock	150.28	150.77	149.875	149.985	10705939.0
2021-09-10 14:00:00	AAPL	Stock	149.9801	150.258	149.51	149.8784	8578505.0
2021-09-10 15:00:00	AAPL	Stock	149.88	149.94	148.74	149.0	17259974.0
2021-09-10 16:00:00	AAPL	Stock	148.97	149.04	148.83	148.98	6004999.0
2021-09-10 17:00:00	AAPL	Stock	148.99	149.15	148.97	149.15	210366.0
2021-09-10 18:00:00	AAPL	Stock	149.15	149.15	148.88	148.88	107585.0
2021-09-10 19:00:00	AAPL	Stock	148.89	148.91	148.65	148.67	98309.0
2021-09-10 04:00:00	MSFT	Stock	298.06	298.55	298.06	298.55	801.0
2021-09-10 05:00:00	MSFT	Stock	298.34	298.4	298.33	298.33	1011.0
2021-09-10 06:00:00	MSFT	Stock	298.04	298.48	298.01	298.48	1507.0
2021-09-10 07:00:00	MSFT	Stock	298.39	298.5	298.2	298.31	9425.0
2021-09-10 08:00:00	MSFT	Stock	298.2	298.6699	297.993	298.5	40671.0
2021-09-10 09:00:00	MSFT	Stock	298.32	299.0894	297.57	297.785	1432332.0
2021-09-10 10:00:00	MSFT	Stock	297.77	297.8	296.4	297.3594	2053060.0
2021-09-10 11:00:00	MSFT	Stock	297.36	298.1199	296.64	297.94	1170487.0
2021-09-10 12:00:00	MSFT	Stock	297.98	299.92	297.78	299.56	1589583.0
2021-09-10 13:00:00	MSFT	Stock	299.57	299.7	298.73	298.84	877065.0
2021-09-10 14:00:00	MSFT	Stock	298.84	298.88	297.8855	297.9299	862416.0
2021-09-10 15:00:00	MSFT	Stock	297.92	297.96	295.38	295.73	3660127.0
2021-09-10 16:00:00	MSFT	Stock	295.72	296.34	295.61	295.61	2659512.0
2021-09-10 17:00:00	MSFT	Stock	295.61	295.71	295.32	295.5	7160.0
2021-09-10 18:00:00	MSFT	Stock	295.53	295.53	295.38	295.4	4251.0
2021-09-10 19:00:00	MSFT	Stock	295.44	295.44	295.21	295.21	3471.0
2021-09-10 04:00:00	NVDA	Stock	22.177	22.31	22.177	22.3	21910.0
2021-09-10 05:00:00	NVDA	Stock	22.308	22.323	22.3	22.3	5900.0
2021-09-10 06:00:00	NVDA	Stock	22.3	22.3	22.257	22.3	13620.0
2021-09-10 07:00:00	NVDA	Stock	22.3	22.359	22.3	22.324	371300.0
2021-09-10 08:00:00	NVDA	Stock	22.317	22.379	22.2853	22.33	423930.0
2021-09-10 09:00:00	NVDA	Stock	22.332	22.626	22.31	22.568	37981260.0
2021-09-10 10:00:00	NVDA	Stock	22.568	22.5819	22.27	22.355	34293070.0
2021-09-10 11:00:00	NVDA	Stock	22.3573	22.4889	22.281	22.4665	16623840.0
2021-09-10 12:00:00	NVDA	Stock	22.466	22.528	22.421	22.5045	15545360.0
2021-09-10 13:00:00	NVDA	Stock	22.508	22.596	22.501	22.571	20205930.0
2021-09-10 14:00:00	NVDA	Stock	22.572	22.588	22.494	22.536	12731170.0
2021-09-10 15:00:00	NVDA	Stock	22.535	22.556	22.434	22.4731	40827680.0
2021-09-10 16:00:00	NVDA	Stock	22.478	22.49	22.45	22.48	14374680.0
2021-09-10 17:00:00	NVDA	Stock	22.489	22.489	22.478	22.478	75020.0
2021-09-10 18:00:00	NVDA	Stock	22.479	22.493	22.478	22.478	65620.0
2021-09-10 19:00:00	NVDA	Stock	22.478	22.488	22.478	22.482	99590.0
2021-09-10 07:00:00	AMZN	Stock	175.1005	175.2325	175.1005	175.185	12000.0
2021-09-10 08:00:00	AMZN	Stock	175.1396	175.3035	175.0753	175.1505	117220.0

> showing 50 of 64,199 rows — these rows as CSV

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