PREVIEW / stock_1hour / 2010-03-09

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-03-09.parquet
  size:    916 KB
  rows:    43,416
  symbols: 3,461

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-09 05:00:00	AAPL	Stock	7.7857	7.7857	7.7857	7.7857	5628.0
2010-03-09 06:00:00	AAPL	Stock	7.785	7.785	7.785	7.785	2800.0
2010-03-09 07:00:00	AAPL	Stock	7.7686	7.7982	7.7686	7.7964	134008.0
2010-03-09 08:00:00	AAPL	Stock	7.7993	7.815	7.7939	7.8075	1118740.0
2010-03-09 09:00:00	AAPL	Stock	7.8107	7.8436	7.7818	7.8382	72220680.0
2010-03-09 10:00:00	AAPL	Stock	7.8368	8.0061	7.8218	7.9893	207694004.0
2010-03-09 11:00:00	AAPL	Stock	7.9907	7.9939	7.9464	7.9893	119707980.0
2010-03-09 12:00:00	AAPL	Stock	7.9893	8.0171	7.9782	8.0121	71083684.0
2010-03-09 13:00:00	AAPL	Stock	8.0119	8.0286	7.9957	8.0271	67990272.0
2010-03-09 14:00:00	AAPL	Stock	8.0271	8.0357	7.9664	7.9771	107992976.0
2010-03-09 15:00:00	AAPL	Stock	7.9772	7.9875	7.9082	7.9704	167157480.0
2010-03-09 16:00:00	AAPL	Stock	7.9661	8.0291	7.9571	7.9679	11987024.0
2010-03-09 17:00:00	AAPL	Stock	7.9654	7.9679	7.9643	7.9679	224168.0
2010-03-09 18:00:00	AAPL	Stock	7.9696	7.975	7.9679	7.9679	357812.0
2010-03-09 19:00:00	AAPL	Stock	7.9682	7.9757	7.9675	7.975	214228.0
2010-03-09 07:00:00	MSFT	Stock	28.53	28.53	28.53	28.53	399.0
2010-03-09 08:00:00	MSFT	Stock	28.55	28.57	28.49	28.52	38975.0
2010-03-09 09:00:00	MSFT	Stock	28.5	28.891	28.5	28.885	4347678.0
2010-03-09 10:00:00	MSFT	Stock	28.88	28.92	28.77	28.9	7461968.0
2010-03-09 11:00:00	MSFT	Stock	28.9	28.94	28.78	28.91	5763288.0
2010-03-09 12:00:00	MSFT	Stock	28.91	29.05	28.9	29.045	6212034.0
2010-03-09 13:00:00	MSFT	Stock	29.045	29.11	28.98	28.99	7060335.0
2010-03-09 14:00:00	MSFT	Stock	29.0	29.07	28.89	28.9	5031708.0
2010-03-09 15:00:00	MSFT	Stock	28.895	28.94	28.74	28.8	10794217.0
2010-03-09 16:00:00	MSFT	Stock	28.8	28.925	28.772	28.81	1522251.0
2010-03-09 17:00:00	MSFT	Stock	28.63	28.82	28.63	28.82	708004.0
2010-03-09 18:00:00	MSFT	Stock	28.83	28.87	28.82	28.82	6700.0
2010-03-09 19:00:00	MSFT	Stock	28.82	28.87	28.82	28.83	3770.0
2010-03-09 07:00:00	NVDA	Stock	0.4205	0.4205	0.4205	0.4205	20000.0
2010-03-09 08:00:00	NVDA	Stock	0.4205	0.4275	0.4205	0.4272	1297480.0
2010-03-09 09:00:00	NVDA	Stock	0.4272	0.435	0.4262	0.4328	119742520.0
2010-03-09 10:00:00	NVDA	Stock	0.4325	0.436	0.4312	0.4358	118343400.0
2010-03-09 11:00:00	NVDA	Stock	0.4358	0.437	0.4328	0.4365	83361200.0
2010-03-09 12:00:00	NVDA	Stock	0.4368	0.4418	0.4362	0.4416	107059360.0
2010-03-09 13:00:00	NVDA	Stock	0.4416	0.443	0.4388	0.44	94673520.0
2010-03-09 14:00:00	NVDA	Stock	0.4398	0.4425	0.439	0.4394	73015280.0
2010-03-09 15:00:00	NVDA	Stock	0.4394	0.4395	0.4352	0.4388	202452080.0
2010-03-09 16:00:00	NVDA	Stock	0.4388	0.4395	0.4352	0.4382	16773720.0
2010-03-09 17:00:00	NVDA	Stock	0.4375	0.4375	0.4375	0.4375	4000.0
2010-03-09 18:00:00	NVDA	Stock	0.439	0.439	0.4382	0.4382	7154840.0
2010-03-09 19:00:00	NVDA	Stock	0.4382	0.4382	0.4382	0.4382	6000.0
2010-03-09 08:00:00	AMZN	Stock	6.441	6.4685	6.441	6.464	64020.0
2010-03-09 09:00:00	AMZN	Stock	6.4625	6.5295	6.4625	6.508	14488580.0
2010-03-09 10:00:00	AMZN	Stock	6.5094	6.5405	6.484	6.526	21569300.0
2010-03-09 11:00:00	AMZN	Stock	6.5275	6.528	6.487	6.5095	13866700.0
2010-03-09 12:00:00	AMZN	Stock	6.5095	6.5147	6.494	6.5085	9693560.0
2010-03-09 13:00:00	AMZN	Stock	6.5085	6.509	6.45	6.472	13872100.0
2010-03-09 14:00:00	AMZN	Stock	6.4725	6.4955	6.4535	6.456	15811220.0
2010-03-09 15:00:00	AMZN	Stock	6.4552	6.4685	6.3985	6.441	29656760.0
2010-03-09 16:00:00	AMZN	Stock	6.441	6.4859	6.4135	6.43	1937540.0

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

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