PREVIEW / stock_1hour / 2006-04-27

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-04-27.parquet
  size:    601 KB
  rows:    28,315
  symbols: 2,237

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-04-27 07:00:00	AAPL	Stock	2.4196	2.4196	2.4143	2.4143	14000.0
2006-04-27 08:00:00	AAPL	Stock	2.4136	2.4211	2.4125	2.415	1685320.0
2006-04-27 09:00:00	AAPL	Stock	2.4168	2.4339	2.4054	2.4236	102155228.0
2006-04-27 10:00:00	AAPL	Stock	2.4232	2.4514	2.4179	2.4421	179126808.0
2006-04-27 11:00:00	AAPL	Stock	2.4421	2.4782	2.4357	2.4714	137864664.0
2006-04-27 12:00:00	AAPL	Stock	2.4718	2.485	2.4707	2.48	91037408.0
2006-04-27 13:00:00	AAPL	Stock	2.4796	2.48	2.4654	2.4704	70399392.0
2006-04-27 14:00:00	AAPL	Stock	2.4704	2.495	2.4668	2.4907	127895768.0
2006-04-27 15:00:00	AAPL	Stock	2.4904	2.4929	2.4632	2.4743	124388320.0
2006-04-27 16:00:00	AAPL	Stock	2.4768	2.4786	2.4632	2.4632	1085476.0
2006-04-27 17:00:00	AAPL	Stock	2.4679	2.4696	2.4636	2.4661	418068.0
2006-04-27 18:00:00	AAPL	Stock	2.4661	2.4679	2.4661	2.4679	63000.0
2006-04-27 06:00:00	MSFT	Stock	27.01	27.03	26.9	26.9	1800.0
2006-04-27 07:00:00	MSFT	Stock	26.97	26.97	26.97	26.97	2000.0
2006-04-27 08:00:00	MSFT	Stock	26.97	27.02	26.96	27.0	67786.0
2006-04-27 09:00:00	MSFT	Stock	27.0	27.1	26.94	27.09	5988520.0
2006-04-27 10:00:00	MSFT	Stock	27.09	27.27	27.08	27.25	13559381.0
2006-04-27 11:00:00	MSFT	Stock	27.24	27.63	27.23	27.51	12566743.0
2006-04-27 12:00:00	MSFT	Stock	27.52	27.6	27.48	27.56	5746123.0
2006-04-27 13:00:00	MSFT	Stock	27.56	27.58	27.42	27.43	4196696.0
2006-04-27 14:00:00	MSFT	Stock	27.43	27.57	27.4	27.48	6480042.0
2006-04-27 15:00:00	MSFT	Stock	27.49	27.5	27.25	27.28	17263175.0
2006-04-27 16:00:00	MSFT	Stock	27.29	27.6	25.65	25.78	16926169.0
2006-04-27 17:00:00	MSFT	Stock	25.78	25.84	25.5	25.53	13216924.0
2006-04-27 18:00:00	MSFT	Stock	25.53	25.58	25.48	25.5	3254294.0
2006-04-27 08:00:00	NVDA	Stock	0.4732	0.4732	0.4732	0.4732	12000.0
2006-04-27 09:00:00	NVDA	Stock	0.4748	0.4785	0.4663	0.4707	57613320.0
2006-04-27 10:00:00	NVDA	Stock	0.4707	0.4787	0.4692	0.4742	100210320.0
2006-04-27 11:00:00	NVDA	Stock	0.4742	0.4852	0.4735	0.4852	69134640.0
2006-04-27 12:00:00	NVDA	Stock	0.4852	0.4907	0.4843	0.4867	68335680.0
2006-04-27 13:00:00	NVDA	Stock	0.487	0.4887	0.4852	0.4872	45308580.0
2006-04-27 14:00:00	NVDA	Stock	0.4872	0.4905	0.4857	0.4888	45467400.0
2006-04-27 15:00:00	NVDA	Stock	0.4887	0.4898	0.4837	0.4862	56066700.0
2006-04-27 16:00:00	NVDA	Stock	0.4862	0.487	0.4817	0.4823	1676880.0
2006-04-27 17:00:00	NVDA	Stock	0.4818	0.4842	0.4815	0.4842	90000.0
2006-04-27 08:00:00	AMZN	Stock	1.7705	1.771	1.7705	1.771	8000.0
2006-04-27 09:00:00	AMZN	Stock	1.782	1.785	1.765	1.7745	10516420.0
2006-04-27 10:00:00	AMZN	Stock	1.7745	1.792	1.7735	1.786	24538740.0
2006-04-27 11:00:00	AMZN	Stock	1.786	1.7925	1.7825	1.791	21303380.0
2006-04-27 12:00:00	AMZN	Stock	1.791	1.7935	1.789	1.79	10558540.0
2006-04-27 13:00:00	AMZN	Stock	1.79	1.7915	1.7865	1.789	12001760.0
2006-04-27 14:00:00	AMZN	Stock	1.7895	1.792	1.7855	1.7895	12933660.0
2006-04-27 15:00:00	AMZN	Stock	1.79	1.7915	1.787	1.787	24241960.0
2006-04-27 16:00:00	AMZN	Stock	1.787	1.7891	1.7835	1.7835	277120.0
2006-04-27 17:00:00	AMZN	Stock	1.7835	1.794	1.7835	1.794	50000.0
2006-04-27 18:00:00	AMZN	Stock	1.7835	1.7835	1.7835	1.7835	8000.0
2006-04-27 09:00:00	CL	Stock	29.48	29.87	29.445	29.74	1110200.0
2006-04-27 10:00:00	CL	Stock	29.735	29.865	29.475	29.68	1413800.0
2006-04-27 11:00:00	CL	Stock	29.678	29.685	29.475	29.59	1107400.0
2006-04-27 12:00:00	CL	Stock	29.59	29.67	29.525	29.65	788000.0

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

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