PREVIEW / stock_1hour / 2011-08-09

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-08-09.parquet
  size:    1012 KB
  rows:    48,549
  symbols: 3,566

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-08-09 04:00:00	AAPL	Stock	12.5914	12.6104	12.3643	12.4861	280980.0
2011-08-09 05:00:00	AAPL	Stock	12.4714	12.5275	12.3396	12.5	244496.0
2011-08-09 06:00:00	AAPL	Stock	12.5	12.6618	12.4971	12.6429	707420.0
2011-08-09 07:00:00	AAPL	Stock	12.6496	12.8232	12.6154	12.7768	5391176.0
2011-08-09 08:00:00	AAPL	Stock	12.7821	12.8479	12.7071	12.8243	9172744.0
2011-08-09 09:00:00	AAPL	Stock	12.8225	12.9957	12.7161	12.9782	166749912.0
2011-08-09 10:00:00	AAPL	Stock	12.9793	13.1964	12.978	13.179	197939252.0
2011-08-09 11:00:00	AAPL	Stock	13.179	13.1979	13.06	13.17	93494184.0
2011-08-09 12:00:00	AAPL	Stock	13.1714	13.2104	13.125	13.1268	71929368.0
2011-08-09 13:00:00	AAPL	Stock	13.1254	13.1671	12.995	13.0711	78708784.0
2011-08-09 14:00:00	AAPL	Stock	13.0711	13.1768	12.6786	12.9236	220597188.0
2011-08-09 15:00:00	AAPL	Stock	12.9218	13.3789	12.8543	13.3721	192284176.0
2011-08-09 16:00:00	AAPL	Stock	13.3721	13.3789	13.0339	13.3307	22505392.0
2011-08-09 17:00:00	AAPL	Stock	13.3339	13.3993	13.1236	13.3971	1998556.0
2011-08-09 18:00:00	AAPL	Stock	13.3936	13.3996	13.3575	13.3996	821212.0
2011-08-09 19:00:00	AAPL	Stock	13.3932	13.4107	13.3871	13.4093	555968.0
2011-08-09 04:00:00	MSFT	Stock	24.1	24.1	24.1	24.1	200.0
2011-08-09 05:00:00	MSFT	Stock	24.02	24.17	24.0	24.17	1600.0
2011-08-09 06:00:00	MSFT	Stock	24.17	24.51	24.13	24.5	18430.0
2011-08-09 07:00:00	MSFT	Stock	24.47	24.71	24.44	24.6	56709.0
2011-08-09 08:00:00	MSFT	Stock	24.65	24.72	24.48	24.65	109823.0
2011-08-09 09:00:00	MSFT	Stock	24.6	24.98	24.3	24.97	17588885.0
2011-08-09 10:00:00	MSFT	Stock	24.98	25.13	24.61	24.64	17359363.0
2011-08-09 11:00:00	MSFT	Stock	24.63	24.855	24.49	24.82	11741650.0
2011-08-09 12:00:00	MSFT	Stock	24.82	25.0	24.781	24.81	8599542.0
2011-08-09 13:00:00	MSFT	Stock	24.806	24.87	24.51	24.64	7966343.0
2011-08-09 14:00:00	MSFT	Stock	24.649	24.97	24.03	24.32	28740000.0
2011-08-09 15:00:00	MSFT	Stock	24.31	25.62	24.15	25.61	24729337.0
2011-08-09 16:00:00	MSFT	Stock	25.62	25.75	24.702	25.68	6953320.0
2011-08-09 17:00:00	MSFT	Stock	25.7	25.8	24.682	25.79	242244.0
2011-08-09 18:00:00	MSFT	Stock	25.77	25.8	25.58	25.71	16061.0
2011-08-09 19:00:00	MSFT	Stock	25.71	25.76	25.71	25.72	3500.0
2011-08-09 06:00:00	NVDA	Stock	0.2962	0.2962	0.2962	0.2962	56000.0
2011-08-09 07:00:00	NVDA	Stock	0.3002	0.3075	0.3	0.305	165600.0
2011-08-09 08:00:00	NVDA	Stock	0.305	0.3075	0.3048	0.3048	655360.0
2011-08-09 09:00:00	NVDA	Stock	0.3025	0.3075	0.3	0.3058	128950800.0
2011-08-09 10:00:00	NVDA	Stock	0.306	0.3185	0.3058	0.3135	249638560.0
2011-08-09 11:00:00	NVDA	Stock	0.3133	0.3173	0.3095	0.3158	111290720.0
2011-08-09 12:00:00	NVDA	Stock	0.316	0.3213	0.3158	0.318	133192440.0
2011-08-09 13:00:00	NVDA	Stock	0.3178	0.319	0.3143	0.3151	116707600.0
2011-08-09 14:00:00	NVDA	Stock	0.315	0.321	0.3028	0.307	293713040.0
2011-08-09 15:00:00	NVDA	Stock	0.3068	0.3235	0.3045	0.3235	255208720.0
2011-08-09 16:00:00	NVDA	Stock	0.3235	0.3263	0.3127	0.325	10153120.0
2011-08-09 17:00:00	NVDA	Stock	0.3235	0.325	0.3233	0.3238	177600.0
2011-08-09 18:00:00	NVDA	Stock	0.3248	0.3263	0.3248	0.3263	45920.0
2011-08-09 19:00:00	NVDA	Stock	0.33	0.33	0.3295	0.3295	28000.0
2011-08-09 04:00:00	AMZN	Stock	9.74	9.74	9.578	9.578	8000.0
2011-08-09 05:00:00	AMZN	Stock	9.5055	9.652	9.5055	9.652	18000.0
2011-08-09 06:00:00	AMZN	Stock	9.561	9.561	9.561	9.561	2000.0
2011-08-09 07:00:00	AMZN	Stock	9.703	9.826	9.703	9.735	67000.0

> showing 50 of 48,549 rows — these rows as CSV

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