PREVIEW / stock_1hour / 2001-08-31

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-08-31.parquet
  size:    366 KB
  rows:    17,735
  symbols: 1,325

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-08-31 08:00:00	AAPL	Stock	0.3183	0.3188	0.318	0.3182	834400.0
2001-08-31 09:00:00	AAPL	Stock	0.3184	0.3205	0.3152	0.3164	22691200.0
2001-08-31 10:00:00	AAPL	Stock	0.3166	0.325	0.3157	0.3189	39911200.0
2001-08-31 11:00:00	AAPL	Stock	0.3188	0.3216	0.317	0.3173	11491200.0
2001-08-31 12:00:00	AAPL	Stock	0.3175	0.3196	0.3161	0.3182	11620000.0
2001-08-31 13:00:00	AAPL	Stock	0.3184	0.323	0.3184	0.3214	12902400.0
2001-08-31 14:00:00	AAPL	Stock	0.3218	0.3268	0.3196	0.3229	29181600.0
2001-08-31 15:00:00	AAPL	Stock	0.3229	0.3321	0.3196	0.3302	60121600.0
2001-08-31 16:00:00	AAPL	Stock	0.3302	0.3436	0.3189	0.3189	10561600.0
2001-08-31 17:00:00	AAPL	Stock	0.3313	0.3332	0.3313	0.3313	442400.0
2001-08-31 18:00:00	AAPL	Stock	0.3313	0.3313	0.3313	0.3313	22400.0
2001-08-31 08:00:00	MSFT	Stock	28.295	28.535	28.295	28.4	259000.0
2001-08-31 09:00:00	MSFT	Stock	28.4	28.59	28.15	28.4	8948600.0
2001-08-31 10:00:00	MSFT	Stock	28.4	29.03	28.38	28.51	13891000.0
2001-08-31 11:00:00	MSFT	Stock	28.52	28.935	28.38	28.42	8095200.0
2001-08-31 12:00:00	MSFT	Stock	28.44	28.7	28.255	28.62	5622800.0
2001-08-31 13:00:00	MSFT	Stock	28.62	28.7855	28.58	28.68	4486800.0
2001-08-31 14:00:00	MSFT	Stock	28.685	28.735	28.5	28.51	4041200.0
2001-08-31 15:00:00	MSFT	Stock	28.51	28.685	28.51	28.525	5266600.0
2001-08-31 16:00:00	MSFT	Stock	28.54	28.65	28.52	28.525	3728400.0
2001-08-31 17:00:00	MSFT	Stock	28.525	28.67	28.525	28.525	76800.0
2001-08-31 18:00:00	MSFT	Stock	28.525	28.65	28.525	28.65	16200.0
2001-08-31 08:00:00	NVDA	Stock	0.3459	0.3459	0.3459	0.3459	360000.0
2001-08-31 09:00:00	NVDA	Stock	0.349	0.3492	0.3431	0.3445	110088000.0
2001-08-31 10:00:00	NVDA	Stock	0.3446	0.3562	0.3446	0.3513	344880000.0
2001-08-31 11:00:00	NVDA	Stock	0.3513	0.3542	0.3495	0.3498	84984000.0
2001-08-31 12:00:00	NVDA	Stock	0.3505	0.3533	0.3481	0.3512	77256000.0
2001-08-31 13:00:00	NVDA	Stock	0.3516	0.3547	0.3509	0.3539	37464000.0
2001-08-31 14:00:00	NVDA	Stock	0.3535	0.3555	0.349	0.349	81048000.0
2001-08-31 15:00:00	NVDA	Stock	0.349	0.3552	0.3479	0.3529	101664000.0
2001-08-31 16:00:00	NVDA	Stock	0.353	0.3546	0.3527	0.3535	11376000.0
2001-08-31 17:00:00	NVDA	Stock	0.353	0.3535	0.3509	0.3535	2112000.0
2001-08-31 18:00:00	NVDA	Stock	0.3528	0.3528	0.3525	0.3525	120000.0
2001-08-31 08:00:00	AMZN	Stock	0.4348	0.4401	0.4348	0.4355	120000.0
2001-08-31 09:00:00	AMZN	Stock	0.44	0.4545	0.4345	0.4425	10556000.0
2001-08-31 10:00:00	AMZN	Stock	0.4425	0.4625	0.4425	0.4485	17320000.0
2001-08-31 11:00:00	AMZN	Stock	0.4485	0.4525	0.441	0.445	9418000.0
2001-08-31 12:00:00	AMZN	Stock	0.445	0.455	0.44	0.453	8724000.0
2001-08-31 13:00:00	AMZN	Stock	0.4525	0.4535	0.4485	0.452	5454000.0
2001-08-31 14:00:00	AMZN	Stock	0.451	0.453	0.4445	0.4495	6528000.0
2001-08-31 15:00:00	AMZN	Stock	0.449	0.4555	0.445	0.4465	7592000.0
2001-08-31 16:00:00	AMZN	Stock	0.447	0.45	0.4465	0.447	1744000.0
2001-08-31 17:00:00	AMZN	Stock	0.4494	0.4494	0.447	0.447	248000.0
2001-08-31 18:00:00	AMZN	Stock	0.454	0.454	0.454	0.454	2000.0
2001-08-31 09:00:00	CL	Stock	26.825	27.3	26.825	27.3	333400.0
2001-08-31 10:00:00	CL	Stock	27.305	27.405	27.235	27.24	365000.0
2001-08-31 11:00:00	CL	Stock	27.23	27.32	27.15	27.155	125800.0
2001-08-31 12:00:00	CL	Stock	27.15	27.315	27.09	27.195	141200.0
2001-08-31 13:00:00	CL	Stock	27.2	27.325	27.15	27.26	164600.0
2001-08-31 14:00:00	CL	Stock	27.25	27.265	27.135	27.195	123200.0

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

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