PREVIEW / stock_1hour / 2014-12-22

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-12-22.parquet
  size:    1.1 MB
  rows:    50,097
  symbols: 3,566

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-12-22 04:00:00	AAPL	Stock	28.0925	28.105	28.05	28.05	2000.0
2014-12-22 05:00:00	AAPL	Stock	28.06	28.07	28.0525	28.0525	4668.0
2014-12-22 06:00:00	AAPL	Stock	28.06	28.065	28.055	28.065	17840.0
2014-12-22 07:00:00	AAPL	Stock	28.055	28.055	28.01	28.0275	134924.0
2014-12-22 08:00:00	AAPL	Stock	28.025	28.0625	27.945	28.035	445564.0
2014-12-22 09:00:00	AAPL	Stock	28.035	28.1795	27.9925	28.098	20260940.0
2014-12-22 10:00:00	AAPL	Stock	28.0952	28.3725	28.0575	28.2825	26401128.0
2014-12-22 11:00:00	AAPL	Stock	28.28	28.3525	28.2125	28.2462	16862572.0
2014-12-22 12:00:00	AAPL	Stock	28.245	28.255	28.1625	28.1725	11430004.0
2014-12-22 13:00:00	AAPL	Stock	28.17	28.205	28.1375	28.18	11316308.0
2014-12-22 14:00:00	AAPL	Stock	28.18	28.18	28.1	28.125	11928316.0
2014-12-22 15:00:00	AAPL	Stock	28.125	28.2725	28.125	28.235	26842424.0
2014-12-22 16:00:00	AAPL	Stock	28.235	28.25	28.1688	28.2	33019260.0
2014-12-22 17:00:00	AAPL	Stock	28.1875	28.235	28.1875	28.235	396196.0
2014-12-22 18:00:00	AAPL	Stock	28.2125	28.235	28.1525	28.21	78536.0
2014-12-22 19:00:00	AAPL	Stock	28.21	28.215	28.16	28.1775	57948.0
2014-12-22 05:00:00	MSFT	Stock	47.86	47.86	47.86	47.86	200.0
2014-12-22 06:00:00	MSFT	Stock	47.89	47.9	47.89	47.9	200.0
2014-12-22 07:00:00	MSFT	Stock	47.85	47.85	47.8	47.8	2600.0
2014-12-22 08:00:00	MSFT	Stock	47.77	47.9	47.77	47.8	3016.0
2014-12-22 09:00:00	MSFT	Stock	47.89	48.12	47.71	47.97	2465658.0
2014-12-22 10:00:00	MSFT	Stock	47.975	48.1	47.84	47.97	2272085.0
2014-12-22 11:00:00	MSFT	Stock	47.97	48.02	47.835	47.835	2164913.0
2014-12-22 12:00:00	MSFT	Stock	47.835	47.92	47.78	47.835	1630774.0
2014-12-22 13:00:00	MSFT	Stock	47.84	47.9	47.78	47.865	1324578.0
2014-12-22 14:00:00	MSFT	Stock	47.86	47.95	47.83	47.87	2240413.0
2014-12-22 15:00:00	MSFT	Stock	47.87	48.0	47.86	48.0	4994465.0
2014-12-22 16:00:00	MSFT	Stock	47.98	48.0	47.87	47.94	8343945.0
2014-12-22 17:00:00	MSFT	Stock	47.98	47.98	47.88	47.98	80691.0
2014-12-22 18:00:00	MSFT	Stock	47.89	47.98	47.89	47.98	2459.0
2014-12-22 19:00:00	MSFT	Stock	47.95	47.95	47.95	47.95	600.0
2014-12-22 09:00:00	NVDA	Stock	0.5112	0.515	0.5082	0.5138	23979480.0
2014-12-22 10:00:00	NVDA	Stock	0.5135	0.5168	0.5125	0.5166	20286120.0
2014-12-22 11:00:00	NVDA	Stock	0.5166	0.518	0.5145	0.516	20064640.0
2014-12-22 12:00:00	NVDA	Stock	0.5158	0.5185	0.5152	0.5185	12616600.0
2014-12-22 13:00:00	NVDA	Stock	0.5182	0.519	0.5168	0.5173	13081880.0
2014-12-22 14:00:00	NVDA	Stock	0.5171	0.5178	0.5168	0.5178	11675920.0
2014-12-22 15:00:00	NVDA	Stock	0.5176	0.5195	0.5175	0.5195	31147760.0
2014-12-22 16:00:00	NVDA	Stock	0.5195	0.5195	0.5162	0.5162	11410080.0
2014-12-22 17:00:00	NVDA	Stock	0.5195	0.5195	0.5195	0.5195	211760.0
2014-12-22 06:00:00	AMZN	Stock	15.05	15.05	15.05	15.05	2000.0
2014-12-22 08:00:00	AMZN	Stock	15.089	15.089	15.05	15.055	104000.0
2014-12-22 09:00:00	AMZN	Stock	15.0475	15.332	15.0475	15.3205	14221300.0
2014-12-22 10:00:00	AMZN	Stock	15.322	15.356	15.257	15.2615	12528600.0
2014-12-22 11:00:00	AMZN	Stock	15.2613	15.32	15.225	15.274	8407260.0
2014-12-22 12:00:00	AMZN	Stock	15.2705	15.3125	15.2505	15.305	6701120.0
2014-12-22 13:00:00	AMZN	Stock	15.3081	15.368	15.2965	15.3345	7675360.0
2014-12-22 14:00:00	AMZN	Stock	15.329	15.36	15.2845	15.2845	7255980.0
2014-12-22 15:00:00	AMZN	Stock	15.289	15.3445	15.2815	15.3275	10802700.0
2014-12-22 16:00:00	AMZN	Stock	15.327	15.3325	15.0325	15.2886	4348580.0

> showing 50 of 50,097 rows — these rows as CSV

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