PREVIEW / stock_1hour / 2014-06-13

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-06-13.parquet
  size:    1.0 MB
  rows:    47,858
  symbols: 3,529

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
2014-06-13 04:00:00	AAPL	Stock	23.0625	23.0625	22.9	22.935	40580.0
2014-06-13 05:00:00	AAPL	Stock	22.92	22.95	22.8	22.81	72696.0
2014-06-13 06:00:00	AAPL	Stock	22.81	22.8875	22.8025	22.87	143000.0
2014-06-13 07:00:00	AAPL	Stock	22.87	22.925	22.86	22.9075	647808.0
2014-06-13 08:00:00	AAPL	Stock	22.9125	23.0925	22.85	23.0825	1916560.0
2014-06-13 09:00:00	AAPL	Stock	23.09	23.1575	22.9175	22.9365	33476868.0
2014-06-13 10:00:00	AAPL	Stock	22.9362	23.035	22.82	23.03	41184000.0
2014-06-13 11:00:00	AAPL	Stock	23.03	23.0375	22.85	22.8775	20607000.0
2014-06-13 12:00:00	AAPL	Stock	22.8775	22.9625	22.865	22.8657	15331488.0
2014-06-13 13:00:00	AAPL	Stock	22.865	22.895	22.7875	22.863	20048820.0
2014-06-13 14:00:00	AAPL	Stock	22.8625	22.925	22.835	22.835	17965708.0
2014-06-13 15:00:00	AAPL	Stock	22.8375	22.875	22.72	22.815	42389332.0
2014-06-13 16:00:00	AAPL	Stock	22.815	22.97	22.75	22.8575	11011420.0
2014-06-13 17:00:00	AAPL	Stock	22.8575	22.875	22.82	22.8725	646244.0
2014-06-13 18:00:00	AAPL	Stock	22.8725	22.88	22.8675	22.87	222048.0
2014-06-13 19:00:00	AAPL	Stock	22.87	22.875	22.8625	22.87	68712.0
2014-06-13 04:00:00	MSFT	Stock	40.8	40.8	40.8	40.8	130.0
2014-06-13 05:00:00	MSFT	Stock	40.85	40.89	40.85	40.89	2950.0
2014-06-13 06:00:00	MSFT	Stock	40.89	40.89	40.89	40.89	100.0
2014-06-13 07:00:00	MSFT	Stock	40.75	41.08	40.75	41.08	10560.0
2014-06-13 08:00:00	MSFT	Stock	41.08	41.19	40.9	41.18	42653.0
2014-06-13 09:00:00	MSFT	Stock	41.15	41.19	40.86	41.185	3839792.0
2014-06-13 10:00:00	MSFT	Stock	41.182	41.565	41.07	41.39	6565830.0
2014-06-13 11:00:00	MSFT	Stock	41.4	41.44	41.11	41.19	3302019.0
2014-06-13 12:00:00	MSFT	Stock	41.19	41.33	41.16	41.244	1518345.0
2014-06-13 13:00:00	MSFT	Stock	41.244	41.35	41.18	41.35	1401770.0
2014-06-13 14:00:00	MSFT	Stock	41.34	41.38	41.23	41.245	1595166.0
2014-06-13 15:00:00	MSFT	Stock	41.25	41.29	41.09	41.23	4970039.0
2014-06-13 16:00:00	MSFT	Stock	41.22	41.385	41.194	41.23	2378341.0
2014-06-13 17:00:00	MSFT	Stock	41.23	41.23	41.22	41.23	3250.0
2014-06-13 18:00:00	MSFT	Stock	41.2	41.24	41.2	41.24	3360.0
2014-06-13 19:00:00	MSFT	Stock	41.25	41.26	41.16	41.16	600.0
2014-06-13 08:00:00	NVDA	Stock	0.4925	0.4925	0.4925	0.4925	120000.0
2014-06-13 09:00:00	NVDA	Stock	0.4932	0.4932	0.4865	0.4872	28657560.0
2014-06-13 10:00:00	NVDA	Stock	0.487	0.4902	0.4838	0.4898	56263080.0
2014-06-13 11:00:00	NVDA	Stock	0.4898	0.4908	0.4868	0.487	28338800.0
2014-06-13 12:00:00	NVDA	Stock	0.487	0.488	0.4862	0.4862	19179000.0
2014-06-13 13:00:00	NVDA	Stock	0.4862	0.488	0.4862	0.4879	16949480.0
2014-06-13 14:00:00	NVDA	Stock	0.4878	0.4883	0.487	0.4872	16842400.0
2014-06-13 15:00:00	NVDA	Stock	0.4871	0.4885	0.4865	0.4883	47808720.0
2014-06-13 16:00:00	NVDA	Stock	0.4883	0.4886	0.4878	0.4886	9804480.0
2014-06-13 17:00:00	NVDA	Stock	0.489	0.489	0.489	0.489	8000.0
2014-06-13 08:00:00	AMZN	Stock	16.323	16.36	16.269	16.345	172380.0
2014-06-13 09:00:00	AMZN	Stock	16.345	16.4649	16.2335	16.272	10182320.0
2014-06-13 10:00:00	AMZN	Stock	16.275	16.407	16.1763	16.35	11713300.0
2014-06-13 11:00:00	AMZN	Stock	16.3535	16.387	16.3045	16.34	6255280.0
2014-06-13 12:00:00	AMZN	Stock	16.3325	16.418	16.3295	16.332	4345660.0
2014-06-13 13:00:00	AMZN	Stock	16.331	16.3445	16.3	16.3416	3361340.0
2014-06-13 14:00:00	AMZN	Stock	16.346	16.3625	16.305	16.305	3103760.0
2014-06-13 15:00:00	AMZN	Stock	16.3055	16.334	16.22	16.3135	10238940.0

> showing 50 of 47,858 rows — these rows as CSV

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