PREVIEW / stock_1hour / 2023-03-31

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-03-31.parquet
  size:    1.4 MB
  rows:    60,449
  symbols: 1,721

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-03-31 04:00:00	AAPL	Stock	162.39	162.5	161.97	162.01	7280.0
2023-03-31 05:00:00	AAPL	Stock	162.01	162.14	161.93	162.05	4770.0
2023-03-31 06:00:00	AAPL	Stock	162.12	162.12	161.84	162.04	16043.0
2023-03-31 07:00:00	AAPL	Stock	162.08	162.24	162.02	162.11	23621.0
2023-03-31 08:00:00	AAPL	Stock	162.21	162.8	161.955	162.16	226167.0
2023-03-31 09:00:00	AAPL	Stock	162.19	163.09	161.91	162.705	5172957.0
2023-03-31 10:00:00	AAPL	Stock	162.71	163.02	162.25	162.785	5794873.0
2023-03-31 11:00:00	AAPL	Stock	162.8	163.26	162.7093	163.22	4256942.0
2023-03-31 12:00:00	AAPL	Stock	163.22	164.04	163.15	163.8	5343629.0
2023-03-31 13:00:00	AAPL	Stock	163.81	164.075	163.57	163.9571	3901595.0
2023-03-31 14:00:00	AAPL	Stock	163.96	164.24	163.92	164.23	3944084.0
2023-03-31 15:00:00	AAPL	Stock	164.22	165.0	164.125	164.84	15070141.0
2023-03-31 16:00:00	AAPL	Stock	164.83	164.96	164.63	164.82	16388951.0
2023-03-31 17:00:00	AAPL	Stock	164.82	164.9	164.74	164.75	55843.0
2023-03-31 18:00:00	AAPL	Stock	164.75	164.87	164.71	164.87	30013.0
2023-03-31 19:00:00	AAPL	Stock	164.87	164.93	164.81	164.9	17491.0
2023-03-31 04:00:00	MSFT	Stock	283.95	284.3	283.65	283.73	5519.0
2023-03-31 05:00:00	MSFT	Stock	283.9	283.9	283.81	283.81	1322.0
2023-03-31 06:00:00	MSFT	Stock	283.6	283.7	283.5	283.55	1780.0
2023-03-31 07:00:00	MSFT	Stock	283.55	283.9	283.25	283.25	8715.0
2023-03-31 08:00:00	MSFT	Stock	283.85	285.0	283.0	284.3	72500.0
2023-03-31 09:00:00	MSFT	Stock	284.2	284.8489	283.25	283.77	2279163.0
2023-03-31 10:00:00	MSFT	Stock	283.81	284.27	283.0	283.89	2835961.0
2023-03-31 11:00:00	MSFT	Stock	283.9	285.35	283.78	285.32	2153626.0
2023-03-31 12:00:00	MSFT	Stock	285.32	286.85	284.91	286.64	2485497.0
2023-03-31 13:00:00	MSFT	Stock	286.64	286.8299	285.97	286.55	1646189.0
2023-03-31 14:00:00	MSFT	Stock	286.57	287.25	286.46	287.21	1549052.0
2023-03-31 15:00:00	MSFT	Stock	287.17	288.82	287.16	288.23	5176261.0
2023-03-31 16:00:00	MSFT	Stock	288.3	289.27	288.14	288.5	8185736.0
2023-03-31 17:00:00	MSFT	Stock	288.4894	288.4894	288.3	288.37	15279.0
2023-03-31 18:00:00	MSFT	Stock	288.25	288.44	288.16	288.44	7741.0
2023-03-31 19:00:00	MSFT	Stock	288.32	288.54	288.31	288.54	9656.0
2023-03-31 04:00:00	NVDA	Stock	27.376	27.376	27.254	27.263	87120.0
2023-03-31 05:00:00	NVDA	Stock	27.271	27.322	27.211	27.225	87720.0
2023-03-31 06:00:00	NVDA	Stock	27.216	27.222	27.16	27.179	89360.0
2023-03-31 07:00:00	NVDA	Stock	27.21	27.26	27.188	27.232	418330.0
2023-03-31 08:00:00	NVDA	Stock	27.223	27.476	27.129	27.176	3128990.0
2023-03-31 09:00:00	NVDA	Stock	27.188	27.538	27.105	27.514	53842770.0
2023-03-31 10:00:00	NVDA	Stock	27.515	27.586	27.355	27.444	54742660.0
2023-03-31 11:00:00	NVDA	Stock	27.4476	27.6	27.331	27.5724	38851290.0
2023-03-31 12:00:00	NVDA	Stock	27.5717	27.8343	27.535	27.72	42361800.0
2023-03-31 13:00:00	NVDA	Stock	27.72	27.8298	27.662	27.732	30483880.0
2023-03-31 14:00:00	NVDA	Stock	27.732	27.788	27.602	27.6315	31176270.0
2023-03-31 15:00:00	NVDA	Stock	27.63	27.827	27.601	27.777	57322180.0
2023-03-31 16:00:00	NVDA	Stock	27.813	27.82	27.752	27.754	37704430.0
2023-03-31 17:00:00	NVDA	Stock	27.757	27.769	27.742	27.76	305940.0
2023-03-31 18:00:00	NVDA	Stock	27.76	27.8	27.74	27.781	479260.0
2023-03-31 19:00:00	NVDA	Stock	27.788	27.825	27.788	27.8	240600.0
2023-03-31 04:00:00	AMZN	Stock	101.98	102.05	101.48	101.78	8723.0
2023-03-31 05:00:00	AMZN	Stock	101.7	101.89	101.68	101.68	5086.0

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

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