PREVIEW / stock_1hour / 2008-03-03

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-03-03.parquet
  size:    816 KB
  rows:    40,829
  symbols: 3,274

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-03-03 04:00:00	AAPL	Stock	4.4564	4.4564	4.44	4.44	36400.0
2008-03-03 06:00:00	AAPL	Stock	4.4518	4.4657	4.4518	4.4518	84224.0
2008-03-03 07:00:00	AAPL	Stock	4.4546	4.4639	4.4379	4.4393	273924.0
2008-03-03 08:00:00	AAPL	Stock	4.4464	4.4714	4.4436	4.465	2773484.0
2008-03-03 09:00:00	AAPL	Stock	4.4479	4.4993	4.3968	4.4068	192509408.0
2008-03-03 10:00:00	AAPL	Stock	4.4068	4.4211	4.3093	4.3175	309927576.0
2008-03-03 11:00:00	AAPL	Stock	4.3179	4.3461	4.2986	4.3436	227749144.0
2008-03-03 12:00:00	AAPL	Stock	4.3436	4.3482	4.3089	4.3196	141054144.0
2008-03-03 13:00:00	AAPL	Stock	4.32	4.3389	4.2982	4.3057	129840144.0
2008-03-03 14:00:00	AAPL	Stock	4.3057	4.3071	4.2143	4.2279	262252368.0
2008-03-03 15:00:00	AAPL	Stock	4.2279	4.3536	4.2257	4.3493	310025296.0
2008-03-03 16:00:00	AAPL	Stock	4.3496	4.3554	4.2771	4.3507	15270892.0
2008-03-03 17:00:00	AAPL	Stock	4.3504	4.355	4.3051	4.35	1120504.0
2008-03-03 18:00:00	AAPL	Stock	4.3504	4.3504	4.3214	4.3214	661276.0
2008-03-03 19:00:00	AAPL	Stock	4.325	4.3296	4.3214	4.3279	271824.0
2008-03-03 07:00:00	MSFT	Stock	27.25	27.3	27.25	27.3	3700.0
2008-03-03 08:00:00	MSFT	Stock	27.25	27.3	27.2	27.2	53888.0
2008-03-03 09:00:00	MSFT	Stock	27.22	27.32	27.02	27.27	8184344.0
2008-03-03 10:00:00	MSFT	Stock	27.26	27.39	27.15	27.19	12660554.0
2008-03-03 11:00:00	MSFT	Stock	27.2	27.31	27.11	27.27	7965407.0
2008-03-03 12:00:00	MSFT	Stock	27.27	27.372	27.16	27.182	6056493.0
2008-03-03 13:00:00	MSFT	Stock	27.182	27.22	27.07	27.15	6348360.0
2008-03-03 14:00:00	MSFT	Stock	27.14	27.26	27.07	27.09	7154519.0
2008-03-03 15:00:00	MSFT	Stock	27.09	27.14	26.87	26.99	22189740.0
2008-03-03 16:00:00	MSFT	Stock	27.0	27.174	26.96	26.99	2493866.0
2008-03-03 17:00:00	MSFT	Stock	26.98	27.154	26.97	27.02	3581207.0
2008-03-03 18:00:00	MSFT	Stock	27.02	27.02	26.85	26.9	86103.0
2008-03-03 19:00:00	MSFT	Stock	26.9	26.9	26.87	26.9	3900.0
2008-03-03 09:00:00	NVDA	Stock	0.5332	0.5365	0.528	0.5295	41637360.0
2008-03-03 10:00:00	NVDA	Stock	0.5295	0.5378	0.5268	0.5278	76553840.0
2008-03-03 11:00:00	NVDA	Stock	0.5278	0.5315	0.5225	0.5308	59534080.0
2008-03-03 12:00:00	NVDA	Stock	0.531	0.536	0.529	0.531	48182360.0
2008-03-03 13:00:00	NVDA	Stock	0.5312	0.5355	0.5302	0.5315	35899320.0
2008-03-03 14:00:00	NVDA	Stock	0.5312	0.5352	0.5215	0.5226	65451560.0
2008-03-03 15:00:00	NVDA	Stock	0.5228	0.5305	0.5225	0.5285	107957560.0
2008-03-03 16:00:00	NVDA	Stock	0.5285	0.5296	0.5272	0.529	7718400.0
2008-03-03 17:00:00	NVDA	Stock	0.5287	0.53	0.5285	0.53	831520.0
2008-03-03 18:00:00	NVDA	Stock	0.5262	0.5262	0.525	0.525	34000.0
2008-03-03 19:00:00	NVDA	Stock	0.525	0.525	0.523	0.523	66000.0
2008-03-03 08:00:00	AMZN	Stock	3.2235	3.2235	3.1765	3.2235	1087560.0
2008-03-03 09:00:00	AMZN	Stock	3.201	3.2055	3.1115	3.1625	35446920.0
2008-03-03 10:00:00	AMZN	Stock	3.162	3.2245	3.1585	3.193	41003160.0
2008-03-03 11:00:00	AMZN	Stock	3.193	3.2065	3.163	3.197	24325900.0
2008-03-03 12:00:00	AMZN	Stock	3.197	3.2015	3.15	3.1625	23952180.0
2008-03-03 13:00:00	AMZN	Stock	3.1625	3.194	3.15	3.165	25925400.0
2008-03-03 14:00:00	AMZN	Stock	3.165	3.1685	3.072	3.0819	44198740.0
2008-03-03 15:00:00	AMZN	Stock	3.083	3.124	3.06	3.1235	73514520.0
2008-03-03 16:00:00	AMZN	Stock	3.178	3.178	3.1041	3.1215	4375200.0
2008-03-03 17:00:00	AMZN	Stock	3.12	3.12	3.12	3.12	4700.0
2008-03-03 18:00:00	AMZN	Stock	3.1155	3.1155	3.1	3.1	55700.0

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

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