PREVIEW / stock_1hour / 2011-01-13

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-01-13.parquet
  size:    939 KB
  rows:    44,655
  symbols: 3,506

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-01-13 04:00:00	AAPL	Stock	12.3332	12.3336	12.3214	12.3336	11200.0
2011-01-13 05:00:00	AAPL	Stock	12.3393	12.375	12.3393	12.35	16800.0
2011-01-13 06:00:00	AAPL	Stock	12.3704	12.375	12.3607	12.375	100800.0
2011-01-13 07:00:00	AAPL	Stock	12.375	12.375	12.3261	12.3446	459340.0
2011-01-13 08:00:00	AAPL	Stock	12.3446	12.3446	12.2893	12.3018	4804212.0
2011-01-13 09:00:00	AAPL	Stock	12.3004	12.3325	12.2804	12.295	49146468.0
2011-01-13 10:00:00	AAPL	Stock	12.2957	12.3732	12.2825	12.3691	69894328.0
2011-01-13 11:00:00	AAPL	Stock	12.3679	12.38	12.3529	12.3536	34591816.0
2011-01-13 12:00:00	AAPL	Stock	12.3539	12.3754	12.3531	12.3596	18188856.0
2011-01-13 13:00:00	AAPL	Stock	12.3589	12.3643	12.3436	12.3489	20333880.0
2011-01-13 14:00:00	AAPL	Stock	12.35	12.3557	12.3125	12.3232	29926120.0
2011-01-13 15:00:00	AAPL	Stock	12.3243	12.35	12.3214	12.345	45969168.0
2011-01-13 16:00:00	AAPL	Stock	12.3457	12.3671	12.3262	12.3671	12893188.0
2011-01-13 17:00:00	AAPL	Stock	12.3643	12.3857	12.3618	12.3786	1010240.0
2011-01-13 18:00:00	AAPL	Stock	12.3804	12.3811	12.3457	12.3729	701596.0
2011-01-13 19:00:00	AAPL	Stock	12.375	12.375	12.3643	12.3714	751660.0
2011-01-13 04:00:00	MSFT	Stock	28.51	28.51	28.51	28.51	500.0
2011-01-13 07:00:00	MSFT	Stock	28.52	28.55	28.52	28.53	10400.0
2011-01-13 08:00:00	MSFT	Stock	28.55	28.55	28.43	28.45	34529.0
2011-01-13 09:00:00	MSFT	Stock	28.48	28.54	28.05	28.05	10965907.0
2011-01-13 10:00:00	MSFT	Stock	28.06	28.21	28.01	28.17	12666445.0
2011-01-13 11:00:00	MSFT	Stock	28.175	28.29	28.175	28.22	8589834.0
2011-01-13 12:00:00	MSFT	Stock	28.22	28.26	28.21	28.238	3650222.0
2011-01-13 13:00:00	MSFT	Stock	28.23	28.25	28.15	28.17	3181675.0
2011-01-13 14:00:00	MSFT	Stock	28.18	28.2	28.1	28.12	5231253.0
2011-01-13 15:00:00	MSFT	Stock	28.12	28.22	28.08	28.2	15938498.0
2011-01-13 16:00:00	MSFT	Stock	28.2	28.3	28.11	28.27	1858263.0
2011-01-13 17:00:00	MSFT	Stock	28.29	28.45	28.29	28.4	253669.0
2011-01-13 18:00:00	MSFT	Stock	28.36	28.4	28.19	28.4	48100.0
2011-01-13 19:00:00	MSFT	Stock	28.4	28.4	28.35	28.35	4200.0
2011-01-13 04:00:00	NVDA	Stock	0.5835	0.5835	0.5835	0.5835	8000.0
2011-01-13 07:00:00	NVDA	Stock	0.5812	0.5812	0.5765	0.5765	142400.0
2011-01-13 08:00:00	NVDA	Stock	0.5775	0.5828	0.576	0.5785	3175160.0
2011-01-13 09:00:00	NVDA	Stock	0.5788	0.581	0.566	0.5698	379890240.0
2011-01-13 10:00:00	NVDA	Stock	0.5698	0.586	0.5595	0.584	575374960.0
2011-01-13 11:00:00	NVDA	Stock	0.584	0.5938	0.5732	0.5865	445582000.0
2011-01-13 12:00:00	NVDA	Stock	0.5865	0.592	0.5802	0.5846	297270400.0
2011-01-13 13:00:00	NVDA	Stock	0.5848	0.592	0.5825	0.5872	242888760.0
2011-01-13 14:00:00	NVDA	Stock	0.5872	0.596	0.5812	0.5825	371332600.0
2011-01-13 15:00:00	NVDA	Stock	0.5826	0.589	0.5818	0.5845	348535520.0
2011-01-13 16:00:00	NVDA	Stock	0.5848	0.5915	0.5811	0.5888	10584080.0
2011-01-13 17:00:00	NVDA	Stock	0.5888	0.5908	0.5875	0.5875	1071680.0
2011-01-13 18:00:00	NVDA	Stock	0.5865	0.5885	0.5865	0.5872	391040.0
2011-01-13 19:00:00	NVDA	Stock	0.588	0.5888	0.585	0.585	870280.0
2011-01-13 04:00:00	AMZN	Stock	9.25	9.25	9.25	9.25	6000.0
2011-01-13 07:00:00	AMZN	Stock	9.23	9.2375	9.2245	9.2375	12000.0
2011-01-13 08:00:00	AMZN	Stock	9.2125	9.224	9.1905	9.2	92840.0
2011-01-13 09:00:00	AMZN	Stock	9.2	9.2745	9.1755	9.2625	9000560.0
2011-01-13 10:00:00	AMZN	Stock	9.2608	9.3135	9.247	9.299	13824240.0
2011-01-13 11:00:00	AMZN	Stock	9.299	9.3225	9.2805	9.297	9444700.0

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

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