PREVIEW / stock_1hour / 2023-04-14

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-04-14.parquet
  size:    1.3 MB
  rows:    59,812
  symbols: 1,680

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-04-14 04:00:00	AAPL	Stock	165.3	165.78	165.05	165.05	6293.0
2023-04-14 05:00:00	AAPL	Stock	165.0	165.0	164.89	164.94	2618.0
2023-04-14 06:00:00	AAPL	Stock	164.93	164.95	164.3	164.31	21812.0
2023-04-14 07:00:00	AAPL	Stock	164.55	164.72	164.35	164.55	70505.0
2023-04-14 08:00:00	AAPL	Stock	165.05	165.25	163.87	164.1018	373346.0
2023-04-14 09:00:00	AAPL	Stock	164.18	166.32	164.15	165.7813	7223661.0
2023-04-14 10:00:00	AAPL	Stock	165.76	166.3	164.575	164.91	7141465.0
2023-04-14 11:00:00	AAPL	Stock	164.915	165.4799	164.61	164.9187	3707290.0
2023-04-14 12:00:00	AAPL	Stock	164.93	164.94	163.82	164.0	3690414.0
2023-04-14 13:00:00	AAPL	Stock	164.0	164.6	163.935	164.4471	3410651.0
2023-04-14 14:00:00	AAPL	Stock	164.45	165.57	164.15	164.983	4186449.0
2023-04-14 15:00:00	AAPL	Stock	164.985	165.28	164.4	165.21	6419244.0
2023-04-14 16:00:00	AAPL	Stock	165.195	165.43	165.1	165.33	5930026.0
2023-04-14 17:00:00	AAPL	Stock	165.3	165.3	165.1433	165.17	11400.0
2023-04-14 18:00:00	AAPL	Stock	165.17	165.24	165.15	165.2	17298.0
2023-04-14 19:00:00	AAPL	Stock	165.21	165.2199	164.85	165.0	24208.0
2023-04-14 04:00:00	MSFT	Stock	289.9	289.9	289.31	289.45	3014.0
2023-04-14 05:00:00	MSFT	Stock	289.35	289.5	289.25	289.25	705.0
2023-04-14 06:00:00	MSFT	Stock	289.0	289.35	287.5	288.0	10168.0
2023-04-14 07:00:00	MSFT	Stock	288.4	288.7	287.43	287.67	22725.0
2023-04-14 08:00:00	MSFT	Stock	288.3	290.0	286.48	286.82	75705.0
2023-04-14 09:00:00	MSFT	Stock	286.82	288.359	286.44	287.85	2174701.0
2023-04-14 10:00:00	MSFT	Stock	287.83	288.48	285.47	286.29	2218861.0
2023-04-14 11:00:00	MSFT	Stock	286.33	287.31	285.71	286.26	1412642.0
2023-04-14 12:00:00	MSFT	Stock	286.255	286.315	284.07	284.19	1820999.0
2023-04-14 13:00:00	MSFT	Stock	284.18	285.22	283.69	284.933	2061479.0
2023-04-14 14:00:00	MSFT	Stock	284.96	286.0399	284.59	285.78	1396954.0
2023-04-14 15:00:00	MSFT	Stock	285.8	286.42	284.62	286.13	2634685.0
2023-04-14 16:00:00	MSFT	Stock	286.14	286.75	286.12	286.51	2293731.0
2023-04-14 17:00:00	MSFT	Stock	286.43	286.58	286.16	286.16	6929.0
2023-04-14 18:00:00	MSFT	Stock	286.23	286.3999	286.2001	286.3999	778.0
2023-04-14 19:00:00	MSFT	Stock	286.21	286.65	286.14	286.5	8808.0
2023-04-14 04:00:00	NVDA	Stock	26.45	26.499	26.44	26.499	70350.0
2023-04-14 05:00:00	NVDA	Stock	26.491	26.547	26.485	26.486	168770.0
2023-04-14 06:00:00	NVDA	Stock	26.499	26.561	26.34	26.369	242730.0
2023-04-14 07:00:00	NVDA	Stock	26.422	26.468	26.32	26.383	461050.0
2023-04-14 08:00:00	NVDA	Stock	26.41	26.55	26.3128	26.482	1456370.0
2023-04-14 09:00:00	NVDA	Stock	26.482	26.883	26.271	26.8305	49309850.0
2023-04-14 10:00:00	NVDA	Stock	26.826	26.869	26.3936	26.574	56814300.0
2023-04-14 11:00:00	NVDA	Stock	26.572	26.7392	26.492	26.52	36791150.0
2023-04-14 12:00:00	NVDA	Stock	26.526	26.561	26.309	26.387	32342100.0
2023-04-14 13:00:00	NVDA	Stock	26.381	26.562	26.22	26.492	41891180.0
2023-04-14 14:00:00	NVDA	Stock	26.493	26.698	26.453	26.6735	36460430.0
2023-04-14 15:00:00	NVDA	Stock	26.675	26.778	26.526	26.757	42949220.0
2023-04-14 16:00:00	NVDA	Stock	26.758	26.769	26.55	26.748	17768440.0
2023-04-14 17:00:00	NVDA	Stock	26.749	26.767	26.747	26.7638	199910.0
2023-04-14 18:00:00	NVDA	Stock	26.76	26.7637	26.683	26.7	269900.0
2023-04-14 19:00:00	NVDA	Stock	26.709	26.75	26.7	26.722	209330.0
2023-04-14 04:00:00	AMZN	Stock	104.0	104.0	101.91	102.02	12372.0
2023-04-14 05:00:00	AMZN	Stock	102.03	102.03	101.72	101.72	9488.0

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

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