PREVIEW / stock_1hour / 2001-09-07

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-09-07.parquet
  size:    368 KB
  rows:    17,363
  symbols: 1,327

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-09-07 08:00:00	AAPL	Stock	0.3188	0.3188	0.3125	0.3138	448000.0
2001-09-07 09:00:00	AAPL	Stock	0.3138	0.3205	0.3111	0.3196	24416000.0
2001-09-07 10:00:00	AAPL	Stock	0.3196	0.3232	0.3161	0.3166	32384800.0
2001-09-07 11:00:00	AAPL	Stock	0.3166	0.3188	0.3132	0.3164	21728000.0
2001-09-07 12:00:00	AAPL	Stock	0.3168	0.3193	0.3111	0.3123	20899200.0
2001-09-07 13:00:00	AAPL	Stock	0.3123	0.3143	0.3079	0.3089	25883200.0
2001-09-07 14:00:00	AAPL	Stock	0.3088	0.3141	0.3079	0.3141	41473600.0
2001-09-07 15:00:00	AAPL	Stock	0.3141	0.3146	0.3071	0.3086	47650400.0
2001-09-07 16:00:00	AAPL	Stock	0.3088	0.3171	0.3077	0.3077	6720000.0
2001-09-07 17:00:00	AAPL	Stock	0.3086	0.3093	0.3086	0.3089	336000.0
2001-09-07 08:00:00	MSFT	Stock	28.3	28.3985	27.735	28.225	833200.0
2001-09-07 09:00:00	MSFT	Stock	28.225	28.45	27.73	28.225	17188800.0
2001-09-07 10:00:00	MSFT	Stock	28.225	28.68	28.03	28.06	15611200.0
2001-09-07 11:00:00	MSFT	Stock	28.1	28.275	27.82	28.135	7815200.0
2001-09-07 12:00:00	MSFT	Stock	28.1295	28.2005	27.8	27.895	8902200.0
2001-09-07 13:00:00	MSFT	Stock	27.9	28.105	27.6595	27.985	8315800.0
2001-09-07 14:00:00	MSFT	Stock	27.985	28.3305	27.825	28.3155	13568200.0
2001-09-07 15:00:00	MSFT	Stock	28.3155	28.335	27.7	27.715	12066600.0
2001-09-07 16:00:00	MSFT	Stock	27.7	28.05	27.5	27.65	1644800.0
2001-09-07 17:00:00	MSFT	Stock	27.625	28.0552	27.625	27.685	76800.0
2001-09-07 18:00:00	MSFT	Stock	27.675	27.685	27.625	27.685	2000.0
2001-09-07 08:00:00	NVDA	Stock	0.3217	0.3242	0.3169	0.3183	11592000.0
2001-09-07 09:00:00	NVDA	Stock	0.3178	0.326	0.315	0.3245	303024000.0
2001-09-07 10:00:00	NVDA	Stock	0.3247	0.33	0.3229	0.3235	339168000.0
2001-09-07 11:00:00	NVDA	Stock	0.3235	0.3255	0.3178	0.3219	249456000.0
2001-09-07 12:00:00	NVDA	Stock	0.3214	0.3232	0.3194	0.3198	133056000.0
2001-09-07 13:00:00	NVDA	Stock	0.3197	0.3209	0.3159	0.3196	215160000.0
2001-09-07 14:00:00	NVDA	Stock	0.3195	0.33	0.319	0.3296	346512000.0
2001-09-07 15:00:00	NVDA	Stock	0.33	0.33	0.3227	0.3251	257664000.0
2001-09-07 16:00:00	NVDA	Stock	0.3251	0.3275	0.3229	0.3251	17520000.0
2001-09-07 17:00:00	NVDA	Stock	0.3251	0.3251	0.3231	0.3231	648000.0
2001-09-07 18:00:00	NVDA	Stock	0.3258	0.3258	0.3251	0.3253	288000.0
2001-09-07 08:00:00	AMZN	Stock	0.4085	0.4085	0.3945	0.399	622000.0
2001-09-07 09:00:00	AMZN	Stock	0.3955	0.4065	0.3925	0.402	19990000.0
2001-09-07 10:00:00	AMZN	Stock	0.4015	0.4121	0.395	0.3985	15238000.0
2001-09-07 11:00:00	AMZN	Stock	0.398	0.403	0.396	0.399	9478000.0
2001-09-07 12:00:00	AMZN	Stock	0.3995	0.4019	0.3945	0.395	8990000.0
2001-09-07 13:00:00	AMZN	Stock	0.3955	0.4	0.395	0.3989	8242000.0
2001-09-07 14:00:00	AMZN	Stock	0.3985	0.4135	0.3965	0.411	17942000.0
2001-09-07 15:00:00	AMZN	Stock	0.411	0.4305	0.4105	0.4255	45620000.0
2001-09-07 16:00:00	AMZN	Stock	0.426	0.4275	0.4025	0.4255	2072000.0
2001-09-07 17:00:00	AMZN	Stock	0.4235	0.4255	0.4235	0.4255	80000.0
2001-09-07 09:00:00	CL	Stock	28.275	28.32	28.19	28.19	529400.0
2001-09-07 10:00:00	CL	Stock	28.195	28.365	28.15	28.19	682400.0
2001-09-07 11:00:00	CL	Stock	28.18	28.225	28.105	28.22	565800.0
2001-09-07 12:00:00	CL	Stock	28.22	28.35	28.15	28.18	657400.0
2001-09-07 13:00:00	CL	Stock	28.18	28.2	27.89	28.07	1456400.0
2001-09-07 14:00:00	CL	Stock	28.07	28.095	27.955	28.045	456200.0
2001-09-07 15:00:00	CL	Stock	28.045	28.25	28.0	28.045	849200.0
2001-09-07 16:00:00	CL	Stock	28.04	28.13	28.0	28.13	139800.0

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

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