PREVIEW / stock_1hour / 2012-05-30

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-05-30.parquet
  size:    948 KB
  rows:    45,467
  symbols: 3,544

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-05-30 04:00:00	AAPL	Stock	20.3668	20.3668	20.3214	20.3214	33880.0
2012-05-30 05:00:00	AAPL	Stock	20.3214	20.3357	20.2975	20.3107	44800.0
2012-05-30 06:00:00	AAPL	Stock	20.3179	20.3179	20.2907	20.2907	33600.0
2012-05-30 07:00:00	AAPL	Stock	20.29	20.4207	20.2543	20.3571	1070356.0
2012-05-30 08:00:00	AAPL	Stock	20.3343	20.3621	20.2696	20.3182	2489732.0
2012-05-30 09:00:00	AAPL	Stock	20.3107	20.3921	20.2343	20.2964	62731368.0
2012-05-30 10:00:00	AAPL	Stock	20.295	20.4575	20.2679	20.3118	84509796.0
2012-05-30 11:00:00	AAPL	Stock	20.3111	20.4586	20.3071	20.4182	58287404.0
2012-05-30 12:00:00	AAPL	Stock	20.4136	20.5154	20.3575	20.4854	54290656.0
2012-05-30 13:00:00	AAPL	Stock	20.4796	20.6143	20.4407	20.6111	57512840.0
2012-05-30 14:00:00	AAPL	Stock	20.6139	20.6914	20.5725	20.6232	85119888.0
2012-05-30 15:00:00	AAPL	Stock	20.625	20.7139	20.5171	20.6789	112311136.0
2012-05-30 16:00:00	AAPL	Stock	20.6846	20.6957	20.4732	20.6571	8654520.0
2012-05-30 17:00:00	AAPL	Stock	20.6589	20.6679	20.4885	20.6646	316120.0
2012-05-30 18:00:00	AAPL	Stock	20.6646	20.6679	20.6307	20.6411	280644.0
2012-05-30 19:00:00	AAPL	Stock	20.6429	20.6518	20.6089	20.6218	289688.0
2012-05-30 06:00:00	MSFT	Stock	29.26	29.26	29.25	29.25	600.0
2012-05-30 07:00:00	MSFT	Stock	29.3	29.3	29.3	29.3	100.0
2012-05-30 08:00:00	MSFT	Stock	29.47	29.54	29.35	29.35	5412.0
2012-05-30 09:00:00	MSFT	Stock	29.34	29.36	29.195	29.29	3901086.0
2012-05-30 10:00:00	MSFT	Stock	29.29	29.34	29.17	29.18	7577597.0
2012-05-30 11:00:00	MSFT	Stock	29.18	29.26	29.12	29.229	7130626.0
2012-05-30 12:00:00	MSFT	Stock	29.23	29.31	29.14	29.28	4431944.0
2012-05-30 13:00:00	MSFT	Stock	29.28	29.43	29.22	29.415	3909022.0
2012-05-30 14:00:00	MSFT	Stock	29.417	29.479	29.33	29.395	4778687.0
2012-05-30 15:00:00	MSFT	Stock	29.39	29.45	29.23	29.34	7735088.0
2012-05-30 16:00:00	MSFT	Stock	29.34	29.416	29.212	29.32	1713781.0
2012-05-30 17:00:00	MSFT	Stock	29.32	29.328	29.32	29.32	74000.0
2012-05-30 18:00:00	MSFT	Stock	29.32	29.33	29.32	29.33	1600.0
2012-05-30 19:00:00	MSFT	Stock	29.32	29.32	29.32	29.32	3961.0
2012-05-30 08:00:00	NVDA	Stock	0.3153	0.3153	0.3153	0.3153	4000.0
2012-05-30 09:00:00	NVDA	Stock	0.3153	0.3155	0.3098	0.3125	38549040.0
2012-05-30 10:00:00	NVDA	Stock	0.3125	0.3125	0.3088	0.3095	46554240.0
2012-05-30 11:00:00	NVDA	Stock	0.3095	0.3133	0.309	0.312	48986640.0
2012-05-30 12:00:00	NVDA	Stock	0.312	0.3148	0.31	0.3138	49306680.0
2012-05-30 13:00:00	NVDA	Stock	0.314	0.3168	0.3133	0.316	53879400.0
2012-05-30 14:00:00	NVDA	Stock	0.3161	0.3165	0.3145	0.3153	37704880.0
2012-05-30 15:00:00	NVDA	Stock	0.315	0.3163	0.3129	0.3143	93053680.0
2012-05-30 16:00:00	NVDA	Stock	0.3143	0.315	0.3135	0.3143	10734200.0
2012-05-30 17:00:00	NVDA	Stock	0.3142	0.3142	0.3142	0.3142	50720.0
2012-05-30 07:00:00	AMZN	Stock	10.6525	10.6525	10.6505	10.6505	4000.0
2012-05-30 08:00:00	AMZN	Stock	10.665	10.6925	10.65	10.65	125240.0
2012-05-30 09:00:00	AMZN	Stock	10.653	10.655	10.506	10.573	9457700.0
2012-05-30 10:00:00	AMZN	Stock	10.5675	10.595	10.4755	10.482	14550380.0
2012-05-30 11:00:00	AMZN	Stock	10.4835	10.5485	10.4755	10.5001	9101120.0
2012-05-30 12:00:00	AMZN	Stock	10.506	10.509	10.3876	10.4365	13117780.0
2012-05-30 13:00:00	AMZN	Stock	10.4405	10.5005	10.3905	10.489	10962520.0
2012-05-30 14:00:00	AMZN	Stock	10.492	10.5296	10.4625	10.499	8195460.0
2012-05-30 15:00:00	AMZN	Stock	10.4935	10.5248	10.416	10.4565	12308460.0
2012-05-30 16:00:00	AMZN	Stock	10.4615	10.5266	10.45	10.4615	2688200.0

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

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