PREVIEW / stock_1hour / 2009-12-08

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-12-08.parquet
  size:    896 KB
  rows:    42,887
  symbols: 3,416

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
2009-12-08 04:00:00	AAPL	Stock	6.7679	6.7679	6.7679	6.7679	22400.0
2009-12-08 05:00:00	AAPL	Stock	6.7668	6.7668	6.7643	6.7668	11200.0
2009-12-08 06:00:00	AAPL	Stock	6.7593	6.7593	6.7321	6.7321	14000.0
2009-12-08 07:00:00	AAPL	Stock	6.7271	6.7321	6.715	6.7286	153636.0
2009-12-08 08:00:00	AAPL	Stock	6.7304	6.7511	6.7054	6.7093	3307220.0
2009-12-08 09:00:00	AAPL	Stock	6.7096	6.7982	6.7089	6.7668	135011856.0
2009-12-08 10:00:00	AAPL	Stock	6.7668	6.8189	6.7436	6.7856	135305408.0
2009-12-08 11:00:00	AAPL	Stock	6.7857	6.8696	6.7786	6.8415	107846368.0
2009-12-08 12:00:00	AAPL	Stock	6.8411	6.8496	6.8089	6.8296	44884980.0
2009-12-08 13:00:00	AAPL	Stock	6.8293	6.8321	6.7961	6.8246	48146896.0
2009-12-08 14:00:00	AAPL	Stock	6.8243	6.8275	6.7771	6.7835	53910808.0
2009-12-08 15:00:00	AAPL	Stock	6.7832	6.8043	6.7721	6.7796	77735476.0
2009-12-08 16:00:00	AAPL	Stock	6.7793	6.8399	6.7511	6.7779	8646288.0
2009-12-08 17:00:00	AAPL	Stock	6.7789	6.7832	6.7782	6.7821	264656.0
2009-12-08 18:00:00	AAPL	Stock	6.7814	6.7854	6.7786	6.785	222628.0
2009-12-08 19:00:00	AAPL	Stock	6.7839	6.7843	6.7464	6.7596	1471288.0
2009-12-08 07:00:00	MSFT	Stock	29.6	29.6	29.6	29.6	1724.0
2009-12-08 08:00:00	MSFT	Stock	29.68	29.79	29.5	29.59	23220.0
2009-12-08 09:00:00	MSFT	Stock	29.59	29.61	29.38	29.51	7413362.0
2009-12-08 10:00:00	MSFT	Stock	29.52	29.74	29.48	29.54	6877647.0
2009-12-08 11:00:00	MSFT	Stock	29.55	29.68	29.52	29.62	3643750.0
2009-12-08 12:00:00	MSFT	Stock	29.62	29.65	29.6	29.64	2483713.0
2009-12-08 13:00:00	MSFT	Stock	29.635	29.64	29.55	29.57	2644399.0
2009-12-08 14:00:00	MSFT	Stock	29.567	29.58	29.53	29.569	4077574.0
2009-12-08 15:00:00	MSFT	Stock	29.56	29.69	29.56	29.57	7334449.0
2009-12-08 16:00:00	MSFT	Stock	29.57	29.616	29.54	29.54	2079298.0
2009-12-08 17:00:00	MSFT	Stock	29.57	29.57	29.55	29.55	9781.0
2009-12-08 18:00:00	MSFT	Stock	29.59	29.59	29.57	29.57	21634.0
2009-12-08 19:00:00	MSFT	Stock	29.57	29.6	29.55	29.6	4100.0
2009-12-08 05:00:00	NVDA	Stock	0.4022	0.4022	0.4003	0.4003	12000.0
2009-12-08 08:00:00	NVDA	Stock	0.3925	0.4022	0.3925	0.3985	1348560.0
2009-12-08 09:00:00	NVDA	Stock	0.399	0.3998	0.388	0.393	251648440.0
2009-12-08 10:00:00	NVDA	Stock	0.393	0.394	0.3848	0.3876	276493880.0
2009-12-08 11:00:00	NVDA	Stock	0.3876	0.3898	0.387	0.3885	117532600.0
2009-12-08 12:00:00	NVDA	Stock	0.3885	0.3888	0.384	0.3873	66852280.0
2009-12-08 13:00:00	NVDA	Stock	0.3873	0.3873	0.3828	0.3838	80300200.0
2009-12-08 14:00:00	NVDA	Stock	0.3838	0.3845	0.3805	0.3805	103866360.0
2009-12-08 15:00:00	NVDA	Stock	0.3808	0.3875	0.3805	0.3825	147138000.0
2009-12-08 16:00:00	NVDA	Stock	0.3822	0.3889	0.382	0.382	7016800.0
2009-12-08 17:00:00	NVDA	Stock	0.3825	0.3828	0.382	0.382	275160.0
2009-12-08 18:00:00	NVDA	Stock	0.382	0.382	0.382	0.382	56000.0
2009-12-08 19:00:00	NVDA	Stock	0.382	0.3833	0.382	0.3833	133800.0
2009-12-08 06:00:00	AMZN	Stock	6.71	6.71	6.71	6.71	100000.0
2009-12-08 07:00:00	AMZN	Stock	6.7025	6.72	6.7	6.717	150980.0
2009-12-08 08:00:00	AMZN	Stock	6.7175	6.7175	6.676	6.68	512700.0
2009-12-08 09:00:00	AMZN	Stock	6.685	6.725	6.6435	6.6855	31255740.0
2009-12-08 10:00:00	AMZN	Stock	6.6875	6.76	6.671	6.71	33765500.0
2009-12-08 11:00:00	AMZN	Stock	6.71	6.804	6.6955	6.7625	27319220.0
2009-12-08 12:00:00	AMZN	Stock	6.7628	6.793	6.7465	6.7895	10679420.0
2009-12-08 13:00:00	AMZN	Stock	6.788	6.792	6.7395	6.7658	11930960.0

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

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