PREVIEW / stock_1hour / 2011-11-08

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-11-08.parquet
  size:    942 KB
  rows:    44,323
  symbols: 3,524

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-11-08 04:00:00	AAPL	Stock	14.3214	14.3214	14.3214	14.3214	19600.0
2011-11-08 07:00:00	AAPL	Stock	14.3293	14.3836	14.3196	14.3836	344288.0
2011-11-08 08:00:00	AAPL	Stock	14.3818	14.3857	14.3429	14.3839	1590708.0
2011-11-08 09:00:00	AAPL	Stock	14.3789	14.4911	14.3414	14.4846	92975092.0
2011-11-08 10:00:00	AAPL	Stock	14.4817	14.505	14.4429	14.4757	76788124.0
2011-11-08 11:00:00	AAPL	Stock	14.4736	14.4925	14.3896	14.4368	46011952.0
2011-11-08 12:00:00	AAPL	Stock	14.4339	14.4764	14.4179	14.4343	22878548.0
2011-11-08 13:00:00	AAPL	Stock	14.4339	14.505	14.4321	14.4964	35476084.0
2011-11-08 14:00:00	AAPL	Stock	14.4996	14.5161	14.4579	14.505	38636108.0
2011-11-08 15:00:00	AAPL	Stock	14.5007	14.5714	14.4761	14.5004	69558608.0
2011-11-08 16:00:00	AAPL	Stock	14.5	14.525	14.4396	14.5246	13780956.0
2011-11-08 17:00:00	AAPL	Stock	14.5257	14.5268	14.5179	14.5268	243908.0
2011-11-08 18:00:00	AAPL	Stock	14.525	14.5329	14.5082	14.5321	492744.0
2011-11-08 19:00:00	AAPL	Stock	14.5286	14.5357	14.525	14.5357	246568.0
2011-11-08 04:00:00	MSFT	Stock	26.86	26.86	26.86	26.86	7920.0
2011-11-08 06:00:00	MSFT	Stock	26.8	26.8	26.8	26.8	300.0
2011-11-08 07:00:00	MSFT	Stock	26.8	26.99	26.8	26.95	13593.0
2011-11-08 08:00:00	MSFT	Stock	26.94	26.99	26.9	26.92	50017.0
2011-11-08 09:00:00	MSFT	Stock	26.92	27.14	26.92	27.09	5207912.0
2011-11-08 10:00:00	MSFT	Stock	27.085	27.1	26.77	26.85	8727352.0
2011-11-08 11:00:00	MSFT	Stock	26.85	26.87	26.685	26.827	5185310.0
2011-11-08 12:00:00	MSFT	Stock	26.83	26.89	26.8	26.836	2853430.0
2011-11-08 13:00:00	MSFT	Stock	26.839	27.08	26.76	27.058	4449189.0
2011-11-08 14:00:00	MSFT	Stock	27.052	27.16	27.0	27.12	4722656.0
2011-11-08 15:00:00	MSFT	Stock	27.12	27.2	27.07	27.15	10781514.0
2011-11-08 16:00:00	MSFT	Stock	27.155	27.17	26.813	27.13	4586942.0
2011-11-08 17:00:00	MSFT	Stock	27.14	27.15	27.13	27.13	2015.0
2011-11-08 18:00:00	MSFT	Stock	27.13	27.16	27.13	27.16	33556.0
2011-11-08 19:00:00	MSFT	Stock	27.15	27.18	27.13	27.16	1976.0
2011-11-08 08:00:00	NVDA	Stock	0.37	0.3735	0.37	0.3733	374000.0
2011-11-08 09:00:00	NVDA	Stock	0.3728	0.3793	0.3708	0.3783	97909480.0
2011-11-08 10:00:00	NVDA	Stock	0.3785	0.3786	0.3708	0.371	96644920.0
2011-11-08 11:00:00	NVDA	Stock	0.371	0.3725	0.3672	0.3696	61084560.0
2011-11-08 12:00:00	NVDA	Stock	0.3698	0.372	0.3685	0.3703	37691200.0
2011-11-08 13:00:00	NVDA	Stock	0.3704	0.3763	0.37	0.3755	58597560.0
2011-11-08 14:00:00	NVDA	Stock	0.3758	0.3768	0.373	0.3759	65207280.0
2011-11-08 15:00:00	NVDA	Stock	0.376	0.3788	0.3748	0.377	117610680.0
2011-11-08 16:00:00	NVDA	Stock	0.3773	0.3775	0.3741	0.376	4036800.0
2011-11-08 17:00:00	NVDA	Stock	0.3775	0.3795	0.3775	0.379	191520.0
2011-11-08 18:00:00	NVDA	Stock	0.377	0.3798	0.3763	0.3798	390840.0
2011-11-08 19:00:00	NVDA	Stock	0.378	0.3798	0.378	0.3798	70400.0
2011-11-08 07:00:00	AMZN	Stock	10.923	10.992	10.923	10.9795	37000.0
2011-11-08 08:00:00	AMZN	Stock	10.95	10.96	10.915	10.93	183580.0
2011-11-08 09:00:00	AMZN	Stock	10.9305	10.97	10.8305	10.8325	15946620.0
2011-11-08 10:00:00	AMZN	Stock	10.8355	10.889	10.8081	10.8245	14069160.0
2011-11-08 11:00:00	AMZN	Stock	10.826	10.8479	10.7605	10.813	9794820.0
2011-11-08 12:00:00	AMZN	Stock	10.808	10.8545	10.8	10.825	7291360.0
2011-11-08 13:00:00	AMZN	Stock	10.825	10.8785	10.8156	10.8638	6711600.0
2011-11-08 14:00:00	AMZN	Stock	10.864	10.91	10.8365	10.898	8063680.0
2011-11-08 15:00:00	AMZN	Stock	10.897	10.9305	10.8786	10.9205	13167280.0

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

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