PREVIEW / stock_1hour / 2010-03-30

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-03-30.parquet
  size:    916 KB
  rows:    43,462
  symbols: 3,486

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-03-30 04:00:00	AAPL	Stock	8.4625	8.4643	8.4579	8.4611	14000.0
2010-03-30 05:00:00	AAPL	Stock	8.4721	8.4721	8.4721	8.4721	14000.0
2010-03-30 06:00:00	AAPL	Stock	8.4643	8.4743	8.4643	8.4682	40600.0
2010-03-30 07:00:00	AAPL	Stock	8.4679	8.4893	8.4361	8.4518	1380232.0
2010-03-30 08:00:00	AAPL	Stock	8.4643	8.4911	8.4554	8.4696	9462516.0
2010-03-30 09:00:00	AAPL	Stock	8.4682	8.4814	8.4196	8.4579	148314376.0
2010-03-30 10:00:00	AAPL	Stock	8.4582	8.4671	8.3946	8.4164	113315888.0
2010-03-30 11:00:00	AAPL	Stock	8.4164	8.44	8.3661	8.43	86170112.0
2010-03-30 12:00:00	AAPL	Stock	8.4318	8.4343	8.4114	8.4175	28568680.0
2010-03-30 13:00:00	AAPL	Stock	8.4182	8.4232	8.395	8.4211	35190316.0
2010-03-30 14:00:00	AAPL	Stock	8.4211	8.4361	8.4129	8.4337	31089828.0
2010-03-30 15:00:00	AAPL	Stock	8.4339	8.4421	8.4204	8.4225	62260380.0
2010-03-30 16:00:00	AAPL	Stock	8.4225	8.432	8.4218	8.4264	7284452.0
2010-03-30 17:00:00	AAPL	Stock	8.4264	8.4264	8.4164	8.4186	422968.0
2010-03-30 18:00:00	AAPL	Stock	8.4232	8.4232	8.4154	8.4214	209188.0
2010-03-30 19:00:00	AAPL	Stock	8.4214	8.4214	8.4114	8.4161	164668.0
2010-03-30 20:00:00	AAPL	Stock	8.4314	8.4314	8.4314	8.4314	1537200.0
2010-03-30 08:00:00	MSFT	Stock	29.59	29.6	29.56	29.57	2733.0
2010-03-30 09:00:00	MSFT	Stock	29.59	29.77	29.5	29.74	4406936.0
2010-03-30 10:00:00	MSFT	Stock	29.75	29.76	29.54	29.705	5863196.0
2010-03-30 11:00:00	MSFT	Stock	29.705	29.73	29.55	29.66	6322407.0
2010-03-30 12:00:00	MSFT	Stock	29.67	29.69	29.6	29.68	2375296.0
2010-03-30 13:00:00	MSFT	Stock	29.672	29.68	29.605	29.67	2470793.0
2010-03-30 14:00:00	MSFT	Stock	29.67	29.75	29.655	29.72	3121439.0
2010-03-30 15:00:00	MSFT	Stock	29.73	29.86	29.725	29.76	8239342.0
2010-03-30 16:00:00	MSFT	Stock	29.76	29.831	29.685	29.75	1527885.0
2010-03-30 17:00:00	MSFT	Stock	29.75	29.75	29.75	29.75	1300.0
2010-03-30 18:00:00	MSFT	Stock	29.75	29.79	29.75	29.75	1288.0
2010-03-30 19:00:00	MSFT	Stock	29.75	29.75	29.75	29.75	200.0
2010-03-30 08:00:00	NVDA	Stock	0.442	0.4448	0.442	0.4438	511680.0
2010-03-30 09:00:00	NVDA	Stock	0.4418	0.4462	0.4418	0.4445	40528800.0
2010-03-30 10:00:00	NVDA	Stock	0.4445	0.4448	0.4385	0.4385	82519400.0
2010-03-30 11:00:00	NVDA	Stock	0.4385	0.4388	0.4332	0.437	65285200.0
2010-03-30 12:00:00	NVDA	Stock	0.437	0.439	0.4364	0.4386	27105600.0
2010-03-30 13:00:00	NVDA	Stock	0.4388	0.4388	0.4362	0.4372	16215360.0
2010-03-30 14:00:00	NVDA	Stock	0.4375	0.4395	0.4368	0.4395	20371280.0
2010-03-30 15:00:00	NVDA	Stock	0.4395	0.4412	0.4388	0.4408	56093720.0
2010-03-30 16:00:00	NVDA	Stock	0.4408	0.4408	0.4396	0.4408	12439280.0
2010-03-30 18:00:00	NVDA	Stock	0.4418	0.4418	0.4418	0.4418	20000.0
2010-03-30 19:00:00	NVDA	Stock	0.4408	0.4418	0.4408	0.4418	12000.0
2010-03-30 07:00:00	AMZN	Stock	6.7595	6.7835	6.7595	6.7835	23700.0
2010-03-30 08:00:00	AMZN	Stock	6.8	6.8	6.775	6.785	109540.0
2010-03-30 09:00:00	AMZN	Stock	6.7845	6.8995	6.768	6.879	25230420.0
2010-03-30 10:00:00	AMZN	Stock	6.88	6.9095	6.8385	6.8525	30291520.0
2010-03-30 11:00:00	AMZN	Stock	6.852	6.8835	6.81	6.8575	21745660.0
2010-03-30 12:00:00	AMZN	Stock	6.8585	6.88	6.844	6.844	8057800.0
2010-03-30 13:00:00	AMZN	Stock	6.8445	6.849	6.8115	6.82	8687300.0
2010-03-30 14:00:00	AMZN	Stock	6.8208	6.849	6.8125	6.8415	8974580.0
2010-03-30 15:00:00	AMZN	Stock	6.8435	6.8492	6.825	6.8335	17106860.0
2010-03-30 16:00:00	AMZN	Stock	6.8305	6.8478	6.825	6.8354	448460.0

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

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