PREVIEW / stock_1hour / 2001-07-13

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-07-13.parquet
  size:    355 KB
  rows:    17,032
  symbols: 1,308

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-13 08:00:00	AAPL	Stock	0.4336	0.4336	0.432	0.4321	263200.0
2001-07-13 09:00:00	AAPL	Stock	0.4321	0.4393	0.4257	0.4321	46356800.0
2001-07-13 10:00:00	AAPL	Stock	0.432	0.4375	0.4286	0.4371	51408000.0
2001-07-13 11:00:00	AAPL	Stock	0.4375	0.4466	0.4355	0.4455	99310400.0
2001-07-13 12:00:00	AAPL	Stock	0.4455	0.4464	0.4427	0.4459	52326400.0
2001-07-13 13:00:00	AAPL	Stock	0.4457	0.4464	0.4423	0.4439	30486400.0
2001-07-13 14:00:00	AAPL	Stock	0.4439	0.4463	0.4416	0.443	76283200.0
2001-07-13 15:00:00	AAPL	Stock	0.4429	0.4457	0.4395	0.4436	70901600.0
2001-07-13 16:00:00	AAPL	Stock	0.4436	0.4441	0.4396	0.4396	9122400.0
2001-07-13 17:00:00	AAPL	Stock	0.4438	0.4438	0.4438	0.4438	28000.0
2001-07-13 18:00:00	AAPL	Stock	0.4438	0.4438	0.4438	0.4438	11200.0
2001-07-13 08:00:00	MSFT	Stock	35.8	36.075	35.575	35.75	253400.0
2001-07-13 09:00:00	MSFT	Stock	35.75	35.815	35.56	35.56	9723400.0
2001-07-13 10:00:00	MSFT	Stock	35.56	35.99	35.535	35.84	14848400.0
2001-07-13 11:00:00	MSFT	Stock	35.84	35.925	35.695	35.785	6888800.0
2001-07-13 12:00:00	MSFT	Stock	35.77	35.95	35.725	35.885	4571200.0
2001-07-13 13:00:00	MSFT	Stock	35.875	35.98	35.73	35.77	4135000.0
2001-07-13 14:00:00	MSFT	Stock	35.775	35.92	35.725	35.81	4582600.0
2001-07-13 15:00:00	MSFT	Stock	35.815	36.0	35.47	35.675	10323000.0
2001-07-13 16:00:00	MSFT	Stock	35.67	35.825	35.61	35.75	1183200.0
2001-07-13 17:00:00	MSFT	Stock	35.75	35.8	35.67	35.75	33400.0
2001-07-13 18:00:00	MSFT	Stock	35.7	35.7	35.675	35.675	2200.0
2001-07-13 08:00:00	NVDA	Stock	0.346	0.346	0.3427	0.3427	216000.0
2001-07-13 09:00:00	NVDA	Stock	0.3425	0.3427	0.3302	0.3342	93672000.0
2001-07-13 10:00:00	NVDA	Stock	0.3342	0.3393	0.3305	0.3388	164112000.0
2001-07-13 11:00:00	NVDA	Stock	0.3388	0.3443	0.337	0.3433	117984000.0
2001-07-13 12:00:00	NVDA	Stock	0.3432	0.3457	0.3418	0.3425	66264000.0
2001-07-13 13:00:00	NVDA	Stock	0.3426	0.3442	0.3383	0.3388	72264000.0
2001-07-13 14:00:00	NVDA	Stock	0.3388	0.3395	0.3338	0.3341	48960000.0
2001-07-13 15:00:00	NVDA	Stock	0.3345	0.3382	0.3327	0.3374	92784000.0
2001-07-13 16:00:00	NVDA	Stock	0.3373	0.341	0.3373	0.3373	4536000.0
2001-07-13 17:00:00	NVDA	Stock	0.3373	0.338	0.3373	0.3373	480000.0
2001-07-13 08:00:00	AMZN	Stock	0.824	0.8245	0.8235	0.8245	78000.0
2001-07-13 09:00:00	AMZN	Stock	0.805	0.819	0.805	0.8085	8918000.0
2001-07-13 10:00:00	AMZN	Stock	0.8085	0.822	0.8065	0.815	14134000.0
2001-07-13 11:00:00	AMZN	Stock	0.815	0.8275	0.8115	0.826	11348000.0
2001-07-13 12:00:00	AMZN	Stock	0.826	0.845	0.8255	0.84	34488000.0
2001-07-13 13:00:00	AMZN	Stock	0.84	0.8485	0.8345	0.839	17620000.0
2001-07-13 14:00:00	AMZN	Stock	0.8375	0.8395	0.825	0.835	5930000.0
2001-07-13 15:00:00	AMZN	Stock	0.835	0.85	0.821	0.849	30206000.0
2001-07-13 16:00:00	AMZN	Stock	0.8495	0.857	0.84	0.8545	3658000.0
2001-07-13 17:00:00	AMZN	Stock	0.855	0.8625	0.855	0.861	86000.0
2001-07-13 18:00:00	AMZN	Stock	0.861	0.861	0.861	0.861	18000.0
2001-07-13 09:00:00	CL	Stock	27.125	27.2	27.025	27.05	420400.0
2001-07-13 10:00:00	CL	Stock	27.04	27.26	27.0	27.05	671000.0
2001-07-13 11:00:00	CL	Stock	27.075	27.095	27.0	27.005	367000.0
2001-07-13 12:00:00	CL	Stock	27.005	27.25	27.005	27.225	427600.0
2001-07-13 13:00:00	CL	Stock	27.225	27.355	27.1	27.35	533200.0
2001-07-13 14:00:00	CL	Stock	27.355	27.675	27.345	27.535	957000.0
2001-07-13 15:00:00	CL	Stock	27.535	27.61	27.5	27.605	788400.0

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

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