PREVIEW / stock_1hour / 2010-05-07

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-05-07.parquet
  size:    957 KB
  rows:    45,707
  symbols: 3,480

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-05-07 04:00:00	AAPL	Stock	8.6714	8.7171	8.6564	8.6564	177800.0
2010-05-07 05:00:00	AAPL	Stock	8.6504	8.6957	8.6429	8.6904	59500.0
2010-05-07 06:00:00	AAPL	Stock	8.6921	8.7968	8.6796	8.7768	678160.0
2010-05-07 07:00:00	AAPL	Stock	8.7893	8.8471	8.7718	8.7907	2712640.0
2010-05-07 08:00:00	AAPL	Stock	8.7857	8.8443	8.7057	8.7625	13485864.0
2010-05-07 09:00:00	AAPL	Stock	8.76	8.8061	8.5193	8.6554	213250072.0
2010-05-07 10:00:00	AAPL	Stock	8.6557	8.6632	8.0432	8.3865	475713644.0
2010-05-07 11:00:00	AAPL	Stock	8.3884	8.6507	8.3643	8.5804	253603868.0
2010-05-07 12:00:00	AAPL	Stock	8.5793	8.6736	8.4821	8.4957	154447888.0
2010-05-07 13:00:00	AAPL	Stock	8.4982	8.5339	8.4293	8.4675	122048724.0
2010-05-07 14:00:00	AAPL	Stock	8.4668	8.5	8.36	8.4139	139912080.0
2010-05-07 15:00:00	AAPL	Stock	8.415	8.4921	8.2789	8.4221	265250944.0
2010-05-07 16:00:00	AAPL	Stock	8.4229	8.4757	8.3719	8.4186	20422108.0
2010-05-07 17:00:00	AAPL	Stock	8.4182	8.4189	8.3768	8.4036	1275764.0
2010-05-07 18:00:00	AAPL	Stock	8.4036	8.4236	8.3804	8.3814	359296.0
2010-05-07 19:00:00	AAPL	Stock	8.3804	8.4036	8.3761	8.4025	492240.0
2010-05-07 04:00:00	MSFT	Stock	28.74	28.74	28.74	28.74	200.0
2010-05-07 05:00:00	MSFT	Stock	28.9	28.9	28.9	28.9	700.0
2010-05-07 06:00:00	MSFT	Stock	28.93	29.05	28.93	28.94	1878.0
2010-05-07 07:00:00	MSFT	Stock	29.15	29.15	29.0	29.0	8182.0
2010-05-07 08:00:00	MSFT	Stock	29.0	29.16	28.99	29.15	41158.0
2010-05-07 09:00:00	MSFT	Stock	29.15	29.15	28.428	28.45	16108019.0
2010-05-07 10:00:00	MSFT	Stock	28.46	28.56	27.32	28.33	44856679.0
2010-05-07 11:00:00	MSFT	Stock	28.35	28.94	28.29	28.65	21374190.0
2010-05-07 12:00:00	MSFT	Stock	28.65	28.94	28.45	28.55	13262376.0
2010-05-07 13:00:00	MSFT	Stock	28.55	28.6	28.3	28.4	13788231.0
2010-05-07 14:00:00	MSFT	Stock	28.41	28.43	28.01	28.14	19735160.0
2010-05-07 15:00:00	MSFT	Stock	28.13	28.89	27.66	28.17	38424402.0
2010-05-07 16:00:00	MSFT	Stock	28.18	28.48	27.72	28.21	4983524.0
2010-05-07 17:00:00	MSFT	Stock	28.21	28.25	28.14	28.21	5542.0
2010-05-07 18:00:00	MSFT	Stock	28.21	28.21	28.18	28.19	31430.0
2010-05-07 19:00:00	MSFT	Stock	28.21	28.25	28.17	28.18	5481.0
2010-05-07 07:00:00	NVDA	Stock	0.3562	0.36	0.3562	0.36	40000.0
2010-05-07 08:00:00	NVDA	Stock	0.355	0.3615	0.35	0.3598	131000.0
2010-05-07 09:00:00	NVDA	Stock	0.3598	0.3598	0.3453	0.3453	130048200.0
2010-05-07 10:00:00	NVDA	Stock	0.3453	0.35	0.3365	0.3462	294919840.0
2010-05-07 11:00:00	NVDA	Stock	0.346	0.3582	0.345	0.3525	205970640.0
2010-05-07 12:00:00	NVDA	Stock	0.3525	0.355	0.3495	0.351	129338200.0
2010-05-07 13:00:00	NVDA	Stock	0.3513	0.3548	0.349	0.3522	66464520.0
2010-05-07 14:00:00	NVDA	Stock	0.3522	0.3535	0.3485	0.3508	108951240.0
2010-05-07 15:00:00	NVDA	Stock	0.3508	0.3522	0.3465	0.3493	194110440.0
2010-05-07 16:00:00	NVDA	Stock	0.349	0.3496	0.3478	0.3478	22910800.0
2010-05-07 18:00:00	NVDA	Stock	0.3493	0.3508	0.3493	0.3508	58000.0
2010-05-07 08:00:00	AMZN	Stock	6.3405	6.425	6.3405	6.4005	164560.0
2010-05-07 09:00:00	AMZN	Stock	6.4025	6.559	6.3404	6.449	28832180.0
2010-05-07 10:00:00	AMZN	Stock	6.4465	6.4885	6.2575	6.455	49440980.0
2010-05-07 11:00:00	AMZN	Stock	6.454	6.51	6.3185	6.4235	34830340.0
2010-05-07 12:00:00	AMZN	Stock	6.418	6.4495	6.336	6.3675	22521880.0
2010-05-07 13:00:00	AMZN	Stock	6.371	6.3885	6.297	6.345	18973020.0
2010-05-07 14:00:00	AMZN	Stock	6.349	6.365	6.2725	6.284	27263440.0

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

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