PREVIEW / stock_1hour / 2011-05-06

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-05-06.parquet
  size:    941 KB
  rows:    44,386
  symbols: 3,549

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-05-06 04:00:00	AAPL	Stock	12.3829	12.3829	12.375	12.375	41888.0
2011-05-06 05:00:00	AAPL	Stock	12.4179	12.4457	12.4179	12.4457	8400.0
2011-05-06 07:00:00	AAPL	Stock	12.4175	12.4357	12.4125	12.4286	83076.0
2011-05-06 08:00:00	AAPL	Stock	12.425	12.5	12.4125	12.4911	4115356.0
2011-05-06 09:00:00	AAPL	Stock	12.4914	12.5139	12.4336	12.4575	49671608.0
2011-05-06 10:00:00	AAPL	Stock	12.4575	12.4789	12.4468	12.4757	36075032.0
2011-05-06 11:00:00	AAPL	Stock	12.4754	12.4925	12.4579	12.4743	34852272.0
2011-05-06 12:00:00	AAPL	Stock	12.4729	12.4804	12.4261	12.435	35108976.0
2011-05-06 13:00:00	AAPL	Stock	12.4371	12.4446	12.3979	12.4007	33273184.0
2011-05-06 14:00:00	AAPL	Stock	12.4032	12.4318	12.3646	12.375	35639884.0
2011-05-06 15:00:00	AAPL	Stock	12.375	12.4104	12.3711	12.3768	41962508.0
2011-05-06 16:00:00	AAPL	Stock	12.3807	12.4394	12.3564	12.3711	7450492.0
2011-05-06 17:00:00	AAPL	Stock	12.3707	12.3807	12.3707	12.3782	294868.0
2011-05-06 18:00:00	AAPL	Stock	12.3768	12.3857	12.3757	12.3839	185752.0
2011-05-06 19:00:00	AAPL	Stock	12.3839	12.3893	12.3804	12.3882	138320.0
2011-05-06 07:00:00	MSFT	Stock	25.83	25.83	25.83	25.83	200.0
2011-05-06 08:00:00	MSFT	Stock	25.85	26.01	25.83	26.0	92963.0
2011-05-06 09:00:00	MSFT	Stock	26.01	26.2	25.98	26.12	6821084.0
2011-05-06 10:00:00	MSFT	Stock	26.12	26.13	25.95	26.06	7766827.0
2011-05-06 11:00:00	MSFT	Stock	26.05	26.22	26.04	26.19	7452043.0
2011-05-06 12:00:00	MSFT	Stock	26.19	26.2	25.98	26.07	9152793.0
2011-05-06 13:00:00	MSFT	Stock	26.08	26.085	25.841	25.849	6139789.0
2011-05-06 14:00:00	MSFT	Stock	25.846	25.92	25.75	25.84	6236580.0
2011-05-06 15:00:00	MSFT	Stock	25.83	25.95	25.82	25.87	10184712.0
2011-05-06 16:00:00	MSFT	Stock	25.87	26.018	25.81	25.83	1831686.0
2011-05-06 17:00:00	MSFT	Stock	25.87	25.87	25.87	25.87	49519.0
2011-05-06 18:00:00	MSFT	Stock	25.87	25.87	25.85	25.87	8328.0
2011-05-06 19:00:00	MSFT	Stock	25.87	25.87	25.87	25.87	600.0
2011-05-06 08:00:00	NVDA	Stock	0.47	0.4772	0.4692	0.4772	1177440.0
2011-05-06 09:00:00	NVDA	Stock	0.4772	0.4875	0.4725	0.4859	180052840.0
2011-05-06 10:00:00	NVDA	Stock	0.486	0.4872	0.4808	0.4848	168392120.0
2011-05-06 11:00:00	NVDA	Stock	0.4849	0.4875	0.4835	0.4845	77326680.0
2011-05-06 12:00:00	NVDA	Stock	0.4846	0.485	0.48	0.4832	94342160.0
2011-05-06 13:00:00	NVDA	Stock	0.4832	0.4852	0.4815	0.4842	100155880.0
2011-05-06 14:00:00	NVDA	Stock	0.4843	0.4845	0.48	0.4828	81864280.0
2011-05-06 15:00:00	NVDA	Stock	0.4828	0.485	0.4818	0.4828	117197560.0
2011-05-06 16:00:00	NVDA	Stock	0.4825	0.4841	0.4825	0.4838	1354800.0
2011-05-06 17:00:00	NVDA	Stock	0.4838	0.4838	0.483	0.4835	234520.0
2011-05-06 18:00:00	NVDA	Stock	0.4845	0.4845	0.484	0.4845	111040.0
2011-05-06 19:00:00	NVDA	Stock	0.4845	0.4848	0.4845	0.4848	16000.0
2011-05-06 08:00:00	AMZN	Stock	9.881	9.987	9.872	9.9725	672760.0
2011-05-06 09:00:00	AMZN	Stock	9.975	9.98	9.828	9.859	14287780.0
2011-05-06 10:00:00	AMZN	Stock	9.86	9.9375	9.8415	9.9035	14775140.0
2011-05-06 11:00:00	AMZN	Stock	9.9054	9.9705	9.904	9.9575	8727100.0
2011-05-06 12:00:00	AMZN	Stock	9.954	9.9755	9.8885	9.9205	12549340.0
2011-05-06 13:00:00	AMZN	Stock	9.923	9.942	9.875	9.886	7208680.0
2011-05-06 14:00:00	AMZN	Stock	9.8855	9.926	9.828	9.8565	7562820.0
2011-05-06 15:00:00	AMZN	Stock	9.854	9.9155	9.8466	9.876	11161280.0
2011-05-06 16:00:00	AMZN	Stock	9.88	9.9072	9.8755	9.9	1980140.0
2011-05-06 17:00:00	AMZN	Stock	9.88	9.9245	9.88	9.9245	75460.0

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

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