PREVIEW / stock_1hour / 2021-09-17

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-09-17.parquet
  size:    1.4 MB
  rows:    64,166
  symbols: 2,716

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-09-17 04:00:00	AAPL	Stock	149.0	149.1	148.71	148.83	11191.0
2021-09-17 05:00:00	AAPL	Stock	148.84	148.84	148.24	148.29	5914.0
2021-09-17 06:00:00	AAPL	Stock	148.37	148.57	148.37	148.47	2694.0
2021-09-17 07:00:00	AAPL	Stock	148.51	148.6	148.37	148.52	29993.0
2021-09-17 08:00:00	AAPL	Stock	148.57	149.161	148.37	148.94	303076.0
2021-09-17 09:00:00	AAPL	Stock	148.9	149.3	146.95	147.24	21316192.0
2021-09-17 10:00:00	AAPL	Stock	147.29	147.355	146.55	146.76	14890451.0
2021-09-17 11:00:00	AAPL	Stock	146.76	146.97	146.18	146.4	9277613.0
2021-09-17 12:00:00	AAPL	Stock	146.4	146.96	146.37	146.7701	6090366.0
2021-09-17 13:00:00	AAPL	Stock	146.77	146.7801	145.875	146.12	7613737.0
2021-09-17 14:00:00	AAPL	Stock	146.12	146.28	145.76	146.1499	6719092.0
2021-09-17 15:00:00	AAPL	Stock	146.15	146.31	145.86	146.03	12719620.0
2021-09-17 16:00:00	AAPL	Stock	146.06	146.09	145.85	145.87	23054128.0
2021-09-17 17:00:00	AAPL	Stock	145.86	146.02	145.86	145.99	127988.0
2021-09-17 18:00:00	AAPL	Stock	146.0	146.0	145.75	145.85	79441.0
2021-09-17 19:00:00	AAPL	Stock	145.84	145.85	145.75	145.76	55596.0
2021-09-17 04:00:00	MSFT	Stock	305.25	305.45	305.18	305.45	667.0
2021-09-17 05:00:00	MSFT	Stock	305.4	305.6	304.51	304.55	2672.0
2021-09-17 06:00:00	MSFT	Stock	304.97	304.98	304.8	304.8	544.0
2021-09-17 07:00:00	MSFT	Stock	304.8	304.9	304.67	304.8	2724.0
2021-09-17 08:00:00	MSFT	Stock	304.8152	305.983	304.65	305.55	44543.0
2021-09-17 09:00:00	MSFT	Stock	305.24	305.95	301.819	302.36	6888975.0
2021-09-17 10:00:00	MSFT	Stock	302.33	302.42	300.72	301.1767	2981425.0
2021-09-17 11:00:00	MSFT	Stock	301.17	301.3144	299.86	300.37	2084149.0
2021-09-17 12:00:00	MSFT	Stock	300.37	301.3	300.27	300.79	1477802.0
2021-09-17 13:00:00	MSFT	Stock	300.8	300.81	299.587	300.06	1264968.0
2021-09-17 14:00:00	MSFT	Stock	300.0599	300.65	299.91	300.23	1308102.0
2021-09-17 15:00:00	MSFT	Stock	300.23	300.74	299.53	299.82	3222188.0
2021-09-17 16:00:00	MSFT	Stock	300.27	300.32	299.46	299.75	12502425.0
2021-09-17 17:00:00	MSFT	Stock	299.76	299.76	299.63	299.71	13686.0
2021-09-17 18:00:00	MSFT	Stock	299.71	299.71	299.4	299.56	8534.0
2021-09-17 19:00:00	MSFT	Stock	299.56	299.69	299.4	299.6	6886.0
2021-09-17 04:00:00	NVDA	Stock	22.188	22.188	22.188	22.188	1050.0
2021-09-17 05:00:00	NVDA	Stock	22.175	22.175	22.157	22.157	4000.0
2021-09-17 06:00:00	NVDA	Stock	22.126	22.194	22.126	22.186	35320.0
2021-09-17 07:00:00	NVDA	Stock	22.189	22.229	22.171	22.21	70480.0
2021-09-17 08:00:00	NVDA	Stock	22.2	22.335	22.175	22.335	550290.0
2021-09-17 09:00:00	NVDA	Stock	22.335	22.399	22.06	22.113	42078270.0
2021-09-17 10:00:00	NVDA	Stock	22.115	22.195	22.007	22.095	26063310.0
2021-09-17 11:00:00	NVDA	Stock	22.091	22.106	21.944	22.014	20562320.0
2021-09-17 12:00:00	NVDA	Stock	22.0126	22.138	22.012	22.075	12817030.0
2021-09-17 13:00:00	NVDA	Stock	22.076	22.09	21.945	21.9813	10414690.0
2021-09-17 14:00:00	NVDA	Stock	21.9825	22.0429	21.931	22.0308	10593360.0
2021-09-17 15:00:00	NVDA	Stock	22.035	22.108	21.83	21.893	34374420.0
2021-09-17 16:00:00	NVDA	Stock	21.9	21.918	21.855	21.87	69442840.0
2021-09-17 17:00:00	NVDA	Stock	21.88	21.88	21.87	21.878	106190.0
2021-09-17 18:00:00	NVDA	Stock	21.869	21.875	21.855	21.855	56620.0
2021-09-17 19:00:00	NVDA	Stock	21.855	21.878	21.85	21.85	198430.0
2021-09-17 05:00:00	AMZN	Stock	174.15	174.1505	174.15	174.1505	4000.0
2021-09-17 07:00:00	AMZN	Stock	174.1945	174.1945	174.15	174.15	10020.0

> showing 50 of 64,166 rows — these rows as CSV

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