PREVIEW / stock_1hour / 2023-06-14

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-06-14.parquet
  size:    1.4 MB
  rows:    61,684
  symbols: 1,621

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
2023-06-14 04:00:00	AAPL	Stock	183.31	183.62	183.26	183.55	11502.0
2023-06-14 05:00:00	AAPL	Stock	183.45	183.53	183.25	183.36	7182.0
2023-06-14 06:00:00	AAPL	Stock	183.37	183.4	183.29	183.34	6460.0
2023-06-14 07:00:00	AAPL	Stock	183.3	183.4	183.25	183.35	19304.0
2023-06-14 08:00:00	AAPL	Stock	183.32	183.55	182.81	183.3	144393.0
2023-06-14 09:00:00	AAPL	Stock	183.27	184.03	182.91	183.91	5447028.0
2023-06-14 10:00:00	AAPL	Stock	183.91	184.335	183.68	183.78	7228814.0
2023-06-14 11:00:00	AAPL	Stock	183.7809	184.39	183.52	184.09	4077189.0
2023-06-14 12:00:00	AAPL	Stock	184.09	184.25	183.84	184.09	2426075.0
2023-06-14 13:00:00	AAPL	Stock	184.09	184.09	183.51	183.71	2758713.0
2023-06-14 14:00:00	AAPL	Stock	183.71	184.13	182.02	183.56	8556114.0
2023-06-14 15:00:00	AAPL	Stock	183.59	184.205	182.95	183.96	8476366.0
2023-06-14 16:00:00	AAPL	Stock	183.97	184.25	183.86	184.08	6960495.0
2023-06-14 17:00:00	AAPL	Stock	184.15	184.15	183.95	184.05	52014.0
2023-06-14 18:00:00	AAPL	Stock	184.06	184.11	184.0	184.03	18823.0
2023-06-14 19:00:00	AAPL	Stock	184.0	184.0001	183.82	183.88	14953.0
2023-06-14 04:00:00	MSFT	Stock	334.69	334.69	334.4	334.55	2113.0
2023-06-14 05:00:00	MSFT	Stock	334.74	335.0	334.6	334.85	5671.0
2023-06-14 06:00:00	MSFT	Stock	334.6	334.78	334.18	334.23	3666.0
2023-06-14 07:00:00	MSFT	Stock	334.42	334.56	333.82	334.1	6490.0
2023-06-14 08:00:00	MSFT	Stock	334.3049	335.42	333.45	333.56	37871.0
2023-06-14 09:00:00	MSFT	Stock	333.8087	335.86	333.28	335.67	1889082.0
2023-06-14 10:00:00	MSFT	Stock	335.675	337.14	335.41	336.28	2087150.0
2023-06-14 11:00:00	MSFT	Stock	336.32	339.04	335.73	337.82	2005991.0
2023-06-14 12:00:00	MSFT	Stock	337.83	338.08	337.03	337.72	1026025.0
2023-06-14 13:00:00	MSFT	Stock	337.7	337.7	336.23	336.66	1193594.0
2023-06-14 14:00:00	MSFT	Stock	336.62	336.69	332.81	335.591	2660800.0
2023-06-14 15:00:00	MSFT	Stock	335.61	338.1	335.14	337.34	3085759.0
2023-06-14 16:00:00	MSFT	Stock	337.35	338.8593	336.91	338.36	3590486.0
2023-06-14 17:00:00	MSFT	Stock	337.34	338.47	337.34	337.851	23617.0
2023-06-14 18:00:00	MSFT	Stock	338.3	338.35	337.65	338.28	6266.0
2023-06-14 19:00:00	MSFT	Stock	338.0	338.45	338.0	338.2	4801.0
2023-06-14 04:00:00	NVDA	Stock	40.512	41.415	40.512	41.37	168960.0
2023-06-14 05:00:00	NVDA	Stock	41.381	41.39	41.319	41.319	115140.0
2023-06-14 06:00:00	NVDA	Stock	41.337	41.35	41.169	41.2	83680.0
2023-06-14 07:00:00	NVDA	Stock	41.218	41.295	40.93	40.98	972710.0
2023-06-14 08:00:00	NVDA	Stock	41.215	41.45	40.741	40.783	2685400.0
2023-06-14 09:00:00	NVDA	Stock	40.774	41.498	40.5	41.3547	71960260.0
2023-06-14 10:00:00	NVDA	Stock	41.362	41.967	41.172	41.845	80100450.0
2023-06-14 11:00:00	NVDA	Stock	41.845	42.276	41.759	41.813	77698300.0
2023-06-14 12:00:00	NVDA	Stock	41.808	42.024	41.668	41.931	45043190.0
2023-06-14 13:00:00	NVDA	Stock	41.931	41.985	41.73	41.8664	36417830.0
2023-06-14 14:00:00	NVDA	Stock	41.8693	42.432	41.368	42.293	100978830.0
2023-06-14 15:00:00	NVDA	Stock	42.3	43.0	42.189	42.998	121339280.0
2023-06-14 16:00:00	NVDA	Stock	42.998	43.334	42.962	43.248	33364560.0
2023-06-14 17:00:00	NVDA	Stock	43.244	43.254	42.997	43.186	1484530.0
2023-06-14 18:00:00	NVDA	Stock	43.175	43.193	43.06	43.1851	1164840.0
2023-06-14 19:00:00	NVDA	Stock	43.176	43.236	43.137	43.188	993420.0
2023-06-14 04:00:00	AMZN	Stock	126.62	127.0	126.62	126.81	9927.0
2023-06-14 05:00:00	AMZN	Stock	126.9	126.96	126.8	126.86	5814.0

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

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