PREVIEW / stock_1hour / 2021-05-07

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-05-07.parquet
  size:    1.4 MB
  rows:    65,129
  symbols: 2,997

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-07 04:00:00	AAPL	Stock	129.93	129.93	129.38	129.71	19559.0
2021-05-07 05:00:00	AAPL	Stock	129.72	129.9	129.72	129.76	5300.0
2021-05-07 06:00:00	AAPL	Stock	129.9	130.05	129.86	129.96	15776.0
2021-05-07 07:00:00	AAPL	Stock	129.99	130.07	129.9	129.96	85718.0
2021-05-07 08:00:00	AAPL	Stock	130.05	132.0	129.81	131.29	1253387.0
2021-05-07 09:00:00	AAPL	Stock	131.25	131.6	129.475	130.14	11004150.0
2021-05-07 10:00:00	AAPL	Stock	130.14	130.97	129.98	130.56	11787226.0
2021-05-07 11:00:00	AAPL	Stock	130.56	131.2582	130.47	131.12	8207914.0
2021-05-07 12:00:00	AAPL	Stock	131.1201	131.15	130.38	130.5915	6003264.0
2021-05-07 13:00:00	AAPL	Stock	130.595	130.62	130.0	130.01	5619611.0
2021-05-07 14:00:00	AAPL	Stock	130.0	130.37	129.85	130.3099	5435463.0
2021-05-07 15:00:00	AAPL	Stock	130.3	130.6	130.17	130.21	9028004.0
2021-05-07 16:00:00	AAPL	Stock	130.21	130.4	130.1	130.32	6453644.0
2021-05-07 17:00:00	AAPL	Stock	130.28	130.3	130.2	130.23	37162.0
2021-05-07 18:00:00	AAPL	Stock	130.21	130.3	130.2	130.24	15680.0
2021-05-07 19:00:00	AAPL	Stock	130.22	130.49	130.2	130.49	57729.0
2021-05-07 04:00:00	MSFT	Stock	249.5	250.0	249.49	249.91	1793.0
2021-05-07 05:00:00	MSFT	Stock	250.13	250.89	250.07	250.07	3120.0
2021-05-07 06:00:00	MSFT	Stock	250.08	250.39	250.08	250.39	5968.0
2021-05-07 07:00:00	MSFT	Stock	250.41	250.45	250.15	250.23	14318.0
2021-05-07 08:00:00	MSFT	Stock	250.39	254.75	249.8982	252.8	266077.0
2021-05-07 09:00:00	MSFT	Stock	252.75	253.17	251.17	252.49	2718754.0
2021-05-07 10:00:00	MSFT	Stock	252.47	253.83	251.89	253.36	2762286.0
2021-05-07 11:00:00	MSFT	Stock	253.35	254.3	253.22	254.23	1967927.0
2021-05-07 12:00:00	MSFT	Stock	254.24	254.27	252.66	252.975	1607475.0
2021-05-07 13:00:00	MSFT	Stock	252.98	253.01	252.14	252.17	1179736.0
2021-05-07 14:00:00	MSFT	Stock	252.16	253.27	251.9	253.16	1316743.0
2021-05-07 15:00:00	MSFT	Stock	253.16	253.47	252.31	252.45	3112024.0
2021-05-07 16:00:00	MSFT	Stock	252.45	252.64	252.4	252.49	2874406.0
2021-05-07 17:00:00	MSFT	Stock	252.49	252.6	252.48	252.55	11589.0
2021-05-07 18:00:00	MSFT	Stock	252.56	252.59	252.48	252.5	7455.0
2021-05-07 19:00:00	MSFT	Stock	252.5	252.6899	252.48	252.6	13738.0
2021-05-07 04:00:00	NVDA	Stock	14.55	14.55	14.5472	14.5472	20240.0
2021-05-07 05:00:00	NVDA	Stock	14.6125	14.6125	14.6	14.6	12760.0
2021-05-07 06:00:00	NVDA	Stock	14.625	14.625	14.6125	14.6125	18000.0
2021-05-07 07:00:00	NVDA	Stock	14.6	14.6138	14.5722	14.6138	223160.0
2021-05-07 08:00:00	NVDA	Stock	14.575	14.8498	14.5625	14.825	1669880.0
2021-05-07 09:00:00	NVDA	Stock	14.8475	14.8717	14.6717	14.7865	27250320.0
2021-05-07 10:00:00	NVDA	Stock	14.7865	14.9708	14.7394	14.9178	26548960.0
2021-05-07 11:00:00	NVDA	Stock	14.9156	14.9468	14.838	14.9028	13889440.0
2021-05-07 12:00:00	NVDA	Stock	14.9032	14.9032	14.8122	14.8386	9529440.0
2021-05-07 13:00:00	NVDA	Stock	14.8375	14.8458	14.7118	14.7118	10900160.0
2021-05-07 14:00:00	NVDA	Stock	14.7088	14.7825	14.685	14.7755	8214240.0
2021-05-07 15:00:00	NVDA	Stock	14.7755	14.8605	14.7702	14.8122	21372680.0
2021-05-07 16:00:00	NVDA	Stock	14.8122	14.8215	14.8005	14.8005	13972880.0
2021-05-07 17:00:00	NVDA	Stock	14.8005	14.8112	14.8005	14.8112	24000.0
2021-05-07 18:00:00	NVDA	Stock	14.809	14.809	14.809	14.809	12440.0
2021-05-07 19:00:00	NVDA	Stock	14.809	14.8135	14.809	14.8135	43000.0
2021-05-07 04:00:00	AMZN	Stock	165.8	166.3	165.8	166.01	26100.0
2021-05-07 05:00:00	AMZN	Stock	166.0	166.0	166.0	166.0	2580.0

> showing 50 of 65,129 rows — these rows as CSV

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