PREVIEW / stock_1hour / 2006-06-21

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-06-21.parquet
  size:    597 KB
  rows:    28,552
  symbols: 2,286

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-21 08:00:00	AAPL	Stock	2.0554	2.0625	2.0536	2.0614	1311380.0
2006-06-21 09:00:00	AAPL	Stock	2.0614	2.0746	2.0468	2.05	98844564.0
2006-06-21 10:00:00	AAPL	Stock	2.05	2.0639	2.0464	2.0504	156811144.0
2006-06-21 11:00:00	AAPL	Stock	2.05	2.0714	2.05	2.0671	127853516.0
2006-06-21 12:00:00	AAPL	Stock	2.0671	2.0782	2.0621	2.0643	93360988.0
2006-06-21 13:00:00	AAPL	Stock	2.0643	2.0793	2.0632	2.0732	71821736.0
2006-06-21 14:00:00	AAPL	Stock	2.0729	2.0968	2.0729	2.0918	126690032.0
2006-06-21 15:00:00	AAPL	Stock	2.0917	2.0936	2.0625	2.0654	161849576.0
2006-06-21 16:00:00	AAPL	Stock	2.065	2.0671	2.0636	2.0664	15393196.0
2006-06-21 17:00:00	AAPL	Stock	2.0664	2.07	2.0664	2.0671	666904.0
2006-06-21 18:00:00	AAPL	Stock	2.0675	2.0675	2.0607	2.0607	673848.0
2006-06-21 08:00:00	MSFT	Stock	22.55	22.67	22.55	22.59	7882.0
2006-06-21 09:00:00	MSFT	Stock	22.64	22.79	22.53	22.72	8788763.0
2006-06-21 10:00:00	MSFT	Stock	22.73	22.89	22.7	22.85	16207972.0
2006-06-21 11:00:00	MSFT	Stock	22.86	22.94	22.84	22.882	9484883.0
2006-06-21 12:00:00	MSFT	Stock	22.89	22.92	22.87	22.912	6228589.0
2006-06-21 13:00:00	MSFT	Stock	22.91	22.98	22.89	22.97	10848039.0
2006-06-21 14:00:00	MSFT	Stock	22.97	23.15	22.95	23.11	15438767.0
2006-06-21 15:00:00	MSFT	Stock	23.11	23.15	22.99	23.07	16820129.0
2006-06-21 16:00:00	MSFT	Stock	23.07	23.11	22.992	23.09	2112079.0
2006-06-21 17:00:00	MSFT	Stock	23.09	23.12	23.08	23.12	5965.0
2006-06-21 18:00:00	MSFT	Stock	23.09	23.1	23.079	23.09	2747279.0
2006-06-21 09:00:00	NVDA	Stock	0.3457	0.3485	0.3432	0.3472	60158400.0
2006-06-21 10:00:00	NVDA	Stock	0.3472	0.3513	0.3465	0.3487	88546680.0
2006-06-21 11:00:00	NVDA	Stock	0.3487	0.3527	0.3485	0.352	50301840.0
2006-06-21 12:00:00	NVDA	Stock	0.352	0.354	0.351	0.3515	39982020.0
2006-06-21 13:00:00	NVDA	Stock	0.3515	0.3518	0.3493	0.3513	54278340.0
2006-06-21 14:00:00	NVDA	Stock	0.3513	0.3527	0.35	0.3512	45667380.0
2006-06-21 15:00:00	NVDA	Stock	0.3512	0.3512	0.3468	0.3483	85133040.0
2006-06-21 16:00:00	NVDA	Stock	0.3483	0.3502	0.3483	0.3485	952260.0
2006-06-21 17:00:00	NVDA	Stock	0.3485	0.3485	0.3485	0.3485	32460.0
2006-06-21 18:00:00	NVDA	Stock	0.3485	0.3485	0.3485	0.3485	15480.0
2006-06-21 05:00:00	AMZN	Stock	1.7695	1.7695	1.7695	1.7695	17000.0
2006-06-21 09:00:00	AMZN	Stock	1.7725	1.793	1.767	1.7885	8623720.0
2006-06-21 10:00:00	AMZN	Stock	1.788	1.85	1.7875	1.821	36972100.0
2006-06-21 11:00:00	AMZN	Stock	1.821	1.8475	1.821	1.836	31120000.0
2006-06-21 12:00:00	AMZN	Stock	1.836	1.8495	1.8355	1.8485	14736840.0
2006-06-21 13:00:00	AMZN	Stock	1.8485	1.8515	1.8445	1.8485	14010460.0
2006-06-21 14:00:00	AMZN	Stock	1.8485	1.8525	1.843	1.8495	15241040.0
2006-06-21 15:00:00	AMZN	Stock	1.849	1.8515	1.8295	1.8325	30339120.0
2006-06-21 16:00:00	AMZN	Stock	1.8315	1.839	1.821	1.83	2603560.0
2006-06-21 17:00:00	AMZN	Stock	1.8275	1.8275	1.8275	1.8275	45200.0
2006-06-21 18:00:00	AMZN	Stock	1.8275	1.8324	1.8275	1.83	114400.0
2006-06-21 09:00:00	CL	Stock	30.235	30.3	30.0605	30.29	670200.0
2006-06-21 10:00:00	CL	Stock	30.26	30.31	30.13	30.21	1105000.0
2006-06-21 11:00:00	CL	Stock	30.21	30.235	30.1	30.185	619200.0
2006-06-21 12:00:00	CL	Stock	30.19	30.285	30.175	30.275	489800.0
2006-06-21 13:00:00	CL	Stock	30.275	30.315	30.1	30.14	439000.0
2006-06-21 14:00:00	CL	Stock	30.123	30.27	30.115	30.24	391600.0
2006-06-21 15:00:00	CL	Stock	30.245	30.28	30.17	30.175	871000.0

> showing 50 of 28,552 rows — these rows as CSV

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