PREVIEW / stock_1hour / 2007-11-20

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-11-20.parquet
  size:    809 KB
  rows:    39,956
  symbols: 3,212

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-11-20 06:00:00	AAPL	Stock	5.9525	6.0175	5.9525	6.0175	173124.0
2007-11-20 07:00:00	AAPL	Stock	6.0175	6.0175	5.9179	5.9636	1432340.0
2007-11-20 08:00:00	AAPL	Stock	5.9518	5.9814	5.8993	5.9286	7989240.0
2007-11-20 09:00:00	AAPL	Stock	5.9286	6.0554	5.8936	6.0393	172349464.0
2007-11-20 10:00:00	AAPL	Stock	6.0397	6.1139	6.0275	6.1111	253598408.0
2007-11-20 11:00:00	AAPL	Stock	6.1107	6.1354	6.0743	6.0829	155182748.0
2007-11-20 12:00:00	AAPL	Stock	6.0836	6.0918	5.9957	6.0121	185874052.0
2007-11-20 13:00:00	AAPL	Stock	6.013	6.0214	5.9218	6.0071	191778188.0
2007-11-20 14:00:00	AAPL	Stock	6.0068	6.0429	5.8779	5.9161	268852920.0
2007-11-20 15:00:00	AAPL	Stock	5.9143	6.0732	5.8404	6.0287	295457428.0
2007-11-20 16:00:00	AAPL	Stock	6.0332	6.05	5.9634	6.0321	7658728.0
2007-11-20 17:00:00	AAPL	Stock	6.0321	6.05	6.0304	6.0429	1777244.0
2007-11-20 18:00:00	AAPL	Stock	6.0429	6.0471	6.0279	6.0396	622888.0
2007-11-20 19:00:00	AAPL	Stock	6.0396	6.0396	6.0143	6.0196	885640.0
2007-11-20 07:00:00	MSFT	Stock	34.2	34.2	34.11	34.12	1000.0
2007-11-20 08:00:00	MSFT	Stock	34.1	34.35	34.09	34.13	101875.0
2007-11-20 09:00:00	MSFT	Stock	34.13	34.62	33.96	34.54	8609839.0
2007-11-20 10:00:00	MSFT	Stock	34.54	34.82	34.36	34.73	11989798.0
2007-11-20 11:00:00	MSFT	Stock	34.73	34.85	34.67	34.803	8467316.0
2007-11-20 12:00:00	MSFT	Stock	34.8	34.97	34.74	34.828	11693160.0
2007-11-20 13:00:00	MSFT	Stock	34.8	34.81	34.53	34.58	14265950.0
2007-11-20 14:00:00	MSFT	Stock	34.58	34.65	34.39	34.43	17748159.0
2007-11-20 15:00:00	MSFT	Stock	34.43	34.82	34.37	34.63	23777426.0
2007-11-20 16:00:00	MSFT	Stock	34.63	34.85	34.56	34.63	1828407.0
2007-11-20 17:00:00	MSFT	Stock	34.65	34.747	34.58	34.58	1513871.0
2007-11-20 18:00:00	MSFT	Stock	34.73	34.73	34.7	34.71	2754.0
2007-11-20 19:00:00	MSFT	Stock	34.68	34.7	34.65	34.7	10169.0
2007-11-20 08:00:00	NVDA	Stock	0.772	0.7975	0.76	0.7675	689160.0
2007-11-20 09:00:00	NVDA	Stock	0.7655	0.772	0.762	0.7684	49897000.0
2007-11-20 10:00:00	NVDA	Stock	0.7688	0.7705	0.7575	0.7678	79573280.0
2007-11-20 11:00:00	NVDA	Stock	0.768	0.7713	0.7645	0.7645	50928600.0
2007-11-20 12:00:00	NVDA	Stock	0.7645	0.7665	0.7433	0.748	70294240.0
2007-11-20 13:00:00	NVDA	Stock	0.7483	0.7483	0.7318	0.744	91951480.0
2007-11-20 14:00:00	NVDA	Stock	0.744	0.75	0.7338	0.7375	102905360.0
2007-11-20 15:00:00	NVDA	Stock	0.7375	0.7538	0.7278	0.7508	157434760.0
2007-11-20 16:00:00	NVDA	Stock	0.7508	0.7523	0.7412	0.7508	18809680.0
2007-11-20 17:00:00	NVDA	Stock	0.7518	0.753	0.7518	0.753	132480.0
2007-11-20 18:00:00	NVDA	Stock	0.7525	0.753	0.7525	0.753	28000.0
2007-11-20 08:00:00	AMZN	Stock	3.9675	4.0085	3.9675	3.9675	621120.0
2007-11-20 09:00:00	AMZN	Stock	3.975	4.0375	3.975	4.03	22349460.0
2007-11-20 10:00:00	AMZN	Stock	4.031	4.079	3.995	4.0615	42012060.0
2007-11-20 11:00:00	AMZN	Stock	4.062	4.1	4.0505	4.0725	29312240.0
2007-11-20 12:00:00	AMZN	Stock	4.0725	4.074	4.008	4.027	25919200.0
2007-11-20 13:00:00	AMZN	Stock	4.027	4.034	3.9825	4.019	22326380.0
2007-11-20 14:00:00	AMZN	Stock	4.0185	4.039	3.9155	3.9495	29801240.0
2007-11-20 15:00:00	AMZN	Stock	3.949	4.046	3.92	4.02	36628860.0
2007-11-20 16:00:00	AMZN	Stock	4.0195	4.0225	3.959	4.0195	6140280.0
2007-11-20 17:00:00	AMZN	Stock	4.0215	4.0215	4.0195	4.0195	10002000.0
2007-11-20 18:00:00	AMZN	Stock	4.0195	4.0195	4.0195	4.0195	7000000.0
2007-11-20 19:00:00	AMZN	Stock	4.022	4.0895	4.022	4.0895	73960.0

> showing 50 of 39,956 rows — these rows as CSV

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