PREVIEW / stock_1hour / 2010-11-03

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-11-03.parquet
  size:    898 KB
  rows:    42,853
  symbols: 3,475

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-11-03 04:00:00	AAPL	Stock	11.095	11.095	11.095	11.095	2800.0
2010-11-03 05:00:00	AAPL	Stock	11.0854	11.0854	11.08	11.08	19600.0
2010-11-03 06:00:00	AAPL	Stock	11.0925	11.0925	11.0818	11.0921	11200.0
2010-11-03 07:00:00	AAPL	Stock	11.0789	11.0893	11.0757	11.0889	269920.0
2010-11-03 08:00:00	AAPL	Stock	11.0907	11.1429	11.0786	11.1375	5798072.0
2010-11-03 09:00:00	AAPL	Stock	11.1407	11.1429	11.0746	11.1084	78076292.0
2010-11-03 10:00:00	AAPL	Stock	11.1086	11.1429	11.0646	11.0733	66450216.0
2010-11-03 11:00:00	AAPL	Stock	11.0732	11.0879	11.0368	11.0579	44093896.0
2010-11-03 12:00:00	AAPL	Stock	11.0557	11.0889	11.0371	11.0832	25484816.0
2010-11-03 13:00:00	AAPL	Stock	11.0842	11.0968	11.0582	11.075	29660736.0
2010-11-03 14:00:00	AAPL	Stock	11.0768	11.1589	11.0189	11.1425	133730716.0
2010-11-03 15:00:00	AAPL	Stock	11.1425	11.1743	11.1286	11.1696	112663264.0
2010-11-03 16:00:00	AAPL	Stock	11.17	11.1925	11.0695	11.1889	8711472.0
2010-11-03 17:00:00	AAPL	Stock	11.1879	11.19	11.1356	11.1804	1427916.0
2010-11-03 18:00:00	AAPL	Stock	11.1804	11.1846	11.1714	11.1793	705684.0
2010-11-03 19:00:00	AAPL	Stock	11.1804	11.1821	11.1718	11.1757	490700.0
2010-11-03 07:00:00	MSFT	Stock	27.4	27.4	27.4	27.4	500.0
2010-11-03 08:00:00	MSFT	Stock	27.4	27.48	27.4	27.45	20970.0
2010-11-03 09:00:00	MSFT	Stock	27.46	27.49	27.28	27.33	9811805.0
2010-11-03 10:00:00	MSFT	Stock	27.34	27.37	27.25	27.274	15538707.0
2010-11-03 11:00:00	MSFT	Stock	27.27	27.302	27.1	27.17	9422269.0
2010-11-03 12:00:00	MSFT	Stock	27.172	27.19	26.99	27.092	6452677.0
2010-11-03 13:00:00	MSFT	Stock	27.092	27.17	27.09	27.12	6439391.0
2010-11-03 14:00:00	MSFT	Stock	27.12	27.24	26.96	27.21	26413082.0
2010-11-03 15:00:00	MSFT	Stock	27.21	27.25	26.99	27.03	30955909.0
2010-11-03 16:00:00	MSFT	Stock	27.03	27.4	27.01	27.12	2866883.0
2010-11-03 17:00:00	MSFT	Stock	27.08	27.11	27.06	27.09	14185.0
2010-11-03 18:00:00	MSFT	Stock	27.03	27.1	27.03	27.1	19023.0
2010-11-03 19:00:00	MSFT	Stock	27.1	27.15	27.1	27.13	37003.0
2010-11-03 08:00:00	NVDA	Stock	0.3083	0.3113	0.3083	0.3113	42000.0
2010-11-03 09:00:00	NVDA	Stock	0.31	0.31	0.305	0.306	64738680.0
2010-11-03 10:00:00	NVDA	Stock	0.306	0.3062	0.3032	0.3034	82719600.0
2010-11-03 11:00:00	NVDA	Stock	0.3035	0.3042	0.3028	0.303	75102320.0
2010-11-03 12:00:00	NVDA	Stock	0.303	0.3032	0.3012	0.3018	52677120.0
2010-11-03 13:00:00	NVDA	Stock	0.302	0.303	0.3015	0.3025	30851880.0
2010-11-03 14:00:00	NVDA	Stock	0.3024	0.3095	0.3022	0.3088	153692720.0
2010-11-03 15:00:00	NVDA	Stock	0.309	0.3115	0.3083	0.3095	201132360.0
2010-11-03 16:00:00	NVDA	Stock	0.31	0.311	0.3061	0.3105	1865920.0
2010-11-03 17:00:00	NVDA	Stock	0.3095	0.3098	0.3095	0.3098	32000.0
2010-11-03 18:00:00	NVDA	Stock	0.3098	0.3098	0.3098	0.3098	40000.0
2010-11-03 07:00:00	AMZN	Stock	8.2695	8.2695	8.2695	8.2695	2000.0
2010-11-03 08:00:00	AMZN	Stock	8.267	8.2745	8.255	8.2745	103240.0
2010-11-03 09:00:00	AMZN	Stock	8.272	8.288	8.1735	8.1885	10914300.0
2010-11-03 10:00:00	AMZN	Stock	8.1885	8.27	8.14	8.143	13120720.0
2010-11-03 11:00:00	AMZN	Stock	8.142	8.1744	8.1145	8.1692	8723220.0
2010-11-03 12:00:00	AMZN	Stock	8.1695	8.185	8.1425	8.177	6208800.0
2010-11-03 13:00:00	AMZN	Stock	8.1775	8.233	8.177	8.2305	8932180.0
2010-11-03 14:00:00	AMZN	Stock	8.2295	8.3645	8.1845	8.3425	27645600.0
2010-11-03 15:00:00	AMZN	Stock	8.3445	8.4305	8.3445	8.424	43629520.0
2010-11-03 16:00:00	AMZN	Stock	8.424	8.4375	8.2796	8.425	2595420.0

> showing 50 of 42,853 rows — these rows as CSV

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