PREVIEW / stock_1hour / 2005-12-09

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-12-09.parquet
  size:    532 KB
  rows:    23,367
  symbols: 2,053

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
2005-12-09 06:00:00	AAPL	Stock	2.6496	2.6496	2.6496	2.6496	5600.0
2005-12-09 07:00:00	AAPL	Stock	2.6339	2.6339	2.6339	2.6339	5152.0
2005-12-09 08:00:00	AAPL	Stock	2.6375	2.6518	2.6339	2.6486	1661828.0
2005-12-09 09:00:00	AAPL	Stock	2.6486	2.6639	2.6336	2.6375	92248156.0
2005-12-09 10:00:00	AAPL	Stock	2.6371	2.6511	2.6196	2.6343	89205256.0
2005-12-09 11:00:00	AAPL	Stock	2.6339	2.6539	2.625	2.6282	75005616.0
2005-12-09 12:00:00	AAPL	Stock	2.6282	2.6414	2.6271	2.6386	47180560.0
2005-12-09 13:00:00	AAPL	Stock	2.6386	2.65	2.6339	2.6404	43085980.0
2005-12-09 14:00:00	AAPL	Stock	2.6407	2.6607	2.6325	2.6536	95349464.0
2005-12-09 15:00:00	AAPL	Stock	2.6532	2.6611	2.6471	2.6554	95866260.0
2005-12-09 16:00:00	AAPL	Stock	2.6554	2.6586	2.6543	2.6586	2778132.0
2005-12-09 17:00:00	AAPL	Stock	2.6557	2.6582	2.6546	2.6546	298200.0
2005-12-09 18:00:00	AAPL	Stock	2.6561	2.6561	2.6546	2.6546	80472.0
2005-12-09 07:00:00	MSFT	Stock	27.6	27.6	27.6	27.6	1000.0
2005-12-09 08:00:00	MSFT	Stock	27.61	27.69	27.61	27.67	12700.0
2005-12-09 09:00:00	MSFT	Stock	27.67	27.83	27.64	27.74	4467212.0
2005-12-09 10:00:00	MSFT	Stock	27.74	27.82	27.72	27.75	7469186.0
2005-12-09 11:00:00	MSFT	Stock	27.75	27.8	27.71	27.71	5297293.0
2005-12-09 12:00:00	MSFT	Stock	27.71	27.75	27.64	27.71	11849563.0
2005-12-09 13:00:00	MSFT	Stock	27.72	27.75	27.69	27.72	4293038.0
2005-12-09 14:00:00	MSFT	Stock	27.72	27.75	27.699	27.7	4016507.0
2005-12-09 15:00:00	MSFT	Stock	27.7	27.74	27.68	27.71	8594068.0
2005-12-09 16:00:00	MSFT	Stock	27.71	27.72	27.68	27.7	490146.0
2005-12-09 17:00:00	MSFT	Stock	27.69	27.7	27.69	27.7	400.0
2005-12-09 18:00:00	MSFT	Stock	27.706	27.706	27.69	27.69	15200.0
2005-12-09 09:00:00	NVDA	Stock	0.2992	0.3006	0.2953	0.2964	39372720.0
2005-12-09 10:00:00	NVDA	Stock	0.2967	0.3	0.2955	0.2993	38505240.0
2005-12-09 11:00:00	NVDA	Stock	0.2993	0.3008	0.2979	0.2997	45677880.0
2005-12-09 12:00:00	NVDA	Stock	0.2999	0.3009	0.2991	0.3006	18360240.0
2005-12-09 13:00:00	NVDA	Stock	0.3007	0.3017	0.3003	0.3004	29620440.0
2005-12-09 14:00:00	NVDA	Stock	0.3005	0.3028	0.3005	0.3021	36253440.0
2005-12-09 15:00:00	NVDA	Stock	0.302	0.3032	0.3012	0.3028	46509480.0
2005-12-09 16:00:00	NVDA	Stock	0.3028	0.3029	0.3023	0.3025	753840.0
2005-12-09 18:00:00	NVDA	Stock	0.3029	0.3029	0.3029	0.3029	84000.0
2005-12-09 08:00:00	AMZN	Stock	2.4175	2.437	2.4175	2.4255	83600.0
2005-12-09 09:00:00	AMZN	Stock	2.4325	2.448	2.4245	2.43	14692700.0
2005-12-09 10:00:00	AMZN	Stock	2.4305	2.4345	2.415	2.4315	20277340.0
2005-12-09 11:00:00	AMZN	Stock	2.433	2.445	2.4175	2.4195	16987640.0
2005-12-09 12:00:00	AMZN	Stock	2.42	2.4315	2.4125	2.4295	6216280.0
2005-12-09 13:00:00	AMZN	Stock	2.4295	2.4445	2.4295	2.4405	10701880.0
2005-12-09 14:00:00	AMZN	Stock	2.4405	2.452	2.438	2.4395	9891640.0
2005-12-09 15:00:00	AMZN	Stock	2.4395	2.444	2.4305	2.437	13254200.0
2005-12-09 16:00:00	AMZN	Stock	2.437	2.4375	2.4345	2.4375	275460.0
2005-12-09 17:00:00	AMZN	Stock	2.4375	2.4425	2.4375	2.4425	38000.0
2005-12-09 09:00:00	CL	Stock	27.6	27.695	27.535	27.64	186400.0
2005-12-09 10:00:00	CL	Stock	27.645	27.7	27.515	27.54	381200.0
2005-12-09 11:00:00	CL	Stock	27.545	27.625	27.475	27.475	284800.0
2005-12-09 12:00:00	CL	Stock	27.46	27.495	27.437	27.47	278800.0
2005-12-09 13:00:00	CL	Stock	27.47	27.535	27.425	27.505	269800.0
2005-12-09 14:00:00	CL	Stock	27.5	27.585	27.49	27.575	206600.0

> showing 50 of 23,367 rows — these rows as CSV

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