PREVIEW / stock_1hour / 2005-07-14

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-07-14.parquet
  size:    552 KB
  rows:    26,340
  symbols: 2,026

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
2005-07-14 07:00:00	AAPL	Stock	1.425	1.4521	1.425	1.4446	4393844.0
2005-07-14 08:00:00	AAPL	Stock	1.4429	1.4593	1.4375	1.4554	74502848.0
2005-07-14 09:00:00	AAPL	Stock	1.4554	1.5004	1.4514	1.48	637355740.0
2005-07-14 10:00:00	AAPL	Stock	1.48	1.4875	1.4661	1.4739	401134272.0
2005-07-14 11:00:00	AAPL	Stock	1.4739	1.4829	1.4679	1.4768	202141268.0
2005-07-14 12:00:00	AAPL	Stock	1.4768	1.4839	1.4739	1.4807	99502984.0
2005-07-14 13:00:00	AAPL	Stock	1.4807	1.4857	1.4611	1.4689	192063564.0
2005-07-14 14:00:00	AAPL	Stock	1.4686	1.4707	1.4368	1.4389	252410256.0
2005-07-14 15:00:00	AAPL	Stock	1.4386	1.4589	1.4386	1.4554	213617152.0
2005-07-14 16:00:00	AAPL	Stock	1.4557	1.4693	1.4521	1.4521	9271836.0
2005-07-14 17:00:00	AAPL	Stock	1.4521	1.4546	1.4511	1.4518	796824.0
2005-07-14 18:00:00	AAPL	Stock	1.4518	1.4518	1.4514	1.4518	128128.0
2005-07-14 08:00:00	MSFT	Stock	25.75	25.8	25.68	25.8	65207.0
2005-07-14 09:00:00	MSFT	Stock	25.8	25.9	25.78	25.84	7497365.0
2005-07-14 10:00:00	MSFT	Stock	25.83	25.997	25.83	25.95	11933545.0
2005-07-14 11:00:00	MSFT	Stock	25.95	25.99	25.87	25.98	6642226.0
2005-07-14 12:00:00	MSFT	Stock	25.97	26.0	25.95	25.97	8605645.0
2005-07-14 13:00:00	MSFT	Stock	25.98	26.01	25.95	25.978	10465425.0
2005-07-14 14:00:00	MSFT	Stock	25.98	26.0	25.93	25.989	6571340.0
2005-07-14 15:00:00	MSFT	Stock	25.982	26.1	25.93	25.98	15746710.0
2005-07-14 16:00:00	MSFT	Stock	25.98	25.99	25.91	25.97	768897.0
2005-07-14 17:00:00	MSFT	Stock	25.96	26.0	25.95	25.97	10000.0
2005-07-14 18:00:00	MSFT	Stock	25.97	25.97	25.94	25.94	8900.0
2005-07-14 08:00:00	NVDA	Stock	0.2379	0.2396	0.2354	0.2395	864000.0
2005-07-14 09:00:00	NVDA	Stock	0.2387	0.2442	0.2383	0.2385	152444400.0
2005-07-14 10:00:00	NVDA	Stock	0.2384	0.2393	0.2335	0.2366	276011880.0
2005-07-14 11:00:00	NVDA	Stock	0.2366	0.2385	0.232	0.2328	360321960.0
2005-07-14 12:00:00	NVDA	Stock	0.2328	0.2342	0.2281	0.2291	284507400.0
2005-07-14 13:00:00	NVDA	Stock	0.2292	0.2319	0.2292	0.2301	220137360.0
2005-07-14 14:00:00	NVDA	Stock	0.2301	0.2302	0.2267	0.2273	269404320.0
2005-07-14 15:00:00	NVDA	Stock	0.2274	0.2283	0.2262	0.2264	268731000.0
2005-07-14 16:00:00	NVDA	Stock	0.2262	0.2329	0.2258	0.2265	3291840.0
2005-07-14 17:00:00	NVDA	Stock	0.2267	0.2272	0.2267	0.2272	643200.0
2005-07-14 18:00:00	NVDA	Stock	0.2272	0.2272	0.2272	0.2272	199200.0
2005-07-14 08:00:00	AMZN	Stock	1.824	1.835	1.824	1.835	65080.0
2005-07-14 09:00:00	AMZN	Stock	1.83	1.8615	1.829	1.847	21464960.0
2005-07-14 10:00:00	AMZN	Stock	1.8465	1.8505	1.844	1.8485	18809720.0
2005-07-14 11:00:00	AMZN	Stock	1.8485	1.8545	1.8475	1.853	11415460.0
2005-07-14 12:00:00	AMZN	Stock	1.8533	1.855	1.8515	1.852	10755340.0
2005-07-14 13:00:00	AMZN	Stock	1.852	1.8555	1.85	1.855	10098780.0
2005-07-14 14:00:00	AMZN	Stock	1.855	1.858	1.8525	1.855	13534220.0
2005-07-14 15:00:00	AMZN	Stock	1.854	1.871	1.854	1.86	29201080.0
2005-07-14 16:00:00	AMZN	Stock	1.86	1.862	1.854	1.857	855600.0
2005-07-14 17:00:00	AMZN	Stock	1.8545	1.8625	1.8545	1.8625	14600.0
2005-07-14 09:00:00	CL	Stock	25.595	25.75	25.595	25.735	379400.0
2005-07-14 10:00:00	CL	Stock	25.735	25.76	25.665	25.7	392200.0
2005-07-14 11:00:00	CL	Stock	25.7	25.795	25.675	25.76	321000.0
2005-07-14 12:00:00	CL	Stock	25.775	25.82	25.685	25.705	391200.0
2005-07-14 13:00:00	CL	Stock	25.705	25.77	25.665	25.675	360400.0
2005-07-14 14:00:00	CL	Stock	25.67	25.685	25.55	25.595	417600.0

> showing 50 of 26,340 rows — these rows as CSV

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