PREVIEW / stock_1hour / 2018-08-21

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-08-21.parquet
  size:    1.1 MB
  rows:    49,558
  symbols: 2,797

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-08-21 04:00:00	AAPL	Stock	54.025	54.025	54.0	54.0	6496.0
2018-08-21 05:00:00	AAPL	Stock	54.1025	54.1925	54.1025	54.1725	61976.0
2018-08-21 06:00:00	AAPL	Stock	54.22	54.25	54.175	54.1875	44672.0
2018-08-21 07:00:00	AAPL	Stock	54.155	54.21	54.09	54.1125	153256.0
2018-08-21 08:00:00	AAPL	Stock	54.1985	54.205	54.0525	54.1	267464.0
2018-08-21 09:00:00	AAPL	Stock	54.1	54.2425	53.8465	53.88	13695700.0
2018-08-21 10:00:00	AAPL	Stock	53.8825	53.925	53.5062	53.6775	19986036.0
2018-08-21 11:00:00	AAPL	Stock	53.6775	54.1425	53.64	54.11	11871404.0
2018-08-21 12:00:00	AAPL	Stock	54.1085	54.25	54.0312	54.2075	8018656.0
2018-08-21 13:00:00	AAPL	Stock	54.21	54.2975	54.1125	54.1275	7295748.0
2018-08-21 14:00:00	AAPL	Stock	54.1275	54.1375	53.815	53.8882	8059220.0
2018-08-21 15:00:00	AAPL	Stock	53.89	53.9275	53.5225	53.765	13437956.0
2018-08-21 16:00:00	AAPL	Stock	53.76	53.8	53.57	53.57	7081012.0
2018-08-21 17:00:00	AAPL	Stock	53.575	53.6075	53.505	53.575	176168.0
2018-08-21 18:00:00	AAPL	Stock	53.55	53.5875	53.5	53.505	104080.0
2018-08-21 19:00:00	AAPL	Stock	53.5025	53.5025	53.4375	53.4425	103860.0
2018-08-21 07:00:00	MSFT	Stock	107.03	107.18	106.92	107.0	21938.0
2018-08-21 08:00:00	MSFT	Stock	107.12	107.18	106.91	107.06	8150.0
2018-08-21 09:00:00	MSFT	Stock	107.1	107.32	106.81	107.26	2203155.0
2018-08-21 10:00:00	MSFT	Stock	107.25	107.35	106.9	107.0	2380278.0
2018-08-21 11:00:00	MSFT	Stock	107.0	107.02	106.61	107.01	1742497.0
2018-08-21 12:00:00	MSFT	Stock	107.015	107.14	106.85	106.854	1379961.0
2018-08-21 13:00:00	MSFT	Stock	106.855	106.86	106.52	106.555	1970148.0
2018-08-21 14:00:00	MSFT	Stock	106.55	106.56	106.0	106.14	2331328.0
2018-08-21 15:00:00	MSFT	Stock	106.14	106.25	105.85	105.98	4318424.0
2018-08-21 16:00:00	MSFT	Stock	105.98	106.14	105.63	105.78	3549394.0
2018-08-21 17:00:00	MSFT	Stock	105.68	105.7	105.5	105.7	13725.0
2018-08-21 18:00:00	MSFT	Stock	105.52	105.61	105.4	105.4	9193.0
2018-08-21 19:00:00	MSFT	Stock	105.4	105.5	105.1	105.29	10583.0
2018-08-21 04:00:00	NVDA	Stock	6.2295	6.2295	6.2295	6.2295	4000.0
2018-08-21 05:00:00	NVDA	Stock	6.2295	6.2295	6.2168	6.2168	25760.0
2018-08-21 06:00:00	NVDA	Stock	6.2258	6.2483	6.2258	6.2375	62280.0
2018-08-21 07:00:00	NVDA	Stock	6.245	6.245	6.2282	6.2375	488960.0
2018-08-21 08:00:00	NVDA	Stock	6.2428	6.2428	6.2275	6.237	1107520.0
2018-08-21 09:00:00	NVDA	Stock	6.236	6.2948	6.1925	6.2715	100948160.0
2018-08-21 10:00:00	NVDA	Stock	6.2738	6.3348	6.25	6.3283	154060080.0
2018-08-21 11:00:00	NVDA	Stock	6.3285	6.3375	6.2752	6.2898	71687640.0
2018-08-21 12:00:00	NVDA	Stock	6.2898	6.3198	6.277	6.294	47261200.0
2018-08-21 13:00:00	NVDA	Stock	6.2945	6.2948	6.2662	6.2858	43091680.0
2018-08-21 14:00:00	NVDA	Stock	6.2865	6.3125	6.2848	6.3102	50748920.0
2018-08-21 15:00:00	NVDA	Stock	6.3085	6.3348	6.301	6.333	96911200.0
2018-08-21 16:00:00	NVDA	Stock	6.333	6.335	6.3004	6.3155	43536400.0
2018-08-21 17:00:00	NVDA	Stock	6.318	6.318	6.2712	6.2822	2004080.0
2018-08-21 18:00:00	NVDA	Stock	6.28	6.2848	6.2728	6.275	1471440.0
2018-08-21 19:00:00	NVDA	Stock	6.275	6.2875	6.2613	6.2775	1515880.0
2018-08-21 04:00:00	AMZN	Stock	94.1	94.15	94.1	94.15	12940.0
2018-08-21 05:00:00	AMZN	Stock	94.1835	94.1835	94.1835	94.1835	2000.0
2018-08-21 07:00:00	AMZN	Stock	94.1395	94.1395	94.061	94.075	64620.0
2018-08-21 08:00:00	AMZN	Stock	94.0995	94.15	94.019	94.0875	173860.0
2018-08-21 09:00:00	AMZN	Stock	94.02	94.603	93.7205	94.529	9878600.0

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

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