PREVIEW / stock_1hour / 2022-04-06

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-04-06.parquet
  size:    1.4 MB
  rows:    65,129
  symbols: 2,495

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
2022-04-06 04:00:00	AAPL	Stock	175.0	175.0	173.43	173.93	30927.0
2022-04-06 05:00:00	AAPL	Stock	173.99	173.99	173.45	173.75	34963.0
2022-04-06 06:00:00	AAPL	Stock	173.65	173.65	173.11	173.17	17867.0
2022-04-06 07:00:00	AAPL	Stock	173.16	173.28	172.29	172.38	158926.0
2022-04-06 08:00:00	AAPL	Stock	172.57	174.19	172.0	172.51	702569.0
2022-04-06 09:00:00	AAPL	Stock	172.51	173.24	171.21	171.605	11478174.0
2022-04-06 10:00:00	AAPL	Stock	171.63	171.67	170.82	170.89	11260307.0
2022-04-06 11:00:00	AAPL	Stock	170.875	171.74	170.13	171.62	8841573.0
2022-04-06 12:00:00	AAPL	Stock	171.62	171.71	170.835	171.35	5247520.0
2022-04-06 13:00:00	AAPL	Stock	171.34	172.39	171.03	171.92	5554473.0
2022-04-06 14:00:00	AAPL	Stock	171.94	173.41	170.93	173.1	11561464.0
2022-04-06 15:00:00	AAPL	Stock	173.1113	173.63	171.51	171.57	13284207.0
2022-04-06 16:00:00	AAPL	Stock	171.59	171.89	171.2	171.31	8914262.0
2022-04-06 17:00:00	AAPL	Stock	171.29	171.42	171.28	171.32	14632.0
2022-04-06 18:00:00	AAPL	Stock	171.41	171.76	171.35	171.7	30254.0
2022-04-06 19:00:00	AAPL	Stock	171.74	171.74	170.85	170.9	70022.0
2022-04-06 04:00:00	MSFT	Stock	308.53	309.0	307.72	308.31	4646.0
2022-04-06 05:00:00	MSFT	Stock	308.45	308.5	306.95	307.49	3928.0
2022-04-06 06:00:00	MSFT	Stock	307.35	307.46	306.12	306.24	7412.0
2022-04-06 07:00:00	MSFT	Stock	306.42	306.49	304.51	304.53	22191.0
2022-04-06 08:00:00	MSFT	Stock	306.35	310.103	304.3449	304.9	66197.0
2022-04-06 09:00:00	MSFT	Stock	304.9	307.0	302.275	302.99	3387247.0
2022-04-06 10:00:00	MSFT	Stock	303.03	303.2499	301.2	301.66	3902121.0
2022-04-06 11:00:00	MSFT	Stock	301.61	301.89	299.5	299.5767	3210724.0
2022-04-06 12:00:00	MSFT	Stock	299.58	300.06	297.8	297.95	2318406.0
2022-04-06 13:00:00	MSFT	Stock	297.95	299.67	297.14	299.03	3048112.0
2022-04-06 14:00:00	MSFT	Stock	299.03	301.89	296.71	301.875	3903238.0
2022-04-06 15:00:00	MSFT	Stock	301.885	302.93	298.733	299.4	5266018.0
2022-04-06 16:00:00	MSFT	Stock	299.5	299.5	298.83	299.35	4973591.0
2022-04-06 17:00:00	MSFT	Stock	299.16	299.39	299.13	299.38	7829.0
2022-04-06 18:00:00	MSFT	Stock	299.35	299.68	299.19	299.2	28312.0
2022-04-06 19:00:00	MSFT	Stock	299.2	299.2	297.65	297.8	20474.0
2022-04-06 04:00:00	NVDA	Stock	25.779	25.779	25.55	25.648	178760.0
2022-04-06 05:00:00	NVDA	Stock	25.65	25.67	25.55	25.64	100450.0
2022-04-06 06:00:00	NVDA	Stock	25.64	25.64	25.055	25.154	1038730.0
2022-04-06 07:00:00	NVDA	Stock	25.194	25.249	24.88	24.898	3200620.0
2022-04-06 08:00:00	NVDA	Stock	25.04	25.9	24.732	24.861	4378860.0
2022-04-06 09:00:00	NVDA	Stock	24.861	25.931	24.705	24.708	70945230.0
2022-04-06 10:00:00	NVDA	Stock	24.715	24.774	24.383	24.494	71827890.0
2022-04-06 11:00:00	NVDA	Stock	24.491	24.6	24.231	24.3034	61012690.0
2022-04-06 12:00:00	NVDA	Stock	24.301	24.35	24.003	24.081	46642190.0
2022-04-06 13:00:00	NVDA	Stock	24.077	24.631	24.015	24.3595	59393970.0
2022-04-06 14:00:00	NVDA	Stock	24.365	24.823	24.03	24.713	91185630.0
2022-04-06 15:00:00	NVDA	Stock	24.722	24.989	24.324	24.388	87624390.0
2022-04-06 16:00:00	NVDA	Stock	24.407	24.407	24.315	24.325	19966470.0
2022-04-06 17:00:00	NVDA	Stock	24.326	24.349	24.31	24.349	224060.0
2022-04-06 18:00:00	NVDA	Stock	24.35	24.399	24.35	24.38	138870.0
2022-04-06 19:00:00	NVDA	Stock	24.397	24.4	24.105	24.145	421580.0
2022-04-06 06:00:00	AMZN	Stock	162.6	162.606	162.6	162.6	9200.0
2022-04-06 07:00:00	AMZN	Stock	162.7375	162.7375	161.55	161.55	46520.0

> showing 50 of 65,129 rows — these rows as CSV

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