PREVIEW / stock_1hour / 2021-09-13

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-09-13.parquet
  size:    1.4 MB
  rows:    64,938
  symbols: 2,722

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-09-13 04:00:00	AAPL	Stock	149.7	150.23	149.67	149.92	78367.0
2021-09-13 05:00:00	AAPL	Stock	149.92	150.25	149.91	150.22	31156.0
2021-09-13 06:00:00	AAPL	Stock	150.25	150.55	150.2	150.4	33667.0
2021-09-13 07:00:00	AAPL	Stock	150.4	150.5	149.92	150.29	331236.0
2021-09-13 08:00:00	AAPL	Stock	150.4	150.88	149.9101	150.5	690453.0
2021-09-13 09:00:00	AAPL	Stock	150.5	151.42	149.7	149.87	16820127.0
2021-09-13 10:00:00	AAPL	Stock	149.86	150.245	149.05	150.059	14895467.0
2021-09-13 11:00:00	AAPL	Stock	150.06	150.405	149.45	149.49	8910849.0
2021-09-13 12:00:00	AAPL	Stock	149.49	150.1099	149.39	150.03	6644411.0
2021-09-13 13:00:00	AAPL	Stock	150.025	150.12	148.82	148.96	7804019.0
2021-09-13 14:00:00	AAPL	Stock	148.97	149.29	148.75	149.2715	7046281.0
2021-09-13 15:00:00	AAPL	Stock	149.275	149.62	148.8945	149.62	11753100.0
2021-09-13 16:00:00	AAPL	Stock	149.6	149.76	148.9	149.75	9925078.0
2021-09-13 17:00:00	AAPL	Stock	149.75	149.76	149.71	149.74	59499.0
2021-09-13 18:00:00	AAPL	Stock	149.72	149.74	149.54	149.56	62230.0
2021-09-13 19:00:00	AAPL	Stock	149.62	149.68	149.47	149.53	66179.0
2021-09-13 04:00:00	MSFT	Stock	293.0	296.52	293.0	296.33	3431.0
2021-09-13 05:00:00	MSFT	Stock	297.17	297.17	296.7	296.8	450.0
2021-09-13 06:00:00	MSFT	Stock	296.66	297.1	296.66	297.0	2005.0
2021-09-13 07:00:00	MSFT	Stock	296.82	297.04	296.7	297.04	6304.0
2021-09-13 08:00:00	MSFT	Stock	296.9907	297.47	296.449	297.39	34621.0
2021-09-13 09:00:00	MSFT	Stock	297.43	298.54	296.25	297.0401	1969156.0
2021-09-13 10:00:00	MSFT	Stock	297.04	297.1173	294.27	295.61	2434263.0
2021-09-13 11:00:00	MSFT	Stock	295.61	296.0	294.1109	294.48	1566502.0
2021-09-13 12:00:00	MSFT	Stock	294.48	296.18	294.08	296.03	1079363.0
2021-09-13 13:00:00	MSFT	Stock	296.03	296.38	295.74	295.88	1315315.0
2021-09-13 14:00:00	MSFT	Stock	295.87	296.05	295.03	295.5	1382169.0
2021-09-13 15:00:00	MSFT	Stock	295.48	297.21	295.08	297.02	2586188.0
2021-09-13 16:00:00	MSFT	Stock	297.06	297.3501	296.8	297.35	4213429.0
2021-09-13 17:00:00	MSFT	Stock	297.3	297.3875	297.13	297.27	3344.0
2021-09-13 18:00:00	MSFT	Stock	297.15	297.24	297.15	297.16	4954.0
2021-09-13 19:00:00	MSFT	Stock	297.2	297.2	297.0201	297.0201	2520.0
2021-09-13 04:00:00	NVDA	Stock	22.465	22.6	22.465	22.6	30910.0
2021-09-13 05:00:00	NVDA	Stock	22.58	22.58	22.58	22.58	1000.0
2021-09-13 06:00:00	NVDA	Stock	22.6	22.681	22.6	22.681	45680.0
2021-09-13 07:00:00	NVDA	Stock	22.645	22.679	22.63	22.677	174740.0
2021-09-13 08:00:00	NVDA	Stock	22.66	22.724	22.625	22.668	669710.0
2021-09-13 09:00:00	NVDA	Stock	22.67	22.964	22.189	22.2135	38427970.0
2021-09-13 10:00:00	NVDA	Stock	22.216	22.223	21.924	22.089	46603770.0
2021-09-13 11:00:00	NVDA	Stock	22.089	22.109	21.858	21.9216	30265170.0
2021-09-13 12:00:00	NVDA	Stock	21.927	22.058	21.899	22.0565	18362640.0
2021-09-13 13:00:00	NVDA	Stock	22.055	22.09	21.915	21.938	14557000.0
2021-09-13 14:00:00	NVDA	Stock	21.942	22.002	21.876	21.9475	19101870.0
2021-09-13 15:00:00	NVDA	Stock	21.944	22.173	21.86	22.155	33542700.0
2021-09-13 16:00:00	NVDA	Stock	22.152	22.189	22.098	22.1341	22142660.0
2021-09-13 17:00:00	NVDA	Stock	22.14	22.148	22.12	22.129	50850.0
2021-09-13 18:00:00	NVDA	Stock	22.122	22.147	22.112	22.147	198420.0
2021-09-13 19:00:00	NVDA	Stock	22.136	22.15	22.131	22.145	95230.0
2021-09-13 04:00:00	AMZN	Stock	173.7	173.7	173.6	173.6	4000.0
2021-09-13 07:00:00	AMZN	Stock	174.0355	174.15	173.76	174.125	77160.0

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

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