PREVIEW / stock_1hour / 2013-01-17

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-01-17.parquet
  size:    955 KB
  rows:    44,791
  symbols: 3,473

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-17 04:00:00	AAPL	Stock	18.0643	18.2143	18.0643	18.2036	158284.0
2013-01-17 05:00:00	AAPL	Stock	18.1964	18.2054	18.1432	18.1614	232232.0
2013-01-17 06:00:00	AAPL	Stock	18.1696	18.1964	18.1607	18.1964	126000.0
2013-01-17 07:00:00	AAPL	Stock	18.1786	18.2464	18.1679	18.2107	885500.0
2013-01-17 08:00:00	AAPL	Stock	18.2036	18.2496	18.0907	18.2121	6818700.0
2013-01-17 09:00:00	AAPL	Stock	18.2098	18.2411	17.9502	18.0275	101028872.0
2013-01-17 10:00:00	AAPL	Stock	18.0275	18.125	17.9771	17.9921	77248780.0
2013-01-17 11:00:00	AAPL	Stock	17.9964	18.0536	17.9414	17.9414	43145060.0
2013-01-17 12:00:00	AAPL	Stock	17.9414	18.0086	17.9296	17.9789	41873972.0
2013-01-17 13:00:00	AAPL	Stock	17.975	18.0786	17.9671	18.075	41175540.0
2013-01-17 14:00:00	AAPL	Stock	18.075	18.125	18.0168	18.0329	49143276.0
2013-01-17 15:00:00	AAPL	Stock	18.0336	18.0489	17.9359	17.9536	60720296.0
2013-01-17 16:00:00	AAPL	Stock	17.9534	18.0318	17.8593	17.8754	14420168.0
2013-01-17 17:00:00	AAPL	Stock	17.8804	17.9529	17.8532	17.8911	1161916.0
2013-01-17 18:00:00	AAPL	Stock	17.8929	17.8929	17.875	17.8857	261688.0
2013-01-17 19:00:00	AAPL	Stock	18.04	18.04	17.8754	17.9286	860496.0
2013-01-17 07:00:00	MSFT	Stock	27.18	27.18	27.16	27.16	11600.0
2013-01-17 08:00:00	MSFT	Stock	27.01	27.14	26.99	27.13	28579.0
2013-01-17 09:00:00	MSFT	Stock	27.12	27.22	27.06	27.195	5198020.0
2013-01-17 10:00:00	MSFT	Stock	27.19	27.31	27.15	27.25	8366212.0
2013-01-17 11:00:00	MSFT	Stock	27.255	27.37	27.22	27.32	5553741.0
2013-01-17 12:00:00	MSFT	Stock	27.32	27.4	27.32	27.38	4868406.0
2013-01-17 13:00:00	MSFT	Stock	27.38	27.47	27.35	27.47	4928347.0
2013-01-17 14:00:00	MSFT	Stock	27.47	27.47	27.342	27.37	4580228.0
2013-01-17 15:00:00	MSFT	Stock	27.38	27.38	27.23	27.23	10888116.0
2013-01-17 16:00:00	MSFT	Stock	27.24	27.363	27.04	27.09	6775035.0
2013-01-17 17:00:00	MSFT	Stock	27.09	27.23	27.05	27.07	28790.0
2013-01-17 18:00:00	MSFT	Stock	27.06	27.07	27.04	27.06	14139.0
2013-01-17 19:00:00	MSFT	Stock	27.06	27.11	27.05	27.07	10065.0
2013-01-17 08:00:00	NVDA	Stock	0.3038	0.3038	0.3038	0.3038	16000.0
2013-01-17 09:00:00	NVDA	Stock	0.303	0.3068	0.3025	0.3064	73350480.0
2013-01-17 10:00:00	NVDA	Stock	0.3064	0.3064	0.3032	0.304	61732360.0
2013-01-17 11:00:00	NVDA	Stock	0.3038	0.305	0.3028	0.3048	68659480.0
2013-01-17 12:00:00	NVDA	Stock	0.305	0.3055	0.3038	0.3046	94211400.0
2013-01-17 13:00:00	NVDA	Stock	0.3048	0.3069	0.3046	0.3059	79201520.0
2013-01-17 14:00:00	NVDA	Stock	0.306	0.307	0.3055	0.3061	45514520.0
2013-01-17 15:00:00	NVDA	Stock	0.306	0.3075	0.306	0.3062	140153760.0
2013-01-17 16:00:00	NVDA	Stock	0.3062	0.3075	0.3054	0.3062	14751040.0
2013-01-17 17:00:00	NVDA	Stock	0.3062	0.3062	0.3042	0.3042	171840.0
2013-01-17 18:00:00	NVDA	Stock	0.3052	0.3052	0.305	0.3052	84000.0
2013-01-17 19:00:00	NVDA	Stock	0.3045	0.3052	0.3045	0.3052	32000.0
2013-01-17 04:00:00	AMZN	Stock	13.502	13.502	13.502	13.502	2000.0
2013-01-17 05:00:00	AMZN	Stock	13.525	13.525	13.525	13.525	2000.0
2013-01-17 07:00:00	AMZN	Stock	13.5155	13.5155	13.4975	13.5	64000.0
2013-01-17 08:00:00	AMZN	Stock	13.5	13.5475	13.499	13.5425	131820.0
2013-01-17 09:00:00	AMZN	Stock	13.549	13.5985	13.4465	13.5083	8263860.0
2013-01-17 10:00:00	AMZN	Stock	13.505	13.574	13.4605	13.501	8562300.0
2013-01-17 11:00:00	AMZN	Stock	13.4985	13.574	13.485	13.5125	4355480.0
2013-01-17 12:00:00	AMZN	Stock	13.514	13.5695	13.514	13.5594	2582440.0
2013-01-17 13:00:00	AMZN	Stock	13.5595	13.564	13.5215	13.5526	2629000.0

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

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