PREVIEW / stock_1hour / 2012-02-02

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-02-02.parquet
  size:    953 KB
  rows:    45,240
  symbols: 3,525

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
2012-02-02 05:00:00	AAPL	Stock	16.3286	16.3571	16.3214	16.3214	107128.0
2012-02-02 06:00:00	AAPL	Stock	16.3036	16.3036	16.3036	16.3036	2800.0
2012-02-02 07:00:00	AAPL	Stock	16.3196	16.3196	16.2868	16.2868	22400.0
2012-02-02 08:00:00	AAPL	Stock	16.2925	16.3161	16.2821	16.2946	572796.0
2012-02-02 09:00:00	AAPL	Stock	16.2964	16.3275	16.255	16.2593	27897856.0
2012-02-02 10:00:00	AAPL	Stock	16.2618	16.295	16.2357	16.2639	33285000.0
2012-02-02 11:00:00	AAPL	Stock	16.267	16.2746	16.2464	16.2639	18401656.0
2012-02-02 12:00:00	AAPL	Stock	16.2636	16.2721	16.2161	16.2364	28446292.0
2012-02-02 13:00:00	AAPL	Stock	16.2379	16.2457	16.2136	16.2296	18120760.0
2012-02-02 14:00:00	AAPL	Stock	16.2293	16.2493	16.2268	16.2443	16904356.0
2012-02-02 15:00:00	AAPL	Stock	16.2429	16.2593	16.2329	16.2518	30390472.0
2012-02-02 16:00:00	AAPL	Stock	16.2543	16.2602	16.2429	16.2564	7211764.0
2012-02-02 17:00:00	AAPL	Stock	16.2564	16.2925	16.2529	16.2579	87108.0
2012-02-02 18:00:00	AAPL	Stock	16.2571	16.2579	16.2439	16.25	192500.0
2012-02-02 19:00:00	AAPL	Stock	16.2504	16.2504	16.2436	16.2446	91140.0
2012-02-02 08:00:00	MSFT	Stock	29.93	29.98	29.84	29.96	13692.0
2012-02-02 09:00:00	MSFT	Stock	29.96	30.06	29.845	30.025	3711156.0
2012-02-02 10:00:00	MSFT	Stock	30.03	30.15	29.97	30.12	6951322.0
2012-02-02 11:00:00	MSFT	Stock	30.11	30.17	29.92	29.947	8619703.0
2012-02-02 12:00:00	MSFT	Stock	29.95	29.96	29.79	29.88	6578025.0
2012-02-02 13:00:00	MSFT	Stock	29.86	29.9	29.71	29.855	5430354.0
2012-02-02 14:00:00	MSFT	Stock	29.85	30.01	29.84	29.96	6978196.0
2012-02-02 15:00:00	MSFT	Stock	29.95	30.02	29.93	29.945	10596655.0
2012-02-02 16:00:00	MSFT	Stock	29.95	30.044	29.92	29.95	1761647.0
2012-02-02 17:00:00	MSFT	Stock	29.95	30.01	29.89	29.95	37398.0
2012-02-02 18:00:00	MSFT	Stock	29.94	29.95	29.94	29.94	1392.0
2012-02-02 19:00:00	MSFT	Stock	29.99	29.99	29.95	29.95	1615.0
2012-02-02 08:00:00	NVDA	Stock	0.375	0.375	0.375	0.375	28000.0
2012-02-02 09:00:00	NVDA	Stock	0.375	0.3768	0.3715	0.3763	51007240.0
2012-02-02 10:00:00	NVDA	Stock	0.3765	0.385	0.3764	0.3842	104287000.0
2012-02-02 11:00:00	NVDA	Stock	0.3842	0.3842	0.3778	0.378	57838640.0
2012-02-02 12:00:00	NVDA	Stock	0.378	0.38	0.377	0.3793	98512120.0
2012-02-02 13:00:00	NVDA	Stock	0.379	0.3828	0.3783	0.3828	74563760.0
2012-02-02 14:00:00	NVDA	Stock	0.3828	0.387	0.3825	0.3868	114749400.0
2012-02-02 15:00:00	NVDA	Stock	0.3869	0.3888	0.3862	0.3871	175373040.0
2012-02-02 16:00:00	NVDA	Stock	0.3875	0.3888	0.3817	0.3817	2929000.0
2012-02-02 17:00:00	NVDA	Stock	0.387	0.387	0.387	0.387	8000.0
2012-02-02 18:00:00	NVDA	Stock	0.387	0.3893	0.387	0.3893	196000.0
2012-02-02 19:00:00	NVDA	Stock	0.3875	0.3875	0.3875	0.3875	40000.0
2012-02-02 04:00:00	AMZN	Stock	9.006	9.018	9.004	9.015	8000.0
2012-02-02 05:00:00	AMZN	Stock	9.0375	9.0375	9.0375	9.0375	2000.0
2012-02-02 06:00:00	AMZN	Stock	9.028	9.028	9.0125	9.0125	4000.0
2012-02-02 07:00:00	AMZN	Stock	9.0285	9.0285	8.9635	8.9875	103860.0
2012-02-02 08:00:00	AMZN	Stock	9.0	9.0	8.9565	8.974	303480.0
2012-02-02 09:00:00	AMZN	Stock	8.9815	9.005	8.8635	8.8975	26618660.0
2012-02-02 10:00:00	AMZN	Stock	8.8976	8.9084	8.84	8.861	30465400.0
2012-02-02 11:00:00	AMZN	Stock	8.8599	8.931	8.8565	8.913	25773760.0
2012-02-02 12:00:00	AMZN	Stock	8.9145	8.923	8.8695	8.9064	15061720.0
2012-02-02 13:00:00	AMZN	Stock	8.9055	8.9395	8.8805	8.9346	13539540.0
2012-02-02 14:00:00	AMZN	Stock	8.9342	9.0205	8.9315	9.015	24936540.0

> showing 50 of 45,240 rows — these rows as CSV

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