PREVIEW / stock_1hour / 2022-01-14

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-01-14.parquet
  size:    1.4 MB
  rows:    64,252
  symbols: 2,594

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-01-14 04:00:00	AAPL	Stock	172.2	172.94	172.2	172.7	15626.0
2022-01-14 05:00:00	AAPL	Stock	172.85	172.9	172.02	172.44	18340.0
2022-01-14 06:00:00	AAPL	Stock	172.41	172.5	171.88	172.0	7939.0
2022-01-14 07:00:00	AAPL	Stock	172.11	172.3	170.32	170.4	185689.0
2022-01-14 08:00:00	AAPL	Stock	172.0046	172.31	170.3	170.93	519577.0
2022-01-14 09:00:00	AAPL	Stock	170.93	173.51	170.76	173.3609	9010513.0
2022-01-14 10:00:00	AAPL	Stock	173.37	173.78	171.68	172.3359	10626888.0
2022-01-14 11:00:00	AAPL	Stock	172.34	172.94	171.26	172.705	8514130.0
2022-01-14 12:00:00	AAPL	Stock	172.71	172.92	171.3039	171.425	5706159.0
2022-01-14 13:00:00	AAPL	Stock	171.425	172.24	171.09	172.0811	5968023.0
2022-01-14 14:00:00	AAPL	Stock	172.07	172.58	171.78	172.07	5568364.0
2022-01-14 15:00:00	AAPL	Stock	172.06	173.28	171.99	173.07	9901418.0
2022-01-14 16:00:00	AAPL	Stock	173.07	173.38	173.02	173.33	8701096.0
2022-01-14 17:00:00	AAPL	Stock	173.31	173.32	173.07	173.19	23255.0
2022-01-14 18:00:00	AAPL	Stock	173.2	173.24	173.1	173.2	18925.0
2022-01-14 19:00:00	AAPL	Stock	173.24	173.3	173.06	173.3	45228.0
2022-01-14 04:00:00	MSFT	Stock	305.4	306.33	305.2	306.0	7867.0
2022-01-14 05:00:00	MSFT	Stock	306.01	306.01	304.3	305.5	11858.0
2022-01-14 06:00:00	MSFT	Stock	305.5	305.5	304.3	304.8	9115.0
2022-01-14 07:00:00	MSFT	Stock	305.0	305.18	301.93	301.93	69868.0
2022-01-14 08:00:00	MSFT	Stock	304.4006	305.21	301.64	302.32	105228.0
2022-01-14 09:00:00	MSFT	Stock	302.5	309.72	302.13	308.9	5792577.0
2022-01-14 10:00:00	MSFT	Stock	308.87	309.16	306.66	308.01	4195282.0
2022-01-14 11:00:00	MSFT	Stock	308.0067	308.86	306.16	308.31	2990209.0
2022-01-14 12:00:00	MSFT	Stock	308.31	309.23	307.58	307.76	2927048.0
2022-01-14 13:00:00	MSFT	Stock	307.74	308.71	306.77	308.46	2266316.0
2022-01-14 14:00:00	MSFT	Stock	308.43	309.18	307.67	307.7	2138844.0
2022-01-14 15:00:00	MSFT	Stock	307.69	310.82	307.67	310.2	5393391.0
2022-01-14 16:00:00	MSFT	Stock	310.09	310.48	309.5	310.04	3502219.0
2022-01-14 17:00:00	MSFT	Stock	309.95	310.01	309.66	310.0	15364.0
2022-01-14 18:00:00	MSFT	Stock	309.89	310.1	309.89	310.1	1875.0
2022-01-14 19:00:00	MSFT	Stock	310.0	310.2	309.82	310.2	15335.0
2022-01-14 04:00:00	NVDA	Stock	26.7	26.899	26.7	26.785	199800.0
2022-01-14 05:00:00	NVDA	Stock	26.775	26.776	26.542	26.625	93970.0
2022-01-14 06:00:00	NVDA	Stock	26.639	26.679	26.48	26.52	123290.0
2022-01-14 07:00:00	NVDA	Stock	26.554	26.565	26.15	26.151	853750.0
2022-01-14 08:00:00	NVDA	Stock	26.154	26.547	26.1	26.18	1899040.0
2022-01-14 09:00:00	NVDA	Stock	26.197	27.175	26.151	27.089	57533770.0
2022-01-14 10:00:00	NVDA	Stock	27.0764	27.1969	26.6101	26.887	56745180.0
2022-01-14 11:00:00	NVDA	Stock	26.889	27.052	26.638	26.9597	34726740.0
2022-01-14 12:00:00	NVDA	Stock	26.943	26.983	26.476	26.522	23349660.0
2022-01-14 13:00:00	NVDA	Stock	26.52	26.807	26.37	26.765	30341900.0
2022-01-14 14:00:00	NVDA	Stock	26.751	26.8219	26.581	26.585	27587720.0
2022-01-14 15:00:00	NVDA	Stock	26.588	26.975	26.588	26.942	38033760.0
2022-01-14 16:00:00	NVDA	Stock	26.942	26.977	26.7922	26.959	14112000.0
2022-01-14 17:00:00	NVDA	Stock	26.951	26.958	26.903	26.928	305520.0
2022-01-14 18:00:00	NVDA	Stock	26.92	26.935	26.899	26.93	225050.0
2022-01-14 19:00:00	NVDA	Stock	26.93	26.939	26.883	26.885	306290.0
2022-01-14 05:00:00	AMZN	Stock	161.325	161.325	161.325	161.325	2000.0
2022-01-14 07:00:00	AMZN	Stock	160.85	160.85	159.8515	159.8515	50600.0

> showing 50 of 64,252 rows — these rows as CSV

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