PREVIEW / stock_1hour / 2023-06-26

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-06-26.parquet
  size:    1.3 MB
  rows:    60,237
  symbols: 1,601

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-26 04:00:00	AAPL	Stock	186.55	186.85	186.0	186.22	39600.0
2023-06-26 05:00:00	AAPL	Stock	186.37	186.43	186.3	186.43	2169.0
2023-06-26 06:00:00	AAPL	Stock	186.34	186.35	186.2	186.2	1000.0
2023-06-26 07:00:00	AAPL	Stock	186.25	186.63	186.25	186.6	22177.0
2023-06-26 08:00:00	AAPL	Stock	186.3318	187.45	186.3	186.91	89217.0
2023-06-26 09:00:00	AAPL	Stock	186.89	187.83	186.34	187.5811	4585123.0
2023-06-26 10:00:00	AAPL	Stock	187.585	188.05	186.96	187.62	5709495.0
2023-06-26 11:00:00	AAPL	Stock	187.61	187.6357	186.41	186.885	4577466.0
2023-06-26 12:00:00	AAPL	Stock	186.885	186.98	185.65	186.05	4498996.0
2023-06-26 13:00:00	AAPL	Stock	186.05	186.05	185.61	185.82	3061116.0
2023-06-26 14:00:00	AAPL	Stock	185.8323	186.41	185.7701	186.15	3224093.0
2023-06-26 15:00:00	AAPL	Stock	186.15	186.25	185.23	185.31	7176651.0
2023-06-26 16:00:00	AAPL	Stock	185.3	185.54	185.0	185.3	6464521.0
2023-06-26 17:00:00	AAPL	Stock	185.29	185.34	185.0301	185.24	60312.0
2023-06-26 18:00:00	AAPL	Stock	185.26	185.39	185.194	185.3	23492.0
2023-06-26 19:00:00	AAPL	Stock	185.29	185.59	185.27	185.52	78380.0
2023-06-26 04:00:00	MSFT	Stock	334.89	334.96	334.23	334.25	5772.0
2023-06-26 05:00:00	MSFT	Stock	334.4	334.6	334.32	334.6	1361.0
2023-06-26 06:00:00	MSFT	Stock	334.5	334.51	334.5	334.51	796.0
2023-06-26 07:00:00	MSFT	Stock	334.7	335.09	334.51	334.55	7677.0
2023-06-26 08:00:00	MSFT	Stock	334.9	336.89	333.5	334.479	20980.0
2023-06-26 09:00:00	MSFT	Stock	334.48	335.58	332.511	335.41	1514503.0
2023-06-26 10:00:00	MSFT	Stock	335.395	336.11	332.77	334.46	1757994.0
2023-06-26 11:00:00	MSFT	Stock	334.4432	334.5099	330.85	331.37	1972028.0
2023-06-26 12:00:00	MSFT	Stock	331.37	331.76	329.415	330.41	1727143.0
2023-06-26 13:00:00	MSFT	Stock	330.44	330.54	329.47	329.97	1183857.0
2023-06-26 14:00:00	MSFT	Stock	329.96	331.0	329.52	330.37	1142966.0
2023-06-26 15:00:00	MSFT	Stock	330.38	330.43	328.49	328.68	2614440.0
2023-06-26 16:00:00	MSFT	Stock	328.71	329.48	328.45	328.96	3173743.0
2023-06-26 17:00:00	MSFT	Stock	328.96	329.2	328.6	328.7579	6707.0
2023-06-26 18:00:00	MSFT	Stock	329.19	329.27	328.79	329.2217	2854.0
2023-06-26 19:00:00	MSFT	Stock	328.99	329.97	328.6	329.75	28065.0
2023-06-26 04:00:00	NVDA	Stock	42.06	42.072	41.875	42.072	219770.0
2023-06-26 05:00:00	NVDA	Stock	42.076	42.149	42.076	42.109	36350.0
2023-06-26 06:00:00	NVDA	Stock	42.1	42.1	42.07	42.07	17560.0
2023-06-26 07:00:00	NVDA	Stock	42.09	42.44	42.051	42.42	416960.0
2023-06-26 08:00:00	NVDA	Stock	42.412	42.488	42.041	42.4729	1164380.0
2023-06-26 09:00:00	NVDA	Stock	42.455	42.748	42.282	42.7295	39663600.0
2023-06-26 10:00:00	NVDA	Stock	42.7295	42.764	41.776	41.861	58194060.0
2023-06-26 11:00:00	NVDA	Stock	41.8645	41.883	41.075	41.222	74526520.0
2023-06-26 12:00:00	NVDA	Stock	41.213	41.22	40.1	40.488	98955100.0
2023-06-26 13:00:00	NVDA	Stock	40.4854	40.707	40.44	40.546	47281470.0
2023-06-26 14:00:00	NVDA	Stock	40.5532	40.928	40.5093	40.8497	43234330.0
2023-06-26 15:00:00	NVDA	Stock	40.86	41.14	40.602	40.634	69446110.0
2023-06-26 16:00:00	NVDA	Stock	40.638	40.9984	40.53	40.55	18070810.0
2023-06-26 17:00:00	NVDA	Stock	40.55	40.67	40.54	40.62	385720.0
2023-06-26 18:00:00	NVDA	Stock	40.64	40.66	40.547	40.5693	349310.0
2023-06-26 19:00:00	NVDA	Stock	40.58	40.631	40.565	40.588	375220.0
2023-06-26 04:00:00	AMZN	Stock	129.06	129.8	129.0	129.36	15036.0
2023-06-26 05:00:00	AMZN	Stock	129.51	129.58	129.32	129.57	9350.0

> showing 50 of 60,237 rows — these rows as CSV

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