PREVIEW / stock_1hour / 2013-08-16

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-08-16.parquet
  size:    1007 KB
  rows:    46,506
  symbols: 3,505

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-08-16 04:00:00	AAPL	Stock	17.8321	17.8682	17.8321	17.8607	31668.0
2013-08-16 05:00:00	AAPL	Stock	17.8671	17.8671	17.8036	17.8211	112532.0
2013-08-16 06:00:00	AAPL	Stock	17.8496	17.8496	17.8471	17.8471	5600.0
2013-08-16 07:00:00	AAPL	Stock	17.8393	17.8882	17.8232	17.8807	477792.0
2013-08-16 08:00:00	AAPL	Stock	17.8761	17.8911	17.8286	17.8907	1860068.0
2013-08-16 09:00:00	AAPL	Stock	17.8879	17.9286	17.8164	17.8832	77683200.0
2013-08-16 10:00:00	AAPL	Stock	17.8876	17.9621	17.8593	17.9579	58397164.0
2013-08-16 11:00:00	AAPL	Stock	17.9557	17.9593	17.8968	17.9079	29714272.0
2013-08-16 12:00:00	AAPL	Stock	17.9086	17.9129	17.8632	17.8907	23967412.0
2013-08-16 13:00:00	AAPL	Stock	17.8889	17.8911	17.8486	17.8736	22451184.0
2013-08-16 14:00:00	AAPL	Stock	17.87	17.9079	17.8614	17.9007	25842600.0
2013-08-16 15:00:00	AAPL	Stock	17.9007	17.9489	17.8656	17.9386	63304752.0
2013-08-16 16:00:00	AAPL	Stock	17.9404	17.9868	17.895	17.9761	30316748.0
2013-08-16 17:00:00	AAPL	Stock	17.975	17.9889	17.9404	17.9643	1625512.0
2013-08-16 18:00:00	AAPL	Stock	17.9668	17.9818	17.9643	17.9743	168280.0
2013-08-16 19:00:00	AAPL	Stock	17.9732	17.9811	17.9646	17.9679	287588.0
2013-08-16 08:00:00	MSFT	Stock	31.87	31.87	31.82	31.84	1500.0
2013-08-16 09:00:00	MSFT	Stock	31.84	31.88	31.71	31.845	6728667.0
2013-08-16 10:00:00	MSFT	Stock	31.85	31.889	31.735	31.855	3813431.0
2013-08-16 11:00:00	MSFT	Stock	31.855	31.99	31.79	31.9	2975265.0
2013-08-16 12:00:00	MSFT	Stock	31.9	31.9	31.8	31.874	2408614.0
2013-08-16 13:00:00	MSFT	Stock	31.88	31.9	31.67	31.711	2026865.0
2013-08-16 14:00:00	MSFT	Stock	31.71	31.82	31.66	31.811	3159776.0
2013-08-16 15:00:00	MSFT	Stock	31.811	31.96	31.78	31.79	7333674.0
2013-08-16 16:00:00	MSFT	Stock	31.8	31.867	31.67	31.69	2813009.0
2013-08-16 17:00:00	MSFT	Stock	31.8	31.83	31.73	31.8	547334.0
2013-08-16 18:00:00	MSFT	Stock	31.73	31.79	31.73	31.79	627.0
2013-08-16 19:00:00	MSFT	Stock	31.73	31.74	31.69	31.74	950.0
2013-08-16 08:00:00	NVDA	Stock	0.381	0.3813	0.3788	0.38	236000.0
2013-08-16 09:00:00	NVDA	Stock	0.38	0.3813	0.3775	0.3801	80174920.0
2013-08-16 10:00:00	NVDA	Stock	0.3803	0.3819	0.3785	0.3799	112591840.0
2013-08-16 11:00:00	NVDA	Stock	0.38	0.385	0.3796	0.3836	132795440.0
2013-08-16 12:00:00	NVDA	Stock	0.3838	0.384	0.3808	0.381	131094880.0
2013-08-16 13:00:00	NVDA	Stock	0.381	0.381	0.3768	0.3785	44236480.0
2013-08-16 14:00:00	NVDA	Stock	0.3784	0.3799	0.3783	0.3785	45738360.0
2013-08-16 15:00:00	NVDA	Stock	0.3785	0.3813	0.3785	0.3795	96255160.0
2013-08-16 16:00:00	NVDA	Stock	0.3795	0.3813	0.3781	0.3798	14538880.0
2013-08-16 08:00:00	AMZN	Stock	14.3495	14.35	14.3235	14.3235	254960.0
2013-08-16 09:00:00	AMZN	Stock	14.345	14.345	14.2325	14.34	9131060.0
2013-08-16 10:00:00	AMZN	Stock	14.338	14.4165	14.315	14.3705	7325960.0
2013-08-16 11:00:00	AMZN	Stock	14.3695	14.385	14.3285	14.348	3542380.0
2013-08-16 12:00:00	AMZN	Stock	14.3485	14.361	14.2805	14.2923	4049300.0
2013-08-16 13:00:00	AMZN	Stock	14.2945	14.3066	14.246	14.279	3840700.0
2013-08-16 14:00:00	AMZN	Stock	14.279	14.311	14.2645	14.311	3705560.0
2013-08-16 15:00:00	AMZN	Stock	14.31	14.322	14.225	14.2255	9788920.0
2013-08-16 16:00:00	AMZN	Stock	14.2333	14.3235	14.2255	14.248	6163460.0
2013-08-16 17:00:00	AMZN	Stock	14.2515	14.255	14.241	14.255	99720.0
2013-08-16 19:00:00	AMZN	Stock	14.2495	14.2495	14.2315	14.2315	4000.0
2013-08-16 04:00:00	META	Stock	36.74	36.94	36.73	36.92	10400.0
2013-08-16 05:00:00	META	Stock	36.87	36.89	36.67	36.74	2058.0

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

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