PREVIEW / stock_1hour / 2011-08-15

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-08-15.parquet
  size:    934 KB
  rows:    44,432
  symbols: 3,547

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-08-15 04:00:00	AAPL	Stock	13.5714	13.63	13.5393	13.6125	67200.0
2011-08-15 05:00:00	AAPL	Stock	13.6321	13.6321	13.6071	13.6075	23800.0
2011-08-15 06:00:00	AAPL	Stock	13.575	13.575	13.5375	13.5511	116060.0
2011-08-15 07:00:00	AAPL	Stock	13.5511	13.5725	13.3929	13.4639	1672832.0
2011-08-15 08:00:00	AAPL	Stock	13.4639	13.4804	13.4161	13.4393	2751812.0
2011-08-15 09:00:00	AAPL	Stock	13.4429	13.7371	13.4393	13.6775	101229296.0
2011-08-15 10:00:00	AAPL	Stock	13.6775	13.7489	13.6625	13.6957	83058192.0
2011-08-15 11:00:00	AAPL	Stock	13.6929	13.705	13.595	13.6575	69895504.0
2011-08-15 12:00:00	AAPL	Stock	13.6568	13.6904	13.6025	13.685	45901632.0
2011-08-15 13:00:00	AAPL	Stock	13.6854	13.7011	13.6607	13.6879	35684544.0
2011-08-15 14:00:00	AAPL	Stock	13.6857	13.7	13.6679	13.6995	38219020.0
2011-08-15 15:00:00	AAPL	Stock	13.6997	13.7082	13.6607	13.6893	69392008.0
2011-08-15 16:00:00	AAPL	Stock	13.6888	13.696	13.6685	13.6882	9059876.0
2011-08-15 17:00:00	AAPL	Stock	13.6893	13.7107	13.6821	13.7018	345100.0
2011-08-15 18:00:00	AAPL	Stock	13.6982	13.7089	13.6807	13.7089	303800.0
2011-08-15 19:00:00	AAPL	Stock	13.6857	13.6929	13.6804	13.685	236040.0
2011-08-15 05:00:00	MSFT	Stock	25.21	25.21	25.2	25.2	700.0
2011-08-15 06:00:00	MSFT	Stock	25.2	25.2	25.1	25.1	600.0
2011-08-15 07:00:00	MSFT	Stock	25.2	25.27	24.99	25.03	85628.0
2011-08-15 08:00:00	MSFT	Stock	25.05	25.25	25.04	25.2	81212.0
2011-08-15 09:00:00	MSFT	Stock	25.23	25.58	25.14	25.42	6399713.0
2011-08-15 10:00:00	MSFT	Stock	25.43	25.53	25.35	25.36	8744905.0
2011-08-15 11:00:00	MSFT	Stock	25.355	25.405	25.15	25.263	9603029.0
2011-08-15 12:00:00	MSFT	Stock	25.265	25.38	25.25	25.35	4454160.0
2011-08-15 13:00:00	MSFT	Stock	25.343	25.39	25.26	25.32	3693901.0
2011-08-15 14:00:00	MSFT	Stock	25.31	25.48	25.31	25.42	6181556.0
2011-08-15 15:00:00	MSFT	Stock	25.43	25.54	25.35	25.53	12727162.0
2011-08-15 16:00:00	MSFT	Stock	25.49	25.545	25.26	25.32	3065350.0
2011-08-15 17:00:00	MSFT	Stock	25.32	25.4	25.32	25.38	36068.0
2011-08-15 18:00:00	MSFT	Stock	25.38	25.51	25.35	25.35	26725.0
2011-08-15 19:00:00	MSFT	Stock	25.37	25.38	25.35	25.37	11656.0
2011-08-15 05:00:00	NVDA	Stock	0.3345	0.3345	0.3345	0.3345	4000.0
2011-08-15 07:00:00	NVDA	Stock	0.3243	0.3243	0.3243	0.3243	80000.0
2011-08-15 08:00:00	NVDA	Stock	0.3285	0.3315	0.325	0.3263	1960000.0
2011-08-15 09:00:00	NVDA	Stock	0.3263	0.3338	0.3235	0.3315	125368880.0
2011-08-15 10:00:00	NVDA	Stock	0.3318	0.3325	0.3273	0.3285	167438200.0
2011-08-15 11:00:00	NVDA	Stock	0.3283	0.329	0.325	0.328	88967680.0
2011-08-15 12:00:00	NVDA	Stock	0.3279	0.33	0.3274	0.3294	82202080.0
2011-08-15 13:00:00	NVDA	Stock	0.3294	0.3305	0.3288	0.3298	89265280.0
2011-08-15 14:00:00	NVDA	Stock	0.3299	0.3313	0.3293	0.3313	74604320.0
2011-08-15 15:00:00	NVDA	Stock	0.3311	0.335	0.331	0.334	209968880.0
2011-08-15 16:00:00	NVDA	Stock	0.3338	0.3343	0.3301	0.333	3997040.0
2011-08-15 17:00:00	NVDA	Stock	0.3338	0.3342	0.3338	0.3342	36000.0
2011-08-15 18:00:00	NVDA	Stock	0.334	0.3342	0.3335	0.334	679320.0
2011-08-15 19:00:00	NVDA	Stock	0.334	0.334	0.332	0.332	17960.0
2011-08-15 07:00:00	AMZN	Stock	10.1065	10.1875	10.1065	10.15	70800.0
2011-08-15 08:00:00	AMZN	Stock	10.175	10.18	10.129	10.159	196140.0
2011-08-15 09:00:00	AMZN	Stock	10.1625	10.264	10.0565	10.0965	17842540.0
2011-08-15 10:00:00	AMZN	Stock	10.097	10.167	10.0795	10.1085	12957260.0
2011-08-15 11:00:00	AMZN	Stock	10.1075	10.127	9.916	10.0126	14888340.0

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

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