PREVIEW / stock_1hour / 2019-10-01

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-10-01.parquet
  size:    1.1 MB
  rows:    49,503
  symbols: 2,505

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
2019-10-01 04:00:00	AAPL	Stock	56.175	56.3375	56.175	56.3375	29636.0
2019-10-01 05:00:00	AAPL	Stock	56.29	56.295	56.2325	56.25	19296.0
2019-10-01 06:00:00	AAPL	Stock	56.25	56.3425	56.25	56.2775	25880.0
2019-10-01 07:00:00	AAPL	Stock	56.25	56.355	56.1725	56.3325	329492.0
2019-10-01 08:00:00	AAPL	Stock	56.3	56.3975	55.855	56.3125	638308.0
2019-10-01 09:00:00	AAPL	Stock	56.3125	57.055	56.175	57.0175	23594672.0
2019-10-01 10:00:00	AAPL	Stock	57.0125	57.02	56.4598	56.5475	25732268.0
2019-10-01 11:00:00	AAPL	Stock	56.545	56.915	56.49	56.5675	12100728.0
2019-10-01 12:00:00	AAPL	Stock	56.565	56.57	56.3275	56.3475	11787316.0
2019-10-01 13:00:00	AAPL	Stock	56.34	56.38	56.105	56.223	11713552.0
2019-10-01 14:00:00	AAPL	Stock	56.2212	56.435	56.1775	56.2875	7706680.0
2019-10-01 15:00:00	AAPL	Stock	56.2925	56.415	56.05	56.145	13543852.0
2019-10-01 16:00:00	AAPL	Stock	56.145	56.25	56.1	56.25	6209128.0
2019-10-01 17:00:00	AAPL	Stock	56.285	56.3	56.1825	56.2725	38456.0
2019-10-01 18:00:00	AAPL	Stock	56.225	56.325	56.195	56.3075	35796.0
2019-10-01 19:00:00	AAPL	Stock	56.325	56.325	56.25	56.2925	38436.0
2019-10-01 04:00:00	MSFT	Stock	139.5	139.79	139.5	139.79	800.0
2019-10-01 05:00:00	MSFT	Stock	139.77	139.77	139.75	139.75	739.0
2019-10-01 06:00:00	MSFT	Stock	139.55	139.63	139.55	139.56	969.0
2019-10-01 07:00:00	MSFT	Stock	139.52	139.57	139.4	139.5	9224.0
2019-10-01 08:00:00	MSFT	Stock	139.57	139.59	139.03	139.48	24213.0
2019-10-01 09:00:00	MSFT	Stock	139.48	140.25	139.46	139.83	2378623.0
2019-10-01 10:00:00	MSFT	Stock	139.81	139.95	138.34	138.73	3050280.0
2019-10-01 11:00:00	MSFT	Stock	138.73	138.84	138.21	138.34	1755807.0
2019-10-01 12:00:00	MSFT	Stock	138.335	138.34	137.57	137.85	1625179.0
2019-10-01 13:00:00	MSFT	Stock	137.84	137.89	137.3	137.367	1422673.0
2019-10-01 14:00:00	MSFT	Stock	137.365	137.85	137.22	137.671	1312406.0
2019-10-01 15:00:00	MSFT	Stock	137.67	137.85	137.0	137.06	3160542.0
2019-10-01 16:00:00	MSFT	Stock	137.06	137.19	136.86	137.07	2953654.0
2019-10-01 17:00:00	MSFT	Stock	137.13	137.2	137.07	137.2	4872.0
2019-10-01 18:00:00	MSFT	Stock	137.17	137.37	137.16	137.37	7362.0
2019-10-01 19:00:00	MSFT	Stock	137.5	137.5	137.25	137.25	3530.0
2019-10-01 04:00:00	NVDA	Stock	4.3875	4.3875	4.3875	4.3875	36000.0
2019-10-01 05:00:00	NVDA	Stock	4.354	4.354	4.354	4.354	14400.0
2019-10-01 06:00:00	NVDA	Stock	4.375	4.3788	4.375	4.3788	21600.0
2019-10-01 07:00:00	NVDA	Stock	4.3688	4.3742	4.3688	4.37	64600.0
2019-10-01 08:00:00	NVDA	Stock	4.3748	4.375	4.3675	4.375	215720.0
2019-10-01 09:00:00	NVDA	Stock	4.3738	4.525	4.365	4.5248	58616640.0
2019-10-01 10:00:00	NVDA	Stock	4.5228	4.5228	4.4255	4.4288	81789640.0
2019-10-01 11:00:00	NVDA	Stock	4.4268	4.456	4.4103	4.4216	34066560.0
2019-10-01 12:00:00	NVDA	Stock	4.422	4.4352	4.405	4.4197	19740760.0
2019-10-01 13:00:00	NVDA	Stock	4.4201	4.4225	4.3795	4.3825	19960120.0
2019-10-01 14:00:00	NVDA	Stock	4.3815	4.399	4.3675	4.3695	34255760.0
2019-10-01 15:00:00	NVDA	Stock	4.3712	4.372	4.3452	4.3485	44478000.0
2019-10-01 16:00:00	NVDA	Stock	4.35	4.375	4.347	4.355	11604400.0
2019-10-01 17:00:00	NVDA	Stock	4.3575	4.3575	4.355	4.355	39320.0
2019-10-01 18:00:00	NVDA	Stock	4.3545	4.36	4.3532	4.36	114000.0
2019-10-01 19:00:00	NVDA	Stock	4.3598	4.362	4.3562	4.361	232720.0
2019-10-01 04:00:00	AMZN	Stock	87.1115	87.15	87.1115	87.15	7340.0
2019-10-01 05:00:00	AMZN	Stock	87.15	87.15	87.093	87.093	5540.0

> showing 50 of 49,503 rows — these rows as CSV

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