PREVIEW / stock_1hour / 2023-06-16

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-06-16.parquet
  size:    1.4 MB
  rows:    61,275
  symbols: 1,573

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-06-16 04:00:00	AAPL	Stock	185.99	185.99	185.6	185.69	13632.0
2023-06-16 05:00:00	AAPL	Stock	185.76	185.8	185.35	185.54	17751.0
2023-06-16 06:00:00	AAPL	Stock	185.6	185.6	185.11	185.52	29956.0
2023-06-16 07:00:00	AAPL	Stock	185.53	185.96	185.47	185.66	53538.0
2023-06-16 08:00:00	AAPL	Stock	185.68	186.31	185.43	186.3	679472.0
2023-06-16 09:00:00	AAPL	Stock	186.32	187.5	184.96	185.22	21594459.0
2023-06-16 10:00:00	AAPL	Stock	185.23	185.96	185.13	185.7301	5671959.0
2023-06-16 11:00:00	AAPL	Stock	185.74	186.13	185.3	185.77	4296465.0
2023-06-16 12:00:00	AAPL	Stock	185.77	185.98	185.51	185.93	2919118.0
2023-06-16 13:00:00	AAPL	Stock	185.94	186.0299	185.46	185.58	2548377.0
2023-06-16 14:00:00	AAPL	Stock	185.57	185.62	184.8618	184.9	3827484.0
2023-06-16 15:00:00	AAPL	Stock	184.9	185.35	184.27	185.01	9104061.0
2023-06-16 16:00:00	AAPL	Stock	185.02	185.2	184.92	185.01	27942984.0
2023-06-16 17:00:00	AAPL	Stock	185.02	185.04	184.92	184.93	49044.0
2023-06-16 18:00:00	AAPL	Stock	184.93	184.98	184.92	184.92	3951.0
2023-06-16 19:00:00	AAPL	Stock	184.92	185.0	184.92	184.94	7372.0
2023-06-16 04:00:00	MSFT	Stock	348.11	349.8	348.11	349.62	5154.0
2023-06-16 05:00:00	MSFT	Stock	349.71	349.82	349.13	349.41	7083.0
2023-06-16 06:00:00	MSFT	Stock	349.42	349.85	348.26	349.28	15672.0
2023-06-16 07:00:00	MSFT	Stock	349.49	350.6	349.49	349.8	45645.0
2023-06-16 08:00:00	MSFT	Stock	349.48	351.02	347.86	350.29	365056.0
2023-06-16 09:00:00	MSFT	Stock	350.29	352.25	345.0	345.84	11698444.0
2023-06-16 10:00:00	MSFT	Stock	345.87	347.99	345.1884	346.62	3182460.0
2023-06-16 11:00:00	MSFT	Stock	346.66	347.93	345.15	346.98	2023215.0
2023-06-16 12:00:00	MSFT	Stock	347.0	347.2	346.12	346.695	1103195.0
2023-06-16 13:00:00	MSFT	Stock	346.7	346.98	345.41	345.94	993975.0
2023-06-16 14:00:00	MSFT	Stock	345.94	346.07	344.05	344.1525	1604035.0
2023-06-16 15:00:00	MSFT	Stock	344.15	344.31	341.95	342.56	3784970.0
2023-06-16 16:00:00	MSFT	Stock	342.595	343.5001	342.33	342.55	10598252.0
2023-06-16 17:00:00	MSFT	Stock	342.55	342.7	342.33	342.5402	69834.0
2023-06-16 18:00:00	MSFT	Stock	342.52	342.95	342.52	342.7779	4572.0
2023-06-16 19:00:00	MSFT	Stock	342.63	343.3	342.57	343.18	4393.0
2023-06-16 04:00:00	NVDA	Stock	42.81	43.152	42.8	43.08	278650.0
2023-06-16 05:00:00	NVDA	Stock	43.104	43.22	43.084	43.18	295870.0
2023-06-16 06:00:00	NVDA	Stock	43.199	43.4	43.199	43.359	639620.0
2023-06-16 07:00:00	NVDA	Stock	43.35	43.365	43.255	43.278	1645910.0
2023-06-16 08:00:00	NVDA	Stock	43.3535	43.36	42.437	43.348	4144950.0
2023-06-16 09:00:00	NVDA	Stock	43.345	43.655	42.832	43.319	101714750.0
2023-06-16 10:00:00	NVDA	Stock	43.316	43.65	43.211	43.442	82368390.0
2023-06-16 11:00:00	NVDA	Stock	43.4449	43.586	43.037	43.4315	54617550.0
2023-06-16 12:00:00	NVDA	Stock	43.4346	43.721	43.361	43.468	47450330.0
2023-06-16 13:00:00	NVDA	Stock	43.47	43.595	43.4175	43.472	27426610.0
2023-06-16 14:00:00	NVDA	Stock	43.481	43.4869	43.107	43.1135	30872420.0
2023-06-16 15:00:00	NVDA	Stock	43.118	43.1395	42.6605	42.7025	75574180.0
2023-06-16 16:00:00	NVDA	Stock	42.692	42.795	42.644	42.745	83056530.0
2023-06-16 17:00:00	NVDA	Stock	42.735	42.788	42.73	42.753	406550.0
2023-06-16 18:00:00	NVDA	Stock	42.751	42.78	42.74	42.7565	329570.0
2023-06-16 19:00:00	NVDA	Stock	42.766	42.794	42.733	42.762	343230.0
2023-06-16 04:00:00	AMZN	Stock	127.0	127.09	126.71	126.9	12244.0
2023-06-16 05:00:00	AMZN	Stock	126.83	126.97	126.52	126.77	3934.0

> showing 50 of 61,275 rows — these rows as CSV

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