PREVIEW / stock_1hour / 2021-09-21

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-09-21.parquet
  size:    1.4 MB
  rows:    63,918
  symbols: 2,669

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-21 04:00:00	AAPL	Stock	144.72	144.8	144.11	144.55	71836.0
2021-09-21 05:00:00	AAPL	Stock	144.5	144.69	144.15	144.53	32789.0
2021-09-21 06:00:00	AAPL	Stock	144.59	144.6	144.4	144.5	25634.0
2021-09-21 07:00:00	AAPL	Stock	144.45	144.53	144.04	144.31	254516.0
2021-09-21 08:00:00	AAPL	Stock	144.1999	144.5	143.297	143.87	610484.0
2021-09-21 09:00:00	AAPL	Stock	143.88	144.6	143.18	144.1173	11850616.0
2021-09-21 10:00:00	AAPL	Stock	144.11	144.3	142.88	143.015	12321581.0
2021-09-21 11:00:00	AAPL	Stock	143.02	144.23	142.78	143.975	8608341.0
2021-09-21 12:00:00	AAPL	Stock	143.97	144.3599	143.73	143.87	5854328.0
2021-09-21 13:00:00	AAPL	Stock	143.87	143.97	143.29	143.4538	5580431.0
2021-09-21 14:00:00	AAPL	Stock	143.46	144.13	143.195	143.8463	5999867.0
2021-09-21 15:00:00	AAPL	Stock	143.8489	144.23	143.4	143.41	9369456.0
2021-09-21 16:00:00	AAPL	Stock	143.4	143.47	143.07	143.23	5550735.0
2021-09-21 17:00:00	AAPL	Stock	143.23	143.43	143.07	143.18	519745.0
2021-09-21 18:00:00	AAPL	Stock	143.18	143.39	143.12	143.23	29554.0
2021-09-21 19:00:00	AAPL	Stock	143.21	143.23	143.07	143.09	41825.0
2021-09-21 04:00:00	MSFT	Stock	297.0	297.35	296.7	297.01	11533.0
2021-09-21 05:00:00	MSFT	Stock	296.73	296.73	295.62	296.28	2925.0
2021-09-21 06:00:00	MSFT	Stock	296.13	296.2	296.06	296.2	3436.0
2021-09-21 07:00:00	MSFT	Stock	296.28	296.84	296.04	296.4	44281.0
2021-09-21 08:00:00	MSFT	Stock	296.2999	296.65	295.035	295.55	56184.0
2021-09-21 09:00:00	MSFT	Stock	295.6	297.54	294.07	296.5429	2424444.0
2021-09-21 10:00:00	MSFT	Stock	296.48	296.77	294.35	294.69	2458097.0
2021-09-21 11:00:00	MSFT	Stock	294.7	296.98	294.13	296.45	1913199.0
2021-09-21 12:00:00	MSFT	Stock	296.46	296.91	295.31	295.6	1325099.0
2021-09-21 13:00:00	MSFT	Stock	295.61	295.8408	294.55	294.89	1114088.0
2021-09-21 14:00:00	MSFT	Stock	294.9	296.68	294.85	296.132	1731411.0
2021-09-21 15:00:00	MSFT	Stock	296.14	296.71	294.64	294.72	2781056.0
2021-09-21 16:00:00	MSFT	Stock	294.8	295.5	294.04	294.25	1949459.0
2021-09-21 17:00:00	MSFT	Stock	294.27	294.27	294.1	294.15	6276.0
2021-09-21 18:00:00	MSFT	Stock	294.18	294.68	294.18	294.4	6729.0
2021-09-21 19:00:00	MSFT	Stock	294.36	294.46	294.03	294.03	10469.0
2021-09-21 04:00:00	NVDA	Stock	21.352	21.505	21.345	21.46	169810.0
2021-09-21 05:00:00	NVDA	Stock	21.44	21.456	21.388	21.445	67520.0
2021-09-21 06:00:00	NVDA	Stock	21.4	21.408	21.352	21.408	18510.0
2021-09-21 07:00:00	NVDA	Stock	21.412	21.423	21.295	21.341	466710.0
2021-09-21 08:00:00	NVDA	Stock	21.35	21.418	21.275	21.275	997670.0
2021-09-21 09:00:00	NVDA	Stock	21.274	21.449	21.1239	21.13	32460010.0
2021-09-21 10:00:00	NVDA	Stock	21.127	21.174	20.95	21.017	29469450.0
2021-09-21 11:00:00	NVDA	Stock	21.018	21.356	20.995	21.3064	22230570.0
2021-09-21 12:00:00	NVDA	Stock	21.31	21.385	21.218	21.2695	14722690.0
2021-09-21 13:00:00	NVDA	Stock	21.266	21.321	21.19	21.261	12072680.0
2021-09-21 14:00:00	NVDA	Stock	21.26	21.393	21.222	21.3384	13107120.0
2021-09-21 15:00:00	NVDA	Stock	21.339	21.399	21.227	21.239	20330420.0
2021-09-21 16:00:00	NVDA	Stock	21.238	21.276	21.175	21.204	9990790.0
2021-09-21 17:00:00	NVDA	Stock	21.186	21.2159	21.175	21.185	32400.0
2021-09-21 18:00:00	NVDA	Stock	21.199	21.24	21.187	21.2	93630.0
2021-09-21 19:00:00	NVDA	Stock	21.19	21.2	21.15	21.15	85140.0
2021-09-21 06:00:00	AMZN	Stock	168.899	168.899	168.899	168.899	2000.0
2021-09-21 07:00:00	AMZN	Stock	168.936	168.9505	168.7	168.85	44180.0

> showing 50 of 63,918 rows — these rows as CSV

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