PREVIEW / stock_1hour / 2013-10-21

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-10-21.parquet
  size:    1.0 MB
  rows:    48,887
  symbols: 3,546

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
2013-10-21 04:00:00	AAPL	Stock	18.2143	18.275	18.2143	18.25	102900.0
2013-10-21 05:00:00	AAPL	Stock	18.25	18.3211	18.25	18.2964	199976.0
2013-10-21 06:00:00	AAPL	Stock	18.2957	18.3036	18.2821	18.2821	139160.0
2013-10-21 07:00:00	AAPL	Stock	18.2804	18.3036	18.2589	18.2857	975940.0
2013-10-21 08:00:00	AAPL	Stock	18.2943	18.3393	18.2539	18.3018	2932188.0
2013-10-21 09:00:00	AAPL	Stock	18.3036	18.5946	18.2536	18.5843	98985852.0
2013-10-21 10:00:00	AAPL	Stock	18.5843	18.6175	18.5418	18.5721	67023768.0
2013-10-21 11:00:00	AAPL	Stock	18.5743	18.7143	18.5454	18.705	56379344.0
2013-10-21 12:00:00	AAPL	Stock	18.705	18.7211	18.6539	18.7116	31937556.0
2013-10-21 13:00:00	AAPL	Stock	18.7118	18.725	18.6732	18.7043	26835508.0
2013-10-21 14:00:00	AAPL	Stock	18.7043	18.706	18.555	18.6311	39096624.0
2013-10-21 15:00:00	AAPL	Stock	18.6289	18.6775	18.5636	18.6209	48730304.0
2013-10-21 16:00:00	AAPL	Stock	18.6179	18.6696	18.4867	18.6671	15125320.0
2013-10-21 17:00:00	AAPL	Stock	18.6607	18.7029	18.5994	18.6879	867748.0
2013-10-21 18:00:00	AAPL	Stock	18.6954	18.7482	18.2686	18.7425	830396.0
2013-10-21 19:00:00	AAPL	Stock	18.7429	18.8139	18.7429	18.7946	1963220.0
2013-10-21 06:00:00	MSFT	Stock	35.0	35.01	35.0	35.01	500.0
2013-10-21 07:00:00	MSFT	Stock	35.05	35.05	35.0	35.01	1100.0
2013-10-21 08:00:00	MSFT	Stock	35.0	35.14	35.0	35.08	24833.0
2013-10-21 09:00:00	MSFT	Stock	35.05	35.2	34.97	35.2	6368307.0
2013-10-21 10:00:00	MSFT	Stock	35.195	35.2	34.97	35.013	5054670.0
2013-10-21 11:00:00	MSFT	Stock	35.015	35.1	34.965	35.03	3216804.0
2013-10-21 12:00:00	MSFT	Stock	35.033	35.12	35.015	35.105	1894711.0
2013-10-21 13:00:00	MSFT	Stock	35.102	35.15	35.07	35.095	1622782.0
2013-10-21 14:00:00	MSFT	Stock	35.095	35.1	34.96	35.0	2112279.0
2013-10-21 15:00:00	MSFT	Stock	35.01	35.027	34.91	34.99	5190485.0
2013-10-21 16:00:00	MSFT	Stock	34.99	35.047	34.92	34.98	1429291.0
2013-10-21 17:00:00	MSFT	Stock	34.95	35.049	34.95	34.95	11081.0
2013-10-21 18:00:00	MSFT	Stock	34.95	35.0	34.95	35.0	1336.0
2013-10-21 19:00:00	MSFT	Stock	34.95	34.95	34.95	34.95	1655.0
2013-10-21 09:00:00	NVDA	Stock	0.3953	0.4003	0.3948	0.3982	25547880.0
2013-10-21 10:00:00	NVDA	Stock	0.3982	0.4	0.3962	0.397	34143120.0
2013-10-21 11:00:00	NVDA	Stock	0.397	0.3973	0.3955	0.3968	19631960.0
2013-10-21 12:00:00	NVDA	Stock	0.3968	0.3975	0.3965	0.3968	18152280.0
2013-10-21 13:00:00	NVDA	Stock	0.3969	0.3975	0.3969	0.3971	16920040.0
2013-10-21 14:00:00	NVDA	Stock	0.3971	0.3973	0.395	0.396	23194680.0
2013-10-21 15:00:00	NVDA	Stock	0.3958	0.3965	0.3953	0.3962	52434320.0
2013-10-21 16:00:00	NVDA	Stock	0.3962	0.3968	0.3962	0.3962	4389600.0
2013-10-21 17:00:00	NVDA	Stock	0.397	0.397	0.397	0.397	4000.0
2013-10-21 07:00:00	AMZN	Stock	16.549	16.549	16.499	16.51	14000.0
2013-10-21 08:00:00	AMZN	Stock	16.492	16.544	16.35	16.497	340180.0
2013-10-21 09:00:00	AMZN	Stock	16.4855	16.5075	16.2505	16.315	10571360.0
2013-10-21 10:00:00	AMZN	Stock	16.315	16.385	16.2105	16.239	11763560.0
2013-10-21 11:00:00	AMZN	Stock	16.239	16.3035	16.228	16.298	7308780.0
2013-10-21 12:00:00	AMZN	Stock	16.296	16.3235	16.2628	16.281	3840220.0
2013-10-21 13:00:00	AMZN	Stock	16.2875	16.314	16.2675	16.29	2332720.0
2013-10-21 14:00:00	AMZN	Stock	16.29	16.29	16.1925	16.2025	4367120.0
2013-10-21 15:00:00	AMZN	Stock	16.2065	16.4945	16.19	16.318	6179800.0
2013-10-21 16:00:00	AMZN	Stock	16.322	16.35	16.2547	16.3006	3557000.0
2013-10-21 17:00:00	AMZN	Stock	16.313	16.35	16.313	16.35	53360.0

> showing 50 of 48,887 rows — these rows as CSV

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