PREVIEW / stock_1hour / 2011-02-22

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-02-22.parquet
  size:    996 KB
  rows:    48,034
  symbols: 3,545

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-02-22 04:00:00	AAPL	Stock	12.4286	12.4286	12.2896	12.3929	456008.0
2011-02-22 05:00:00	AAPL	Stock	12.3668	12.3857	12.3661	12.3857	41076.0
2011-02-22 06:00:00	AAPL	Stock	12.3886	12.3886	12.3579	12.3579	61516.0
2011-02-22 07:00:00	AAPL	Stock	12.3468	12.3732	12.3214	12.3643	665224.0
2011-02-22 08:00:00	AAPL	Stock	12.3504	12.3614	12.2357	12.2971	5654320.0
2011-02-22 09:00:00	AAPL	Stock	12.3	12.3004	12.0714	12.2168	207315360.0
2011-02-22 10:00:00	AAPL	Stock	12.2221	12.3357	12.1821	12.2771	139410684.0
2011-02-22 11:00:00	AAPL	Stock	12.2742	12.2807	12.1661	12.2189	116696440.0
2011-02-22 12:00:00	AAPL	Stock	12.2199	12.2446	12.1121	12.1257	78448972.0
2011-02-22 13:00:00	AAPL	Stock	12.1261	12.1893	12.1	12.1482	82970104.0
2011-02-22 14:00:00	AAPL	Stock	12.1471	12.1964	12.1354	12.1432	65303056.0
2011-02-22 15:00:00	AAPL	Stock	12.1421	12.1517	12.0614	12.0957	129801420.0
2011-02-22 16:00:00	AAPL	Stock	12.0961	12.1803	12.0688	12.0814	24889340.0
2011-02-22 17:00:00	AAPL	Stock	12.0814	12.2294	12.0268	12.0375	1472548.0
2011-02-22 18:00:00	AAPL	Stock	12.0357	12.0932	11.9729	12.0179	991004.0
2011-02-22 19:00:00	AAPL	Stock	12.0232	12.0393	12.0	12.0161	796544.0
2011-02-22 05:00:00	MSFT	Stock	26.91	26.91	26.77	26.77	2800.0
2011-02-22 07:00:00	MSFT	Stock	26.82	26.82	26.78	26.78	6856.0
2011-02-22 08:00:00	MSFT	Stock	26.85	26.9	26.78	26.88	46420.0
2011-02-22 09:00:00	MSFT	Stock	26.9	26.95	26.68	26.92	9125872.0
2011-02-22 10:00:00	MSFT	Stock	26.92	27.1	26.85	27.03	7640317.0
2011-02-22 11:00:00	MSFT	Stock	27.03	27.03	26.73	26.76	7704244.0
2011-02-22 12:00:00	MSFT	Stock	26.76	26.77	26.58	26.615	9599882.0
2011-02-22 13:00:00	MSFT	Stock	26.61	26.76	26.59	26.69	6608808.0
2011-02-22 14:00:00	MSFT	Stock	26.7	26.77	26.61	26.7	5766302.0
2011-02-22 15:00:00	MSFT	Stock	26.709	26.71	26.52	26.57	10379583.0
2011-02-22 16:00:00	MSFT	Stock	26.58	27.1	26.44	26.47	2901006.0
2011-02-22 17:00:00	MSFT	Stock	26.48	26.59	26.44	26.45	100414.0
2011-02-22 18:00:00	MSFT	Stock	26.59	26.59	26.44	26.51	21135.0
2011-02-22 19:00:00	MSFT	Stock	26.51	26.55	26.51	26.54	47826.0
2011-02-22 05:00:00	NVDA	Stock	0.6248	0.6248	0.6248	0.6248	8000.0
2011-02-22 06:00:00	NVDA	Stock	0.6248	0.6248	0.6195	0.6195	42000.0
2011-02-22 07:00:00	NVDA	Stock	0.62	0.6295	0.62	0.6225	178000.0
2011-02-22 08:00:00	NVDA	Stock	0.6293	0.6293	0.6225	0.6275	1789800.0
2011-02-22 09:00:00	NVDA	Stock	0.6285	0.63	0.6005	0.6162	272367080.0
2011-02-22 10:00:00	NVDA	Stock	0.6165	0.6168	0.6068	0.6093	196269960.0
2011-02-22 11:00:00	NVDA	Stock	0.6095	0.6095	0.5948	0.5976	237244800.0
2011-02-22 12:00:00	NVDA	Stock	0.5975	0.5985	0.5863	0.5885	179693440.0
2011-02-22 13:00:00	NVDA	Stock	0.5885	0.5903	0.5843	0.5898	130103200.0
2011-02-22 14:00:00	NVDA	Stock	0.5895	0.5925	0.5883	0.5893	119743320.0
2011-02-22 15:00:00	NVDA	Stock	0.5893	0.5895	0.5782	0.5805	228009400.0
2011-02-22 16:00:00	NVDA	Stock	0.5808	0.5975	0.5788	0.5825	5079440.0
2011-02-22 17:00:00	NVDA	Stock	0.5825	0.5838	0.5815	0.5825	2016240.0
2011-02-22 18:00:00	NVDA	Stock	0.5818	0.5832	0.579	0.5792	1107240.0
2011-02-22 19:00:00	NVDA	Stock	0.5792	0.5805	0.579	0.579	473360.0
2011-02-22 05:00:00	AMZN	Stock	9.2825	9.2825	9.2725	9.2725	4000.0
2011-02-22 06:00:00	AMZN	Stock	9.2275	9.2275	9.2275	9.2275	2000.0
2011-02-22 07:00:00	AMZN	Stock	9.25	9.25	9.2005	9.2345	40940.0
2011-02-22 08:00:00	AMZN	Stock	9.2395	9.3145	9.225	9.2485	175520.0
2011-02-22 09:00:00	AMZN	Stock	9.2625	9.2625	9.0625	9.147	16161840.0

> showing 50 of 48,034 rows — these rows as CSV

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