PREVIEW / stock_1hour / 2014-10-03

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-10-03.parquet
  size:    1.0 MB
  rows:    48,158
  symbols: 3,576

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-10-03 04:00:00	AAPL	Stock	24.8125	24.85	24.75	24.85	44904.0
2014-10-03 05:00:00	AAPL	Stock	24.85	24.9125	24.79	24.79	74840.0
2014-10-03 06:00:00	AAPL	Stock	24.79	24.8725	24.7875	24.825	81256.0
2014-10-03 07:00:00	AAPL	Stock	24.825	24.9125	24.825	24.8775	244524.0
2014-10-03 08:00:00	AAPL	Stock	24.88	24.975	24.8	24.8675	2297880.0
2014-10-03 09:00:00	AAPL	Stock	24.865	24.955	24.76	24.92	31537312.0
2014-10-03 10:00:00	AAPL	Stock	24.9225	25.0525	24.845	24.955	33455888.0
2014-10-03 11:00:00	AAPL	Stock	24.9525	24.9675	24.8525	24.885	14261436.0
2014-10-03 12:00:00	AAPL	Stock	24.8862	24.9875	24.875	24.965	16017648.0
2014-10-03 13:00:00	AAPL	Stock	24.965	24.995	24.9478	24.9562	15254952.0
2014-10-03 14:00:00	AAPL	Stock	24.96	24.9918	24.9525	24.9725	13167868.0
2014-10-03 15:00:00	AAPL	Stock	24.9725	24.9975	24.89	24.9025	27753364.0
2014-10-03 16:00:00	AAPL	Stock	24.905	24.9788	24.89	24.9175	10537660.0
2014-10-03 17:00:00	AAPL	Stock	24.905	24.965	24.9025	24.915	80396.0
2014-10-03 18:00:00	AAPL	Stock	24.92	24.925	24.905	24.925	66740.0
2014-10-03 19:00:00	AAPL	Stock	24.925	24.925	24.8975	24.915	77256.0
2014-10-03 07:00:00	MSFT	Stock	46.12	46.17	46.11	46.15	10126.0
2014-10-03 08:00:00	MSFT	Stock	46.13	46.15	45.76	46.1	230081.0
2014-10-03 09:00:00	MSFT	Stock	46.05	46.09	45.61	45.959	3683137.0
2014-10-03 10:00:00	MSFT	Stock	45.96	46.09	45.9	45.99	4805816.0
2014-10-03 11:00:00	MSFT	Stock	45.99	46.01	45.79	45.82	4585126.0
2014-10-03 12:00:00	MSFT	Stock	45.82	46.05	45.79	46.024	2729160.0
2014-10-03 13:00:00	MSFT	Stock	46.02	46.055	45.94	46.04	2344997.0
2014-10-03 14:00:00	MSFT	Stock	46.04	46.265	46.04	46.23	3147050.0
2014-10-03 15:00:00	MSFT	Stock	46.22	46.3	46.06	46.07	6476171.0
2014-10-03 16:00:00	MSFT	Stock	46.09	46.15	46.021	46.06	3309950.0
2014-10-03 17:00:00	MSFT	Stock	46.17	46.17	46.17	46.17	470.0
2014-10-03 18:00:00	MSFT	Stock	46.09	46.13	46.09	46.13	101537.0
2014-10-03 08:00:00	NVDA	Stock	0.4548	0.4548	0.4548	0.4548	658240.0
2014-10-03 09:00:00	NVDA	Stock	0.4588	0.4638	0.4563	0.4622	36782920.0
2014-10-03 10:00:00	NVDA	Stock	0.4622	0.4638	0.4612	0.4628	26161760.0
2014-10-03 11:00:00	NVDA	Stock	0.4625	0.4635	0.4593	0.4598	27864960.0
2014-10-03 12:00:00	NVDA	Stock	0.4595	0.4625	0.4593	0.4618	14196040.0
2014-10-03 13:00:00	NVDA	Stock	0.4619	0.462	0.4584	0.4595	10615760.0
2014-10-03 14:00:00	NVDA	Stock	0.4593	0.4598	0.4582	0.4589	16631680.0
2014-10-03 15:00:00	NVDA	Stock	0.4589	0.459	0.4558	0.4558	66077040.0
2014-10-03 16:00:00	NVDA	Stock	0.456	0.4568	0.4558	0.4568	17801160.0
2014-10-03 08:00:00	AMZN	Stock	15.9205	16.075	15.9205	16.025	392280.0
2014-10-03 09:00:00	AMZN	Stock	16.025	16.1175	15.9765	16.1095	9765120.0
2014-10-03 10:00:00	AMZN	Stock	16.1135	16.1875	16.067	16.1845	12235420.0
2014-10-03 11:00:00	AMZN	Stock	16.1805	16.258	16.1505	16.1545	8616020.0
2014-10-03 12:00:00	AMZN	Stock	16.155	16.2435	16.1416	16.2075	4014660.0
2014-10-03 13:00:00	AMZN	Stock	16.2045	16.225	16.1185	16.175	4224540.0
2014-10-03 14:00:00	AMZN	Stock	16.178	16.199	16.15	16.1806	3721060.0
2014-10-03 15:00:00	AMZN	Stock	16.18	16.204	16.1305	16.1355	9089480.0
2014-10-03 16:00:00	AMZN	Stock	16.137	16.1643	16.12	16.137	972520.0
2014-10-03 17:00:00	AMZN	Stock	16.137	16.137	16.137	16.137	18420.0
2014-10-03 18:00:00	AMZN	Stock	16.1225	16.1225	16.1225	16.1225	6500.0
2014-10-03 07:00:00	GOOGL	Stock	29.2265	29.2265	29.2265	29.2265	2000.0
2014-10-03 08:00:00	GOOGL	Stock	29.2265	29.315	29.044	29.2625	207840.0

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

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