PREVIEW / stock_1hour / 2009-12-18

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-12-18.parquet
  size:    990 KB
  rows:    45,551
  symbols: 3,450

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-18 04:00:00	AAPL	Stock	6.9089	6.9089	6.9089	6.9089	2800.0
2009-12-18 06:00:00	AAPL	Stock	6.8893	6.8893	6.8893	6.8893	2800.0
2009-12-18 07:00:00	AAPL	Stock	6.9018	6.9107	6.8946	6.8961	208096.0
2009-12-18 08:00:00	AAPL	Stock	6.8996	6.92	6.8893	6.9014	2214268.0
2009-12-18 09:00:00	AAPL	Stock	6.9007	6.9318	6.8786	6.9243	159427548.0
2009-12-18 10:00:00	AAPL	Stock	6.9236	6.9375	6.8821	6.9061	83949796.0
2009-12-18 11:00:00	AAPL	Stock	6.9071	6.9107	6.8807	6.9004	36729532.0
2009-12-18 12:00:00	AAPL	Stock	6.8996	6.925	6.8954	6.9175	34728652.0
2009-12-18 13:00:00	AAPL	Stock	6.9171	6.9307	6.9	6.9275	39424280.0
2009-12-18 14:00:00	AAPL	Stock	6.9268	6.96	6.9214	6.959	82840548.0
2009-12-18 15:00:00	AAPL	Stock	6.9589	6.9736	6.9357	6.9736	109398800.0
2009-12-18 16:00:00	AAPL	Stock	6.97	6.9856	6.8999	6.9675	39783492.0
2009-12-18 17:00:00	AAPL	Stock	6.9675	6.9854	6.9604	6.9679	6509748.0
2009-12-18 18:00:00	AAPL	Stock	6.9671	6.9796	6.965	6.9682	544124.0
2009-12-18 19:00:00	AAPL	Stock	6.9643	6.975	6.9607	6.9729	599844.0
2009-12-18 07:00:00	MSFT	Stock	29.72	29.72	29.72	29.72	1100.0
2009-12-18 08:00:00	MSFT	Stock	29.82	29.84	29.65	29.77	17059.0
2009-12-18 09:00:00	MSFT	Stock	29.77	30.1	29.71	30.02	22996657.0
2009-12-18 10:00:00	MSFT	Stock	30.02	30.16	29.98	30.05	8108561.0
2009-12-18 11:00:00	MSFT	Stock	30.05	30.1	29.99	30.01	6405493.0
2009-12-18 12:00:00	MSFT	Stock	30.02	30.09	30.0	30.039	4172439.0
2009-12-18 13:00:00	MSFT	Stock	30.04	30.06	30.0	30.01	2992991.0
2009-12-18 14:00:00	MSFT	Stock	30.01	30.06	30.0	30.05	4403062.0
2009-12-18 15:00:00	MSFT	Stock	30.05	30.45	30.0	30.37	20859725.0
2009-12-18 16:00:00	MSFT	Stock	30.37	30.45	30.026	30.32	17988563.0
2009-12-18 17:00:00	MSFT	Stock	30.254	30.38	30.035	30.24	1909955.0
2009-12-18 18:00:00	MSFT	Stock	30.38	30.39	30.34	30.39	47521.0
2009-12-18 19:00:00	MSFT	Stock	30.34	30.39	30.34	30.39	500.0
2009-12-18 20:00:00	MSFT	Stock	30.0	30.0	30.0	30.0	2600.0
2009-12-18 07:00:00	NVDA	Stock	0.425	0.425	0.425	0.425	4000.0
2009-12-18 08:00:00	NVDA	Stock	0.425	0.425	0.4225	0.4248	221600.0
2009-12-18 09:00:00	NVDA	Stock	0.4245	0.4258	0.4225	0.4228	159983400.0
2009-12-18 10:00:00	NVDA	Stock	0.4228	0.4238	0.4155	0.4205	152357760.0
2009-12-18 11:00:00	NVDA	Stock	0.4202	0.4208	0.4173	0.4192	66146080.0
2009-12-18 12:00:00	NVDA	Stock	0.419	0.4228	0.419	0.4205	57473160.0
2009-12-18 13:00:00	NVDA	Stock	0.4205	0.4222	0.4198	0.4202	70614600.0
2009-12-18 14:00:00	NVDA	Stock	0.4202	0.4208	0.4192	0.42	57456040.0
2009-12-18 15:00:00	NVDA	Stock	0.4202	0.4215	0.417	0.421	160272600.0
2009-12-18 16:00:00	NVDA	Stock	0.421	0.4215	0.4196	0.4215	56846360.0
2009-12-18 17:00:00	NVDA	Stock	0.4207	0.4213	0.4203	0.4205	3734800.0
2009-12-18 18:00:00	NVDA	Stock	0.4205	0.4238	0.4205	0.4238	150800.0
2009-12-18 19:00:00	NVDA	Stock	0.4238	0.4248	0.4238	0.4238	108120.0
2009-12-18 06:00:00	AMZN	Stock	6.3825	6.3825	6.3825	6.3825	4000.0
2009-12-18 07:00:00	AMZN	Stock	6.38	6.39	6.38	6.39	58000.0
2009-12-18 08:00:00	AMZN	Stock	6.38	6.406	6.38	6.3895	505000.0
2009-12-18 09:00:00	AMZN	Stock	6.3875	6.414	6.3685	6.383	38999340.0
2009-12-18 10:00:00	AMZN	Stock	6.3835	6.4095	6.326	6.34	25045720.0
2009-12-18 11:00:00	AMZN	Stock	6.34	6.344	6.2824	6.311	17164200.0
2009-12-18 12:00:00	AMZN	Stock	6.3096	6.367	6.3055	6.3655	12439480.0
2009-12-18 13:00:00	AMZN	Stock	6.3665	6.398	6.3475	6.3955	12301240.0

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

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