PREVIEW / stock_1hour / 2021-03-16

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-03-16.parquet
  size:    1.5 MB
  rows:    67,504
  symbols: 2,901

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-03-16 04:00:00	AAPL	Stock	124.66	124.99	124.4	124.67	32794.0
2021-03-16 05:00:00	AAPL	Stock	124.72	125.2	124.72	125.05	43709.0
2021-03-16 06:00:00	AAPL	Stock	125.07	125.28	124.86	125.18	40523.0
2021-03-16 07:00:00	AAPL	Stock	125.13	125.25	124.82	125.21	284860.0
2021-03-16 08:00:00	AAPL	Stock	124.975	125.75	124.299	125.53	708551.0
2021-03-16 09:00:00	AAPL	Stock	125.52	126.64	125.08	126.52	17199379.0
2021-03-16 10:00:00	AAPL	Stock	126.5198	127.22	126.06	126.935	17569639.0
2021-03-16 11:00:00	AAPL	Stock	126.93	127.055	126.16	126.225	12077314.0
2021-03-16 12:00:00	AAPL	Stock	126.23	126.33	125.33	125.8501	13137696.0
2021-03-16 13:00:00	AAPL	Stock	125.857	126.28	125.33	125.635	9013663.0
2021-03-16 14:00:00	AAPL	Stock	125.63	125.835	124.715	125.33	12158724.0
2021-03-16 15:00:00	AAPL	Stock	125.335	125.9284	125.235	125.57	12636288.0
2021-03-16 16:00:00	AAPL	Stock	125.57	125.7	125.48	125.5	5963007.0
2021-03-16 17:00:00	AAPL	Stock	125.5	125.57	125.31	125.55	108415.0
2021-03-16 18:00:00	AAPL	Stock	125.56	125.62	125.5	125.51	88108.0
2021-03-16 19:00:00	AAPL	Stock	125.51	125.6	125.1	125.23	107734.0
2021-03-16 04:00:00	MSFT	Stock	235.07	235.07	235.07	235.07	100.0
2021-03-16 05:00:00	MSFT	Stock	235.11	235.28	235.07	235.28	624.0
2021-03-16 06:00:00	MSFT	Stock	235.46	235.64	235.27	235.64	1462.0
2021-03-16 07:00:00	MSFT	Stock	235.51	235.8	235.26	235.69	9637.0
2021-03-16 08:00:00	MSFT	Stock	235.43	235.82	234.223	235.7	18472.0
2021-03-16 09:00:00	MSFT	Stock	235.57	238.31	234.81	238.3079	2483547.0
2021-03-16 10:00:00	MSFT	Stock	238.3	239.85	238.15	239.56	3312796.0
2021-03-16 11:00:00	MSFT	Stock	239.56	240.055	239.28	239.57	2367954.0
2021-03-16 12:00:00	MSFT	Stock	239.59	239.845	238.57	238.89	2437154.0
2021-03-16 13:00:00	MSFT	Stock	238.872	239.48	237.73	238.019	1769614.0
2021-03-16 14:00:00	MSFT	Stock	238.01	238.19	236.92	237.33	2004649.0
2021-03-16 15:00:00	MSFT	Stock	237.322	239.25	237.03	237.69	3264542.0
2021-03-16 16:00:00	MSFT	Stock	237.71	238.46	237.53	238.45	4053938.0
2021-03-16 17:00:00	MSFT	Stock	237.8	237.9	237.71	237.72	15364.0
2021-03-16 18:00:00	MSFT	Stock	237.84	238.4	237.84	238.06	4958.0
2021-03-16 19:00:00	MSFT	Stock	238.1	238.39	236.72	237.5	10836.0
2021-03-16 05:00:00	NVDA	Stock	13.2475	13.2475	13.2475	13.2475	4000.0
2021-03-16 06:00:00	NVDA	Stock	13.2942	13.3635	13.2942	13.35	54280.0
2021-03-16 07:00:00	NVDA	Stock	13.3375	13.3708	13.321	13.3438	303160.0
2021-03-16 08:00:00	NVDA	Stock	13.35	13.3856	13.2242	13.3658	568440.0
2021-03-16 09:00:00	NVDA	Stock	13.385	13.4698	13.303	13.4285	29241800.0
2021-03-16 10:00:00	NVDA	Stock	13.4253	13.5125	13.3945	13.4582	26903720.0
2021-03-16 11:00:00	NVDA	Stock	13.4578	13.4852	13.3825	13.3983	13925600.0
2021-03-16 12:00:00	NVDA	Stock	13.4035	13.4235	13.2575	13.35	20904760.0
2021-03-16 13:00:00	NVDA	Stock	13.352	13.4238	13.2673	13.2925	11343400.0
2021-03-16 14:00:00	NVDA	Stock	13.2912	13.3297	13.1168	13.2225	21592120.0
2021-03-16 15:00:00	NVDA	Stock	13.2212	13.3392	13.1842	13.2845	22346760.0
2021-03-16 16:00:00	NVDA	Stock	13.2875	13.3045	13.2812	13.2812	15565280.0
2021-03-16 17:00:00	NVDA	Stock	13.283	13.3	13.2812	13.2918	114640.0
2021-03-16 18:00:00	NVDA	Stock	13.3	13.3112	13.2918	13.3012	50000.0
2021-03-16 19:00:00	NVDA	Stock	13.3072	13.3112	13.2825	13.2833	226640.0
2021-03-16 07:00:00	AMZN	Stock	154.6465	154.75	154.6345	154.75	30880.0
2021-03-16 08:00:00	AMZN	Stock	154.75	155.5	154.71	154.71	58240.0
2021-03-16 09:00:00	AMZN	Stock	154.7575	156.0605	154.25	155.7704	3728560.0

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

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