PREVIEW / stock_1hour / 2018-07-27

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-07-27.parquet
  size:    1.1 MB
  rows:    48,209
  symbols: 2,774

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
2018-07-27 04:00:00	AAPL	Stock	48.65	48.7725	48.65	48.75	9780.0
2018-07-27 05:00:00	AAPL	Stock	48.7425	48.75	48.69	48.7	7948.0
2018-07-27 06:00:00	AAPL	Stock	48.7125	48.7125	48.7125	48.7125	400.0
2018-07-27 07:00:00	AAPL	Stock	48.6975	48.755	48.6625	48.6875	143444.0
2018-07-27 08:00:00	AAPL	Stock	48.745	48.7875	48.67	48.7875	381168.0
2018-07-27 09:00:00	AAPL	Stock	48.7875	48.7975	48.595	48.6175	8455308.0
2018-07-27 10:00:00	AAPL	Stock	48.6125	48.6555	48.28	48.3975	11148948.0
2018-07-27 11:00:00	AAPL	Stock	48.3975	48.5097	48.3475	48.3825	6188452.0
2018-07-27 12:00:00	AAPL	Stock	48.38	48.395	47.925	47.95	10616756.0
2018-07-27 13:00:00	AAPL	Stock	47.9487	48.0125	47.7975	47.965	9256184.0
2018-07-27 14:00:00	AAPL	Stock	47.9575	48.0075	47.54	47.5488	11199524.0
2018-07-27 15:00:00	AAPL	Stock	47.5475	47.8	47.525	47.745	17353288.0
2018-07-27 16:00:00	AAPL	Stock	47.745	47.75	47.6625	47.705	6522740.0
2018-07-27 17:00:00	AAPL	Stock	47.7075	47.7475	47.6875	47.745	78280.0
2018-07-27 18:00:00	AAPL	Stock	47.745	47.7875	47.745	47.745	85272.0
2018-07-27 19:00:00	AAPL	Stock	47.75	47.785	47.745	47.745	34348.0
2018-07-27 04:00:00	MSFT	Stock	110.39	110.39	110.2	110.2	600.0
2018-07-27 05:00:00	MSFT	Stock	110.3	110.39	110.29	110.29	2600.0
2018-07-27 06:00:00	MSFT	Stock	110.4	110.4	110.4	110.4	100.0
2018-07-27 07:00:00	MSFT	Stock	110.1	110.21	109.9	110.04	19775.0
2018-07-27 08:00:00	MSFT	Stock	110.19	110.25	109.81	110.25	38655.0
2018-07-27 09:00:00	MSFT	Stock	110.24	110.44	109.18	109.19	3142597.0
2018-07-27 10:00:00	MSFT	Stock	109.19	109.355	108.925	109.16	3808396.0
2018-07-27 11:00:00	MSFT	Stock	109.15	109.25	108.11	108.145	3520192.0
2018-07-27 12:00:00	MSFT	Stock	108.145	108.145	106.57	106.59	6878854.0
2018-07-27 13:00:00	MSFT	Stock	106.57	108.0	106.14	107.91	5767875.0
2018-07-27 14:00:00	MSFT	Stock	107.918	107.95	107.18	107.195	3551417.0
2018-07-27 15:00:00	MSFT	Stock	107.19	107.89	107.19	107.67	4924749.0
2018-07-27 16:00:00	MSFT	Stock	107.68	107.98	107.57	107.68	2569912.0
2018-07-27 17:00:00	MSFT	Stock	107.68	107.87	107.68	107.79	3908.0
2018-07-27 18:00:00	MSFT	Stock	107.74	107.77	107.6	107.77	1106.0
2018-07-27 19:00:00	MSFT	Stock	107.71	107.71	107.5	107.55	6765.0
2018-07-27 04:00:00	NVDA	Stock	6.4125	6.4125	6.4108	6.4108	12040.0
2018-07-27 05:00:00	NVDA	Stock	6.4125	6.4125	6.4125	6.4125	4080.0
2018-07-27 07:00:00	NVDA	Stock	6.4188	6.4188	6.407	6.412	255080.0
2018-07-27 08:00:00	NVDA	Stock	6.4188	6.422	6.4037	6.4125	992240.0
2018-07-27 09:00:00	NVDA	Stock	6.4165	6.4165	6.35	6.3502	42683640.0
2018-07-27 10:00:00	NVDA	Stock	6.3543	6.4075	6.3463	6.3738	43754320.0
2018-07-27 11:00:00	NVDA	Stock	6.3738	6.3943	6.3525	6.3635	29526760.0
2018-07-27 12:00:00	NVDA	Stock	6.3648	6.3648	6.2582	6.2602	35414960.0
2018-07-27 13:00:00	NVDA	Stock	6.2598	6.3187	6.246	6.317	34956480.0
2018-07-27 14:00:00	NVDA	Stock	6.3171	6.318	6.2665	6.279	17646160.0
2018-07-27 15:00:00	NVDA	Stock	6.2805	6.315	6.2805	6.2998	28528520.0
2018-07-27 16:00:00	NVDA	Stock	6.3005	6.31	6.2975	6.3055	15284000.0
2018-07-27 17:00:00	NVDA	Stock	6.305	6.305	6.295	6.3005	199160.0
2018-07-27 18:00:00	NVDA	Stock	6.2995	6.3125	6.2995	6.3125	47120.0
2018-07-27 19:00:00	NVDA	Stock	6.3025	6.3025	6.2878	6.288	67920.0
2018-07-27 04:00:00	AMZN	Stock	93.4505	93.95	93.45	93.95	116720.0
2018-07-27 05:00:00	AMZN	Stock	93.9895	94.143	93.9895	94.0	152820.0
2018-07-27 06:00:00	AMZN	Stock	94.0	94.8	94.0	94.75	130660.0

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

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