PREVIEW / stock_1hour / 2010-06-02

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-06-02.parquet
  size:    966 KB
  rows:    46,148
  symbols: 3,475

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-06-02 04:00:00	AAPL	Stock	9.3932	9.4314	9.3654	9.3664	89600.0
2010-06-02 05:00:00	AAPL	Stock	9.4204	9.4261	9.4204	9.4261	5600.0
2010-06-02 06:00:00	AAPL	Stock	9.425	9.4407	9.4186	9.425	30520.0
2010-06-02 07:00:00	AAPL	Stock	9.425	9.4368	9.3946	9.4071	681968.0
2010-06-02 08:00:00	AAPL	Stock	9.4071	9.455	9.4018	9.4254	6411076.0
2010-06-02 09:00:00	AAPL	Stock	9.4257	9.4571	9.325	9.3843	117158048.0
2010-06-02 10:00:00	AAPL	Stock	9.3864	9.4225	9.3393	9.3649	112694848.0
2010-06-02 11:00:00	AAPL	Stock	9.3646	9.4061	9.3646	9.3921	70479920.0
2010-06-02 12:00:00	AAPL	Stock	9.3932	9.4207	9.3857	9.4086	42762076.0
2010-06-02 13:00:00	AAPL	Stock	9.4086	9.4232	9.3446	9.3561	68616268.0
2010-06-02 14:00:00	AAPL	Stock	9.3575	9.3814	9.2977	9.3571	119552104.0
2010-06-02 15:00:00	AAPL	Stock	9.3564	9.4268	9.3486	9.4264	123862312.0
2010-06-02 16:00:00	AAPL	Stock	9.4268	9.4268	9.3807	9.4161	13701324.0
2010-06-02 17:00:00	AAPL	Stock	9.4179	9.4418	9.4146	9.4409	2915808.0
2010-06-02 18:00:00	AAPL	Stock	9.4409	9.4411	9.4107	9.4107	665280.0
2010-06-02 19:00:00	AAPL	Stock	9.4207	9.425	9.4107	9.4246	568428.0
2010-06-02 20:00:00	AAPL	Stock	9.3932	9.3932	9.3932	9.3932	184800.0
2010-06-02 07:00:00	MSFT	Stock	26.05	26.05	26.05	26.05	500.0
2010-06-02 08:00:00	MSFT	Stock	25.89	26.12	25.89	26.04	45759.0
2010-06-02 09:00:00	MSFT	Stock	26.03	26.09	25.73	25.82	8092464.0
2010-06-02 10:00:00	MSFT	Stock	25.815	25.95	25.79	25.92	8053999.0
2010-06-02 11:00:00	MSFT	Stock	25.91	26.04	25.9	26.025	5619279.0
2010-06-02 12:00:00	MSFT	Stock	26.02	26.06	26.01	26.035	5871890.0
2010-06-02 13:00:00	MSFT	Stock	26.035	26.08	26.03	26.055	4286002.0
2010-06-02 14:00:00	MSFT	Stock	26.052	26.23	25.975	26.21	8609957.0
2010-06-02 15:00:00	MSFT	Stock	26.2	26.48	26.19	26.43	18450335.0
2010-06-02 16:00:00	MSFT	Stock	26.43	26.47	26.078	26.43	4655230.0
2010-06-02 17:00:00	MSFT	Stock	26.39	26.43	26.097	26.097	367840.0
2010-06-02 18:00:00	MSFT	Stock	26.35	26.43	26.136	26.35	57476.0
2010-06-02 19:00:00	MSFT	Stock	26.33	26.39	26.33	26.38	2500.0
2010-06-02 20:00:00	MSFT	Stock	25.99	26.05	25.99	26.05	392400.0
2010-06-02 08:00:00	NVDA	Stock	0.3145	0.3165	0.3145	0.3163	270360.0
2010-06-02 09:00:00	NVDA	Stock	0.3163	0.3175	0.3129	0.3158	51959120.0
2010-06-02 10:00:00	NVDA	Stock	0.3158	0.3173	0.314	0.3148	105119080.0
2010-06-02 11:00:00	NVDA	Stock	0.3148	0.3166	0.3145	0.316	52588560.0
2010-06-02 12:00:00	NVDA	Stock	0.3163	0.3175	0.316	0.3175	34227640.0
2010-06-02 13:00:00	NVDA	Stock	0.3175	0.3183	0.3156	0.316	30812240.0
2010-06-02 14:00:00	NVDA	Stock	0.3158	0.316	0.3133	0.3153	125507600.0
2010-06-02 15:00:00	NVDA	Stock	0.3153	0.3184	0.315	0.318	222724200.0
2010-06-02 16:00:00	NVDA	Stock	0.3178	0.318	0.3151	0.318	5471200.0
2010-06-02 17:00:00	NVDA	Stock	0.318	0.3188	0.3162	0.3162	2377440.0
2010-06-02 18:00:00	NVDA	Stock	0.3162	0.3183	0.3162	0.318	103560.0
2010-06-02 19:00:00	NVDA	Stock	0.318	0.3188	0.318	0.3188	220000.0
2010-06-02 08:00:00	AMZN	Stock	6.223	6.2325	6.22	6.225	84380.0
2010-06-02 09:00:00	AMZN	Stock	6.2325	6.25	6.0915	6.1055	14435760.0
2010-06-02 10:00:00	AMZN	Stock	6.1055	6.2	6.0825	6.1845	20866700.0
2010-06-02 11:00:00	AMZN	Stock	6.184	6.23	6.178	6.2135	12059660.0
2010-06-02 12:00:00	AMZN	Stock	6.213	6.2465	6.205	6.245	8008860.0
2010-06-02 13:00:00	AMZN	Stock	6.2455	6.256	6.2185	6.2315	7553040.0
2010-06-02 14:00:00	AMZN	Stock	6.232	6.262	6.1875	6.2575	9253100.0

> showing 50 of 46,148 rows — these rows as CSV

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