PREVIEW / stock_1hour / 2021-03-26

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-03-26.parquet
  size:    1.4 MB
  rows:    66,090
  symbols: 2,928

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-03-26 04:00:00	AAPL	Stock	121.4	121.4	120.86	120.86	11183.0
2021-03-26 05:00:00	AAPL	Stock	120.86	120.95	120.5	120.95	16544.0
2021-03-26 06:00:00	AAPL	Stock	121.0	121.15	120.44	120.46	21856.0
2021-03-26 07:00:00	AAPL	Stock	120.61	120.67	120.05	120.42	294427.0
2021-03-26 08:00:00	AAPL	Stock	120.43	120.67	119.9	120.3	509607.0
2021-03-26 09:00:00	AAPL	Stock	120.32	121.08	120.01	120.14	8595963.0
2021-03-26 10:00:00	AAPL	Stock	120.15	120.76	119.81	120.14	12336584.0
2021-03-26 11:00:00	AAPL	Stock	120.15	120.45	119.48	120.44	9864931.0
2021-03-26 12:00:00	AAPL	Stock	120.45	120.73	120.03	120.45	7250159.0
2021-03-26 13:00:00	AAPL	Stock	120.45	120.68	119.82	119.9	6308046.0
2021-03-26 14:00:00	AAPL	Stock	119.9	120.14	118.92	119.587	13422499.0
2021-03-26 15:00:00	AAPL	Stock	119.59	121.48	119.58	121.21	16394161.0
2021-03-26 16:00:00	AAPL	Stock	121.21	121.5	121.0	121.24	8208780.0
2021-03-26 17:00:00	AAPL	Stock	121.23	121.23	121.01	121.06	78613.0
2021-03-26 18:00:00	AAPL	Stock	121.08	121.21	121.05	121.1	61140.0
2021-03-26 19:00:00	AAPL	Stock	121.09	121.18	121.05	121.1	61534.0
2021-03-26 04:00:00	MSFT	Stock	233.66	233.66	232.6	232.6	965.0
2021-03-26 05:00:00	MSFT	Stock	232.6	232.71	232.5	232.71	913.0
2021-03-26 06:00:00	MSFT	Stock	232.9	232.9	232.2	232.2	5841.0
2021-03-26 07:00:00	MSFT	Stock	232.5	232.6	231.16	231.95	16987.0
2021-03-26 08:00:00	MSFT	Stock	232.25	232.8	230.6	231.82	43632.0
2021-03-26 09:00:00	MSFT	Stock	232.25	233.94	231.35	233.08	1780982.0
2021-03-26 10:00:00	MSFT	Stock	233.08	234.15	232.43	233.81	1912446.0
2021-03-26 11:00:00	MSFT	Stock	233.81	234.99	232.77	234.99	1868564.0
2021-03-26 12:00:00	MSFT	Stock	234.99	235.18	234.01	234.8	1367271.0
2021-03-26 13:00:00	MSFT	Stock	234.8	235.44	234.42	234.55	1539550.0
2021-03-26 14:00:00	MSFT	Stock	234.55	234.8	233.03	233.7	2184312.0
2021-03-26 15:00:00	MSFT	Stock	233.7	236.71	233.56	236.48	3902049.0
2021-03-26 16:00:00	MSFT	Stock	236.48	236.71	235.86	236.0	5070085.0
2021-03-26 17:00:00	MSFT	Stock	236.2	236.51	234.35	236.2	28051.0
2021-03-26 18:00:00	MSFT	Stock	236.21	236.3	236.13	236.21	3399.0
2021-03-26 19:00:00	MSFT	Stock	236.13	236.29	236.03	236.03	4079.0
2021-03-26 05:00:00	NVDA	Stock	12.625	12.625	12.62	12.62	11240.0
2021-03-26 06:00:00	NVDA	Stock	12.6198	12.6198	12.6198	12.6198	6800.0
2021-03-26 07:00:00	NVDA	Stock	12.55	12.56	12.4873	12.5	119720.0
2021-03-26 08:00:00	NVDA	Stock	12.5055	12.5875	12.425	12.585	444320.0
2021-03-26 09:00:00	NVDA	Stock	12.575	12.673	12.48	12.5123	28798600.0
2021-03-26 10:00:00	NVDA	Stock	12.5115	12.62	12.4813	12.5	30352880.0
2021-03-26 11:00:00	NVDA	Stock	12.5003	12.5233	12.3735	12.5135	18472880.0
2021-03-26 12:00:00	NVDA	Stock	12.525	12.66	12.4785	12.572	27017600.0
2021-03-26 13:00:00	NVDA	Stock	12.5819	12.672	12.54	12.5848	22153680.0
2021-03-26 14:00:00	NVDA	Stock	12.5853	12.6155	12.4425	12.5735	23427360.0
2021-03-26 15:00:00	NVDA	Stock	12.574	12.8563	12.57	12.8458	53337400.0
2021-03-26 16:00:00	NVDA	Stock	12.8393	12.875	12.8038	12.8135	35214720.0
2021-03-26 17:00:00	NVDA	Stock	12.8256	12.8425	12.5752	12.81	289720.0
2021-03-26 18:00:00	NVDA	Stock	12.8	12.8375	12.8	12.825	127840.0
2021-03-26 19:00:00	NVDA	Stock	12.83	12.8338	12.82	12.8338	45960.0
2021-03-26 04:00:00	AMZN	Stock	153.0	153.0	153.0	153.0	2000.0
2021-03-26 05:00:00	AMZN	Stock	152.8895	152.8895	152.8895	152.8895	2000.0
2021-03-26 07:00:00	AMZN	Stock	152.7505	152.7505	151.95	152.1	61820.0

> showing 50 of 66,090 rows — these rows as CSV

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