PREVIEW / stock_1hour / 2013-12-09

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-12-09.parquet
  size:    1.0 MB
  rows:    48,618
  symbols: 3,549

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-12-09 04:00:00	AAPL	Stock	20.0864	20.0864	20.0725	20.075	50400.0
2013-12-09 05:00:00	AAPL	Stock	20.0621	20.0621	20.0429	20.0429	29820.0
2013-12-09 06:00:00	AAPL	Stock	20.0679	20.0771	20.0679	20.0757	46228.0
2013-12-09 07:00:00	AAPL	Stock	20.08	20.1161	20.0657	20.1071	243264.0
2013-12-09 08:00:00	AAPL	Stock	20.0982	20.1107	20.0518	20.0725	1866564.0
2013-12-09 09:00:00	AAPL	Stock	20.0775	20.2134	20.0186	20.1256	50822800.0
2013-12-09 10:00:00	AAPL	Stock	20.1339	20.2521	20.1114	20.2482	46398716.0
2013-12-09 11:00:00	AAPL	Stock	20.2493	20.3196	20.2411	20.2889	46600960.0
2013-12-09 12:00:00	AAPL	Stock	20.2893	20.3354	20.2664	20.2979	30362500.0
2013-12-09 13:00:00	AAPL	Stock	20.2975	20.3421	20.2939	20.305	17275048.0
2013-12-09 14:00:00	AAPL	Stock	20.3054	20.3121	20.2329	20.2504	24388504.0
2013-12-09 15:00:00	AAPL	Stock	20.2507	20.2729	20.2132	20.2357	31173744.0
2013-12-09 16:00:00	AAPL	Stock	20.2296	20.3412	20.2107	20.2264	14950712.0
2013-12-09 17:00:00	AAPL	Stock	20.2236	20.25	20.2236	20.2496	330904.0
2013-12-09 18:00:00	AAPL	Stock	20.2493	20.2714	20.2296	20.2607	235508.0
2013-12-09 19:00:00	AAPL	Stock	20.2589	20.2679	20.25	20.2661	136388.0
2013-12-09 04:00:00	MSFT	Stock	38.36	38.36	38.36	38.36	300.0
2013-12-09 05:00:00	MSFT	Stock	38.38	38.4	38.38	38.4	553.0
2013-12-09 06:00:00	MSFT	Stock	38.41	38.41	38.38	38.38	440.0
2013-12-09 07:00:00	MSFT	Stock	38.5	38.5	38.45	38.48	2661.0
2013-12-09 08:00:00	MSFT	Stock	38.46	38.49	38.41	38.45	36497.0
2013-12-09 09:00:00	MSFT	Stock	38.46	38.68	38.37	38.59	4361156.0
2013-12-09 10:00:00	MSFT	Stock	38.59	38.8	38.59	38.735	4097902.0
2013-12-09 11:00:00	MSFT	Stock	38.735	38.74	38.56	38.56	2541939.0
2013-12-09 12:00:00	MSFT	Stock	38.56	38.74	38.52	38.73	2334888.0
2013-12-09 13:00:00	MSFT	Stock	38.74	38.87	38.72	38.83	2345166.0
2013-12-09 14:00:00	MSFT	Stock	38.83	38.83	38.63	38.64	3401494.0
2013-12-09 15:00:00	MSFT	Stock	38.63	38.74	38.6	38.67	5955163.0
2013-12-09 16:00:00	MSFT	Stock	38.67	38.727	38.649	38.66	3830552.0
2013-12-09 17:00:00	MSFT	Stock	38.726	38.726	38.67	38.67	3716.0
2013-12-09 18:00:00	MSFT	Stock	38.69	38.69	38.67	38.67	11399.0
2013-12-09 19:00:00	MSFT	Stock	38.72	38.72	38.72	38.72	250.0
2013-12-09 09:00:00	NVDA	Stock	0.3873	0.388	0.3816	0.3822	41229680.0
2013-12-09 10:00:00	NVDA	Stock	0.3822	0.3825	0.3795	0.382	65867800.0
2013-12-09 11:00:00	NVDA	Stock	0.3821	0.3833	0.382	0.3822	33286720.0
2013-12-09 12:00:00	NVDA	Stock	0.3822	0.3825	0.3818	0.3822	26604040.0
2013-12-09 13:00:00	NVDA	Stock	0.3824	0.383	0.3818	0.3825	23946200.0
2013-12-09 14:00:00	NVDA	Stock	0.3822	0.3828	0.3815	0.3824	24200240.0
2013-12-09 15:00:00	NVDA	Stock	0.3825	0.3825	0.38	0.3803	70035760.0
2013-12-09 16:00:00	NVDA	Stock	0.3801	0.3805	0.3799	0.3805	74231360.0
2013-12-09 17:00:00	NVDA	Stock	0.3798	0.3798	0.3798	0.3798	40000.0
2013-12-09 19:00:00	NVDA	Stock	0.38	0.38	0.38	0.38	90000.0
2013-12-09 04:00:00	AMZN	Stock	19.4	19.4	19.4	19.4	2000.0
2013-12-09 05:00:00	AMZN	Stock	19.3825	19.3825	19.3825	19.3825	2000.0
2013-12-09 06:00:00	AMZN	Stock	19.3865	19.3865	19.3865	19.3865	2000.0
2013-12-09 07:00:00	AMZN	Stock	19.395	19.395	19.3785	19.3785	12000.0
2013-12-09 08:00:00	AMZN	Stock	19.38	19.38	19.3735	19.3735	4000.0
2013-12-09 09:00:00	AMZN	Stock	19.375	19.5	19.188	19.266	7430700.0
2013-12-09 10:00:00	AMZN	Stock	19.2638	19.2935	19.1285	19.2023	8957660.0
2013-12-09 11:00:00	AMZN	Stock	19.195	19.273	19.166	19.1715	4320380.0

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

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