PREVIEW / stock_1hour / 2012-05-01

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-05-01.parquet
  size:    969 KB
  rows:    46,003
  symbols: 3,561

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-05-01 04:00:00	AAPL	Stock	20.8564	20.8571	20.8214	20.8214	28812.0
2012-05-01 05:00:00	AAPL	Stock	20.8214	20.8214	20.8214	20.8214	14000.0
2012-05-01 06:00:00	AAPL	Stock	20.8214	20.8214	20.7929	20.7946	31780.0
2012-05-01 07:00:00	AAPL	Stock	20.8482	21.02	20.8482	20.9782	682080.0
2012-05-01 08:00:00	AAPL	Stock	20.9761	20.9979	20.8214	20.9068	2567740.0
2012-05-01 09:00:00	AAPL	Stock	20.8982	21.1586	20.7582	21.075	113729392.0
2012-05-01 10:00:00	AAPL	Stock	21.0875	21.3129	21.0778	21.2296	118634796.0
2012-05-01 11:00:00	AAPL	Stock	21.23	21.2832	21.2021	21.2354	42900480.0
2012-05-01 12:00:00	AAPL	Stock	21.2352	21.2396	21.0482	21.1804	65110472.0
2012-05-01 13:00:00	AAPL	Stock	21.1808	21.185	20.9121	20.9354	61717348.0
2012-05-01 14:00:00	AAPL	Stock	20.9396	20.9796	20.7704	20.8907	104381508.0
2012-05-01 15:00:00	AAPL	Stock	20.8886	20.9482	20.7886	20.7914	80491796.0
2012-05-01 16:00:00	AAPL	Stock	20.7904	21.2519	20.7536	20.7825	9193044.0
2012-05-01 17:00:00	AAPL	Stock	20.7814	20.7904	20.7696	20.7775	523600.0
2012-05-01 18:00:00	AAPL	Stock	20.7786	20.8154	20.7786	20.8118	476504.0
2012-05-01 19:00:00	AAPL	Stock	20.8125	20.8179	20.7957	20.8075	336308.0
2012-05-01 08:00:00	MSFT	Stock	32.04	32.04	31.96	32.02	29296.0
2012-05-01 09:00:00	MSFT	Stock	32.02	32.11	31.96	32.01	3276226.0
2012-05-01 10:00:00	MSFT	Stock	32.02	32.23	32.01	32.177	7668388.0
2012-05-01 11:00:00	MSFT	Stock	32.17	32.335	32.16	32.282	5140842.0
2012-05-01 12:00:00	MSFT	Stock	32.285	32.31	32.24	32.25	2582207.0
2012-05-01 13:00:00	MSFT	Stock	32.24	32.25	32.11	32.2	2575393.0
2012-05-01 14:00:00	MSFT	Stock	32.19	32.21	32.09	32.135	3397546.0
2012-05-01 15:00:00	MSFT	Stock	32.14	32.15	31.95	32.02	12506881.0
2012-05-01 16:00:00	MSFT	Stock	32.02	32.113	31.98	31.99	5577763.0
2012-05-01 17:00:00	MSFT	Stock	31.99	32.0	31.99	31.99	5721.0
2012-05-01 18:00:00	MSFT	Stock	31.99	31.99	31.98	31.99	991.0
2012-05-01 19:00:00	MSFT	Stock	32.0	32.0	31.9	31.9	963.0
2012-05-01 07:00:00	NVDA	Stock	0.3275	0.3275	0.3275	0.3275	8000.0
2012-05-01 09:00:00	NVDA	Stock	0.325	0.3273	0.3233	0.3255	24685200.0
2012-05-01 10:00:00	NVDA	Stock	0.3255	0.331	0.3255	0.3305	63704040.0
2012-05-01 11:00:00	NVDA	Stock	0.3303	0.3329	0.33	0.3328	61678040.0
2012-05-01 12:00:00	NVDA	Stock	0.3328	0.333	0.3318	0.3325	51608240.0
2012-05-01 13:00:00	NVDA	Stock	0.3322	0.3325	0.3308	0.3315	37379560.0
2012-05-01 14:00:00	NVDA	Stock	0.3316	0.333	0.3313	0.3313	53604960.0
2012-05-01 15:00:00	NVDA	Stock	0.3314	0.3342	0.3305	0.3309	105544640.0
2012-05-01 16:00:00	NVDA	Stock	0.3308	0.3318	0.3305	0.3318	1462040.0
2012-05-01 17:00:00	NVDA	Stock	0.3308	0.3308	0.3293	0.3293	44000.0
2012-05-01 19:00:00	NVDA	Stock	0.3308	0.3308	0.3308	0.3308	124000.0
2012-05-01 07:00:00	AMZN	Stock	11.62	11.68	11.62	11.65	82600.0
2012-05-01 08:00:00	AMZN	Stock	11.65	11.684	11.511	11.543	495800.0
2012-05-01 09:00:00	AMZN	Stock	11.5495	11.5495	11.42	11.475	21039100.0
2012-05-01 10:00:00	AMZN	Stock	11.476	11.5955	11.476	11.5692	23153160.0
2012-05-01 11:00:00	AMZN	Stock	11.5685	11.6485	11.561	11.6145	19921780.0
2012-05-01 12:00:00	AMZN	Stock	11.614	11.6175	11.591	11.6072	9393640.0
2012-05-01 13:00:00	AMZN	Stock	11.6055	11.609	11.538	11.5805	13803800.0
2012-05-01 14:00:00	AMZN	Stock	11.581	11.6325	11.5735	11.5855	18714500.0
2012-05-01 15:00:00	AMZN	Stock	11.589	11.618	11.497	11.5015	24481060.0
2012-05-01 16:00:00	AMZN	Stock	11.499	11.5827	11.4588	11.505	2702340.0
2012-05-01 17:00:00	AMZN	Stock	11.506	11.506	11.501	11.501	13500.0

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

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