PREVIEW / stock_1hour / 2014-02-24

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-02-24.parquet
  size:    1.1 MB
  rows:    49,679
  symbols: 3,548

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-02-24 04:00:00	AAPL	Stock	18.7786	18.7786	18.7143	18.7143	75600.0
2014-02-24 05:00:00	AAPL	Stock	18.6907	18.6907	18.6907	18.6907	2800.0
2014-02-24 06:00:00	AAPL	Stock	18.6907	18.6907	18.6368	18.6643	143500.0
2014-02-24 07:00:00	AAPL	Stock	18.6711	18.7211	18.6643	18.7143	549976.0
2014-02-24 08:00:00	AAPL	Stock	18.7143	18.7218	18.6521	18.7107	1132404.0
2014-02-24 09:00:00	AAPL	Stock	18.7057	18.8864	18.6579	18.8768	50533336.0
2014-02-24 10:00:00	AAPL	Stock	18.8796	18.8839	18.7536	18.8093	35291732.0
2014-02-24 11:00:00	AAPL	Stock	18.8107	18.83	18.7543	18.7721	21053284.0
2014-02-24 12:00:00	AAPL	Stock	18.7736	18.7882	18.6607	18.6729	24276448.0
2014-02-24 13:00:00	AAPL	Stock	18.6725	18.775	18.6682	18.7482	18196052.0
2014-02-24 14:00:00	AAPL	Stock	18.7486	18.9257	18.7486	18.8905	34246660.0
2014-02-24 15:00:00	AAPL	Stock	18.8875	18.8964	18.8221	18.8407	31900372.0
2014-02-24 16:00:00	AAPL	Stock	18.8421	18.8617	18.8016	18.8393	20469596.0
2014-02-24 17:00:00	AAPL	Stock	18.8382	18.8439	18.8368	18.8411	202496.0
2014-02-24 18:00:00	AAPL	Stock	18.8404	18.8411	18.8364	18.8393	135436.0
2014-02-24 19:00:00	AAPL	Stock	18.8446	18.9007	18.8446	18.9007	323988.0
2014-02-24 04:00:00	MSFT	Stock	37.95	37.96	37.95	37.96	350.0
2014-02-24 06:00:00	MSFT	Stock	38.2	38.2	38.0	38.2	5290.0
2014-02-24 07:00:00	MSFT	Stock	38.12	38.12	37.95	38.0	8900.0
2014-02-24 08:00:00	MSFT	Stock	38.05	38.05	37.85	37.9	85200.0
2014-02-24 09:00:00	MSFT	Stock	37.9	37.94	37.54	37.84	3977201.0
2014-02-24 10:00:00	MSFT	Stock	37.84	37.91	37.77	37.865	4326435.0
2014-02-24 11:00:00	MSFT	Stock	37.86	37.94	37.82	37.82	4207011.0
2014-02-24 12:00:00	MSFT	Stock	37.825	37.91	37.81	37.89	3285129.0
2014-02-24 13:00:00	MSFT	Stock	37.89	37.975	37.76	37.79	2450892.0
2014-02-24 14:00:00	MSFT	Stock	37.8	37.85	37.78	37.78	2382253.0
2014-02-24 15:00:00	MSFT	Stock	37.78	37.84	37.67	37.69	6097317.0
2014-02-24 16:00:00	MSFT	Stock	37.69	37.83	37.6	37.67	4215693.0
2014-02-24 17:00:00	MSFT	Stock	37.65	37.69	37.65	37.69	136237.0
2014-02-24 18:00:00	MSFT	Stock	37.69	37.69	37.66	37.66	56350.0
2014-02-24 19:00:00	MSFT	Stock	37.66	37.69	37.66	37.69	1790.0
2014-02-24 09:00:00	NVDA	Stock	0.4692	0.4698	0.4608	0.4625	39801080.0
2014-02-24 10:00:00	NVDA	Stock	0.4628	0.4678	0.4626	0.4669	35060920.0
2014-02-24 11:00:00	NVDA	Stock	0.4669	0.4745	0.4668	0.4742	53138400.0
2014-02-24 12:00:00	NVDA	Stock	0.4741	0.4748	0.472	0.4729	45244920.0
2014-02-24 13:00:00	NVDA	Stock	0.4729	0.4748	0.4728	0.4742	28155400.0
2014-02-24 14:00:00	NVDA	Stock	0.4744	0.4763	0.474	0.4748	57247880.0
2014-02-24 15:00:00	NVDA	Stock	0.4749	0.475	0.472	0.472	77132080.0
2014-02-24 16:00:00	NVDA	Stock	0.472	0.474	0.4716	0.4721	10898240.0
2014-02-24 18:00:00	NVDA	Stock	0.474	0.4755	0.474	0.4745	128000.0
2014-02-24 19:00:00	NVDA	Stock	0.4742	0.4745	0.4742	0.4745	16800.0
2014-02-24 04:00:00	AMZN	Stock	17.375	17.3875	17.3295	17.3295	40000.0
2014-02-24 05:00:00	AMZN	Stock	17.3	17.3	17.3	17.3	2000.0
2014-02-24 06:00:00	AMZN	Stock	17.3025	17.3025	17.2625	17.269	9000.0
2014-02-24 07:00:00	AMZN	Stock	17.2875	17.3	17.2875	17.3	30000.0
2014-02-24 08:00:00	AMZN	Stock	17.3	17.4	17.257	17.295	126180.0
2014-02-24 09:00:00	AMZN	Stock	17.2985	17.45	17.1645	17.4395	10676800.0
2014-02-24 10:00:00	AMZN	Stock	17.441	17.537	17.431	17.523	11258540.0
2014-02-24 11:00:00	AMZN	Stock	17.5235	17.5724	17.5175	17.5455	9064280.0
2014-02-24 12:00:00	AMZN	Stock	17.548	17.591	17.51	17.5305	4277900.0

> showing 50 of 49,679 rows — these rows as CSV

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