PREVIEW / stock_1hour / 2018-07-18

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-07-18.parquet
  size:    1.1 MB
  rows:    48,948
  symbols: 2,824

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-18 04:00:00	AAPL	Stock	48.0125	48.0375	47.9875	48.0375	37596.0
2018-07-18 05:00:00	AAPL	Stock	48.0475	48.1	48.04	48.1	4156.0
2018-07-18 06:00:00	AAPL	Stock	48.0975	48.0975	48.05	48.075	8664.0
2018-07-18 07:00:00	AAPL	Stock	48.045	48.0625	48.0	48.025	82220.0
2018-07-18 08:00:00	AAPL	Stock	48.05	48.06	47.95	48.0375	188640.0
2018-07-18 09:00:00	AAPL	Stock	48.0375	48.05	47.5505	47.595	10809644.0
2018-07-18 10:00:00	AAPL	Stock	47.5925	47.6492	47.4825	47.555	8699040.0
2018-07-18 11:00:00	AAPL	Stock	47.555	47.63	47.5175	47.5985	4920776.0
2018-07-18 12:00:00	AAPL	Stock	47.6	47.6025	47.49	47.55	3933124.0
2018-07-18 13:00:00	AAPL	Stock	47.5488	47.5875	47.51	47.5675	3090716.0
2018-07-18 14:00:00	AAPL	Stock	47.5675	47.6112	47.5325	47.5588	2982524.0
2018-07-18 15:00:00	AAPL	Stock	47.56	47.6675	47.5425	47.6	8145128.0
2018-07-18 16:00:00	AAPL	Stock	47.6	47.6	47.5468	47.5625	11131684.0
2018-07-18 17:00:00	AAPL	Stock	47.575	47.6	47.5675	47.58	18952.0
2018-07-18 18:00:00	AAPL	Stock	47.57	47.595	47.57	47.585	37208.0
2018-07-18 19:00:00	AAPL	Stock	47.585	47.635	47.585	47.6325	49960.0
2018-07-18 04:00:00	MSFT	Stock	106.31	106.32	106.3	106.32	2103.0
2018-07-18 05:00:00	MSFT	Stock	106.32	106.37	106.32	106.33	1378.0
2018-07-18 06:00:00	MSFT	Stock	106.35	106.38	106.1	106.2	6041.0
2018-07-18 07:00:00	MSFT	Stock	106.28	106.34	106.05	106.24	15753.0
2018-07-18 08:00:00	MSFT	Stock	106.28	106.34	105.86	106.12	35306.0
2018-07-18 09:00:00	MSFT	Stock	106.1	106.34	104.715	105.02	4888818.0
2018-07-18 10:00:00	MSFT	Stock	105.03	105.27	104.91	105.05	3483401.0
2018-07-18 11:00:00	MSFT	Stock	105.06	105.41	105.005	105.225	2670500.0
2018-07-18 12:00:00	MSFT	Stock	105.22	105.25	104.93	105.01	2482871.0
2018-07-18 13:00:00	MSFT	Stock	105.01	105.1	104.96	105.05	1807000.0
2018-07-18 14:00:00	MSFT	Stock	105.05	105.315	104.965	105.22	2266316.0
2018-07-18 15:00:00	MSFT	Stock	105.22	105.35	105.03	105.1	5045984.0
2018-07-18 16:00:00	MSFT	Stock	105.12	105.281	105.0	105.05	3151313.0
2018-07-18 17:00:00	MSFT	Stock	105.05	105.25	105.01	105.25	41792.0
2018-07-18 18:00:00	MSFT	Stock	105.2	105.48	105.12	105.4	72106.0
2018-07-18 19:00:00	MSFT	Stock	105.38	105.47	105.33	105.45	17120.0
2018-07-18 04:00:00	NVDA	Stock	6.3693	6.3693	6.3693	6.3693	9120.0
2018-07-18 05:00:00	NVDA	Stock	6.3688	6.3688	6.3688	6.3688	12000.0
2018-07-18 06:00:00	NVDA	Stock	6.3672	6.3852	6.367	6.3852	129200.0
2018-07-18 07:00:00	NVDA	Stock	6.3755	6.3808	6.35	6.36	573080.0
2018-07-18 08:00:00	NVDA	Stock	6.3645	6.3808	6.335	6.3512	903160.0
2018-07-18 09:00:00	NVDA	Stock	6.3523	6.3538	6.2635	6.2854	48286440.0
2018-07-18 10:00:00	NVDA	Stock	6.286	6.3148	6.241	6.3111	62506320.0
2018-07-18 11:00:00	NVDA	Stock	6.3111	6.3454	6.2985	6.307	31220720.0
2018-07-18 12:00:00	NVDA	Stock	6.3072	6.3118	6.277	6.3004	21181160.0
2018-07-18 13:00:00	NVDA	Stock	6.3005	6.3078	6.2908	6.2978	16411080.0
2018-07-18 14:00:00	NVDA	Stock	6.2985	6.3083	6.2903	6.2988	18853640.0
2018-07-18 15:00:00	NVDA	Stock	6.3	6.305	6.2853	6.2922	32238840.0
2018-07-18 16:00:00	NVDA	Stock	6.2925	6.2925	6.2795	6.2888	11321520.0
2018-07-18 17:00:00	NVDA	Stock	6.2888	6.2888	6.2853	6.2888	37480.0
2018-07-18 18:00:00	NVDA	Stock	6.2968	6.2975	6.29	6.2963	102640.0
2018-07-18 19:00:00	NVDA	Stock	6.2985	6.3025	6.2975	6.3	287720.0
2018-07-18 04:00:00	AMZN	Stock	92.4	92.4	92.35	92.35	15540.0
2018-07-18 05:00:00	AMZN	Stock	92.35	92.35	92.3	92.3	7240.0

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

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