PREVIEW / stock_1hour / 2021-08-27

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-08-27.parquet
  size:    1.4 MB
  rows:    64,135
  symbols: 2,733

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-08-27 04:00:00	AAPL	Stock	148.13	148.39	147.69	148.11	17723.0
2021-08-27 05:00:00	AAPL	Stock	148.15	148.4	147.88	148.3	9290.0
2021-08-27 06:00:00	AAPL	Stock	148.29	148.32	148.18	148.27	6681.0
2021-08-27 07:00:00	AAPL	Stock	148.2	148.29	147.8	148.02	113568.0
2021-08-27 08:00:00	AAPL	Stock	148.0	148.23	147.172	147.91	261402.0
2021-08-27 09:00:00	AAPL	Stock	147.9	147.97	146.83	147.18	7137756.0
2021-08-27 10:00:00	AAPL	Stock	147.18	148.42	146.88	148.0175	10793105.0
2021-08-27 11:00:00	AAPL	Stock	148.02	148.52	147.77	148.51	6042101.0
2021-08-27 12:00:00	AAPL	Stock	148.515	148.635	148.15	148.41	4136801.0
2021-08-27 13:00:00	AAPL	Stock	148.4	148.75	148.3318	148.666	3524505.0
2021-08-27 14:00:00	AAPL	Stock	148.6631	148.74	148.5	148.545	3107927.0
2021-08-27 15:00:00	AAPL	Stock	148.545	148.67	148.39	148.6	6567724.0
2021-08-27 16:00:00	AAPL	Stock	148.6	148.67	148.43	148.48	5997917.0
2021-08-27 17:00:00	AAPL	Stock	148.46	148.49	148.41	148.48	34672.0
2021-08-27 18:00:00	AAPL	Stock	148.48	148.5	148.43	148.5	21720.0
2021-08-27 19:00:00	AAPL	Stock	148.52	148.52	148.4	148.48	27459.0
2021-08-27 04:00:00	MSFT	Stock	299.65	300.05	299.39	300.05	4814.0
2021-08-27 05:00:00	MSFT	Stock	300.09	300.3	300.0	300.3	1242.0
2021-08-27 06:00:00	MSFT	Stock	300.37	300.39	300.29	300.36	1230.0
2021-08-27 07:00:00	MSFT	Stock	300.41	300.68	299.98	300.16	18964.0
2021-08-27 08:00:00	MSFT	Stock	300.3802	300.7	299.837	300.2	20345.0
2021-08-27 09:00:00	MSFT	Stock	300.2	300.25	296.83	297.6184	2316503.0
2021-08-27 10:00:00	MSFT	Stock	297.65	300.87	297.31	299.59	3514078.0
2021-08-27 11:00:00	MSFT	Stock	299.58	299.86	298.72	299.7	1451692.0
2021-08-27 12:00:00	MSFT	Stock	299.71	299.78	299.12	299.42	925789.0
2021-08-27 13:00:00	MSFT	Stock	299.41	299.99	299.32	299.51	943496.0
2021-08-27 14:00:00	MSFT	Stock	299.51	299.5399	298.9702	299.16	1061059.0
2021-08-27 15:00:00	MSFT	Stock	299.1596	300.1416	299.105	299.65	2213792.0
2021-08-27 16:00:00	MSFT	Stock	299.7	299.8	299.5	299.51	2676183.0
2021-08-27 17:00:00	MSFT	Stock	299.7	299.7	299.62	299.7	432.0
2021-08-27 18:00:00	MSFT	Stock	299.69	299.69	299.53	299.53	2126.0
2021-08-27 19:00:00	MSFT	Stock	299.64	299.7	299.57	299.7	3523.0
2021-08-27 04:00:00	NVDA	Stock	22.0	22.088	21.99	22.088	17780.0
2021-08-27 05:00:00	NVDA	Stock	22.099	22.199	22.088	22.138	49200.0
2021-08-27 06:00:00	NVDA	Stock	22.164	22.164	22.12	22.12	45170.0
2021-08-27 07:00:00	NVDA	Stock	22.135	22.147	22.1	22.125	323730.0
2021-08-27 08:00:00	NVDA	Stock	22.13	22.247	22.0129	22.225	805930.0
2021-08-27 09:00:00	NVDA	Stock	22.225	22.573	22.167	22.304	40745080.0
2021-08-27 10:00:00	NVDA	Stock	22.306	22.5544	22.256	22.5099	49197630.0
2021-08-27 11:00:00	NVDA	Stock	22.5105	22.535	22.43	22.476	19887230.0
2021-08-27 12:00:00	NVDA	Stock	22.472	22.54	22.454	22.488	20662530.0
2021-08-27 13:00:00	NVDA	Stock	22.488	22.613	22.481	22.578	26425730.0
2021-08-27 14:00:00	NVDA	Stock	22.58	22.695	22.557	22.685	23173260.0
2021-08-27 15:00:00	NVDA	Stock	22.687	22.722	22.61	22.637	37806930.0
2021-08-27 16:00:00	NVDA	Stock	22.637	22.641	22.534	22.55	14581540.0
2021-08-27 17:00:00	NVDA	Stock	22.563	22.563	22.536	22.536	175680.0
2021-08-27 18:00:00	NVDA	Stock	22.536	22.577	22.536	22.561	186670.0
2021-08-27 19:00:00	NVDA	Stock	22.571	22.588	22.54	22.588	147350.0
2021-08-27 07:00:00	AMZN	Stock	166.0025	166.105	166.0025	166.105	11840.0
2021-08-27 08:00:00	AMZN	Stock	165.95	166.6	165.8	166.45	45320.0

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

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