PREVIEW / stock_1hour / 2012-03-09

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-03-09.parquet
  size:    942 KB
  rows:    44,201
  symbols: 3,507

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-03-09 04:00:00	AAPL	Stock	19.3929	19.4321	19.3929	19.4143	87612.0
2012-03-09 05:00:00	AAPL	Stock	19.4243	19.4429	19.4179	19.4196	61600.0
2012-03-09 06:00:00	AAPL	Stock	19.3964	19.3964	19.375	19.3929	127400.0
2012-03-09 07:00:00	AAPL	Stock	19.4054	19.4054	19.3589	19.3696	658280.0
2012-03-09 08:00:00	AAPL	Stock	19.3632	19.4286	19.34	19.4204	5676048.0
2012-03-09 09:00:00	AAPL	Stock	19.4221	19.5621	19.4018	19.4732	98276164.0
2012-03-09 10:00:00	AAPL	Stock	19.4668	19.5139	19.4439	19.4964	81932788.0
2012-03-09 11:00:00	AAPL	Stock	19.4964	19.5132	19.4664	19.4786	38833984.0
2012-03-09 12:00:00	AAPL	Stock	19.4804	19.4904	19.4679	19.4747	23234820.0
2012-03-09 13:00:00	AAPL	Stock	19.4736	19.4875	19.4571	19.4714	27706952.0
2012-03-09 14:00:00	AAPL	Stock	19.4725	19.4907	19.42	19.4221	43161440.0
2012-03-09 15:00:00	AAPL	Stock	19.4221	19.4696	19.3968	19.465	77367528.0
2012-03-09 16:00:00	AAPL	Stock	19.4696	19.4989	19.3568	19.4632	15731576.0
2012-03-09 17:00:00	AAPL	Stock	19.4646	19.465	19.4571	19.4643	128968.0
2012-03-09 18:00:00	AAPL	Stock	19.4664	19.4693	19.4643	19.4679	190652.0
2012-03-09 19:00:00	AAPL	Stock	19.4675	19.4704	19.4596	19.4596	412888.0
2012-03-09 07:00:00	MSFT	Stock	32.05	32.1	32.05	32.1	500.0
2012-03-09 08:00:00	MSFT	Stock	32.05	32.1	32.02	32.08	21739.0
2012-03-09 09:00:00	MSFT	Stock	32.08	32.16	31.96	31.98	3185945.0
2012-03-09 10:00:00	MSFT	Stock	31.985	32.07	31.92	32.06	7105448.0
2012-03-09 11:00:00	MSFT	Stock	32.065	32.07	31.95	31.995	4243491.0
2012-03-09 12:00:00	MSFT	Stock	31.995	32.05	31.96	31.995	3223685.0
2012-03-09 13:00:00	MSFT	Stock	31.99	32.05	31.98	32.04	2363143.0
2012-03-09 14:00:00	MSFT	Stock	32.04	32.045	31.97	31.995	3343582.0
2012-03-09 15:00:00	MSFT	Stock	32.0	32.05	31.96	32.0	7290437.0
2012-03-09 16:00:00	MSFT	Stock	31.99	32.072	31.95	31.99	2740990.0
2012-03-09 17:00:00	MSFT	Stock	31.99	31.99	31.98	31.99	6570.0
2012-03-09 09:00:00	NVDA	Stock	0.3725	0.3743	0.3715	0.372	27009920.0
2012-03-09 10:00:00	NVDA	Stock	0.372	0.3743	0.3718	0.3738	39016920.0
2012-03-09 11:00:00	NVDA	Stock	0.3738	0.3753	0.3735	0.375	31420040.0
2012-03-09 12:00:00	NVDA	Stock	0.3753	0.3753	0.3713	0.3713	31372360.0
2012-03-09 13:00:00	NVDA	Stock	0.3713	0.3715	0.3698	0.3708	41771320.0
2012-03-09 14:00:00	NVDA	Stock	0.371	0.372	0.3695	0.3699	57622480.0
2012-03-09 15:00:00	NVDA	Stock	0.37	0.3708	0.3685	0.3703	121221360.0
2012-03-09 16:00:00	NVDA	Stock	0.3705	0.3724	0.3699	0.3715	17656160.0
2012-03-09 07:00:00	AMZN	Stock	9.3875	9.3875	9.33	9.335	31200.0
2012-03-09 08:00:00	AMZN	Stock	9.335	9.3905	9.3195	9.3425	461360.0
2012-03-09 09:00:00	AMZN	Stock	9.342	9.36	9.172	9.1941	21390000.0
2012-03-09 10:00:00	AMZN	Stock	9.191	9.2465	9.191	9.2235	18889840.0
2012-03-09 11:00:00	AMZN	Stock	9.222	9.228	9.1835	9.195	10070340.0
2012-03-09 12:00:00	AMZN	Stock	9.1945	9.2165	9.1882	9.21	7071460.0
2012-03-09 13:00:00	AMZN	Stock	9.209	9.2795	9.205	9.2475	8071120.0
2012-03-09 14:00:00	AMZN	Stock	9.248	9.256	9.206	9.216	7488060.0
2012-03-09 15:00:00	AMZN	Stock	9.215	9.235	9.2	9.2145	12590180.0
2012-03-09 16:00:00	AMZN	Stock	9.2145	9.382	9.191	9.2215	3619920.0
2012-03-09 17:00:00	AMZN	Stock	9.216	9.216	9.216	9.216	29040.0
2012-03-09 09:00:00	TSLA	Stock	2.2133	2.2433	2.2133	2.234	581715.0
2012-03-09 10:00:00	TSLA	Stock	2.2367	2.2653	2.23	2.26	1431780.0
2012-03-09 11:00:00	TSLA	Stock	2.2593	2.2793	2.2529	2.2746	1736730.0
2012-03-09 12:00:00	TSLA	Stock	2.2727	2.3313	2.2713	2.3273	3726840.0

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

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