PREVIEW / stock_1hour / 2006-06-19

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-06-19.parquet
  size:    620 KB
  rows:    29,796
  symbols: 2,292

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
2006-06-19 06:00:00	AAPL	Stock	2.0625	2.0625	2.0625	2.0625	19600.0
2006-06-19 07:00:00	AAPL	Stock	2.0679	2.0696	2.0679	2.0696	25200.0
2006-06-19 08:00:00	AAPL	Stock	2.0682	2.0743	2.0643	2.0668	1724604.0
2006-06-19 09:00:00	AAPL	Stock	2.0671	2.0779	2.0486	2.06	95968628.0
2006-06-19 10:00:00	AAPL	Stock	2.0604	2.0752	2.0357	2.0511	120395100.0
2006-06-19 11:00:00	AAPL	Stock	2.0514	2.0732	2.0482	2.0696	111532204.0
2006-06-19 12:00:00	AAPL	Stock	2.0696	2.0771	2.065	2.0661	69577256.0
2006-06-19 13:00:00	AAPL	Stock	2.0657	2.0671	2.0482	2.0589	103417944.0
2006-06-19 14:00:00	AAPL	Stock	2.0589	2.0632	2.045	2.0457	70948668.0
2006-06-19 15:00:00	AAPL	Stock	2.0457	2.0621	2.0414	2.0439	96793284.0
2006-06-19 16:00:00	AAPL	Stock	2.0432	2.0446	2.0393	2.0407	4244604.0
2006-06-19 17:00:00	AAPL	Stock	2.0404	2.0429	2.0357	2.0393	21049392.0
2006-06-19 18:00:00	AAPL	Stock	2.0393	2.0429	2.0357	2.0368	17090304.0
2006-06-19 07:00:00	MSFT	Stock	22.2	22.2	22.11	22.15	1800.0
2006-06-19 08:00:00	MSFT	Stock	22.15	22.17	22.1	22.15	47487.0
2006-06-19 09:00:00	MSFT	Stock	22.16	22.29	22.12	22.24	12031201.0
2006-06-19 10:00:00	MSFT	Stock	22.23	22.41	22.22	22.313	21214864.0
2006-06-19 11:00:00	MSFT	Stock	22.32	22.4	22.2	22.4	16013296.0
2006-06-19 12:00:00	MSFT	Stock	22.4	22.5	22.36	22.48	13229034.0
2006-06-19 13:00:00	MSFT	Stock	22.49	22.52	22.4	22.46	16912833.0
2006-06-19 14:00:00	MSFT	Stock	22.46	22.54	22.36	22.36	16322454.0
2006-06-19 15:00:00	MSFT	Stock	22.36	22.6	22.35	22.53	28241109.0
2006-06-19 16:00:00	MSFT	Stock	22.52	22.55	22.3	22.55	2787361.0
2006-06-19 17:00:00	MSFT	Stock	22.54	22.55	22.53	22.55	13866.0
2006-06-19 18:00:00	MSFT	Stock	22.6	22.6	22.53	22.54	2950.0
2006-06-19 08:00:00	NVDA	Stock	0.3613	0.365	0.3613	0.3632	556800.0
2006-06-19 09:00:00	NVDA	Stock	0.3645	0.3675	0.3547	0.358	38885940.0
2006-06-19 10:00:00	NVDA	Stock	0.3578	0.3641	0.3512	0.3553	66548160.0
2006-06-19 11:00:00	NVDA	Stock	0.3553	0.3644	0.3553	0.3573	54583500.0
2006-06-19 12:00:00	NVDA	Stock	0.3573	0.3592	0.3567	0.3582	28409280.0
2006-06-19 13:00:00	NVDA	Stock	0.3582	0.3588	0.3542	0.3542	47542800.0
2006-06-19 14:00:00	NVDA	Stock	0.3542	0.3558	0.35	0.3502	43358220.0
2006-06-19 15:00:00	NVDA	Stock	0.3502	0.3525	0.3493	0.35	87313020.0
2006-06-19 16:00:00	NVDA	Stock	0.35	0.351	0.3493	0.3493	384840.0
2006-06-19 17:00:00	NVDA	Stock	0.3497	0.3502	0.3497	0.3502	62760.0
2006-06-19 18:00:00	NVDA	Stock	0.35	0.35	0.3495	0.3495	72000.0
2006-06-19 09:00:00	AMZN	Stock	1.76	1.7655	1.752	1.7585	6092720.0
2006-06-19 10:00:00	AMZN	Stock	1.7595	1.765	1.753	1.7635	13257120.0
2006-06-19 11:00:00	AMZN	Stock	1.7635	1.774	1.763	1.7675	15816540.0
2006-06-19 12:00:00	AMZN	Stock	1.7675	1.7735	1.767	1.7685	6918280.0
2006-06-19 13:00:00	AMZN	Stock	1.768	1.771	1.7525	1.753	12888120.0
2006-06-19 14:00:00	AMZN	Stock	1.7535	1.7605	1.752	1.7575	10368640.0
2006-06-19 15:00:00	AMZN	Stock	1.757	1.762	1.752	1.753	16741020.0
2006-06-19 16:00:00	AMZN	Stock	1.753	1.759	1.753	1.759	208140.0
2006-06-19 17:00:00	AMZN	Stock	1.759	1.759	1.759	1.759	26000.0
2006-06-19 09:00:00	CL	Stock	30.345	30.445	30.23	30.315	357800.0
2006-06-19 10:00:00	CL	Stock	30.33	30.335	30.005	30.055	535400.0
2006-06-19 11:00:00	CL	Stock	30.065	30.33	30.015	30.295	613600.0
2006-06-19 12:00:00	CL	Stock	30.295	30.325	30.22	30.265	502800.0
2006-06-19 13:00:00	CL	Stock	30.245	30.265	30.1	30.135	425800.0

> showing 50 of 29,796 rows — these rows as CSV

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