PREVIEW / stock_1hour / 2018-11-01

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-11-01.parquet
  size:    1.1 MB
  rows:    50,075
  symbols: 2,769

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-11-01 04:00:00	AAPL	Stock	54.745	54.955	54.625	54.955	29528.0
2018-11-01 05:00:00	AAPL	Stock	54.9	54.9475	54.85	54.9375	52028.0
2018-11-01 06:00:00	AAPL	Stock	54.9875	55.0975	54.9775	55.0025	120848.0
2018-11-01 07:00:00	AAPL	Stock	55.0	55.125	54.925	54.9825	722984.0
2018-11-01 08:00:00	AAPL	Stock	55.0	55.125	54.7075	54.765	1089896.0
2018-11-01 09:00:00	AAPL	Stock	54.7525	55.0	54.3	54.4275	20866664.0
2018-11-01 10:00:00	AAPL	Stock	54.4475	54.6675	54.2025	54.375	18581368.0
2018-11-01 11:00:00	AAPL	Stock	54.375	54.98	54.3	54.815	16134024.0
2018-11-01 12:00:00	AAPL	Stock	54.8125	54.9975	54.66	54.8115	10207880.0
2018-11-01 13:00:00	AAPL	Stock	54.805	55.215	54.765	55.1025	18159176.0
2018-11-01 14:00:00	AAPL	Stock	55.1	55.1175	54.5575	54.875	15710924.0
2018-11-01 15:00:00	AAPL	Stock	54.8725	55.59	54.8125	55.515	38219580.0
2018-11-01 16:00:00	AAPL	Stock	55.525	55.8725	52.6375	53.25	33393308.0
2018-11-01 17:00:00	AAPL	Stock	53.25	53.275	51.29	51.8375	19160648.0
2018-11-01 18:00:00	AAPL	Stock	51.8475	52.26	51.53	52.0375	4007336.0
2018-11-01 19:00:00	AAPL	Stock	52.0625	52.08	51.7125	51.9525	2646292.0
2018-11-01 04:00:00	MSFT	Stock	107.06	107.06	107.06	107.06	100.0
2018-11-01 05:00:00	MSFT	Stock	107.11	107.11	107.11	107.11	150.0
2018-11-01 06:00:00	MSFT	Stock	107.37	107.5	107.37	107.41	980.0
2018-11-01 07:00:00	MSFT	Stock	107.6	107.71	107.27	107.3	16892.0
2018-11-01 08:00:00	MSFT	Stock	107.7	107.8	106.7	106.8	35514.0
2018-11-01 09:00:00	MSFT	Stock	106.81	107.32	105.85	106.25	3569099.0
2018-11-01 10:00:00	MSFT	Stock	106.23	106.73	105.57	106.45	4661853.0
2018-11-01 11:00:00	MSFT	Stock	106.45	106.588	106.01	106.155	3644046.0
2018-11-01 12:00:00	MSFT	Stock	106.15	106.56	105.88	106.54	3163522.0
2018-11-01 13:00:00	MSFT	Stock	106.54	106.59	106.2	106.348	2475657.0
2018-11-01 14:00:00	MSFT	Stock	106.35	106.39	105.84	106.04	2658230.0
2018-11-01 15:00:00	MSFT	Stock	106.04	106.07	105.53	105.91	6046809.0
2018-11-01 16:00:00	MSFT	Stock	105.91	107.14	105.0	105.68	3733013.0
2018-11-01 17:00:00	MSFT	Stock	105.35	105.92	105.07	105.4	71019.0
2018-11-01 18:00:00	MSFT	Stock	105.38	105.8	105.15	105.5	65773.0
2018-11-01 19:00:00	MSFT	Stock	105.52	105.74	105.4	105.74	11415.0
2018-11-01 04:00:00	NVDA	Stock	5.3038	5.3238	5.3038	5.3238	16000.0
2018-11-01 05:00:00	NVDA	Stock	5.3422	5.345	5.3365	5.3365	28640.0
2018-11-01 06:00:00	NVDA	Stock	5.35	5.375	5.345	5.345	218920.0
2018-11-01 07:00:00	NVDA	Stock	5.3495	5.35	5.323	5.3422	1174320.0
2018-11-01 08:00:00	NVDA	Stock	5.3425	5.35	5.3038	5.304	1776000.0
2018-11-01 09:00:00	NVDA	Stock	5.303	5.3246	5.1798	5.2102	98909920.0
2018-11-01 10:00:00	NVDA	Stock	5.2065	5.3215	5.18	5.3125	81234520.0
2018-11-01 11:00:00	NVDA	Stock	5.313	5.453	5.3088	5.4255	112933640.0
2018-11-01 12:00:00	NVDA	Stock	5.4225	5.4435	5.3648	5.402	49094200.0
2018-11-01 13:00:00	NVDA	Stock	5.402	5.4478	5.395	5.4243	34430160.0
2018-11-01 14:00:00	NVDA	Stock	5.4264	5.448	5.4155	5.438	38195440.0
2018-11-01 15:00:00	NVDA	Stock	5.4375	5.4623	5.4205	5.4515	61647120.0
2018-11-01 16:00:00	NVDA	Stock	5.4515	5.4545	5.35	5.3925	20997280.0
2018-11-01 17:00:00	NVDA	Stock	5.3928	5.4528	5.2803	5.35	4029480.0
2018-11-01 18:00:00	NVDA	Stock	5.3553	5.4325	5.3515	5.3838	974360.0
2018-11-01 19:00:00	NVDA	Stock	5.3875	5.3875	5.3538	5.361	606880.0
2018-11-01 04:00:00	AMZN	Stock	80.52	80.7	80.52	80.7	6220.0
2018-11-01 05:00:00	AMZN	Stock	80.745	80.75	80.745	80.75	6480.0

> showing 50 of 50,075 rows — these rows as CSV

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