PREVIEW / stock_1hour / 2008-03-04

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-03-04.parquet
  size:    822 KB
  rows:    41,125
  symbols: 3,281

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-04 04:00:00	AAPL	Stock	4.3436	4.3436	4.3436	4.3436	8400.0
2008-03-04 05:00:00	AAPL	Stock	4.3393	4.3393	4.3039	4.3039	72800.0
2008-03-04 06:00:00	AAPL	Stock	4.305	4.305	4.2857	4.2857	86632.0
2008-03-04 07:00:00	AAPL	Stock	4.2861	4.3182	4.2857	4.3171	178948.0
2008-03-04 08:00:00	AAPL	Stock	4.3082	4.3389	4.2911	4.3357	3665340.0
2008-03-04 09:00:00	AAPL	Stock	4.3357	4.385	4.3	4.3493	224330148.0
2008-03-04 10:00:00	AAPL	Stock	4.3493	4.385	4.3245	4.3541	239069488.0
2008-03-04 11:00:00	AAPL	Stock	4.3529	4.3761	4.3321	4.3648	144725364.0
2008-03-04 12:00:00	AAPL	Stock	4.3625	4.4386	4.3571	4.3832	194504212.0
2008-03-04 13:00:00	AAPL	Stock	4.3839	4.4568	4.3275	4.34	296762004.0
2008-03-04 14:00:00	AAPL	Stock	4.3407	4.3825	4.3082	4.3714	307160560.0
2008-03-04 15:00:00	AAPL	Stock	4.3711	4.46	4.3604	4.4507	352756964.0
2008-03-04 16:00:00	AAPL	Stock	4.4504	4.4509	4.3475	4.4471	23415168.0
2008-03-04 17:00:00	AAPL	Stock	4.4461	4.4507	4.3974	4.4429	528500.0
2008-03-04 18:00:00	AAPL	Stock	4.4446	4.4496	4.4429	4.4471	233016.0
2008-03-04 19:00:00	AAPL	Stock	4.4482	4.4496	4.4393	4.4496	244748.0
2008-03-04 06:00:00	MSFT	Stock	26.88	26.88	26.88	26.88	1400.0
2008-03-04 07:00:00	MSFT	Stock	26.85	26.9	26.81	26.9	11300.0
2008-03-04 08:00:00	MSFT	Stock	26.9	26.95	26.8	26.9	31075.0
2008-03-04 09:00:00	MSFT	Stock	26.86	27.24	26.85	27.17	9094537.0
2008-03-04 10:00:00	MSFT	Stock	27.18	27.32	27.13	27.14	14374878.0
2008-03-04 11:00:00	MSFT	Stock	27.14	27.2	27.03	27.06	6736071.0
2008-03-04 12:00:00	MSFT	Stock	27.05	27.13	26.99	27.03	8996793.0
2008-03-04 13:00:00	MSFT	Stock	27.03	27.15	26.96	27.05	7804024.0
2008-03-04 14:00:00	MSFT	Stock	27.05	27.2	27.0	27.15	10230430.0
2008-03-04 15:00:00	MSFT	Stock	27.14	27.63	27.11	27.56	24942651.0
2008-03-04 16:00:00	MSFT	Stock	27.56	27.6	26.99	27.48	4534927.0
2008-03-04 17:00:00	MSFT	Stock	27.59	27.59	27.176	27.45	366257.0
2008-03-04 18:00:00	MSFT	Stock	27.47	27.47	27.46	27.47	13100.0
2008-03-04 19:00:00	MSFT	Stock	27.48	27.48	27.47	27.48	8940.0
2008-03-04 07:00:00	NVDA	Stock	0.5287	0.5287	0.5262	0.5275	100000.0
2008-03-04 08:00:00	NVDA	Stock	0.5262	0.5262	0.522	0.522	579760.0
2008-03-04 09:00:00	NVDA	Stock	0.522	0.526	0.5192	0.5222	49970360.0
2008-03-04 10:00:00	NVDA	Stock	0.522	0.5225	0.5072	0.5075	141107000.0
2008-03-04 11:00:00	NVDA	Stock	0.5075	0.5115	0.5028	0.5078	85315840.0
2008-03-04 12:00:00	NVDA	Stock	0.5078	0.5152	0.507	0.5138	68675640.0
2008-03-04 13:00:00	NVDA	Stock	0.5138	0.5173	0.5112	0.5125	85646880.0
2008-03-04 14:00:00	NVDA	Stock	0.5128	0.5173	0.5112	0.5142	84346240.0
2008-03-04 15:00:00	NVDA	Stock	0.5142	0.5258	0.513	0.5232	192287320.0
2008-03-04 16:00:00	NVDA	Stock	0.523	0.5285	0.5159	0.5232	76166160.0
2008-03-04 17:00:00	NVDA	Stock	0.522	0.5232	0.5207	0.5207	276400.0
2008-03-04 08:00:00	AMZN	Stock	3.1	3.1065	3.075	3.0825	151180.0
2008-03-04 09:00:00	AMZN	Stock	3.0845	3.143	3.07	3.111	27168860.0
2008-03-04 10:00:00	AMZN	Stock	3.11	3.11	3.0615	3.0705	35345960.0
2008-03-04 11:00:00	AMZN	Stock	3.071	3.219	3.0665	3.19	78335640.0
2008-03-04 12:00:00	AMZN	Stock	3.188	3.235	3.172	3.1935	36524000.0
2008-03-04 13:00:00	AMZN	Stock	3.1935	3.224	3.185	3.1855	22897020.0
2008-03-04 14:00:00	AMZN	Stock	3.1855	3.23	3.156	3.2285	37065840.0
2008-03-04 15:00:00	AMZN	Stock	3.2285	3.33	3.2215	3.2665	89250280.0
2008-03-04 16:00:00	AMZN	Stock	3.267	3.2775	3.1215	3.249	7970480.0

> showing 50 of 41,125 rows — these rows as CSV

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