PREVIEW / stock_1hour / 2020-04-22

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-04-22.parquet
  size:    1.2 MB
  rows:    53,178
  symbols: 2,377

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-22 04:00:00	AAPL	Stock	67.995	68.31	67.8725	68.1575	43104.0
2020-04-22 05:00:00	AAPL	Stock	68.325	68.475	68.28	68.4	7864.0
2020-04-22 06:00:00	AAPL	Stock	68.4	68.4	68.125	68.225	90652.0
2020-04-22 07:00:00	AAPL	Stock	68.18	68.325	68.025	68.18	160496.0
2020-04-22 08:00:00	AAPL	Stock	68.18	68.435	67.95	68.4325	772772.0
2020-04-22 09:00:00	AAPL	Stock	68.4	68.72	68.1075	68.415	14497140.0
2020-04-22 10:00:00	AAPL	Stock	68.42	68.6	68.15	68.1725	13075560.0
2020-04-22 11:00:00	AAPL	Stock	68.18	68.5075	68.05	68.4	8998316.0
2020-04-22 12:00:00	AAPL	Stock	68.405	68.73	68.4025	68.5425	8751556.0
2020-04-22 13:00:00	AAPL	Stock	68.5475	68.975	68.5075	68.935	7463432.0
2020-04-22 14:00:00	AAPL	Stock	68.9412	69.395	68.7875	69.3475	10470408.0
2020-04-22 15:00:00	AAPL	Stock	69.3475	69.475	68.9275	69.025	21174504.0
2020-04-22 16:00:00	AAPL	Stock	69.025	69.025	68.86	68.9	11058944.0
2020-04-22 17:00:00	AAPL	Stock	68.9	69.025	68.9	69.0225	305536.0
2020-04-22 18:00:00	AAPL	Stock	69.0	69.025	68.625	68.6275	64636.0
2020-04-22 19:00:00	AAPL	Stock	68.6575	68.6575	68.505	68.5625	98020.0
2020-04-22 04:00:00	MSFT	Stock	170.57	171.15	170.35	171.15	5670.0
2020-04-22 05:00:00	MSFT	Stock	171.35	171.88	171.35	171.51	7660.0
2020-04-22 06:00:00	MSFT	Stock	171.6	171.6	171.1	171.26	9192.0
2020-04-22 07:00:00	MSFT	Stock	171.1	171.19	170.4	170.9	58871.0
2020-04-22 08:00:00	MSFT	Stock	170.8	171.63	168.23	171.55	112429.0
2020-04-22 09:00:00	MSFT	Stock	171.49	172.49	170.82	171.766	4376457.0
2020-04-22 10:00:00	MSFT	Stock	171.78	172.2	171.02	171.56	3979289.0
2020-04-22 11:00:00	MSFT	Stock	171.57	172.55	171.32	172.095	3281208.0
2020-04-22 12:00:00	MSFT	Stock	172.09	172.55	171.83	172.21	2616660.0
2020-04-22 13:00:00	MSFT	Stock	172.21	173.27	171.96	173.185	2124114.0
2020-04-22 14:00:00	MSFT	Stock	173.18	173.6	173.01	173.44	2416694.0
2020-04-22 15:00:00	MSFT	Stock	173.46	174.0	172.88	173.52	6037884.0
2020-04-22 16:00:00	MSFT	Stock	173.52	173.73	172.9	173.66	5051257.0
2020-04-22 17:00:00	MSFT	Stock	173.64	173.64	173.42	173.54	23915.0
2020-04-22 18:00:00	MSFT	Stock	173.52	173.52	173.0	173.1	16366.0
2020-04-22 19:00:00	MSFT	Stock	173.1	173.18	172.8	172.86	14558.0
2020-04-22 04:00:00	NVDA	Stock	6.85	6.875	6.85	6.875	32000.0
2020-04-22 05:00:00	NVDA	Stock	6.8985	6.9	6.8662	6.8812	60720.0
2020-04-22 06:00:00	NVDA	Stock	6.8645	6.8645	6.8425	6.8425	50600.0
2020-04-22 07:00:00	NVDA	Stock	6.858	6.8672	6.8375	6.8672	1040280.0
2020-04-22 08:00:00	NVDA	Stock	6.841	6.8968	6.84	6.8965	2837040.0
2020-04-22 09:00:00	NVDA	Stock	6.8975	7.0938	6.8825	7.074	94704680.0
2020-04-22 10:00:00	NVDA	Stock	7.0748	7.0982	7.0198	7.0536	63915480.0
2020-04-22 11:00:00	NVDA	Stock	7.0562	7.085	7.0032	7.075	41423120.0
2020-04-22 12:00:00	NVDA	Stock	7.075	7.1055	7.0564	7.0698	35016200.0
2020-04-22 13:00:00	NVDA	Stock	7.072	7.139	7.0468	7.1373	29334480.0
2020-04-22 14:00:00	NVDA	Stock	7.1373	7.1918	7.1182	7.1872	43889120.0
2020-04-22 15:00:00	NVDA	Stock	7.1875	7.1968	7.1468	7.15	67928040.0
2020-04-22 16:00:00	NVDA	Stock	7.1538	7.1538	7.1025	7.125	16634600.0
2020-04-22 17:00:00	NVDA	Stock	7.1538	7.1538	7.1125	7.1182	275480.0
2020-04-22 18:00:00	NVDA	Stock	7.125	7.1472	7.1162	7.128	521000.0
2020-04-22 19:00:00	NVDA	Stock	7.1288	7.1445	7.1025	7.1225	719880.0
2020-04-22 04:00:00	AMZN	Stock	118.5	118.55	118.4	118.55	38980.0
2020-04-22 05:00:00	AMZN	Stock	118.7195	118.7195	118.55	118.6	8140.0

> showing 50 of 53,178 rows — these rows as CSV

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