PREVIEW / stock_1hour / 2022-01-10

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-01-10.parquet
  size:    1.5 MB
  rows:    65,987
  symbols: 2,645

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-10 04:00:00	AAPL	Stock	172.22	172.55	172.15	172.47	13855.0
2022-01-10 05:00:00	AAPL	Stock	172.4	172.5	171.64	171.78	18580.0
2022-01-10 06:00:00	AAPL	Stock	171.75	171.84	171.4	171.66	29747.0
2022-01-10 07:00:00	AAPL	Stock	171.62	171.78	170.0	170.0	197884.0
2022-01-10 08:00:00	AAPL	Stock	171.0999	171.77	169.0	169.23	908517.0
2022-01-10 09:00:00	AAPL	Stock	169.21	171.73	168.68	169.53	14977303.0
2022-01-10 10:00:00	AAPL	Stock	169.46	169.72	168.17	168.6932	13801259.0
2022-01-10 11:00:00	AAPL	Stock	168.7	170.02	168.45	169.075	9319292.0
2022-01-10 12:00:00	AAPL	Stock	169.07	170.135	168.29	169.66	7970779.0
2022-01-10 13:00:00	AAPL	Stock	169.64	171.45	169.53	171.16	9159881.0
2022-01-10 14:00:00	AAPL	Stock	171.16	171.66	170.35	170.69	8040011.0
2022-01-10 15:00:00	AAPL	Stock	170.7	172.5	169.9701	172.19	13917757.0
2022-01-10 16:00:00	AAPL	Stock	172.21	172.67	172.17	172.46	11267183.0
2022-01-10 17:00:00	AAPL	Stock	172.47	172.56	172.19	172.56	1935025.0
2022-01-10 18:00:00	AAPL	Stock	172.53	172.85	172.32	172.72	47834.0
2022-01-10 19:00:00	AAPL	Stock	172.76	172.95	172.19	172.9	51382.0
2022-01-10 04:00:00	MSFT	Stock	313.22	314.29	313.22	314.19	1832.0
2022-01-10 05:00:00	MSFT	Stock	314.2	314.48	313.7	313.7	1293.0
2022-01-10 06:00:00	MSFT	Stock	313.27	313.27	312.29	312.99	3039.0
2022-01-10 07:00:00	MSFT	Stock	313.19	313.45	309.02	309.02	51226.0
2022-01-10 08:00:00	MSFT	Stock	312.6129	313.45	308.5	309.98	96312.0
2022-01-10 09:00:00	MSFT	Stock	309.98	310.94	306.59	307.05	4172901.0
2022-01-10 10:00:00	MSFT	Stock	307.0	307.15	304.69	306.4669	4616296.0
2022-01-10 11:00:00	MSFT	Stock	306.41	308.94	306.29	307.88	2976551.0
2022-01-10 12:00:00	MSFT	Stock	307.87	308.5	305.62	307.29	2163574.0
2022-01-10 13:00:00	MSFT	Stock	307.24	310.75	307.21	310.25	2861652.0
2022-01-10 14:00:00	MSFT	Stock	310.235	312.8988	310.01	311.96	2634723.0
2022-01-10 15:00:00	MSFT	Stock	311.95	314.72	310.48	314.09	4596151.0
2022-01-10 16:00:00	MSFT	Stock	314.27	314.97	314.04	314.52	7326395.0
2022-01-10 17:00:00	MSFT	Stock	314.51	314.67	314.3	314.67	16234.0
2022-01-10 18:00:00	MSFT	Stock	314.74	314.92	314.4	314.75	15750.0
2022-01-10 19:00:00	MSFT	Stock	314.9	315.0	314.0	315.0	17993.0
2022-01-10 04:00:00	NVDA	Stock	27.224	27.28	27.052	27.167	184040.0
2022-01-10 05:00:00	NVDA	Stock	27.129	27.148	26.979	27.065	157700.0
2022-01-10 06:00:00	NVDA	Stock	27.048	27.052	26.871	26.9	250420.0
2022-01-10 07:00:00	NVDA	Stock	26.9	27.002	26.55	26.565	1820240.0
2022-01-10 08:00:00	NVDA	Stock	26.95	27.0	26.471	26.55	2400360.0
2022-01-10 09:00:00	NVDA	Stock	26.57	26.8	25.776	25.948	81637190.0
2022-01-10 10:00:00	NVDA	Stock	25.941	26.0751	25.6438	25.884	70439630.0
2022-01-10 11:00:00	NVDA	Stock	25.877	26.324	25.77	26.1916	50623480.0
2022-01-10 12:00:00	NVDA	Stock	26.183	26.22	25.801	26.13	34288030.0
2022-01-10 13:00:00	NVDA	Stock	26.132	26.827	26.075	26.649	56764880.0
2022-01-10 14:00:00	NVDA	Stock	26.655	27.011	26.6391	26.786	48114430.0
2022-01-10 15:00:00	NVDA	Stock	26.786	27.469	26.572	27.417	68308700.0
2022-01-10 16:00:00	NVDA	Stock	27.417	27.52	27.247	27.461	28226250.0
2022-01-10 17:00:00	NVDA	Stock	27.464	27.539	27.4	27.425	481790.0
2022-01-10 18:00:00	NVDA	Stock	27.47	27.545	27.43	27.545	319210.0
2022-01-10 19:00:00	NVDA	Stock	27.53	27.545	27.401	27.401	467800.0
2022-01-10 04:00:00	AMZN	Stock	162.4	162.9	162.4	162.9	4000.0
2022-01-10 07:00:00	AMZN	Stock	162.0125	162.0125	160.231	160.231	49940.0

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

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