PREVIEW / stock_1hour / 2023-10-23

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-10-23.parquet
  size:    1.3 MB
  rows:    58,549
  symbols: 1,356

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-10-23 04:00:00	AAPL	Stock	172.6	172.6	171.68	171.7	42241.0
2023-10-23 05:00:00	AAPL	Stock	171.67	171.67	170.0	170.2	71951.0
2023-10-23 06:00:00	AAPL	Stock	170.22	170.7	170.2	170.66	23639.0
2023-10-23 07:00:00	AAPL	Stock	170.6	171.32	170.6	170.81	82388.0
2023-10-23 08:00:00	AAPL	Stock	171.04	173.08	170.6	170.8709	163565.0
2023-10-23 09:00:00	AAPL	Stock	170.85	171.68	169.93	171.3799	8888297.0
2023-10-23 10:00:00	AAPL	Stock	171.37	172.23	171.09	172.21	7483877.0
2023-10-23 11:00:00	AAPL	Stock	172.22	172.985	172.02	172.58	4922372.0
2023-10-23 12:00:00	AAPL	Stock	172.6	173.62	172.28	173.6	4277495.0
2023-10-23 13:00:00	AAPL	Stock	173.61	174.01	173.1131	173.521	4244030.0
2023-10-23 14:00:00	AAPL	Stock	173.52	173.8129	173.139	173.5	3823821.0
2023-10-23 15:00:00	AAPL	Stock	173.5	173.725	172.72	172.96	7097624.0
2023-10-23 16:00:00	AAPL	Stock	173.12	173.23	172.78	173.01	4274848.0
2023-10-23 17:00:00	AAPL	Stock	173.02	173.04	172.76	172.95	60031.0
2023-10-23 18:00:00	AAPL	Stock	172.95	172.96	172.71	172.94	17959.0
2023-10-23 19:00:00	AAPL	Stock	172.85	173.23	172.66	173.23	19133.0
2023-10-23 04:00:00	MSFT	Stock	328.28	328.28	327.1	327.11	3644.0
2023-10-23 05:00:00	MSFT	Stock	327.05	327.05	324.27	324.44	8258.0
2023-10-23 06:00:00	MSFT	Stock	324.94	325.21	324.5	325.21	5148.0
2023-10-23 07:00:00	MSFT	Stock	325.21	326.78	325.11	326.14	16719.0
2023-10-23 08:00:00	MSFT	Stock	325.0	328.44	325.0	326.74	46189.0
2023-10-23 09:00:00	MSFT	Stock	326.96	329.13	324.39	327.59	2970259.0
2023-10-23 10:00:00	MSFT	Stock	327.5796	328.32	326.5201	328.28	1827436.0
2023-10-23 11:00:00	MSFT	Stock	328.32	329.5724	327.92	329.41	1338347.0
2023-10-23 12:00:00	MSFT	Stock	329.41	332.68	329.05	332.68	2105062.0
2023-10-23 13:00:00	MSFT	Stock	332.66	332.725	331.23	331.65	1185125.0
2023-10-23 14:00:00	MSFT	Stock	331.64	332.09	330.622	331.09	1224491.0
2023-10-23 15:00:00	MSFT	Stock	331.08	331.54	329.07	329.16	2467572.0
2023-10-23 16:00:00	MSFT	Stock	329.16	330.7299	329.16	330.55	3315021.0
2023-10-23 17:00:00	MSFT	Stock	330.55	330.55	330.18	330.4	6611.0
2023-10-23 18:00:00	MSFT	Stock	330.3805	330.8	330.1801	330.25	17289.0
2023-10-23 19:00:00	MSFT	Stock	330.25	330.99	330.12	330.98	10843.0
2023-10-23 04:00:00	NVDA	Stock	41.21	41.46	41.21	41.214	79330.0
2023-10-23 05:00:00	NVDA	Stock	41.21	41.21	40.764	40.833	422080.0
2023-10-23 06:00:00	NVDA	Stock	40.85	41.01	40.803	41.01	246730.0
2023-10-23 07:00:00	NVDA	Stock	41.061	41.144	40.935	41.076	797770.0
2023-10-23 08:00:00	NVDA	Stock	40.999	41.527	40.935	41.23	1853720.0
2023-10-23 09:00:00	NVDA	Stock	41.248	41.957	40.945	41.924	55211300.0
2023-10-23 10:00:00	NVDA	Stock	41.933	42.56	41.725	42.388	78499820.0
2023-10-23 11:00:00	NVDA	Stock	42.388	42.77	42.221	42.768	47955620.0
2023-10-23 12:00:00	NVDA	Stock	42.7635	42.997	42.627	42.989	41980420.0
2023-10-23 13:00:00	NVDA	Stock	42.996	42.999	42.72	42.844	28936080.0
2023-10-23 14:00:00	NVDA	Stock	42.84	42.966	42.746	42.926	29008270.0
2023-10-23 15:00:00	NVDA	Stock	42.9295	43.248	42.811	42.975	63569770.0
2023-10-23 16:00:00	NVDA	Stock	42.976	43.238	42.5562	43.21	17035670.0
2023-10-23 17:00:00	NVDA	Stock	43.205	43.225	43.116	43.13	579380.0
2023-10-23 18:00:00	NVDA	Stock	43.126	43.174	43.094	43.1291	436700.0
2023-10-23 19:00:00	NVDA	Stock	43.13	43.285	43.105	43.271	561460.0
2023-10-23 04:00:00	AMZN	Stock	125.26	125.58	125.12	125.17	12031.0
2023-10-23 05:00:00	AMZN	Stock	125.01	125.04	124.15	124.15	21774.0

> showing 50 of 58,549 rows — these rows as CSV

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