PREVIEW / stock_1hour / 2018-07-30

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-07-30.parquet
  size:    1.1 MB
  rows:    48,685
  symbols: 2,818

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-30 04:00:00	AAPL	Stock	47.75	47.9675	47.7	47.745	20204.0
2018-07-30 05:00:00	AAPL	Stock	47.75	47.9	47.75	47.825	39876.0
2018-07-30 06:00:00	AAPL	Stock	47.825	47.85	47.795	47.85	7836.0
2018-07-30 07:00:00	AAPL	Stock	47.815	47.95	47.8	47.9125	209728.0
2018-07-30 08:00:00	AAPL	Stock	47.85	48.0	47.8375	47.95	342832.0
2018-07-30 09:00:00	AAPL	Stock	47.94	48.05	47.4375	47.475	11719708.0
2018-07-30 10:00:00	AAPL	Stock	47.47	47.5925	47.3525	47.4075	10517436.0
2018-07-30 11:00:00	AAPL	Stock	47.405	47.52	47.3625	47.4925	8878500.0
2018-07-30 12:00:00	AAPL	Stock	47.4925	47.505	47.2675	47.385	7196828.0
2018-07-30 13:00:00	AAPL	Stock	47.3862	47.5325	47.3128	47.491	7547020.0
2018-07-30 14:00:00	AAPL	Stock	47.4925	47.5625	47.42	47.4588	4986344.0
2018-07-30 15:00:00	AAPL	Stock	47.46	47.5325	47.4125	47.485	13084296.0
2018-07-30 16:00:00	AAPL	Stock	47.43	47.52	47.43	47.5125	7948480.0
2018-07-30 17:00:00	AAPL	Stock	47.5	47.525	47.3825	47.465	169068.0
2018-07-30 18:00:00	AAPL	Stock	47.4675	47.525	47.4675	47.5	66044.0
2018-07-30 19:00:00	AAPL	Stock	47.5225	47.535	47.4875	47.535	62312.0
2018-07-30 04:00:00	MSFT	Stock	107.55	107.55	107.55	107.55	100.0
2018-07-30 05:00:00	MSFT	Stock	107.52	107.64	107.28	107.3	7891.0
2018-07-30 06:00:00	MSFT	Stock	107.3	107.3	107.28	107.28	1082.0
2018-07-30 07:00:00	MSFT	Stock	107.48	107.48	107.01	107.27	20003.0
2018-07-30 08:00:00	MSFT	Stock	107.432	107.85	107.06	107.63	34681.0
2018-07-30 09:00:00	MSFT	Stock	107.63	107.704	105.24	105.4	5133555.0
2018-07-30 10:00:00	MSFT	Stock	105.41	106.21	105.28	105.585	5749713.0
2018-07-30 11:00:00	MSFT	Stock	105.58	106.04	105.349	105.9	3332374.0
2018-07-30 12:00:00	MSFT	Stock	105.9	105.9	104.76	105.045	3524992.0
2018-07-30 13:00:00	MSFT	Stock	105.04	105.76	105.02	105.715	2650246.0
2018-07-30 14:00:00	MSFT	Stock	105.72	105.89	105.55	105.615	2647003.0
2018-07-30 15:00:00	MSFT	Stock	105.61	105.73	105.16	105.38	5583329.0
2018-07-30 16:00:00	MSFT	Stock	105.3	105.47	105.3	105.46	2837807.0
2018-07-30 17:00:00	MSFT	Stock	105.4	105.46	105.38	105.45	3823.0
2018-07-30 18:00:00	MSFT	Stock	105.45	105.8	105.37	105.8	50189.0
2018-07-30 19:00:00	MSFT	Stock	105.83	105.84	105.65	105.65	15137.0
2018-07-30 04:00:00	NVDA	Stock	6.2925	6.295	6.29	6.29	26400.0
2018-07-30 05:00:00	NVDA	Stock	6.29	6.3	6.29	6.3	25480.0
2018-07-30 06:00:00	NVDA	Stock	6.2628	6.2662	6.2558	6.2558	46400.0
2018-07-30 07:00:00	NVDA	Stock	6.268	6.2853	6.268	6.2812	65760.0
2018-07-30 08:00:00	NVDA	Stock	6.2825	6.322	6.265	6.3195	284240.0
2018-07-30 09:00:00	NVDA	Stock	6.3	6.3208	6.1705	6.1948	42260600.0
2018-07-30 10:00:00	NVDA	Stock	6.197	6.2288	6.1535	6.1645	52262240.0
2018-07-30 11:00:00	NVDA	Stock	6.167	6.171	6.1068	6.1248	49108440.0
2018-07-30 12:00:00	NVDA	Stock	6.1251	6.1298	6.068	6.111	40563120.0
2018-07-30 13:00:00	NVDA	Stock	6.1109	6.162	6.0888	6.1558	33101040.0
2018-07-30 14:00:00	NVDA	Stock	6.157	6.1708	6.13	6.1352	21500600.0
2018-07-30 15:00:00	NVDA	Stock	6.1355	6.1432	6.0928	6.1035	51339800.0
2018-07-30 16:00:00	NVDA	Stock	6.1032	6.104	6.0875	6.103	1825160.0
2018-07-30 17:00:00	NVDA	Stock	6.1025	6.1025	6.0805	6.092	519880.0
2018-07-30 18:00:00	NVDA	Stock	6.092	6.1	6.092	6.1	235000.0
2018-07-30 19:00:00	NVDA	Stock	6.1	6.1062	6.1	6.1062	237160.0
2018-07-30 04:00:00	AMZN	Stock	91.1505	91.45	91.1505	91.2115	26000.0
2018-07-30 06:00:00	AMZN	Stock	91.225	91.25	91.225	91.25	4000.0

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

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