PREVIEW / stock_1hour / 2011-08-24

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-08-24.parquet
  size:    929 KB
  rows:    45,467
  symbols: 3,501

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
2011-08-24 04:00:00	AAPL	Stock	13.2075	13.2714	13.2075	13.2714	30800.0
2011-08-24 05:00:00	AAPL	Stock	13.2857	13.3304	13.2857	13.3304	11200.0
2011-08-24 06:00:00	AAPL	Stock	13.3214	13.3214	13.2536	13.2536	83496.0
2011-08-24 07:00:00	AAPL	Stock	13.255	13.3357	13.2264	13.2857	764960.0
2011-08-24 08:00:00	AAPL	Stock	13.2868	13.3411	13.2239	13.3361	5215728.0
2011-08-24 09:00:00	AAPL	Stock	13.3386	13.5111	13.3043	13.5016	91576100.0
2011-08-24 10:00:00	AAPL	Stock	13.4979	13.5343	13.2896	13.2993	117222756.0
2011-08-24 11:00:00	AAPL	Stock	13.3004	13.3675	13.2582	13.2979	89226144.0
2011-08-24 12:00:00	AAPL	Stock	13.2993	13.3529	13.2357	13.3436	57781304.0
2011-08-24 13:00:00	AAPL	Stock	13.3452	13.3857	13.3114	13.3689	49733012.0
2011-08-24 14:00:00	AAPL	Stock	13.3676	13.3843	13.32	13.3836	48377560.0
2011-08-24 15:00:00	AAPL	Stock	13.3843	13.4875	13.3789	13.4339	107471336.0
2011-08-24 16:00:00	AAPL	Stock	13.4343	13.4393	13.2725	13.4007	10379124.0
2011-08-24 17:00:00	AAPL	Stock	13.3429	13.435	13.3429	13.4107	281932.0
2011-08-24 18:00:00	AAPL	Stock	13.4107	13.435	12.5	12.75	8152424.0
2011-08-24 19:00:00	AAPL	Stock	12.75	12.8229	12.6786	12.7536	32754904.0
2011-08-24 07:00:00	MSFT	Stock	24.47	24.47	24.47	24.47	100.0
2011-08-24 08:00:00	MSFT	Stock	24.54	24.72	24.47	24.65	16625.0
2011-08-24 09:00:00	MSFT	Stock	24.65	24.84	24.45	24.81	4811789.0
2011-08-24 10:00:00	MSFT	Stock	24.81	24.84	24.57	24.59	7362883.0
2011-08-24 11:00:00	MSFT	Stock	24.585	24.61	24.42	24.53	6084929.0
2011-08-24 12:00:00	MSFT	Stock	24.525	24.68	24.45	24.67	4359543.0
2011-08-24 13:00:00	MSFT	Stock	24.67	24.77	24.615	24.74	4084036.0
2011-08-24 14:00:00	MSFT	Stock	24.74	24.815	24.66	24.805	4157995.0
2011-08-24 15:00:00	MSFT	Stock	24.81	24.93	24.76	24.9	10470214.0
2011-08-24 16:00:00	MSFT	Stock	24.91	24.921	24.583	24.87	3608079.0
2011-08-24 17:00:00	MSFT	Stock	24.72	24.88	24.72	24.88	3000.0
2011-08-24 18:00:00	MSFT	Stock	24.87	24.9	24.8	24.8	40266.0
2011-08-24 19:00:00	MSFT	Stock	24.8	24.83	24.72	24.72	5676.0
2011-08-24 08:00:00	NVDA	Stock	0.3263	0.3295	0.3263	0.3295	248000.0
2011-08-24 09:00:00	NVDA	Stock	0.3295	0.332	0.32	0.33	102323920.0
2011-08-24 10:00:00	NVDA	Stock	0.33	0.331	0.3213	0.3218	116209360.0
2011-08-24 11:00:00	NVDA	Stock	0.322	0.3233	0.3195	0.321	99983120.0
2011-08-24 12:00:00	NVDA	Stock	0.321	0.3218	0.3175	0.3215	63433160.0
2011-08-24 13:00:00	NVDA	Stock	0.3215	0.3241	0.32	0.322	55912280.0
2011-08-24 14:00:00	NVDA	Stock	0.3223	0.323	0.319	0.3225	73028040.0
2011-08-24 15:00:00	NVDA	Stock	0.3228	0.327	0.322	0.326	138331720.0
2011-08-24 16:00:00	NVDA	Stock	0.326	0.3261	0.3213	0.3213	32788760.0
2011-08-24 17:00:00	NVDA	Stock	0.3308	0.3308	0.3205	0.3213	1236000.0
2011-08-24 18:00:00	NVDA	Stock	0.3213	0.3213	0.3203	0.321	884000.0
2011-08-24 19:00:00	NVDA	Stock	0.321	0.321	0.3188	0.3203	381600.0
2011-08-24 06:00:00	AMZN	Stock	9.6025	9.6025	9.6005	9.6005	10000.0
2011-08-24 07:00:00	AMZN	Stock	9.63	9.6305	9.611	9.611	12000.0
2011-08-24 08:00:00	AMZN	Stock	9.611	9.773	9.6	9.76	553540.0
2011-08-24 09:00:00	AMZN	Stock	9.75	9.8055	9.62	9.766	33192960.0
2011-08-24 10:00:00	AMZN	Stock	9.765	9.8155	9.5435	9.544	28549640.0
2011-08-24 11:00:00	AMZN	Stock	9.544	9.6975	9.5085	9.59	15928560.0
2011-08-24 12:00:00	AMZN	Stock	9.596	9.614	9.515	9.605	9168120.0
2011-08-24 13:00:00	AMZN	Stock	9.5985	9.6175	9.527	9.586	8483380.0
2011-08-24 14:00:00	AMZN	Stock	9.5805	9.61	9.5211	9.6015	7857520.0

> showing 50 of 45,467 rows — these rows as CSV

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