PREVIEW / stock_1hour / 2010-05-24

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-05-24.parquet
  size:    903 KB
  rows:    43,487
  symbols: 3,444

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-24 04:00:00	AAPL	Stock	8.6889	8.6896	8.6889	8.6896	30800.0
2010-05-24 05:00:00	AAPL	Stock	8.6786	8.6786	8.6429	8.6429	48412.0
2010-05-24 06:00:00	AAPL	Stock	8.6429	8.6429	8.5986	8.5986	165536.0
2010-05-24 07:00:00	AAPL	Stock	8.5807	8.7043	8.5807	8.6914	1614676.0
2010-05-24 08:00:00	AAPL	Stock	8.6843	8.8264	8.6632	8.8071	8580040.0
2010-05-24 09:00:00	AAPL	Stock	8.8093	8.9107	8.795	8.865	143601724.0
2010-05-24 10:00:00	AAPL	Stock	8.8671	8.9443	8.8393	8.9132	163914604.0
2010-05-24 11:00:00	AAPL	Stock	8.9136	8.9339	8.8707	8.9129	79157456.0
2010-05-24 12:00:00	AAPL	Stock	8.9118	8.9552	8.9032	8.9529	65336880.0
2010-05-24 13:00:00	AAPL	Stock	8.9529	8.9607	8.9164	8.9286	64389780.0
2010-05-24 14:00:00	AAPL	Stock	8.9296	8.9518	8.9164	8.9375	67254712.0
2010-05-24 15:00:00	AAPL	Stock	8.9375	8.9446	8.8114	8.8125	139910988.0
2010-05-24 16:00:00	AAPL	Stock	8.8171	8.9404	8.7925	8.8032	10158848.0
2010-05-24 17:00:00	AAPL	Stock	8.8068	8.8086	8.7393	8.7589	1735188.0
2010-05-24 18:00:00	AAPL	Stock	8.7589	8.8129	8.7521	8.7536	395892.0
2010-05-24 19:00:00	AAPL	Stock	8.7557	8.7611	8.75	8.7504	477764.0
2010-05-24 20:00:00	AAPL	Stock	8.9261	8.9261	8.9261	8.9261	2800.0
2010-05-24 07:00:00	MSFT	Stock	26.78	26.79	26.78	26.79	1500.0
2010-05-24 08:00:00	MSFT	Stock	26.75	26.907	26.7	26.78	28005.0
2010-05-24 09:00:00	MSFT	Stock	26.78	26.97	26.59	26.705	5877012.0
2010-05-24 10:00:00	MSFT	Stock	26.72	26.82	26.57	26.595	9554184.0
2010-05-24 11:00:00	MSFT	Stock	26.595	26.8	26.356	26.58	9408598.0
2010-05-24 12:00:00	MSFT	Stock	26.58	26.66	26.54	26.6	8646714.0
2010-05-24 13:00:00	MSFT	Stock	26.595	26.62	26.54	26.571	5795017.0
2010-05-24 14:00:00	MSFT	Stock	26.579	26.61	26.52	26.58	6003461.0
2010-05-24 15:00:00	MSFT	Stock	26.58	26.59	26.26	26.33	23651329.0
2010-05-24 16:00:00	MSFT	Stock	26.33	26.728	26.25	26.29	3079005.0
2010-05-24 17:00:00	MSFT	Stock	26.31	26.32	26.25	26.25	10776.0
2010-05-24 18:00:00	MSFT	Stock	26.3	26.3	26.2	26.23	44346.0
2010-05-24 19:00:00	MSFT	Stock	26.2	26.25	26.15	26.2	10613.0
2010-05-24 20:00:00	MSFT	Stock	26.61	26.61	26.61	26.61	300.0
2010-05-24 08:00:00	NVDA	Stock	0.3175	0.3175	0.3168	0.3168	34040.0
2010-05-24 09:00:00	NVDA	Stock	0.3178	0.321	0.3125	0.314	87585840.0
2010-05-24 10:00:00	NVDA	Stock	0.3138	0.3175	0.3125	0.315	130877640.0
2010-05-24 11:00:00	NVDA	Stock	0.3152	0.3163	0.3125	0.3148	114937440.0
2010-05-24 12:00:00	NVDA	Stock	0.3148	0.3168	0.3133	0.3143	50823800.0
2010-05-24 13:00:00	NVDA	Stock	0.3144	0.3148	0.3115	0.3126	52678160.0
2010-05-24 14:00:00	NVDA	Stock	0.3127	0.3135	0.3118	0.3121	53454760.0
2010-05-24 15:00:00	NVDA	Stock	0.312	0.3125	0.308	0.3088	167473360.0
2010-05-24 16:00:00	NVDA	Stock	0.309	0.3134	0.3073	0.3088	5542800.0
2010-05-24 17:00:00	NVDA	Stock	0.3073	0.3075	0.3065	0.3068	114000.0
2010-05-24 18:00:00	NVDA	Stock	0.307	0.31	0.307	0.31	72000.0
2010-05-24 19:00:00	NVDA	Stock	0.3103	0.3103	0.3073	0.3073	99120.0
2010-05-24 06:00:00	AMZN	Stock	6.0	6.0	6.0	6.0	4000.0
2010-05-24 07:00:00	AMZN	Stock	6.109	6.1115	6.109	6.1115	10000.0
2010-05-24 08:00:00	AMZN	Stock	6.1085	6.1115	6.075	6.1045	196840.0
2010-05-24 09:00:00	AMZN	Stock	6.11	6.1885	6.0865	6.1285	12531920.0
2010-05-24 10:00:00	AMZN	Stock	6.1315	6.198	6.127	6.1525	18406160.0
2010-05-24 11:00:00	AMZN	Stock	6.152	6.194	6.142	6.1785	8580120.0
2010-05-24 12:00:00	AMZN	Stock	6.178	6.225	6.172	6.206	9601280.0

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

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