PREVIEW / stock_1hour / 2011-11-07

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-11-07.parquet
  size:    915 KB
  rows:    43,953
  symbols: 3,518

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-07 04:00:00	AAPL	Stock	14.2146	14.2146	14.2146	14.2146	5600.0
2011-11-07 05:00:00	AAPL	Stock	14.1786	14.2143	14.1786	14.2143	5600.0
2011-11-07 07:00:00	AAPL	Stock	14.25	14.2861	14.25	14.2696	114800.0
2011-11-07 08:00:00	AAPL	Stock	14.2843	14.2871	14.2332	14.2536	621236.0
2011-11-07 09:00:00	AAPL	Stock	14.2536	14.3036	14.1864	14.2536	51512384.0
2011-11-07 10:00:00	AAPL	Stock	14.2539	14.2711	14.1625	14.1704	54918304.0
2011-11-07 11:00:00	AAPL	Stock	14.1682	14.1886	14.1496	14.1736	36937740.0
2011-11-07 12:00:00	AAPL	Stock	14.1725	14.2085	14.1475	14.16	23087820.0
2011-11-07 13:00:00	AAPL	Stock	14.1607	14.25	14.1584	14.2359	24057908.0
2011-11-07 14:00:00	AAPL	Stock	14.2346	14.2696	14.2143	14.2593	27604108.0
2011-11-07 15:00:00	AAPL	Stock	14.2621	14.2857	14.2143	14.2775	39749808.0
2011-11-07 16:00:00	AAPL	Stock	14.2775	14.2843	14.2174	14.2711	5526108.0
2011-11-07 17:00:00	AAPL	Stock	14.2729	14.2893	14.27	14.2854	514584.0
2011-11-07 18:00:00	AAPL	Stock	14.2982	14.2982	14.2679	14.2786	124236.0
2011-11-07 19:00:00	AAPL	Stock	14.2857	14.2946	14.275	14.2821	258468.0
2011-11-07 04:00:00	MSFT	Stock	26.35	26.35	26.15	26.27	3300.0
2011-11-07 05:00:00	MSFT	Stock	26.17	26.17	26.17	26.17	200.0
2011-11-07 06:00:00	MSFT	Stock	26.14	26.14	26.14	26.14	300.0
2011-11-07 07:00:00	MSFT	Stock	26.11	26.3	26.11	26.25	4700.0
2011-11-07 08:00:00	MSFT	Stock	26.21	26.23	26.12	26.15	10676.0
2011-11-07 09:00:00	MSFT	Stock	26.17	26.57	26.17	26.56	4428165.0
2011-11-07 10:00:00	MSFT	Stock	26.565	26.58	26.19	26.22	5901732.0
2011-11-07 11:00:00	MSFT	Stock	26.21	26.3	26.18	26.225	3410100.0
2011-11-07 12:00:00	MSFT	Stock	26.22	26.29	26.13	26.145	2694253.0
2011-11-07 13:00:00	MSFT	Stock	26.145	26.305	26.13	26.25	4065936.0
2011-11-07 14:00:00	MSFT	Stock	26.25	26.67	26.25	26.66	6562227.0
2011-11-07 15:00:00	MSFT	Stock	26.655	26.82	26.65	26.8	12953870.0
2011-11-07 16:00:00	MSFT	Stock	26.8	26.83	26.475	26.8	1399046.0
2011-11-07 17:00:00	MSFT	Stock	26.83	26.84	26.81	26.83	4015.0
2011-11-07 18:00:00	MSFT	Stock	26.81	26.84	26.8	26.8	47336.0
2011-11-07 19:00:00	MSFT	Stock	26.78	26.78	26.7	26.75	10800.0
2011-11-07 08:00:00	NVDA	Stock	0.3675	0.3675	0.367	0.367	20000.0
2011-11-07 09:00:00	NVDA	Stock	0.364	0.374	0.364	0.3696	65427080.0
2011-11-07 10:00:00	NVDA	Stock	0.3695	0.3698	0.3625	0.3644	78264440.0
2011-11-07 11:00:00	NVDA	Stock	0.364	0.3682	0.3632	0.3658	52164880.0
2011-11-07 12:00:00	NVDA	Stock	0.3658	0.3662	0.36	0.3642	89533040.0
2011-11-07 13:00:00	NVDA	Stock	0.3644	0.3658	0.3615	0.3652	70996640.0
2011-11-07 14:00:00	NVDA	Stock	0.3652	0.3665	0.3635	0.366	136445680.0
2011-11-07 15:00:00	NVDA	Stock	0.366	0.3692	0.3655	0.3685	110010200.0
2011-11-07 16:00:00	NVDA	Stock	0.3685	0.3698	0.3654	0.368	8242760.0
2011-11-07 17:00:00	NVDA	Stock	0.369	0.3705	0.369	0.3705	174000.0
2011-11-07 18:00:00	NVDA	Stock	0.3695	0.3695	0.3678	0.3678	48000.0
2011-11-07 19:00:00	NVDA	Stock	0.369	0.3698	0.3678	0.3682	129160.0
2011-11-07 04:00:00	AMZN	Stock	10.7875	10.8	10.75	10.8	14000.0
2011-11-07 05:00:00	AMZN	Stock	10.762	10.787	10.761	10.761	8000.0
2011-11-07 06:00:00	AMZN	Stock	10.786	10.8	10.786	10.8	6000.0
2011-11-07 07:00:00	AMZN	Stock	10.8	10.818	10.8	10.818	8000.0
2011-11-07 08:00:00	AMZN	Stock	10.786	10.822	10.786	10.786	23820.0
2011-11-07 09:00:00	AMZN	Stock	10.781	10.995	10.7805	10.9805	12617240.0
2011-11-07 10:00:00	AMZN	Stock	10.9805	11.01	10.739	10.7435	19878980.0

> showing 50 of 43,953 rows — these rows as CSV

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