PREVIEW / stock_1hour / 2013-03-22

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-03-22.parquet
  size:    953 KB
  rows:    44,430
  symbols: 3,461

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-03-22 04:00:00	AAPL	Stock	16.1804	16.1804	16.1804	16.1804	2800.0
2013-03-22 05:00:00	AAPL	Stock	16.2143	16.2143	16.2143	16.2143	2800.0
2013-03-22 07:00:00	AAPL	Stock	16.2207	16.2679	16.2054	16.2304	216384.0
2013-03-22 08:00:00	AAPL	Stock	16.2296	16.25	16.2139	16.2214	713776.0
2013-03-22 09:00:00	AAPL	Stock	16.2246	16.2961	16.1825	16.2764	49816816.0
2013-03-22 10:00:00	AAPL	Stock	16.2754	16.3268	16.1786	16.2854	53418848.0
2013-03-22 11:00:00	AAPL	Stock	16.2839	16.325	16.2797	16.3236	26731180.0
2013-03-22 12:00:00	AAPL	Stock	16.325	16.4239	16.325	16.4068	67368056.0
2013-03-22 13:00:00	AAPL	Stock	16.4068	16.4929	16.3725	16.4753	60862956.0
2013-03-22 14:00:00	AAPL	Stock	16.4748	16.5	16.4321	16.4461	39344676.0
2013-03-22 15:00:00	AAPL	Stock	16.4425	16.5036	16.4336	16.4982	72051448.0
2013-03-22 16:00:00	AAPL	Stock	16.4982	16.5464	16.3832	16.5107	13910092.0
2013-03-22 17:00:00	AAPL	Stock	16.5125	16.5696	16.4968	16.5589	1548512.0
2013-03-22 18:00:00	AAPL	Stock	16.5468	16.5536	16.5296	16.5314	535472.0
2013-03-22 19:00:00	AAPL	Stock	16.5325	16.5429	16.5257	16.5325	166600.0
2013-03-22 08:00:00	MSFT	Stock	28.15	28.2	28.15	28.2	400.0
2013-03-22 09:00:00	MSFT	Stock	28.14	28.22	28.13	28.18	2766247.0
2013-03-22 10:00:00	MSFT	Stock	28.175	28.21	28.115	28.16	4057301.0
2013-03-22 11:00:00	MSFT	Stock	28.15	28.175	28.1	28.11	3576305.0
2013-03-22 12:00:00	MSFT	Stock	28.105	28.27	28.1	28.25	4463701.0
2013-03-22 13:00:00	MSFT	Stock	28.25	28.338	28.24	28.265	2942732.0
2013-03-22 14:00:00	MSFT	Stock	28.265	28.28	28.22	28.23	3066548.0
2013-03-22 15:00:00	MSFT	Stock	28.23	28.26	28.17	28.245	5378506.0
2013-03-22 16:00:00	MSFT	Stock	28.26	28.28	28.068	28.22	2255257.0
2013-03-22 17:00:00	MSFT	Stock	28.25	28.29	28.23	28.23	5470.0
2013-03-22 18:00:00	MSFT	Stock	28.25	28.25	28.25	28.25	100.0
2013-03-22 19:00:00	MSFT	Stock	28.29	28.29	28.29	28.29	300.0
2013-03-22 09:00:00	NVDA	Stock	0.312	0.3133	0.3103	0.3105	26587920.0
2013-03-22 10:00:00	NVDA	Stock	0.3105	0.3115	0.3105	0.3115	35725920.0
2013-03-22 11:00:00	NVDA	Stock	0.3115	0.3118	0.3108	0.3111	28253440.0
2013-03-22 12:00:00	NVDA	Stock	0.311	0.3115	0.311	0.3115	15974320.0
2013-03-22 13:00:00	NVDA	Stock	0.3115	0.3128	0.3113	0.3123	29110280.0
2013-03-22 14:00:00	NVDA	Stock	0.312	0.3123	0.3115	0.3115	17517240.0
2013-03-22 15:00:00	NVDA	Stock	0.3118	0.3125	0.311	0.312	63573680.0
2013-03-22 16:00:00	NVDA	Stock	0.3119	0.3123	0.3116	0.312	13499520.0
2013-03-22 17:00:00	NVDA	Stock	0.312	0.312	0.312	0.312	12000.0
2013-03-22 19:00:00	NVDA	Stock	0.3128	0.3128	0.3128	0.3128	20000.0
2013-03-22 04:00:00	AMZN	Stock	12.6505	12.6505	12.6505	12.6505	2000.0
2013-03-22 09:00:00	AMZN	Stock	12.703	12.729	12.6035	12.628	8045340.0
2013-03-22 10:00:00	AMZN	Stock	12.6315	12.722	12.629	12.654	10564880.0
2013-03-22 11:00:00	AMZN	Stock	12.653	12.7075	12.6405	12.697	4872120.0
2013-03-22 12:00:00	AMZN	Stock	12.6985	12.8025	12.6805	12.801	6139680.0
2013-03-22 13:00:00	AMZN	Stock	12.8015	12.8625	12.772	12.8455	9163340.0
2013-03-22 14:00:00	AMZN	Stock	12.8465	12.87	12.821	12.8575	4725680.0
2013-03-22 15:00:00	AMZN	Stock	12.86	12.8885	12.805	12.887	10516460.0
2013-03-22 16:00:00	AMZN	Stock	12.8875	12.93	12.6882	12.905	8114080.0
2013-03-22 17:00:00	AMZN	Stock	12.8875	12.913	12.8875	12.9	195520.0
2013-03-22 18:00:00	AMZN	Stock	12.9005	12.9005	12.8985	12.8985	8000.0
2013-03-22 05:00:00	META	Stock	25.8	25.8	25.8	25.8	600.0
2013-03-22 07:00:00	META	Stock	25.81	25.85	25.81	25.82	3200.0

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

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