PREVIEW / stock_1hour / 2013-04-17

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-04-17.parquet
  size:    978 KB
  rows:    45,500
  symbols: 3,485

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-04-17 04:00:00	AAPL	Stock	15.0893	15.0893	15.0571	15.0675	22568.0
2013-04-17 05:00:00	AAPL	Stock	15.0893	15.0893	15.0821	15.0821	14112.0
2013-04-17 06:00:00	AAPL	Stock	15.1175	15.1175	15.0832	15.0832	24220.0
2013-04-17 07:00:00	AAPL	Stock	15.0796	15.0929	15.0071	15.0604	1069824.0
2013-04-17 08:00:00	AAPL	Stock	15.055	15.0982	15.0339	15.05	2259460.0
2013-04-17 09:00:00	AAPL	Stock	15.045	15.0496	14.7321	14.7482	128090004.0
2013-04-17 10:00:00	AAPL	Stock	14.7474	14.7725	14.4168	14.5207	223537944.0
2013-04-17 11:00:00	AAPL	Stock	14.5182	14.6029	14.4189	14.4197	113244348.0
2013-04-17 12:00:00	AAPL	Stock	14.4196	14.4455	14.2182	14.3907	162328264.0
2013-04-17 13:00:00	AAPL	Stock	14.3921	14.4918	14.3632	14.4379	85054564.0
2013-04-17 14:00:00	AAPL	Stock	14.4346	14.4818	14.3054	14.3571	66175648.0
2013-04-17 15:00:00	AAPL	Stock	14.3566	14.4107	14.2854	14.3857	126637896.0
2013-04-17 16:00:00	AAPL	Stock	14.3857	14.5027	14.3269	14.3968	21558124.0
2013-04-17 17:00:00	AAPL	Stock	14.3968	14.5027	14.3857	14.3929	577556.0
2013-04-17 18:00:00	AAPL	Stock	14.39	14.4071	14.3857	14.3929	149212.0
2013-04-17 19:00:00	AAPL	Stock	14.3979	14.4036	14.3857	14.3929	365288.0
2013-04-17 07:00:00	MSFT	Stock	28.81	28.85	28.8	28.81	3199.0
2013-04-17 08:00:00	MSFT	Stock	28.82	28.93	28.82	28.82	11238.0
2013-04-17 09:00:00	MSFT	Stock	28.82	29.04	28.78	28.94	5991264.0
2013-04-17 10:00:00	MSFT	Stock	28.94	28.95	28.69	28.753	8633549.0
2013-04-17 11:00:00	MSFT	Stock	28.76	28.939	28.72	28.752	5308321.0
2013-04-17 12:00:00	MSFT	Stock	28.76	28.81	28.6	28.765	5782943.0
2013-04-17 13:00:00	MSFT	Stock	28.76	28.98	28.72	28.895	6411956.0
2013-04-17 14:00:00	MSFT	Stock	28.9	28.93	28.78	28.83	6494017.0
2013-04-17 15:00:00	MSFT	Stock	28.834	28.92	28.8	28.87	8557723.0
2013-04-17 16:00:00	MSFT	Stock	28.875	28.98	28.81	28.86	2658450.0
2013-04-17 17:00:00	MSFT	Stock	28.826	28.88	28.82	28.82	114852.0
2013-04-17 18:00:00	MSFT	Stock	28.84	28.84	28.84	28.84	707.0
2013-04-17 08:00:00	NVDA	Stock	0.3213	0.3213	0.3213	0.3213	28000.0
2013-04-17 09:00:00	NVDA	Stock	0.3213	0.3218	0.3178	0.3193	51811560.0
2013-04-17 10:00:00	NVDA	Stock	0.319	0.3236	0.3188	0.322	125510240.0
2013-04-17 11:00:00	NVDA	Stock	0.3218	0.3245	0.3203	0.323	80680560.0
2013-04-17 12:00:00	NVDA	Stock	0.323	0.3235	0.3208	0.3218	42158680.0
2013-04-17 13:00:00	NVDA	Stock	0.3219	0.323	0.321	0.322	55108360.0
2013-04-17 14:00:00	NVDA	Stock	0.3218	0.3228	0.3198	0.321	48860880.0
2013-04-17 15:00:00	NVDA	Stock	0.3209	0.321	0.3188	0.3196	106195760.0
2013-04-17 16:00:00	NVDA	Stock	0.3195	0.3211	0.3188	0.3194	7889600.0
2013-04-17 19:00:00	NVDA	Stock	0.3188	0.3188	0.318	0.318	68000.0
2013-04-17 07:00:00	AMZN	Stock	13.5535	13.5535	13.51	13.51	6000.0
2013-04-17 08:00:00	AMZN	Stock	13.5525	13.5525	13.5055	13.5325	48000.0
2013-04-17 09:00:00	AMZN	Stock	13.535	13.5475	13.4705	13.4925	9473380.0
2013-04-17 10:00:00	AMZN	Stock	13.4865	13.508	13.275	13.275	12170560.0
2013-04-17 11:00:00	AMZN	Stock	13.283	13.3875	13.2125	13.2912	11585460.0
2013-04-17 12:00:00	AMZN	Stock	13.2945	13.3195	13.235	13.306	5692680.0
2013-04-17 13:00:00	AMZN	Stock	13.3065	13.396	13.2945	13.3285	4878700.0
2013-04-17 14:00:00	AMZN	Stock	13.3285	13.3725	13.275	13.3228	5860120.0
2013-04-17 15:00:00	AMZN	Stock	13.315	13.4095	13.3095	13.3695	9682640.0
2013-04-17 16:00:00	AMZN	Stock	13.37	13.3975	13.2875	13.35	3025460.0
2013-04-17 17:00:00	AMZN	Stock	13.326	13.3265	13.3	13.325	52000.0
2013-04-17 19:00:00	AMZN	Stock	13.3255	13.3255	13.325	13.325	4000.0

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

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