PREVIEW / stock_1hour / 2011-11-01

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-11-01.parquet
  size:    940 KB
  rows:    44,858
  symbols: 3,497

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-01 04:00:00	AAPL	Stock	14.4021	14.4021	14.2529	14.3007	44352.0
2011-11-01 05:00:00	AAPL	Stock	14.3204	14.3204	14.2982	14.2982	25200.0
2011-11-01 06:00:00	AAPL	Stock	14.2821	14.2821	14.2614	14.2625	49504.0
2011-11-01 07:00:00	AAPL	Stock	14.2768	14.3	14.1943	14.2457	876372.0
2011-11-01 08:00:00	AAPL	Stock	14.2571	14.2857	14.1868	14.2136	4751264.0
2011-11-01 09:00:00	AAPL	Stock	14.2054	14.4564	14.1429	14.2296	84222460.0
2011-11-01 10:00:00	AAPL	Stock	14.2325	14.265	14.1871	14.2102	77810432.0
2011-11-01 11:00:00	AAPL	Stock	14.2061	14.2089	14.09	14.0982	74134340.0
2011-11-01 12:00:00	AAPL	Stock	14.0968	14.1589	14.0436	14.1057	59538556.0
2011-11-01 13:00:00	AAPL	Stock	14.1057	14.2321	14.0732	14.185	71215648.0
2011-11-01 14:00:00	AAPL	Stock	14.1846	14.2543	14.1646	14.1964	56172368.0
2011-11-01 15:00:00	AAPL	Stock	14.1946	14.2075	14.1071	14.1657	87714872.0
2011-11-01 16:00:00	AAPL	Stock	14.1611	14.2039	14.1539	14.1964	9429588.0
2011-11-01 17:00:00	AAPL	Stock	14.1964	14.2407	14.1611	14.2093	810208.0
2011-11-01 18:00:00	AAPL	Stock	14.2011	14.2114	14.1611	14.1857	303324.0
2011-11-01 19:00:00	AAPL	Stock	14.1857	14.1868	14.1714	14.1721	363300.0
2011-11-01 04:00:00	MSFT	Stock	26.3	26.3	26.26	26.26	200.0
2011-11-01 06:00:00	MSFT	Stock	26.2	26.2	26.13	26.14	3000.0
2011-11-01 07:00:00	MSFT	Stock	26.25	26.35	26.18	26.22	13787.0
2011-11-01 08:00:00	MSFT	Stock	26.19	26.63	26.0	26.1	101293.0
2011-11-01 09:00:00	MSFT	Stock	26.07	26.63	25.97	26.2	6262600.0
2011-11-01 10:00:00	MSFT	Stock	26.2	26.32	26.09	26.23	9348951.0
2011-11-01 11:00:00	MSFT	Stock	26.225	26.29	26.03	26.08	6099478.0
2011-11-01 12:00:00	MSFT	Stock	26.078	26.1	25.87	25.88	7164534.0
2011-11-01 13:00:00	MSFT	Stock	25.87	26.21	25.86	26.13	7928013.0
2011-11-01 14:00:00	MSFT	Stock	26.13	26.21	26.06	26.095	5116196.0
2011-11-01 15:00:00	MSFT	Stock	26.095	26.13	25.89	25.97	16262757.0
2011-11-01 16:00:00	MSFT	Stock	25.97	26.1	25.97	26.08	2448961.0
2011-11-01 17:00:00	MSFT	Stock	26.1	26.19	25.99	26.07	117935.0
2011-11-01 18:00:00	MSFT	Stock	25.99	26.11	25.99	26.11	18392.0
2011-11-01 19:00:00	MSFT	Stock	26.1	26.1	26.06	26.1	4225.0
2011-11-01 08:00:00	NVDA	Stock	0.36	0.3625	0.3545	0.3548	951760.0
2011-11-01 09:00:00	NVDA	Stock	0.355	0.3565	0.351	0.3542	94630600.0
2011-11-01 10:00:00	NVDA	Stock	0.3545	0.3575	0.3525	0.3553	118086200.0
2011-11-01 11:00:00	NVDA	Stock	0.355	0.3555	0.3485	0.3498	112702600.0
2011-11-01 12:00:00	NVDA	Stock	0.3498	0.3533	0.348	0.35	65529120.0
2011-11-01 13:00:00	NVDA	Stock	0.3498	0.355	0.349	0.3525	102075640.0
2011-11-01 14:00:00	NVDA	Stock	0.3525	0.356	0.3515	0.3535	96788360.0
2011-11-01 15:00:00	NVDA	Stock	0.3535	0.3558	0.35	0.3513	185073680.0
2011-11-01 16:00:00	NVDA	Stock	0.3515	0.37	0.3513	0.3525	5678880.0
2011-11-01 17:00:00	NVDA	Stock	0.3528	0.3528	0.3528	0.3528	240000.0
2011-11-01 18:00:00	NVDA	Stock	0.3538	0.3542	0.3515	0.353	615200.0
2011-11-01 19:00:00	NVDA	Stock	0.353	0.3542	0.3515	0.3533	176000.0
2011-11-01 04:00:00	AMZN	Stock	10.539	10.6345	10.539	10.6345	32000.0
2011-11-01 07:00:00	AMZN	Stock	10.504	10.504	10.425	10.425	138680.0
2011-11-01 08:00:00	AMZN	Stock	10.4365	10.475	10.4	10.406	899440.0
2011-11-01 09:00:00	AMZN	Stock	10.42	10.501	10.3715	10.458	20029960.0
2011-11-01 10:00:00	AMZN	Stock	10.459	10.625	10.4155	10.581	29501740.0
2011-11-01 11:00:00	AMZN	Stock	10.574	10.6465	10.4945	10.505	18322540.0
2011-11-01 12:00:00	AMZN	Stock	10.499	10.538	10.451	10.451	14055400.0

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

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