PREVIEW / stock_1hour / 2013-01-08

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-01-08.parquet
  size:    957 KB
  rows:    45,345
  symbols: 3,448

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-08 04:00:00	AAPL	Stock	18.6743	18.6743	18.6743	18.6743	2800.0
2013-01-08 05:00:00	AAPL	Stock	18.6864	18.7143	18.6864	18.7143	48468.0
2013-01-08 06:00:00	AAPL	Stock	18.7325	18.8214	18.7325	18.7929	80836.0
2013-01-08 07:00:00	AAPL	Stock	18.7846	18.8107	18.7143	18.7543	655228.0
2013-01-08 08:00:00	AAPL	Stock	18.7539	18.9911	18.725	18.9054	6230672.0
2013-01-08 09:00:00	AAPL	Stock	18.9054	18.9961	18.7657	18.7905	85857548.0
2013-01-08 10:00:00	AAPL	Stock	18.7864	18.8525	18.6721	18.7114	80844764.0
2013-01-08 11:00:00	AAPL	Stock	18.7114	18.7586	18.6161	18.6849	61873504.0
2013-01-08 12:00:00	AAPL	Stock	18.685	18.7375	18.625	18.6607	37158212.0
2013-01-08 13:00:00	AAPL	Stock	18.6607	18.8068	18.6604	18.8025	38922520.0
2013-01-08 14:00:00	AAPL	Stock	18.8055	18.8371	18.715	18.74	45433668.0
2013-01-08 15:00:00	AAPL	Stock	18.7391	18.8643	18.7368	18.7568	72574488.0
2013-01-08 16:00:00	AAPL	Stock	18.7575	18.8406	18.7318	18.7464	11856096.0
2013-01-08 17:00:00	AAPL	Stock	18.7461	18.7611	18.7396	18.7446	327236.0
2013-01-08 18:00:00	AAPL	Stock	18.7464	18.7654	18.7464	18.7629	208516.0
2013-01-08 19:00:00	AAPL	Stock	18.7639	18.7993	18.7639	18.7925	556696.0
2013-01-08 06:00:00	MSFT	Stock	26.71	26.71	26.71	26.71	400.0
2013-01-08 07:00:00	MSFT	Stock	26.74	26.75	26.74	26.74	5360.0
2013-01-08 08:00:00	MSFT	Stock	26.74	26.79	26.72	26.77	23063.0
2013-01-08 09:00:00	MSFT	Stock	26.75	26.8	26.52	26.52	5401005.0
2013-01-08 10:00:00	MSFT	Stock	26.52	26.6	26.5	26.517	6346895.0
2013-01-08 11:00:00	MSFT	Stock	26.511	26.58	26.48	26.52	5696525.0
2013-01-08 12:00:00	MSFT	Stock	26.525	26.53	26.46	26.485	3386090.0
2013-01-08 13:00:00	MSFT	Stock	26.485	26.59	26.48	26.52	4590352.0
2013-01-08 14:00:00	MSFT	Stock	26.52	26.61	26.51	26.55	3336311.0
2013-01-08 15:00:00	MSFT	Stock	26.547	26.63	26.51	26.54	11194982.0
2013-01-08 16:00:00	MSFT	Stock	26.55	26.65	26.535	26.6	1962876.0
2013-01-08 17:00:00	MSFT	Stock	26.58	26.64	26.55	26.6	28908.0
2013-01-08 18:00:00	MSFT	Stock	26.55	26.62	26.55	26.61	24894.0
2013-01-08 19:00:00	MSFT	Stock	26.61	26.65	26.6	26.65	10058.0
2013-01-08 08:00:00	NVDA	Stock	0.3188	0.322	0.3188	0.3193	246000.0
2013-01-08 09:00:00	NVDA	Stock	0.32	0.321	0.3178	0.3188	42314160.0
2013-01-08 10:00:00	NVDA	Stock	0.3185	0.3186	0.3125	0.3125	96437760.0
2013-01-08 11:00:00	NVDA	Stock	0.3128	0.3155	0.3125	0.3144	59516280.0
2013-01-08 12:00:00	NVDA	Stock	0.3145	0.3148	0.3133	0.3135	28589840.0
2013-01-08 13:00:00	NVDA	Stock	0.3134	0.3153	0.3133	0.3136	30219160.0
2013-01-08 14:00:00	NVDA	Stock	0.3135	0.314	0.3103	0.3103	77021000.0
2013-01-08 15:00:00	NVDA	Stock	0.3105	0.3135	0.31	0.3125	113764240.0
2013-01-08 16:00:00	NVDA	Stock	0.3125	0.314	0.312	0.3125	16671560.0
2013-01-08 18:00:00	NVDA	Stock	0.3145	0.3148	0.3145	0.3148	200000.0
2013-01-08 04:00:00	AMZN	Stock	13.4995	13.516	13.4995	13.516	8000.0
2013-01-08 05:00:00	AMZN	Stock	13.4995	13.4995	13.4985	13.4985	13000.0
2013-01-08 07:00:00	AMZN	Stock	13.475	13.475	13.447	13.45	16000.0
2013-01-08 08:00:00	AMZN	Stock	13.447	13.447	13.32	13.3975	374600.0
2013-01-08 09:00:00	AMZN	Stock	13.387	13.449	13.2875	13.3072	10363540.0
2013-01-08 10:00:00	AMZN	Stock	13.307	13.338	13.2515	13.2965	11362440.0
2013-01-08 11:00:00	AMZN	Stock	13.2985	13.3145	13.1784	13.2635	13993340.0
2013-01-08 12:00:00	AMZN	Stock	13.2715	13.312	13.238	13.255	3505340.0
2013-01-08 13:00:00	AMZN	Stock	13.2535	13.339	13.2515	13.3005	3901180.0
2013-01-08 14:00:00	AMZN	Stock	13.303	13.3282	13.2175	13.2526	5511960.0

> showing 50 of 45,345 rows — these rows as CSV

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