PREVIEW / stock_1hour / 2015-03-02

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-03-02.parquet
  size:    1.1 MB
  rows:    50,655
  symbols: 3,533

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
2015-03-02 04:00:00	AAPL	Stock	32.175	32.375	31.75	32.375	130580.0
2015-03-02 05:00:00	AAPL	Stock	32.315	32.325	32.275	32.325	54952.0
2015-03-02 06:00:00	AAPL	Stock	32.3125	32.3375	32.19	32.2225	158064.0
2015-03-02 07:00:00	AAPL	Stock	32.2225	32.335	32.205	32.255	230944.0
2015-03-02 08:00:00	AAPL	Stock	32.25	32.3075	32.115	32.2475	811336.0
2015-03-02 09:00:00	AAPL	Stock	32.2475	32.515	32.1925	32.4925	32301876.0
2015-03-02 10:00:00	AAPL	Stock	32.4875	32.57	32.3	32.36	30397776.0
2015-03-02 11:00:00	AAPL	Stock	32.36	32.4475	32.2825	32.3925	16421940.0
2015-03-02 12:00:00	AAPL	Stock	32.3925	32.4125	32.1	32.2238	21512736.0
2015-03-02 13:00:00	AAPL	Stock	32.2225	32.2422	32.075	32.2288	16995300.0
2015-03-02 14:00:00	AAPL	Stock	32.2275	32.2288	32.0775	32.1875	18477520.0
2015-03-02 15:00:00	AAPL	Stock	32.19	32.2975	32.1775	32.27	29555036.0
2015-03-02 16:00:00	AAPL	Stock	32.2725	32.3485	32.22	32.2575	16070712.0
2015-03-02 17:00:00	AAPL	Stock	32.255	32.2575	32.2375	32.245	64728.0
2015-03-02 18:00:00	AAPL	Stock	32.2725	32.2725	32.25	32.25	116044.0
2015-03-02 19:00:00	AAPL	Stock	32.2525	32.2575	32.24	32.25	69524.0
2015-03-02 04:00:00	MSFT	Stock	43.84	43.84	43.84	43.84	100.0
2015-03-02 05:00:00	MSFT	Stock	43.84	43.84	43.84	43.84	600.0
2015-03-02 06:00:00	MSFT	Stock	43.84	43.93	43.84	43.85	600.0
2015-03-02 07:00:00	MSFT	Stock	43.84	43.84	43.73	43.73	600.0
2015-03-02 08:00:00	MSFT	Stock	43.85	43.85	43.68	43.78	66641.0
2015-03-02 09:00:00	MSFT	Stock	43.75	43.97	43.55	43.91	3537423.0
2015-03-02 10:00:00	MSFT	Stock	43.91	44.08	43.845	44.01	3424282.0
2015-03-02 11:00:00	MSFT	Stock	44.015	44.19	43.95	44.08	3169488.0
2015-03-02 12:00:00	MSFT	Stock	44.087	44.16	43.96	43.99	2196328.0
2015-03-02 13:00:00	MSFT	Stock	43.99	43.996	43.84	43.865	2307561.0
2015-03-02 14:00:00	MSFT	Stock	43.865	43.87	43.63	43.755	3209184.0
2015-03-02 15:00:00	MSFT	Stock	43.76	43.87	43.71	43.87	6072569.0
2015-03-02 16:00:00	MSFT	Stock	43.88	44.155	43.75	43.88	6378179.0
2015-03-02 17:00:00	MSFT	Stock	43.88	43.88	43.76	43.76	2195.0
2015-03-02 18:00:00	MSFT	Stock	43.88	43.88	43.82	43.82	156803.0
2015-03-02 19:00:00	MSFT	Stock	43.82	43.84	43.82	43.84	900.0
2015-03-02 08:00:00	NVDA	Stock	0.5515	0.5515	0.5515	0.5515	2411200.0
2015-03-02 09:00:00	NVDA	Stock	0.5505	0.5588	0.5493	0.5586	31087600.0
2015-03-02 10:00:00	NVDA	Stock	0.5585	0.564	0.5582	0.5632	61995520.0
2015-03-02 11:00:00	NVDA	Stock	0.5635	0.568	0.5635	0.5664	48979520.0
2015-03-02 12:00:00	NVDA	Stock	0.5665	0.567	0.5635	0.5648	26677640.0
2015-03-02 13:00:00	NVDA	Stock	0.565	0.5652	0.5635	0.564	23575320.0
2015-03-02 14:00:00	NVDA	Stock	0.5641	0.5641	0.562	0.5632	19990440.0
2015-03-02 15:00:00	NVDA	Stock	0.5632	0.565	0.5625	0.565	52292120.0
2015-03-02 16:00:00	NVDA	Stock	0.5649	0.5658	0.5612	0.565	13008280.0
2015-03-02 17:00:00	NVDA	Stock	0.5665	0.5675	0.5665	0.5675	42000.0
2015-03-02 19:00:00	NVDA	Stock	0.5628	0.5628	0.5628	0.5628	8000.0
2015-03-02 07:00:00	AMZN	Stock	19.002	19.0125	18.9615	18.9615	24520.0
2015-03-02 08:00:00	AMZN	Stock	19.025	19.025	18.975	19.0	52220.0
2015-03-02 09:00:00	AMZN	Stock	19.0045	19.2275	18.9741	19.212	8232380.0
2015-03-02 10:00:00	AMZN	Stock	19.212	19.2706	19.1825	19.2345	7193200.0
2015-03-02 11:00:00	AMZN	Stock	19.2385	19.291	19.202	19.2444	4204420.0
2015-03-02 12:00:00	AMZN	Stock	19.2495	19.2565	19.153	19.228	2698540.0
2015-03-02 13:00:00	AMZN	Stock	19.2285	19.2835	19.1995	19.28	3044920.0

> showing 50 of 50,655 rows — these rows as CSV

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