PREVIEW / stock_1hour / 2006-12-01

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-12-01.parquet
  size:    651 KB
  rows:    30,880
  symbols: 2,449

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-12-01 07:00:00	AAPL	Stock	3.2821	3.2886	3.2821	3.2886	47460.0
2006-12-01 08:00:00	AAPL	Stock	3.2925	3.2929	3.2736	3.2789	2455768.0
2006-12-01 09:00:00	AAPL	Stock	3.2786	3.2975	3.2725	3.275	83734868.0
2006-12-01 10:00:00	AAPL	Stock	3.2757	3.2768	3.2179	3.2468	217234780.0
2006-12-01 11:00:00	AAPL	Stock	3.2468	3.2786	3.2404	3.2754	116773832.0
2006-12-01 12:00:00	AAPL	Stock	3.2754	3.2796	3.2571	3.2732	79290148.0
2006-12-01 13:00:00	AAPL	Stock	3.2735	3.275	3.245	3.2593	77250348.0
2006-12-01 14:00:00	AAPL	Stock	3.2586	3.2823	3.2393	3.2506	98377496.0
2006-12-01 15:00:00	AAPL	Stock	3.2507	3.2625	3.2468	3.2604	108269812.0
2006-12-01 16:00:00	AAPL	Stock	3.2614	3.2646	3.2518	3.2589	1868692.0
2006-12-01 17:00:00	AAPL	Stock	3.2636	3.2636	3.2589	3.2629	225148.0
2006-12-01 18:00:00	AAPL	Stock	3.2625	3.2629	3.2618	3.2621	264460.0
2006-12-01 19:00:00	AAPL	Stock	3.2625	3.2639	3.2611	3.2639	133812.0
2006-12-01 06:00:00	MSFT	Stock	29.4	29.4	29.4	29.4	1283.0
2006-12-01 07:00:00	MSFT	Stock	29.4	29.4	29.4	29.4	5000.0
2006-12-01 08:00:00	MSFT	Stock	29.4	29.4	29.33	29.33	6000.0
2006-12-01 09:00:00	MSFT	Stock	29.32	29.33	29.12	29.18	6479423.0
2006-12-01 10:00:00	MSFT	Stock	29.18	29.21	28.93	29.05	17471806.0
2006-12-01 11:00:00	MSFT	Stock	29.04	29.15	29.03	29.11	5750520.0
2006-12-01 12:00:00	MSFT	Stock	29.11	29.14	28.94	28.989	7955391.0
2006-12-01 13:00:00	MSFT	Stock	28.98	29.0	28.9	28.975	8242984.0
2006-12-01 14:00:00	MSFT	Stock	28.97	29.0	28.9	28.98	7828821.0
2006-12-01 15:00:00	MSFT	Stock	28.98	29.11	28.97	29.11	13852645.0
2006-12-01 16:00:00	MSFT	Stock	29.12	29.15	29.09	29.14	231819.0
2006-12-01 17:00:00	MSFT	Stock	29.15	29.15	29.027	29.14	30417.0
2006-12-01 18:00:00	MSFT	Stock	29.14	29.14	29.14	29.14	4300.0
2006-12-01 19:00:00	MSFT	Stock	29.15	29.15	29.15	29.15	1146.0
2006-12-01 08:00:00	NVDA	Stock	0.6142	0.615	0.6133	0.6133	246000.0
2006-12-01 09:00:00	NVDA	Stock	0.6138	0.6225	0.5965	0.6007	114906960.0
2006-12-01 10:00:00	NVDA	Stock	0.6005	0.601	0.5888	0.5987	197844720.0
2006-12-01 11:00:00	NVDA	Stock	0.5987	0.6042	0.5967	0.6008	118338180.0
2006-12-01 12:00:00	NVDA	Stock	0.6008	0.6022	0.5963	0.5967	58657080.0
2006-12-01 13:00:00	NVDA	Stock	0.5967	0.5967	0.5912	0.5927	74784540.0
2006-12-01 14:00:00	NVDA	Stock	0.5928	0.5935	0.587	0.59	87338100.0
2006-12-01 15:00:00	NVDA	Stock	0.59	0.5938	0.5883	0.592	113583660.0
2006-12-01 16:00:00	NVDA	Stock	0.5923	0.5933	0.5918	0.5933	765660.0
2006-12-01 17:00:00	NVDA	Stock	0.5923	0.5942	0.5917	0.5922	1660560.0
2006-12-01 18:00:00	NVDA	Stock	0.5928	0.5997	0.5928	0.5997	596400.0
2006-12-01 19:00:00	NVDA	Stock	0.5983	0.6022	0.5933	0.5983	203460.0
2006-12-01 08:00:00	AMZN	Stock	2.017	2.017	2.017	2.017	304000.0
2006-12-01 09:00:00	AMZN	Stock	2.0165	2.027	1.99	1.9965	11641620.0
2006-12-01 10:00:00	AMZN	Stock	1.9965	1.9975	1.963	1.975	33776040.0
2006-12-01 11:00:00	AMZN	Stock	1.9755	1.983	1.9645	1.9795	27293460.0
2006-12-01 12:00:00	AMZN	Stock	1.98	1.98	1.967	1.9715	13129980.0
2006-12-01 13:00:00	AMZN	Stock	1.9715	1.9725	1.9585	1.9615	13046260.0
2006-12-01 14:00:00	AMZN	Stock	1.9615	1.9655	1.9545	1.956	26180720.0
2006-12-01 15:00:00	AMZN	Stock	1.956	1.978	1.955	1.9705	35448700.0
2006-12-01 16:00:00	AMZN	Stock	1.9725	1.9725	1.97	1.97	287900.0
2006-12-01 17:00:00	AMZN	Stock	1.9705	1.9718	1.9687	1.9687	207200.0
2006-12-01 18:00:00	AMZN	Stock	1.966	1.9665	1.966	1.966	22100.0

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

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