PREVIEW / stock_1hour / 2012-05-24

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-05-24.parquet
  size:    930 KB
  rows:    44,339
  symbols: 3,542

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
2012-05-24 04:00:00	AAPL	Stock	20.3796	20.3796	20.3214	20.3214	44604.0
2012-05-24 05:00:00	AAPL	Stock	20.4196	20.4196	20.4196	20.4196	14000.0
2012-05-24 06:00:00	AAPL	Stock	20.4504	20.5	20.4504	20.4893	118888.0
2012-05-24 07:00:00	AAPL	Stock	20.4889	20.5325	20.4643	20.4786	729204.0
2012-05-24 08:00:00	AAPL	Stock	20.4818	20.5339	20.3804	20.5018	5201252.0
2012-05-24 09:00:00	AAPL	Stock	20.5054	20.5893	20.2161	20.3245	106151360.0
2012-05-24 10:00:00	AAPL	Stock	20.3225	20.4743	20.3075	20.4029	95638424.0
2012-05-24 11:00:00	AAPL	Stock	20.4027	20.4404	20.2357	20.2689	55165936.0
2012-05-24 12:00:00	AAPL	Stock	20.2689	20.3446	20.1964	20.2604	42349552.0
2012-05-24 13:00:00	AAPL	Stock	20.2604	20.3411	20.1979	20.2	33834696.0
2012-05-24 14:00:00	AAPL	Stock	20.2071	20.2621	20.0893	20.0971	52215996.0
2012-05-24 15:00:00	AAPL	Stock	20.0971	20.2393	20.0439	20.1875	87159940.0
2012-05-24 16:00:00	AAPL	Stock	20.19	20.3714	20.1695	20.2125	9297092.0
2012-05-24 17:00:00	AAPL	Stock	20.2132	20.2214	20.19	20.2214	305088.0
2012-05-24 18:00:00	AAPL	Stock	20.2232	20.2232	20.1936	20.2054	136248.0
2012-05-24 19:00:00	AAPL	Stock	20.1989	20.2211	20.1429	20.2089	528892.0
2012-05-24 06:00:00	MSFT	Stock	29.2	29.25	29.2	29.25	200.0
2012-05-24 07:00:00	MSFT	Stock	29.25	29.25	29.2	29.2	4800.0
2012-05-24 08:00:00	MSFT	Stock	29.16	29.2	29.12	29.17	41078.0
2012-05-24 09:00:00	MSFT	Stock	29.18	29.24	28.92	28.92	5992111.0
2012-05-24 10:00:00	MSFT	Stock	28.92	29.11	28.868	29.09	10785922.0
2012-05-24 11:00:00	MSFT	Stock	29.085	29.3	29.035	29.11	5679436.0
2012-05-24 12:00:00	MSFT	Stock	29.11	29.12	28.97	29.02	4715774.0
2012-05-24 13:00:00	MSFT	Stock	29.02	29.1	28.9	28.908	3548292.0
2012-05-24 14:00:00	MSFT	Stock	28.91	28.96	28.76	28.778	7054305.0
2012-05-24 15:00:00	MSFT	Stock	28.78	29.08	28.76	29.08	10902731.0
2012-05-24 16:00:00	MSFT	Stock	29.07	29.25	29.0	29.22	3549217.0
2012-05-24 17:00:00	MSFT	Stock	29.11	29.23	29.11	29.23	4700.0
2012-05-24 19:00:00	MSFT	Stock	29.19	29.2	29.19	29.19	1025.0
2012-05-24 08:00:00	NVDA	Stock	0.3123	0.3123	0.312	0.312	88000.0
2012-05-24 09:00:00	NVDA	Stock	0.312	0.3133	0.3032	0.3045	51872160.0
2012-05-24 10:00:00	NVDA	Stock	0.3046	0.3075	0.3025	0.3048	94947560.0
2012-05-24 11:00:00	NVDA	Stock	0.3048	0.3083	0.3048	0.306	53318520.0
2012-05-24 12:00:00	NVDA	Stock	0.306	0.306	0.3025	0.3032	72235840.0
2012-05-24 13:00:00	NVDA	Stock	0.3035	0.3048	0.3008	0.301	56400720.0
2012-05-24 14:00:00	NVDA	Stock	0.3008	0.3039	0.3006	0.3018	81658120.0
2012-05-24 15:00:00	NVDA	Stock	0.3019	0.3031	0.3005	0.3028	96569240.0
2012-05-24 16:00:00	NVDA	Stock	0.3028	0.3041	0.3027	0.3041	1631120.0
2012-05-24 17:00:00	NVDA	Stock	0.3052	0.3052	0.3052	0.3052	28000.0
2012-05-24 18:00:00	NVDA	Stock	0.3052	0.3052	0.3052	0.3052	16000.0
2012-05-24 04:00:00	AMZN	Stock	10.814	10.814	10.814	10.814	6000.0
2012-05-24 05:00:00	AMZN	Stock	10.814	10.814	10.814	10.814	2000.0
2012-05-24 06:00:00	AMZN	Stock	10.864	10.864	10.864	10.864	36700.0
2012-05-24 07:00:00	AMZN	Stock	10.864	10.864	10.8495	10.85	10300.0
2012-05-24 08:00:00	AMZN	Stock	10.828	10.842	10.815	10.84	85660.0
2012-05-24 09:00:00	AMZN	Stock	10.8425	10.883	10.6765	10.748	10695700.0
2012-05-24 10:00:00	AMZN	Stock	10.7515	10.797	10.6895	10.7145	9511700.0
2012-05-24 11:00:00	AMZN	Stock	10.7135	10.749	10.6975	10.7138	8109980.0
2012-05-24 12:00:00	AMZN	Stock	10.7135	10.721	10.701	10.7065	8083840.0
2012-05-24 13:00:00	AMZN	Stock	10.707	10.7425	10.666	10.669	8938760.0

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

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