PREVIEW / stock_1hour / 2014-02-05

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-02-05.parquet
  size:    1.0 MB
  rows:    49,586
  symbols: 3,536

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-02-05 04:00:00	AAPL	Stock	18.1786	18.1786	18.1786	18.1786	2800.0
2014-02-05 05:00:00	AAPL	Stock	18.1646	18.17	18.1575	18.17	16800.0
2014-02-05 06:00:00	AAPL	Stock	18.1089	18.1429	18.1071	18.1161	64988.0
2014-02-05 07:00:00	AAPL	Stock	18.1143	18.1407	18.0882	18.0882	94668.0
2014-02-05 08:00:00	AAPL	Stock	18.0993	18.1393	18.0382	18.125	1607620.0
2014-02-05 09:00:00	AAPL	Stock	18.1264	18.2454	18.0804	18.1786	39287612.0
2014-02-05 10:00:00	AAPL	Stock	18.1786	18.2946	18.14	18.2303	56512456.0
2014-02-05 11:00:00	AAPL	Stock	18.2282	18.3314	18.2143	18.3262	29916236.0
2014-02-05 12:00:00	AAPL	Stock	18.3261	18.3761	18.3229	18.3604	31456320.0
2014-02-05 13:00:00	AAPL	Stock	18.3586	18.4029	18.3502	18.3857	20608448.0
2014-02-05 14:00:00	AAPL	Stock	18.3761	18.3961	18.3336	18.3411	19085164.0
2014-02-05 15:00:00	AAPL	Stock	18.3429	18.3725	18.3036	18.3075	36886668.0
2014-02-05 16:00:00	AAPL	Stock	18.3068	18.3362	18.142	18.3082	15210160.0
2014-02-05 17:00:00	AAPL	Stock	18.3086	18.3161	18.2893	18.2961	500948.0
2014-02-05 18:00:00	AAPL	Stock	18.2929	18.3082	18.2893	18.2893	204036.0
2014-02-05 19:00:00	AAPL	Stock	18.2961	18.3036	18.2921	18.3032	483028.0
2014-02-05 04:00:00	MSFT	Stock	36.4	36.42	36.39	36.42	1850.0
2014-02-05 05:00:00	MSFT	Stock	36.42	36.46	36.42	36.46	500.0
2014-02-05 06:00:00	MSFT	Stock	36.42	36.42	36.21	36.21	2688.0
2014-02-05 07:00:00	MSFT	Stock	36.3	36.4	36.25	36.3	18550.0
2014-02-05 08:00:00	MSFT	Stock	36.3	36.4	36.21	36.4	21852.0
2014-02-05 09:00:00	MSFT	Stock	36.43	36.49	36.17	36.28	5242160.0
2014-02-05 10:00:00	MSFT	Stock	36.27	36.43	35.85	35.97	9973846.0
2014-02-05 11:00:00	MSFT	Stock	35.97	36.04	35.8	35.95	11306001.0
2014-02-05 12:00:00	MSFT	Stock	35.96	36.16	35.955	36.155	3405655.0
2014-02-05 13:00:00	MSFT	Stock	36.155	36.24	35.95	35.99	3864493.0
2014-02-05 14:00:00	MSFT	Stock	35.98	36.05	35.88	35.91	3229503.0
2014-02-05 15:00:00	MSFT	Stock	35.905	35.98	35.8	35.83	9307393.0
2014-02-05 16:00:00	MSFT	Stock	35.82	36.35	35.77	35.83	4037418.0
2014-02-05 17:00:00	MSFT	Stock	35.82	35.992	35.81	35.81	52024.0
2014-02-05 18:00:00	MSFT	Stock	35.81	35.84	35.8	35.84	15156.0
2014-02-05 19:00:00	MSFT	Stock	35.84	35.84	35.75	35.83	8880.0
2014-02-05 09:00:00	NVDA	Stock	0.3868	0.388	0.3854	0.3858	26740520.0
2014-02-05 10:00:00	NVDA	Stock	0.3858	0.387	0.3835	0.3848	45182840.0
2014-02-05 11:00:00	NVDA	Stock	0.3848	0.3855	0.383	0.385	26357160.0
2014-02-05 12:00:00	NVDA	Stock	0.3849	0.3859	0.384	0.3853	22055000.0
2014-02-05 13:00:00	NVDA	Stock	0.3853	0.387	0.3853	0.3853	9001760.0
2014-02-05 14:00:00	NVDA	Stock	0.3853	0.3855	0.3839	0.3842	20657240.0
2014-02-05 15:00:00	NVDA	Stock	0.3844	0.387	0.3842	0.386	52237160.0
2014-02-05 16:00:00	NVDA	Stock	0.386	0.3862	0.386	0.3861	10253440.0
2014-02-05 17:00:00	NVDA	Stock	0.386	0.386	0.386	0.386	148120.0
2014-02-05 04:00:00	AMZN	Stock	17.407	17.407	17.407	17.407	4000.0
2014-02-05 05:00:00	AMZN	Stock	17.375	17.375	17.325	17.3625	6000.0
2014-02-05 06:00:00	AMZN	Stock	17.3575	17.3625	17.35	17.35	6000.0
2014-02-05 07:00:00	AMZN	Stock	17.311	17.311	17.25	17.25	6000.0
2014-02-05 08:00:00	AMZN	Stock	17.3225	17.367	17.254	17.324	280400.0
2014-02-05 09:00:00	AMZN	Stock	17.325	17.3975	17.154	17.18	10576900.0
2014-02-05 10:00:00	AMZN	Stock	17.1795	17.2685	16.8865	17.0885	23181640.0
2014-02-05 11:00:00	AMZN	Stock	17.0845	17.2545	16.983	17.2228	10040520.0
2014-02-05 12:00:00	AMZN	Stock	17.2235	17.2625	17.163	17.2438	4985540.0

> showing 50 of 49,586 rows — these rows as CSV

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