PREVIEW / stock_1hour / 2023-08-03

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-08-03.parquet
  size:    1.4 MB
  rows:    60,660
  symbols: 1,523

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-03 04:00:00	AAPL	Stock	191.9	191.9	190.74	191.48	43014.0
2023-08-03 05:00:00	AAPL	Stock	191.48	192.1	191.48	191.83	14370.0
2023-08-03 06:00:00	AAPL	Stock	191.91	192.07	191.7	191.7	11506.0
2023-08-03 07:00:00	AAPL	Stock	191.75	192.25	191.65	191.79	57011.0
2023-08-03 08:00:00	AAPL	Stock	191.8	193.0	191.45	191.73	216176.0
2023-08-03 09:00:00	AAPL	Stock	191.77	192.28	190.69	191.69	5148493.0
2023-08-03 10:00:00	AAPL	Stock	191.68	192.03	190.84	191.72	6185794.0
2023-08-03 11:00:00	AAPL	Stock	191.72	192.37	191.623	191.74	4262612.0
2023-08-03 12:00:00	AAPL	Stock	191.74	192.36	191.61	192.215	3203496.0
2023-08-03 13:00:00	AAPL	Stock	192.22	192.3	191.24	191.3702	3481369.0
2023-08-03 14:00:00	AAPL	Stock	191.37	191.95	191.2	191.84	4145277.0
2023-08-03 15:00:00	AAPL	Stock	191.85	191.95	190.99	191.0099	9061342.0
2023-08-03 16:00:00	AAPL	Stock	191.005	196.11	187.21	189.01	9570632.0
2023-08-03 17:00:00	AAPL	Stock	189.01	189.48	185.0	187.0	2861255.0
2023-08-03 18:00:00	AAPL	Stock	187.0	187.45	185.85	187.45	708813.0
2023-08-03 19:00:00	AAPL	Stock	187.45	187.8	186.68	187.3	338150.0
2023-08-03 04:00:00	MSFT	Stock	326.5	326.5	325.01	326.0	16863.0
2023-08-03 05:00:00	MSFT	Stock	326.71	327.0	326.32	327.0	8053.0
2023-08-03 06:00:00	MSFT	Stock	326.8	327.15	326.8	326.8	2868.0
2023-08-03 07:00:00	MSFT	Stock	326.92	327.3	326.02	326.45	14247.0
2023-08-03 08:00:00	MSFT	Stock	326.92	327.7	325.05	325.3212	58661.0
2023-08-03 09:00:00	MSFT	Stock	325.46	328.68	325.15	328.48	2263801.0
2023-08-03 10:00:00	MSFT	Stock	328.43	329.15	326.56	328.49	2337836.0
2023-08-03 11:00:00	MSFT	Stock	328.4529	329.88	328.01	328.14	1510225.0
2023-08-03 12:00:00	MSFT	Stock	328.11	329.38	327.93	329.1601	942796.0
2023-08-03 13:00:00	MSFT	Stock	329.19	329.49	327.68	327.7631	901768.0
2023-08-03 14:00:00	MSFT	Stock	327.74	328.298	327.03	328.19	836129.0
2023-08-03 15:00:00	MSFT	Stock	328.24	328.24	326.58	326.64	1958902.0
2023-08-03 16:00:00	MSFT	Stock	326.64	329.6	326.56	327.81	2585191.0
2023-08-03 17:00:00	MSFT	Stock	327.89	328.5	327.05	327.5186	30299.0
2023-08-03 18:00:00	MSFT	Stock	327.62	329.695	327.5	329.2	72442.0
2023-08-03 19:00:00	MSFT	Stock	329.0401	329.63	329.0401	329.4	15498.0
2023-08-03 04:00:00	NVDA	Stock	44.154	44.154	43.785	43.942	414320.0
2023-08-03 05:00:00	NVDA	Stock	43.966	44.169	43.91	44.165	157710.0
2023-08-03 06:00:00	NVDA	Stock	44.175	44.255	44.0	44.019	125100.0
2023-08-03 07:00:00	NVDA	Stock	44.049	44.132	43.699	43.85	636200.0
2023-08-03 08:00:00	NVDA	Stock	44.113	44.49	43.68	43.7317	1842600.0
2023-08-03 09:00:00	NVDA	Stock	43.75	44.93	43.645	44.789	49659320.0
2023-08-03 10:00:00	NVDA	Stock	44.789	44.995	44.29	44.8535	56159790.0
2023-08-03 11:00:00	NVDA	Stock	44.8535	45.118	44.715	44.821	35215030.0
2023-08-03 12:00:00	NVDA	Stock	44.808	45.0	44.67	44.9504	21994760.0
2023-08-03 13:00:00	NVDA	Stock	44.964	45.03	44.6	44.6255	18917620.0
2023-08-03 14:00:00	NVDA	Stock	44.612	44.696	44.47	44.6318	22536420.0
2023-08-03 15:00:00	NVDA	Stock	44.644	44.655	44.361	44.514	24091790.0
2023-08-03 16:00:00	NVDA	Stock	44.515	44.9	44.44	44.7	11994240.0
2023-08-03 17:00:00	NVDA	Stock	44.6822	44.7	44.405	44.54	524440.0
2023-08-03 18:00:00	NVDA	Stock	44.533	44.7394	44.52	44.739	287260.0
2023-08-03 19:00:00	NVDA	Stock	44.736	44.798	44.703	44.73	369640.0
2023-08-03 04:00:00	AMZN	Stock	128.0	128.99	127.38	128.28	49302.0
2023-08-03 05:00:00	AMZN	Stock	128.33	128.87	128.33	128.67	15393.0

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

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