PREVIEW / stock_1hour / 2011-07-05

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-07-05.parquet
  size:    944 KB
  rows:    44,767
  symbols: 3,526

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-07-05 04:00:00	AAPL	Stock	12.2196	12.2196	12.2196	12.2196	2800.0
2011-07-05 05:00:00	AAPL	Stock	12.2196	12.2196	12.2196	12.2196	30800.0
2011-07-05 06:00:00	AAPL	Stock	12.225	12.225	12.2196	12.2196	11200.0
2011-07-05 07:00:00	AAPL	Stock	12.2289	12.2532	12.2189	12.2404	211484.0
2011-07-05 08:00:00	AAPL	Stock	12.2496	12.2539	12.2357	12.2429	572908.0
2011-07-05 09:00:00	AAPL	Stock	12.2396	12.4296	12.2321	12.4109	63578508.0
2011-07-05 10:00:00	AAPL	Stock	12.4107	12.4643	12.3796	12.4225	74174324.0
2011-07-05 11:00:00	AAPL	Stock	12.4225	12.4639	12.4096	12.4346	31954412.0
2011-07-05 12:00:00	AAPL	Stock	12.4341	12.45	12.4139	12.44	23049264.0
2011-07-05 13:00:00	AAPL	Stock	12.4404	12.4711	12.4396	12.4559	27664896.0
2011-07-05 14:00:00	AAPL	Stock	12.4557	12.4625	12.4179	12.4429	39677568.0
2011-07-05 15:00:00	AAPL	Stock	12.4429	12.4939	12.4314	12.4754	63559468.0
2011-07-05 16:00:00	AAPL	Stock	12.4754	12.4822	12.4247	12.4786	17093020.0
2011-07-05 17:00:00	AAPL	Stock	12.4775	12.4779	12.4479	12.4739	207284.0
2011-07-05 18:00:00	AAPL	Stock	12.4725	12.4857	12.4718	12.4836	390124.0
2011-07-05 19:00:00	AAPL	Stock	12.4786	12.4821	12.475	12.4768	131824.0
2011-07-05 06:00:00	MSFT	Stock	26.16	26.16	26.14	26.15	5400.0
2011-07-05 07:00:00	MSFT	Stock	26.15	26.15	26.15	26.15	6085.0
2011-07-05 08:00:00	MSFT	Stock	26.16	26.17	26.11	26.15	24029.0
2011-07-05 09:00:00	MSFT	Stock	26.15	26.2	25.92	25.996	4778124.0
2011-07-05 10:00:00	MSFT	Stock	26.0	26.01	25.91	25.975	4915679.0
2011-07-05 11:00:00	MSFT	Stock	25.975	26.1	25.93	26.061	3962033.0
2011-07-05 12:00:00	MSFT	Stock	26.065	26.08	26.02	26.06	2943543.0
2011-07-05 13:00:00	MSFT	Stock	26.054	26.08	25.95	25.955	3567239.0
2011-07-05 14:00:00	MSFT	Stock	25.96	25.98	25.9	25.965	4214877.0
2011-07-05 15:00:00	MSFT	Stock	25.965	26.08	25.96	26.05	9128979.0
2011-07-05 16:00:00	MSFT	Stock	26.06	26.08	26.001	26.06	2532268.0
2011-07-05 17:00:00	MSFT	Stock	26.03	26.14	26.03	26.07	37655.0
2011-07-05 18:00:00	MSFT	Stock	26.1	26.17	26.03	26.09	40715.0
2011-07-05 19:00:00	MSFT	Stock	26.09	26.13	26.09	26.1	1883.0
2011-07-05 08:00:00	NVDA	Stock	0.405	0.405	0.4028	0.4028	242000.0
2011-07-05 09:00:00	NVDA	Stock	0.4015	0.407	0.399	0.3993	56217440.0
2011-07-05 10:00:00	NVDA	Stock	0.3993	0.401	0.3968	0.397	102434440.0
2011-07-05 11:00:00	NVDA	Stock	0.397	0.3982	0.3953	0.3953	71094160.0
2011-07-05 12:00:00	NVDA	Stock	0.3954	0.398	0.3954	0.3968	38658080.0
2011-07-05 13:00:00	NVDA	Stock	0.397	0.3975	0.396	0.3961	55770600.0
2011-07-05 14:00:00	NVDA	Stock	0.3961	0.3968	0.3935	0.3953	91305680.0
2011-07-05 15:00:00	NVDA	Stock	0.3952	0.3975	0.3948	0.397	91959040.0
2011-07-05 16:00:00	NVDA	Stock	0.3968	0.3975	0.3958	0.397	25775960.0
2011-07-05 17:00:00	NVDA	Stock	0.3965	0.3973	0.3962	0.3968	61400.0
2011-07-05 18:00:00	NVDA	Stock	0.3968	0.3995	0.3962	0.3995	201400.0
2011-07-05 06:00:00	AMZN	Stock	10.4745	10.4745	10.4745	10.4745	4000.0
2011-07-05 07:00:00	AMZN	Stock	10.463	10.468	10.463	10.468	6000.0
2011-07-05 08:00:00	AMZN	Stock	10.451	10.451	10.4335	10.437	47800.0
2011-07-05 09:00:00	AMZN	Stock	10.438	10.625	10.4365	10.5843	12964660.0
2011-07-05 10:00:00	AMZN	Stock	10.581	10.6025	10.529	10.564	9170620.0
2011-07-05 11:00:00	AMZN	Stock	10.561	10.656	10.5455	10.625	7621840.0
2011-07-05 12:00:00	AMZN	Stock	10.625	10.694	10.6235	10.6788	6977880.0
2011-07-05 13:00:00	AMZN	Stock	10.6785	10.716	10.6785	10.7128	6194540.0
2011-07-05 14:00:00	AMZN	Stock	10.712	10.7225	10.6125	10.6505	10747960.0

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

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