PREVIEW / stock_1hour / 2013-01-09

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-01-09.parquet
  size:    941 KB
  rows:    44,433
  symbols: 3,453

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
2013-01-09 04:00:00	AAPL	Stock	18.8571	18.8571	18.8107	18.8157	16800.0
2013-01-09 05:00:00	AAPL	Stock	18.8161	18.8161	18.8057	18.8057	16800.0
2013-01-09 06:00:00	AAPL	Stock	18.8161	18.8161	18.7671	18.7671	108444.0
2013-01-09 07:00:00	AAPL	Stock	18.7504	18.8211	18.7321	18.7921	326312.0
2013-01-09 08:00:00	AAPL	Stock	18.7968	18.8107	18.6071	18.6625	4265772.0
2013-01-09 09:00:00	AAPL	Stock	18.6579	18.7429	18.5393	18.6314	82865972.0
2013-01-09 10:00:00	AAPL	Stock	18.6279	18.7039	18.5629	18.6856	64922508.0
2013-01-09 11:00:00	AAPL	Stock	18.6853	18.7496	18.6025	18.62	46544988.0
2013-01-09 12:00:00	AAPL	Stock	18.6196	18.6371	18.5793	18.6143	29339968.0
2013-01-09 13:00:00	AAPL	Stock	18.6164	18.6718	18.6032	18.645	26632844.0
2013-01-09 14:00:00	AAPL	Stock	18.6454	18.7007	18.5786	18.5882	33019980.0
2013-01-09 15:00:00	AAPL	Stock	18.5839	18.6054	18.4282	18.4679	88916660.0
2013-01-09 16:00:00	AAPL	Stock	18.4686	18.6044	18.4136	18.4179	16533776.0
2013-01-09 17:00:00	AAPL	Stock	18.4207	18.4357	18.4143	18.4282	458444.0
2013-01-09 18:00:00	AAPL	Stock	18.4221	18.4339	18.4214	18.4218	211932.0
2013-01-09 19:00:00	AAPL	Stock	18.4268	18.4339	18.4179	18.4204	236012.0
2013-01-09 06:00:00	MSFT	Stock	26.64	26.64	26.64	26.64	5000.0
2013-01-09 07:00:00	MSFT	Stock	26.6	26.61	26.6	26.6	14825.0
2013-01-09 08:00:00	MSFT	Stock	26.62	26.64	26.59	26.61	23171.0
2013-01-09 09:00:00	MSFT	Stock	26.61	26.75	26.6	26.635	4858021.0
2013-01-09 10:00:00	MSFT	Stock	26.635	26.7	26.56	26.63	7688623.0
2013-01-09 11:00:00	MSFT	Stock	26.635	26.66	26.614	26.62	3683055.0
2013-01-09 12:00:00	MSFT	Stock	26.625	26.65	26.6	26.626	2941692.0
2013-01-09 13:00:00	MSFT	Stock	26.628	26.65	26.6	26.65	2929573.0
2013-01-09 14:00:00	MSFT	Stock	26.65	26.67	26.6	26.62	4820510.0
2013-01-09 15:00:00	MSFT	Stock	26.62	26.72	26.56	26.7	8946351.0
2013-01-09 16:00:00	MSFT	Stock	26.7	26.703	26.637	26.7	1498936.0
2013-01-09 17:00:00	MSFT	Stock	26.7	26.71	26.68	26.7	10659842.0
2013-01-09 18:00:00	MSFT	Stock	26.67	26.7	26.67	26.7	4050.0
2013-01-09 19:00:00	MSFT	Stock	26.67	26.74	26.67	26.74	9567.0
2013-01-09 06:00:00	NVDA	Stock	0.3175	0.3175	0.3175	0.3175	4000.0
2013-01-09 08:00:00	NVDA	Stock	0.3168	0.317	0.3125	0.3125	444000.0
2013-01-09 09:00:00	NVDA	Stock	0.3145	0.3163	0.3108	0.3115	48729000.0
2013-01-09 10:00:00	NVDA	Stock	0.3118	0.3123	0.3093	0.3103	62446840.0
2013-01-09 11:00:00	NVDA	Stock	0.3103	0.3103	0.3065	0.307	88753760.0
2013-01-09 12:00:00	NVDA	Stock	0.3073	0.3073	0.3032	0.3046	172709800.0
2013-01-09 13:00:00	NVDA	Stock	0.3047	0.3058	0.304	0.3046	81175080.0
2013-01-09 14:00:00	NVDA	Stock	0.3045	0.305	0.304	0.3046	57090000.0
2013-01-09 15:00:00	NVDA	Stock	0.3048	0.3058	0.3038	0.3052	161325960.0
2013-01-09 16:00:00	NVDA	Stock	0.3051	0.3153	0.3042	0.3042	14919520.0
2013-01-09 17:00:00	NVDA	Stock	0.3055	0.3055	0.3055	0.3055	8000.0
2013-01-09 18:00:00	NVDA	Stock	0.3052	0.3058	0.3052	0.3058	32000.0
2013-01-09 19:00:00	NVDA	Stock	0.3058	0.306	0.3058	0.306	90800.0
2013-01-09 04:00:00	AMZN	Stock	13.35	13.35	13.35	13.35	4260.0
2013-01-09 05:00:00	AMZN	Stock	13.35	13.35	13.35	13.35	60000.0
2013-01-09 06:00:00	AMZN	Stock	13.35	13.35	13.3305	13.3305	10000.0
2013-01-09 07:00:00	AMZN	Stock	13.3255	13.3915	13.325	13.385	74160.0
2013-01-09 08:00:00	AMZN	Stock	13.385	13.441	13.3195	13.415	645800.0
2013-01-09 09:00:00	AMZN	Stock	13.4115	13.475	13.295	13.3215	9920640.0
2013-01-09 10:00:00	AMZN	Stock	13.327	13.409	13.3195	13.3725	6656280.0

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

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