PREVIEW / stock_1hour / 2011-12-14

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-12-14.parquet
  size:    934 KB
  rows:    44,899
  symbols: 3,530

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
2011-12-14 04:00:00	AAPL	Stock	13.9054	13.9054	13.9004	13.9014	16800.0
2011-12-14 05:00:00	AAPL	Stock	13.9146	13.9146	13.9146	13.9146	2800.0
2011-12-14 06:00:00	AAPL	Stock	13.8929	13.8929	13.8821	13.8857	35000.0
2011-12-14 07:00:00	AAPL	Stock	13.8536	13.9039	13.85	13.8754	79100.0
2011-12-14 08:00:00	AAPL	Stock	13.8768	13.9443	13.875	13.9021	1216964.0
2011-12-14 09:00:00	AAPL	Stock	13.9021	13.9021	13.6539	13.7098	82053020.0
2011-12-14 10:00:00	AAPL	Stock	13.7057	13.7111	13.5943	13.6107	75876332.0
2011-12-14 11:00:00	AAPL	Stock	13.6076	13.6339	13.4886	13.5214	57560888.0
2011-12-14 12:00:00	AAPL	Stock	13.5225	13.5804	13.5036	13.5537	39260004.0
2011-12-14 13:00:00	AAPL	Stock	13.5582	13.6214	13.5545	13.5611	35180348.0
2011-12-14 14:00:00	AAPL	Stock	13.5618	13.5893	13.5268	13.5321	33169164.0
2011-12-14 15:00:00	AAPL	Stock	13.5343	13.6071	13.5086	13.5725	61636064.0
2011-12-14 16:00:00	AAPL	Stock	13.5743	13.6155	13.5697	13.5732	16889768.0
2011-12-14 17:00:00	AAPL	Stock	13.5732	13.5782	13.5554	13.5611	1269828.0
2011-12-14 18:00:00	AAPL	Stock	13.5632	13.5782	13.5346	13.5357	261716.0
2011-12-14 19:00:00	AAPL	Stock	13.5357	13.5571	13.5354	13.5393	149268.0
2011-12-14 08:00:00	MSFT	Stock	25.73	25.79	25.67	25.71	6538.0
2011-12-14 09:00:00	MSFT	Stock	25.66	25.86	25.61	25.83	5252462.0
2011-12-14 10:00:00	MSFT	Stock	25.82	25.83	25.61	25.625	7812722.0
2011-12-14 11:00:00	MSFT	Stock	25.62	25.7	25.57	25.67	6513549.0
2011-12-14 12:00:00	MSFT	Stock	25.67	25.72	25.62	25.638	4493745.0
2011-12-14 13:00:00	MSFT	Stock	25.64	25.74	25.62	25.645	4361735.0
2011-12-14 14:00:00	MSFT	Stock	25.64	25.69	25.57	25.605	5810113.0
2011-12-14 15:00:00	MSFT	Stock	25.6	25.72	25.57	25.58	9794395.0
2011-12-14 16:00:00	MSFT	Stock	25.59	25.76	25.57	25.65	2530150.0
2011-12-14 17:00:00	MSFT	Stock	25.6	25.6	25.59	25.6	323806.0
2011-12-14 18:00:00	MSFT	Stock	25.59	25.6	25.56	25.6	16760.0
2011-12-14 19:00:00	MSFT	Stock	25.57	25.57	25.57	25.57	371.0
2011-12-14 05:00:00	NVDA	Stock	0.3675	0.3675	0.3625	0.3625	8000.0
2011-12-14 07:00:00	NVDA	Stock	0.3533	0.3575	0.3533	0.3575	8000.0
2011-12-14 08:00:00	NVDA	Stock	0.353	0.353	0.353	0.353	4000.0
2011-12-14 09:00:00	NVDA	Stock	0.3538	0.3538	0.3413	0.3433	82387560.0
2011-12-14 10:00:00	NVDA	Stock	0.3433	0.3433	0.3375	0.3385	114657080.0
2011-12-14 11:00:00	NVDA	Stock	0.3385	0.3408	0.3358	0.3373	87730760.0
2011-12-14 12:00:00	NVDA	Stock	0.337	0.3441	0.3368	0.3428	80353960.0
2011-12-14 13:00:00	NVDA	Stock	0.343	0.346	0.3418	0.342	57883000.0
2011-12-14 14:00:00	NVDA	Stock	0.3421	0.3428	0.3388	0.3396	76340080.0
2011-12-14 15:00:00	NVDA	Stock	0.3396	0.3415	0.3385	0.3395	114779360.0
2011-12-14 16:00:00	NVDA	Stock	0.3398	0.3416	0.3395	0.3405	2578520.0
2011-12-14 17:00:00	NVDA	Stock	0.3405	0.3475	0.3395	0.3475	1022880.0
2011-12-14 18:00:00	NVDA	Stock	0.3413	0.3413	0.3413	0.3413	48000.0
2011-12-14 19:00:00	NVDA	Stock	0.3413	0.3413	0.3413	0.3413	12000.0
2011-12-14 07:00:00	AMZN	Stock	8.9545	9.0	8.9545	9.0	20000.0
2011-12-14 08:00:00	AMZN	Stock	9.0015	9.0015	8.933	8.935	323440.0
2011-12-14 09:00:00	AMZN	Stock	8.9325	8.975	8.83	8.8896	21277200.0
2011-12-14 10:00:00	AMZN	Stock	8.8915	8.904	8.7	8.7026	37530340.0
2011-12-14 11:00:00	AMZN	Stock	8.7069	8.7194	8.5125	8.6165	49063160.0
2011-12-14 12:00:00	AMZN	Stock	8.615	8.785	8.601	8.7686	28134680.0
2011-12-14 13:00:00	AMZN	Stock	8.771	8.8795	8.739	8.8625	24071700.0
2011-12-14 14:00:00	AMZN	Stock	8.8615	8.906	8.797	8.8635	19302180.0

> showing 50 of 44,899 rows — these rows as CSV

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