PREVIEW / stock_1hour / 2014-06-17

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-06-17.parquet
  size:    1.0 MB
  rows:    48,541
  symbols: 3,553

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-06-17 04:00:00	AAPL	Stock	23.0825	23.1875	23.0825	23.145	39216.0
2014-06-17 05:00:00	AAPL	Stock	23.125	23.1475	23.125	23.1475	13096.0
2014-06-17 06:00:00	AAPL	Stock	23.1325	23.1475	23.125	23.135	30232.0
2014-06-17 07:00:00	AAPL	Stock	23.1325	23.2	23.1	23.15	262248.0
2014-06-17 08:00:00	AAPL	Stock	23.1475	23.1975	23.075	23.0825	832556.0
2014-06-17 09:00:00	AAPL	Stock	23.0875	23.175	22.965	23.0722	22062144.0
2014-06-17 10:00:00	AAPL	Stock	23.0725	23.1	23.0125	23.0208	15829636.0
2014-06-17 11:00:00	AAPL	Stock	23.02	23.06	22.95	23.0455	14739460.0
2014-06-17 12:00:00	AAPL	Stock	23.045	23.085	23.02	23.0638	10365924.0
2014-06-17 13:00:00	AAPL	Stock	23.0625	23.105	23.0375	23.09	8270452.0
2014-06-17 14:00:00	AAPL	Stock	23.0925	23.0925	23.0325	23.0425	9117156.0
2014-06-17 15:00:00	AAPL	Stock	23.045	23.065	22.9825	23.02	19760720.0
2014-06-17 16:00:00	AAPL	Stock	23.02	23.088	23.005	23.0825	5916444.0
2014-06-17 17:00:00	AAPL	Stock	23.01	23.05	23.0075	23.02	66736.0
2014-06-17 18:00:00	AAPL	Stock	23.02	23.0375	23.02	23.025	61916.0
2014-06-17 19:00:00	AAPL	Stock	23.015	23.025	22.995	23.0	77276.0
2014-06-17 05:00:00	MSFT	Stock	41.55	41.55	41.55	41.55	465.0
2014-06-17 07:00:00	MSFT	Stock	41.39	41.39	41.39	41.39	100.0
2014-06-17 08:00:00	MSFT	Stock	41.55	41.55	41.5	41.5	1503.0
2014-06-17 09:00:00	MSFT	Stock	41.45	41.65	41.2	41.615	2777114.0
2014-06-17 10:00:00	MSFT	Stock	41.62	41.84	41.61	41.68	4304792.0
2014-06-17 11:00:00	MSFT	Stock	41.68	41.74	41.54	41.735	2233561.0
2014-06-17 12:00:00	MSFT	Stock	41.73	41.82	41.379	41.785	1537336.0
2014-06-17 13:00:00	MSFT	Stock	41.79	41.91	41.74	41.795	1993114.0
2014-06-17 14:00:00	MSFT	Stock	41.8	41.85	41.76	41.82	1399544.0
2014-06-17 15:00:00	MSFT	Stock	41.83	41.83	40.335	41.68	5090121.0
2014-06-17 16:00:00	MSFT	Stock	41.68	41.68	41.65	41.67	2158479.0
2014-06-17 17:00:00	MSFT	Stock	41.65	41.65	41.6	41.6	2500.0
2014-06-17 18:00:00	MSFT	Stock	41.6	41.65	41.6	41.65	5100.0
2014-06-17 19:00:00	MSFT	Stock	41.6	41.6	41.6	41.6	200.0
2014-06-17 09:00:00	NVDA	Stock	0.4875	0.491	0.4843	0.4889	24136000.0
2014-06-17 10:00:00	NVDA	Stock	0.489	0.4918	0.4883	0.4902	24304480.0
2014-06-17 11:00:00	NVDA	Stock	0.4902	0.4915	0.489	0.4912	12415480.0
2014-06-17 12:00:00	NVDA	Stock	0.491	0.4912	0.4898	0.49	21280920.0
2014-06-17 13:00:00	NVDA	Stock	0.4902	0.4923	0.4892	0.4902	26893400.0
2014-06-17 14:00:00	NVDA	Stock	0.4902	0.491	0.4898	0.4902	11699800.0
2014-06-17 15:00:00	NVDA	Stock	0.4902	0.4908	0.4895	0.49	26080200.0
2014-06-17 16:00:00	NVDA	Stock	0.4902	0.4902	0.4902	0.4902	1103720.0
2014-06-17 18:00:00	NVDA	Stock	0.4902	0.4902	0.4902	0.4902	4000.0
2014-06-17 07:00:00	AMZN	Stock	16.403	16.43	16.4005	16.4015	12000.0
2014-06-17 08:00:00	AMZN	Stock	16.425	16.447	16.3855	16.3855	102420.0
2014-06-17 09:00:00	AMZN	Stock	16.395	16.567	16.3145	16.471	10814020.0
2014-06-17 10:00:00	AMZN	Stock	16.4615	16.4725	16.299	16.3441	9849560.0
2014-06-17 11:00:00	AMZN	Stock	16.352	16.37	16.2615	16.343	6049760.0
2014-06-17 12:00:00	AMZN	Stock	16.3435	16.381	16.313	16.3402	3661920.0
2014-06-17 13:00:00	AMZN	Stock	16.3465	16.351	16.3025	16.3245	3224640.0
2014-06-17 14:00:00	AMZN	Stock	16.321	16.355	16.3	16.3095	4073420.0
2014-06-17 15:00:00	AMZN	Stock	16.315	16.335	16.277	16.281	12847680.0
2014-06-17 16:00:00	AMZN	Stock	16.281	16.3588	16.281	16.281	1687780.0
2014-06-17 17:00:00	AMZN	Stock	16.281	16.301	16.2805	16.301	15000.0

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

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