PREVIEW / stock_1hour / 2010-04-27

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-04-27.parquet
  size:    934 KB
  rows:    43,947
  symbols: 3,505

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-04-27 04:00:00	AAPL	Stock	9.5807	9.5807	9.5807	9.5807	2800.0
2010-04-27 05:00:00	AAPL	Stock	9.5786	9.5911	9.5446	9.5446	30800.0
2010-04-27 06:00:00	AAPL	Stock	9.5379	9.5379	9.4932	9.5114	155036.0
2010-04-27 07:00:00	AAPL	Stock	9.525	9.5571	9.5146	9.5571	354620.0
2010-04-27 08:00:00	AAPL	Stock	9.5479	9.5661	9.5446	9.5614	1257452.0
2010-04-27 09:00:00	AAPL	Stock	9.5607	9.5632	9.4982	9.5354	83808340.0
2010-04-27 10:00:00	AAPL	Stock	9.5357	9.5657	9.5093	9.5493	74252668.0
2010-04-27 11:00:00	AAPL	Stock	9.5493	9.5532	9.3043	9.3832	169648164.0
2010-04-27 12:00:00	AAPL	Stock	9.3832	9.4034	9.3321	9.3858	76471640.0
2010-04-27 13:00:00	AAPL	Stock	9.3868	9.4604	9.3861	9.4531	71185632.0
2010-04-27 14:00:00	AAPL	Stock	9.4532	9.4536	9.3839	9.3968	63588280.0
2010-04-27 15:00:00	AAPL	Stock	9.3968	9.4296	9.3186	9.3654	115969084.0
2010-04-27 16:00:00	AAPL	Stock	9.3657	9.6287	9.3442	9.3689	15077132.0
2010-04-27 17:00:00	AAPL	Stock	9.3664	9.3729	9.3643	9.3721	290696.0
2010-04-27 18:00:00	AAPL	Stock	9.3725	9.3739	9.3586	9.3711	1080380.0
2010-04-27 19:00:00	AAPL	Stock	9.3686	9.3857	9.3686	9.3857	249368.0
2010-04-27 20:00:00	AAPL	Stock	9.3593	9.3593	9.3593	9.3593	8400.0
2010-04-27 06:00:00	MSFT	Stock	31.02	31.02	31.02	31.02	600.0
2010-04-27 07:00:00	MSFT	Stock	30.93	31.04	30.93	31.04	1360.0
2010-04-27 08:00:00	MSFT	Stock	30.98	31.0	30.96	30.99	14741.0
2010-04-27 09:00:00	MSFT	Stock	30.99	31.24	30.93	31.18	8391380.0
2010-04-27 10:00:00	MSFT	Stock	31.18	31.25	31.111	31.2	8299824.0
2010-04-27 11:00:00	MSFT	Stock	31.2	31.21	30.8	30.842	13691356.0
2010-04-27 12:00:00	MSFT	Stock	30.85	30.99	30.8	30.86	7201455.0
2010-04-27 13:00:00	MSFT	Stock	30.855	31.0	30.83	30.915	5281700.0
2010-04-27 14:00:00	MSFT	Stock	30.91	30.96	30.84	30.858	5306422.0
2010-04-27 15:00:00	MSFT	Stock	30.86	30.988	30.749	30.86	16682341.0
2010-04-27 16:00:00	MSFT	Stock	30.85	31.215	30.825	30.86	3225181.0
2010-04-27 17:00:00	MSFT	Stock	30.87	30.9	30.86	30.9	7186.0
2010-04-27 18:00:00	MSFT	Stock	30.86	30.9	30.85	30.9	4600.0
2010-04-27 19:00:00	MSFT	Stock	30.86	30.86	30.86	30.86	1000.0
2010-04-27 09:00:00	NVDA	Stock	0.412	0.413	0.4085	0.4115	47413560.0
2010-04-27 10:00:00	NVDA	Stock	0.4115	0.4162	0.41	0.415	76518840.0
2010-04-27 11:00:00	NVDA	Stock	0.4148	0.4152	0.4032	0.4032	110492760.0
2010-04-27 12:00:00	NVDA	Stock	0.4035	0.406	0.402	0.4035	74888800.0
2010-04-27 13:00:00	NVDA	Stock	0.4036	0.4072	0.4032	0.4062	58473520.0
2010-04-27 14:00:00	NVDA	Stock	0.406	0.4068	0.4043	0.4043	50680080.0
2010-04-27 15:00:00	NVDA	Stock	0.4044	0.4065	0.402	0.4035	177905680.0
2010-04-27 16:00:00	NVDA	Stock	0.403	0.4066	0.4029	0.4055	3780240.0
2010-04-27 17:00:00	NVDA	Stock	0.4055	0.4055	0.4032	0.4032	72760.0
2010-04-27 19:00:00	NVDA	Stock	0.4035	0.4035	0.4035	0.4035	10040.0
2010-04-27 07:00:00	AMZN	Stock	7.3365	7.3365	7.3365	7.3365	3000.0
2010-04-27 08:00:00	AMZN	Stock	7.325	7.333	7.3195	7.325	161260.0
2010-04-27 09:00:00	AMZN	Stock	7.32	7.3325	7.221	7.2595	20828640.0
2010-04-27 10:00:00	AMZN	Stock	7.2595	7.2905	7.2255	7.257	20582660.0
2010-04-27 11:00:00	AMZN	Stock	7.2585	7.2635	7.1105	7.1265	32405680.0
2010-04-27 12:00:00	AMZN	Stock	7.125	7.155	7.09	7.131	19054320.0
2010-04-27 13:00:00	AMZN	Stock	7.133	7.1755	7.129	7.133	12620660.0
2010-04-27 14:00:00	AMZN	Stock	7.133	7.137	7.0724	7.074	21941360.0
2010-04-27 15:00:00	AMZN	Stock	7.074	7.1125	7.0555	7.101	37011700.0

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

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