PREVIEW / stock_1hour / 2012-09-17

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-09-17.parquet
  size:    932 KB
  rows:    43,902
  symbols: 3,458

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
2012-09-17 04:00:00	AAPL	Stock	24.7857	24.795	24.7643	24.795	39172.0
2012-09-17 05:00:00	AAPL	Stock	24.7679	24.7679	24.7679	24.7679	2800.0
2012-09-17 06:00:00	AAPL	Stock	24.8068	24.8068	24.7857	24.7929	98756.0
2012-09-17 07:00:00	AAPL	Stock	24.7857	24.85	24.7682	24.8032	896756.0
2012-09-17 08:00:00	AAPL	Stock	24.7989	24.9118	24.78	24.8957	5685008.0
2012-09-17 09:00:00	AAPL	Stock	24.8964	24.9939	24.8089	24.8389	83540856.0
2012-09-17 10:00:00	AAPL	Stock	24.8367	24.9704	24.8289	24.9671	60862620.0
2012-09-17 11:00:00	AAPL	Stock	24.9671	24.9718	24.9104	24.9357	35579068.0
2012-09-17 12:00:00	AAPL	Stock	24.935	24.9657	24.9286	24.9379	20962032.0
2012-09-17 13:00:00	AAPL	Stock	24.9361	24.9429	24.8636	24.8736	30864400.0
2012-09-17 14:00:00	AAPL	Stock	24.8715	24.9318	24.8075	24.9146	43590820.0
2012-09-17 15:00:00	AAPL	Stock	24.9129	24.9929	24.8464	24.9929	69947752.0
2012-09-17 16:00:00	AAPL	Stock	24.9929	25.0157	24.8661	24.995	25781672.0
2012-09-17 17:00:00	AAPL	Stock	24.9964	25.0639	24.9921	25.0514	3309964.0
2012-09-17 18:00:00	AAPL	Stock	25.05	25.0518	25.0221	25.0393	989464.0
2012-09-17 19:00:00	AAPL	Stock	25.0357	25.0714	25.0357	25.0679	636552.0
2012-09-17 04:00:00	MSFT	Stock	31.02	31.09	31.02	31.09	300.0
2012-09-17 05:00:00	MSFT	Stock	31.38	31.38	31.32	31.32	200.0
2012-09-17 06:00:00	MSFT	Stock	31.5	31.5	31.21	31.21	300.0
2012-09-17 07:00:00	MSFT	Stock	31.2	31.24	31.19	31.24	800.0
2012-09-17 08:00:00	MSFT	Stock	31.15	31.2	31.1	31.16	1776.0
2012-09-17 09:00:00	MSFT	Stock	31.19	31.26	31.04	31.12	3131714.0
2012-09-17 10:00:00	MSFT	Stock	31.12	31.22	31.06	31.115	6754646.0
2012-09-17 11:00:00	MSFT	Stock	31.11	31.16	31.08	31.15	3869962.0
2012-09-17 12:00:00	MSFT	Stock	31.14	31.175	31.11	31.12	2574260.0
2012-09-17 13:00:00	MSFT	Stock	31.12	31.2	31.1	31.166	2180328.0
2012-09-17 14:00:00	MSFT	Stock	31.17	31.17	31.09	31.105	4373698.0
2012-09-17 15:00:00	MSFT	Stock	31.11	31.21	31.09	31.21	5322411.0
2012-09-17 16:00:00	MSFT	Stock	31.21	31.22	31.102	31.19	6230588.0
2012-09-17 17:00:00	MSFT	Stock	31.17	31.2	31.17	31.17	2005.0
2012-09-17 19:00:00	MSFT	Stock	31.2	31.2	31.2	31.2	350.0
2012-09-17 08:00:00	NVDA	Stock	0.3453	0.3453	0.3453	0.3453	92000.0
2012-09-17 09:00:00	NVDA	Stock	0.3453	0.3468	0.3328	0.336	96675720.0
2012-09-17 10:00:00	NVDA	Stock	0.336	0.3385	0.3338	0.3358	86340040.0
2012-09-17 11:00:00	NVDA	Stock	0.3358	0.338	0.3345	0.3375	60941960.0
2012-09-17 12:00:00	NVDA	Stock	0.3375	0.3382	0.337	0.3376	28286720.0
2012-09-17 13:00:00	NVDA	Stock	0.3378	0.3378	0.3348	0.3355	37439840.0
2012-09-17 14:00:00	NVDA	Stock	0.3355	0.3365	0.3348	0.3361	33498600.0
2012-09-17 15:00:00	NVDA	Stock	0.3361	0.3365	0.3344	0.3362	96002360.0
2012-09-17 16:00:00	NVDA	Stock	0.3365	0.3366	0.3353	0.3365	5494760.0
2012-09-17 19:00:00	NVDA	Stock	0.336	0.336	0.336	0.336	16000.0
2012-09-17 07:00:00	AMZN	Stock	13.1875	13.1875	13.05	13.05	27200.0
2012-09-17 08:00:00	AMZN	Stock	13.0635	13.089	13.055	13.0575	56580.0
2012-09-17 09:00:00	AMZN	Stock	13.0585	13.0635	12.93	12.9715	4588700.0
2012-09-17 10:00:00	AMZN	Stock	12.965	13.022	12.95	12.9924	6313320.0
2012-09-17 11:00:00	AMZN	Stock	12.9935	13.013	12.95	12.964	4622500.0
2012-09-17 12:00:00	AMZN	Stock	12.9655	12.9905	12.94	12.955	3387000.0
2012-09-17 13:00:00	AMZN	Stock	12.955	12.9566	12.8725	12.8825	5733680.0
2012-09-17 14:00:00	AMZN	Stock	12.8848	12.9185	12.8585	12.887	4598840.0
2012-09-17 15:00:00	AMZN	Stock	12.8895	12.909	12.85	12.8995	8454840.0

> showing 50 of 43,902 rows — these rows as CSV

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