PREVIEW / stock_1hour / 2020-04-24

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-04-24.parquet
  size:    1.2 MB
  rows:    52,880
  symbols: 2,369

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
2020-04-24 04:00:00	AAPL	Stock	68.2	68.3975	68.2	68.3975	10152.0
2020-04-24 05:00:00	AAPL	Stock	68.38	69.12	68.38	69.025	3188.0
2020-04-24 06:00:00	AAPL	Stock	68.8925	69.135	68.75	69.015	30600.0
2020-04-24 07:00:00	AAPL	Stock	68.9025	69.11	68.775	68.915	143776.0
2020-04-24 08:00:00	AAPL	Stock	69.075	69.3425	68.875	69.1925	355952.0
2020-04-24 09:00:00	AAPL	Stock	69.1607	69.8725	69.0	69.3625	14319932.0
2020-04-24 10:00:00	AAPL	Stock	69.3605	70.1225	69.3605	69.865	17324812.0
2020-04-24 11:00:00	AAPL	Stock	69.8625	69.88	69.5018	69.7125	10962644.0
2020-04-24 12:00:00	AAPL	Stock	69.7175	70.205	69.62	70.1175	11015100.0
2020-04-24 13:00:00	AAPL	Stock	70.1175	70.3425	70.06	70.3225	10395696.0
2020-04-24 14:00:00	AAPL	Stock	70.325	70.5	70.265	70.31	9708460.0
2020-04-24 15:00:00	AAPL	Stock	70.3025	70.7525	70.1525	70.7375	20683884.0
2020-04-24 16:00:00	AAPL	Stock	70.74	70.75	70.1903	70.745	8873896.0
2020-04-24 17:00:00	AAPL	Stock	70.7275	70.7425	70.5075	70.61	242752.0
2020-04-24 18:00:00	AAPL	Stock	70.6	70.6	70.5	70.515	95376.0
2020-04-24 19:00:00	AAPL	Stock	70.515	70.5875	70.45	70.475	214200.0
2020-04-24 04:00:00	MSFT	Stock	170.8	170.8	170.5	170.5	1972.0
2020-04-24 05:00:00	MSFT	Stock	171.04	172.51	171.04	172.48	2758.0
2020-04-24 06:00:00	MSFT	Stock	172.36	173.4	172.0	173.28	4309.0
2020-04-24 07:00:00	MSFT	Stock	172.3	173.48	172.25	172.31	24230.0
2020-04-24 08:00:00	MSFT	Stock	172.51	173.2	171.84	172.85	72905.0
2020-04-24 09:00:00	MSFT	Stock	172.75	172.89	170.81	170.96	2990132.0
2020-04-24 10:00:00	MSFT	Stock	170.95	172.215	170.71	171.559	3464460.0
2020-04-24 11:00:00	MSFT	Stock	171.555	172.18	171.0	172.12	2316980.0
2020-04-24 12:00:00	MSFT	Stock	172.14	173.67	171.86	173.45	4183499.0
2020-04-24 13:00:00	MSFT	Stock	173.445	173.48	172.04	173.197	3733689.0
2020-04-24 14:00:00	MSFT	Stock	173.16	173.385	172.65	173.022	2541471.0
2020-04-24 15:00:00	MSFT	Stock	173.01	174.56	172.81	174.54	6054699.0
2020-04-24 16:00:00	MSFT	Stock	174.54	174.55	174.09	174.25	4414525.0
2020-04-24 17:00:00	MSFT	Stock	174.26	174.54	174.1	174.31	29867.0
2020-04-24 18:00:00	MSFT	Stock	174.25	174.35	174.2	174.33	12348.0
2020-04-24 19:00:00	MSFT	Stock	174.33	174.55	174.3	174.5	12217.0
2020-04-24 04:00:00	NVDA	Stock	7.015	7.015	7.0088	7.0088	12800.0
2020-04-24 05:00:00	NVDA	Stock	7.015	7.0768	7.015	7.0768	162200.0
2020-04-24 06:00:00	NVDA	Stock	7.0738	7.0868	7.0498	7.0868	535640.0
2020-04-24 07:00:00	NVDA	Stock	7.0635	7.1	7.0568	7.0568	1035160.0
2020-04-24 08:00:00	NVDA	Stock	7.095	7.1125	7.0378	7.1	3688840.0
2020-04-24 09:00:00	NVDA	Stock	7.0942	7.1463	7.0255	7.0396	49721440.0
2020-04-24 10:00:00	NVDA	Stock	7.043	7.167	7.015	7.1165	50279680.0
2020-04-24 11:00:00	NVDA	Stock	7.118	7.1722	7.0809	7.1532	41891720.0
2020-04-24 12:00:00	NVDA	Stock	7.152	7.2069	7.1345	7.1765	31094440.0
2020-04-24 13:00:00	NVDA	Stock	7.1762	7.2181	7.1375	7.2158	24286720.0
2020-04-24 14:00:00	NVDA	Stock	7.2158	7.2375	7.1808	7.194	28286680.0
2020-04-24 15:00:00	NVDA	Stock	7.1912	7.2418	7.1745	7.2402	50688200.0
2020-04-24 16:00:00	NVDA	Stock	7.2398	7.2398	7.1383	7.23	22413840.0
2020-04-24 17:00:00	NVDA	Stock	7.23	7.2325	7.225	7.225	108200.0
2020-04-24 18:00:00	NVDA	Stock	7.225	7.2375	7.225	7.2375	135160.0
2020-04-24 19:00:00	NVDA	Stock	7.2375	7.2425	7.2272	7.2272	155520.0
2020-04-24 04:00:00	AMZN	Stock	119.45	119.45	119.45	119.45	2000.0
2020-04-24 06:00:00	AMZN	Stock	120.2475	120.35	120.15	120.35	16100.0

> showing 50 of 52,880 rows — these rows as CSV

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