PREVIEW / stock_1hour / 2010-06-21

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-06-21.parquet
  size:    921 KB
  rows:    44,065
  symbols: 3,471

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
2010-06-21 04:00:00	AAPL	Stock	9.9464	9.9536	9.8996	9.9286	131600.0
2010-06-21 05:00:00	AAPL	Stock	9.9286	9.9518	9.9096	9.9286	61600.0
2010-06-21 06:00:00	AAPL	Stock	9.9454	9.95	9.9304	9.9304	78372.0
2010-06-21 07:00:00	AAPL	Stock	9.9429	9.9589	9.9207	9.9286	854056.0
2010-06-21 08:00:00	AAPL	Stock	9.9279	9.9346	9.8861	9.8989	5476268.0
2010-06-21 09:00:00	AAPL	Stock	9.8993	9.9625	9.8993	9.9592	99850044.0
2010-06-21 10:00:00	AAPL	Stock	9.9593	9.9646	9.8496	9.8679	134383312.0
2010-06-21 11:00:00	AAPL	Stock	9.8668	9.895	9.8286	9.8465	83028652.0
2010-06-21 12:00:00	AAPL	Stock	9.8471	9.8589	9.8125	9.8471	53689636.0
2010-06-21 13:00:00	AAPL	Stock	9.8475	9.8639	9.7804	9.7825	62178704.0
2010-06-21 14:00:00	AAPL	Stock	9.7818	9.8382	9.7282	9.7436	89186132.0
2010-06-21 15:00:00	AAPL	Stock	9.7414	9.7492	9.5975	9.6557	226443504.0
2010-06-21 16:00:00	AAPL	Stock	9.6554	9.9276	9.643	9.6721	10206280.0
2010-06-21 17:00:00	AAPL	Stock	9.6725	9.6775	9.6679	9.6768	533736.0
2010-06-21 18:00:00	AAPL	Stock	9.6754	9.6846	9.6489	9.6846	3064152.0
2010-06-21 19:00:00	AAPL	Stock	9.6821	9.7032	9.6818	9.6996	469616.0
2010-06-21 04:00:00	MSFT	Stock	26.81	26.81	26.81	26.81	100.0
2010-06-21 07:00:00	MSFT	Stock	26.73	26.79	26.73	26.78	5300.0
2010-06-21 08:00:00	MSFT	Stock	26.78	26.8	26.71	26.8	21606.0
2010-06-21 09:00:00	MSFT	Stock	26.79	27.0	26.44	26.56	5357948.0
2010-06-21 10:00:00	MSFT	Stock	26.566	26.61	26.25	26.3	7239352.0
2010-06-21 11:00:00	MSFT	Stock	26.305	26.38	26.27	26.29	4639249.0
2010-06-21 12:00:00	MSFT	Stock	26.298	26.33	26.17	26.2	5241673.0
2010-06-21 13:00:00	MSFT	Stock	26.2	26.29	26.13	26.17	3176323.0
2010-06-21 14:00:00	MSFT	Stock	26.18	26.27	26.14	26.17	3893064.0
2010-06-21 15:00:00	MSFT	Stock	26.16	26.17	25.89	25.96	18334599.0
2010-06-21 16:00:00	MSFT	Stock	25.96	26.368	25.91	26.03	4366629.0
2010-06-21 17:00:00	MSFT	Stock	26.393	26.398	26.01	26.04	852117.0
2010-06-21 18:00:00	MSFT	Stock	26.01	26.03	25.95	26.02	3160.0
2010-06-21 19:00:00	MSFT	Stock	26.03	26.03	26.01	26.02	7500.0
2010-06-21 04:00:00	NVDA	Stock	0.3125	0.3125	0.3125	0.3125	4000.0
2010-06-21 07:00:00	NVDA	Stock	0.3125	0.314	0.3125	0.314	28000.0
2010-06-21 08:00:00	NVDA	Stock	0.314	0.315	0.309	0.3128	626800.0
2010-06-21 09:00:00	NVDA	Stock	0.3138	0.3148	0.3083	0.3125	106056080.0
2010-06-21 10:00:00	NVDA	Stock	0.3128	0.3143	0.3085	0.3085	93747280.0
2010-06-21 11:00:00	NVDA	Stock	0.3088	0.3108	0.3085	0.3095	43570960.0
2010-06-21 12:00:00	NVDA	Stock	0.3095	0.3098	0.3068	0.3085	45505800.0
2010-06-21 13:00:00	NVDA	Stock	0.3087	0.3093	0.3058	0.3062	29516920.0
2010-06-21 14:00:00	NVDA	Stock	0.306	0.308	0.303	0.3035	50243080.0
2010-06-21 15:00:00	NVDA	Stock	0.3035	0.3038	0.2975	0.3002	194848960.0
2010-06-21 16:00:00	NVDA	Stock	0.3	0.3063	0.3	0.3025	2419480.0
2010-06-21 17:00:00	NVDA	Stock	0.3076	0.3076	0.3008	0.3008	5029600.0
2010-06-21 18:00:00	NVDA	Stock	0.3012	0.306	0.3012	0.305	1135600.0
2010-06-21 19:00:00	NVDA	Stock	0.3045	0.3045	0.304	0.3042	312000.0
2010-06-21 07:00:00	AMZN	Stock	6.354	6.3725	6.354	6.3725	6500.0
2010-06-21 08:00:00	AMZN	Stock	6.37	6.3875	6.2809	6.365	89500.0
2010-06-21 09:00:00	AMZN	Stock	6.358	6.376	6.292	6.3292	8697940.0
2010-06-21 10:00:00	AMZN	Stock	6.3305	6.363	6.287	6.296	8524040.0
2010-06-21 11:00:00	AMZN	Stock	6.295	6.3145	6.25	6.2598	8347600.0
2010-06-21 12:00:00	AMZN	Stock	6.262	6.288	6.2375	6.288	7704040.0

> showing 50 of 44,065 rows — these rows as CSV

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