PREVIEW / stock_1hour / 2022-05-17

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-05-17.parquet
  size:    1.4 MB
  rows:    64,211
  symbols: 2,404

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-05-17 04:00:00	AAPL	Stock	146.82	148.4	146.61	148.27	77360.0
2022-05-17 05:00:00	AAPL	Stock	148.23	148.74	148.13	148.64	29576.0
2022-05-17 06:00:00	AAPL	Stock	148.7	148.7	148.0	148.08	41145.0
2022-05-17 07:00:00	AAPL	Stock	148.08	148.2	147.72	148.05	281670.0
2022-05-17 08:00:00	AAPL	Stock	147.81	148.4	146.97	147.9144	637274.0
2022-05-17 09:00:00	AAPL	Stock	147.98	149.34	147.63	147.7978	9454396.0
2022-05-17 10:00:00	AAPL	Stock	147.79	148.32	146.68	147.34	9875794.0
2022-05-17 11:00:00	AAPL	Stock	147.34	148.68	147.05	147.9906	7292657.0
2022-05-17 12:00:00	AAPL	Stock	148.0	148.4018	147.46	147.99	5044026.0
2022-05-17 13:00:00	AAPL	Stock	147.99	148.8301	147.65	148.55	5757059.0
2022-05-17 14:00:00	AAPL	Stock	148.54	149.33	147.3003	149.1099	9548974.0
2022-05-17 15:00:00	AAPL	Stock	149.106	149.77	148.79	149.24	11436053.0
2022-05-17 16:00:00	AAPL	Stock	149.24	149.42	149.0999	149.3	7689554.0
2022-05-17 17:00:00	AAPL	Stock	149.3	149.4	149.26	149.35	21269.0
2022-05-17 18:00:00	AAPL	Stock	149.38	149.62	149.36	149.46	77651.0
2022-05-17 19:00:00	AAPL	Stock	149.49	149.5	149.2	149.24	41687.0
2022-05-17 04:00:00	MSFT	Stock	264.57	266.98	264.57	266.5	16607.0
2022-05-17 05:00:00	MSFT	Stock	266.11	266.55	265.93	266.55	9988.0
2022-05-17 06:00:00	MSFT	Stock	266.6	267.0	265.55	266.44	16098.0
2022-05-17 07:00:00	MSFT	Stock	266.4	266.69	265.26	265.75	37877.0
2022-05-17 08:00:00	MSFT	Stock	265.8998	266.7	264.25	265.35	71194.0
2022-05-17 09:00:00	MSFT	Stock	265.34	268.33	264.91	265.73	3182246.0
2022-05-17 10:00:00	MSFT	Stock	265.77	266.3799	262.46	263.1184	3053869.0
2022-05-17 11:00:00	MSFT	Stock	263.11	266.11	262.85	265.06	2065633.0
2022-05-17 12:00:00	MSFT	Stock	265.07	265.98	264.53	264.99	1534389.0
2022-05-17 13:00:00	MSFT	Stock	265.0	265.2874	264.33	264.615	1214428.0
2022-05-17 14:00:00	MSFT	Stock	264.65	266.49	262.58	265.9599	2672830.0
2022-05-17 15:00:00	MSFT	Stock	265.95	267.0	265.68	266.86	3721379.0
2022-05-17 16:00:00	MSFT	Stock	266.82	267.19	266.62	267.0	3590748.0
2022-05-17 17:00:00	MSFT	Stock	266.99	267.1	266.9147	267.0	3636.0
2022-05-17 18:00:00	MSFT	Stock	267.07	267.36	267.0	267.18	3984.0
2022-05-17 19:00:00	MSFT	Stock	267.35	267.35	266.6	267.0	9325.0
2022-05-17 04:00:00	NVDA	Stock	17.526	17.896	17.426	17.821	445080.0
2022-05-17 05:00:00	NVDA	Stock	17.821	17.875	17.811	17.86	105990.0
2022-05-17 06:00:00	NVDA	Stock	17.87	17.878	17.78	17.782	82230.0
2022-05-17 07:00:00	NVDA	Stock	17.782	17.86	17.736	17.825	912760.0
2022-05-17 08:00:00	NVDA	Stock	17.781	17.95	17.3071	17.938	2905350.0
2022-05-17 09:00:00	NVDA	Stock	17.936	18.371	17.88	17.9266	82012060.0
2022-05-17 10:00:00	NVDA	Stock	17.935	18.074	17.634	17.7715	81512950.0
2022-05-17 11:00:00	NVDA	Stock	17.77	18.158	17.702	18.1307	66415180.0
2022-05-17 12:00:00	NVDA	Stock	18.134	18.149	17.907	17.925	49192260.0
2022-05-17 13:00:00	NVDA	Stock	17.922	18.041	17.851	18.015	35359260.0
2022-05-17 14:00:00	NVDA	Stock	18.017	18.155	17.691	18.0441	65809940.0
2022-05-17 15:00:00	NVDA	Stock	18.054	18.231	18.033	18.181	68113210.0
2022-05-17 16:00:00	NVDA	Stock	18.177	18.28	18.1401	18.278	23122790.0
2022-05-17 17:00:00	NVDA	Stock	18.283	18.3	18.25	18.285	481650.0
2022-05-17 18:00:00	NVDA	Stock	18.285	18.33	18.26	18.265	482180.0
2022-05-17 19:00:00	NVDA	Stock	18.266	18.3	18.235	18.28	393420.0
2022-05-17 04:00:00	AMZN	Stock	112.75	112.75	112.75	112.75	2000.0
2022-05-17 05:00:00	AMZN	Stock	113.7655	113.7655	113.7655	113.7655	2620.0

> showing 50 of 64,211 rows — these rows as CSV

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