PREVIEW / stock_1hour / 2022-06-06

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-06-06.parquet
  size:    1.4 MB
  rows:    62,780
  symbols: 2,374

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-06 04:00:00	AAPL	Stock	146.19	147.72	146.19	147.68	44073.0
2022-06-06 05:00:00	AAPL	Stock	147.6	147.67	147.27	147.39	12137.0
2022-06-06 06:00:00	AAPL	Stock	147.44	148.0	147.44	147.71	29456.0
2022-06-06 07:00:00	AAPL	Stock	147.75	147.75	147.14	147.4	116260.0
2022-06-06 08:00:00	AAPL	Stock	147.43	147.64	146.76	146.96	583280.0
2022-06-06 09:00:00	AAPL	Stock	146.96	148.31	146.75	147.83	9015573.0
2022-06-06 10:00:00	AAPL	Stock	147.83	148.5689	147.75	148.17	8749448.0
2022-06-06 11:00:00	AAPL	Stock	148.18	148.3385	146.01	146.52	8761407.0
2022-06-06 12:00:00	AAPL	Stock	146.52	146.57	145.2	146.085	6281401.0
2022-06-06 13:00:00	AAPL	Stock	146.08	146.74	145.6	146.6487	5667388.0
2022-06-06 14:00:00	AAPL	Stock	146.65	146.89	145.07	145.3999	7736071.0
2022-06-06 15:00:00	AAPL	Stock	145.4	146.47	144.9	146.14	10693044.0
2022-06-06 16:00:00	AAPL	Stock	146.14	146.5	146.05	146.27	4222215.0
2022-06-06 17:00:00	AAPL	Stock	146.27	146.42	146.14	146.2883	61283.0
2022-06-06 18:00:00	AAPL	Stock	146.29	146.3	146.03	146.07	40421.0
2022-06-06 19:00:00	AAPL	Stock	146.06	146.54	146.06	146.5	52576.0
2022-06-06 04:00:00	MSFT	Stock	272.35	273.79	271.37	273.6	3582.0
2022-06-06 05:00:00	MSFT	Stock	273.7	273.7	273.0	273.0	7734.0
2022-06-06 06:00:00	MSFT	Stock	273.15	273.5	273.15	273.5	2831.0
2022-06-06 07:00:00	MSFT	Stock	273.4	273.65	272.71	273.19	15843.0
2022-06-06 08:00:00	MSFT	Stock	273.19	273.5	269.345	272.65	45533.0
2022-06-06 09:00:00	MSFT	Stock	272.66	273.88	271.32	273.29	1925106.0
2022-06-06 10:00:00	MSFT	Stock	273.275	274.18	272.56	273.66	1857495.0
2022-06-06 11:00:00	MSFT	Stock	273.71	273.97	269.81	270.46	1943225.0
2022-06-06 12:00:00	MSFT	Stock	270.45	270.4924	268.17	269.576	1312641.0
2022-06-06 13:00:00	MSFT	Stock	269.54	270.2	268.5	270.16	1095926.0
2022-06-06 14:00:00	MSFT	Stock	270.1503	270.2679	267.88	268.68	1498512.0
2022-06-06 15:00:00	MSFT	Stock	268.68	269.25	267.22	268.75	2744374.0
2022-06-06 16:00:00	MSFT	Stock	268.75	269.05	268.51	268.76	2370302.0
2022-06-06 17:00:00	MSFT	Stock	268.75	269.18	268.75	268.99	38339.0
2022-06-06 18:00:00	MSFT	Stock	268.9	268.9	268.51	268.51	11780.0
2022-06-06 19:00:00	MSFT	Stock	268.75	269.28	268.75	269.2	4335.0
2022-06-06 04:00:00	NVDA	Stock	18.976	19.223	18.936	19.202	293320.0
2022-06-06 05:00:00	NVDA	Stock	19.19	19.2	19.123	19.16	95040.0
2022-06-06 06:00:00	NVDA	Stock	19.159	19.19	19.131	19.19	31010.0
2022-06-06 07:00:00	NVDA	Stock	19.18	19.199	19.061	19.116	334050.0
2022-06-06 08:00:00	NVDA	Stock	19.1482	19.2	19.0815	19.14	1796450.0
2022-06-06 09:00:00	NVDA	Stock	19.1357	19.337	18.857	19.105	47524730.0
2022-06-06 10:00:00	NVDA	Stock	19.1021	19.272	19.076	19.124	57494180.0
2022-06-06 11:00:00	NVDA	Stock	19.128	19.154	18.767	18.89	51622140.0
2022-06-06 12:00:00	NVDA	Stock	18.8895	18.895	18.5642	18.808	48859370.0
2022-06-06 13:00:00	NVDA	Stock	18.809	19.005	18.689	18.9985	35356060.0
2022-06-06 14:00:00	NVDA	Stock	19.0	19.018	18.687	18.767	34504960.0
2022-06-06 15:00:00	NVDA	Stock	18.77	18.824	18.646	18.7855	42702010.0
2022-06-06 16:00:00	NVDA	Stock	18.783	18.807	18.75	18.8	16510300.0
2022-06-06 17:00:00	NVDA	Stock	18.79	18.816	18.775	18.79	246760.0
2022-06-06 18:00:00	NVDA	Stock	18.782	18.794	18.763	18.769	163330.0
2022-06-06 19:00:00	NVDA	Stock	18.765	18.788	18.763	18.77	241540.0
2022-06-06 04:00:00	AMZN	Stock	123.64	124.79	123.0	123.47	155968.0
2022-06-06 05:00:00	AMZN	Stock	123.5	123.53	122.5	122.64	90177.0

> showing 50 of 62,780 rows — these rows as CSV

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