PREVIEW / stock_1hour / 2012-10-02

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-10-02.parquet
  size:    934 KB
  rows:    44,192
  symbols: 3,469

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-10-02 04:00:00	AAPL	Stock	23.625	23.6429	23.6246	23.6429	40880.0
2012-10-02 05:00:00	AAPL	Stock	23.6943	23.7214	23.6943	23.7143	76888.0
2012-10-02 06:00:00	AAPL	Stock	23.7054	23.7318	23.7	23.7318	69580.0
2012-10-02 07:00:00	AAPL	Stock	23.7143	23.7282	23.6429	23.7121	605612.0
2012-10-02 08:00:00	AAPL	Stock	23.7007	23.7507	23.6471	23.6532	2233140.0
2012-10-02 09:00:00	AAPL	Stock	23.65	23.7225	23.5546	23.6318	78251964.0
2012-10-02 10:00:00	AAPL	Stock	23.6314	23.7982	23.5179	23.6601	89767860.0
2012-10-02 11:00:00	AAPL	Stock	23.6593	23.6921	23.4786	23.4964	73394020.0
2012-10-02 12:00:00	AAPL	Stock	23.4957	23.5493	23.4036	23.4157	64157548.0
2012-10-02 13:00:00	AAPL	Stock	23.4154	23.4868	23.3132	23.35	75632648.0
2012-10-02 14:00:00	AAPL	Stock	23.35	23.3986	23.25	23.2754	76814640.0
2012-10-02 15:00:00	AAPL	Stock	23.28	23.6571	23.2375	23.6168	154289884.0
2012-10-02 16:00:00	AAPL	Stock	23.6175	23.6554	23.4197	23.6536	5736332.0
2012-10-02 17:00:00	AAPL	Stock	23.6543	23.6929	23.6543	23.6868	621516.0
2012-10-02 18:00:00	AAPL	Stock	23.6896	23.6896	23.6182	23.6732	2273432.0
2012-10-02 19:00:00	AAPL	Stock	23.6696	23.6821	23.6618	23.6821	251944.0
2012-10-02 07:00:00	MSFT	Stock	29.53	29.64	29.53	29.64	10666.0
2012-10-02 08:00:00	MSFT	Stock	29.6	29.69	29.6	29.65	26442.0
2012-10-02 09:00:00	MSFT	Stock	29.65	29.89	29.6	29.8	5757294.0
2012-10-02 10:00:00	MSFT	Stock	29.8	29.83	29.67	29.73	8625210.0
2012-10-02 11:00:00	MSFT	Stock	29.73	29.74	29.52	29.53	4742351.0
2012-10-02 12:00:00	MSFT	Stock	29.521	29.63	29.52	29.568	3665106.0
2012-10-02 13:00:00	MSFT	Stock	29.56	29.64	29.54	29.568	2992016.0
2012-10-02 14:00:00	MSFT	Stock	29.57	29.66	29.5	29.53	4610345.0
2012-10-02 15:00:00	MSFT	Stock	29.535	29.71	29.52	29.67	8908373.0
2012-10-02 16:00:00	MSFT	Stock	29.66	29.85	29.49	29.72	1574109.0
2012-10-02 17:00:00	MSFT	Stock	29.515	29.75	29.515	29.75	9437.0
2012-10-02 18:00:00	MSFT	Stock	29.66	29.73	29.66	29.73	575040.0
2012-10-02 19:00:00	MSFT	Stock	29.72	29.77	29.72	29.77	10127.0
2012-10-02 09:00:00	NVDA	Stock	0.3293	0.3305	0.3268	0.3273	33548640.0
2012-10-02 10:00:00	NVDA	Stock	0.327	0.33	0.3255	0.3279	61214240.0
2012-10-02 11:00:00	NVDA	Stock	0.3279	0.3285	0.3255	0.3263	43092400.0
2012-10-02 12:00:00	NVDA	Stock	0.3263	0.328	0.3263	0.327	21448760.0
2012-10-02 13:00:00	NVDA	Stock	0.327	0.328	0.3263	0.327	25298440.0
2012-10-02 14:00:00	NVDA	Stock	0.327	0.3273	0.3255	0.3268	29678080.0
2012-10-02 15:00:00	NVDA	Stock	0.3268	0.3294	0.3265	0.3289	64987480.0
2012-10-02 16:00:00	NVDA	Stock	0.3293	0.3293	0.3276	0.3279	9453840.0
2012-10-02 17:00:00	NVDA	Stock	0.3279	0.3279	0.3279	0.3279	80000.0
2012-10-02 18:00:00	NVDA	Stock	0.3293	0.3293	0.3293	0.3293	1888200.0
2012-10-02 08:00:00	AMZN	Stock	12.6725	12.6745	12.6505	12.6505	20800.0
2012-10-02 09:00:00	AMZN	Stock	12.65	12.6575	12.5165	12.586	5342600.0
2012-10-02 10:00:00	AMZN	Stock	12.595	12.6	12.5175	12.5435	5970380.0
2012-10-02 11:00:00	AMZN	Stock	12.5435	12.5665	12.469	12.4825	6909060.0
2012-10-02 12:00:00	AMZN	Stock	12.4785	12.5345	12.4705	12.497	3841600.0
2012-10-02 13:00:00	AMZN	Stock	12.5022	12.537	12.4835	12.5016	4261120.0
2012-10-02 14:00:00	AMZN	Stock	12.501	12.5155	12.4535	12.4555	5468460.0
2012-10-02 15:00:00	AMZN	Stock	12.455	12.533	12.4515	12.5295	9890440.0
2012-10-02 16:00:00	AMZN	Stock	12.53	12.6005	12.5106	12.53	1514680.0
2012-10-02 18:00:00	AMZN	Stock	12.53	12.53	12.53	12.53	551160.0
2012-10-02 04:00:00	META	Stock	22.2	22.2	22.2	22.2	100.0

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

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