PREVIEW / stock_1hour / 2012-01-24

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-01-24.parquet
  size:    928 KB
  rows:    44,194
  symbols: 3,522

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-01-24 04:00:00	AAPL	Stock	15.2679	15.2679	15.2354	15.2496	39200.0
2012-01-24 05:00:00	AAPL	Stock	15.2432	15.2432	15.2143	15.2143	16800.0
2012-01-24 06:00:00	AAPL	Stock	15.1964	15.2232	15.1964	15.2	28840.0
2012-01-24 07:00:00	AAPL	Stock	15.2143	15.2311	15.1964	15.1964	310184.0
2012-01-24 08:00:00	AAPL	Stock	15.2032	15.23	15.1671	15.1857	2323804.0
2012-01-24 09:00:00	AAPL	Stock	15.1861	15.1911	15.1129	15.1389	47843796.0
2012-01-24 10:00:00	AAPL	Stock	15.1386	15.1786	15.1171	15.1436	43585472.0
2012-01-24 11:00:00	AAPL	Stock	15.1458	15.15	15.1093	15.1286	34468448.0
2012-01-24 12:00:00	AAPL	Stock	15.1275	15.1536	15.125	15.1393	26812632.0
2012-01-24 13:00:00	AAPL	Stock	15.1396	15.1404	15.0307	15.0761	54644408.0
2012-01-24 14:00:00	AAPL	Stock	15.0761	15.1139	15.0579	15.0725	43247904.0
2012-01-24 15:00:00	AAPL	Stock	15.0714	15.0893	14.9839	15.018	100240756.0
2012-01-24 16:00:00	AAPL	Stock	15.0161	16.7482	14.9643	16.1968	89885572.0
2012-01-24 17:00:00	AAPL	Stock	16.1996	16.2504	15.0179	16.2143	63503692.0
2012-01-24 18:00:00	AAPL	Stock	16.2143	16.2232	16.1429	16.145	13874392.0
2012-01-24 19:00:00	AAPL	Stock	16.1446	16.1564	16.1071	16.11	5059656.0
2012-01-24 07:00:00	MSFT	Stock	29.54	29.54	29.5	29.5	2200.0
2012-01-24 08:00:00	MSFT	Stock	29.57	29.58	29.51	29.52	29602.0
2012-01-24 09:00:00	MSFT	Stock	29.51	29.73	29.29	29.46	7587040.0
2012-01-24 10:00:00	MSFT	Stock	29.46	29.53	29.4	29.456	7895540.0
2012-01-24 11:00:00	MSFT	Stock	29.455	29.47	29.3	29.355	6766642.0
2012-01-24 12:00:00	MSFT	Stock	29.36	29.41	29.22	29.3	6010664.0
2012-01-24 13:00:00	MSFT	Stock	29.3	29.31	29.18	29.29	4739143.0
2012-01-24 14:00:00	MSFT	Stock	29.29	29.38	29.26	29.355	5741461.0
2012-01-24 15:00:00	MSFT	Stock	29.36	29.39	29.28	29.34	9764196.0
2012-01-24 16:00:00	MSFT	Stock	29.335	29.569	29.29	29.41	418635.0
2012-01-24 17:00:00	MSFT	Stock	29.45	29.51	29.35	29.49	51299.0
2012-01-24 18:00:00	MSFT	Stock	29.47	29.59	29.46	29.53	27637.0
2012-01-24 19:00:00	MSFT	Stock	29.53	29.53	29.46	29.46	3371.0
2012-01-24 08:00:00	NVDA	Stock	0.3675	0.3675	0.3625	0.3625	664000.0
2012-01-24 09:00:00	NVDA	Stock	0.3625	0.3672	0.3602	0.3665	58525080.0
2012-01-24 10:00:00	NVDA	Stock	0.3665	0.375	0.3665	0.3706	209679760.0
2012-01-24 11:00:00	NVDA	Stock	0.3708	0.3743	0.3705	0.3715	72369320.0
2012-01-24 12:00:00	NVDA	Stock	0.3714	0.3728	0.3705	0.371	43441560.0
2012-01-24 13:00:00	NVDA	Stock	0.3708	0.3745	0.3703	0.3743	65012960.0
2012-01-24 14:00:00	NVDA	Stock	0.3743	0.3745	0.3725	0.374	60963080.0
2012-01-24 15:00:00	NVDA	Stock	0.3743	0.375	0.3725	0.3735	152749200.0
2012-01-24 16:00:00	NVDA	Stock	0.3735	0.378	0.3703	0.3765	8815760.0
2012-01-24 17:00:00	NVDA	Stock	0.3765	0.378	0.3733	0.378	470920.0
2012-01-24 18:00:00	NVDA	Stock	0.376	0.376	0.3525	0.3638	8899800.0
2012-01-24 19:00:00	NVDA	Stock	0.363	0.365	0.3588	0.3588	2395080.0
2012-01-24 06:00:00	AMZN	Stock	9.2625	9.2625	9.2625	9.2625	10000.0
2012-01-24 07:00:00	AMZN	Stock	9.25	9.2935	9.25	9.25	14000.0
2012-01-24 08:00:00	AMZN	Stock	9.2515	9.2515	9.23	9.232	62020.0
2012-01-24 09:00:00	AMZN	Stock	9.2315	9.2865	9.191	9.229	12541560.0
2012-01-24 10:00:00	AMZN	Stock	9.229	9.4205	9.2105	9.3985	24937160.0
2012-01-24 11:00:00	AMZN	Stock	9.397	9.4	9.32	9.3385	13697780.0
2012-01-24 12:00:00	AMZN	Stock	9.3425	9.3744	9.3325	9.3525	6426200.0
2012-01-24 13:00:00	AMZN	Stock	9.352	9.3545	9.2545	9.281	9403300.0
2012-01-24 14:00:00	AMZN	Stock	9.2825	9.3555	9.2805	9.35	8164040.0

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

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