PREVIEW / stock_1hour / 2021-11-19

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-11-19.parquet
  size:    1.5 MB
  rows:    67,248
  symbols: 2,701

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-11-19 04:00:00	AAPL	Stock	158.5	158.62	158.02	158.1	62872.0
2021-11-19 05:00:00	AAPL	Stock	158.03	158.03	157.5	157.87	53524.0
2021-11-19 06:00:00	AAPL	Stock	157.91	157.91	157.38	157.48	50729.0
2021-11-19 07:00:00	AAPL	Stock	157.58	157.7	157.27	157.43	331855.0
2021-11-19 08:00:00	AAPL	Stock	157.4	157.7	156.804	157.13	725033.0
2021-11-19 09:00:00	AAPL	Stock	157.15	159.02	156.5328	158.945	18564851.0
2021-11-19 10:00:00	AAPL	Stock	158.945	159.19	158.07	158.985	13499603.0
2021-11-19 11:00:00	AAPL	Stock	158.99	160.17	158.86	159.87	15556960.0
2021-11-19 12:00:00	AAPL	Stock	159.86	160.35	159.69	160.2866	9357789.0
2021-11-19 13:00:00	AAPL	Stock	160.285	160.72	159.77	160.69	10721815.0
2021-11-19 14:00:00	AAPL	Stock	160.7	160.84	160.3	160.515	9047798.0
2021-11-19 15:00:00	AAPL	Stock	160.515	161.02	160.1	160.56	16135143.0
2021-11-19 16:00:00	AAPL	Stock	160.57	160.86	160.52	160.75	7272899.0
2021-11-19 17:00:00	AAPL	Stock	160.72	161.0	160.55	160.92	229284.0
2021-11-19 18:00:00	AAPL	Stock	160.9201	160.99	160.72	160.84	44551.0
2021-11-19 19:00:00	AAPL	Stock	160.8	161.0	160.71	160.99	64143.0
2021-11-19 04:00:00	MSFT	Stock	342.59	343.05	342.53	342.82	6197.0
2021-11-19 05:00:00	MSFT	Stock	342.71	343.49	341.98	343.48	4870.0
2021-11-19 06:00:00	MSFT	Stock	343.24	343.24	342.8	343.14	8528.0
2021-11-19 07:00:00	MSFT	Stock	343.24	344.0	343.21	344.0	20394.0
2021-11-19 08:00:00	MSFT	Stock	342.999	344.2093	341.27	342.12	282477.0
2021-11-19 09:00:00	MSFT	Stock	342.13	344.4026	341.52	344.31	3444138.0
2021-11-19 10:00:00	MSFT	Stock	344.35	345.1	342.635	342.77	2437777.0
2021-11-19 11:00:00	MSFT	Stock	342.73	344.03	342.68	343.43	1317239.0
2021-11-19 12:00:00	MSFT	Stock	343.44	344.2399	343.2	343.45	1013404.0
2021-11-19 13:00:00	MSFT	Stock	343.43	343.98	342.66	343.25	1073298.0
2021-11-19 14:00:00	MSFT	Stock	343.24	343.41	342.85	342.932	809229.0
2021-11-19 15:00:00	MSFT	Stock	342.92	343.69	342.82	343.04	2236714.0
2021-11-19 16:00:00	MSFT	Stock	343.11	343.49	342.85	343.11	3869581.0
2021-11-19 17:00:00	MSFT	Stock	343.11	343.41	343.11	343.37	30344.0
2021-11-19 18:00:00	MSFT	Stock	343.25	343.35	343.2	343.22	3880.0
2021-11-19 19:00:00	MSFT	Stock	343.22	343.55	343.22	343.55	9706.0
2021-11-19 04:00:00	NVDA	Stock	32.093	32.532	32.091	32.339	586270.0
2021-11-19 05:00:00	NVDA	Stock	32.301	32.436	32.2	32.35	211490.0
2021-11-19 06:00:00	NVDA	Stock	32.35	32.357	32.065	32.291	159830.0
2021-11-19 07:00:00	NVDA	Stock	32.243	32.3	32.015	32.054	1022090.0
2021-11-19 08:00:00	NVDA	Stock	32.1058	32.3	31.915	32.25	2669750.0
2021-11-19 09:00:00	NVDA	Stock	32.2592	32.737	31.905	32.59	76615120.0
2021-11-19 10:00:00	NVDA	Stock	32.596	32.785	32.38	32.5	70127300.0
2021-11-19 11:00:00	NVDA	Stock	32.491	32.928	32.252	32.843	63274680.0
2021-11-19 12:00:00	NVDA	Stock	32.842	33.0	32.721	32.848	50161170.0
2021-11-19 13:00:00	NVDA	Stock	32.852	32.9739	32.583	32.8875	33672100.0
2021-11-19 14:00:00	NVDA	Stock	32.887	32.985	32.799	32.878	31929200.0
2021-11-19 15:00:00	NVDA	Stock	32.881	33.088	32.841	33.0	55784150.0
2021-11-19 16:00:00	NVDA	Stock	33.0	33.066	32.985	33.002	15503670.0
2021-11-19 17:00:00	NVDA	Stock	33.002	33.179	32.985	33.179	2071040.0
2021-11-19 18:00:00	NVDA	Stock	33.165	33.285	32.97	32.97	1168880.0
2021-11-19 19:00:00	NVDA	Stock	32.96	33.28	32.952	33.223	711620.0
2021-11-19 04:00:00	AMZN	Stock	185.724	185.724	185.1	185.1	26380.0
2021-11-19 05:00:00	AMZN	Stock	185.2325	185.2325	185.1	185.1485	17040.0

> showing 50 of 67,248 rows — these rows as CSV

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