PREVIEW / stock_1hour / 2010-08-05

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-08-05.parquet
  size:    890 KB
  rows:    42,869
  symbols: 3,462

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-08-05 04:00:00	AAPL	Stock	9.4107	9.4107	9.4107	9.4107	8400.0
2010-08-05 05:00:00	AAPL	Stock	9.4018	9.4018	9.4018	9.4018	17500.0
2010-08-05 07:00:00	AAPL	Stock	9.4193	9.4286	9.3964	9.4107	167804.0
2010-08-05 08:00:00	AAPL	Stock	9.3971	9.4186	9.3732	9.3768	2715272.0
2010-08-05 09:00:00	AAPL	Stock	9.3768	9.3993	9.3232	9.3582	52406508.0
2010-08-05 10:00:00	AAPL	Stock	9.3589	9.38	9.3171	9.3257	58852276.0
2010-08-05 11:00:00	AAPL	Stock	9.3262	9.3454	9.3054	9.3311	44062928.0
2010-08-05 12:00:00	AAPL	Stock	9.3331	9.3425	9.3107	9.3261	22620500.0
2010-08-05 13:00:00	AAPL	Stock	9.3261	9.3546	9.3107	9.3496	25782764.0
2010-08-05 14:00:00	AAPL	Stock	9.35	9.3571	9.3214	9.345	26356008.0
2010-08-05 15:00:00	AAPL	Stock	9.3436	9.365	9.3329	9.3464	50498112.0
2010-08-05 16:00:00	AAPL	Stock	9.3464	9.3541	9.3379	9.3436	4327596.0
2010-08-05 17:00:00	AAPL	Stock	9.3429	9.3475	9.3404	9.3429	147112.0
2010-08-05 18:00:00	AAPL	Stock	9.3457	9.3464	9.34	9.34	105840.0
2010-08-05 19:00:00	AAPL	Stock	9.34	9.34	9.3357	9.3393	141260.0
2010-08-05 20:00:00	AAPL	Stock	9.335	9.335	9.335	9.335	19600.0
2010-08-05 07:00:00	MSFT	Stock	25.87	25.93	25.86	25.87	4400.0
2010-08-05 08:00:00	MSFT	Stock	25.85	25.86	25.63	25.63	35420.0
2010-08-05 09:00:00	MSFT	Stock	25.729	25.729	25.41	25.5	5537340.0
2010-08-05 10:00:00	MSFT	Stock	25.5	25.54	25.31	25.31	11279474.0
2010-08-05 11:00:00	MSFT	Stock	25.32	25.33	25.21	25.26	11340719.0
2010-08-05 12:00:00	MSFT	Stock	25.26	25.38	25.252	25.32	7312145.0
2010-08-05 13:00:00	MSFT	Stock	25.325	25.39	25.29	25.37	6679707.0
2010-08-05 14:00:00	MSFT	Stock	25.38	25.4	25.31	25.35	6704369.0
2010-08-05 15:00:00	MSFT	Stock	25.35	25.4	25.29	25.37	13581276.0
2010-08-05 16:00:00	MSFT	Stock	25.37	25.73	25.3	25.4	1632512.0
2010-08-05 17:00:00	MSFT	Stock	25.4	25.4	25.36	25.37	22920.0
2010-08-05 18:00:00	MSFT	Stock	25.4	25.4	25.37	25.37	18185.0
2010-08-05 19:00:00	MSFT	Stock	25.38	25.38	25.37	25.37	4275.0
2010-08-05 04:00:00	NVDA	Stock	0.2342	0.235	0.2342	0.235	24000.0
2010-08-05 05:00:00	NVDA	Stock	0.2362	0.242	0.2362	0.242	36000.0
2010-08-05 06:00:00	NVDA	Stock	0.2418	0.2418	0.2418	0.2418	4000.0
2010-08-05 07:00:00	NVDA	Stock	0.24	0.24	0.2388	0.239	676000.0
2010-08-05 08:00:00	NVDA	Stock	0.2385	0.24	0.2345	0.2355	4995280.0
2010-08-05 09:00:00	NVDA	Stock	0.2355	0.2365	0.2305	0.2315	107724480.0
2010-08-05 10:00:00	NVDA	Stock	0.2318	0.2322	0.2298	0.2305	93186680.0
2010-08-05 11:00:00	NVDA	Stock	0.2305	0.2325	0.2295	0.2315	77559480.0
2010-08-05 12:00:00	NVDA	Stock	0.2315	0.2355	0.2315	0.2348	129388600.0
2010-08-05 13:00:00	NVDA	Stock	0.2348	0.2362	0.234	0.2358	131266760.0
2010-08-05 14:00:00	NVDA	Stock	0.2358	0.2365	0.2355	0.2355	83884320.0
2010-08-05 15:00:00	NVDA	Stock	0.2358	0.2365	0.2352	0.2358	162062480.0
2010-08-05 16:00:00	NVDA	Stock	0.2358	0.237	0.233	0.2358	9460840.0
2010-08-05 17:00:00	NVDA	Stock	0.2358	0.2358	0.2355	0.2355	44000.0
2010-08-05 18:00:00	NVDA	Stock	0.236	0.2365	0.236	0.2365	198000.0
2010-08-05 19:00:00	NVDA	Stock	0.236	0.236	0.234	0.2342	103360.0
2010-08-05 08:00:00	AMZN	Stock	6.3965	6.3965	6.3275	6.3375	201640.0
2010-08-05 09:00:00	AMZN	Stock	6.34	6.3985	6.3215	6.3525	18194780.0
2010-08-05 10:00:00	AMZN	Stock	6.353	6.3705	6.3015	6.3025	15389700.0
2010-08-05 11:00:00	AMZN	Stock	6.3025	6.344	6.291	6.3315	10162380.0
2010-08-05 12:00:00	AMZN	Stock	6.331	6.3565	6.3275	6.3405	7102280.0

> showing 50 of 42,869 rows — these rows as CSV

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