PREVIEW / stock_1hour / 2002-06-12

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-06-12.parquet
  size:    415 KB
  rows:    18,950
  symbols: 1,435

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
2002-06-12 09:00:00	AAPL	Stock	0.3656	0.3675	0.3636	0.3671	80847200.0
2002-06-12 10:00:00	AAPL	Stock	0.3671	0.3671	0.3625	0.3625	43411200.0
2002-06-12 11:00:00	AAPL	Stock	0.3625	0.3664	0.3616	0.3618	30430400.0
2002-06-12 12:00:00	AAPL	Stock	0.3618	0.3668	0.3598	0.3668	37458400.0
2002-06-12 13:00:00	AAPL	Stock	0.367	0.3706	0.3645	0.3657	70358400.0
2002-06-12 14:00:00	AAPL	Stock	0.3668	0.3668	0.3561	0.3598	95636800.0
2002-06-12 15:00:00	AAPL	Stock	0.3598	0.3607	0.3579	0.3588	123160800.0
2002-06-12 16:00:00	AAPL	Stock	0.3588	0.3595	0.3563	0.358	17427200.0
2002-06-12 17:00:00	AAPL	Stock	0.3588	0.3588	0.3588	0.3588	2968000.0
2002-06-12 08:00:00	MSFT	Stock	26.27	26.37	26.0	26.3	97400.0
2002-06-12 09:00:00	MSFT	Stock	26.325	26.745	26.195	26.74	13475800.0
2002-06-12 10:00:00	MSFT	Stock	26.74	26.97	26.57	26.76	18136400.0
2002-06-12 11:00:00	MSFT	Stock	26.765	26.97	26.62	26.645	14736000.0
2002-06-12 12:00:00	MSFT	Stock	26.6355	27.05	26.625	26.98	9291200.0
2002-06-12 13:00:00	MSFT	Stock	26.98	27.43	26.975	27.39	15962600.0
2002-06-12 14:00:00	MSFT	Stock	27.39	27.47	27.0	27.335	20343000.0
2002-06-12 15:00:00	MSFT	Stock	27.335	27.89	27.25	27.77	32788600.0
2002-06-12 16:00:00	MSFT	Stock	27.765	27.77	27.1162	27.7	6161200.0
2002-06-12 17:00:00	MSFT	Stock	27.7	27.9	27.65	27.875	2041600.0
2002-06-12 18:00:00	MSFT	Stock	27.775	27.9	27.77	27.895	278200.0
2002-06-12 08:00:00	NVDA	Stock	0.2549	0.255	0.2447	0.2468	13560000.0
2002-06-12 09:00:00	NVDA	Stock	0.2468	0.2533	0.245	0.2521	267876000.0
2002-06-12 10:00:00	NVDA	Stock	0.2521	0.2529	0.2332	0.2333	433572000.0
2002-06-12 11:00:00	NVDA	Stock	0.2332	0.2346	0.2222	0.2249	468672000.0
2002-06-12 12:00:00	NVDA	Stock	0.2248	0.23	0.2226	0.2287	279060000.0
2002-06-12 13:00:00	NVDA	Stock	0.2289	0.2364	0.2285	0.232	281568000.0
2002-06-12 14:00:00	NVDA	Stock	0.2322	0.2341	0.226	0.2319	246240000.0
2002-06-12 15:00:00	NVDA	Stock	0.2323	0.2358	0.23	0.2331	226824000.0
2002-06-12 16:00:00	NVDA	Stock	0.2329	0.2338	0.2312	0.2324	13692000.0
2002-06-12 17:00:00	NVDA	Stock	0.2327	0.2358	0.2327	0.2346	2268000.0
2002-06-12 18:00:00	NVDA	Stock	0.2357	0.2362	0.2329	0.2362	1740000.0
2002-06-12 08:00:00	AMZN	Stock	0.8575	0.8575	0.8555	0.857	46000.0
2002-06-12 09:00:00	AMZN	Stock	0.854	0.8575	0.847	0.8545	19304000.0
2002-06-12 10:00:00	AMZN	Stock	0.854	0.8574	0.838	0.8415	21060000.0
2002-06-12 11:00:00	AMZN	Stock	0.842	0.845	0.813	0.813	37506000.0
2002-06-12 12:00:00	AMZN	Stock	0.813	0.838	0.813	0.8345	13364000.0
2002-06-12 13:00:00	AMZN	Stock	0.834	0.855	0.833	0.8505	12456000.0
2002-06-12 14:00:00	AMZN	Stock	0.8505	0.8505	0.83	0.8315	11652000.0
2002-06-12 15:00:00	AMZN	Stock	0.8329	0.8575	0.8285	0.856	17850000.0
2002-06-12 16:00:00	AMZN	Stock	0.854	0.8595	0.8394	0.8595	2528000.0
2002-06-12 17:00:00	AMZN	Stock	0.861	0.8685	0.854	0.854	646000.0
2002-06-12 09:00:00	CL	Stock	26.7	26.78	26.585	26.75	641400.0
2002-06-12 10:00:00	CL	Stock	26.775	26.9	26.675	26.87	560800.0
2002-06-12 11:00:00	CL	Stock	26.85	27.05	26.775	26.85	553200.0
2002-06-12 12:00:00	CL	Stock	26.85	26.85	26.67	26.67	516200.0
2002-06-12 13:00:00	CL	Stock	26.675	26.78	26.645	26.74	337600.0
2002-06-12 14:00:00	CL	Stock	26.74	26.795	26.61	26.765	592200.0
2002-06-12 15:00:00	CL	Stock	26.765	26.93	26.7	26.925	971200.0
2002-06-12 16:00:00	CL	Stock	26.93	26.93	26.925	26.93	342200.0

> showing 49 of 18,950 rows — these rows as CSV

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