PREVIEW / stock_1hour / 2011-10-28

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-10-28.parquet
  size:    941 KB
  rows:    44,300
  symbols: 3,514

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-10-28 04:00:00	AAPL	Stock	14.4643	14.4643	14.4643	14.4643	5600.0
2011-10-28 05:00:00	AAPL	Stock	14.4357	14.4357	14.4264	14.4329	11200.0
2011-10-28 06:00:00	AAPL	Stock	14.4436	14.4436	14.405	14.4214	30800.0
2011-10-28 07:00:00	AAPL	Stock	14.4214	14.4214	14.3789	14.3929	149352.0
2011-10-28 08:00:00	AAPL	Stock	14.3929	14.4532	14.3643	14.3964	807576.0
2011-10-28 09:00:00	AAPL	Stock	14.3929	14.4893	14.3686	14.4596	48771352.0
2011-10-28 10:00:00	AAPL	Stock	14.465	14.475	14.4093	14.4418	54544700.0
2011-10-28 11:00:00	AAPL	Stock	14.4411	14.4607	14.3968	14.4086	40417916.0
2011-10-28 12:00:00	AAPL	Stock	14.4071	14.4361	14.3907	14.4248	24946404.0
2011-10-28 13:00:00	AAPL	Stock	14.4246	14.4643	14.4129	14.4494	27234844.0
2011-10-28 14:00:00	AAPL	Stock	14.4491	14.4536	14.4221	14.445	25085564.0
2011-10-28 15:00:00	AAPL	Stock	14.4464	14.5125	14.44	14.4657	64032584.0
2011-10-28 16:00:00	AAPL	Stock	14.4643	14.4714	14.4444	14.4643	27989976.0
2011-10-28 17:00:00	AAPL	Stock	14.4532	14.4654	14.4429	14.4432	596596.0
2011-10-28 18:00:00	AAPL	Stock	14.4625	14.4625	14.4461	14.4464	64260.0
2011-10-28 19:00:00	AAPL	Stock	14.4468	14.4607	14.4321	14.4357	397040.0
2011-10-28 06:00:00	MSFT	Stock	27.09	27.09	27.09	27.09	200.0
2011-10-28 07:00:00	MSFT	Stock	27.05	27.08	27.03	27.04	632.0
2011-10-28 08:00:00	MSFT	Stock	27.08	27.25	27.04	27.11	26660.0
2011-10-28 09:00:00	MSFT	Stock	27.11	27.19	26.79	26.885	7737320.0
2011-10-28 10:00:00	MSFT	Stock	26.88	27.0	26.79	26.89	8337425.0
2011-10-28 11:00:00	MSFT	Stock	26.89	26.94	26.81	26.84	5110811.0
2011-10-28 12:00:00	MSFT	Stock	26.83	26.91	26.81	26.9	4061775.0
2011-10-28 13:00:00	MSFT	Stock	26.9	26.98	26.88	26.935	5002470.0
2011-10-28 14:00:00	MSFT	Stock	26.935	26.97	26.87	26.961	5128571.0
2011-10-28 15:00:00	MSFT	Stock	26.96	27.0	26.9	26.98	9976192.0
2011-10-28 16:00:00	MSFT	Stock	26.97	27.03	26.84	26.981	9265508.0
2011-10-28 17:00:00	MSFT	Stock	27.25	27.25	26.95	26.96	16389.0
2011-10-28 18:00:00	MSFT	Stock	26.95	26.98	26.95	26.98	9100.0
2011-10-28 08:00:00	NVDA	Stock	0.3813	0.3813	0.378	0.378	138400.0
2011-10-28 09:00:00	NVDA	Stock	0.3793	0.3888	0.3765	0.386	65816120.0
2011-10-28 10:00:00	NVDA	Stock	0.3862	0.39	0.3822	0.3885	103840560.0
2011-10-28 11:00:00	NVDA	Stock	0.3885	0.3935	0.385	0.3855	73411200.0
2011-10-28 12:00:00	NVDA	Stock	0.3855	0.3895	0.385	0.3893	39538520.0
2011-10-28 13:00:00	NVDA	Stock	0.389	0.39	0.3862	0.3882	46973720.0
2011-10-28 14:00:00	NVDA	Stock	0.3882	0.3893	0.3865	0.388	35462400.0
2011-10-28 15:00:00	NVDA	Stock	0.3882	0.3913	0.3882	0.39	103594680.0
2011-10-28 16:00:00	NVDA	Stock	0.39	0.391	0.3877	0.3895	18102640.0
2011-10-28 17:00:00	NVDA	Stock	0.3813	0.3913	0.3813	0.3913	468960.0
2011-10-28 18:00:00	NVDA	Stock	0.39	0.3913	0.39	0.39	172600.0
2011-10-28 19:00:00	NVDA	Stock	0.39	0.3913	0.39	0.3913	8000.0
2011-10-28 04:00:00	AMZN	Stock	10.3085	10.348	10.3085	10.348	14000.0
2011-10-28 05:00:00	AMZN	Stock	10.3185	10.3195	10.3185	10.3195	6000.0
2011-10-28 07:00:00	AMZN	Stock	10.326	10.326	10.28	10.28	51040.0
2011-10-28 08:00:00	AMZN	Stock	10.2825	10.2995	10.275	10.275	186860.0
2011-10-28 09:00:00	AMZN	Stock	10.27	10.4325	10.265	10.372	23301560.0
2011-10-28 10:00:00	AMZN	Stock	10.3725	10.75	10.3445	10.6615	51311020.0
2011-10-28 11:00:00	AMZN	Stock	10.6612	10.737	10.6135	10.6396	24159460.0
2011-10-28 12:00:00	AMZN	Stock	10.635	10.675	10.62	10.669	11157760.0
2011-10-28 13:00:00	AMZN	Stock	10.671	10.725	10.6455	10.725	11558220.0

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

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