PREVIEW / stock_1hour / 2014-10-06

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-10-06.parquet
  size:    1.0 MB
  rows:    48,437
  symbols: 3,558

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-10-06 04:00:00	AAPL	Stock	24.905	25.0375	24.905	25.0375	16100.0
2014-10-06 05:00:00	AAPL	Stock	25.03	25.04	24.975	25.0	8316.0
2014-10-06 06:00:00	AAPL	Stock	24.995	25.0	24.975	24.9825	20716.0
2014-10-06 07:00:00	AAPL	Stock	24.995	25.0475	24.95	25.025	137960.0
2014-10-06 08:00:00	AAPL	Stock	25.0	25.055	24.9775	25.015	506740.0
2014-10-06 09:00:00	AAPL	Stock	25.0175	25.1625	24.9475	25.1312	24466144.0
2014-10-06 10:00:00	AAPL	Stock	25.1318	25.1575	24.9875	25.0425	28289012.0
2014-10-06 11:00:00	AAPL	Stock	25.0425	25.0625	24.89	24.9525	18611560.0
2014-10-06 12:00:00	AAPL	Stock	24.9513	25.0	24.8825	24.9175	13103900.0
2014-10-06 13:00:00	AAPL	Stock	24.915	25.021	24.896	24.97	13368560.0
2014-10-06 14:00:00	AAPL	Stock	24.9725	24.9975	24.912	24.9425	13682288.0
2014-10-06 15:00:00	AAPL	Stock	24.9402	24.96	24.855	24.9062	23324584.0
2014-10-06 16:00:00	AAPL	Stock	24.905	25.0552	24.7975	24.835	4159508.0
2014-10-06 17:00:00	AAPL	Stock	24.8325	24.905	24.8325	24.8625	843576.0
2014-10-06 18:00:00	AAPL	Stock	24.85	24.905	24.85	24.905	222880.0
2014-10-06 19:00:00	AAPL	Stock	24.8525	24.905	24.8225	24.8575	110932.0
2014-10-06 07:00:00	MSFT	Stock	46.19	46.31	46.19	46.31	300.0
2014-10-06 08:00:00	MSFT	Stock	46.22	46.22	45.54	46.12	8709.0
2014-10-06 09:00:00	MSFT	Stock	46.18	46.3	45.92	46.24	2820623.0
2014-10-06 10:00:00	MSFT	Stock	46.25	46.3	46.09	46.14	3534234.0
2014-10-06 11:00:00	MSFT	Stock	46.14	46.25	45.965	46.02	3266589.0
2014-10-06 12:00:00	MSFT	Stock	46.02	46.08	45.96	46.01	1836237.0
2014-10-06 13:00:00	MSFT	Stock	46.0	46.12	45.95	46.08	1597711.0
2014-10-06 14:00:00	MSFT	Stock	46.085	46.16	46.03	46.09	1937173.0
2014-10-06 15:00:00	MSFT	Stock	46.09	46.17	46.015	46.1	3822044.0
2014-10-06 16:00:00	MSFT	Stock	46.09	46.173	46.06	46.07	1040116.0
2014-10-06 17:00:00	MSFT	Stock	46.09	46.09	46.09	46.09	102.0
2014-10-06 18:00:00	MSFT	Stock	46.08	46.09	46.07	46.09	70833.0
2014-10-06 19:00:00	MSFT	Stock	45.97	45.97	45.97	45.97	100.0
2014-10-06 09:00:00	NVDA	Stock	0.4575	0.4612	0.4568	0.459	14660560.0
2014-10-06 10:00:00	NVDA	Stock	0.459	0.4598	0.4518	0.4535	32886000.0
2014-10-06 11:00:00	NVDA	Stock	0.4535	0.4545	0.45	0.4524	25378840.0
2014-10-06 12:00:00	NVDA	Stock	0.4522	0.4548	0.4508	0.452	19368960.0
2014-10-06 13:00:00	NVDA	Stock	0.452	0.4558	0.4518	0.455	16953320.0
2014-10-06 14:00:00	NVDA	Stock	0.455	0.4575	0.4542	0.455	15934680.0
2014-10-06 15:00:00	NVDA	Stock	0.4549	0.455	0.452	0.453	55380360.0
2014-10-06 16:00:00	NVDA	Stock	0.453	0.4542	0.4529	0.453	16379280.0
2014-10-06 18:00:00	NVDA	Stock	0.453	0.453	0.453	0.453	226960.0
2014-10-06 07:00:00	AMZN	Stock	16.1635	16.1635	16.1635	16.1635	6000.0
2014-10-06 08:00:00	AMZN	Stock	16.137	16.2125	16.137	16.189	235340.0
2014-10-06 09:00:00	AMZN	Stock	16.189	16.2065	16.0885	16.092	6675720.0
2014-10-06 10:00:00	AMZN	Stock	16.101	16.118	15.9955	16.027	8461680.0
2014-10-06 11:00:00	AMZN	Stock	16.0285	16.0785	15.98	16.007	5538680.0
2014-10-06 12:00:00	AMZN	Stock	16.007	16.075	15.9995	16.0683	3509340.0
2014-10-06 13:00:00	AMZN	Stock	16.062	16.1245	16.047	16.1115	3650120.0
2014-10-06 14:00:00	AMZN	Stock	16.109	16.164	16.076	16.129	4707920.0
2014-10-06 15:00:00	AMZN	Stock	16.121	16.151	16.085	16.11	7569400.0
2014-10-06 16:00:00	AMZN	Stock	16.11	16.11	16.0186	16.1005	1293420.0
2014-10-06 18:00:00	AMZN	Stock	16.11	16.11	16.102	16.11	145600.0
2014-10-06 07:00:00	GOOGL	Stock	29.429	29.429	29.429	29.429	2000.0

> showing 50 of 48,437 rows — these rows as CSV

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