PREVIEW / stock_1hour / 2021-05-03

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-05-03.parquet
  size:    1.4 MB
  rows:    66,221
  symbols: 3,005

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-05-03 04:00:00	AAPL	Stock	131.9	132.3	131.75	131.86	48819.0
2021-05-03 05:00:00	AAPL	Stock	131.85	131.97	131.5	131.65	17182.0
2021-05-03 06:00:00	AAPL	Stock	131.68	132.13	131.67	131.67	24192.0
2021-05-03 07:00:00	AAPL	Stock	131.74	132.23	131.66	132.04	200946.0
2021-05-03 08:00:00	AAPL	Stock	131.85	132.19	131.82	132.16	415150.0
2021-05-03 09:00:00	AAPL	Stock	132.16	133.355	131.83	133.2054	10076705.0
2021-05-03 10:00:00	AAPL	Stock	133.2	134.07	132.63	132.77	15259832.0
2021-05-03 11:00:00	AAPL	Stock	132.775	132.9599	132.14	132.815	9029915.0
2021-05-03 12:00:00	AAPL	Stock	132.815	132.92	132.31	132.45	5607537.0
2021-05-03 13:00:00	AAPL	Stock	132.45	132.61	132.21	132.4612	5656639.0
2021-05-03 14:00:00	AAPL	Stock	132.46	132.96	132.4501	132.835	5797858.0
2021-05-03 15:00:00	AAPL	Stock	132.84	132.98	132.3949	132.55	8563771.0
2021-05-03 16:00:00	AAPL	Stock	132.54	132.54	132.35	132.42	5432331.0
2021-05-03 17:00:00	AAPL	Stock	132.42	132.43	132.3	132.33	61650.0
2021-05-03 18:00:00	AAPL	Stock	132.35	132.4	132.33	132.37	34539.0
2021-05-03 19:00:00	AAPL	Stock	132.32	132.35	132.25	132.33	53204.0
2021-05-03 04:00:00	MSFT	Stock	253.02	253.1	252.4	252.48	4063.0
2021-05-03 05:00:00	MSFT	Stock	252.44	252.6	252.2	252.2	2046.0
2021-05-03 06:00:00	MSFT	Stock	252.68	253.1	252.68	253.0	3078.0
2021-05-03 07:00:00	MSFT	Stock	252.97	253.01	252.53	252.79	12662.0
2021-05-03 08:00:00	MSFT	Stock	252.75	253.06	252.5281	252.81	34802.0
2021-05-03 09:00:00	MSFT	Stock	252.88	253.69	251.8	253.18	1891398.0
2021-05-03 10:00:00	MSFT	Stock	253.18	254.35	252.57	252.69	2880143.0
2021-05-03 11:00:00	MSFT	Stock	252.685	252.8922	251.8	252.69	1673952.0
2021-05-03 12:00:00	MSFT	Stock	252.68	252.7	251.83	252.04	1111856.0
2021-05-03 13:00:00	MSFT	Stock	252.07	252.34	251.12	251.4499	1242111.0
2021-05-03 14:00:00	MSFT	Stock	251.445	251.84	251.32	251.5901	930214.0
2021-05-03 15:00:00	MSFT	Stock	251.61	252.0	251.32	251.8801	1957824.0
2021-05-03 16:00:00	MSFT	Stock	251.86	251.93	250.86	251.49	2294103.0
2021-05-03 17:00:00	MSFT	Stock	251.68	251.68	251.26	251.58	12997.0
2021-05-03 18:00:00	MSFT	Stock	251.4	251.86	251.4	251.53	180938.0
2021-05-03 19:00:00	MSFT	Stock	251.54	251.54	251.33	251.44	10145.0
2021-05-03 04:00:00	NVDA	Stock	15.0945	15.0945	15.0945	15.0945	19280.0
2021-05-03 05:00:00	NVDA	Stock	14.975	14.975	14.975	14.975	16000.0
2021-05-03 06:00:00	NVDA	Stock	15.0	15.05	15.0	15.05	14760.0
2021-05-03 07:00:00	NVDA	Stock	15.0375	15.0725	15.0372	15.0705	179440.0
2021-05-03 08:00:00	NVDA	Stock	15.0375	15.0992	15.0375	15.0812	457240.0
2021-05-03 09:00:00	NVDA	Stock	15.0825	15.2468	15.0025	15.0496	20342280.0
2021-05-03 10:00:00	NVDA	Stock	15.0472	15.1463	14.942	14.9506	21585800.0
2021-05-03 11:00:00	NVDA	Stock	14.95	14.9945	14.8285	14.8873	16520360.0
2021-05-03 12:00:00	NVDA	Stock	14.8868	14.8955	14.7918	14.822	9890200.0
2021-05-03 13:00:00	NVDA	Stock	14.8188	14.8578	14.7875	14.8285	7153920.0
2021-05-03 14:00:00	NVDA	Stock	14.8345	14.9402	14.8323	14.8882	11556240.0
2021-05-03 15:00:00	NVDA	Stock	14.8904	14.8928	14.7902	14.8345	22044360.0
2021-05-03 16:00:00	NVDA	Stock	14.8368	14.8438	14.8175	14.8175	13944480.0
2021-05-03 17:00:00	NVDA	Stock	14.8242	14.825	14.8138	14.814	103080.0
2021-05-03 18:00:00	NVDA	Stock	14.8242	14.825	14.815	14.815	22720.0
2021-05-03 19:00:00	NVDA	Stock	14.814	14.825	14.8008	14.8172	91360.0
2021-05-03 04:00:00	AMZN	Stock	174.0025	174.25	174.0025	174.25	4000.0
2021-05-03 05:00:00	AMZN	Stock	173.95	173.95	173.8	173.8	8780.0

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

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