PREVIEW / stock_1hour / 2011-09-12

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-09-12.parquet
  size:    929 KB
  rows:    45,101
  symbols: 3,517

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-09-12 04:00:00	AAPL	Stock	13.3929	13.3929	13.3393	13.3393	8400.0
2011-09-12 05:00:00	AAPL	Stock	13.3214	13.3393	13.3214	13.3393	11200.0
2011-09-12 06:00:00	AAPL	Stock	13.3214	13.3214	13.3036	13.3036	30100.0
2011-09-12 07:00:00	AAPL	Stock	13.3179	13.3643	13.2946	13.3196	746592.0
2011-09-12 08:00:00	AAPL	Stock	13.3204	13.3375	13.2357	13.3357	3765272.0
2011-09-12 09:00:00	AAPL	Stock	13.3293	13.5625	13.3214	13.555	70304472.0
2011-09-12 10:00:00	AAPL	Stock	13.5539	13.6029	13.4018	13.4079	78376648.0
2011-09-12 11:00:00	AAPL	Stock	13.4076	13.5179	13.4021	13.4546	45395252.0
2011-09-12 12:00:00	AAPL	Stock	13.4536	13.4714	13.375	13.4032	35564928.0
2011-09-12 13:00:00	AAPL	Stock	13.4032	13.4254	13.3183	13.3368	45318112.0
2011-09-12 14:00:00	AAPL	Stock	13.3403	13.4746	13.2821	13.3943	76276676.0
2011-09-12 15:00:00	AAPL	Stock	13.3943	13.5696	13.3439	13.5696	97076392.0
2011-09-12 16:00:00	AAPL	Stock	13.5664	13.6071	13.3195	13.5946	8461180.0
2011-09-12 17:00:00	AAPL	Stock	13.6004	13.6161	13.5696	13.5839	971376.0
2011-09-12 18:00:00	AAPL	Stock	13.5839	13.5989	13.5693	13.5961	141512.0
2011-09-12 19:00:00	AAPL	Stock	13.5961	13.5968	13.5875	13.5936	270592.0
2011-09-12 04:00:00	MSFT	Stock	25.59	25.59	25.5	25.5	2815.0
2011-09-12 06:00:00	MSFT	Stock	25.44	25.44	25.44	25.44	100.0
2011-09-12 07:00:00	MSFT	Stock	25.4	25.42	25.39	25.42	2100.0
2011-09-12 08:00:00	MSFT	Stock	25.42	25.5	25.32	25.49	30472.0
2011-09-12 09:00:00	MSFT	Stock	25.51	25.76	25.41	25.66	5325119.0
2011-09-12 10:00:00	MSFT	Stock	25.66	25.75	25.57	25.57	7127168.0
2011-09-12 11:00:00	MSFT	Stock	25.57	25.735	25.57	25.597	4969332.0
2011-09-12 12:00:00	MSFT	Stock	25.6	25.6	25.4	25.47	6240823.0
2011-09-12 13:00:00	MSFT	Stock	25.47	25.56	25.34	25.409	4656162.0
2011-09-12 14:00:00	MSFT	Stock	25.409	25.59	25.27	25.47	8491431.0
2011-09-12 15:00:00	MSFT	Stock	25.47	25.93	25.41	25.88	12176529.0
2011-09-12 16:00:00	MSFT	Stock	25.89	25.97	25.422	25.558	4129037.0
2011-09-12 17:00:00	MSFT	Stock	25.89	25.97	25.89	25.93	82720.0
2011-09-12 18:00:00	MSFT	Stock	25.94	25.97	25.89	25.94	16593.0
2011-09-12 19:00:00	MSFT	Stock	25.97	25.97	25.92	25.92	2826.0
2011-09-12 07:00:00	NVDA	Stock	0.34	0.34	0.34	0.34	8000.0
2011-09-12 08:00:00	NVDA	Stock	0.3442	0.3445	0.337	0.3422	898440.0
2011-09-12 09:00:00	NVDA	Stock	0.3438	0.3572	0.3422	0.355	131934560.0
2011-09-12 10:00:00	NVDA	Stock	0.355	0.3582	0.349	0.3504	182179000.0
2011-09-12 11:00:00	NVDA	Stock	0.3504	0.3565	0.35	0.3542	78873480.0
2011-09-12 12:00:00	NVDA	Stock	0.354	0.3548	0.3505	0.3518	54252960.0
2011-09-12 13:00:00	NVDA	Stock	0.3518	0.353	0.3468	0.3473	116309240.0
2011-09-12 14:00:00	NVDA	Stock	0.347	0.3535	0.3465	0.3495	155828800.0
2011-09-12 15:00:00	NVDA	Stock	0.3495	0.3558	0.3482	0.3554	173774200.0
2011-09-12 16:00:00	NVDA	Stock	0.3555	0.3588	0.3498	0.3588	7438440.0
2011-09-12 17:00:00	NVDA	Stock	0.3468	0.36	0.3468	0.3588	808000.0
2011-09-12 18:00:00	NVDA	Stock	0.3595	0.3625	0.3575	0.3588	588480.0
2011-09-12 19:00:00	NVDA	Stock	0.358	0.3602	0.3575	0.3602	335080.0
2011-09-12 04:00:00	AMZN	Stock	10.5215	10.5215	10.46	10.46	8000.0
2011-09-12 07:00:00	AMZN	Stock	10.431	10.47	10.375	10.44	150000.0
2011-09-12 08:00:00	AMZN	Stock	10.4285	10.478	10.3655	10.478	645760.0
2011-09-12 09:00:00	AMZN	Stock	10.474	10.79	10.4215	10.773	18193900.0
2011-09-12 10:00:00	AMZN	Stock	10.7725	10.808	10.6605	10.6665	15504760.0
2011-09-12 11:00:00	AMZN	Stock	10.665	10.7305	10.6275	10.65	11310460.0

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

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