PREVIEW / stock_1hour / 2017-09-26

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-09-26.parquet
  size:    1.0 MB
  rows:    47,580
  symbols: 2,951

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
2017-09-26 04:00:00	AAPL	Stock	37.6475	37.8	37.6475	37.7925	18380.0
2017-09-26 05:00:00	AAPL	Stock	37.795	37.885	37.775	37.8625	56888.0
2017-09-26 06:00:00	AAPL	Stock	37.86	37.895	37.8175	37.875	78440.0
2017-09-26 07:00:00	AAPL	Stock	37.88	38.0	37.8275	37.9	456480.0
2017-09-26 08:00:00	AAPL	Stock	37.9475	38.0	37.8275	37.975	723768.0
2017-09-26 09:00:00	AAPL	Stock	37.9625	38.1925	37.9225	38.04	20748264.0
2017-09-26 10:00:00	AAPL	Stock	38.0418	38.255	38.035	38.13	20682684.0
2017-09-26 11:00:00	AAPL	Stock	38.13	38.13	37.945	38.13	17599756.0
2017-09-26 12:00:00	AAPL	Stock	38.13	38.1925	38.025	38.14	11040268.0
2017-09-26 13:00:00	AAPL	Stock	38.1425	38.4525	38.1405	38.4275	15800840.0
2017-09-26 14:00:00	AAPL	Stock	38.4275	38.48	38.328	38.3412	12562364.0
2017-09-26 15:00:00	AAPL	Stock	38.3425	38.4525	38.26	38.305	18169788.0
2017-09-26 16:00:00	AAPL	Stock	38.3175	38.3275	38.275	38.315	8407060.0
2017-09-26 17:00:00	AAPL	Stock	38.295	38.3175	38.28	38.2975	32544.0
2017-09-26 18:00:00	AAPL	Stock	38.2975	38.3225	38.2825	38.315	38600.0
2017-09-26 19:00:00	AAPL	Stock	38.305	38.3425	38.3	38.3425	79084.0
2017-09-26 04:00:00	MSFT	Stock	73.5	73.77	73.5	73.67	3758.0
2017-09-26 06:00:00	MSFT	Stock	73.7	73.7	73.51	73.51	3263.0
2017-09-26 07:00:00	MSFT	Stock	73.61	73.61	73.52	73.54	8760.0
2017-09-26 08:00:00	MSFT	Stock	73.67	73.71	73.5	73.71	5078.0
2017-09-26 09:00:00	MSFT	Stock	73.71	73.739	73.475	73.66	1546878.0
2017-09-26 10:00:00	MSFT	Stock	73.66	73.81	73.31	73.38	1750772.0
2017-09-26 11:00:00	MSFT	Stock	73.39	73.396	72.99	73.025	2402913.0
2017-09-26 12:00:00	MSFT	Stock	73.025	73.32	73.01	73.25	1205713.0
2017-09-26 13:00:00	MSFT	Stock	73.24	73.54	73.22	73.43	1558298.0
2017-09-26 14:00:00	MSFT	Stock	73.43	73.5	73.321	73.43	1022248.0
2017-09-26 15:00:00	MSFT	Stock	73.43	73.53	73.18	73.3	2703098.0
2017-09-26 16:00:00	MSFT	Stock	73.26	73.26	73.25	73.25	3292590.0
2017-09-26 17:00:00	MSFT	Stock	73.32	73.32	73.32	73.32	278.0
2017-09-26 18:00:00	MSFT	Stock	73.26	73.3	73.26	73.3	1800.0
2017-09-26 19:00:00	MSFT	Stock	73.28	73.35	73.28	73.32	2952.0
2017-09-26 04:00:00	NVDA	Stock	4.2958	4.35	4.2958	4.3493	456480.0
2017-09-26 05:00:00	NVDA	Stock	4.3493	4.36	4.3438	4.36	299200.0
2017-09-26 06:00:00	NVDA	Stock	4.3662	4.4075	4.3662	4.3895	921120.0
2017-09-26 07:00:00	NVDA	Stock	4.3875	4.4175	4.3733	4.3982	7275520.0
2017-09-26 08:00:00	NVDA	Stock	4.3982	4.4167	4.2838	4.402	9100280.0
2017-09-26 09:00:00	NVDA	Stock	4.4023	4.467	4.3788	4.4232	217664080.0
2017-09-26 10:00:00	NVDA	Stock	4.4202	4.4468	4.3608	4.364	185236520.0
2017-09-26 11:00:00	NVDA	Stock	4.3648	4.3649	4.307	4.3472	178868840.0
2017-09-26 12:00:00	NVDA	Stock	4.3478	4.3703	4.3365	4.355	78146120.0
2017-09-26 13:00:00	NVDA	Stock	4.356	4.3835	4.3272	4.329	98941680.0
2017-09-26 14:00:00	NVDA	Stock	4.3295	4.3395	4.3188	4.3289	83268560.0
2017-09-26 15:00:00	NVDA	Stock	4.3295	4.3425	4.2588	4.299	223788320.0
2017-09-26 16:00:00	NVDA	Stock	4.299	4.3125	4.2932	4.2932	14771800.0
2017-09-26 17:00:00	NVDA	Stock	4.3013	4.3062	4.2928	4.304	1206880.0
2017-09-26 18:00:00	NVDA	Stock	4.3038	4.312	4.3025	4.3085	565560.0
2017-09-26 19:00:00	NVDA	Stock	4.3088	4.3275	4.3085	4.325	797440.0
2017-09-26 05:00:00	AMZN	Stock	47.1935	47.1935	47.1935	47.1935	2000.0
2017-09-26 06:00:00	AMZN	Stock	47.1885	47.1885	47.1885	47.1885	2000.0
2017-09-26 07:00:00	AMZN	Stock	47.175	47.2255	47.15	47.205	50620.0

> showing 50 of 47,580 rows — these rows as CSV

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