PREVIEW / stock_1hour / 2018-05-09

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-05-09.parquet
  size:    1.1 MB
  rows:    49,655
  symbols: 2,868

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-05-09 04:00:00	AAPL	Stock	46.59	46.6125	46.59	46.6125	10400.0
2018-05-09 05:00:00	AAPL	Stock	46.61	46.6725	46.61	46.635	28328.0
2018-05-09 06:00:00	AAPL	Stock	46.6	46.6	46.575	46.5875	3332.0
2018-05-09 07:00:00	AAPL	Stock	46.5975	46.695	46.5925	46.6375	223956.0
2018-05-09 08:00:00	AAPL	Stock	46.6338	46.6875	46.61	46.6175	302292.0
2018-05-09 09:00:00	AAPL	Stock	46.615	46.675	46.415	46.4275	12360432.0
2018-05-09 10:00:00	AAPL	Stock	46.4288	46.5325	46.305	46.3725	12527400.0
2018-05-09 11:00:00	AAPL	Stock	46.375	46.4988	46.34	46.475	7574608.0
2018-05-09 12:00:00	AAPL	Stock	46.4775	46.6123	46.4175	46.5625	8762468.0
2018-05-09 13:00:00	AAPL	Stock	46.5625	46.71	46.5225	46.705	8536852.0
2018-05-09 14:00:00	AAPL	Stock	46.7048	46.7475	46.63	46.74	8210556.0
2018-05-09 15:00:00	AAPL	Stock	46.735	46.85	46.725	46.8375	17760128.0
2018-05-09 16:00:00	AAPL	Stock	46.84	46.8775	46.6268	46.8675	7005520.0
2018-05-09 17:00:00	AAPL	Stock	46.855	46.875	46.8425	46.865	79120.0
2018-05-09 18:00:00	AAPL	Stock	46.8675	46.875	46.86	46.8675	48176.0
2018-05-09 19:00:00	AAPL	Stock	46.8575	46.875	46.85	46.87	48176.0
2018-05-09 05:00:00	MSFT	Stock	95.76	95.76	95.7	95.7	485.0
2018-05-09 07:00:00	MSFT	Stock	96.15	96.24	96.15	96.15	2138.0
2018-05-09 08:00:00	MSFT	Stock	96.25	96.25	96.0	96.07	23817.0
2018-05-09 09:00:00	MSFT	Stock	96.05	96.383	95.43	95.5	2347905.0
2018-05-09 10:00:00	MSFT	Stock	95.505	96.02	95.11	95.24	2881861.0
2018-05-09 11:00:00	MSFT	Stock	95.24	95.59	95.05	95.494	2125110.0
2018-05-09 12:00:00	MSFT	Stock	95.5	96.25	95.484	96.19	2895261.0
2018-05-09 13:00:00	MSFT	Stock	96.19	96.94	96.16	96.72	2473879.0
2018-05-09 14:00:00	MSFT	Stock	96.71	96.9	96.535	96.79	1768885.0
2018-05-09 15:00:00	MSFT	Stock	96.79	96.97	96.58	96.95	3709500.0
2018-05-09 16:00:00	MSFT	Stock	96.94	96.94	96.8	96.8	4783152.0
2018-05-09 17:00:00	MSFT	Stock	96.92	96.94	96.92	96.93	4311.0
2018-05-09 18:00:00	MSFT	Stock	96.93	96.94	96.8	96.85	4165.0
2018-05-09 19:00:00	MSFT	Stock	96.81	96.91	96.8	96.8	1535.0
2018-05-09 04:00:00	NVDA	Stock	6.2678	6.2995	6.2678	6.2995	276480.0
2018-05-09 05:00:00	NVDA	Stock	6.2948	6.3	6.2935	6.3	54560.0
2018-05-09 06:00:00	NVDA	Stock	6.2948	6.3005	6.2948	6.3005	95840.0
2018-05-09 07:00:00	NVDA	Stock	6.3005	6.322	6.3	6.3112	2912320.0
2018-05-09 08:00:00	NVDA	Stock	6.3038	6.325	6.2968	6.2998	3360920.0
2018-05-09 09:00:00	NVDA	Stock	6.3	6.3102	6.2528	6.2914	92126880.0
2018-05-09 10:00:00	NVDA	Stock	6.2922	6.3705	6.2875	6.3056	125230040.0
2018-05-09 11:00:00	NVDA	Stock	6.305	6.351	6.2928	6.3405	59276840.0
2018-05-09 12:00:00	NVDA	Stock	6.3418	6.3625	6.3288	6.3421	47647640.0
2018-05-09 13:00:00	NVDA	Stock	6.3422	6.358	6.329	6.3502	36660120.0
2018-05-09 14:00:00	NVDA	Stock	6.3515	6.373	6.348	6.3583	52101200.0
2018-05-09 15:00:00	NVDA	Stock	6.358	6.3968	6.3532	6.3968	90328320.0
2018-05-09 16:00:00	NVDA	Stock	6.3945	6.416	6.3493	6.407	27371760.0
2018-05-09 17:00:00	NVDA	Stock	6.4055	6.4175	6.4032	6.4175	3496720.0
2018-05-09 18:00:00	NVDA	Stock	6.4188	6.4213	6.398	6.398	1259360.0
2018-05-09 19:00:00	NVDA	Stock	6.3972	6.4122	6.3813	6.4062	1206640.0
2018-05-09 06:00:00	AMZN	Stock	79.95	80.0505	79.95	80.0065	8000.0
2018-05-09 07:00:00	AMZN	Stock	79.9475	79.9875	79.826	79.95	182840.0
2018-05-09 08:00:00	AMZN	Stock	79.95	80.275	79.79	80.038	650640.0
2018-05-09 09:00:00	AMZN	Stock	80.005	80.3245	79.7688	79.81	11181340.0

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

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