PREVIEW / stock_1hour / 2022-07-13

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-07-13.parquet
  size:    1.3 MB
  rows:    61,006
  symbols: 2,304

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
2022-07-13 04:00:00	AAPL	Stock	146.09	146.44	145.98	146.3	6956.0
2022-07-13 05:00:00	AAPL	Stock	146.3	146.35	146.19	146.19	8770.0
2022-07-13 06:00:00	AAPL	Stock	146.13	146.24	146.02	146.02	6879.0
2022-07-13 07:00:00	AAPL	Stock	146.09	146.59	146.02	146.5	47887.0
2022-07-13 08:00:00	AAPL	Stock	146.4	147.8	142.37	143.45	1020731.0
2022-07-13 09:00:00	AAPL	Stock	143.4	145.32	142.1201	145.04	11276035.0
2022-07-13 10:00:00	AAPL	Stock	145.04	146.42	143.86	145.63	11076198.0
2022-07-13 11:00:00	AAPL	Stock	145.63	146.11	144.79	145.22	5840938.0
2022-07-13 12:00:00	AAPL	Stock	145.22	146.02	145.15	145.995	4460438.0
2022-07-13 13:00:00	AAPL	Stock	146.0	146.45	145.42	146.141	4775994.0
2022-07-13 14:00:00	AAPL	Stock	146.1483	146.42	145.2	146.3901	5165992.0
2022-07-13 15:00:00	AAPL	Stock	146.4	146.42	145.4	145.45	8438929.0
2022-07-13 16:00:00	AAPL	Stock	145.45	145.69	145.03	145.1701	7634055.0
2022-07-13 17:00:00	AAPL	Stock	145.1621	145.22	145.13	145.2	28781.0
2022-07-13 18:00:00	AAPL	Stock	145.17	145.17	144.63	144.88	36335.0
2022-07-13 19:00:00	AAPL	Stock	144.83	144.93	144.3	144.35	41887.0
2022-07-13 04:00:00	MSFT	Stock	254.5	254.81	254.0	254.81	3086.0
2022-07-13 05:00:00	MSFT	Stock	255.3	255.49	255.11	255.23	3212.0
2022-07-13 06:00:00	MSFT	Stock	255.1	255.1	254.5	254.82	3929.0
2022-07-13 07:00:00	MSFT	Stock	254.97	255.42	254.18	255.11	24624.0
2022-07-13 08:00:00	MSFT	Stock	254.6413	256.65	247.0	250.26	230934.0
2022-07-13 09:00:00	MSFT	Stock	250.02	252.36	248.4143	250.13	3859110.0
2022-07-13 10:00:00	MSFT	Stock	250.12	250.92	248.11	250.5	3747388.0
2022-07-13 11:00:00	MSFT	Stock	250.51	251.92	249.33	250.55	1896676.0
2022-07-13 12:00:00	MSFT	Stock	250.56	252.8	250.5	252.77	1394153.0
2022-07-13 13:00:00	MSFT	Stock	252.77	253.55	251.8807	252.4799	1247598.0
2022-07-13 14:00:00	MSFT	Stock	252.45	253.0	250.5	252.98	1756075.0
2022-07-13 15:00:00	MSFT	Stock	252.979	253.4	251.64	252.67	3737091.0
2022-07-13 16:00:00	MSFT	Stock	252.7	252.79	252.2113	252.31	3511904.0
2022-07-13 17:00:00	MSFT	Stock	252.4035	252.4035	252.1	252.24	6990.0
2022-07-13 18:00:00	MSFT	Stock	252.2	252.2	251.1	251.21	7732.0
2022-07-13 19:00:00	MSFT	Stock	251.4	251.5	251.0	251.02	4703.0
2022-07-13 04:00:00	NVDA	Stock	15.098	15.213	15.082	15.213	68320.0
2022-07-13 05:00:00	NVDA	Stock	15.2	15.216	15.193	15.193	73140.0
2022-07-13 06:00:00	NVDA	Stock	15.184	15.184	15.114	15.135	115960.0
2022-07-13 07:00:00	NVDA	Stock	15.125	15.166	15.11	15.15	145170.0
2022-07-13 08:00:00	NVDA	Stock	15.103	15.27	14.56	14.7	6435510.0
2022-07-13 09:00:00	NVDA	Stock	14.715	14.95	14.465	14.914	82620470.0
2022-07-13 10:00:00	NVDA	Stock	14.917	15.375	14.772	15.277	92819720.0
2022-07-13 11:00:00	NVDA	Stock	15.28	15.369	15.064	15.161	57359790.0
2022-07-13 12:00:00	NVDA	Stock	15.163	15.284	15.1209	15.2825	43680320.0
2022-07-13 13:00:00	NVDA	Stock	15.282	15.345	15.195	15.3181	33970010.0
2022-07-13 14:00:00	NVDA	Stock	15.318	15.3287	15.155	15.299	33998360.0
2022-07-13 15:00:00	NVDA	Stock	15.296	15.308	15.138	15.162	46101240.0
2022-07-13 16:00:00	NVDA	Stock	15.164	15.192	15.122	15.135	15345280.0
2022-07-13 17:00:00	NVDA	Stock	15.13	15.145	15.125	15.135	186050.0
2022-07-13 18:00:00	NVDA	Stock	15.123	15.14	15.033	15.06	394590.0
2022-07-13 19:00:00	NVDA	Stock	15.056	15.1	15.007	15.017	421770.0
2022-07-13 04:00:00	AMZN	Stock	109.7	109.81	109.09	109.8	6700.0
2022-07-13 05:00:00	AMZN	Stock	109.93	110.26	109.68	109.82	8932.0

> showing 50 of 61,006 rows — these rows as CSV

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