PREVIEW / stock_1hour / 2013-04-16

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-04-16.parquet
  size:    986 KB
  rows:    45,554
  symbols: 3,477

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
2013-04-16 04:00:00	AAPL	Stock	15.0357	15.0357	15.0357	15.0357	17304.0
2013-04-16 05:00:00	AAPL	Stock	15.0714	15.0714	15.0714	15.0714	20160.0
2013-04-16 06:00:00	AAPL	Stock	15.0821	15.0925	15.0768	15.0786	56000.0
2013-04-16 07:00:00	AAPL	Stock	15.0786	15.1589	15.0714	15.1218	713356.0
2013-04-16 08:00:00	AAPL	Stock	15.1146	15.1468	15.0	15.0893	2115876.0
2013-04-16 09:00:00	AAPL	Stock	15.0914	15.1714	15.0204	15.0795	60985876.0
2013-04-16 10:00:00	AAPL	Stock	15.0769	15.1661	15.0279	15.1025	58213456.0
2013-04-16 11:00:00	AAPL	Stock	15.1004	15.1893	15.0754	15.1664	38221988.0
2013-04-16 12:00:00	AAPL	Stock	15.1661	15.1814	15.1446	15.1636	24828216.0
2013-04-16 13:00:00	AAPL	Stock	15.1639	15.1736	15.1168	15.1621	17164392.0
2013-04-16 14:00:00	AAPL	Stock	15.1656	15.1968	15.1632	15.1739	27106940.0
2013-04-16 15:00:00	AAPL	Stock	15.1775	15.2361	15.1664	15.2175	45387664.0
2013-04-16 16:00:00	AAPL	Stock	15.2229	15.2289	15.0915	15.2246	24857252.0
2013-04-16 17:00:00	AAPL	Stock	15.2229	15.2243	15.2143	15.2168	202412.0
2013-04-16 18:00:00	AAPL	Stock	15.2175	15.2175	15.1918	15.1964	193116.0
2013-04-16 19:00:00	AAPL	Stock	15.1893	15.1893	15.1571	15.1786	689612.0
2013-04-16 06:00:00	MSFT	Stock	28.83	28.85	28.81	28.85	4700.0
2013-04-16 07:00:00	MSFT	Stock	28.86	29.03	28.86	29.0	27226.0
2013-04-16 08:00:00	MSFT	Stock	29.0	29.05	28.68	29.04	188943.0
2013-04-16 09:00:00	MSFT	Stock	29.0	29.03	28.76	28.9	7401309.0
2013-04-16 10:00:00	MSFT	Stock	28.9	29.14	28.695	28.817	9743457.0
2013-04-16 11:00:00	MSFT	Stock	28.82	29.08	28.77	28.945	7279549.0
2013-04-16 12:00:00	MSFT	Stock	28.945	29.1	28.92	29.09	4293681.0
2013-04-16 13:00:00	MSFT	Stock	29.085	29.095	28.96	29.015	3252733.0
2013-04-16 14:00:00	MSFT	Stock	29.02	29.03	28.88	28.885	5031853.0
2013-04-16 15:00:00	MSFT	Stock	28.885	28.98	28.81	28.98	10433642.0
2013-04-16 16:00:00	MSFT	Stock	28.98	29.25	28.623	29.08	4386882.0
2013-04-16 17:00:00	MSFT	Stock	28.97	29.07	28.97	29.06	103702.0
2013-04-16 18:00:00	MSFT	Stock	29.05	29.07	29.01	29.01	5300.0
2013-04-16 19:00:00	MSFT	Stock	29.03	29.09	29.03	29.05	4100.0
2013-04-16 08:00:00	NVDA	Stock	0.3245	0.3258	0.3245	0.3258	58480.0
2013-04-16 09:00:00	NVDA	Stock	0.3265	0.3265	0.322	0.3221	42996440.0
2013-04-16 10:00:00	NVDA	Stock	0.3223	0.325	0.3218	0.3249	59631080.0
2013-04-16 11:00:00	NVDA	Stock	0.3249	0.3263	0.3243	0.3249	91563200.0
2013-04-16 12:00:00	NVDA	Stock	0.325	0.325	0.3223	0.3238	79388080.0
2013-04-16 13:00:00	NVDA	Stock	0.3236	0.325	0.3228	0.3243	44768760.0
2013-04-16 14:00:00	NVDA	Stock	0.3243	0.3245	0.3225	0.3228	33599320.0
2013-04-16 15:00:00	NVDA	Stock	0.3226	0.3255	0.3225	0.3241	95533880.0
2013-04-16 16:00:00	NVDA	Stock	0.324	0.3245	0.3225	0.3225	5565040.0
2013-04-16 17:00:00	NVDA	Stock	0.3235	0.324	0.3235	0.324	27920.0
2013-04-16 19:00:00	NVDA	Stock	0.324	0.324	0.324	0.324	4000.0
2013-04-16 06:00:00	AMZN	Stock	13.455	13.455	13.445	13.445	4160.0
2013-04-16 07:00:00	AMZN	Stock	13.4425	13.5235	13.4425	13.5235	74000.0
2013-04-16 08:00:00	AMZN	Stock	13.483	13.5065	13.386	13.49	292280.0
2013-04-16 09:00:00	AMZN	Stock	13.495	13.5185	13.403	13.465	6349540.0
2013-04-16 10:00:00	AMZN	Stock	13.466	13.546	13.42	13.5165	9047840.0
2013-04-16 11:00:00	AMZN	Stock	13.523	13.6192	13.5032	13.5965	5572160.0
2013-04-16 12:00:00	AMZN	Stock	13.5955	13.637	13.576	13.6235	3572140.0
2013-04-16 13:00:00	AMZN	Stock	13.6255	13.64	13.58	13.581	2454680.0
2013-04-16 14:00:00	AMZN	Stock	13.581	13.612	13.5625	13.5881	3882060.0

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

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