PREVIEW / stock_1hour / 2002-05-09

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-05-09.parquet
  size:    409 KB
  rows:    18,838
  symbols: 1,398

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-05-09 08:00:00	AAPL	Stock	0.4348	0.4348	0.4346	0.4348	224000.0
2002-05-09 09:00:00	AAPL	Stock	0.4339	0.4348	0.4293	0.4339	17712800.0
2002-05-09 10:00:00	AAPL	Stock	0.4338	0.4345	0.425	0.4284	22674400.0
2002-05-09 11:00:00	AAPL	Stock	0.4284	0.4293	0.4268	0.4288	13512800.0
2002-05-09 12:00:00	AAPL	Stock	0.4288	0.4304	0.4252	0.4288	42632800.0
2002-05-09 13:00:00	AAPL	Stock	0.4291	0.4304	0.4259	0.4275	16660000.0
2002-05-09 14:00:00	AAPL	Stock	0.4277	0.4286	0.425	0.4261	17931200.0
2002-05-09 15:00:00	AAPL	Stock	0.4261	0.4346	0.4252	0.432	80763200.0
2002-05-09 16:00:00	AAPL	Stock	0.432	0.433	0.4311	0.4311	12364800.0
2002-05-09 17:00:00	AAPL	Stock	0.432	0.432	0.432	0.432	56000.0
2002-05-09 08:00:00	MSFT	Stock	26.945	27.45	26.945	27.22	117000.0
2002-05-09 09:00:00	MSFT	Stock	27.225	27.5	27.104	27.315	10024800.0
2002-05-09 10:00:00	MSFT	Stock	27.305	27.35	26.485	26.79	15692400.0
2002-05-09 11:00:00	MSFT	Stock	26.79	26.865	26.535	26.625	8037600.0
2002-05-09 12:00:00	MSFT	Stock	26.625	26.665	26.215	26.62	16154000.0
2002-05-09 13:00:00	MSFT	Stock	26.62	26.675	26.275	26.395	8514400.0
2002-05-09 14:00:00	MSFT	Stock	26.39	26.41	26.04	26.075	8836000.0
2002-05-09 15:00:00	MSFT	Stock	26.075	26.3155	25.95	26.055	11920200.0
2002-05-09 16:00:00	MSFT	Stock	26.06	26.805	26.04	26.12	2102200.0
2002-05-09 17:00:00	MSFT	Stock	26.11	26.73	26.06	26.17	68000.0
2002-05-09 18:00:00	MSFT	Stock	26.18	26.22	26.155	26.155	9000.0
2002-05-09 08:00:00	NVDA	Stock	0.2987	0.3	0.2917	0.2954	2124000.0
2002-05-09 09:00:00	NVDA	Stock	0.2979	0.3053	0.2933	0.3001	184068000.0
2002-05-09 10:00:00	NVDA	Stock	0.3003	0.3017	0.2914	0.2925	191160000.0
2002-05-09 11:00:00	NVDA	Stock	0.2927	0.2947	0.2887	0.2907	134088000.0
2002-05-09 12:00:00	NVDA	Stock	0.2906	0.2933	0.2874	0.2926	127848000.0
2002-05-09 13:00:00	NVDA	Stock	0.2926	0.2974	0.29	0.2969	196404000.0
2002-05-09 14:00:00	NVDA	Stock	0.2964	0.2974	0.2902	0.2913	154920000.0
2002-05-09 15:00:00	NVDA	Stock	0.2912	0.292	0.2867	0.2871	206856000.0
2002-05-09 16:00:00	NVDA	Stock	0.2872	0.2933	0.2862	0.2933	14556000.0
2002-05-09 17:00:00	NVDA	Stock	0.2867	0.2916	0.2867	0.2882	348000.0
2002-05-09 18:00:00	NVDA	Stock	0.2867	0.2882	0.2867	0.2867	144000.0
2002-05-09 08:00:00	AMZN	Stock	0.855	0.865	0.855	0.8599	100000.0
2002-05-09 09:00:00	AMZN	Stock	0.8615	0.8975	0.849	0.894	32608000.0
2002-05-09 10:00:00	AMZN	Stock	0.8945	0.9115	0.8875	0.9046	60074000.0
2002-05-09 11:00:00	AMZN	Stock	0.9035	0.908	0.8865	0.892	34524000.0
2002-05-09 12:00:00	AMZN	Stock	0.8915	0.892	0.8815	0.889	14966000.0
2002-05-09 13:00:00	AMZN	Stock	0.889	0.899	0.8875	0.8965	16998000.0
2002-05-09 14:00:00	AMZN	Stock	0.897	0.904	0.893	0.898	17328000.0
2002-05-09 15:00:00	AMZN	Stock	0.899	0.9075	0.885	0.8865	33106000.0
2002-05-09 16:00:00	AMZN	Stock	0.887	0.8989	0.885	0.8935	4724000.0
2002-05-09 17:00:00	AMZN	Stock	0.8948	0.8948	0.8865	0.8865	138000.0
2002-05-09 18:00:00	AMZN	Stock	0.893	0.893	0.893	0.893	30000.0
2002-05-09 09:00:00	CL	Stock	27.625	27.925	27.6	27.91	257200.0
2002-05-09 10:00:00	CL	Stock	27.9	27.9	27.74	27.83	452400.0
2002-05-09 11:00:00	CL	Stock	27.835	27.85	27.7	27.75	230800.0
2002-05-09 12:00:00	CL	Stock	27.765	27.765	27.58	27.685	256800.0
2002-05-09 13:00:00	CL	Stock	27.65	27.695	27.615	27.625	370200.0
2002-05-09 14:00:00	CL	Stock	27.625	27.625	27.495	27.505	329600.0
2002-05-09 15:00:00	CL	Stock	27.505	27.575	27.415	27.45	431600.0

> showing 50 of 18,838 rows — these rows as CSV

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