PREVIEW / stock_1hour / 2021-01-20

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-01-20.parquet
  size:    1.4 MB
  rows:    66,284
  symbols: 2,712

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
2021-01-20 04:00:00	AAPL	Stock	128.68	128.75	128.0	128.68	28350.0
2021-01-20 05:00:00	AAPL	Stock	128.66	128.75	128.57	128.72	16335.0
2021-01-20 06:00:00	AAPL	Stock	128.72	128.72	128.46	128.58	18041.0
2021-01-20 07:00:00	AAPL	Stock	128.58	128.73	128.45	128.73	143627.0
2021-01-20 08:00:00	AAPL	Stock	128.74	128.75	128.45	128.68	349412.0
2021-01-20 09:00:00	AAPL	Stock	128.69	130.423	128.55	129.985	13808762.0
2021-01-20 10:00:00	AAPL	Stock	129.985	131.82	129.8	131.71	17677895.0
2021-01-20 11:00:00	AAPL	Stock	131.708	132.25	131.062	132.085	11932212.0
2021-01-20 12:00:00	AAPL	Stock	132.09	132.22	131.68	131.87	7187443.0
2021-01-20 13:00:00	AAPL	Stock	131.87	132.44	131.82	131.934	7349741.0
2021-01-20 14:00:00	AAPL	Stock	131.935	132.49	131.73	132.183	7501703.0
2021-01-20 15:00:00	AAPL	Stock	132.18	132.46	131.94	131.97	12273439.0
2021-01-20 16:00:00	AAPL	Stock	131.98	132.28	131.96	132.25	13193826.0
2021-01-20 17:00:00	AAPL	Stock	132.25	132.27	132.17	132.22	54812.0
2021-01-20 18:00:00	AAPL	Stock	132.23	132.55	132.19	132.55	199147.0
2021-01-20 19:00:00	AAPL	Stock	132.52	133.0	132.41	133.0	209166.0
2021-01-20 04:00:00	MSFT	Stock	217.28	217.47	217.18	217.45	3803.0
2021-01-20 05:00:00	MSFT	Stock	217.32	217.97	217.32	217.97	2895.0
2021-01-20 06:00:00	MSFT	Stock	217.83	218.07	217.32	217.38	31745.0
2021-01-20 07:00:00	MSFT	Stock	217.38	217.78	217.35	217.78	19010.0
2021-01-20 08:00:00	MSFT	Stock	217.8	218.01	216.44	217.67	45857.0
2021-01-20 09:00:00	MSFT	Stock	217.76	221.25	217.291	221.18	4530526.0
2021-01-20 10:00:00	MSFT	Stock	221.15	224.31	220.99	223.81	6488138.0
2021-01-20 11:00:00	MSFT	Stock	223.8	225.192	223.45	223.91	4061743.0
2021-01-20 12:00:00	MSFT	Stock	223.94	224.92	223.73	224.82	2011236.0
2021-01-20 13:00:00	MSFT	Stock	224.83	225.16	224.22	224.61	2011575.0
2021-01-20 14:00:00	MSFT	Stock	224.61	224.848	224.14	224.738	1534998.0
2021-01-20 15:00:00	MSFT	Stock	224.735	225.79	224.18	224.18	5467917.0
2021-01-20 16:00:00	MSFT	Stock	224.34	224.79	224.2	224.5	4730495.0
2021-01-20 17:00:00	MSFT	Stock	224.38	224.7	224.38	224.47	4356.0
2021-01-20 18:00:00	MSFT	Stock	224.44	224.86	224.41	224.6	10139.0
2021-01-20 19:00:00	MSFT	Stock	224.6	225.48	224.4	225.48	11060.0
2021-01-20 06:00:00	NVDA	Stock	13.111	13.127	13.1102	13.125	116080.0
2021-01-20 07:00:00	NVDA	Stock	13.11	13.1125	13.0948	13.1125	249240.0
2021-01-20 08:00:00	NVDA	Stock	13.0988	13.145	13.0863	13.145	484320.0
2021-01-20 09:00:00	NVDA	Stock	13.1425	13.3312	13.0568	13.2625	31753560.0
2021-01-20 10:00:00	NVDA	Stock	13.264	13.3515	13.2188	13.2945	29256800.0
2021-01-20 11:00:00	NVDA	Stock	13.2939	13.3122	13.205	13.2715	15508120.0
2021-01-20 12:00:00	NVDA	Stock	13.275	13.3532	13.2675	13.3266	37546240.0
2021-01-20 13:00:00	NVDA	Stock	13.3285	13.3502	13.3	13.3145	12322600.0
2021-01-20 14:00:00	NVDA	Stock	13.313	13.3698	13.2962	13.3595	13636520.0
2021-01-20 15:00:00	NVDA	Stock	13.3615	13.4305	13.3385	13.363	38675400.0
2021-01-20 16:00:00	NVDA	Stock	13.3658	13.3658	13.3535	13.3635	23501840.0
2021-01-20 17:00:00	NVDA	Stock	13.357	13.3748	13.357	13.3748	95880.0
2021-01-20 18:00:00	NVDA	Stock	13.3675	13.3825	13.3675	13.3825	62400.0
2021-01-20 19:00:00	NVDA	Stock	13.3878	13.42	13.3825	13.3888	114480.0
2021-01-20 05:00:00	AMZN	Stock	157.2505	157.2505	157.2505	157.2505	3020.0
2021-01-20 06:00:00	AMZN	Stock	157.4	157.8	157.4	157.7485	61340.0
2021-01-20 07:00:00	AMZN	Stock	157.7	157.85	157.5	157.85	85340.0
2021-01-20 08:00:00	AMZN	Stock	157.6223	158.2235	157.4575	158.2	386580.0

> showing 50 of 66,284 rows — these rows as CSV

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