PREVIEW / stock_1hour / 2008-01-10

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-01-10.parquet
  size:    810 KB
  rows:    40,314
  symbols: 3,261

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
2008-01-10 04:00:00	AAPL	Stock	6.4286	6.4286	6.4018	6.4071	19600.0
2008-01-10 05:00:00	AAPL	Stock	6.4075	6.4175	6.4075	6.4175	11200.0
2008-01-10 06:00:00	AAPL	Stock	6.3932	6.4214	6.3932	6.4214	56000.0
2008-01-10 07:00:00	AAPL	Stock	6.4004	6.4304	6.3929	6.4086	710780.0
2008-01-10 08:00:00	AAPL	Stock	6.4171	6.4311	6.3214	6.3461	11441976.0
2008-01-10 09:00:00	AAPL	Stock	6.3454	6.3564	6.2646	6.2925	195588456.0
2008-01-10 10:00:00	AAPL	Stock	6.2921	6.3336	6.2679	6.2907	241758776.0
2008-01-10 11:00:00	AAPL	Stock	6.2921	6.3168	6.2739	6.3082	102901260.0
2008-01-10 12:00:00	AAPL	Stock	6.3082	6.4643	6.3	6.405	312236568.0
2008-01-10 13:00:00	AAPL	Stock	6.4043	6.4254	6.2979	6.3364	220796632.0
2008-01-10 14:00:00	AAPL	Stock	6.335	6.4232	6.3132	6.4055	182120708.0
2008-01-10 15:00:00	AAPL	Stock	6.4046	6.4321	6.3314	6.3579	198176972.0
2008-01-10 16:00:00	AAPL	Stock	6.3579	6.4268	6.3214	6.3282	15003072.0
2008-01-10 17:00:00	AAPL	Stock	6.3225	6.3295	6.3107	6.325	652904.0
2008-01-10 18:00:00	AAPL	Stock	6.3225	6.3282	6.3125	6.3243	1004556.0
2008-01-10 19:00:00	AAPL	Stock	6.3204	6.3371	6.3171	6.3311	480340.0
2008-01-10 08:00:00	MSFT	Stock	34.39	34.4	34.25	34.25	25045.0
2008-01-10 09:00:00	MSFT	Stock	34.25	34.37	34.05	34.305	6353951.0
2008-01-10 10:00:00	MSFT	Stock	34.3	34.312	33.9	33.95	8975047.0
2008-01-10 11:00:00	MSFT	Stock	33.94	34.07	33.85	33.989	6489562.0
2008-01-10 12:00:00	MSFT	Stock	33.98	34.5	33.96	34.13	14130203.0
2008-01-10 13:00:00	MSFT	Stock	34.129	34.17	33.78	33.95	8693310.0
2008-01-10 14:00:00	MSFT	Stock	33.95	34.4	33.94	34.2	10745556.0
2008-01-10 15:00:00	MSFT	Stock	34.21	34.44	34.14	34.32	12933472.0
2008-01-10 16:00:00	MSFT	Stock	34.33	34.44	33.99	34.19	4094530.0
2008-01-10 17:00:00	MSFT	Stock	34.18	34.32	34.18	34.32	2405.0
2008-01-10 18:00:00	MSFT	Stock	34.27	34.29	34.2	34.2	1415.0
2008-01-10 08:00:00	NVDA	Stock	0.7313	0.7313	0.7153	0.7153	279400.0
2008-01-10 09:00:00	NVDA	Stock	0.713	0.713	0.6972	0.7055	53455040.0
2008-01-10 10:00:00	NVDA	Stock	0.7052	0.7095	0.6938	0.6975	84996560.0
2008-01-10 11:00:00	NVDA	Stock	0.6972	0.7032	0.6932	0.7025	62816960.0
2008-01-10 12:00:00	NVDA	Stock	0.7025	0.7185	0.7015	0.7143	84486640.0
2008-01-10 13:00:00	NVDA	Stock	0.7143	0.7153	0.702	0.7068	68015360.0
2008-01-10 14:00:00	NVDA	Stock	0.7068	0.7125	0.702	0.7095	60329560.0
2008-01-10 15:00:00	NVDA	Stock	0.7098	0.7178	0.706	0.7072	102634120.0
2008-01-10 16:00:00	NVDA	Stock	0.7073	0.7223	0.6995	0.7078	37301520.0
2008-01-10 17:00:00	NVDA	Stock	0.7078	0.7098	0.7015	0.7098	116000.0
2008-01-10 18:00:00	NVDA	Stock	0.71	0.7125	0.71	0.7125	124000.0
2008-01-10 19:00:00	NVDA	Stock	0.7105	0.7105	0.71	0.71	12000.0
2008-01-10 08:00:00	AMZN	Stock	4.2255	4.2255	4.1825	4.2	110000.0
2008-01-10 09:00:00	AMZN	Stock	4.2	4.2215	4.1485	4.1895	18587060.0
2008-01-10 10:00:00	AMZN	Stock	4.187	4.2235	4.15	4.1805	28399820.0
2008-01-10 11:00:00	AMZN	Stock	4.1805	4.188	4.151	4.162	17366840.0
2008-01-10 12:00:00	AMZN	Stock	4.1615	4.2665	4.1525	4.248	55976660.0
2008-01-10 13:00:00	AMZN	Stock	4.2475	4.2825	4.161	4.1855	33529800.0
2008-01-10 14:00:00	AMZN	Stock	4.1875	4.244	4.1665	4.237	20734880.0
2008-01-10 15:00:00	AMZN	Stock	4.2375	4.2985	4.2075	4.214	41441480.0
2008-01-10 16:00:00	AMZN	Stock	4.214	4.261	4.183	4.1995	11525800.0
2008-01-10 17:00:00	AMZN	Stock	4.199	4.2	4.188	4.1925	24000.0
2008-01-10 18:00:00	AMZN	Stock	4.213	4.213	4.189	4.189	2802000.0

> showing 50 of 40,314 rows — these rows as CSV

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