PREVIEW / stock_1hour / 2006-05-18

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-05-18.parquet
  size:    611 KB
  rows:    29,066
  symbols: 2,267

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-05-18 04:00:00	AAPL	Stock	2.3321	2.3321	2.3321	2.3321	33600.0
2006-05-18 07:00:00	AAPL	Stock	2.3464	2.3464	2.3464	2.3464	16800.0
2006-05-18 08:00:00	AAPL	Stock	2.3464	2.3554	2.3357	2.3475	1623468.0
2006-05-18 09:00:00	AAPL	Stock	2.3475	2.3664	2.3254	2.3314	115403344.0
2006-05-18 10:00:00	AAPL	Stock	2.3314	2.3436	2.3189	2.3254	107125032.0
2006-05-18 11:00:00	AAPL	Stock	2.325	2.3268	2.3114	2.3186	85704752.0
2006-05-18 12:00:00	AAPL	Stock	2.3182	2.3268	2.3154	2.3229	40297460.0
2006-05-18 13:00:00	AAPL	Stock	2.3221	2.3243	2.3161	2.3214	26017180.0
2006-05-18 14:00:00	AAPL	Stock	2.3214	2.325	2.3143	2.3211	38337152.0
2006-05-18 15:00:00	AAPL	Stock	2.3212	2.3212	2.2543	2.2546	228130224.0
2006-05-18 16:00:00	AAPL	Stock	2.2561	2.2693	2.2539	2.2607	4005680.0
2006-05-18 17:00:00	AAPL	Stock	2.2596	2.2671	2.2568	2.2671	1447628.0
2006-05-18 18:00:00	AAPL	Stock	2.2671	2.2671	2.2618	2.2621	305396.0
2006-05-18 05:00:00	MSFT	Stock	22.85	22.85	22.85	22.85	300.0
2006-05-18 07:00:00	MSFT	Stock	22.82	22.82	22.82	22.82	100.0
2006-05-18 08:00:00	MSFT	Stock	22.82	22.85	22.8	22.84	120655.0
2006-05-18 09:00:00	MSFT	Stock	22.84	22.96	22.83	22.96	12467421.0
2006-05-18 10:00:00	MSFT	Stock	22.96	23.02	22.84	22.88	10565242.0
2006-05-18 11:00:00	MSFT	Stock	22.88	22.95	22.76	22.91	8996542.0
2006-05-18 12:00:00	MSFT	Stock	22.91	23.13	22.87	23.06	12300807.0
2006-05-18 13:00:00	MSFT	Stock	23.06	23.14	22.99	23.07	14389439.0
2006-05-18 14:00:00	MSFT	Stock	23.08	23.12	22.95	22.99	11153590.0
2006-05-18 15:00:00	MSFT	Stock	22.98	22.99	22.8	22.81	16427765.0
2006-05-18 16:00:00	MSFT	Stock	22.81	22.93	22.76	22.9	498475.0
2006-05-18 17:00:00	MSFT	Stock	22.9	22.94	22.82	22.92	66836.0
2006-05-18 18:00:00	MSFT	Stock	22.91	22.93	22.91	22.93	2260.0
2006-05-18 07:00:00	NVDA	Stock	0.4188	0.4188	0.4167	0.4167	126000.0
2006-05-18 08:00:00	NVDA	Stock	0.4192	0.4208	0.4175	0.4203	502500.0
2006-05-18 09:00:00	NVDA	Stock	0.4203	0.4233	0.4138	0.4187	58033140.0
2006-05-18 10:00:00	NVDA	Stock	0.4187	0.4215	0.4135	0.4163	68579880.0
2006-05-18 11:00:00	NVDA	Stock	0.4162	0.4168	0.4133	0.414	52850460.0
2006-05-18 12:00:00	NVDA	Stock	0.414	0.4187	0.4098	0.4115	70578960.0
2006-05-18 13:00:00	NVDA	Stock	0.4115	0.4142	0.4083	0.414	73238400.0
2006-05-18 14:00:00	NVDA	Stock	0.4142	0.4143	0.4075	0.4083	71474280.0
2006-05-18 15:00:00	NVDA	Stock	0.4083	0.4085	0.3967	0.3972	233894160.0
2006-05-18 16:00:00	NVDA	Stock	0.3973	0.41	0.397	0.4083	4406760.0
2006-05-18 17:00:00	NVDA	Stock	0.4087	0.4095	0.4018	0.4018	1139700.0
2006-05-18 09:00:00	AMZN	Stock	1.589	1.593	1.576	1.5905	9750040.0
2006-05-18 10:00:00	AMZN	Stock	1.591	1.622	1.586	1.618	27780080.0
2006-05-18 11:00:00	AMZN	Stock	1.618	1.6435	1.6155	1.6375	35387240.0
2006-05-18 12:00:00	AMZN	Stock	1.6375	1.657	1.634	1.65	40338240.0
2006-05-18 13:00:00	AMZN	Stock	1.65	1.68	1.649	1.674	36521260.0
2006-05-18 14:00:00	AMZN	Stock	1.6735	1.682	1.6565	1.6675	35748760.0
2006-05-18 15:00:00	AMZN	Stock	1.6675	1.668	1.626	1.6305	45586180.0
2006-05-18 16:00:00	AMZN	Stock	1.6315	1.636	1.6255	1.6345	1540060.0
2006-05-18 17:00:00	AMZN	Stock	1.63	1.64	1.63	1.64	42700.0
2006-05-18 08:00:00	CL	Stock	30.3	30.35	30.15	30.15	7400.0
2006-05-18 09:00:00	CL	Stock	30.16	30.4	30.125	30.285	1129400.0
2006-05-18 10:00:00	CL	Stock	30.285	30.33	30.13	30.19	1569000.0
2006-05-18 11:00:00	CL	Stock	30.2	30.22	30.06	30.145	2004800.0

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

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