PREVIEW / stock_1hour / 2023-09-21

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-09-21.parquet
  size:    1.3 MB
  rows:    59,381
  symbols: 1,396

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-09-21 04:00:00	AAPL	Stock	175.01	175.03	174.55	174.61	24626.0
2023-09-21 05:00:00	AAPL	Stock	174.6	174.72	174.5	174.53	16487.0
2023-09-21 06:00:00	AAPL	Stock	174.54	174.62	174.34	174.48	32336.0
2023-09-21 07:00:00	AAPL	Stock	174.58	174.66	174.2	174.5	103324.0
2023-09-21 08:00:00	AAPL	Stock	174.7	175.05	173.88	173.89	429059.0
2023-09-21 09:00:00	AAPL	Stock	173.9	176.05	173.7	174.68	7935434.0
2023-09-21 10:00:00	AAPL	Stock	174.66	176.3	174.63	175.41	8887789.0
2023-09-21 11:00:00	AAPL	Stock	175.4	175.7	174.82	175.377	4992901.0
2023-09-21 12:00:00	AAPL	Stock	175.37	175.4212	174.86	174.885	4113143.0
2023-09-21 13:00:00	AAPL	Stock	174.88	175.54	174.87	175.35	3943759.0
2023-09-21 14:00:00	AAPL	Stock	175.35	175.39	174.52	174.651	4515687.0
2023-09-21 15:00:00	AAPL	Stock	174.655	174.8099	173.86	173.93	8765594.0
2023-09-21 16:00:00	AAPL	Stock	173.92	174.07	173.79	173.88	7528059.0
2023-09-21 17:00:00	AAPL	Stock	173.88	173.96	173.74	173.89	44235.0
2023-09-21 18:00:00	AAPL	Stock	173.87	174.29	173.87	174.11	52245.0
2023-09-21 19:00:00	AAPL	Stock	174.12	174.22	174.03	174.14	35782.0
2023-09-21 04:00:00	MSFT	Stock	319.9	320.3	319.38	319.4	2831.0
2023-09-21 05:00:00	MSFT	Stock	319.6	319.6	319.3	319.3	2012.0
2023-09-21 06:00:00	MSFT	Stock	319.49	319.5	319.1	319.25	2752.0
2023-09-21 07:00:00	MSFT	Stock	319.41	319.75	318.0	318.77	40459.0
2023-09-21 08:00:00	MSFT	Stock	319.66	319.68	318.08	318.5495	65311.0
2023-09-21 09:00:00	MSFT	Stock	318.59	320.31	317.27	317.43	2590184.0
2023-09-21 10:00:00	MSFT	Stock	317.43	325.3499	315.0	323.24	7807403.0
2023-09-21 11:00:00	MSFT	Stock	323.25	324.15	321.51	321.71	2166216.0
2023-09-21 12:00:00	MSFT	Stock	321.7	321.81	320.24	321.275	1404295.0
2023-09-21 13:00:00	MSFT	Stock	321.27	323.4	321.2	321.86	1851061.0
2023-09-21 14:00:00	MSFT	Stock	321.95	322.55	320.34	320.54	1473726.0
2023-09-21 15:00:00	MSFT	Stock	320.57	321.76	319.5	319.51	4182891.0
2023-09-21 16:00:00	MSFT	Stock	319.54	319.7	318.49	318.6	3900856.0
2023-09-21 17:00:00	MSFT	Stock	318.71	319.16	318.47	318.68	25247.0
2023-09-21 18:00:00	MSFT	Stock	318.87	319.49	318.87	319.42	9457.0
2023-09-21 19:00:00	MSFT	Stock	319.51	319.53	318.8	319.3	13372.0
2023-09-21 04:00:00	NVDA	Stock	41.77	41.961	41.6	41.647	160890.0
2023-09-21 05:00:00	NVDA	Stock	41.682	41.699	41.545	41.564	247360.0
2023-09-21 06:00:00	NVDA	Stock	41.58	41.654	41.526	41.654	206680.0
2023-09-21 07:00:00	NVDA	Stock	41.659	41.695	41.2	41.31	1429180.0
2023-09-21 08:00:00	NVDA	Stock	41.32	41.92	41.15	41.239	3679780.0
2023-09-21 09:00:00	NVDA	Stock	41.25	42.1	41.2	41.324	68635790.0
2023-09-21 10:00:00	NVDA	Stock	41.36	41.825	41.271	41.6047	74009710.0
2023-09-21 11:00:00	NVDA	Stock	41.599	41.72	41.333	41.376	37935810.0
2023-09-21 12:00:00	NVDA	Stock	41.378	41.5443	41.29	41.352	29335120.0
2023-09-21 13:00:00	NVDA	Stock	41.3545	41.66	41.315	41.472	28237890.0
2023-09-21 14:00:00	NVDA	Stock	41.47	41.49	41.237	41.238	27557710.0
2023-09-21 15:00:00	NVDA	Stock	41.241	41.296	40.98	41.006	62222280.0
2023-09-21 16:00:00	NVDA	Stock	41.005	41.422	40.875	40.96	17397450.0
2023-09-21 17:00:00	NVDA	Stock	40.955	40.955	40.7254	40.764	886860.0
2023-09-21 18:00:00	NVDA	Stock	40.775	40.914	40.775	40.854	648430.0
2023-09-21 19:00:00	NVDA	Stock	40.846	40.852	40.768	40.815	741060.0
2023-09-21 04:00:00	AMZN	Stock	135.0	135.01	134.41	134.41	9890.0
2023-09-21 05:00:00	AMZN	Stock	134.5	134.65	134.4	134.4	5701.0

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

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