PREVIEW / stock_1hour / 2014-12-04

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-12-04.parquet
  size:    1.0 MB
  rows:    49,298
  symbols: 3,536

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-04 04:00:00	AAPL	Stock	29.0375	29.075	29.02	29.075	6000.0
2014-12-04 05:00:00	AAPL	Stock	29.085	29.1225	29.075	29.1025	21424.0
2014-12-04 06:00:00	AAPL	Stock	29.1	29.1025	29.04	29.0425	47684.0
2014-12-04 07:00:00	AAPL	Stock	29.0625	29.075	29.025	29.025	135556.0
2014-12-04 08:00:00	AAPL	Stock	29.0362	29.1	28.89	28.9125	823664.0
2014-12-04 09:00:00	AAPL	Stock	28.9202	29.19	28.9025	29.17	20722708.0
2014-12-04 10:00:00	AAPL	Stock	29.1725	29.3	29.0875	29.1485	33304180.0
2014-12-04 11:00:00	AAPL	Stock	29.1488	29.15	28.975	29.075	20232544.0
2014-12-04 12:00:00	AAPL	Stock	29.0748	29.145	28.9432	29.0275	18084852.0
2014-12-04 13:00:00	AAPL	Stock	29.0275	29.0625	28.9775	29.0025	8882728.0
2014-12-04 14:00:00	AAPL	Stock	29.0025	29.0075	28.9188	28.955	10270372.0
2014-12-04 15:00:00	AAPL	Stock	28.955	28.97	28.8225	28.8725	24398396.0
2014-12-04 16:00:00	AAPL	Stock	28.8725	29.1302	28.8125	28.8522	20670252.0
2014-12-04 17:00:00	AAPL	Stock	28.845	28.8725	28.815	28.86	83092.0
2014-12-04 18:00:00	AAPL	Stock	28.86	28.9	28.855	28.885	159236.0
2014-12-04 19:00:00	AAPL	Stock	28.8775	28.88	28.855	28.8575	55764.0
2014-12-04 07:00:00	MSFT	Stock	48.16	48.16	48.16	48.16	500.0
2014-12-04 08:00:00	MSFT	Stock	48.08	48.25	48.05	48.05	31376.0
2014-12-04 09:00:00	MSFT	Stock	48.07	48.92	48.02	48.69	3905909.0
2014-12-04 10:00:00	MSFT	Stock	48.7	48.8	48.54	48.775	4110334.0
2014-12-04 11:00:00	MSFT	Stock	48.77	48.91	48.63	48.82	2969556.0
2014-12-04 12:00:00	MSFT	Stock	48.825	49.06	48.82	48.94	2957582.0
2014-12-04 13:00:00	MSFT	Stock	48.94	49.02	48.88	48.97	2608233.0
2014-12-04 14:00:00	MSFT	Stock	48.97	49.02	48.91	49.02	3366621.0
2014-12-04 15:00:00	MSFT	Stock	49.02	49.05	48.8	48.85	6395443.0
2014-12-04 16:00:00	MSFT	Stock	48.84	48.949	48.79	48.84	3079235.0
2014-12-04 17:00:00	MSFT	Stock	48.84	48.84	48.84	48.84	5612.0
2014-12-04 18:00:00	MSFT	Stock	48.82	48.83	48.82	48.83	2850.0
2014-12-04 08:00:00	NVDA	Stock	0.5285	0.5312	0.5285	0.5312	48000.0
2014-12-04 09:00:00	NVDA	Stock	0.5272	0.5298	0.5255	0.5265	16722400.0
2014-12-04 10:00:00	NVDA	Stock	0.5265	0.5278	0.5236	0.5247	34625640.0
2014-12-04 11:00:00	NVDA	Stock	0.5247	0.525	0.5202	0.5234	39272920.0
2014-12-04 12:00:00	NVDA	Stock	0.5234	0.5249	0.5228	0.5244	24681840.0
2014-12-04 13:00:00	NVDA	Stock	0.5245	0.5255	0.5239	0.525	10082640.0
2014-12-04 14:00:00	NVDA	Stock	0.525	0.526	0.5242	0.5249	13253840.0
2014-12-04 15:00:00	NVDA	Stock	0.5249	0.5255	0.5228	0.524	34447920.0
2014-12-04 16:00:00	NVDA	Stock	0.5238	0.5245	0.5237	0.5245	3125680.0
2014-12-04 04:00:00	AMZN	Stock	15.8225	15.8225	15.8225	15.8225	2000.0
2014-12-04 07:00:00	AMZN	Stock	15.825	15.825	15.785	15.8	12000.0
2014-12-04 08:00:00	AMZN	Stock	15.8415	15.8415	15.75	15.7575	163980.0
2014-12-04 09:00:00	AMZN	Stock	15.77	15.9295	15.6735	15.894	13805000.0
2014-12-04 10:00:00	AMZN	Stock	15.8905	15.9145	15.7095	15.7715	11114180.0
2014-12-04 11:00:00	AMZN	Stock	15.766	15.8185	15.7105	15.8185	7341460.0
2014-12-04 12:00:00	AMZN	Stock	15.8085	15.8395	15.769	15.826	4288740.0
2014-12-04 13:00:00	AMZN	Stock	15.8245	15.829	15.7805	15.806	4266420.0
2014-12-04 14:00:00	AMZN	Stock	15.8045	15.8585	15.7942	15.826	4619060.0
2014-12-04 15:00:00	AMZN	Stock	15.8265	15.857	15.7795	15.8465	11283720.0
2014-12-04 16:00:00	AMZN	Stock	15.8465	15.9	15.7697	15.8465	566800.0
2014-12-04 17:00:00	AMZN	Stock	15.85	15.85	15.85	15.85	2700.0
2014-12-04 18:00:00	AMZN	Stock	15.8465	15.853	15.8465	15.85	37880.0

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

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