PREVIEW / stock_1hour / 2022-12-15

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-12-15.parquet
  size:    1.4 MB
  rows:    61,977
  symbols: 2,038

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-12-15 04:00:00	AAPL	Stock	142.68	142.73	141.2	141.45	34826.0
2022-12-15 05:00:00	AAPL	Stock	141.32	141.57	141.28	141.35	18363.0
2022-12-15 06:00:00	AAPL	Stock	141.3	141.77	141.22	141.77	28109.0
2022-12-15 07:00:00	AAPL	Stock	141.88	142.11	141.45	141.66	82539.0
2022-12-15 08:00:00	AAPL	Stock	142.08	142.3	140.83	141.43	274916.0
2022-12-15 09:00:00	AAPL	Stock	141.37	141.8	138.9	139.08	9633903.0
2022-12-15 10:00:00	AAPL	Stock	139.1	139.38	138.46	138.77	11111451.0
2022-12-15 11:00:00	AAPL	Stock	138.78	139.09	137.71	137.87	9711531.0
2022-12-15 12:00:00	AAPL	Stock	137.865	138.2277	137.21	137.27	6568922.0
2022-12-15 13:00:00	AAPL	Stock	137.28	137.37	136.5	136.775	8202681.0
2022-12-15 14:00:00	AAPL	Stock	136.78	137.09	136.19	136.91	7991645.0
2022-12-15 15:00:00	AAPL	Stock	136.91	137.25	136.025	136.49	15711759.0
2022-12-15 16:00:00	AAPL	Stock	136.5	136.85	136.21	136.28	13538465.0
2022-12-15 17:00:00	AAPL	Stock	136.32	136.5	136.26	136.35	188127.0
2022-12-15 18:00:00	AAPL	Stock	136.36	136.5	136.36	136.4805	41136.0
2022-12-15 19:00:00	AAPL	Stock	136.49	136.68	136.49	136.62	51997.0
2022-12-15 04:00:00	MSFT	Stock	255.71	255.71	253.71	254.33	10094.0
2022-12-15 05:00:00	MSFT	Stock	254.26	254.37	253.92	253.92	3211.0
2022-12-15 06:00:00	MSFT	Stock	253.92	254.33	253.84	254.1	1062.0
2022-12-15 07:00:00	MSFT	Stock	254.23	255.41	254.23	255.23	38145.0
2022-12-15 08:00:00	MSFT	Stock	254.28	256.577	253.25	254.35	52305.0
2022-12-15 09:00:00	MSFT	Stock	254.3	254.65	250.895	251.25	2468567.0
2022-12-15 10:00:00	MSFT	Stock	251.26	251.6	249.55	249.7949	2758026.0
2022-12-15 11:00:00	MSFT	Stock	249.79	250.25	248.38	248.6191	2338324.0
2022-12-15 12:00:00	MSFT	Stock	248.58	249.46	248.16	248.4999	1789159.0
2022-12-15 13:00:00	MSFT	Stock	248.5	248.65	247.34	248.1601	1563303.0
2022-12-15 14:00:00	MSFT	Stock	248.15	249.78	247.93	249.7	1736655.0
2022-12-15 15:00:00	MSFT	Stock	249.685	250.18	248.36	248.96	5310253.0
2022-12-15 16:00:00	MSFT	Stock	249.06	249.85	248.4	249.43	7022820.0
2022-12-15 17:00:00	MSFT	Stock	249.285	249.4	248.5895	248.8	6450.0
2022-12-15 18:00:00	MSFT	Stock	249.19	249.25	249.09	249.09	2752.0
2022-12-15 19:00:00	MSFT	Stock	249.28	249.32	249.03	249.2999	2213.0
2022-12-15 04:00:00	NVDA	Stock	17.42	17.42	17.175	17.295	212060.0
2022-12-15 05:00:00	NVDA	Stock	17.303	17.303	17.221	17.3	134590.0
2022-12-15 06:00:00	NVDA	Stock	17.265	17.32	17.25	17.302	59300.0
2022-12-15 07:00:00	NVDA	Stock	17.316	17.36	17.289	17.309	265510.0
2022-12-15 08:00:00	NVDA	Stock	17.364	17.594	17.167	17.235	1979650.0
2022-12-15 09:00:00	NVDA	Stock	17.225	17.32	16.8384	16.881	52998110.0
2022-12-15 10:00:00	NVDA	Stock	16.882	16.915	16.728	16.8083	56768460.0
2022-12-15 11:00:00	NVDA	Stock	16.8099	16.8975	16.7	16.8403	46893450.0
2022-12-15 12:00:00	NVDA	Stock	16.837	16.975	16.766	16.791	37851100.0
2022-12-15 13:00:00	NVDA	Stock	16.792	16.827	16.7328	16.803	27780220.0
2022-12-15 14:00:00	NVDA	Stock	16.803	17.074	16.791	17.057	54084420.0
2022-12-15 15:00:00	NVDA	Stock	17.058	17.119	16.919	16.96	68877430.0
2022-12-15 16:00:00	NVDA	Stock	16.96	17.0128	16.93	16.956	36625900.0
2022-12-15 17:00:00	NVDA	Stock	16.956	16.97	16.935	16.94	71130.0
2022-12-15 18:00:00	NVDA	Stock	16.96	16.97	16.935	16.959	139600.0
2022-12-15 19:00:00	NVDA	Stock	16.958	16.965	16.921	16.933	160460.0
2022-12-15 04:00:00	AMZN	Stock	91.01	91.01	90.02	90.11	50824.0
2022-12-15 05:00:00	AMZN	Stock	90.21	90.27	90.0	90.06	11948.0

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

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