PREVIEW / stock_1hour / 2010-06-22

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-06-22.parquet
  size:    897 KB
  rows:    43,010
  symbols: 3,468

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
2010-06-22 04:00:00	AAPL	Stock	9.7118	9.7118	9.7118	9.7118	2800.0
2010-06-22 05:00:00	AAPL	Stock	9.6832	9.6832	9.6786	9.6793	30800.0
2010-06-22 06:00:00	AAPL	Stock	9.6832	9.6896	9.6661	9.6661	52192.0
2010-06-22 07:00:00	AAPL	Stock	9.6689	9.7139	9.6679	9.6925	1279824.0
2010-06-22 08:00:00	AAPL	Stock	9.6936	9.7314	9.6825	9.7271	4519088.0
2010-06-22 09:00:00	AAPL	Stock	9.7264	9.8161	9.7054	9.7786	106581552.0
2010-06-22 10:00:00	AAPL	Stock	9.7796	9.7839	9.6964	9.7714	119180768.0
2010-06-22 11:00:00	AAPL	Stock	9.77	9.8409	9.7207	9.7918	112338492.0
2010-06-22 12:00:00	AAPL	Stock	9.7943	9.8246	9.7893	9.8168	49469868.0
2010-06-22 13:00:00	AAPL	Stock	9.8168	9.8561	9.8089	9.8343	74344816.0
2010-06-22 14:00:00	AAPL	Stock	9.8346	9.8346	9.7418	9.76	107404920.0
2010-06-22 15:00:00	AAPL	Stock	9.7614	9.7946	9.7225	9.7664	117003152.0
2010-06-22 16:00:00	AAPL	Stock	9.7661	9.7868	9.7306	9.7804	13059004.0
2010-06-22 17:00:00	AAPL	Stock	9.7832	9.7929	9.7714	9.775	844368.0
2010-06-22 18:00:00	AAPL	Stock	9.7732	9.7839	9.7679	9.7836	693672.0
2010-06-22 19:00:00	AAPL	Stock	9.7821	9.7925	9.7786	9.7925	818412.0
2010-06-22 07:00:00	MSFT	Stock	25.92	25.92	25.88	25.88	1235.0
2010-06-22 08:00:00	MSFT	Stock	25.95	26.02	25.94	26.02	28200.0
2010-06-22 09:00:00	MSFT	Stock	26.05	26.45	26.05	26.2	7007296.0
2010-06-22 10:00:00	MSFT	Stock	26.2	26.31	26.04	26.26	9156042.0
2010-06-22 11:00:00	MSFT	Stock	26.26	26.34	26.16	26.265	6171739.0
2010-06-22 12:00:00	MSFT	Stock	26.265	26.3	26.2	26.24	3499983.0
2010-06-22 13:00:00	MSFT	Stock	26.24	26.32	26.17	26.225	4082106.0
2010-06-22 14:00:00	MSFT	Stock	26.225	26.26	26.0	26.03	8153075.0
2010-06-22 15:00:00	MSFT	Stock	26.02	26.07	25.76	25.78	13255780.0
2010-06-22 16:00:00	MSFT	Stock	25.78	26.268	25.77	25.8	3526851.0
2010-06-22 17:00:00	MSFT	Stock	25.8	25.91	25.79	25.9	23789.0
2010-06-22 18:00:00	MSFT	Stock	25.77	25.92	25.77	25.85	72644.0
2010-06-22 19:00:00	MSFT	Stock	25.86	25.86	25.85	25.85	300.0
2010-06-22 08:00:00	NVDA	Stock	0.3038	0.305	0.3015	0.3045	168000.0
2010-06-22 09:00:00	NVDA	Stock	0.3035	0.3078	0.3025	0.3028	76342080.0
2010-06-22 10:00:00	NVDA	Stock	0.3025	0.3028	0.2978	0.3015	150418240.0
2010-06-22 11:00:00	NVDA	Stock	0.3015	0.3015	0.2975	0.2981	106367080.0
2010-06-22 12:00:00	NVDA	Stock	0.298	0.2992	0.2965	0.2975	49546960.0
2010-06-22 13:00:00	NVDA	Stock	0.2974	0.2982	0.2928	0.2931	107279200.0
2010-06-22 14:00:00	NVDA	Stock	0.2932	0.2932	0.2888	0.29	142329040.0
2010-06-22 15:00:00	NVDA	Stock	0.2901	0.2908	0.2875	0.289	164500600.0
2010-06-22 16:00:00	NVDA	Stock	0.2888	0.2958	0.288	0.2898	14272840.0
2010-06-22 17:00:00	NVDA	Stock	0.2898	0.29	0.289	0.29	322400.0
2010-06-22 18:00:00	NVDA	Stock	0.2892	0.2932	0.2892	0.29	209360.0
2010-06-22 19:00:00	NVDA	Stock	0.29	0.29	0.2888	0.29	468200.0
2010-06-22 07:00:00	AMZN	Stock	6.086	6.086	6.0815	6.0815	14000.0
2010-06-22 08:00:00	AMZN	Stock	6.108	6.14	6.107	6.1125	45700.0
2010-06-22 09:00:00	AMZN	Stock	6.1315	6.215	6.089	6.1805	19264460.0
2010-06-22 10:00:00	AMZN	Stock	6.178	6.195	6.0775	6.18	26913860.0
2010-06-22 11:00:00	AMZN	Stock	6.1815	6.2615	6.168	6.2186	13058800.0
2010-06-22 12:00:00	AMZN	Stock	6.2205	6.255	6.2005	6.2255	8787540.0
2010-06-22 13:00:00	AMZN	Stock	6.2265	6.2445	6.2	6.2165	10410540.0
2010-06-22 14:00:00	AMZN	Stock	6.2158	6.2158	6.126	6.145	15913780.0
2010-06-22 15:00:00	AMZN	Stock	6.144	6.1645	6.1025	6.118	25279400.0

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

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