PREVIEW / stock_1hour / 2013-01-30

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-01-30.parquet
  size:    958 KB
  rows:    44,891
  symbols: 3,474

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-01-30 04:00:00	AAPL	Stock	16.4332	16.4539	16.4164	16.4539	99400.0
2013-01-30 05:00:00	AAPL	Stock	16.4461	16.4461	16.4075	16.4121	86800.0
2013-01-30 06:00:00	AAPL	Stock	16.4154	16.4154	16.3214	16.3232	116340.0
2013-01-30 07:00:00	AAPL	Stock	16.3232	16.3357	16.2875	16.3036	459200.0
2013-01-30 08:00:00	AAPL	Stock	16.3025	16.3571	16.1807	16.2218	3809008.0
2013-01-30 09:00:00	AAPL	Stock	16.2218	16.4893	16.2011	16.4564	84437612.0
2013-01-30 10:00:00	AAPL	Stock	16.4561	16.5214	16.3507	16.4575	90591172.0
2013-01-30 11:00:00	AAPL	Stock	16.4579	16.4959	16.4304	16.45	36290744.0
2013-01-30 12:00:00	AAPL	Stock	16.4496	16.4593	16.3546	16.4135	34974576.0
2013-01-30 13:00:00	AAPL	Stock	16.4125	16.4275	16.375	16.4104	20420512.0
2013-01-30 14:00:00	AAPL	Stock	16.4079	16.425	16.3618	16.4	41783756.0
2013-01-30 15:00:00	AAPL	Stock	16.3982	16.4064	16.2321	16.3182	84248948.0
2013-01-30 16:00:00	AAPL	Stock	16.3154	16.4482	16.2857	16.3036	6571348.0
2013-01-30 17:00:00	AAPL	Stock	16.3036	16.3036	16.2786	16.3	579432.0
2013-01-30 18:00:00	AAPL	Stock	16.3018	16.3107	16.2957	16.3093	151088.0
2013-01-30 19:00:00	AAPL	Stock	16.3121	16.3121	16.3036	16.3071	225596.0
2013-01-30 06:00:00	MSFT	Stock	28.06	28.06	28.06	28.06	500.0
2013-01-30 07:00:00	MSFT	Stock	28.03	28.06	28.03	28.05	2700.0
2013-01-30 08:00:00	MSFT	Stock	28.06	28.06	27.97	27.99	48101.0
2013-01-30 09:00:00	MSFT	Stock	27.98	28.19	27.98	28.155	6186499.0
2013-01-30 10:00:00	MSFT	Stock	28.15	28.152	27.86	27.99	7117652.0
2013-01-30 11:00:00	MSFT	Stock	27.995	28.05	27.98	27.98	3748150.0
2013-01-30 12:00:00	MSFT	Stock	27.98	28.05	27.94	28.05	3321889.0
2013-01-30 13:00:00	MSFT	Stock	28.045	28.06	27.95	27.98	2742002.0
2013-01-30 14:00:00	MSFT	Stock	27.975	28.04	27.92	27.952	4241290.0
2013-01-30 15:00:00	MSFT	Stock	27.96	27.98	27.76	27.85	13073995.0
2013-01-30 16:00:00	MSFT	Stock	27.85	28.07	27.79	27.81	2444706.0
2013-01-30 17:00:00	MSFT	Stock	27.82	28.0	27.81	27.83	10416.0
2013-01-30 18:00:00	MSFT	Stock	27.84	27.85	27.83	27.83	2864.0
2013-01-30 19:00:00	MSFT	Stock	27.83	27.88	27.83	27.86	3612.0
2013-01-30 08:00:00	NVDA	Stock	0.3093	0.3103	0.3085	0.3085	644320.0
2013-01-30 09:00:00	NVDA	Stock	0.31	0.313	0.3085	0.3123	48821720.0
2013-01-30 10:00:00	NVDA	Stock	0.3123	0.3123	0.3085	0.3093	50665320.0
2013-01-30 11:00:00	NVDA	Stock	0.3094	0.3098	0.3078	0.3093	45904640.0
2013-01-30 12:00:00	NVDA	Stock	0.309	0.3095	0.3086	0.3095	17751680.0
2013-01-30 13:00:00	NVDA	Stock	0.3093	0.3095	0.3085	0.3088	16622320.0
2013-01-30 14:00:00	NVDA	Stock	0.3088	0.3095	0.3083	0.309	27119920.0
2013-01-30 15:00:00	NVDA	Stock	0.3089	0.309	0.3069	0.308	67305560.0
2013-01-30 16:00:00	NVDA	Stock	0.3078	0.3093	0.3078	0.308	12380000.0
2013-01-30 17:00:00	NVDA	Stock	0.3093	0.3103	0.3093	0.3103	280000.0
2013-01-30 19:00:00	NVDA	Stock	0.3095	0.3095	0.3095	0.3095	32000.0
2013-01-30 04:00:00	AMZN	Stock	14.197	14.2	14.12	14.146	142800.0
2013-01-30 05:00:00	AMZN	Stock	14.09	14.1645	14.09	14.1505	198440.0
2013-01-30 06:00:00	AMZN	Stock	14.168	14.2395	14.1375	14.175	141080.0
2013-01-30 07:00:00	AMZN	Stock	14.172	14.23	14.0785	14.102	1041340.0
2013-01-30 08:00:00	AMZN	Stock	14.1	14.228	14.0315	14.19	4127500.0
2013-01-30 09:00:00	AMZN	Stock	14.185	14.21	13.6505	13.6551	79805980.0
2013-01-30 10:00:00	AMZN	Stock	13.6553	13.7705	13.3555	13.7668	66195440.0
2013-01-30 11:00:00	AMZN	Stock	13.767	13.899	13.692	13.8075	33348460.0
2013-01-30 12:00:00	AMZN	Stock	13.8006	13.8215	13.65	13.77	15931940.0

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

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