PREVIEW / stock_1hour / 2021-12-13

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-12-13.parquet
  size:    1.4 MB
  rows:    65,911
  symbols: 2,641

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-12-13 04:00:00	AAPL	Stock	180.45	181.37	180.37	181.1	94056.0
2021-12-13 05:00:00	AAPL	Stock	181.1	181.42	180.99	181.4	40635.0
2021-12-13 06:00:00	AAPL	Stock	181.33	181.5	181.02	181.06	47750.0
2021-12-13 07:00:00	AAPL	Stock	181.07	181.98	181.04	181.8	466031.0
2021-12-13 08:00:00	AAPL	Stock	181.2	182.22	179.002	181.75	1038361.0
2021-12-13 09:00:00	AAPL	Stock	181.77	181.8293	179.76	180.95	18538404.0
2021-12-13 10:00:00	AAPL	Stock	180.94	182.13	178.16	179.7801	28638716.0
2021-12-13 11:00:00	AAPL	Stock	179.7925	180.0	177.11	177.8517	16365266.0
2021-12-13 12:00:00	AAPL	Stock	177.84	179.41	177.74	178.73	13471936.0
2021-12-13 13:00:00	AAPL	Stock	178.73	179.15	177.34	178.1696	9907538.0
2021-12-13 14:00:00	AAPL	Stock	178.16	178.779	177.79	178.65	8741628.0
2021-12-13 15:00:00	AAPL	Stock	178.645	178.86	175.53	175.81	20704459.0
2021-12-13 16:00:00	AAPL	Stock	175.81	175.85	175.4	175.74	12454612.0
2021-12-13 17:00:00	AAPL	Stock	175.74	175.8	175.07	175.17	145283.0
2021-12-13 18:00:00	AAPL	Stock	175.2	175.74	175.19	175.49	827007.0
2021-12-13 19:00:00	AAPL	Stock	175.49	175.71	175.43	175.69	73529.0
2021-12-13 04:00:00	MSFT	Stock	343.48	343.66	342.56	343.5	4452.0
2021-12-13 05:00:00	MSFT	Stock	343.53	343.74	343.36	343.53	4562.0
2021-12-13 06:00:00	MSFT	Stock	343.59	343.63	342.72	342.93	5738.0
2021-12-13 07:00:00	MSFT	Stock	342.94	343.25	342.6	342.8	26861.0
2021-12-13 08:00:00	MSFT	Stock	343.1199	343.17	342.6504	342.91	26518.0
2021-12-13 09:00:00	MSFT	Stock	342.8	342.8	339.8	341.56	2599146.0
2021-12-13 10:00:00	MSFT	Stock	341.53	343.79	340.8	341.75	2748585.0
2021-12-13 11:00:00	MSFT	Stock	341.73	342.16	340.58	341.095	1901419.0
2021-12-13 12:00:00	MSFT	Stock	341.095	341.76	340.4342	341.33	1135231.0
2021-12-13 13:00:00	MSFT	Stock	341.33	341.8211	340.53	341.3	1174637.0
2021-12-13 14:00:00	MSFT	Stock	341.29	342.11	341.11	342.09	1290662.0
2021-12-13 15:00:00	MSFT	Stock	342.0911	342.23	339.08	339.44	3668076.0
2021-12-13 16:00:00	MSFT	Stock	339.4	339.89	339.2	339.4	6652431.0
2021-12-13 17:00:00	MSFT	Stock	339.32	339.37	339.1	339.1	4998.0
2021-12-13 18:00:00	MSFT	Stock	339.1	339.65	339.1	339.4	344221.0
2021-12-13 19:00:00	MSFT	Stock	339.4	339.63	339.37	339.63	6459.0
2021-12-13 04:00:00	NVDA	Stock	30.576	31.0	30.481	30.619	158680.0
2021-12-13 05:00:00	NVDA	Stock	30.654	30.73	30.63	30.705	56480.0
2021-12-13 06:00:00	NVDA	Stock	30.715	30.722	30.58	30.62	58890.0
2021-12-13 07:00:00	NVDA	Stock	30.571	30.604	30.455	30.5	404620.0
2021-12-13 08:00:00	NVDA	Stock	30.475	30.5935	30.375	30.4	1141690.0
2021-12-13 09:00:00	NVDA	Stock	30.394	30.394	29.72	29.8615	48109070.0
2021-12-13 10:00:00	NVDA	Stock	29.865	29.9699	29.41	29.4872	63979890.0
2021-12-13 11:00:00	NVDA	Stock	29.485	29.5055	28.8	28.9135	71232370.0
2021-12-13 12:00:00	NVDA	Stock	28.916	29.342	28.851	29.0405	60217380.0
2021-12-13 13:00:00	NVDA	Stock	29.0402	29.239	28.9476	28.99	45144350.0
2021-12-13 14:00:00	NVDA	Stock	28.993	29.0349	28.803	28.8845	45677630.0
2021-12-13 15:00:00	NVDA	Stock	28.886	28.979	28.116	28.15	106275760.0
2021-12-13 16:00:00	NVDA	Stock	28.15	28.342	28.1	28.333	31201700.0
2021-12-13 17:00:00	NVDA	Stock	28.35	28.36	28.173	28.173	353320.0
2021-12-13 18:00:00	NVDA	Stock	28.19	28.297	28.161	28.284	1999480.0
2021-12-13 19:00:00	NVDA	Stock	28.281	28.288	28.18	28.25	318990.0
2021-12-13 05:00:00	AMZN	Stock	172.9995	172.9995	172.95	172.95	4000.0
2021-12-13 06:00:00	AMZN	Stock	173.0	173.05	173.0	173.05	9740.0

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

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