PREVIEW / stock_1hour / 2021-06-25

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-06-25.parquet
  size:    1.4 MB
  rows:    65,468
  symbols: 2,929

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-06-25 04:00:00	AAPL	Stock	133.33	133.41	133.01	133.32	8134.0
2021-06-25 05:00:00	AAPL	Stock	133.4	133.6	133.16	133.6	8833.0
2021-06-25 06:00:00	AAPL	Stock	133.54	133.55	133.38	133.45	3686.0
2021-06-25 07:00:00	AAPL	Stock	133.41	133.72	133.29	133.32	76048.0
2021-06-25 08:00:00	AAPL	Stock	133.55	133.63	133.077	133.57	358019.0
2021-06-25 09:00:00	AAPL	Stock	133.57	133.708	133.105	133.245	6786405.0
2021-06-25 10:00:00	AAPL	Stock	133.24	133.89	133.085	133.49	7202234.0
2021-06-25 11:00:00	AAPL	Stock	133.5	133.65	133.3418	133.375	3969733.0
2021-06-25 12:00:00	AAPL	Stock	133.38	133.51	133.24	133.3906	3151326.0
2021-06-25 13:00:00	AAPL	Stock	133.395	133.45	133.05	133.0957	3251403.0
2021-06-25 14:00:00	AAPL	Stock	133.1	133.17	132.9	133.0	4587685.0
2021-06-25 15:00:00	AAPL	Stock	132.9906	133.36	132.81	133.11	9232176.0
2021-06-25 16:00:00	AAPL	Stock	133.12	133.29	133.01	133.04	22569393.0
2021-06-25 17:00:00	AAPL	Stock	133.045	133.08	132.98	133.03	47158.0
2021-06-25 18:00:00	AAPL	Stock	133.03	133.12	133.0	133.02	15223.0
2021-06-25 19:00:00	AAPL	Stock	133.01	133.01	132.93	132.98	33878.0
2021-06-25 04:00:00	MSFT	Stock	267.0	267.5	267.0	267.36	500.0
2021-06-25 05:00:00	MSFT	Stock	267.27	267.27	266.84	267.23	895.0
2021-06-25 06:00:00	MSFT	Stock	267.48	267.49	267.31	267.31	1122.0
2021-06-25 07:00:00	MSFT	Stock	267.38	267.38	266.82	266.85	11984.0
2021-06-25 08:00:00	MSFT	Stock	267.31	267.4	266.67	266.9	20209.0
2021-06-25 09:00:00	MSFT	Stock	267.03	267.25	265.6	265.785	1932365.0
2021-06-25 10:00:00	MSFT	Stock	265.77	266.1172	264.9154	265.73	1574410.0
2021-06-25 11:00:00	MSFT	Stock	265.73	266.26	265.51	265.835	844240.0
2021-06-25 12:00:00	MSFT	Stock	265.8286	265.83	265.07	265.13	964581.0
2021-06-25 13:00:00	MSFT	Stock	265.12	265.38	264.76	265.31	1122717.0
2021-06-25 14:00:00	MSFT	Stock	265.32	265.94	265.16	265.82	1000159.0
2021-06-25 15:00:00	MSFT	Stock	265.83	266.3	264.9	265.02	3281820.0
2021-06-25 16:00:00	MSFT	Stock	265.02	265.24	264.9	265.1	8262787.0
2021-06-25 17:00:00	MSFT	Stock	265.01	265.24	265.01	265.24	970.0
2021-06-25 18:00:00	MSFT	Stock	265.16	265.21	265.0	265.01	2913.0
2021-06-25 19:00:00	MSFT	Stock	265.09	265.18	265.02	265.02	1735.0
2021-06-25 04:00:00	NVDA	Stock	19.27	19.305	19.27	19.305	44120.0
2021-06-25 05:00:00	NVDA	Stock	19.325	19.35	19.3105	19.3285	101240.0
2021-06-25 06:00:00	NVDA	Stock	19.325	19.325	19.2768	19.2768	36000.0
2021-06-25 07:00:00	NVDA	Stock	19.2593	19.3055	19.2375	19.2425	515040.0
2021-06-25 08:00:00	NVDA	Stock	19.289	19.3	19.225	19.2973	372880.0
2021-06-25 09:00:00	NVDA	Stock	19.2755	19.3455	18.9695	18.9991	32821280.0
2021-06-25 10:00:00	NVDA	Stock	18.995	19.0945	18.8944	19.0536	41695480.0
2021-06-25 11:00:00	NVDA	Stock	19.05	19.1302	19.014	19.103	17041760.0
2021-06-25 12:00:00	NVDA	Stock	19.1053	19.1127	18.9918	19.0238	13246480.0
2021-06-25 13:00:00	NVDA	Stock	19.0243	19.0432	18.9752	18.9912	8399800.0
2021-06-25 14:00:00	NVDA	Stock	18.9925	19.0605	18.9703	19.0572	8719240.0
2021-06-25 15:00:00	NVDA	Stock	19.053	19.0927	18.9526	19.0315	24267840.0
2021-06-25 16:00:00	NVDA	Stock	19.031	19.0375	19.006	19.0098	28275400.0
2021-06-25 17:00:00	NVDA	Stock	19.0112	19.025	19.0	19.025	145640.0
2021-06-25 18:00:00	NVDA	Stock	19.0195	19.0312	19.0125	19.0125	57600.0
2021-06-25 19:00:00	NVDA	Stock	19.0197	19.035	19.0137	19.0325	130640.0
2021-06-25 04:00:00	AMZN	Stock	173.0	173.0	173.0	173.0	2000.0
2021-06-25 05:00:00	AMZN	Stock	173.1495	173.16	173.1495	173.16	5500.0

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

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