PREVIEW / stock_1hour / 2023-01-18

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-01-18.parquet
  size:    1.4 MB
  rows:    61,904
  symbols: 1,938

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-01-18 04:00:00	AAPL	Stock	136.28	136.3	136.07	136.17	15063.0
2023-01-18 05:00:00	AAPL	Stock	136.18	136.45	136.02	136.41	14301.0
2023-01-18 06:00:00	AAPL	Stock	136.44	136.57	136.32	136.57	8528.0
2023-01-18 07:00:00	AAPL	Stock	136.52	136.88	136.43	136.88	64384.0
2023-01-18 08:00:00	AAPL	Stock	136.5995	137.2699	135.601	136.96	466063.0
2023-01-18 09:00:00	AAPL	Stock	136.92	138.0	136.68	137.98	9444846.0
2023-01-18 10:00:00	AAPL	Stock	137.98	138.61	136.55	137.055	11039849.0
2023-01-18 11:00:00	AAPL	Stock	137.05	137.3699	135.8	136.1559	7589777.0
2023-01-18 12:00:00	AAPL	Stock	136.1578	136.2799	135.42	135.7	5426170.0
2023-01-18 13:00:00	AAPL	Stock	135.7	136.27	135.33	136.06	5217979.0
2023-01-18 14:00:00	AAPL	Stock	136.07	136.16	135.65	135.805	4124853.0
2023-01-18 15:00:00	AAPL	Stock	135.8	136.11	135.03	135.2	7794346.0
2023-01-18 16:00:00	AAPL	Stock	135.2	135.25	134.9	135.05	9297741.0
2023-01-18 17:00:00	AAPL	Stock	135.05	135.07	134.7617	134.86	50858.0
2023-01-18 18:00:00	AAPL	Stock	134.9	135.16	134.76	134.79	57540.0
2023-01-18 19:00:00	AAPL	Stock	134.79	134.8	134.4	134.44	48753.0
2023-01-18 04:00:00	MSFT	Stock	240.41	240.41	239.99	240.15	1809.0
2023-01-18 05:00:00	MSFT	Stock	239.89	240.0	239.59	239.94	1327.0
2023-01-18 06:00:00	MSFT	Stock	239.92	240.61	239.92	240.61	6070.0
2023-01-18 07:00:00	MSFT	Stock	240.65	241.45	240.47	241.41	21349.0
2023-01-18 08:00:00	MSFT	Stock	240.71	242.98	239.75	241.65	62760.0
2023-01-18 09:00:00	MSFT	Stock	241.75	244.0	240.11	241.11	3644862.0
2023-01-18 10:00:00	MSFT	Stock	241.09	242.05	237.56	238.27	3657201.0
2023-01-18 11:00:00	MSFT	Stock	238.25	238.5	236.35	237.38	2585056.0
2023-01-18 12:00:00	MSFT	Stock	237.37	237.68	236.89	237.2033	1537315.0
2023-01-18 13:00:00	MSFT	Stock	237.22	237.411	236.26	237.12	1412784.0
2023-01-18 14:00:00	MSFT	Stock	237.15	237.97	236.83	237.1564	1244297.0
2023-01-18 15:00:00	MSFT	Stock	237.16	237.41	235.52	235.8	3748668.0
2023-01-18 16:00:00	MSFT	Stock	235.81	235.84	235.3297	235.57	4736136.0
2023-01-18 17:00:00	MSFT	Stock	235.6	235.81	235.1	235.1	210239.0
2023-01-18 18:00:00	MSFT	Stock	235.21	235.74	235.21	235.6	11905.0
2023-01-18 19:00:00	MSFT	Stock	235.45	235.59	235.16	235.17	5258.0
2023-01-18 04:00:00	NVDA	Stock	17.678	17.73	17.678	17.726	140190.0
2023-01-18 05:00:00	NVDA	Stock	17.727	17.78	17.701	17.78	40290.0
2023-01-18 06:00:00	NVDA	Stock	17.77	17.775	17.735	17.74	95010.0
2023-01-18 07:00:00	NVDA	Stock	17.732	17.75	17.64	17.698	444150.0
2023-01-18 08:00:00	NVDA	Stock	17.665	17.797	17.555	17.692	1814060.0
2023-01-18 09:00:00	NVDA	Stock	17.7	17.843	17.493	17.731	69142960.0
2023-01-18 10:00:00	NVDA	Stock	17.726	17.873	17.417	17.513	82272220.0
2023-01-18 11:00:00	NVDA	Stock	17.511	17.523	17.282	17.4625	53794540.0
2023-01-18 12:00:00	NVDA	Stock	17.4616	17.523	17.3715	17.403	35578320.0
2023-01-18 13:00:00	NVDA	Stock	17.404	17.485	17.319	17.4405	29189350.0
2023-01-18 14:00:00	NVDA	Stock	17.443	17.527	17.377	17.495	29560410.0
2023-01-18 15:00:00	NVDA	Stock	17.495	17.518	17.362	17.376	42850590.0
2023-01-18 16:00:00	NVDA	Stock	17.375	17.395	17.352	17.39	26067860.0
2023-01-18 17:00:00	NVDA	Stock	17.38	17.381	17.351	17.36	580730.0
2023-01-18 18:00:00	NVDA	Stock	17.36	17.374	17.352	17.36	104720.0
2023-01-18 19:00:00	NVDA	Stock	17.352	17.352	17.281	17.29	194450.0
2023-01-18 04:00:00	AMZN	Stock	96.74	96.74	95.96	96.21	26735.0
2023-01-18 05:00:00	AMZN	Stock	96.2	96.5	96.1	96.47	14191.0

> showing 50 of 61,904 rows — these rows as CSV

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