PREVIEW / stock_1hour / 2013-09-17

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-09-17.parquet
  size:    1.0 MB
  rows:    48,242
  symbols: 3,535

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-09-17 04:00:00	AAPL	Stock	15.8857	15.9739	15.8714	15.9679	148932.0
2013-09-17 05:00:00	AAPL	Stock	15.9679	15.9821	15.9429	15.9432	46480.0
2013-09-17 06:00:00	AAPL	Stock	15.9375	15.9429	15.9068	15.9143	35840.0
2013-09-17 07:00:00	AAPL	Stock	15.9089	16.0093	15.9089	15.95	1258404.0
2013-09-17 08:00:00	AAPL	Stock	15.9554	16.0171	15.9018	15.9671	2768388.0
2013-09-17 09:00:00	AAPL	Stock	15.9682	16.265	15.9614	16.2441	96115096.0
2013-09-17 10:00:00	AAPL	Stock	16.245	16.4125	16.1904	16.4015	90598788.0
2013-09-17 11:00:00	AAPL	Stock	16.4036	16.4182	16.2861	16.3118	55519296.0
2013-09-17 12:00:00	AAPL	Stock	16.3139	16.3836	16.3086	16.3586	28222488.0
2013-09-17 13:00:00	AAPL	Stock	16.3575	16.3918	16.3261	16.3534	20217288.0
2013-09-17 14:00:00	AAPL	Stock	16.3515	16.3689	16.2336	16.2607	37808932.0
2013-09-17 15:00:00	AAPL	Stock	16.2607	16.3014	16.2336	16.2564	50925000.0
2013-09-17 16:00:00	AAPL	Stock	16.2564	16.39	16.0556	16.2439	12671988.0
2013-09-17 17:00:00	AAPL	Stock	16.2457	16.2564	16.2321	16.2564	337988.0
2013-09-17 18:00:00	AAPL	Stock	16.2414	16.2564	16.2414	16.2468	117628.0
2013-09-17 19:00:00	AAPL	Stock	16.2425	16.2614	16.2407	16.2571	235508.0
2013-09-17 08:00:00	MSFT	Stock	32.8	32.8	32.73	32.74	4844.0
2013-09-17 09:00:00	MSFT	Stock	32.74	34.49	32.74	32.97	31643391.0
2013-09-17 10:00:00	MSFT	Stock	32.96	33.11	32.9	33.035	15478408.0
2013-09-17 11:00:00	MSFT	Stock	33.04	33.13	32.96	33.035	10137436.0
2013-09-17 12:00:00	MSFT	Stock	33.04	33.1	32.99	33.005	4741864.0
2013-09-17 13:00:00	MSFT	Stock	33.01	33.05	32.92	32.97	4011955.0
2013-09-17 14:00:00	MSFT	Stock	32.973	33.01	32.93	32.998	4802250.0
2013-09-17 15:00:00	MSFT	Stock	32.99	33.03	32.91	32.94	9114897.0
2013-09-17 16:00:00	MSFT	Stock	32.935	33.13	32.831	32.93	2974638.0
2013-09-17 17:00:00	MSFT	Stock	32.93	32.96	32.92	32.93	12598.0
2013-09-17 18:00:00	MSFT	Stock	32.95	32.95	32.93	32.93	27412.0
2013-09-17 19:00:00	MSFT	Stock	32.93	32.93	32.92	32.92	5125.0
2013-09-17 09:00:00	NVDA	Stock	0.3955	0.3998	0.3955	0.3982	17041960.0
2013-09-17 10:00:00	NVDA	Stock	0.3982	0.3982	0.395	0.3978	45545720.0
2013-09-17 11:00:00	NVDA	Stock	0.3978	0.3984	0.396	0.3978	19289600.0
2013-09-17 12:00:00	NVDA	Stock	0.3976	0.3982	0.3969	0.3975	13336920.0
2013-09-17 13:00:00	NVDA	Stock	0.3978	0.3982	0.3973	0.3973	9659560.0
2013-09-17 14:00:00	NVDA	Stock	0.3973	0.3975	0.3958	0.3968	25233800.0
2013-09-17 15:00:00	NVDA	Stock	0.3968	0.397	0.3965	0.3965	26594640.0
2013-09-17 16:00:00	NVDA	Stock	0.3965	0.398	0.3965	0.3965	2301640.0
2013-09-17 18:00:00	NVDA	Stock	0.3995	0.3995	0.3995	0.3995	20000.0
2013-09-17 04:00:00	AMZN	Stock	14.75	14.75	14.75	14.75	6000.0
2013-09-17 06:00:00	AMZN	Stock	14.7945	14.7945	14.7945	14.7945	2000.0
2013-09-17 09:00:00	AMZN	Stock	14.857	14.988	14.8005	14.9665	5071720.0
2013-09-17 10:00:00	AMZN	Stock	14.9605	15.042	14.924	15.0215	6325680.0
2013-09-17 11:00:00	AMZN	Stock	15.023	15.1482	15.017	15.137	8355420.0
2013-09-17 12:00:00	AMZN	Stock	15.1375	15.224	15.137	15.2015	6620680.0
2013-09-17 13:00:00	AMZN	Stock	15.202	15.2155	15.1561	15.21	3104300.0
2013-09-17 14:00:00	AMZN	Stock	15.208	15.231	15.1922	15.2165	4220060.0
2013-09-17 15:00:00	AMZN	Stock	15.2185	15.2325	15.201	15.2135	9255180.0
2013-09-17 16:00:00	AMZN	Stock	15.2085	15.215	14.7845	15.2085	2753760.0
2013-09-17 17:00:00	AMZN	Stock	15.2085	15.2125	15.2085	15.2085	27380.0
2013-09-17 19:00:00	AMZN	Stock	15.2125	15.2125	15.2125	15.2125	4500.0
2013-09-17 04:00:00	META	Stock	42.2	42.47	42.02	42.33	35115.0

> showing 50 of 48,242 rows — these rows as CSV

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