PREVIEW / stock_1hour / 2011-01-26

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-01-26.parquet
  size:    957 KB
  rows:    45,912
  symbols: 3,516

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
2011-01-26 04:00:00	AAPL	Stock	12.2457	12.3161	12.2457	12.3071	38500.0
2011-01-26 05:00:00	AAPL	Stock	12.3079	12.3161	12.2893	12.3161	79660.0
2011-01-26 06:00:00	AAPL	Stock	12.3125	12.3129	12.3	12.3	39200.0
2011-01-26 07:00:00	AAPL	Stock	12.2857	12.3	12.2607	12.2796	324492.0
2011-01-26 08:00:00	AAPL	Stock	12.2796	12.2804	12.2357	12.25	3215436.0
2011-01-26 09:00:00	AAPL	Stock	12.2504	12.2614	12.1964	12.2311	72831248.0
2011-01-26 10:00:00	AAPL	Stock	12.2307	12.3386	12.2182	12.2961	131673360.0
2011-01-26 11:00:00	AAPL	Stock	12.2964	12.3154	12.2682	12.2986	47190248.0
2011-01-26 12:00:00	AAPL	Stock	12.2989	12.3375	12.2971	12.3218	39228868.0
2011-01-26 13:00:00	AAPL	Stock	12.3219	12.3311	12.2936	12.3171	43788836.0
2011-01-26 14:00:00	AAPL	Stock	12.3168	12.3321	12.2814	12.3271	58963352.0
2011-01-26 15:00:00	AAPL	Stock	12.3232	12.3429	12.2786	12.2811	83748588.0
2011-01-26 16:00:00	AAPL	Stock	12.2821	12.3402	12.2796	12.2875	8249584.0
2011-01-26 17:00:00	AAPL	Stock	12.2846	12.3129	12.2804	12.2857	483812.0
2011-01-26 18:00:00	AAPL	Stock	12.2875	12.29	12.2804	12.2857	218652.0
2011-01-26 19:00:00	AAPL	Stock	12.2907	12.2907	12.2679	12.2857	314720.0
2011-01-26 04:00:00	MSFT	Stock	28.45	28.45	28.45	28.45	100.0
2011-01-26 06:00:00	MSFT	Stock	28.45	28.45	28.45	28.45	600.0
2011-01-26 07:00:00	MSFT	Stock	28.5	28.56	28.5	28.56	700.0
2011-01-26 08:00:00	MSFT	Stock	28.52	28.58	28.52	28.53	36474.0
2011-01-26 09:00:00	MSFT	Stock	28.52	28.8	28.48	28.8	9174183.0
2011-01-26 10:00:00	MSFT	Stock	28.79	28.99	28.72	28.958	17638607.0
2011-01-26 11:00:00	MSFT	Stock	28.955	28.96	28.73	28.77	8795381.0
2011-01-26 12:00:00	MSFT	Stock	28.77	28.88	28.73	28.845	6934251.0
2011-01-26 13:00:00	MSFT	Stock	28.84	28.93	28.77	28.895	5600706.0
2011-01-26 14:00:00	MSFT	Stock	28.89	28.93	28.84	28.91	10294165.0
2011-01-26 15:00:00	MSFT	Stock	28.91	28.91	28.75	28.75	9883337.0
2011-01-26 16:00:00	MSFT	Stock	28.785	28.921	28.74	28.83	2533699.0
2011-01-26 17:00:00	MSFT	Stock	28.83	28.95	28.78	28.89	34897.0
2011-01-26 18:00:00	MSFT	Stock	28.78	28.82	28.78	28.82	22666.0
2011-01-26 19:00:00	MSFT	Stock	28.88	28.89	28.85	28.89	1800.0
2011-01-26 08:00:00	NVDA	Stock	0.6065	0.6075	0.6023	0.6035	1864840.0
2011-01-26 09:00:00	NVDA	Stock	0.6035	0.616	0.6013	0.6153	146622440.0
2011-01-26 10:00:00	NVDA	Stock	0.6155	0.625	0.6118	0.6177	303129760.0
2011-01-26 11:00:00	NVDA	Stock	0.6175	0.6215	0.6158	0.6178	92289160.0
2011-01-26 12:00:00	NVDA	Stock	0.6178	0.62	0.6165	0.6175	63537600.0
2011-01-26 13:00:00	NVDA	Stock	0.6173	0.618	0.6128	0.614	97486360.0
2011-01-26 14:00:00	NVDA	Stock	0.614	0.6153	0.6085	0.6103	137456640.0
2011-01-26 15:00:00	NVDA	Stock	0.6103	0.615	0.609	0.613	205303840.0
2011-01-26 16:00:00	NVDA	Stock	0.6133	0.6162	0.6112	0.6138	9368200.0
2011-01-26 17:00:00	NVDA	Stock	0.6148	0.6148	0.6135	0.6148	441360.0
2011-01-26 18:00:00	NVDA	Stock	0.6148	0.615	0.6148	0.6148	68000.0
2011-01-26 19:00:00	NVDA	Stock	0.6148	0.6173	0.6138	0.6173	471400.0
2011-01-26 07:00:00	AMZN	Stock	8.8515	8.8515	8.8515	8.8515	2000.0
2011-01-26 08:00:00	AMZN	Stock	8.8565	8.8955	8.8245	8.867	147460.0
2011-01-26 09:00:00	AMZN	Stock	8.865	8.8945	8.768	8.8185	10253740.0
2011-01-26 10:00:00	AMZN	Stock	8.825	8.893	8.7885	8.791	14499960.0
2011-01-26 11:00:00	AMZN	Stock	8.7905	8.8265	8.7315	8.7556	11297560.0
2011-01-26 12:00:00	AMZN	Stock	8.756	8.8	8.7475	8.7955	6512100.0
2011-01-26 13:00:00	AMZN	Stock	8.7955	8.8295	8.77	8.811	5945980.0

> showing 50 of 45,912 rows — these rows as CSV

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