PREVIEW / stock_1hour / 2023-08-09

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-08-09.parquet
  size:    1.3 MB
  rows:    59,849
  symbols: 1,514

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-08-09 04:00:00	AAPL	Stock	180.77	181.47	180.75	181.41	28831.0
2023-08-09 05:00:00	AAPL	Stock	181.44	181.44	181.2	181.21	11778.0
2023-08-09 06:00:00	AAPL	Stock	181.26	181.29	181.02	181.02	17930.0
2023-08-09 07:00:00	AAPL	Stock	181.0	181.1	180.56	181.06	65583.0
2023-08-09 08:00:00	AAPL	Stock	181.0	181.1	180.52	180.76	243792.0
2023-08-09 09:00:00	AAPL	Stock	180.79	180.98	178.14	178.66	6912605.0
2023-08-09 10:00:00	AAPL	Stock	178.66	179.13	177.6	177.815	7757033.0
2023-08-09 11:00:00	AAPL	Stock	177.82	178.2	177.01	177.42	6296683.0
2023-08-09 12:00:00	AAPL	Stock	177.42	178.48	177.37	178.19	5605654.0
2023-08-09 13:00:00	AAPL	Stock	178.195	178.79	178.1402	178.6732	3154989.0
2023-08-09 14:00:00	AAPL	Stock	178.67	179.59	178.61	179.16	4824053.0
2023-08-09 15:00:00	AAPL	Stock	179.16	179.3	177.99	178.2	7837560.0
2023-08-09 16:00:00	AAPL	Stock	178.2	178.56	178.108	178.56	5771892.0
2023-08-09 17:00:00	AAPL	Stock	178.54	178.65	178.2	178.3	93097.0
2023-08-09 18:00:00	AAPL	Stock	178.35	178.63	178.35	178.55	46903.0
2023-08-09 19:00:00	AAPL	Stock	178.55	178.55	178.36	178.43	49980.0
2023-08-09 04:00:00	MSFT	Stock	326.8	327.59	326.8	327.59	4368.0
2023-08-09 05:00:00	MSFT	Stock	327.53	327.68	327.3	327.3	1929.0
2023-08-09 06:00:00	MSFT	Stock	326.84	326.84	326.03	326.39	890.0
2023-08-09 07:00:00	MSFT	Stock	326.48	326.87	326.0	326.8	8202.0
2023-08-09 08:00:00	MSFT	Stock	326.25	327.59	325.9	326.6101	32384.0
2023-08-09 09:00:00	MSFT	Stock	326.8	327.11	324.46	324.7689	1232313.0
2023-08-09 10:00:00	MSFT	Stock	324.78	325.545	322.92	322.94	1543516.0
2023-08-09 11:00:00	MSFT	Stock	322.94	323.66	321.0499	322.45	2233508.0
2023-08-09 12:00:00	MSFT	Stock	322.43	323.9	322.41	323.195	1223726.0
2023-08-09 13:00:00	MSFT	Stock	323.18	324.52	322.855	324.28	985199.0
2023-08-09 14:00:00	MSFT	Stock	324.29	325.45	324.08	324.7	1165792.0
2023-08-09 15:00:00	MSFT	Stock	324.72	324.94	322.09	322.32	2592926.0
2023-08-09 16:00:00	MSFT	Stock	322.32	322.9086	322.16	322.485	3223864.0
2023-08-09 17:00:00	MSFT	Stock	322.48	322.52	322.23	322.35	12216.0
2023-08-09 18:00:00	MSFT	Stock	322.4	322.97	322.4	322.86	16975.0
2023-08-09 19:00:00	MSFT	Stock	322.66	322.93	322.5	322.93	6669.0
2023-08-09 04:00:00	NVDA	Stock	44.81	45.115	44.801	44.89	172220.0
2023-08-09 05:00:00	NVDA	Stock	44.875	44.894	44.453	44.548	177280.0
2023-08-09 06:00:00	NVDA	Stock	44.56	44.568	44.441	44.512	153180.0
2023-08-09 07:00:00	NVDA	Stock	44.56	44.73	44.55	44.73	456080.0
2023-08-09 08:00:00	NVDA	Stock	44.563	44.908	44.41	44.457	1476910.0
2023-08-09 09:00:00	NVDA	Stock	44.47	44.53	43.254	43.483	65368760.0
2023-08-09 10:00:00	NVDA	Stock	43.486	43.61	42.411	42.434	89307590.0
2023-08-09 11:00:00	NVDA	Stock	42.433	42.75	42.134	42.698	88417840.0
2023-08-09 12:00:00	NVDA	Stock	42.685	43.019	42.672	42.722	51504930.0
2023-08-09 13:00:00	NVDA	Stock	42.7249	43.197	42.708	43.067	39573950.0
2023-08-09 14:00:00	NVDA	Stock	43.06	43.375	42.9407	42.996	40669100.0
2023-08-09 15:00:00	NVDA	Stock	42.9965	43.0465	42.535	42.545	56957860.0
2023-08-09 16:00:00	NVDA	Stock	42.57	42.75	42.31	42.352	17097950.0
2023-08-09 17:00:00	NVDA	Stock	42.37	42.4	42.269	42.344	971210.0
2023-08-09 18:00:00	NVDA	Stock	42.348	42.58	42.348	42.535	792580.0
2023-08-09 19:00:00	NVDA	Stock	42.556	42.556	42.38	42.43	525170.0
2023-08-09 04:00:00	AMZN	Stock	140.18	140.5	140.18	140.5	21573.0
2023-08-09 05:00:00	AMZN	Stock	140.48	140.49	140.32	140.41	8003.0

> showing 50 of 59,849 rows — these rows as CSV

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