PREVIEW / stock_1hour / 2013-05-09

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-05-09.parquet
  size:    990 KB
  rows:    45,841
  symbols: 3,494

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-05-09 04:00:00	AAPL	Stock	16.5275	16.5275	16.475	16.5036	64260.0
2013-05-09 05:00:00	AAPL	Stock	16.4821	16.4821	16.475	16.475	11200.0
2013-05-09 06:00:00	AAPL	Stock	16.4671	16.4675	16.4107	16.4429	120652.0
2013-05-09 07:00:00	AAPL	Stock	16.4357	16.5071	16.4329	16.4446	827848.0
2013-05-09 08:00:00	AAPL	Stock	16.445	16.4925	16.3857	16.4354	3241168.0
2013-05-09 09:00:00	AAPL	Stock	16.4357	16.5357	16.3429	16.4257	77427196.0
2013-05-09 10:00:00	AAPL	Stock	16.4261	16.4389	16.3721	16.39	64577184.0
2013-05-09 11:00:00	AAPL	Stock	16.3861	16.4643	16.3447	16.4521	52094560.0
2013-05-09 12:00:00	AAPL	Stock	16.454	16.4914	16.4179	16.4736	32447296.0
2013-05-09 13:00:00	AAPL	Stock	16.4761	16.4893	16.4268	16.4782	33440708.0
2013-05-09 14:00:00	AAPL	Stock	16.4761	16.4825	16.3529	16.3643	41451480.0
2013-05-09 15:00:00	AAPL	Stock	16.3636	16.39	16.2707	16.3125	69316464.0
2013-05-09 16:00:00	AAPL	Stock	16.3132	16.4091	16.2986	16.3132	13484100.0
2013-05-09 17:00:00	AAPL	Stock	16.2975	16.3132	16.275	16.3125	552496.0
2013-05-09 18:00:00	AAPL	Stock	16.2946	16.3	16.2821	16.2875	314608.0
2013-05-09 19:00:00	AAPL	Stock	16.2886	16.2993	16.2861	16.2982	213948.0
2013-05-09 07:00:00	MSFT	Stock	32.91	32.91	32.84	32.85	1900.0
2013-05-09 08:00:00	MSFT	Stock	32.85	32.99	32.7	32.73	163337.0
2013-05-09 09:00:00	MSFT	Stock	32.72	32.98	32.62	32.875	7019096.0
2013-05-09 10:00:00	MSFT	Stock	32.875	32.89	32.59	32.75	9068368.0
2013-05-09 11:00:00	MSFT	Stock	32.745	32.86	32.72	32.845	3815493.0
2013-05-09 12:00:00	MSFT	Stock	32.845	32.89	32.79	32.88	2176852.0
2013-05-09 13:00:00	MSFT	Stock	32.876	33.0	32.87	32.919	4195921.0
2013-05-09 14:00:00	MSFT	Stock	32.92	32.93	32.77	32.771	4741440.0
2013-05-09 15:00:00	MSFT	Stock	32.78	32.81	32.6	32.66	10256084.0
2013-05-09 16:00:00	MSFT	Stock	32.66	32.772	32.62	32.65	2203719.0
2013-05-09 17:00:00	MSFT	Stock	32.67	32.7	32.62	32.7	28073.0
2013-05-09 18:00:00	MSFT	Stock	32.7	32.76	32.67	32.67	6703.0
2013-05-09 19:00:00	MSFT	Stock	32.66	32.7	32.61	32.61	11900.0
2013-05-09 08:00:00	NVDA	Stock	0.3498	0.3498	0.348	0.348	16000.0
2013-05-09 09:00:00	NVDA	Stock	0.3475	0.3475	0.3408	0.3465	25522280.0
2013-05-09 10:00:00	NVDA	Stock	0.3465	0.3473	0.345	0.3459	75120000.0
2013-05-09 11:00:00	NVDA	Stock	0.3458	0.3478	0.3453	0.3477	48910680.0
2013-05-09 12:00:00	NVDA	Stock	0.3478	0.3493	0.3468	0.3473	27376680.0
2013-05-09 13:00:00	NVDA	Stock	0.347	0.3485	0.3465	0.3475	66782320.0
2013-05-09 14:00:00	NVDA	Stock	0.3475	0.3475	0.3448	0.3458	81911680.0
2013-05-09 15:00:00	NVDA	Stock	0.3455	0.3478	0.344	0.3478	204790080.0
2013-05-09 16:00:00	NVDA	Stock	0.3478	0.36	0.3378	0.3518	22332040.0
2013-05-09 17:00:00	NVDA	Stock	0.3525	0.353	0.3478	0.3513	6595080.0
2013-05-09 18:00:00	NVDA	Stock	0.3505	0.3515	0.35	0.3513	329600.0
2013-05-09 19:00:00	NVDA	Stock	0.3513	0.3513	0.35	0.3513	550600.0
2013-05-09 05:00:00	AMZN	Stock	12.924	12.924	12.924	12.924	2000.0
2013-05-09 08:00:00	AMZN	Stock	12.925	12.934	12.877	12.89	193500.0
2013-05-09 09:00:00	AMZN	Stock	12.8945	13.0175	12.8945	12.9758	4949360.0
2013-05-09 10:00:00	AMZN	Stock	12.973	12.9772	12.844	12.94	8483920.0
2013-05-09 11:00:00	AMZN	Stock	12.937	13.06	12.936	13.033	5941620.0
2013-05-09 12:00:00	AMZN	Stock	13.0315	13.0625	13.022	13.0545	4166820.0
2013-05-09 13:00:00	AMZN	Stock	13.0525	13.1775	13.046	13.1485	11015360.0
2013-05-09 14:00:00	AMZN	Stock	13.151	13.1625	12.9848	12.9979	8466640.0
2013-05-09 15:00:00	AMZN	Stock	12.9985	13.0697	12.9795	13.006	9836800.0

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

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