PREVIEW / stock_1hour / 2011-10-20

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-10-20.parquet
  size:    893 KB
  rows:    42,825
  symbols: 3,479

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-20 04:00:00	AAPL	Stock	14.2586	14.3307	14.25	14.3307	56000.0
2011-10-20 05:00:00	AAPL	Stock	14.3561	14.3561	14.3143	14.3143	140000.0
2011-10-20 06:00:00	AAPL	Stock	14.3214	14.3214	14.3107	14.3118	36400.0
2011-10-20 07:00:00	AAPL	Stock	14.3036	14.3179	14.2579	14.2693	268296.0
2011-10-20 08:00:00	AAPL	Stock	14.2846	14.3036	14.2271	14.2839	2731512.0
2011-10-20 09:00:00	AAPL	Stock	14.2857	14.2982	14.1111	14.1889	99004752.0
2011-10-20 10:00:00	AAPL	Stock	14.1893	14.2664	14.1565	14.2102	99338036.0
2011-10-20 11:00:00	AAPL	Stock	14.2082	14.2125	14.125	14.1532	68344332.0
2011-10-20 12:00:00	AAPL	Stock	14.1536	14.175	14.0789	14.1179	67136776.0
2011-10-20 13:00:00	AAPL	Stock	14.1184	14.1871	14.0832	14.1456	60329808.0
2011-10-20 14:00:00	AAPL	Stock	14.1432	14.1964	14.1119	14.1764	52042760.0
2011-10-20 15:00:00	AAPL	Stock	14.1761	14.18	14.0911	14.1232	75769960.0
2011-10-20 16:00:00	AAPL	Stock	14.1191	14.1668	14.0964	14.1193	15268036.0
2011-10-20 17:00:00	AAPL	Stock	14.1182	14.1429	14.1132	14.1221	506912.0
2011-10-20 18:00:00	AAPL	Stock	14.1186	14.1304	14.1182	14.1221	275744.0
2011-10-20 19:00:00	AAPL	Stock	14.1261	14.1261	14.1186	14.1232	154000.0
2011-10-20 05:00:00	MSFT	Stock	27.19	27.19	27.19	27.19	3000.0
2011-10-20 06:00:00	MSFT	Stock	27.19	27.19	27.18	27.18	7100.0
2011-10-20 07:00:00	MSFT	Stock	27.2	27.26	27.18	27.23	3000.0
2011-10-20 08:00:00	MSFT	Stock	27.24	27.34	27.23	27.33	65030.0
2011-10-20 09:00:00	MSFT	Stock	27.34	27.37	26.75	26.75	6693740.0
2011-10-20 10:00:00	MSFT	Stock	26.76	26.93	26.61	26.61	12344799.0
2011-10-20 11:00:00	MSFT	Stock	26.61	26.71	26.4	26.54	8981473.0
2011-10-20 12:00:00	MSFT	Stock	26.55	26.76	26.45	26.72	7700680.0
2011-10-20 13:00:00	MSFT	Stock	26.73	26.95	26.72	26.87	8766366.0
2011-10-20 14:00:00	MSFT	Stock	26.87	27.07	26.86	27.055	6407816.0
2011-10-20 15:00:00	MSFT	Stock	27.06	27.18	27.03	27.04	16997762.0
2011-10-20 16:00:00	MSFT	Stock	27.03	27.135	26.2	26.68	4649564.0
2011-10-20 17:00:00	MSFT	Stock	26.68	27.04	26.67	26.86	271882.0
2011-10-20 18:00:00	MSFT	Stock	26.86	27.04	26.83	26.85	45365.0
2011-10-20 19:00:00	MSFT	Stock	26.83	26.9	26.75	26.86	56812.0
2011-10-20 08:00:00	NVDA	Stock	0.3798	0.38	0.371	0.3738	658880.0
2011-10-20 09:00:00	NVDA	Stock	0.3718	0.3723	0.3562	0.3587	180740600.0
2011-10-20 10:00:00	NVDA	Stock	0.3588	0.3618	0.3513	0.3513	171984520.0
2011-10-20 11:00:00	NVDA	Stock	0.3515	0.3582	0.346	0.3533	188233480.0
2011-10-20 12:00:00	NVDA	Stock	0.3533	0.3565	0.3502	0.3562	69425000.0
2011-10-20 13:00:00	NVDA	Stock	0.3561	0.361	0.3558	0.3592	103599000.0
2011-10-20 14:00:00	NVDA	Stock	0.359	0.3645	0.3572	0.3628	87039400.0
2011-10-20 15:00:00	NVDA	Stock	0.3628	0.363	0.358	0.36	174103720.0
2011-10-20 16:00:00	NVDA	Stock	0.359	0.361	0.3574	0.36	5027960.0
2011-10-20 17:00:00	NVDA	Stock	0.3602	0.3602	0.36	0.3602	183680.0
2011-10-20 18:00:00	NVDA	Stock	0.3605	0.3605	0.3605	0.3605	34000.0
2011-10-20 19:00:00	NVDA	Stock	0.3638	0.364	0.3615	0.3615	227600.0
2011-10-20 04:00:00	AMZN	Stock	11.622	11.622	11.622	11.622	4000.0
2011-10-20 05:00:00	AMZN	Stock	11.6515	11.6515	11.6005	11.6215	13200.0
2011-10-20 06:00:00	AMZN	Stock	11.6515	11.6515	11.6515	11.6515	2000.0
2011-10-20 07:00:00	AMZN	Stock	11.648	11.6515	11.632	11.6515	22000.0
2011-10-20 08:00:00	AMZN	Stock	11.652	11.685	11.57	11.61	292460.0
2011-10-20 09:00:00	AMZN	Stock	11.6085	11.694	11.495	11.655	15261060.0
2011-10-20 10:00:00	AMZN	Stock	11.6535	11.737	11.566	11.566	16610360.0

> showing 50 of 42,825 rows — these rows as CSV

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