PREVIEW / stock_1hour / 2022-06-03

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-06-03.parquet
  size:    1.4 MB
  rows:    61,290
  symbols: 2,364

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-06-03 04:00:00	AAPL	Stock	150.7	150.7	149.87	150.39	47703.0
2022-06-03 05:00:00	AAPL	Stock	150.29	150.32	150.02	150.24	20902.0
2022-06-03 06:00:00	AAPL	Stock	150.2	150.27	147.65	148.21	141454.0
2022-06-03 07:00:00	AAPL	Stock	148.34	148.82	147.58	147.71	350819.0
2022-06-03 08:00:00	AAPL	Stock	148.7	151.0	147.07	147.56	1519780.0
2022-06-03 09:00:00	AAPL	Stock	147.6199	148.05	145.72	147.135	13301140.0
2022-06-03 10:00:00	AAPL	Stock	147.15	147.4782	145.25	145.52	12488838.0
2022-06-03 11:00:00	AAPL	Stock	145.51	145.585	144.46	145.1316	9327189.0
2022-06-03 12:00:00	AAPL	Stock	145.13	146.105	145.01	145.95	6490362.0
2022-06-03 13:00:00	AAPL	Stock	145.9521	146.3442	144.85	145.0499	7065009.0
2022-06-03 14:00:00	AAPL	Stock	145.0451	145.72	144.92	145.48	5837182.0
2022-06-03 15:00:00	AAPL	Stock	145.48	145.74	144.81	145.39	12728376.0
2022-06-03 16:00:00	AAPL	Stock	145.38	145.57	145.24	145.4	7468415.0
2022-06-03 17:00:00	AAPL	Stock	145.3901	145.64	145.3507	145.47	60526.0
2022-06-03 18:00:00	AAPL	Stock	145.47	145.47	145.15	145.2	48336.0
2022-06-03 19:00:00	AAPL	Stock	145.21	145.33	145.1	145.2	40345.0
2022-06-03 04:00:00	MSFT	Stock	272.7	273.24	272.7	273.1	6908.0
2022-06-03 05:00:00	MSFT	Stock	273.3	273.57	272.98	273.05	17667.0
2022-06-03 06:00:00	MSFT	Stock	273.12	273.39	272.3	272.34	17810.0
2022-06-03 07:00:00	MSFT	Stock	272.49	273.0	271.61	271.7	50138.0
2022-06-03 08:00:00	MSFT	Stock	274.0	274.0	270.26	270.99	165465.0
2022-06-03 09:00:00	MSFT	Stock	270.9	272.8454	269.4701	272.09	3049429.0
2022-06-03 10:00:00	MSFT	Stock	272.14	273.45	270.48	270.77	2241479.0
2022-06-03 11:00:00	MSFT	Stock	270.76	270.81	268.41	269.333	1947605.0
2022-06-03 12:00:00	MSFT	Stock	269.33	270.8664	268.87	270.68	1208470.0
2022-06-03 13:00:00	MSFT	Stock	270.7	271.5	269.17	269.765	1160160.0
2022-06-03 14:00:00	MSFT	Stock	269.74	270.8	269.51	270.1746	1111415.0
2022-06-03 15:00:00	MSFT	Stock	270.19	270.4	268.48	270.05	3640776.0
2022-06-03 16:00:00	MSFT	Stock	270.04	270.39	269.7	270.0	3394270.0
2022-06-03 17:00:00	MSFT	Stock	270.0707	270.09	269.8814	269.92	3639.0
2022-06-03 18:00:00	MSFT	Stock	269.92	270.02	269.75	269.75	2864.0
2022-06-03 19:00:00	MSFT	Stock	269.75	269.85	269.5001	269.8	5035.0
2022-06-03 04:00:00	NVDA	Stock	19.566	19.566	19.353	19.402	240450.0
2022-06-03 05:00:00	NVDA	Stock	19.43	19.437	19.38	19.42	145500.0
2022-06-03 06:00:00	NVDA	Stock	19.43	19.465	19.28	19.316	301220.0
2022-06-03 07:00:00	NVDA	Stock	19.326	19.355	19.22	19.25	539850.0
2022-06-03 08:00:00	NVDA	Stock	19.3477	19.77	19.082	19.195	4373360.0
2022-06-03 09:00:00	NVDA	Stock	19.199	19.2699	18.923	19.208	73686480.0
2022-06-03 10:00:00	NVDA	Stock	19.216	19.3323	18.7694	18.773	92481120.0
2022-06-03 11:00:00	NVDA	Stock	18.775	18.785	18.5216	18.728	71463590.0
2022-06-03 12:00:00	NVDA	Stock	18.726	18.938	18.668	18.931	49707300.0
2022-06-03 13:00:00	NVDA	Stock	18.932	18.999	18.7111	18.7199	46988420.0
2022-06-03 14:00:00	NVDA	Stock	18.721	18.878	18.68	18.806	42864610.0
2022-06-03 15:00:00	NVDA	Stock	18.807	18.831	18.657	18.718	64792940.0
2022-06-03 16:00:00	NVDA	Stock	18.72	18.77	18.7	18.7256	22621600.0
2022-06-03 17:00:00	NVDA	Stock	18.732	18.75	18.731	18.7373	84650.0
2022-06-03 18:00:00	NVDA	Stock	18.737	18.74	18.707	18.707	63990.0
2022-06-03 19:00:00	NVDA	Stock	18.71	18.736	18.7	18.72	142180.0
2022-06-03 04:00:00	AMZN	Stock	125.725	125.725	124.9025	124.9025	25720.0
2022-06-03 05:00:00	AMZN	Stock	125.11	125.11	125.006	125.102	26100.0

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

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