PREVIEW / stock_1hour / 2021-10-08

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-10-08.parquet
  size:    1.4 MB
  rows:    62,637
  symbols: 2,682

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-10-08 04:00:00	AAPL	Stock	143.24	143.27	142.65	142.7	40221.0
2021-10-08 05:00:00	AAPL	Stock	142.66	143.05	142.6	143.05	5439.0
2021-10-08 06:00:00	AAPL	Stock	143.05	143.19	143.0	143.05	6723.0
2021-10-08 07:00:00	AAPL	Stock	143.0	143.49	143.0	143.44	74907.0
2021-10-08 08:00:00	AAPL	Stock	143.3301	144.35	143.05	144.05	736921.0
2021-10-08 09:00:00	AAPL	Stock	144.09	144.18	143.0601	143.1823	7671056.0
2021-10-08 10:00:00	AAPL	Stock	143.18	143.96	143.07	143.285	8430693.0
2021-10-08 11:00:00	AAPL	Stock	143.29	143.49	142.95	143.0101	5621170.0
2021-10-08 12:00:00	AAPL	Stock	143.02	143.25	142.8	142.97	4846822.0
2021-10-08 13:00:00	AAPL	Stock	142.975	143.06	142.56	142.865	4608237.0
2021-10-08 14:00:00	AAPL	Stock	142.87	143.4	142.8301	143.065	4729882.0
2021-10-08 15:00:00	AAPL	Stock	143.0601	143.34	142.783	143.01	7686647.0
2021-10-08 16:00:00	AAPL	Stock	142.99	143.2744	142.75	142.95	7964918.0
2021-10-08 17:00:00	AAPL	Stock	142.96	142.99	142.86	142.9	23601.0
2021-10-08 18:00:00	AAPL	Stock	142.9	142.93	142.85	142.86	18103.0
2021-10-08 19:00:00	AAPL	Stock	142.85	142.91	142.8	142.81	30578.0
2021-10-08 04:00:00	MSFT	Stock	294.81	294.81	294.1	294.11	1853.0
2021-10-08 05:00:00	MSFT	Stock	293.99	294.43	293.99	294.43	1377.0
2021-10-08 06:00:00	MSFT	Stock	294.78	294.78	294.53	294.67	853.0
2021-10-08 07:00:00	MSFT	Stock	294.72	295.45	294.72	295.27	7828.0
2021-10-08 08:00:00	MSFT	Stock	295.2298	297.45	294.79	296.291	86262.0
2021-10-08 09:00:00	MSFT	Stock	296.5	296.9	294.57	295.1636	1650783.0
2021-10-08 10:00:00	MSFT	Stock	295.15	296.52	294.86	295.47	1768950.0
2021-10-08 11:00:00	MSFT	Stock	295.515	296.14	294.5387	294.81	1216412.0
2021-10-08 12:00:00	MSFT	Stock	294.8099	295.45	294.51	294.81	966696.0
2021-10-08 13:00:00	MSFT	Stock	294.83	294.95	293.76	294.77	1194335.0
2021-10-08 14:00:00	MSFT	Stock	294.755	295.56	294.7	295.28	880119.0
2021-10-08 15:00:00	MSFT	Stock	295.29	295.64	294.09	294.85	1830312.0
2021-10-08 16:00:00	MSFT	Stock	294.85	295.5156	294.54	294.85	3656678.0
2021-10-08 17:00:00	MSFT	Stock	294.8	294.85	294.66	294.75	767.0
2021-10-08 18:00:00	MSFT	Stock	294.6601	294.68	294.66	294.66	1613.0
2021-10-08 19:00:00	MSFT	Stock	294.64	294.64	294.34	294.53	3247.0
2021-10-08 04:00:00	NVDA	Stock	21.085	21.1	21.0	21.0	34720.0
2021-10-08 05:00:00	NVDA	Stock	20.982	21.001	20.941	20.995	8130.0
2021-10-08 06:00:00	NVDA	Stock	21.002	21.026	21.001	21.02	17300.0
2021-10-08 07:00:00	NVDA	Stock	21.054	21.175	21.02	21.165	248030.0
2021-10-08 08:00:00	NVDA	Stock	21.0272	21.299	21.0272	21.201	1641760.0
2021-10-08 09:00:00	NVDA	Stock	21.198	21.206	20.925	20.973	20829340.0
2021-10-08 10:00:00	NVDA	Stock	20.9725	21.1531	20.92	21.0315	22002020.0
2021-10-08 11:00:00	NVDA	Stock	21.032	21.063	20.921	20.936	11957170.0
2021-10-08 12:00:00	NVDA	Stock	20.935	20.975	20.888	20.911	11012810.0
2021-10-08 13:00:00	NVDA	Stock	20.913	20.946	20.775	20.8625	12019350.0
2021-10-08 14:00:00	NVDA	Stock	20.866	20.938	20.845	20.9132	9671230.0
2021-10-08 15:00:00	NVDA	Stock	20.914	20.941	20.809	20.826	17837490.0
2021-10-08 16:00:00	NVDA	Stock	20.826	20.9247	20.776	20.786	11726220.0
2021-10-08 17:00:00	NVDA	Stock	20.786	20.8	20.781	20.796	41310.0
2021-10-08 18:00:00	NVDA	Stock	20.782	20.789	20.78	20.785	43960.0
2021-10-08 19:00:00	NVDA	Stock	20.78	20.79	20.755	20.785	118400.0
2021-10-08 06:00:00	AMZN	Stock	164.75	164.75	164.75	164.75	2500.0
2021-10-08 07:00:00	AMZN	Stock	164.89	165.4	164.89	165.3	24820.0

> showing 50 of 62,637 rows — these rows as CSV

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