PREVIEW / stock_1hour / 2015-07-02

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-07-02.parquet
  size:    1.0 MB
  rows:    48,379
  symbols: 3,483

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-07-02 04:00:00	AAPL	Stock	31.6975	31.77	31.6975	31.725	6504.0
2015-07-02 05:00:00	AAPL	Stock	31.7025	31.7025	31.7025	31.7025	400.0
2015-07-02 06:00:00	AAPL	Stock	31.675	31.685	31.4475	31.655	51040.0
2015-07-02 07:00:00	AAPL	Stock	31.6625	31.6675	31.6125	31.65	63660.0
2015-07-02 08:00:00	AAPL	Stock	31.6325	31.7	31.6125	31.6675	459708.0
2015-07-02 09:00:00	AAPL	Stock	31.6725	31.6725	31.5525	31.555	15891400.0
2015-07-02 10:00:00	AAPL	Stock	31.555	31.5825	31.5125	31.5425	15498404.0
2015-07-02 11:00:00	AAPL	Stock	31.545	31.55	31.4425	31.4925	13588088.0
2015-07-02 12:00:00	AAPL	Stock	31.4925	31.5125	31.4525	31.505	7826056.0
2015-07-02 13:00:00	AAPL	Stock	31.5025	31.5425	31.4725	31.52	9147836.0
2015-07-02 14:00:00	AAPL	Stock	31.52	31.5575	31.49	31.555	8778188.0
2015-07-02 15:00:00	AAPL	Stock	31.555	31.63	31.5362	31.6	24893692.0
2015-07-02 16:00:00	AAPL	Stock	31.61	31.6225	31.5622	31.58	6576392.0
2015-07-02 17:00:00	AAPL	Stock	31.58	31.59	31.5775	31.59	37020.0
2015-07-02 18:00:00	AAPL	Stock	31.59	31.61	31.58	31.58	37188.0
2015-07-02 19:00:00	AAPL	Stock	31.5875	31.5975	31.575	31.585	69252.0
2015-07-02 04:00:00	MSFT	Stock	44.63	44.63	44.63	44.63	100.0
2015-07-02 08:00:00	MSFT	Stock	44.58	44.69	44.56	44.68	1989.0
2015-07-02 09:00:00	MSFT	Stock	44.56	44.75	44.47	44.57	3025169.0
2015-07-02 10:00:00	MSFT	Stock	44.57	44.59	44.145	44.225	2728975.0
2015-07-02 11:00:00	MSFT	Stock	44.23	44.25	44.11	44.19	2717789.0
2015-07-02 12:00:00	MSFT	Stock	44.19	44.24	44.06	44.16	1582342.0
2015-07-02 13:00:00	MSFT	Stock	44.16	44.24	44.07	44.16	1518427.0
2015-07-02 14:00:00	MSFT	Stock	44.17	44.33	44.13	44.3	1549827.0
2015-07-02 15:00:00	MSFT	Stock	44.3	44.46	44.26	44.39	4791096.0
2015-07-02 16:00:00	MSFT	Stock	44.37	44.4	44.33	44.34	2848387.0
2015-07-02 17:00:00	MSFT	Stock	44.42	44.457	44.42	44.44	4685.0
2015-07-02 18:00:00	MSFT	Stock	44.4	44.4	44.333	44.34	2460.0
2015-07-02 19:00:00	MSFT	Stock	44.37	44.46	44.37	44.46	1200.0
2015-07-02 09:00:00	NVDA	Stock	0.51	0.5118	0.5072	0.5108	16535480.0
2015-07-02 10:00:00	NVDA	Stock	0.511	0.5138	0.5105	0.513	16692920.0
2015-07-02 11:00:00	NVDA	Stock	0.5129	0.5129	0.5085	0.5108	22237640.0
2015-07-02 12:00:00	NVDA	Stock	0.5108	0.5115	0.5085	0.5095	16177200.0
2015-07-02 13:00:00	NVDA	Stock	0.5095	0.5102	0.5082	0.5095	15123280.0
2015-07-02 14:00:00	NVDA	Stock	0.5095	0.5098	0.5078	0.5085	11371560.0
2015-07-02 15:00:00	NVDA	Stock	0.5085	0.5114	0.5082	0.5102	34116320.0
2015-07-02 16:00:00	NVDA	Stock	0.5105	0.5105	0.5105	0.5105	9769880.0
2015-07-02 18:00:00	NVDA	Stock	0.5095	0.5095	0.5095	0.5095	20000.0
2015-07-02 07:00:00	AMZN	Stock	21.9095	21.9095	21.9095	21.9095	4000.0
2015-07-02 08:00:00	AMZN	Stock	21.825	21.9205	21.825	21.9205	14000.0
2015-07-02 09:00:00	AMZN	Stock	21.9	21.907	21.788	21.82	3708240.0
2015-07-02 10:00:00	AMZN	Stock	21.8125	21.8445	21.7025	21.7775	2653020.0
2015-07-02 11:00:00	AMZN	Stock	21.7725	21.783	21.674	21.6925	1465500.0
2015-07-02 12:00:00	AMZN	Stock	21.6885	21.781	21.6815	21.7625	2832700.0
2015-07-02 13:00:00	AMZN	Stock	21.754	21.7985	21.7335	21.779	2500120.0
2015-07-02 14:00:00	AMZN	Stock	21.787	21.8175	21.761	21.81	2347040.0
2015-07-02 15:00:00	AMZN	Stock	21.8125	21.91	21.7995	21.889	6136220.0
2015-07-02 16:00:00	AMZN	Stock	21.886	21.906	21.8805	21.8825	400720.0
2015-07-02 17:00:00	AMZN	Stock	21.9045	21.9045	21.87	21.8845	26000.0
2015-07-02 19:00:00	AMZN	Stock	21.8974	21.8974	21.8974	21.8974	3000.0

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

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