PREVIEW / stock_1hour / 2008-06-27

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-06-27.parquet
  size:    959 KB
  rows:    45,744
  symbols: 3,335

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
2008-06-27 04:00:00	AAPL	Stock	6.0	6.0	6.0	6.0	2800.0
2008-06-27 05:00:00	AAPL	Stock	6.0089	6.0089	5.9839	5.9943	14000.0
2008-06-27 07:00:00	AAPL	Stock	5.9646	5.9804	5.9357	5.9568	261128.0
2008-06-27 08:00:00	AAPL	Stock	5.9643	5.9775	5.8957	5.9518	5630184.0
2008-06-27 09:00:00	AAPL	Stock	5.9514	6.0179	5.9068	6.0168	148609440.0
2008-06-27 10:00:00	AAPL	Stock	6.0171	6.0625	5.9696	6.0061	159606048.0
2008-06-27 11:00:00	AAPL	Stock	6.0067	6.0182	5.9775	6.0	124815992.0
2008-06-27 12:00:00	AAPL	Stock	5.9996	6.0343	5.9643	5.9839	72123800.0
2008-06-27 13:00:00	AAPL	Stock	5.9839	5.9875	5.8625	5.9057	123515924.0
2008-06-27 14:00:00	AAPL	Stock	5.9054	6.0686	5.9054	6.0682	168050736.0
2008-06-27 15:00:00	AAPL	Stock	6.0679	6.0918	6.03	6.0749	156390192.0
2008-06-27 16:00:00	AAPL	Stock	6.0737	6.0839	5.9941	6.0716	21914872.0
2008-06-27 17:00:00	AAPL	Stock	6.0749	6.0811	6.0718	6.0811	22907808.0
2008-06-27 18:00:00	AAPL	Stock	6.0746	6.0789	5.9941	6.0764	2835868.0
2008-06-27 19:00:00	AAPL	Stock	6.0764	6.0839	6.0757	6.0821	88620.0
2008-06-27 07:00:00	MSFT	Stock	27.63	27.63	27.56	27.59	1600.0
2008-06-27 08:00:00	MSFT	Stock	27.65	27.72	27.6	27.6	7225.0
2008-06-27 09:00:00	MSFT	Stock	27.71	27.9	27.58	27.77	5504566.0
2008-06-27 10:00:00	MSFT	Stock	27.77	27.91	27.57	27.7	10827118.0
2008-06-27 11:00:00	MSFT	Stock	27.7	27.79	27.61	27.72	5725825.0
2008-06-27 12:00:00	MSFT	Stock	27.72	27.86	27.62	27.69	5608273.0
2008-06-27 13:00:00	MSFT	Stock	27.68	27.69	27.46	27.572	7862406.0
2008-06-27 14:00:00	MSFT	Stock	27.57	27.81	27.54	27.8	7584690.0
2008-06-27 15:00:00	MSFT	Stock	27.79	27.88	27.59	27.69	10583910.0
2008-06-27 16:00:00	MSFT	Stock	27.7	27.72	27.627	27.63	11541000.0
2008-06-27 17:00:00	MSFT	Stock	27.636	27.72	27.622	27.639	2799942.0
2008-06-27 18:00:00	MSFT	Stock	27.63	27.71	27.63	27.7	333871.0
2008-06-27 19:00:00	MSFT	Stock	27.68	27.71	27.68	27.71	2633.0
2008-06-27 08:00:00	NVDA	Stock	0.4753	0.4775	0.4753	0.4753	124880.0
2008-06-27 09:00:00	NVDA	Stock	0.4755	0.4805	0.4678	0.4805	86806520.0
2008-06-27 10:00:00	NVDA	Stock	0.4803	0.4848	0.4763	0.478	105232320.0
2008-06-27 11:00:00	NVDA	Stock	0.4778	0.4808	0.4763	0.477	50487280.0
2008-06-27 12:00:00	NVDA	Stock	0.4772	0.4805	0.4768	0.4788	45487440.0
2008-06-27 13:00:00	NVDA	Stock	0.4785	0.479	0.475	0.4763	93401080.0
2008-06-27 14:00:00	NVDA	Stock	0.4763	0.4812	0.476	0.4808	71543720.0
2008-06-27 15:00:00	NVDA	Stock	0.4808	0.483	0.478	0.482	84320960.0
2008-06-27 16:00:00	NVDA	Stock	0.482	0.485	0.4781	0.4818	4698640.0
2008-06-27 17:00:00	NVDA	Stock	0.482	0.4825	0.48	0.48	11732840.0
2008-06-27 18:00:00	NVDA	Stock	0.482	0.482	0.48	0.4818	589280.0
2008-06-27 19:00:00	NVDA	Stock	0.4818	0.4818	0.4818	0.4818	8000.0
2008-06-27 08:00:00	AMZN	Stock	3.8495	3.8495	3.765	3.81	111180.0
2008-06-27 09:00:00	AMZN	Stock	3.8345	3.8345	3.7225	3.7745	31753740.0
2008-06-27 10:00:00	AMZN	Stock	3.7745	3.793	3.7145	3.7205	40023200.0
2008-06-27 11:00:00	AMZN	Stock	3.7205	3.7365	3.6875	3.7275	24263620.0
2008-06-27 12:00:00	AMZN	Stock	3.7275	3.735	3.6955	3.699	20682600.0
2008-06-27 13:00:00	AMZN	Stock	3.699	3.6995	3.631	3.659	32620580.0
2008-06-27 14:00:00	AMZN	Stock	3.659	3.738	3.658	3.73	34169000.0
2008-06-27 15:00:00	AMZN	Stock	3.7295	3.755	3.7075	3.7325	30614420.0
2008-06-27 16:00:00	AMZN	Stock	3.7365	3.7375	3.7011	3.7312	2744540.0
2008-06-27 17:00:00	AMZN	Stock	3.7327	3.733	3.7188	3.7322	5311340.0

> showing 50 of 45,744 rows — these rows as CSV

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