PREVIEW / stock_1hour / 2012-10-08

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-10-08.parquet
  size:    902 KB
  rows:    42,963
  symbols: 3,439

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-10-08 04:00:00	AAPL	Stock	23.2168	23.2168	23.0893	23.125	157528.0
2012-10-08 05:00:00	AAPL	Stock	23.125	23.125	23.0911	23.1011	79940.0
2012-10-08 06:00:00	AAPL	Stock	23.105	23.1296	23.0886	23.125	70000.0
2012-10-08 07:00:00	AAPL	Stock	23.1254	23.1607	23.075	23.125	661724.0
2012-10-08 08:00:00	AAPL	Stock	23.1364	23.2114	23.0843	23.1107	3032372.0
2012-10-08 09:00:00	AAPL	Stock	23.1093	23.1382	22.9107	23.0286	109485992.0
2012-10-08 10:00:00	AAPL	Stock	23.0296	23.0846	22.7379	22.935	155276660.0
2012-10-08 11:00:00	AAPL	Stock	22.9254	22.9464	22.7975	22.8911	61478480.0
2012-10-08 12:00:00	AAPL	Stock	22.8911	22.9354	22.7429	22.8139	60539472.0
2012-10-08 13:00:00	AAPL	Stock	22.8071	22.8857	22.7182	22.767	55021148.0
2012-10-08 14:00:00	AAPL	Stock	22.7672	22.8671	22.7445	22.8318	42282828.0
2012-10-08 15:00:00	AAPL	Stock	22.8339	23.0446	22.7904	22.7918	128874088.0
2012-10-08 16:00:00	AAPL	Stock	22.7918	22.9652	22.7411	22.7411	5729388.0
2012-10-08 17:00:00	AAPL	Stock	22.7461	22.7918	22.6875	22.7036	878808.0
2012-10-08 18:00:00	AAPL	Stock	22.7061	22.7339	22.7061	22.7189	534072.0
2012-10-08 19:00:00	AAPL	Stock	22.7214	22.7393	22.7161	22.7393	285572.0
2012-10-08 08:00:00	MSFT	Stock	29.78	29.82	29.77	29.77	26700.0
2012-10-08 09:00:00	MSFT	Stock	29.78	29.81	29.55	29.795	3773480.0
2012-10-08 10:00:00	MSFT	Stock	29.795	29.92	29.731	29.875	4670393.0
2012-10-08 11:00:00	MSFT	Stock	29.87	29.9	29.71	29.8	3757421.0
2012-10-08 12:00:00	MSFT	Stock	29.79	29.8	29.72	29.76	3300489.0
2012-10-08 13:00:00	MSFT	Stock	29.76	29.79	29.74	29.78	2255985.0
2012-10-08 14:00:00	MSFT	Stock	29.77	29.8	29.73	29.75	3200940.0
2012-10-08 15:00:00	MSFT	Stock	29.75	29.84	29.75	29.79	7018195.0
2012-10-08 16:00:00	MSFT	Stock	29.78	29.8	29.73	29.8	1111204.0
2012-10-08 17:00:00	MSFT	Stock	29.7	29.78	29.7	29.78	12858.0
2012-10-08 18:00:00	MSFT	Stock	29.71	29.74	29.7	29.74	2900.0
2012-10-08 19:00:00	MSFT	Stock	29.74	29.74	29.74	29.74	700.0
2012-10-08 05:00:00	NVDA	Stock	0.3318	0.3318	0.3318	0.3318	4000.0
2012-10-08 09:00:00	NVDA	Stock	0.3313	0.3313	0.3268	0.3305	52691560.0
2012-10-08 10:00:00	NVDA	Stock	0.3305	0.3328	0.329	0.329	42618760.0
2012-10-08 11:00:00	NVDA	Stock	0.3293	0.3294	0.3278	0.3285	27460200.0
2012-10-08 12:00:00	NVDA	Stock	0.3288	0.3313	0.328	0.3313	37393640.0
2012-10-08 13:00:00	NVDA	Stock	0.331	0.3318	0.3303	0.3305	20172960.0
2012-10-08 14:00:00	NVDA	Stock	0.3305	0.3308	0.329	0.329	13119640.0
2012-10-08 15:00:00	NVDA	Stock	0.329	0.3303	0.329	0.3293	37731360.0
2012-10-08 16:00:00	NVDA	Stock	0.3293	0.332	0.329	0.3293	8771880.0
2012-10-08 17:00:00	NVDA	Stock	0.3293	0.3293	0.3293	0.3293	80000.0
2012-10-08 07:00:00	AMZN	Stock	12.8805	12.8805	12.875	12.875	12000.0
2012-10-08 08:00:00	AMZN	Stock	12.8625	12.875	12.85	12.85	50000.0
2012-10-08 09:00:00	AMZN	Stock	12.853	12.905	12.816	12.882	4351600.0
2012-10-08 10:00:00	AMZN	Stock	12.8805	12.9225	12.82	12.8325	4657060.0
2012-10-08 11:00:00	AMZN	Stock	12.832	12.8723	12.778	12.8723	4662500.0
2012-10-08 12:00:00	AMZN	Stock	12.869	12.937	12.863	12.932	4584480.0
2012-10-08 13:00:00	AMZN	Stock	12.937	12.9605	12.905	12.9135	4399540.0
2012-10-08 14:00:00	AMZN	Stock	12.9115	12.9207	12.8875	12.899	2445580.0
2012-10-08 15:00:00	AMZN	Stock	12.8965	12.99	12.8965	12.956	8324340.0
2012-10-08 16:00:00	AMZN	Stock	12.953	12.9838	12.8988	12.9838	1547980.0
2012-10-08 17:00:00	AMZN	Stock	12.9505	12.969	12.9505	12.969	4000.0
2012-10-08 18:00:00	AMZN	Stock	12.965	12.979	12.95	12.979	16000.0

> showing 50 of 42,963 rows — these rows as CSV

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