PREVIEW / stock_1hour / 2001-07-11

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-07-11.parquet
  size:    368 KB
  rows:    17,497
  symbols: 1,314

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
2001-07-11 08:00:00	AAPL	Stock	0.3777	0.3782	0.3771	0.3782	414400.0
2001-07-11 09:00:00	AAPL	Stock	0.3791	0.387	0.375	0.3854	70957600.0
2001-07-11 10:00:00	AAPL	Stock	0.3854	0.3984	0.3846	0.3913	91660800.0
2001-07-11 11:00:00	AAPL	Stock	0.3913	0.3952	0.3893	0.3936	74384800.0
2001-07-11 12:00:00	AAPL	Stock	0.3938	0.398	0.3911	0.3955	38287200.0
2001-07-11 13:00:00	AAPL	Stock	0.3955	0.3973	0.3927	0.3959	44576000.0
2001-07-11 14:00:00	AAPL	Stock	0.3957	0.4011	0.393	0.3973	57820000.0
2001-07-11 15:00:00	AAPL	Stock	0.397	0.4027	0.3936	0.4025	66080000.0
2001-07-11 16:00:00	AAPL	Stock	0.4023	0.4036	0.393	0.4034	12191200.0
2001-07-11 17:00:00	AAPL	Stock	0.403	0.4196	0.403	0.4179	1680000.0
2001-07-11 18:00:00	AAPL	Stock	0.4179	0.4179	0.417	0.417	33600.0
2001-07-11 08:00:00	MSFT	Stock	32.145	32.25	31.995	32.225	82002.0
2001-07-11 09:00:00	MSFT	Stock	32.17	32.625	32.025	32.625	8207000.0
2001-07-11 10:00:00	MSFT	Stock	32.61	32.99	32.58	32.725	10039800.0
2001-07-11 11:00:00	MSFT	Stock	32.73	32.95	32.5	32.9	7926200.0
2001-07-11 12:00:00	MSFT	Stock	32.9	33.15	32.89	33.1	7752200.0
2001-07-11 13:00:00	MSFT	Stock	33.105	33.375	33.05	33.275	7034200.0
2001-07-11 14:00:00	MSFT	Stock	33.27	33.355	32.855	32.895	7928600.0
2001-07-11 15:00:00	MSFT	Stock	32.9	33.335	32.81	33.25	13377200.0
2001-07-11 16:00:00	MSFT	Stock	33.25	33.5	32.895	33.375	3019600.0
2001-07-11 17:00:00	MSFT	Stock	33.465	36.55	33.29	35.23	5638400.0
2001-07-11 18:00:00	MSFT	Stock	35.225	35.325	35.13	35.25	775400.0
2001-07-11 08:00:00	NVDA	Stock	0.3279	0.3279	0.3251	0.3251	1536000.0
2001-07-11 09:00:00	NVDA	Stock	0.3246	0.3313	0.3222	0.3273	116304000.0
2001-07-11 10:00:00	NVDA	Stock	0.3274	0.3324	0.3252	0.3255	194928000.0
2001-07-11 11:00:00	NVDA	Stock	0.3254	0.3256	0.3172	0.324	129840000.0
2001-07-11 12:00:00	NVDA	Stock	0.3239	0.3302	0.3238	0.3271	93432000.0
2001-07-11 13:00:00	NVDA	Stock	0.3271	0.3307	0.3243	0.3283	73416000.0
2001-07-11 14:00:00	NVDA	Stock	0.3285	0.3298	0.3229	0.3258	82776000.0
2001-07-11 15:00:00	NVDA	Stock	0.3258	0.329	0.3242	0.3277	156192000.0
2001-07-11 16:00:00	NVDA	Stock	0.3273	0.3304	0.3263	0.3273	15720000.0
2001-07-11 17:00:00	NVDA	Stock	0.3296	0.3524	0.3296	0.3459	5520000.0
2001-07-11 18:00:00	NVDA	Stock	0.3459	0.3479	0.3458	0.346	2664000.0
2001-07-11 08:00:00	AMZN	Stock	0.775	0.775	0.77	0.77	98000.0
2001-07-11 09:00:00	AMZN	Stock	0.7715	0.7835	0.767	0.7705	12904000.0
2001-07-11 10:00:00	AMZN	Stock	0.7705	0.79	0.762	0.763	14952000.0
2001-07-11 11:00:00	AMZN	Stock	0.763	0.7655	0.7475	0.7525	37616000.0
2001-07-11 12:00:00	AMZN	Stock	0.752	0.755	0.7475	0.753	11744000.0
2001-07-11 13:00:00	AMZN	Stock	0.753	0.7635	0.7515	0.7555	7110000.0
2001-07-11 14:00:00	AMZN	Stock	0.755	0.7595	0.749	0.753	7416000.0
2001-07-11 15:00:00	AMZN	Stock	0.753	0.7675	0.7525	0.767	9530000.0
2001-07-11 16:00:00	AMZN	Stock	0.7675	0.799	0.75	0.767	9576000.0
2001-07-11 17:00:00	AMZN	Stock	0.802	0.82	0.7855	0.81	2462000.0
2001-07-11 18:00:00	AMZN	Stock	0.767	0.81	0.767	0.809	164000.0
2001-07-11 09:00:00	CL	Stock	28.75	28.775	28.55	28.55	626400.0
2001-07-11 10:00:00	CL	Stock	28.545	28.73	28.26	28.45	853600.0
2001-07-11 11:00:00	CL	Stock	28.45	28.45	27.77	27.905	1351200.0
2001-07-11 12:00:00	CL	Stock	27.925	28.05	27.655	27.655	604400.0
2001-07-11 13:00:00	CL	Stock	27.625	27.76	27.15	27.625	1795600.0
2001-07-11 14:00:00	CL	Stock	27.62	27.75	27.525	27.57	1156600.0

> showing 50 of 17,497 rows — these rows as CSV

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