PREVIEW / stock_1hour / 2007-06-01

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-06-01.parquet
  size:    649 KB
  rows:    30,215
  symbols: 2,650

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
2007-06-01 07:00:00	AAPL	Stock	4.3168	4.3196	4.3107	4.3143	40320.0
2007-06-01 08:00:00	AAPL	Stock	4.3136	4.3457	4.3107	4.3368	6639976.0
2007-06-01 09:00:00	AAPL	Stock	4.3357	4.3357	4.2432	4.2743	176573964.0
2007-06-01 10:00:00	AAPL	Stock	4.2732	4.3246	4.2579	4.265	171843420.0
2007-06-01 11:00:00	AAPL	Stock	4.2657	4.2821	4.25	4.2579	95471880.0
2007-06-01 12:00:00	AAPL	Stock	4.2582	4.2654	4.2275	4.2443	113105048.0
2007-06-01 13:00:00	AAPL	Stock	4.2439	4.2636	4.2246	4.2475	102678240.0
2007-06-01 14:00:00	AAPL	Stock	4.2471	4.2631	4.2393	4.2525	76561800.0
2007-06-01 15:00:00	AAPL	Stock	4.2529	4.2571	4.225	4.2268	125143172.0
2007-06-01 16:00:00	AAPL	Stock	4.2282	4.2571	4.2275	4.2329	3500000.0
2007-06-01 17:00:00	AAPL	Stock	4.2325	4.2389	4.2307	4.2357	748720.0
2007-06-01 18:00:00	AAPL	Stock	4.2389	4.2389	4.2311	4.2375	137788.0
2007-06-01 19:00:00	AAPL	Stock	4.2375	4.2439	4.2321	4.2382	573356.0
2007-06-01 08:00:00	MSFT	Stock	30.78	30.84	30.75	30.78	39084.0
2007-06-01 09:00:00	MSFT	Stock	30.77	30.9	30.77	30.85	4353474.0
2007-06-01 10:00:00	MSFT	Stock	30.84	30.89	30.62	30.66	7868880.0
2007-06-01 11:00:00	MSFT	Stock	30.67	30.73	30.59	30.6	4662863.0
2007-06-01 12:00:00	MSFT	Stock	30.6	30.68	30.55	30.65	4459191.0
2007-06-01 13:00:00	MSFT	Stock	30.65	30.74	30.61	30.72	3972252.0
2007-06-01 14:00:00	MSFT	Stock	30.72	30.74	30.67	30.7	3472541.0
2007-06-01 15:00:00	MSFT	Stock	30.7	30.79	30.56	30.6	7602920.0
2007-06-01 16:00:00	MSFT	Stock	30.61	30.7628	30.6	30.67	581211.0
2007-06-01 17:00:00	MSFT	Stock	30.65	30.67	30.65	30.65	16500.0
2007-06-01 18:00:00	MSFT	Stock	30.65	30.65	30.65	30.65	5322.0
2007-06-01 19:00:00	MSFT	Stock	30.63	30.64	30.6	30.64	7954.0
2007-06-01 08:00:00	NVDA	Stock	0.5825	0.5883	0.5778	0.5848	1637520.0
2007-06-01 09:00:00	NVDA	Stock	0.5872	0.5925	0.5773	0.5876	63699000.0
2007-06-01 10:00:00	NVDA	Stock	0.5877	0.591	0.5858	0.5867	50492580.0
2007-06-01 11:00:00	NVDA	Stock	0.5868	0.591	0.5868	0.5883	51645300.0
2007-06-01 12:00:00	NVDA	Stock	0.5883	0.5885	0.581	0.582	74233620.0
2007-06-01 13:00:00	NVDA	Stock	0.5818	0.5837	0.5813	0.5827	42188640.0
2007-06-01 14:00:00	NVDA	Stock	0.5827	0.5837	0.5813	0.5832	45921900.0
2007-06-01 15:00:00	NVDA	Stock	0.5833	0.5835	0.5803	0.5812	77423280.0
2007-06-01 16:00:00	NVDA	Stock	0.581	0.5817	0.5795	0.5813	1925280.0
2007-06-01 19:00:00	NVDA	Stock	0.5815	0.5815	0.5815	0.5815	42000.0
2007-06-01 08:00:00	AMZN	Stock	3.48	3.48	3.457	3.457	839760.0
2007-06-01 09:00:00	AMZN	Stock	3.4595	3.48	3.4275	3.4472	20565740.0
2007-06-01 10:00:00	AMZN	Stock	3.448	3.4585	3.4205	3.4305	28671580.0
2007-06-01 11:00:00	AMZN	Stock	3.43	3.448	3.424	3.4465	16619380.0
2007-06-01 12:00:00	AMZN	Stock	3.4465	3.4525	3.421	3.431	16011200.0
2007-06-01 13:00:00	AMZN	Stock	3.431	3.4335	3.4175	3.4295	13790120.0
2007-06-01 14:00:00	AMZN	Stock	3.429	3.434	3.425	3.43	15247820.0
2007-06-01 15:00:00	AMZN	Stock	3.4295	3.4435	3.4215	3.4315	23968560.0
2007-06-01 16:00:00	AMZN	Stock	3.429	3.436	3.4285	3.43	522460.0
2007-06-01 17:00:00	AMZN	Stock	3.428	3.428	3.428	3.428	4000.0
2007-06-01 18:00:00	AMZN	Stock	3.429	3.43	3.429	3.43	18000.0
2007-06-01 19:00:00	AMZN	Stock	3.43	3.43	3.4295	3.4295	9500.0
2007-06-01 08:00:00	CL	Stock	33.48	33.48	33.48	33.48	400.0
2007-06-01 09:00:00	CL	Stock	33.475	33.575	33.405	33.545	267632.0
2007-06-01 10:00:00	CL	Stock	33.545	33.62	33.5	33.55	710000.0

> showing 50 of 30,215 rows — these rows as CSV

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