PREVIEW / stock_1hour / 2012-11-09

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-11-09.parquet
  size:    938 KB
  rows:    44,242
  symbols: 3,463

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
2012-11-09 04:00:00	AAPL	Stock	19.2054	19.25	19.1432	19.2214	235144.0
2012-11-09 05:00:00	AAPL	Stock	19.2214	19.25	19.2143	19.2143	204960.0
2012-11-09 06:00:00	AAPL	Stock	19.2036	19.2036	19.1432	19.1786	195300.0
2012-11-09 07:00:00	AAPL	Stock	19.1571	19.165	19.1086	19.1246	1322580.0
2012-11-09 08:00:00	AAPL	Stock	19.125	19.2589	19.0489	19.225	9506532.0
2012-11-09 09:00:00	AAPL	Stock	19.2232	19.4111	19.0614	19.1579	177055872.0
2012-11-09 10:00:00	AAPL	Stock	19.1529	19.6221	19.1257	19.6211	216788740.0
2012-11-09 11:00:00	AAPL	Stock	19.6214	19.7254	19.5357	19.5686	114576336.0
2012-11-09 12:00:00	AAPL	Stock	19.5674	19.8171	19.5643	19.7593	81089736.0
2012-11-09 13:00:00	AAPL	Stock	19.7571	19.8039	19.5039	19.5996	113371804.0
2012-11-09 14:00:00	AAPL	Stock	19.6037	19.6779	19.4589	19.5514	74204116.0
2012-11-09 15:00:00	AAPL	Stock	19.5464	19.6139	19.4364	19.5464	102255552.0
2012-11-09 16:00:00	AAPL	Stock	19.5369	19.6429	19.2136	19.5496	23967412.0
2012-11-09 17:00:00	AAPL	Stock	19.5496	19.5496	19.5314	19.5321	441672.0
2012-11-09 18:00:00	AAPL	Stock	19.5354	19.5357	19.5096	19.5261	399476.0
2012-11-09 19:00:00	AAPL	Stock	19.5214	19.5389	19.5214	19.5357	135156.0
2012-11-09 04:00:00	MSFT	Stock	28.8	28.8	28.67	28.8	500.0
2012-11-09 06:00:00	MSFT	Stock	28.98	28.98	28.98	28.98	100.0
2012-11-09 07:00:00	MSFT	Stock	28.78	28.88	28.78	28.79	9000.0
2012-11-09 08:00:00	MSFT	Stock	28.79	28.88	28.79	28.87	57450.0
2012-11-09 09:00:00	MSFT	Stock	28.87	29.19	28.83	29.01	6346191.0
2012-11-09 10:00:00	MSFT	Stock	29.0	29.09	28.92	28.977	8496769.0
2012-11-09 11:00:00	MSFT	Stock	28.97	29.02	28.87	28.99	5380854.0
2012-11-09 12:00:00	MSFT	Stock	29.0	29.05	28.97	28.98	3368401.0
2012-11-09 13:00:00	MSFT	Stock	28.98	29.02	28.85	28.94	4954166.0
2012-11-09 14:00:00	MSFT	Stock	28.94	29.06	28.88	28.9	3871736.0
2012-11-09 15:00:00	MSFT	Stock	28.905	28.96	28.805	28.82	7969423.0
2012-11-09 16:00:00	MSFT	Stock	28.82	28.967	28.82	28.83	2032469.0
2012-11-09 17:00:00	MSFT	Stock	28.83	28.84	28.8	28.8	22516.0
2012-11-09 18:00:00	MSFT	Stock	28.8	28.83	28.8	28.83	6400.0
2012-11-09 19:00:00	MSFT	Stock	28.82	28.83	28.82	28.83	3348.0
2012-11-09 07:00:00	NVDA	Stock	0.3218	0.3225	0.321	0.3213	124000.0
2012-11-09 08:00:00	NVDA	Stock	0.322	0.322	0.3173	0.3178	1810960.0
2012-11-09 09:00:00	NVDA	Stock	0.3188	0.3205	0.315	0.318	144340080.0
2012-11-09 10:00:00	NVDA	Stock	0.318	0.3223	0.3168	0.3222	146356920.0
2012-11-09 11:00:00	NVDA	Stock	0.322	0.3224	0.3178	0.3185	116409640.0
2012-11-09 12:00:00	NVDA	Stock	0.3188	0.3193	0.3161	0.3163	66690880.0
2012-11-09 13:00:00	NVDA	Stock	0.3165	0.3178	0.3105	0.3124	110358960.0
2012-11-09 14:00:00	NVDA	Stock	0.3123	0.3124	0.3065	0.307	91269280.0
2012-11-09 15:00:00	NVDA	Stock	0.307	0.3175	0.3038	0.3045	155184720.0
2012-11-09 16:00:00	NVDA	Stock	0.3048	0.3166	0.3042	0.3048	1744520.0
2012-11-09 17:00:00	NVDA	Stock	0.3052	0.3052	0.3045	0.3045	287720.0
2012-11-09 18:00:00	NVDA	Stock	0.3042	0.3065	0.3042	0.3065	8160.0
2012-11-09 19:00:00	NVDA	Stock	0.3042	0.3042	0.3042	0.3042	39000.0
2012-11-09 07:00:00	AMZN	Stock	11.3925	11.3925	11.33	11.33	56000.0
2012-11-09 08:00:00	AMZN	Stock	11.3305	11.3465	11.2665	11.324	66660.0
2012-11-09 09:00:00	AMZN	Stock	11.325	11.4325	11.23	11.2715	12617740.0
2012-11-09 10:00:00	AMZN	Stock	11.2715	11.432	11.2655	11.4168	12422440.0
2012-11-09 11:00:00	AMZN	Stock	11.407	11.4485	11.3661	11.4144	4785280.0
2012-11-09 12:00:00	AMZN	Stock	11.4155	11.5485	11.4155	11.4625	6012620.0

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

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