PREVIEW / stock_1hour / 2023-05-23

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-05-23.parquet
  size:    1.3 MB
  rows:    60,263
  symbols: 1,652

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
2023-05-23 04:00:00	AAPL	Stock	174.55	174.56	174.1	174.2	9359.0
2023-05-23 05:00:00	AAPL	Stock	174.18	174.21	173.8	173.91	11542.0
2023-05-23 06:00:00	AAPL	Stock	173.91	174.01	173.89	173.96	8515.0
2023-05-23 07:00:00	AAPL	Stock	173.99	174.2	173.5	173.5	65433.0
2023-05-23 08:00:00	AAPL	Stock	174.19	174.51	173.17	173.23	184001.0
2023-05-23 09:00:00	AAPL	Stock	173.21	174.2	172.55	172.938	5493522.0
2023-05-23 10:00:00	AAPL	Stock	172.94	173.19	172.685	172.9135	4490489.0
2023-05-23 11:00:00	AAPL	Stock	172.91	173.18	172.52	172.725	3366187.0
2023-05-23 12:00:00	AAPL	Stock	172.73	172.8105	171.77	171.9401	4086404.0
2023-05-23 13:00:00	AAPL	Stock	171.95	172.48	171.86	172.16	2951730.0
2023-05-23 14:00:00	AAPL	Stock	172.1703	172.3	171.5	171.82	3965129.0
2023-05-23 15:00:00	AAPL	Stock	171.83	172.02	171.275	171.55	8324856.0
2023-05-23 16:00:00	AAPL	Stock	171.55	171.76	171.35	171.54	5626014.0
2023-05-23 17:00:00	AAPL	Stock	171.52	171.64	171.45	171.46	22996.0
2023-05-23 18:00:00	AAPL	Stock	171.47	171.8	171.47	171.73	76404.0
2023-05-23 19:00:00	AAPL	Stock	171.74	171.9	171.67	171.76	21899.0
2023-05-23 04:00:00	MSFT	Stock	321.8	323.29	321.8	322.75	23798.0
2023-05-23 05:00:00	MSFT	Stock	322.69	322.7	321.8	322.0	5581.0
2023-05-23 06:00:00	MSFT	Stock	322.12	322.35	322.07	322.35	7587.0
2023-05-23 07:00:00	MSFT	Stock	322.35	322.35	320.9	321.0	29225.0
2023-05-23 08:00:00	MSFT	Stock	322.3495	322.35	320.8	321.13	73149.0
2023-05-23 09:00:00	MSFT	Stock	321.14	322.72	319.8	320.74	3013756.0
2023-05-23 10:00:00	MSFT	Stock	320.75	321.19	318.58	318.8525	2852687.0
2023-05-23 11:00:00	MSFT	Stock	318.86	319.64	318.31	318.9249	2588803.0
2023-05-23 12:00:00	MSFT	Stock	318.95	319.0	317.0	317.34	1970786.0
2023-05-23 13:00:00	MSFT	Stock	317.33	317.9	316.72	317.185	1555214.0
2023-05-23 14:00:00	MSFT	Stock	317.19	317.5	315.27	316.1431	2395068.0
2023-05-23 15:00:00	MSFT	Stock	316.15	316.62	315.25	315.28	3734947.0
2023-05-23 16:00:00	MSFT	Stock	315.28	315.69	315.12	315.39	3437278.0
2023-05-23 17:00:00	MSFT	Stock	315.37	315.55	315.26	315.39	12565.0
2023-05-23 18:00:00	MSFT	Stock	315.49	315.75	315.4702	315.7363	4247.0
2023-05-23 19:00:00	MSFT	Stock	315.51	316.0	315.5	315.8	7480.0
2023-05-23 04:00:00	NVDA	Stock	31.207	31.207	31.12	31.121	140540.0
2023-05-23 05:00:00	NVDA	Stock	31.139	31.143	30.99	31.007	57640.0
2023-05-23 06:00:00	NVDA	Stock	31.001	31.1	31.001	31.075	61810.0
2023-05-23 07:00:00	NVDA	Stock	31.053	31.15	31.053	31.07	384070.0
2023-05-23 08:00:00	NVDA	Stock	31.126	31.35	31.062	31.202	1845020.0
2023-05-23 09:00:00	NVDA	Stock	31.2	31.288	30.951	31.1825	47192000.0
2023-05-23 10:00:00	NVDA	Stock	31.1785	31.252	30.95	30.994	40441620.0
2023-05-23 11:00:00	NVDA	Stock	30.995	31.065	30.715	30.869	38884550.0
2023-05-23 12:00:00	NVDA	Stock	30.8669	30.91	30.695	30.778	31422860.0
2023-05-23 13:00:00	NVDA	Stock	30.7789	30.923	30.713	30.784	27255010.0
2023-05-23 14:00:00	NVDA	Stock	30.787	30.891	30.631	30.7293	24523850.0
2023-05-23 15:00:00	NVDA	Stock	30.7305	30.849	30.666	30.684	43079480.0
2023-05-23 16:00:00	NVDA	Stock	30.688	30.73	30.619	30.725	17995690.0
2023-05-23 17:00:00	NVDA	Stock	30.7244	30.725	30.69	30.695	316170.0
2023-05-23 18:00:00	NVDA	Stock	30.71	30.732	30.708	30.71	188660.0
2023-05-23 19:00:00	NVDA	Stock	30.721	30.731	30.71	30.72	337670.0
2023-05-23 04:00:00	AMZN	Stock	115.18	115.18	114.85	114.96	6966.0
2023-05-23 05:00:00	AMZN	Stock	114.99	115.09	114.67	114.67	11372.0

> showing 50 of 60,263 rows — these rows as CSV

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