PREVIEW / stock_1hour / 2012-04-26

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-04-26.parquet
  size:    941 KB
  rows:    44,578
  symbols: 3,533

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-04-26 04:00:00	AAPL	Stock	21.8932	21.9554	21.8593	21.8629	105644.0
2012-04-26 05:00:00	AAPL	Stock	21.8661	21.8982	21.8393	21.8571	116200.0
2012-04-26 06:00:00	AAPL	Stock	21.8411	21.8568	21.7857	21.8054	61012.0
2012-04-26 07:00:00	AAPL	Stock	21.8071	21.8579	21.7857	21.8482	346360.0
2012-04-26 08:00:00	AAPL	Stock	21.8518	21.9082	21.7982	21.9036	5454512.0
2012-04-26 09:00:00	AAPL	Stock	21.8989	21.9557	21.6968	21.7125	88657492.0
2012-04-26 10:00:00	AAPL	Stock	21.7139	21.7925	21.5575	21.5982	96619348.0
2012-04-26 11:00:00	AAPL	Stock	21.6007	21.66	21.5046	21.5875	79056852.0
2012-04-26 12:00:00	AAPL	Stock	21.59	21.6175	21.5504	21.5671	29505532.0
2012-04-26 13:00:00	AAPL	Stock	21.5632	21.7071	21.5539	21.6861	53743172.0
2012-04-26 14:00:00	AAPL	Stock	21.685	21.7836	21.6461	21.7768	63275996.0
2012-04-26 15:00:00	AAPL	Stock	21.7783	21.8	21.6589	21.7043	87057264.0
2012-04-26 16:00:00	AAPL	Stock	21.6939	21.755	21.6697	21.7146	18138540.0
2012-04-26 17:00:00	AAPL	Stock	21.7143	21.7221	21.6232	21.6429	1329160.0
2012-04-26 18:00:00	AAPL	Stock	21.6375	21.6429	21.6	21.6286	725816.0
2012-04-26 19:00:00	AAPL	Stock	21.635	21.6411	21.5893	21.5893	457940.0
2012-04-26 08:00:00	MSFT	Stock	32.21	32.23	32.11	32.13	5469.0
2012-04-26 09:00:00	MSFT	Stock	32.12	32.17	32.03	32.09	3902384.0
2012-04-26 10:00:00	MSFT	Stock	32.1	32.15	31.92	31.945	5740855.0
2012-04-26 11:00:00	MSFT	Stock	31.95	32.115	31.935	32.0	4279449.0
2012-04-26 12:00:00	MSFT	Stock	32.0	32.03	31.96	31.99	3274383.0
2012-04-26 13:00:00	MSFT	Stock	31.99	32.11	31.97	32.098	4584561.0
2012-04-26 14:00:00	MSFT	Stock	32.1	32.23	32.08	32.2	6218713.0
2012-04-26 15:00:00	MSFT	Stock	32.2	32.23	32.04	32.12	9720894.0
2012-04-26 16:00:00	MSFT	Stock	32.11	32.23	32.075	32.09	1934618.0
2012-04-26 17:00:00	MSFT	Stock	32.09	32.11	32.05	32.05	10538.0
2012-04-26 18:00:00	MSFT	Stock	32.05	32.07	32.01	32.05	6313.0
2012-04-26 19:00:00	MSFT	Stock	32.03	32.07	32.02	32.07	1456.0
2012-04-26 07:00:00	NVDA	Stock	0.334	0.334	0.3335	0.3335	56000.0
2012-04-26 08:00:00	NVDA	Stock	0.325	0.328	0.325	0.3253	230000.0
2012-04-26 09:00:00	NVDA	Stock	0.3253	0.3293	0.323	0.3275	49690600.0
2012-04-26 10:00:00	NVDA	Stock	0.3275	0.3295	0.3245	0.325	79337560.0
2012-04-26 11:00:00	NVDA	Stock	0.325	0.3285	0.325	0.3284	91936560.0
2012-04-26 12:00:00	NVDA	Stock	0.3285	0.33	0.327	0.3273	111784880.0
2012-04-26 13:00:00	NVDA	Stock	0.3274	0.3283	0.3265	0.3278	46046480.0
2012-04-26 14:00:00	NVDA	Stock	0.328	0.3283	0.327	0.3275	58955840.0
2012-04-26 15:00:00	NVDA	Stock	0.3275	0.328	0.3268	0.3273	89440520.0
2012-04-26 16:00:00	NVDA	Stock	0.3273	0.3278	0.325	0.3273	10729200.0
2012-04-26 17:00:00	NVDA	Stock	0.3273	0.3275	0.3268	0.3275	346320.0
2012-04-26 18:00:00	NVDA	Stock	0.327	0.327	0.327	0.327	5200.0
2012-04-26 19:00:00	NVDA	Stock	0.3265	0.3265	0.3265	0.3265	6000.0
2012-04-26 07:00:00	AMZN	Stock	9.739	9.739	9.686	9.686	20000.0
2012-04-26 08:00:00	AMZN	Stock	9.686	9.7175	9.65	9.692	209120.0
2012-04-26 09:00:00	AMZN	Stock	9.6845	9.749	9.651	9.6775	12824600.0
2012-04-26 10:00:00	AMZN	Stock	9.6775	9.719	9.654	9.675	12294540.0
2012-04-26 11:00:00	AMZN	Stock	9.6765	9.705	9.67	9.697	9177460.0
2012-04-26 12:00:00	AMZN	Stock	9.696	9.73	9.6701	9.7175	9713960.0
2012-04-26 13:00:00	AMZN	Stock	9.7145	9.784	9.6995	9.7575	12606500.0
2012-04-26 14:00:00	AMZN	Stock	9.757	9.818	9.757	9.765	18899560.0
2012-04-26 15:00:00	AMZN	Stock	9.765	9.8	9.6961	9.799	35277220.0

> showing 50 of 44,578 rows — these rows as CSV

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