PREVIEW / stock_1hour / 2018-02-01

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-02-01.parquet
  size:    1.1 MB
  rows:    50,059
  symbols: 2,905

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-02-01 04:00:00	AAPL	Stock	42.0	42.0	41.85	41.885	66720.0
2018-02-01 05:00:00	AAPL	Stock	41.875	41.925	41.8	41.8625	49012.0
2018-02-01 06:00:00	AAPL	Stock	41.85	41.9475	41.825	41.9	63436.0
2018-02-01 07:00:00	AAPL	Stock	41.9	41.925	41.825	41.9125	202128.0
2018-02-01 08:00:00	AAPL	Stock	41.9125	41.92	41.6775	41.7375	662904.0
2018-02-01 09:00:00	AAPL	Stock	41.745	42.065	41.6575	41.97	17836380.0
2018-02-01 10:00:00	AAPL	Stock	41.9575	42.05	41.7425	41.785	19202376.0
2018-02-01 11:00:00	AAPL	Stock	41.7875	42.0125	41.745	42.0125	14340064.0
2018-02-01 12:00:00	AAPL	Stock	42.0125	42.155	41.93	41.9512	15964728.0
2018-02-01 13:00:00	AAPL	Stock	41.9512	42.0425	41.83	41.865	11364036.0
2018-02-01 14:00:00	AAPL	Stock	41.8625	42.0325	41.78	42.025	13209812.0
2018-02-01 15:00:00	AAPL	Stock	42.025	42.0275	41.7025	41.925	27380688.0
2018-02-01 16:00:00	AAPL	Stock	41.945	42.5	40.6375	42.345	27243548.0
2018-02-01 17:00:00	AAPL	Stock	42.345	43.5625	41.93	43.35	16692784.0
2018-02-01 18:00:00	AAPL	Stock	43.3725	43.45	43.225	43.2875	2454660.0
2018-02-01 19:00:00	AAPL	Stock	43.2875	43.3725	43.225	43.3725	583064.0
2018-02-01 04:00:00	MSFT	Stock	95.5	95.5	94.6	94.71	9627.0
2018-02-01 05:00:00	MSFT	Stock	94.89	95.2	94.89	95.12	3930.0
2018-02-01 06:00:00	MSFT	Stock	95.1	95.14	94.85	95.0	14697.0
2018-02-01 07:00:00	MSFT	Stock	95.0	95.0	93.71	94.25	104953.0
2018-02-01 08:00:00	MSFT	Stock	95.01	95.01	93.28	93.81	373040.0
2018-02-01 09:00:00	MSFT	Stock	93.75	95.84	93.62	95.039	9356846.0
2018-02-01 10:00:00	MSFT	Stock	95.04	96.07	94.95	96.02	6937219.0
2018-02-01 11:00:00	MSFT	Stock	96.014	96.035	95.36	95.53	3884477.0
2018-02-01 12:00:00	MSFT	Stock	95.535	95.99	95.01	95.82	3401799.0
2018-02-01 13:00:00	MSFT	Stock	95.83	95.92	94.36	94.5	4400469.0
2018-02-01 14:00:00	MSFT	Stock	94.505	94.54	93.765	94.53	4404156.0
2018-02-01 15:00:00	MSFT	Stock	94.525	94.645	93.581	94.24	5658922.0
2018-02-01 16:00:00	MSFT	Stock	93.63	94.48	93.63	94.34	3631144.0
2018-02-01 17:00:00	MSFT	Stock	94.4	94.97	94.26	94.5	438229.0
2018-02-01 18:00:00	MSFT	Stock	94.5	94.62	94.25	94.59	46649.0
2018-02-01 19:00:00	MSFT	Stock	94.59	94.69	94.52	94.64	8934.0
2018-02-01 04:00:00	NVDA	Stock	6.129	6.129	6.03	6.0498	521480.0
2018-02-01 05:00:00	NVDA	Stock	6.0392	6.0392	6.0225	6.0278	127240.0
2018-02-01 06:00:00	NVDA	Stock	6.0413	6.056	6.0318	6.045	296240.0
2018-02-01 07:00:00	NVDA	Stock	6.0525	6.0875	6.03	6.0625	1058080.0
2018-02-01 08:00:00	NVDA	Stock	6.053	6.145	6.0028	6.0045	3349200.0
2018-02-01 09:00:00	NVDA	Stock	6.003	6.1163	5.9515	6.1058	102978360.0
2018-02-01 10:00:00	NVDA	Stock	6.1074	6.1725	6.097	6.152	86545520.0
2018-02-01 11:00:00	NVDA	Stock	6.151	6.1614	6.1145	6.1322	41756160.0
2018-02-01 12:00:00	NVDA	Stock	6.1338	6.144	6.0682	6.071	33494480.0
2018-02-01 13:00:00	NVDA	Stock	6.0708	6.1032	6.0602	6.0655	24049320.0
2018-02-01 14:00:00	NVDA	Stock	6.068	6.0788	6.0353	6.0544	30680880.0
2018-02-01 15:00:00	NVDA	Stock	6.0538	6.059	5.9682	6.012	76906800.0
2018-02-01 16:00:00	NVDA	Stock	6.0125	6.025	5.9485	6.0075	21497520.0
2018-02-01 17:00:00	NVDA	Stock	6.0013	6.07	6.0013	6.0623	3225840.0
2018-02-01 18:00:00	NVDA	Stock	6.0625	6.0688	6.05	6.0623	667720.0
2018-02-01 19:00:00	NVDA	Stock	6.06	6.072	6.0488	6.0625	920280.0
2018-02-01 04:00:00	AMZN	Stock	73.4225	73.4655	73.2655	73.3445	35000.0
2018-02-01 05:00:00	AMZN	Stock	73.3	73.45	73.3	73.45	26760.0

> showing 50 of 50,059 rows — these rows as CSV

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