PREVIEW / stock_1hour / 2014-04-24

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-04-24.parquet
  size:    1.0 MB
  rows:    48,018
  symbols: 3,539

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
2014-04-24 04:00:00	AAPL	Stock	20.1411	20.1629	20.095	20.095	297920.0
2014-04-24 05:00:00	AAPL	Stock	20.1143	20.1439	20.1071	20.1325	149268.0
2014-04-24 06:00:00	AAPL	Stock	20.1325	20.2411	20.1325	20.2411	558796.0
2014-04-24 07:00:00	AAPL	Stock	20.2143	20.4375	20.1786	20.3564	5360152.0
2014-04-24 08:00:00	AAPL	Stock	20.355	20.4282	20.2821	20.3325	11230548.0
2014-04-24 09:00:00	AAPL	Stock	20.3321	20.375	20.0261	20.1464	197970416.0
2014-04-24 10:00:00	AAPL	Stock	20.1411	20.2446	20.0407	20.2207	125682648.0
2014-04-24 11:00:00	AAPL	Stock	20.2206	20.2657	20.1843	20.2607	54093564.0
2014-04-24 12:00:00	AAPL	Stock	20.2611	20.2743	20.2107	20.2661	39390092.0
2014-04-24 13:00:00	AAPL	Stock	20.2654	20.2811	20.2429	20.2607	37344916.0
2014-04-24 14:00:00	AAPL	Stock	20.26	20.2923	20.2421	20.2907	47610024.0
2014-04-24 15:00:00	AAPL	Stock	20.2893	20.355	20.265	20.2775	86557940.0
2014-04-24 16:00:00	AAPL	Stock	20.2779	20.304	20.2043	20.2586	14788368.0
2014-04-24 17:00:00	AAPL	Stock	20.25	20.2775	20.2275	20.2275	1979348.0
2014-04-24 18:00:00	AAPL	Stock	20.2307	20.2775	20.2143	20.2189	607992.0
2014-04-24 19:00:00	AAPL	Stock	20.2239	20.25	20.2239	20.2432	483280.0
2014-04-24 06:00:00	MSFT	Stock	40.0	40.19	39.98	40.0	1550.0
2014-04-24 07:00:00	MSFT	Stock	39.98	40.09	39.95	40.05	21390.0
2014-04-24 08:00:00	MSFT	Stock	40.0	40.12	39.9	40.02	78571.0
2014-04-24 09:00:00	MSFT	Stock	40.01	40.05	39.55	39.56	5532996.0
2014-04-24 10:00:00	MSFT	Stock	39.56	39.56	39.3	39.33	7342609.0
2014-04-24 11:00:00	MSFT	Stock	39.33	39.48	39.3	39.395	2994612.0
2014-04-24 12:00:00	MSFT	Stock	39.4	39.41	39.34	39.406	2516381.0
2014-04-24 13:00:00	MSFT	Stock	39.41	39.617	39.39	39.55	3265233.0
2014-04-24 14:00:00	MSFT	Stock	39.55	39.71	39.54	39.655	4226007.0
2014-04-24 15:00:00	MSFT	Stock	39.66	39.87	39.62	39.85	8838083.0
2014-04-24 16:00:00	MSFT	Stock	39.86	41.0	39.376	40.93	5498881.0
2014-04-24 17:00:00	MSFT	Stock	40.85	41.0	39.65	40.8	442545.0
2014-04-24 18:00:00	MSFT	Stock	40.8	41.06	40.8	40.95	202894.0
2014-04-24 19:00:00	MSFT	Stock	40.91	40.95	40.83	40.86	25730.0
2014-04-24 07:00:00	NVDA	Stock	0.484	0.484	0.4825	0.4825	16000.0
2014-04-24 08:00:00	NVDA	Stock	0.4825	0.484	0.48	0.484	113000.0
2014-04-24 09:00:00	NVDA	Stock	0.4825	0.4843	0.4805	0.4822	45882960.0
2014-04-24 10:00:00	NVDA	Stock	0.4825	0.486	0.481	0.4842	83343120.0
2014-04-24 11:00:00	NVDA	Stock	0.4841	0.4865	0.4825	0.483	51640880.0
2014-04-24 12:00:00	NVDA	Stock	0.4829	0.4838	0.4818	0.4835	35983480.0
2014-04-24 13:00:00	NVDA	Stock	0.4834	0.4838	0.4816	0.4822	27484000.0
2014-04-24 14:00:00	NVDA	Stock	0.4824	0.4832	0.4812	0.4832	47595560.0
2014-04-24 15:00:00	NVDA	Stock	0.4831	0.4838	0.481	0.4812	79505880.0
2014-04-24 16:00:00	NVDA	Stock	0.4815	0.483	0.4772	0.4816	3167080.0
2014-04-24 17:00:00	NVDA	Stock	0.4815	0.4815	0.4815	0.4815	141760.0
2014-04-24 19:00:00	NVDA	Stock	0.4815	0.4815	0.4815	0.4815	8000.0
2014-04-24 04:00:00	AMZN	Stock	16.495	16.495	16.495	16.495	4000.0
2014-04-24 06:00:00	AMZN	Stock	16.597	16.6	16.521	16.521	22160.0
2014-04-24 07:00:00	AMZN	Stock	16.55	16.55	16.5	16.5335	44600.0
2014-04-24 08:00:00	AMZN	Stock	16.5465	16.55	16.475	16.55	423280.0
2014-04-24 09:00:00	AMZN	Stock	16.564	16.573	16.211	16.2805	17142640.0
2014-04-24 10:00:00	AMZN	Stock	16.2975	16.637	16.1475	16.55	27190360.0
2014-04-24 11:00:00	AMZN	Stock	16.549	16.7465	16.5225	16.7255	16474020.0
2014-04-24 12:00:00	AMZN	Stock	16.719	16.769	16.635	16.7212	9098280.0

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

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