PREVIEW / stock_1hour / 2021-11-17

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-11-17.parquet
  size:    1.5 MB
  rows:    67,221
  symbols: 2,703

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-11-17 04:00:00	AAPL	Stock	150.99	151.27	150.93	151.05	8529.0
2021-11-17 05:00:00	AAPL	Stock	151.0	151.02	150.92	150.96	2612.0
2021-11-17 06:00:00	AAPL	Stock	150.95	151.06	150.93	151.06	8076.0
2021-11-17 07:00:00	AAPL	Stock	151.06	151.27	150.99	151.06	72366.0
2021-11-17 08:00:00	AAPL	Stock	151.0363	151.24	150.623	151.07	152988.0
2021-11-17 09:00:00	AAPL	Stock	151.09	152.78	150.72	152.07	10318202.0
2021-11-17 10:00:00	AAPL	Stock	152.08	152.78	152.0545	152.6187	9136135.0
2021-11-17 11:00:00	AAPL	Stock	152.62	155.0	152.605	154.985	16498710.0
2021-11-17 12:00:00	AAPL	Stock	154.985	155.0	153.77	154.005	9783679.0
2021-11-17 13:00:00	AAPL	Stock	154.01	154.545	153.735	154.295	5689536.0
2021-11-17 14:00:00	AAPL	Stock	154.295	154.545	153.78	154.11	5041689.0
2021-11-17 15:00:00	AAPL	Stock	154.105	154.27	153.34	153.65	11587630.0
2021-11-17 16:00:00	AAPL	Stock	153.49	153.57	153.21	153.55	7856957.0
2021-11-17 17:00:00	AAPL	Stock	153.58	153.71	153.3001	153.32	96169.0
2021-11-17 18:00:00	AAPL	Stock	153.35	153.69	153.33	153.65	31604.0
2021-11-17 19:00:00	AAPL	Stock	153.66	153.72	153.5	153.68	46206.0
2021-11-17 04:00:00	MSFT	Stock	339.61	339.61	339.1	339.25	2348.0
2021-11-17 05:00:00	MSFT	Stock	339.87	340.0	339.87	340.0	616.0
2021-11-17 06:00:00	MSFT	Stock	339.89	339.96	339.84	339.87	2438.0
2021-11-17 07:00:00	MSFT	Stock	339.88	340.13	339.0	339.2	22559.0
2021-11-17 08:00:00	MSFT	Stock	339.1559	340.16	338.8	339.46	29337.0
2021-11-17 09:00:00	MSFT	Stock	339.55	340.33	338.0	338.11	1434192.0
2021-11-17 10:00:00	MSFT	Stock	338.205	340.2	338.16	339.84	1698563.0
2021-11-17 11:00:00	MSFT	Stock	339.83	342.14	339.83	342.03	1607533.0
2021-11-17 12:00:00	MSFT	Stock	342.05	342.19	340.01	340.355	1327993.0
2021-11-17 13:00:00	MSFT	Stock	340.33	340.79	339.73	340.21	890103.0
2021-11-17 14:00:00	MSFT	Stock	340.22	340.27	339.47	339.87	724095.0
2021-11-17 15:00:00	MSFT	Stock	339.88	340.24	339.0	339.15	2337653.0
2021-11-17 16:00:00	MSFT	Stock	339.12	339.55	338.9	339.2	3083957.0
2021-11-17 17:00:00	MSFT	Stock	339.21	339.49	339.12	339.19	11373.0
2021-11-17 18:00:00	MSFT	Stock	339.3	339.4	339.12	339.16	2339.0
2021-11-17 19:00:00	MSFT	Stock	339.24	339.4	339.17	339.4	4774.0
2021-11-17 04:00:00	NVDA	Stock	30.38	30.467	30.212	30.3	143740.0
2021-11-17 05:00:00	NVDA	Stock	30.301	30.349	30.255	30.349	35280.0
2021-11-17 06:00:00	NVDA	Stock	30.32	30.416	30.31	30.32	48510.0
2021-11-17 07:00:00	NVDA	Stock	30.347	30.5	30.347	30.41	667140.0
2021-11-17 08:00:00	NVDA	Stock	30.48	30.497	30.27	30.39	1252890.0
2021-11-17 09:00:00	NVDA	Stock	30.399	30.55	29.65	29.775	36758160.0
2021-11-17 10:00:00	NVDA	Stock	29.773	29.8727	29.607	29.845	30193740.0
2021-11-17 11:00:00	NVDA	Stock	29.8425	30.1206	29.832	30.0195	25020690.0
2021-11-17 12:00:00	NVDA	Stock	30.0195	30.035	29.231	29.2815	38475450.0
2021-11-17 13:00:00	NVDA	Stock	29.285	29.687	29.23	29.6816	24241510.0
2021-11-17 14:00:00	NVDA	Stock	29.677	29.687	29.3965	29.4341	21271900.0
2021-11-17 15:00:00	NVDA	Stock	29.436	29.436	28.8	29.257	65786700.0
2021-11-17 16:00:00	NVDA	Stock	29.261	30.55	29.2	30.484	36825630.0
2021-11-17 17:00:00	NVDA	Stock	30.484	30.918	30.351	30.8	12660260.0
2021-11-17 18:00:00	NVDA	Stock	30.858	30.86	29.261	30.698	2313220.0
2021-11-17 19:00:00	NVDA	Stock	30.695	30.8	30.647	30.775	2128360.0
2021-11-17 06:00:00	AMZN	Stock	177.5335	177.5335	177.5335	177.5335	36660.0
2021-11-17 07:00:00	AMZN	Stock	177.6245	178.05	177.55	177.9445	26500.0

> showing 50 of 67,221 rows — these rows as CSV

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