PREVIEW / stock_1hour / 2016-12-07

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-12-07.parquet
  size:    1.1 MB
  rows:    49,156
  symbols: 3,168

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
2016-12-07 04:00:00	AAPL	Stock	27.52	27.52	27.52	27.52	800.0
2016-12-07 05:00:00	AAPL	Stock	27.525	27.5625	27.525	27.5625	2496.0
2016-12-07 06:00:00	AAPL	Stock	27.525	27.5325	27.525	27.525	4992.0
2016-12-07 07:00:00	AAPL	Stock	27.5225	27.5225	27.2625	27.2625	149476.0
2016-12-07 08:00:00	AAPL	Stock	27.31	27.515	27.2075	27.28	361336.0
2016-12-07 09:00:00	AAPL	Stock	27.2875	27.4725	27.2825	27.3625	11337488.0
2016-12-07 10:00:00	AAPL	Stock	27.36	27.5225	27.345	27.465	16309912.0
2016-12-07 11:00:00	AAPL	Stock	27.4675	27.5125	27.354	27.4262	11786800.0
2016-12-07 12:00:00	AAPL	Stock	27.4275	27.545	27.3975	27.54	9213856.0
2016-12-07 13:00:00	AAPL	Stock	27.5418	27.735	27.5375	27.71	15596516.0
2016-12-07 14:00:00	AAPL	Stock	27.71	27.755	27.6425	27.71	12921844.0
2016-12-07 15:00:00	AAPL	Stock	27.7125	27.7975	27.6912	27.7525	21560212.0
2016-12-07 16:00:00	AAPL	Stock	27.7575	27.7625	27.7125	27.725	11287360.0
2016-12-07 17:00:00	AAPL	Stock	27.7125	27.7575	27.7125	27.725	122168.0
2016-12-07 18:00:00	AAPL	Stock	27.725	27.725	27.7	27.7125	9672.0
2016-12-07 19:00:00	AAPL	Stock	27.7225	27.725	27.71	27.7125	28380.0
2016-12-07 06:00:00	MSFT	Stock	60.2	60.21	60.2	60.21	250.0
2016-12-07 07:00:00	MSFT	Stock	60.0	60.0	60.0	60.0	400.0
2016-12-07 08:00:00	MSFT	Stock	59.98	59.98	59.9	59.94	1828.0
2016-12-07 09:00:00	MSFT	Stock	59.96	60.04	59.8	59.837	2044787.0
2016-12-07 10:00:00	MSFT	Stock	59.835	60.32	59.81	60.24	2512896.0
2016-12-07 11:00:00	MSFT	Stock	60.25	60.315	60.05	60.25	2531589.0
2016-12-07 12:00:00	MSFT	Stock	60.25	60.63	60.22	60.62	2064273.0
2016-12-07 13:00:00	MSFT	Stock	60.629	60.88	60.61	60.82	3045332.0
2016-12-07 14:00:00	MSFT	Stock	60.825	61.25	60.77	61.25	3987687.0
2016-12-07 15:00:00	MSFT	Stock	61.24	61.38	61.14	61.36	7705673.0
2016-12-07 16:00:00	MSFT	Stock	61.37	61.37	61.26	61.35	3929287.0
2016-12-07 17:00:00	MSFT	Stock	61.37	61.37	61.22	61.22	947447.0
2016-12-07 18:00:00	MSFT	Stock	61.26	61.26	61.26	61.26	100.0
2016-12-07 19:00:00	MSFT	Stock	61.26	61.32	61.26	61.32	493.0
2016-12-07 07:00:00	NVDA	Stock	2.3425	2.3425	2.3382	2.3425	66120.0
2016-12-07 08:00:00	NVDA	Stock	2.3378	2.34	2.33	2.3313	335520.0
2016-12-07 09:00:00	NVDA	Stock	2.3313	2.3332	2.3025	2.3245	46894440.0
2016-12-07 10:00:00	NVDA	Stock	2.3242	2.3582	2.3175	2.3422	72620080.0
2016-12-07 11:00:00	NVDA	Stock	2.3415	2.3478	2.3313	2.3428	51157160.0
2016-12-07 12:00:00	NVDA	Stock	2.3425	2.3534	2.335	2.3534	56938080.0
2016-12-07 13:00:00	NVDA	Stock	2.3538	2.36	2.3473	2.3546	38942600.0
2016-12-07 14:00:00	NVDA	Stock	2.3542	2.3745	2.3497	2.3638	58084840.0
2016-12-07 15:00:00	NVDA	Stock	2.3638	2.3825	2.3605	2.3768	109242280.0
2016-12-07 16:00:00	NVDA	Stock	2.3768	2.3785	2.3518	2.3765	23904720.0
2016-12-07 17:00:00	NVDA	Stock	2.375	2.3763	2.373	2.3763	224440.0
2016-12-07 18:00:00	NVDA	Stock	2.37	2.3755	2.3672	2.3755	298160.0
2016-12-07 19:00:00	NVDA	Stock	2.3748	2.3748	2.3742	2.3742	18720.0
2016-12-07 06:00:00	AMZN	Stock	38.25	38.25	38.25	38.25	4360.0
2016-12-07 07:00:00	AMZN	Stock	38.245	38.245	38.235	38.2415	19500.0
2016-12-07 08:00:00	AMZN	Stock	38.2	38.2	38.1015	38.125	32260.0
2016-12-07 09:00:00	AMZN	Stock	38.125	38.25	37.791	37.8345	10250140.0
2016-12-07 10:00:00	AMZN	Stock	37.8256	38.136	37.802	38.124	9550880.0
2016-12-07 11:00:00	AMZN	Stock	38.131	38.293	38.107	38.26	7966640.0
2016-12-07 12:00:00	AMZN	Stock	38.2725	38.3	38.1397	38.286	4537320.0

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

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