PREVIEW / stock_1hour / 2012-02-13

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-02-13.parquet
  size:    977 KB
  rows:    45,957
  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
2012-02-13 04:00:00	AAPL	Stock	17.6139	17.8479	17.6139	17.8321	115248.0
2012-02-13 05:00:00	AAPL	Stock	17.8268	17.8321	17.8132	17.8286	152292.0
2012-02-13 06:00:00	AAPL	Stock	17.8286	17.8393	17.8214	17.8321	123620.0
2012-02-13 07:00:00	AAPL	Stock	17.8214	17.8375	17.8036	17.8211	1650264.0
2012-02-13 08:00:00	AAPL	Stock	17.8211	17.855	17.7968	17.8446	7101696.0
2012-02-13 09:00:00	AAPL	Stock	17.8439	17.9939	17.8179	17.8611	142716420.0
2012-02-13 10:00:00	AAPL	Stock	17.8632	17.9196	17.7939	17.855	94854760.0
2012-02-13 11:00:00	AAPL	Stock	17.8561	17.8786	17.825	17.847	40024096.0
2012-02-13 12:00:00	AAPL	Stock	17.8489	17.8525	17.7532	17.827	45136168.0
2012-02-13 13:00:00	AAPL	Stock	17.8271	17.885	17.8207	17.8675	32434444.0
2012-02-13 14:00:00	AAPL	Stock	17.8679	17.9239	17.8596	17.8975	47206516.0
2012-02-13 15:00:00	AAPL	Stock	17.8968	17.95	17.8697	17.9493	74819500.0
2012-02-13 16:00:00	AAPL	Stock	17.95	17.9889	17.7889	17.9839	17356528.0
2012-02-13 17:00:00	AAPL	Stock	17.9825	17.9846	17.836	17.9571	1727152.0
2012-02-13 18:00:00	AAPL	Stock	17.9571	17.9657	17.9111	17.9657	673036.0
2012-02-13 19:00:00	AAPL	Stock	17.9536	17.9714	17.9518	17.9571	341180.0
2012-02-13 05:00:00	MSFT	Stock	30.68	30.68	30.66	30.66	1300.0
2012-02-13 06:00:00	MSFT	Stock	30.66	30.66	30.66	30.66	4800.0
2012-02-13 07:00:00	MSFT	Stock	30.61	30.68	30.61	30.68	1356.0
2012-02-13 08:00:00	MSFT	Stock	30.65	30.69	30.55	30.62	37675.0
2012-02-13 09:00:00	MSFT	Stock	30.65	30.77	30.485	30.745	5106183.0
2012-02-13 10:00:00	MSFT	Stock	30.74	30.745	30.43	30.495	6273361.0
2012-02-13 11:00:00	MSFT	Stock	30.495	30.59	30.48	30.56	4228075.0
2012-02-13 12:00:00	MSFT	Stock	30.554	30.6	30.53	30.59	2471205.0
2012-02-13 13:00:00	MSFT	Stock	30.585	30.62	30.55	30.611	2749845.0
2012-02-13 14:00:00	MSFT	Stock	30.611	30.71	30.6	30.67	3236000.0
2012-02-13 15:00:00	MSFT	Stock	30.67	30.68	30.55	30.56	6452163.0
2012-02-13 16:00:00	MSFT	Stock	30.555	30.67	30.5	30.6	1220076.0
2012-02-13 17:00:00	MSFT	Stock	30.6	30.62	30.55	30.6	143185.0
2012-02-13 18:00:00	MSFT	Stock	30.58	30.58	30.55	30.55	4143.0
2012-02-13 19:00:00	MSFT	Stock	30.56	30.56	30.56	30.56	2800.0
2012-02-13 07:00:00	NVDA	Stock	0.4075	0.4098	0.4075	0.4098	77000.0
2012-02-13 08:00:00	NVDA	Stock	0.4088	0.4122	0.4058	0.4075	1402200.0
2012-02-13 09:00:00	NVDA	Stock	0.4072	0.409	0.3995	0.4005	75880440.0
2012-02-13 10:00:00	NVDA	Stock	0.4005	0.4018	0.3955	0.3982	93632040.0
2012-02-13 11:00:00	NVDA	Stock	0.3982	0.4	0.3968	0.3992	57400040.0
2012-02-13 12:00:00	NVDA	Stock	0.3992	0.4038	0.399	0.4035	90895440.0
2012-02-13 13:00:00	NVDA	Stock	0.4032	0.4062	0.4032	0.4048	104370400.0
2012-02-13 14:00:00	NVDA	Stock	0.4048	0.405	0.4032	0.4032	59105200.0
2012-02-13 15:00:00	NVDA	Stock	0.4035	0.4055	0.403	0.404	104474560.0
2012-02-13 16:00:00	NVDA	Stock	0.4038	0.4048	0.3973	0.4038	9613680.0
2012-02-13 17:00:00	NVDA	Stock	0.3985	0.4053	0.3985	0.4053	492920.0
2012-02-13 18:00:00	NVDA	Stock	0.4048	0.4048	0.4048	0.4048	109040.0
2012-02-13 19:00:00	NVDA	Stock	0.405	0.405	0.4048	0.4048	105600.0
2012-02-13 06:00:00	AMZN	Stock	9.307	9.359	9.303	9.359	18000.0
2012-02-13 07:00:00	AMZN	Stock	9.3705	9.375	9.35	9.375	51000.0
2012-02-13 08:00:00	AMZN	Stock	9.358	9.3755	9.35	9.35	176940.0
2012-02-13 09:00:00	AMZN	Stock	9.35	9.4665	9.284	9.45	18451560.0
2012-02-13 10:00:00	AMZN	Stock	9.45	9.497	9.4204	9.4935	22635340.0
2012-02-13 11:00:00	AMZN	Stock	9.494	9.553	9.4675	9.5335	17619460.0

> showing 50 of 45,957 rows — these rows as CSV

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