PREVIEW / stock_1hour / 2011-07-19

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-07-19.parquet
  size:    959 KB
  rows:    46,025
  symbols: 3,530

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-07-19 04:00:00	AAPL	Stock	13.4404	13.4696	13.4404	13.4646	31808.0
2011-07-19 05:00:00	AAPL	Stock	13.4646	13.4757	13.4536	13.4536	52192.0
2011-07-19 06:00:00	AAPL	Stock	13.4643	13.4643	13.4082	13.4329	72800.0
2011-07-19 07:00:00	AAPL	Stock	13.4143	13.4821	13.4129	13.4557	975520.0
2011-07-19 08:00:00	AAPL	Stock	13.4557	13.5625	13.4518	13.5193	8984668.0
2011-07-19 09:00:00	AAPL	Stock	13.5186	13.5254	13.4107	13.4654	108679788.0
2011-07-19 10:00:00	AAPL	Stock	13.4675	13.5232	13.4589	13.4643	84255556.0
2011-07-19 11:00:00	AAPL	Stock	13.4622	13.4764	13.3329	13.4196	103176248.0
2011-07-19 12:00:00	AAPL	Stock	13.4214	13.4229	13.3643	13.4068	58352672.0
2011-07-19 13:00:00	AAPL	Stock	13.4066	13.4214	13.38	13.4131	76795208.0
2011-07-19 14:00:00	AAPL	Stock	13.4132	13.4718	13.4082	13.4434	75271056.0
2011-07-19 15:00:00	AAPL	Stock	13.4454	13.4589	13.3968	13.4589	149847348.0
2011-07-19 16:00:00	AAPL	Stock	13.4419	14.4643	13.375	14.1893	78834140.0
2011-07-19 17:00:00	AAPL	Stock	14.1889	14.2679	13.4589	14.1714	49027244.0
2011-07-19 18:00:00	AAPL	Stock	14.1711	14.1964	13.4589	14.0296	7691152.0
2011-07-19 19:00:00	AAPL	Stock	14.0307	14.0893	14.0114	14.0714	2810640.0
2011-07-19 05:00:00	MSFT	Stock	26.75	26.86	26.75	26.86	200.0
2011-07-19 07:00:00	MSFT	Stock	26.75	26.79	26.72	26.72	1500.0
2011-07-19 08:00:00	MSFT	Stock	26.7	26.77	26.68	26.74	12825.0
2011-07-19 09:00:00	MSFT	Stock	26.75	27.09	26.72	26.985	8735054.0
2011-07-19 10:00:00	MSFT	Stock	26.99	27.218	26.965	27.17	11290517.0
2011-07-19 11:00:00	MSFT	Stock	27.17	27.25	27.15	27.22	8245508.0
2011-07-19 12:00:00	MSFT	Stock	27.23	27.43	27.18	27.353	8903062.0
2011-07-19 13:00:00	MSFT	Stock	27.36	27.58	27.32	27.536	11627715.0
2011-07-19 14:00:00	MSFT	Stock	27.532	27.555	27.38	27.49	12277240.0
2011-07-19 15:00:00	MSFT	Stock	27.481	27.64	27.47	27.54	18754709.0
2011-07-19 16:00:00	MSFT	Stock	27.55	27.6	26.59	27.52	2996639.0
2011-07-19 17:00:00	MSFT	Stock	27.49	27.55	27.44	27.5	286792.0
2011-07-19 18:00:00	MSFT	Stock	27.5	27.54	27.46	27.49	106497.0
2011-07-19 19:00:00	MSFT	Stock	27.53	27.53	27.48	27.48	6968.0
2011-07-19 08:00:00	NVDA	Stock	0.3498	0.35	0.3498	0.35	272000.0
2011-07-19 09:00:00	NVDA	Stock	0.3493	0.3543	0.3458	0.3542	111528120.0
2011-07-19 10:00:00	NVDA	Stock	0.3542	0.3562	0.3533	0.3547	112157120.0
2011-07-19 11:00:00	NVDA	Stock	0.3548	0.3553	0.3525	0.354	78727120.0
2011-07-19 12:00:00	NVDA	Stock	0.354	0.355	0.3533	0.3542	49688400.0
2011-07-19 13:00:00	NVDA	Stock	0.3542	0.355	0.3525	0.354	51340200.0
2011-07-19 14:00:00	NVDA	Stock	0.3538	0.3547	0.3522	0.3542	58259040.0
2011-07-19 15:00:00	NVDA	Stock	0.3542	0.3562	0.354	0.3558	117904840.0
2011-07-19 16:00:00	NVDA	Stock	0.3562	0.358	0.3518	0.3562	11733080.0
2011-07-19 17:00:00	NVDA	Stock	0.357	0.357	0.3562	0.357	798680.0
2011-07-19 18:00:00	NVDA	Stock	0.3568	0.357	0.3568	0.357	52000.0
2011-07-19 04:00:00	AMZN	Stock	10.6215	10.6395	10.6215	10.6395	4000.0
2011-07-19 07:00:00	AMZN	Stock	10.65	10.7195	10.65	10.678	91400.0
2011-07-19 08:00:00	AMZN	Stock	10.675	10.722	10.675	10.71	188020.0
2011-07-19 09:00:00	AMZN	Stock	10.722	10.891	10.6885	10.8115	14388160.0
2011-07-19 10:00:00	AMZN	Stock	10.817	10.8715	10.7985	10.8122	9148400.0
2011-07-19 11:00:00	AMZN	Stock	10.816	10.909	10.7985	10.895	12653060.0
2011-07-19 12:00:00	AMZN	Stock	10.895	10.915	10.8615	10.881	9390600.0
2011-07-19 13:00:00	AMZN	Stock	10.881	10.9	10.8519	10.8734	8843580.0
2011-07-19 14:00:00	AMZN	Stock	10.8735	10.92	10.8655	10.9005	8925120.0

> showing 50 of 46,025 rows — these rows as CSV

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