PREVIEW / stock_1hour / 2021-04-08

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-04-08.parquet
  size:    1.4 MB
  rows:    65,337
  symbols: 2,943

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-04-08 04:00:00	AAPL	Stock	128.61	128.9	128.5	128.64	30067.0
2021-04-08 05:00:00	AAPL	Stock	128.64	128.98	128.5	128.87	25530.0
2021-04-08 06:00:00	AAPL	Stock	128.95	129.2	128.82	128.84	31850.0
2021-04-08 07:00:00	AAPL	Stock	128.84	129.04	128.62	128.9	236986.0
2021-04-08 08:00:00	AAPL	Stock	128.82	129.05	128.219	128.72	650857.0
2021-04-08 09:00:00	AAPL	Stock	128.73	130.0	128.52	129.9746	14704508.0
2021-04-08 10:00:00	AAPL	Stock	129.9709	130.07	129.02	129.243	14772101.0
2021-04-08 11:00:00	AAPL	Stock	129.25	129.665	129.0601	129.58	7463320.0
2021-04-08 12:00:00	AAPL	Stock	129.59	129.9	129.405	129.8198	7090130.0
2021-04-08 13:00:00	AAPL	Stock	129.815	130.27	129.7416	129.9473	8798727.0
2021-04-08 14:00:00	AAPL	Stock	129.95	130.39	129.915	130.2799	7099060.0
2021-04-08 15:00:00	AAPL	Stock	130.275	130.39	129.92	130.3772	11603487.0
2021-04-08 16:00:00	AAPL	Stock	130.36	130.65	130.34	130.65	5943714.0
2021-04-08 17:00:00	AAPL	Stock	130.66	130.72	130.62	130.7099	119159.0
2021-04-08 18:00:00	AAPL	Stock	130.68	130.71	130.56	130.61	113475.0
2021-04-08 19:00:00	AAPL	Stock	130.6	130.87	130.6	130.87	111480.0
2021-04-08 04:00:00	MSFT	Stock	252.0	252.39	251.38	251.38	2653.0
2021-04-08 05:00:00	MSFT	Stock	251.8	252.16	251.58	252.16	6517.0
2021-04-08 06:00:00	MSFT	Stock	252.32	252.6	252.15	252.5	7931.0
2021-04-08 07:00:00	MSFT	Stock	252.5	252.7	252.2	252.53	15334.0
2021-04-08 08:00:00	MSFT	Stock	252.3945	252.65	249.276	252.38	48494.0
2021-04-08 09:00:00	MSFT	Stock	252.11	254.139	251.94	253.92	3608513.0
2021-04-08 10:00:00	MSFT	Stock	253.93	253.97	252.66	252.85	2648250.0
2021-04-08 11:00:00	MSFT	Stock	252.87	253.19	252.123	252.93	1826399.0
2021-04-08 12:00:00	MSFT	Stock	252.9398	253.24	252.135	252.45	1726465.0
2021-04-08 13:00:00	MSFT	Stock	252.44	253.25	252.13	253.25	1147040.0
2021-04-08 14:00:00	MSFT	Stock	253.2307	253.46	253.03	253.12	1098673.0
2021-04-08 15:00:00	MSFT	Stock	253.12	253.47	252.84	253.25	2843671.0
2021-04-08 16:00:00	MSFT	Stock	253.25	253.99	253.1565	253.65	3305803.0
2021-04-08 17:00:00	MSFT	Stock	253.8	253.93	253.75	253.77	4942.0
2021-04-08 18:00:00	MSFT	Stock	253.83	253.9	253.33	253.5	5569.0
2021-04-08 19:00:00	MSFT	Stock	253.6	253.97	253.6	253.97	8228.0
2021-04-08 04:00:00	NVDA	Stock	14.25	14.25	14.25	14.25	6000.0
2021-04-08 05:00:00	NVDA	Stock	14.25	14.25	14.25	14.25	12000.0
2021-04-08 06:00:00	NVDA	Stock	14.2965	14.325	14.2945	14.325	49400.0
2021-04-08 07:00:00	NVDA	Stock	14.2935	14.3062	14.29	14.3	204120.0
2021-04-08 08:00:00	NVDA	Stock	14.2875	14.3238	14.1082	14.3158	369160.0
2021-04-08 09:00:00	NVDA	Stock	14.31	14.4575	14.2489	14.4347	34871520.0
2021-04-08 10:00:00	NVDA	Stock	14.4375	14.4715	14.2877	14.3375	31535560.0
2021-04-08 11:00:00	NVDA	Stock	14.3388	14.3985	14.3068	14.3492	12803800.0
2021-04-08 12:00:00	NVDA	Stock	14.3498	14.3667	14.2693	14.3068	14965720.0
2021-04-08 13:00:00	NVDA	Stock	14.3055	14.3245	14.2598	14.2818	8042120.0
2021-04-08 14:00:00	NVDA	Stock	14.2848	14.3673	14.284	14.36	10226240.0
2021-04-08 15:00:00	NVDA	Stock	14.3578	14.3685	14.2538	14.3228	22968800.0
2021-04-08 16:00:00	NVDA	Stock	14.317	14.36	14.317	14.35	16905120.0
2021-04-08 17:00:00	NVDA	Stock	14.3525	14.36	14.3525	14.36	66800.0
2021-04-08 18:00:00	NVDA	Stock	14.3502	14.3585	14.3502	14.3558	66840.0
2021-04-08 19:00:00	NVDA	Stock	14.3508	14.3678	14.3435	14.3675	196040.0
2021-04-08 04:00:00	AMZN	Stock	165.3	165.3	165.25	165.25	6520.0
2021-04-08 06:00:00	AMZN	Stock	165.5	165.5	165.5	165.5	3840.0

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

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