PREVIEW / stock_1hour / 2022-02-09

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-02-09.parquet
  size:    1.4 MB
  rows:    64,481
  symbols: 2,540

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
2022-02-09 04:00:00	AAPL	Stock	175.35	176.0	175.35	175.83	16384.0
2022-02-09 05:00:00	AAPL	Stock	175.79	176.1	175.79	176.05	28544.0
2022-02-09 06:00:00	AAPL	Stock	176.01	176.45	175.93	176.34	25632.0
2022-02-09 07:00:00	AAPL	Stock	176.3	176.69	175.95	176.57	126229.0
2022-02-09 08:00:00	AAPL	Stock	176.3805	176.76	175.0	176.3	279621.0
2022-02-09 09:00:00	AAPL	Stock	176.32	176.65	175.0805	175.24	9185214.0
2022-02-09 10:00:00	AAPL	Stock	175.25	176.1699	175.18	175.7838	8253204.0
2022-02-09 11:00:00	AAPL	Stock	175.7845	175.98	175.2	175.4248	6260501.0
2022-02-09 12:00:00	AAPL	Stock	175.43	175.88	175.25	175.815	4741196.0
2022-02-09 13:00:00	AAPL	Stock	175.82	175.92	175.435	175.6	4160654.0
2022-02-09 14:00:00	AAPL	Stock	175.6091	176.12	175.59	175.67	4806830.0
2022-02-09 15:00:00	AAPL	Stock	175.67	176.33	174.9	176.28	11714734.0
2022-02-09 16:00:00	AAPL	Stock	176.27	176.48	175.3865	176.4499	7434454.0
2022-02-09 17:00:00	AAPL	Stock	176.44	176.59	176.28	176.4001	728611.0
2022-02-09 18:00:00	AAPL	Stock	176.4	176.45	176.14	176.14	14971.0
2022-02-09 19:00:00	AAPL	Stock	176.14	176.23	175.92	176.0	30241.0
2022-02-09 04:00:00	MSFT	Stock	307.01	307.56	306.84	306.9	7323.0
2022-02-09 05:00:00	MSFT	Stock	307.0	307.49	307.0	307.46	3446.0
2022-02-09 06:00:00	MSFT	Stock	307.35	307.95	307.2	307.95	5569.0
2022-02-09 07:00:00	MSFT	Stock	307.94	309.0	307.68	308.8	38267.0
2022-02-09 08:00:00	MSFT	Stock	308.5	309.47	307.61	308.4	46316.0
2022-02-09 09:00:00	MSFT	Stock	308.5	311.93	308.4	309.275	3713611.0
2022-02-09 10:00:00	MSFT	Stock	309.35	309.9	307.39	308.65	3047370.0
2022-02-09 11:00:00	MSFT	Stock	308.655	309.07	307.47	307.89	2597544.0
2022-02-09 12:00:00	MSFT	Stock	307.89	308.97	307.68	308.92	1503137.0
2022-02-09 13:00:00	MSFT	Stock	308.93	309.03	308.19	308.594	1303538.0
2022-02-09 14:00:00	MSFT	Stock	308.61	310.185	308.58	309.4611	1876557.0
2022-02-09 15:00:00	MSFT	Stock	309.4598	311.26	308.5337	311.21	4455887.0
2022-02-09 16:00:00	MSFT	Stock	311.21	311.95	310.74	311.33	3902419.0
2022-02-09 17:00:00	MSFT	Stock	311.32	311.4	311.22	311.3	11476.0
2022-02-09 18:00:00	MSFT	Stock	311.29	311.3	310.7	310.95	9315.0
2022-02-09 19:00:00	MSFT	Stock	310.86	310.86	310.03	310.03	10285.0
2022-02-09 04:00:00	NVDA	Stock	25.466	25.57	25.458	25.557	93030.0
2022-02-09 05:00:00	NVDA	Stock	25.547	25.675	25.547	25.636	39060.0
2022-02-09 06:00:00	NVDA	Stock	25.623	25.669	25.58	25.648	123370.0
2022-02-09 07:00:00	NVDA	Stock	25.636	25.79	25.6	25.762	992350.0
2022-02-09 08:00:00	NVDA	Stock	25.629	25.808	25.1707	25.71	963050.0
2022-02-09 09:00:00	NVDA	Stock	25.73	25.75	25.353	25.439	40572080.0
2022-02-09 10:00:00	NVDA	Stock	25.441	26.0614	25.391	26.054	63246210.0
2022-02-09 11:00:00	NVDA	Stock	26.053	26.3787	26.049	26.1582	69368400.0
2022-02-09 12:00:00	NVDA	Stock	26.1578	26.583	26.112	26.5535	50602710.0
2022-02-09 13:00:00	NVDA	Stock	26.5515	26.595	26.369	26.4535	30193280.0
2022-02-09 14:00:00	NVDA	Stock	26.452	26.635	26.4469	26.4974	32691260.0
2022-02-09 15:00:00	NVDA	Stock	26.499	26.725	26.3746	26.708	61555650.0
2022-02-09 16:00:00	NVDA	Stock	26.711	26.896	26.648	26.8	21111930.0
2022-02-09 17:00:00	NVDA	Stock	26.8	26.825	26.775	26.775	240550.0
2022-02-09 18:00:00	NVDA	Stock	26.784	26.8	26.752	26.752	208310.0
2022-02-09 19:00:00	NVDA	Stock	26.751	26.76	26.7	26.7	409700.0
2022-02-09 04:00:00	AMZN	Stock	161.9	162.25	161.9	162.25	4000.0
2022-02-09 05:00:00	AMZN	Stock	162.5	162.5	162.4	162.4	8000.0

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

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