PREVIEW / stock_1hour / 2018-06-28

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-06-28.parquet
  size:    1.1 MB
  rows:    49,477
  symbols: 2,840

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-06-28 04:00:00	AAPL	Stock	46.1925	46.1925	46.1675	46.1675	14600.0
2018-06-28 05:00:00	AAPL	Stock	46.1875	46.1875	46.15	46.15	8868.0
2018-06-28 06:00:00	AAPL	Stock	46.15	46.2475	46.15	46.2475	5712.0
2018-06-28 07:00:00	AAPL	Stock	46.2175	46.2425	46.1375	46.17	149992.0
2018-06-28 08:00:00	AAPL	Stock	46.22	46.2445	45.91	45.91	276636.0
2018-06-28 09:00:00	AAPL	Stock	45.91	46.2975	45.855	46.25	9766376.0
2018-06-28 10:00:00	AAPL	Stock	46.2575	46.3922	46.0975	46.3675	11233852.0
2018-06-28 11:00:00	AAPL	Stock	46.365	46.415	46.1625	46.295	7292400.0
2018-06-28 12:00:00	AAPL	Stock	46.2975	46.3125	46.15	46.265	5736780.0
2018-06-28 13:00:00	AAPL	Stock	46.27	46.325	46.215	46.2675	4198308.0
2018-06-28 14:00:00	AAPL	Stock	46.2688	46.49	46.2375	46.49	5260180.0
2018-06-28 15:00:00	AAPL	Stock	46.49	46.5525	46.3175	46.3775	10900612.0
2018-06-28 16:00:00	AAPL	Stock	46.375	46.4075	46.2925	46.4075	5934148.0
2018-06-28 17:00:00	AAPL	Stock	46.3925	46.425	46.375	46.4225	21136.0
2018-06-28 18:00:00	AAPL	Stock	46.4225	46.45	46.3325	46.3875	18652.0
2018-06-28 19:00:00	AAPL	Stock	46.4	46.4375	46.3725	46.4375	10420.0
2018-06-28 04:00:00	MSFT	Stock	98.17	98.38	98.0	98.38	2586.0
2018-06-28 05:00:00	MSFT	Stock	98.0	98.1	98.0	98.1	1614.0
2018-06-28 06:00:00	MSFT	Stock	97.97	98.2	97.97	98.2	1100.0
2018-06-28 07:00:00	MSFT	Stock	98.04	98.04	97.75	97.75	5449.0
2018-06-28 08:00:00	MSFT	Stock	98.03	98.1	97.2	97.2	29981.0
2018-06-28 09:00:00	MSFT	Stock	97.2	98.32	97.2	98.19	3472318.0
2018-06-28 10:00:00	MSFT	Stock	98.2	98.46	97.515	98.44	3976169.0
2018-06-28 11:00:00	MSFT	Stock	98.445	98.85	98.2	98.31	3349873.0
2018-06-28 12:00:00	MSFT	Stock	98.318	98.45	97.75	98.23	2145240.0
2018-06-28 13:00:00	MSFT	Stock	98.23	98.49	98.15	98.42	1772361.0
2018-06-28 14:00:00	MSFT	Stock	98.42	98.94	98.4	98.935	2269945.0
2018-06-28 15:00:00	MSFT	Stock	98.94	99.11	98.545	98.63	3555717.0
2018-06-28 16:00:00	MSFT	Stock	98.63	98.77	98.63	98.75	2544061.0
2018-06-28 17:00:00	MSFT	Stock	98.8	98.85	98.8	98.85	989.0
2018-06-28 18:00:00	MSFT	Stock	98.75	98.85	98.67	98.8	1350.0
2018-06-28 19:00:00	MSFT	Stock	98.8	98.8	98.7	98.7	300.0
2018-06-28 04:00:00	NVDA	Stock	5.9252	5.9465	5.925	5.925	36320.0
2018-06-28 07:00:00	NVDA	Stock	5.9275	5.9275	5.91	5.9125	367760.0
2018-06-28 08:00:00	NVDA	Stock	5.9362	5.9375	5.85	5.8502	2132280.0
2018-06-28 09:00:00	NVDA	Stock	5.8585	6.0175	5.8525	5.9898	82750920.0
2018-06-28 10:00:00	NVDA	Stock	5.991	6.0037	5.9404	6.002	52531560.0
2018-06-28 11:00:00	NVDA	Stock	6.0013	6.0055	5.9642	5.9835	33559960.0
2018-06-28 12:00:00	NVDA	Stock	5.984	5.9875	5.933	5.9538	20182840.0
2018-06-28 13:00:00	NVDA	Stock	5.9503	5.9725	5.9475	5.9655	14778200.0
2018-06-28 14:00:00	NVDA	Stock	5.9655	6.0182	5.9623	6.0182	29162720.0
2018-06-28 15:00:00	NVDA	Stock	6.0178	6.0335	6.0054	6.0215	52164040.0
2018-06-28 16:00:00	NVDA	Stock	6.0215	6.0308	6.01	6.025	11515640.0
2018-06-28 17:00:00	NVDA	Stock	6.0488	6.0488	6.0275	6.0288	127840.0
2018-06-28 18:00:00	NVDA	Stock	6.0325	6.0348	6.0275	6.0312	156680.0
2018-06-28 19:00:00	NVDA	Stock	6.0355	6.0448	6.0275	6.0315	180720.0
2018-06-28 04:00:00	AMZN	Stock	83.57	83.625	83.57	83.57	18440.0
2018-06-28 05:00:00	AMZN	Stock	83.4285	83.4285	83.4	83.4	18120.0
2018-06-28 06:00:00	AMZN	Stock	83.4	83.6915	83.4	83.6915	14060.0
2018-06-28 07:00:00	AMZN	Stock	83.55	83.6	83.4	83.4	60980.0

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

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