PREVIEW / stock_1hour / 2013-01-24

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-01-24.parquet
  size:    967 KB
  rows:    45,639
  symbols: 3,498

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-01-24 04:00:00	AAPL	Stock	16.5714	16.8429	16.5714	16.8421	1775732.0
2013-01-24 05:00:00	AAPL	Stock	16.8421	16.9286	16.7607	16.8393	1728552.0
2013-01-24 06:00:00	AAPL	Stock	16.8014	16.8014	16.5982	16.6229	3101504.0
2013-01-24 07:00:00	AAPL	Stock	16.6232	16.7429	16.6075	16.7296	9418304.0
2013-01-24 08:00:00	AAPL	Stock	16.7321	16.7596	16.4446	16.4814	31274096.0
2013-01-24 09:00:00	AAPL	Stock	16.4818	16.5914	16.095	16.5469	462186816.0
2013-01-24 10:00:00	AAPL	Stock	16.5439	16.6332	16.3929	16.4699	263407060.0
2013-01-24 11:00:00	AAPL	Stock	16.4639	16.505	16.3804	16.465	134799588.0
2013-01-24 12:00:00	AAPL	Stock	16.4646	16.4696	16.2968	16.2989	88847192.0
2013-01-24 13:00:00	AAPL	Stock	16.3007	16.3018	16.1607	16.1664	130055352.0
2013-01-24 14:00:00	AAPL	Stock	16.1668	16.2321	16.1183	16.2155	118922188.0
2013-01-24 15:00:00	AAPL	Stock	16.2155	16.2232	16.0804	16.0893	172613812.0
2013-01-24 16:00:00	AAPL	Stock	16.0839	16.3379	15.9911	16.0071	16767800.0
2013-01-24 17:00:00	AAPL	Stock	16.0175	16.4996	15.9771	15.9825	2271668.0
2013-01-24 18:00:00	AAPL	Stock	15.9879	16.0286	15.9829	16.0114	801780.0
2013-01-24 19:00:00	AAPL	Stock	16.0082	16.0268	16.0054	16.0132	789488.0
2013-01-24 07:00:00	MSFT	Stock	27.46	27.6	27.46	27.6	3000.0
2013-01-24 08:00:00	MSFT	Stock	27.47	27.6	27.43	27.59	97314.0
2013-01-24 09:00:00	MSFT	Stock	27.59	28.06	27.56	27.96	13295990.0
2013-01-24 10:00:00	MSFT	Stock	27.96	28.07	27.9	27.97	14924255.0
2013-01-24 11:00:00	MSFT	Stock	27.97	28.06	27.968	28.035	15100313.0
2013-01-24 12:00:00	MSFT	Stock	28.03	28.045	27.95	27.95	8659943.0
2013-01-24 13:00:00	MSFT	Stock	27.95	27.97	27.82	27.852	8808667.0
2013-01-24 14:00:00	MSFT	Stock	27.85	28.0	27.84	27.875	9632297.0
2013-01-24 15:00:00	MSFT	Stock	27.87	27.93	27.6	27.63	22045175.0
2013-01-24 16:00:00	MSFT	Stock	27.63	28.19	26.96	27.02	5723358.0
2013-01-24 17:00:00	MSFT	Stock	27.02	27.988	26.99	27.1	695437.0
2013-01-24 18:00:00	MSFT	Stock	27.09	27.26	27.09	27.21	211400.0
2013-01-24 19:00:00	MSFT	Stock	27.24	27.25	27.19	27.23	75553.0
2013-01-24 08:00:00	NVDA	Stock	0.301	0.3025	0.301	0.3018	248000.0
2013-01-24 09:00:00	NVDA	Stock	0.3018	0.3038	0.3008	0.3025	34734920.0
2013-01-24 10:00:00	NVDA	Stock	0.3026	0.306	0.3022	0.3051	76015320.0
2013-01-24 11:00:00	NVDA	Stock	0.305	0.3055	0.3045	0.3055	34751320.0
2013-01-24 12:00:00	NVDA	Stock	0.3052	0.3055	0.3025	0.3038	57138600.0
2013-01-24 13:00:00	NVDA	Stock	0.3035	0.3055	0.3035	0.305	52746120.0
2013-01-24 14:00:00	NVDA	Stock	0.3048	0.3049	0.3038	0.3046	22239040.0
2013-01-24 15:00:00	NVDA	Stock	0.3046	0.3058	0.3042	0.3046	101436000.0
2013-01-24 16:00:00	NVDA	Stock	0.3048	0.3055	0.3043	0.3048	14021400.0
2013-01-24 17:00:00	NVDA	Stock	0.3048	0.3048	0.3048	0.3048	36840.0
2013-01-24 18:00:00	NVDA	Stock	0.3042	0.3042	0.304	0.304	100000.0
2013-01-24 19:00:00	NVDA	Stock	0.3048	0.3048	0.3048	0.3048	5800.0
2013-01-24 05:00:00	AMZN	Stock	13.3805	13.4145	13.3805	13.4145	8000.0
2013-01-24 07:00:00	AMZN	Stock	13.3875	13.3885	13.3875	13.3885	4000.0
2013-01-24 08:00:00	AMZN	Stock	13.389	13.45	13.389	13.425	49500.0
2013-01-24 09:00:00	AMZN	Stock	13.425	13.8217	13.425	13.7323	18671120.0
2013-01-24 10:00:00	AMZN	Stock	13.7415	13.799	13.7	13.775	9406160.0
2013-01-24 11:00:00	AMZN	Stock	13.7703	13.8325	13.747	13.796	9494540.0
2013-01-24 12:00:00	AMZN	Stock	13.7985	13.8055	13.6825	13.6905	7126720.0
2013-01-24 13:00:00	AMZN	Stock	13.6905	13.7065	13.6025	13.6295	5563660.0
2013-01-24 14:00:00	AMZN	Stock	13.63	13.694	13.6055	13.683	4905420.0

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

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