PREVIEW / stock_1hour / 2010-02-18

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-02-18.parquet
  size:    902 KB
  rows:    43,162
  symbols: 3,451

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-02-18 04:00:00	AAPL	Stock	7.21	7.2143	7.21	7.2143	8400.0
2010-02-18 07:00:00	AAPL	Stock	7.2279	7.2279	7.2279	7.2279	5600.0
2010-02-18 08:00:00	AAPL	Stock	7.2118	7.2268	7.1646	7.1714	2794400.0
2010-02-18 09:00:00	AAPL	Stock	7.1743	7.2193	7.1743	7.2071	59361316.0
2010-02-18 10:00:00	AAPL	Stock	7.2079	7.2639	7.1879	7.2529	87261776.0
2010-02-18 11:00:00	AAPL	Stock	7.2532	7.2818	7.2429	7.2546	66158792.0
2010-02-18 12:00:00	AAPL	Stock	7.2543	7.2643	7.2325	7.2411	30978640.0
2010-02-18 13:00:00	AAPL	Stock	7.2411	7.2511	7.2329	7.2414	36514912.0
2010-02-18 14:00:00	AAPL	Stock	7.2421	7.2782	7.2336	7.2746	56285348.0
2010-02-18 15:00:00	AAPL	Stock	7.2746	7.2782	7.2418	7.2514	66125808.0
2010-02-18 16:00:00	AAPL	Stock	7.2514	7.2622	7.1936	7.2011	6838104.0
2010-02-18 17:00:00	AAPL	Stock	7.2032	7.2507	7.1821	7.1839	853552.0
2010-02-18 18:00:00	AAPL	Stock	7.185	7.2475	7.1839	7.1875	371168.0
2010-02-18 19:00:00	AAPL	Stock	7.1875	7.1911	7.1793	7.1893	735616.0
2010-02-18 07:00:00	MSFT	Stock	28.59	28.59	28.59	28.59	100.0
2010-02-18 08:00:00	MSFT	Stock	28.56	28.6	28.48	28.53	30048.0
2010-02-18 09:00:00	MSFT	Stock	28.5	28.73	28.5	28.69	5102595.0
2010-02-18 10:00:00	MSFT	Stock	28.68	28.75	28.6	28.7	6084099.0
2010-02-18 11:00:00	MSFT	Stock	28.7	28.72	28.63	28.683	3490911.0
2010-02-18 12:00:00	MSFT	Stock	28.685	28.72	28.63	28.66	2587498.0
2010-02-18 13:00:00	MSFT	Stock	28.66	28.73	28.66	28.71	2466632.0
2010-02-18 14:00:00	MSFT	Stock	28.72	28.96	28.67	28.94	6631769.0
2010-02-18 15:00:00	MSFT	Stock	28.95	29.03	28.89	28.97	14083809.0
2010-02-18 16:00:00	MSFT	Stock	28.97	29.09	28.58	28.6	1322789.0
2010-02-18 17:00:00	MSFT	Stock	28.751	28.97	28.55	28.73	48158.0
2010-02-18 18:00:00	MSFT	Stock	28.97	28.97	28.7	28.75	5290.0
2010-02-18 19:00:00	MSFT	Stock	28.72	28.72	28.65	28.65	14301.0
2010-02-18 07:00:00	NVDA	Stock	0.4258	0.432	0.4258	0.432	43960.0
2010-02-18 08:00:00	NVDA	Stock	0.431	0.431	0.4208	0.4215	14483240.0
2010-02-18 09:00:00	NVDA	Stock	0.4213	0.4318	0.4053	0.4115	462283800.0
2010-02-18 10:00:00	NVDA	Stock	0.4115	0.4192	0.4088	0.4158	302863000.0
2010-02-18 11:00:00	NVDA	Stock	0.4158	0.4218	0.4133	0.4218	194452120.0
2010-02-18 12:00:00	NVDA	Stock	0.4215	0.4232	0.413	0.4155	142018720.0
2010-02-18 13:00:00	NVDA	Stock	0.4155	0.4175	0.4142	0.4145	71763000.0
2010-02-18 14:00:00	NVDA	Stock	0.4145	0.4182	0.4138	0.4168	95066040.0
2010-02-18 15:00:00	NVDA	Stock	0.4165	0.4175	0.4155	0.4168	192667360.0
2010-02-18 16:00:00	NVDA	Stock	0.4165	0.4168	0.4125	0.4125	9047520.0
2010-02-18 17:00:00	NVDA	Stock	0.4145	0.415	0.4138	0.415	622720.0
2010-02-18 18:00:00	NVDA	Stock	0.415	0.4168	0.4125	0.4125	9324680.0
2010-02-18 19:00:00	NVDA	Stock	0.4128	0.4145	0.4125	0.4125	96400.0
2010-02-18 08:00:00	AMZN	Stock	5.792	5.8175	5.7805	5.7855	263060.0
2010-02-18 09:00:00	AMZN	Stock	5.7925	5.8	5.741	5.761	23902300.0
2010-02-18 10:00:00	AMZN	Stock	5.763	5.8335	5.7515	5.8174	40092540.0
2010-02-18 11:00:00	AMZN	Stock	5.817	5.8335	5.803	5.8221	24839860.0
2010-02-18 12:00:00	AMZN	Stock	5.822	5.85	5.8125	5.8415	16541340.0
2010-02-18 13:00:00	AMZN	Stock	5.8415	5.8735	5.836	5.8705	17710660.0
2010-02-18 14:00:00	AMZN	Stock	5.8705	5.89	5.858	5.889	22436080.0
2010-02-18 15:00:00	AMZN	Stock	5.888	5.9255	5.881	5.904	45038400.0
2010-02-18 16:00:00	AMZN	Stock	5.909	5.9095	5.8144	5.865	1335200.0
2010-02-18 17:00:00	AMZN	Stock	5.869	5.904	5.8565	5.861	345180.0

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

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