PREVIEW / stock_1hour / 2011-12-16

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-12-16.parquet
  size:    955 KB
  rows:    44,829
  symbols: 3,542

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-16 04:00:00	AAPL	Stock	13.5804	13.5804	13.5804	13.5804	2800.0
2011-12-16 05:00:00	AAPL	Stock	13.6225	13.6225	13.6225	13.6225	2800.0
2011-12-16 07:00:00	AAPL	Stock	13.5982	13.6179	13.5964	13.5964	112420.0
2011-12-16 08:00:00	AAPL	Stock	13.6071	13.6071	13.5768	13.5857	528192.0
2011-12-16 09:00:00	AAPL	Stock	13.5929	13.6211	13.5561	13.5889	86492560.0
2011-12-16 10:00:00	AAPL	Stock	13.5918	13.7196	13.5714	13.6786	70232904.0
2011-12-16 11:00:00	AAPL	Stock	13.6761	13.68	13.6004	13.6032	41627404.0
2011-12-16 12:00:00	AAPL	Stock	13.6029	13.6189	13.5618	13.5921	43076684.0
2011-12-16 13:00:00	AAPL	Stock	13.593	13.6143	13.5864	13.5893	24147452.0
2011-12-16 14:00:00	AAPL	Stock	13.5921	13.5979	13.5664	13.5825	24153528.0
2011-12-16 15:00:00	AAPL	Stock	13.5836	13.5964	13.5714	13.5961	51686880.0
2011-12-16 16:00:00	AAPL	Stock	13.5918	13.6218	13.5336	13.6078	54878180.0
2011-12-16 17:00:00	AAPL	Stock	13.6018	13.6432	13.6018	13.6321	6904408.0
2011-12-16 18:00:00	AAPL	Stock	13.6079	13.6382	13.6079	13.6268	38920.0
2011-12-16 19:00:00	AAPL	Stock	13.6214	13.6371	13.615	13.6371	67312.0
2011-12-16 07:00:00	MSFT	Stock	25.73	25.73	25.73	25.73	400.0
2011-12-16 08:00:00	MSFT	Stock	25.66	25.81	25.66	25.71	16336.0
2011-12-16 09:00:00	MSFT	Stock	25.7	25.94	25.63	25.93	21597215.0
2011-12-16 10:00:00	MSFT	Stock	25.93	26.17	25.894	26.1	11922815.0
2011-12-16 11:00:00	MSFT	Stock	26.108	26.14	25.9	25.93	8891440.0
2011-12-16 12:00:00	MSFT	Stock	25.93	25.99	25.85	25.95	7956939.0
2011-12-16 13:00:00	MSFT	Stock	25.95	26.08	25.931	25.985	7393498.0
2011-12-16 14:00:00	MSFT	Stock	25.99	26.02	25.925	25.944	4488880.0
2011-12-16 15:00:00	MSFT	Stock	25.94	26.03	25.9	25.98	13817163.0
2011-12-16 16:00:00	MSFT	Stock	25.975	26.1	25.56	25.999	15309021.0
2011-12-16 17:00:00	MSFT	Stock	26.0	26.03	25.98	25.98	1838570.0
2011-12-16 18:00:00	MSFT	Stock	26.0	26.0	25.98	25.98	134200.0
2011-12-16 19:00:00	MSFT	Stock	25.98	25.98	25.97	25.97	2000.0
2011-12-16 08:00:00	NVDA	Stock	0.34	0.3438	0.3398	0.3425	164000.0
2011-12-16 09:00:00	NVDA	Stock	0.34	0.3435	0.338	0.3418	99083200.0
2011-12-16 10:00:00	NVDA	Stock	0.342	0.3458	0.3419	0.3453	78449680.0
2011-12-16 11:00:00	NVDA	Stock	0.3453	0.3455	0.3398	0.34	47694200.0
2011-12-16 12:00:00	NVDA	Stock	0.3398	0.3408	0.3362	0.3364	80916360.0
2011-12-16 13:00:00	NVDA	Stock	0.3362	0.3395	0.3362	0.3375	48357400.0
2011-12-16 14:00:00	NVDA	Stock	0.3378	0.3388	0.3368	0.3375	57132080.0
2011-12-16 15:00:00	NVDA	Stock	0.3375	0.339	0.337	0.338	118935520.0
2011-12-16 16:00:00	NVDA	Stock	0.3378	0.3402	0.3376	0.3377	68065280.0
2011-12-16 17:00:00	NVDA	Stock	0.3402	0.3402	0.3378	0.34	6258640.0
2011-12-16 18:00:00	NVDA	Stock	0.3405	0.3405	0.34	0.3402	45200.0
2011-12-16 19:00:00	NVDA	Stock	0.3398	0.3398	0.3398	0.3398	25880.0
2011-12-16 07:00:00	AMZN	Stock	9.1105	9.13	9.1105	9.13	5140.0
2011-12-16 08:00:00	AMZN	Stock	9.116	9.15	9.1	9.15	260820.0
2011-12-16 09:00:00	AMZN	Stock	9.125	9.1685	9.065	9.1555	29124540.0
2011-12-16 10:00:00	AMZN	Stock	9.1625	9.2205	9.1458	9.2025	15248680.0
2011-12-16 11:00:00	AMZN	Stock	9.206	9.211	9.145	9.1589	13318620.0
2011-12-16 12:00:00	AMZN	Stock	9.1575	9.1645	9.095	9.113	11453760.0
2011-12-16 13:00:00	AMZN	Stock	9.111	9.18	9.11	9.1311	8761320.0
2011-12-16 14:00:00	AMZN	Stock	9.1315	9.159	9.1025	9.1045	6706740.0
2011-12-16 15:00:00	AMZN	Stock	9.102	9.1205	9.0155	9.063	29251480.0
2011-12-16 16:00:00	AMZN	Stock	9.0626	9.1752	9.0405	9.063	15216240.0

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

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