PREVIEW / stock_1hour / 2013-03-19

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-03-19.parquet
  size:    983 KB
  rows:    46,198
  symbols: 3,468

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-19 04:00:00	AAPL	Stock	16.325	16.325	16.3121	16.3125	28000.0
2013-03-19 05:00:00	AAPL	Stock	16.3125	16.3125	16.3125	16.3125	28000.0
2013-03-19 06:00:00	AAPL	Stock	16.3375	16.3375	16.2857	16.3	115640.0
2013-03-19 07:00:00	AAPL	Stock	16.3	16.3261	16.2507	16.3204	440944.0
2013-03-19 08:00:00	AAPL	Stock	16.3	16.4439	16.2679	16.4018	4303096.0
2013-03-19 09:00:00	AAPL	Stock	16.4064	16.4632	16.3036	16.3604	101506496.0
2013-03-19 10:00:00	AAPL	Stock	16.36	16.39	16.1393	16.1561	105905856.0
2013-03-19 11:00:00	AAPL	Stock	16.1536	16.2186	16.0861	16.1031	64542016.0
2013-03-19 12:00:00	AAPL	Stock	16.1029	16.1243	16.0429	16.0914	53373264.0
2013-03-19 13:00:00	AAPL	Stock	16.0904	16.1357	16.0179	16.07	41394668.0
2013-03-19 14:00:00	AAPL	Stock	16.0686	16.2061	16.0579	16.1261	48404944.0
2013-03-19 15:00:00	AAPL	Stock	16.1275	16.2429	16.0714	16.2318	78632596.0
2013-03-19 16:00:00	AAPL	Stock	16.2318	16.252	16.1254	16.2054	12769960.0
2013-03-19 17:00:00	AAPL	Stock	16.2	16.2318	16.1986	16.2232	604492.0
2013-03-19 18:00:00	AAPL	Stock	16.2168	16.2232	16.2	16.2046	152824.0
2013-03-19 19:00:00	AAPL	Stock	16.2068	16.2143	16.1986	16.2125	493584.0
2013-03-19 07:00:00	MSFT	Stock	28.1	28.1	28.1	28.1	100.0
2013-03-19 08:00:00	MSFT	Stock	28.1	28.15	28.1	28.15	620.0
2013-03-19 09:00:00	MSFT	Stock	28.18	28.2	28.055	28.17	3356882.0
2013-03-19 10:00:00	MSFT	Stock	28.16	28.22	28.06	28.13	6619045.0
2013-03-19 11:00:00	MSFT	Stock	28.12	28.138	28.03	28.06	6455688.0
2013-03-19 12:00:00	MSFT	Stock	28.065	28.13	28.04	28.06	6541839.0
2013-03-19 13:00:00	MSFT	Stock	28.06	28.105	28.03	28.09	9427178.0
2013-03-19 14:00:00	MSFT	Stock	28.08	28.11	28.05	28.087	7030329.0
2013-03-19 15:00:00	MSFT	Stock	28.085	28.19	28.05	28.17	10050711.0
2013-03-19 16:00:00	MSFT	Stock	28.18	28.18	28.026	28.08	1792783.0
2013-03-19 17:00:00	MSFT	Stock	28.13	28.18	28.13	28.18	24310.0
2013-03-19 18:00:00	MSFT	Stock	28.14	28.14	28.14	28.14	800.0
2013-03-19 19:00:00	MSFT	Stock	28.13	28.13	28.12	28.12	600.0
2013-03-19 08:00:00	NVDA	Stock	0.3148	0.3148	0.3148	0.3148	8000.0
2013-03-19 09:00:00	NVDA	Stock	0.314	0.3153	0.313	0.3143	24968440.0
2013-03-19 10:00:00	NVDA	Stock	0.3143	0.3155	0.3134	0.3144	53242360.0
2013-03-19 11:00:00	NVDA	Stock	0.3145	0.3148	0.3118	0.3124	38694320.0
2013-03-19 12:00:00	NVDA	Stock	0.3123	0.3138	0.3113	0.3134	28804600.0
2013-03-19 13:00:00	NVDA	Stock	0.3133	0.3134	0.3095	0.3099	58692360.0
2013-03-19 14:00:00	NVDA	Stock	0.31	0.312	0.3095	0.3113	54546720.0
2013-03-19 15:00:00	NVDA	Stock	0.3113	0.313	0.3108	0.3118	86232200.0
2013-03-19 16:00:00	NVDA	Stock	0.3118	0.3142	0.3117	0.312	8944400.0
2013-03-19 17:00:00	NVDA	Stock	0.3123	0.313	0.3118	0.3118	460480.0
2013-03-19 18:00:00	NVDA	Stock	0.3123	0.3123	0.312	0.312	716000.0
2013-03-19 08:00:00	AMZN	Stock	12.963	12.9675	12.896	12.896	79500.0
2013-03-19 09:00:00	AMZN	Stock	12.9005	12.975	12.84	12.8685	10968820.0
2013-03-19 10:00:00	AMZN	Stock	12.8713	12.924	12.769	12.8375	13453900.0
2013-03-19 11:00:00	AMZN	Stock	12.838	12.96	12.77	12.7895	10694340.0
2013-03-19 12:00:00	AMZN	Stock	12.7875	12.84	12.7096	12.7412	9663500.0
2013-03-19 13:00:00	AMZN	Stock	12.7365	12.7594	12.631	12.698	8490040.0
2013-03-19 14:00:00	AMZN	Stock	12.699	12.764	12.678	12.7205	6215800.0
2013-03-19 15:00:00	AMZN	Stock	12.7255	12.826	12.718	12.821	12235120.0
2013-03-19 16:00:00	AMZN	Stock	12.821	12.827	12.7482	12.8255	1964360.0
2013-03-19 17:00:00	AMZN	Stock	12.8205	12.8205	12.7905	12.7905	71880.0

> showing 50 of 46,198 rows — these rows as CSV

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