PREVIEW / stock_1hour / 2012-01-25

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-01-25.parquet
  size:    932 KB
  rows:    44,314
  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
2012-01-25 04:00:00	AAPL	Stock	16.1143	16.1143	16.0411	16.0682	272552.0
2012-01-25 05:00:00	AAPL	Stock	16.0643	16.1393	16.0607	16.1393	314776.0
2012-01-25 06:00:00	AAPL	Stock	16.11	16.1536	16.11	16.1429	312844.0
2012-01-25 07:00:00	AAPL	Stock	16.1339	16.2243	16.1339	16.2054	3796184.0
2012-01-25 08:00:00	AAPL	Stock	16.1986	16.4107	16.125	16.3786	27120520.0
2012-01-25 09:00:00	AAPL	Stock	16.3821	16.4	15.9732	16.0357	308046816.0
2012-01-25 10:00:00	AAPL	Stock	16.0346	16.0379	15.9007	15.9554	156132984.0
2012-01-25 11:00:00	AAPL	Stock	15.9571	16.0578	15.9479	16.0232	105607712.0
2012-01-25 12:00:00	AAPL	Stock	16.0236	16.0286	15.8475	15.8607	86886996.0
2012-01-25 13:00:00	AAPL	Stock	15.8618	16.0036	15.8593	15.9979	73853080.0
2012-01-25 14:00:00	AAPL	Stock	15.9982	16.0	15.9411	15.9446	55801200.0
2012-01-25 15:00:00	AAPL	Stock	15.9432	15.9829	15.9364	15.9493	94048500.0
2012-01-25 16:00:00	AAPL	Stock	15.9482	16.0714	15.9482	15.9482	4108132.0
2012-01-25 17:00:00	AAPL	Stock	15.9482	15.9639	15.9393	15.9639	628432.0
2012-01-25 18:00:00	AAPL	Stock	15.9625	15.9707	15.9446	15.9446	701288.0
2012-01-25 19:00:00	AAPL	Stock	15.9464	15.9643	15.9375	15.9643	352548.0
2012-01-25 07:00:00	MSFT	Stock	29.38	29.38	29.29	29.29	2050.0
2012-01-25 08:00:00	MSFT	Stock	29.32	29.37	29.18	29.23	26558.0
2012-01-25 09:00:00	MSFT	Stock	29.23	29.33	29.02	29.23	6619892.0
2012-01-25 10:00:00	MSFT	Stock	29.23	29.37	29.16	29.26	7737688.0
2012-01-25 11:00:00	MSFT	Stock	29.265	29.52	29.25	29.372	8509502.0
2012-01-25 12:00:00	MSFT	Stock	29.375	29.52	29.3	29.39	6451081.0
2012-01-25 13:00:00	MSFT	Stock	29.39	29.57	29.39	29.565	8776335.0
2012-01-25 14:00:00	MSFT	Stock	29.565	29.65	29.51	29.577	7429157.0
2012-01-25 15:00:00	MSFT	Stock	29.575	29.65	29.46	29.57	10187183.0
2012-01-25 16:00:00	MSFT	Stock	29.56	29.65	29.317	29.424	925964.0
2012-01-25 17:00:00	MSFT	Stock	29.56	29.59	29.56	29.58	11776.0
2012-01-25 18:00:00	MSFT	Stock	29.5	29.5	29.267	29.29	18734.0
2012-01-25 19:00:00	MSFT	Stock	29.47	29.57	29.33	29.57	2400.0
2012-01-25 04:00:00	NVDA	Stock	0.3575	0.3668	0.3575	0.3668	11240.0
2012-01-25 05:00:00	NVDA	Stock	0.353	0.353	0.353	0.353	20000.0
2012-01-25 06:00:00	NVDA	Stock	0.3555	0.356	0.3555	0.3558	172800.0
2012-01-25 07:00:00	NVDA	Stock	0.3558	0.3625	0.3538	0.3602	1745560.0
2012-01-25 08:00:00	NVDA	Stock	0.3605	0.3645	0.3575	0.359	3487040.0
2012-01-25 09:00:00	NVDA	Stock	0.3598	0.3672	0.353	0.355	242999640.0
2012-01-25 10:00:00	NVDA	Stock	0.355	0.3615	0.3538	0.3614	249179080.0
2012-01-25 11:00:00	NVDA	Stock	0.3615	0.366	0.3605	0.3655	160350440.0
2012-01-25 12:00:00	NVDA	Stock	0.3655	0.368	0.3638	0.3655	95911200.0
2012-01-25 13:00:00	NVDA	Stock	0.3656	0.3723	0.3655	0.3715	137133760.0
2012-01-25 14:00:00	NVDA	Stock	0.3714	0.3715	0.3688	0.3694	95072400.0
2012-01-25 15:00:00	NVDA	Stock	0.3695	0.3713	0.3675	0.3713	268361080.0
2012-01-25 16:00:00	NVDA	Stock	0.3713	0.3725	0.3634	0.3695	13352400.0
2012-01-25 17:00:00	NVDA	Stock	0.3692	0.3695	0.3678	0.3685	331600.0
2012-01-25 18:00:00	NVDA	Stock	0.3688	0.3688	0.3685	0.3685	12000.0
2012-01-25 19:00:00	NVDA	Stock	0.3698	0.3705	0.3698	0.37	288000.0
2012-01-25 07:00:00	AMZN	Stock	9.415	9.415	9.375	9.4145	42000.0
2012-01-25 08:00:00	AMZN	Stock	9.35	9.41	9.35	9.4	62320.0
2012-01-25 09:00:00	AMZN	Stock	9.4	9.4	9.2505	9.2755	10328000.0
2012-01-25 10:00:00	AMZN	Stock	9.275	9.2925	9.2305	9.2823	12017220.0
2012-01-25 11:00:00	AMZN	Stock	9.282	9.2855	9.255	9.2605	7789240.0

> showing 50 of 44,314 rows — these rows as CSV

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