PREVIEW / stock_1hour / 2019-10-21

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-10-21.parquet
  size:    1.1 MB
  rows:    49,331
  symbols: 2,492

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-21 04:00:00	AAPL	Stock	59.31	59.3875	59.31	59.375	45060.0
2019-10-21 05:00:00	AAPL	Stock	59.3625	59.3775	59.3625	59.3775	10408.0
2019-10-21 06:00:00	AAPL	Stock	59.3675	59.4225	59.3675	59.4	13212.0
2019-10-21 07:00:00	AAPL	Stock	59.3525	59.4375	59.2875	59.4375	190832.0
2019-10-21 08:00:00	AAPL	Stock	59.35	59.525	59.2778	59.4075	788860.0
2019-10-21 09:00:00	AAPL	Stock	59.4125	60.0	59.33	59.925	16363344.0
2019-10-21 10:00:00	AAPL	Stock	59.9178	60.0	59.775	59.98	11037448.0
2019-10-21 11:00:00	AAPL	Stock	59.98	60.22	59.96	60.1825	12460036.0
2019-10-21 12:00:00	AAPL	Stock	60.1825	60.2475	60.1325	60.145	6000152.0
2019-10-21 13:00:00	AAPL	Stock	60.1525	60.235	60.1125	60.2	4283420.0
2019-10-21 14:00:00	AAPL	Stock	60.2025	60.2325	60.1292	60.1725	3664928.0
2019-10-21 15:00:00	AAPL	Stock	60.1745	60.1875	60.015	60.1325	10145612.0
2019-10-21 16:00:00	AAPL	Stock	60.1275	60.15	60.0072	60.125	9206440.0
2019-10-21 17:00:00	AAPL	Stock	60.125	60.165	60.125	60.165	47464.0
2019-10-21 18:00:00	AAPL	Stock	60.1575	60.1625	60.1125	60.1375	23384.0
2019-10-21 19:00:00	AAPL	Stock	60.1375	60.175	60.1075	60.1725	57832.0
2019-10-21 04:00:00	MSFT	Stock	138.13	138.45	138.13	138.3	4025.0
2019-10-21 05:00:00	MSFT	Stock	138.2	138.93	138.2	138.93	6380.0
2019-10-21 06:00:00	MSFT	Stock	138.88	138.89	138.41	138.55	1645.0
2019-10-21 07:00:00	MSFT	Stock	138.5	138.6	138.31	138.51	21729.0
2019-10-21 08:00:00	MSFT	Stock	138.41	138.64	137.75	138.29	129290.0
2019-10-21 09:00:00	MSFT	Stock	138.29	138.54	137.105	137.41	2850643.0
2019-10-21 10:00:00	MSFT	Stock	137.38	138.11	137.01	137.92	2636055.0
2019-10-21 11:00:00	MSFT	Stock	137.92	138.0	137.314	137.465	1791586.0
2019-10-21 12:00:00	MSFT	Stock	137.465	137.96	137.394	137.9	1504253.0
2019-10-21 13:00:00	MSFT	Stock	137.9	138.07	137.86	138.015	1226445.0
2019-10-21 14:00:00	MSFT	Stock	138.015	138.16	138.01	138.11	973053.0
2019-10-21 15:00:00	MSFT	Stock	138.11	138.5	138.075	138.43	2851821.0
2019-10-21 16:00:00	MSFT	Stock	138.43	138.52	137.97	138.48	3788264.0
2019-10-21 17:00:00	MSFT	Stock	138.5	138.6	138.5	138.6	13743.0
2019-10-21 18:00:00	MSFT	Stock	138.54	138.63	138.53	138.56	4158.0
2019-10-21 19:00:00	MSFT	Stock	138.57	138.71	138.57	138.66	13786.0
2019-10-21 04:00:00	NVDA	Stock	4.7685	4.8	4.7685	4.7998	17360.0
2019-10-21 06:00:00	NVDA	Stock	4.8118	4.812	4.7962	4.7962	20000.0
2019-10-21 07:00:00	NVDA	Stock	4.7925	4.798	4.7762	4.795	210640.0
2019-10-21 08:00:00	NVDA	Stock	4.7958	4.8358	4.7875	4.8308	1305280.0
2019-10-21 09:00:00	NVDA	Stock	4.832	4.8775	4.8215	4.8253	44383640.0
2019-10-21 10:00:00	NVDA	Stock	4.8255	4.872	4.805	4.87	44303640.0
2019-10-21 11:00:00	NVDA	Stock	4.8705	4.9138	4.8695	4.885	46236080.0
2019-10-21 12:00:00	NVDA	Stock	4.8855	4.905	4.8788	4.8885	16172680.0
2019-10-21 13:00:00	NVDA	Stock	4.89	4.9032	4.882	4.8885	10151480.0
2019-10-21 14:00:00	NVDA	Stock	4.8895	4.8964	4.8705	4.8822	15683160.0
2019-10-21 15:00:00	NVDA	Stock	4.8825	4.905	4.8792	4.9008	41356640.0
2019-10-21 16:00:00	NVDA	Stock	4.9002	4.9048	4.8978	4.9048	13796200.0
2019-10-21 17:00:00	NVDA	Stock	4.9045	4.9045	4.902	4.902	99800.0
2019-10-21 18:00:00	NVDA	Stock	4.9025	4.909	4.9002	4.9045	178560.0
2019-10-21 19:00:00	NVDA	Stock	4.9042	4.915	4.9042	4.915	286640.0
2019-10-21 04:00:00	AMZN	Stock	88.2	88.225	88.2	88.225	11300.0
2019-10-21 05:00:00	AMZN	Stock	88.249	88.3625	88.249	88.3625	11580.0
2019-10-21 07:00:00	AMZN	Stock	88.3	88.339	88.203	88.25	108460.0

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

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