PREVIEW / stock_1hour / 2012-09-13

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-09-13.parquet
  size:    950 KB
  rows:    44,475
  symbols: 3,488

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-09-13 04:00:00	AAPL	Stock	23.9161	23.9646	23.8932	23.9646	155428.0
2012-09-13 05:00:00	AAPL	Stock	23.9679	24.0143	23.9679	24.0	76580.0
2012-09-13 06:00:00	AAPL	Stock	23.9857	24.0232	23.9821	23.9907	112980.0
2012-09-13 07:00:00	AAPL	Stock	23.9875	24.1286	23.9875	24.0893	3212860.0
2012-09-13 08:00:00	AAPL	Stock	24.0982	24.1321	24.0	24.1093	5892824.0
2012-09-13 09:00:00	AAPL	Stock	24.1071	24.2739	24.0982	24.1911	105623728.0
2012-09-13 10:00:00	AAPL	Stock	24.1943	24.2464	24.1368	24.2196	74457096.0
2012-09-13 11:00:00	AAPL	Stock	24.22	24.2357	24.1836	24.2007	31322648.0
2012-09-13 12:00:00	AAPL	Stock	24.1979	24.3129	24.1536	24.285	89088496.0
2012-09-13 13:00:00	AAPL	Stock	24.2854	24.4532	24.2689	24.4126	96104232.0
2012-09-13 14:00:00	AAPL	Stock	24.4138	24.4821	24.3929	24.455	64181824.0
2012-09-13 15:00:00	AAPL	Stock	24.455	24.4579	24.3654	24.3918	75996340.0
2012-09-13 16:00:00	AAPL	Stock	24.3896	24.4064	24.2252	24.3889	29887144.0
2012-09-13 17:00:00	AAPL	Stock	24.2164	24.4168	24.2164	24.4168	632016.0
2012-09-13 18:00:00	AAPL	Stock	24.4179	24.4357	24.4179	24.4321	572292.0
2012-09-13 19:00:00	AAPL	Stock	24.4264	24.4429	24.4229	24.4293	391076.0
2012-09-13 07:00:00	MSFT	Stock	30.8	30.8	30.78	30.78	850.0
2012-09-13 08:00:00	MSFT	Stock	30.8	30.93	30.76	30.78	76214.0
2012-09-13 09:00:00	MSFT	Stock	30.78	30.9	30.4	30.53	4408036.0
2012-09-13 10:00:00	MSFT	Stock	30.524	30.61	30.455	30.555	5572943.0
2012-09-13 11:00:00	MSFT	Stock	30.56	30.62	30.54	30.55	2995240.0
2012-09-13 12:00:00	MSFT	Stock	30.55	31.0	30.54	30.88	7619059.0
2012-09-13 13:00:00	MSFT	Stock	30.89	31.07	30.86	30.95	4670807.0
2012-09-13 14:00:00	MSFT	Stock	30.95	31.18	30.91	31.08	4980565.0
2012-09-13 15:00:00	MSFT	Stock	31.08	31.13	30.89	30.97	9789202.0
2012-09-13 16:00:00	MSFT	Stock	30.95	31.069	30.564	30.97	4169903.0
2012-09-13 17:00:00	MSFT	Stock	30.96	31.0	30.91	30.91	12506.0
2012-09-13 18:00:00	MSFT	Stock	30.93	31.0	30.91	30.94	9459.0
2012-09-13 19:00:00	MSFT	Stock	30.92	30.93	30.92	30.93	3880.0
2012-09-13 09:00:00	NVDA	Stock	0.3398	0.345	0.3385	0.3409	64593200.0
2012-09-13 10:00:00	NVDA	Stock	0.341	0.342	0.3355	0.337	58219520.0
2012-09-13 11:00:00	NVDA	Stock	0.337	0.3378	0.3362	0.3362	32241240.0
2012-09-13 12:00:00	NVDA	Stock	0.3365	0.34	0.336	0.3398	43960640.0
2012-09-13 13:00:00	NVDA	Stock	0.3398	0.3415	0.3394	0.3398	69190040.0
2012-09-13 14:00:00	NVDA	Stock	0.3398	0.3425	0.3394	0.341	62656840.0
2012-09-13 15:00:00	NVDA	Stock	0.3411	0.3425	0.3408	0.342	85029680.0
2012-09-13 16:00:00	NVDA	Stock	0.342	0.3433	0.3402	0.3413	4996240.0
2012-09-13 17:00:00	NVDA	Stock	0.3413	0.3425	0.3413	0.3425	128000.0
2012-09-13 18:00:00	NVDA	Stock	0.3433	0.3433	0.343	0.3433	214520.0
2012-09-13 04:00:00	AMZN	Stock	12.6605	12.6605	12.6	12.6	52000.0
2012-09-13 05:00:00	AMZN	Stock	12.6	12.62	12.6	12.62	196000.0
2012-09-13 06:00:00	AMZN	Stock	12.6	12.65	12.6	12.65	59400.0
2012-09-13 07:00:00	AMZN	Stock	12.685	12.74	12.65	12.7175	651160.0
2012-09-13 08:00:00	AMZN	Stock	12.714	12.739	12.714	12.739	219060.0
2012-09-13 09:00:00	AMZN	Stock	12.742	12.825	12.69	12.716	7542180.0
2012-09-13 10:00:00	AMZN	Stock	12.7175	12.7675	12.7045	12.727	6215720.0
2012-09-13 11:00:00	AMZN	Stock	12.7305	12.778	12.7251	12.7616	3398580.0
2012-09-13 12:00:00	AMZN	Stock	12.7645	12.9295	12.7605	12.9	12871160.0
2012-09-13 13:00:00	AMZN	Stock	12.899	12.9855	12.8965	12.9685	10717560.0
2012-09-13 14:00:00	AMZN	Stock	12.9668	13.1	12.9565	13.0583	12211960.0

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

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