PREVIEW / stock_1hour / 2011-03-29

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-03-29.parquet
  size:    926 KB
  rows:    43,862
  symbols: 3,523

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-03-29 04:00:00	AAPL	Stock	12.5711	12.5711	12.5446	12.5632	35000.0
2011-03-29 05:00:00	AAPL	Stock	12.5468	12.5468	12.4739	12.4739	44800.0
2011-03-29 06:00:00	AAPL	Stock	12.5011	12.5011	12.5	12.5	5600.0
2011-03-29 07:00:00	AAPL	Stock	12.5186	12.5186	12.4914	12.495	159600.0
2011-03-29 08:00:00	AAPL	Stock	12.5	12.5171	12.4254	12.4261	3720640.0
2011-03-29 09:00:00	AAPL	Stock	12.4268	12.4475	12.3593	12.4136	78417164.0
2011-03-29 10:00:00	AAPL	Stock	12.4136	12.4979	12.4	12.4921	71318856.0
2011-03-29 11:00:00	AAPL	Stock	12.4921	12.52	12.4787	12.5086	46479888.0
2011-03-29 12:00:00	AAPL	Stock	12.5086	12.5229	12.4693	12.4786	30931740.0
2011-03-29 13:00:00	AAPL	Stock	12.4782	12.4875	12.4343	12.4521	28059528.0
2011-03-29 14:00:00	AAPL	Stock	12.4525	12.4957	12.4491	12.4839	28540680.0
2011-03-29 15:00:00	AAPL	Stock	12.4839	12.5343	12.4807	12.5339	50043700.0
2011-03-29 16:00:00	AAPL	Stock	12.5329	12.5471	12.426	12.5421	8862868.0
2011-03-29 17:00:00	AAPL	Stock	12.5404	12.5482	12.5379	12.5482	212212.0
2011-03-29 18:00:00	AAPL	Stock	12.5482	12.5482	12.5343	12.5357	548604.0
2011-03-29 19:00:00	AAPL	Stock	12.5386	12.5464	12.5357	12.5464	134204.0
2011-03-29 07:00:00	MSFT	Stock	25.49	25.49	25.49	25.49	100.0
2011-03-29 08:00:00	MSFT	Stock	25.47	25.49	25.43	25.45	1200.0
2011-03-29 09:00:00	MSFT	Stock	25.44	25.48	25.3	25.34	3989310.0
2011-03-29 10:00:00	MSFT	Stock	25.34	25.44	25.33	25.374	5476161.0
2011-03-29 11:00:00	MSFT	Stock	25.38	25.47	25.375	25.43	5860117.0
2011-03-29 12:00:00	MSFT	Stock	25.44	25.46	25.4	25.45	2530007.0
2011-03-29 13:00:00	MSFT	Stock	25.445	25.46	25.4	25.41	3311706.0
2011-03-29 14:00:00	MSFT	Stock	25.415	25.52	25.4	25.5	8903999.0
2011-03-29 15:00:00	MSFT	Stock	25.5	25.52	25.43	25.49	7558160.0
2011-03-29 16:00:00	MSFT	Stock	25.49	25.51	25.422	25.5	1640382.0
2011-03-29 17:00:00	MSFT	Stock	25.5	25.5	25.49	25.49	750.0
2011-03-29 18:00:00	MSFT	Stock	25.49	25.51	25.49	25.51	8547.0
2011-03-29 19:00:00	MSFT	Stock	25.49	25.51	25.49	25.51	1000.0
2011-03-29 07:00:00	NVDA	Stock	0.487	0.487	0.487	0.487	12000.0
2011-03-29 08:00:00	NVDA	Stock	0.4845	0.4875	0.4805	0.4838	1178800.0
2011-03-29 09:00:00	NVDA	Stock	0.4838	0.4848	0.4768	0.4815	95038400.0
2011-03-29 10:00:00	NVDA	Stock	0.4812	0.4822	0.4753	0.478	161524120.0
2011-03-29 11:00:00	NVDA	Stock	0.4782	0.48	0.474	0.4748	105062640.0
2011-03-29 12:00:00	NVDA	Stock	0.4748	0.4775	0.4728	0.477	80531120.0
2011-03-29 13:00:00	NVDA	Stock	0.4768	0.4772	0.474	0.4764	53297520.0
2011-03-29 14:00:00	NVDA	Stock	0.4763	0.478	0.4759	0.4759	66079560.0
2011-03-29 15:00:00	NVDA	Stock	0.4759	0.4803	0.4759	0.4795	134687480.0
2011-03-29 16:00:00	NVDA	Stock	0.4795	0.4815	0.4765	0.4798	7130680.0
2011-03-29 18:00:00	NVDA	Stock	0.481	0.481	0.4798	0.4808	57280.0
2011-03-29 19:00:00	NVDA	Stock	0.48	0.48	0.48	0.48	200000.0
2011-03-29 07:00:00	AMZN	Stock	8.5	8.5	8.497	8.4995	14000.0
2011-03-29 08:00:00	AMZN	Stock	8.511	8.5425	8.511	8.5165	200200.0
2011-03-29 09:00:00	AMZN	Stock	8.514	8.6575	8.5035	8.6397	18667020.0
2011-03-29 10:00:00	AMZN	Stock	8.635	8.708	8.63	8.6925	21114280.0
2011-03-29 11:00:00	AMZN	Stock	8.694	8.7355	8.6835	8.7075	11304620.0
2011-03-29 12:00:00	AMZN	Stock	8.7048	8.7095	8.661	8.6865	8663900.0
2011-03-29 13:00:00	AMZN	Stock	8.686	8.705	8.681	8.6985	5754760.0
2011-03-29 14:00:00	AMZN	Stock	8.698	8.731	8.694	8.717	9213400.0
2011-03-29 15:00:00	AMZN	Stock	8.7165	8.742	8.707	8.733	19365380.0

> showing 50 of 43,862 rows — these rows as CSV

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