PREVIEW / stock_1hour / 2018-02-22

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-02-22.parquet
  size:    1.1 MB
  rows:    48,691
  symbols: 2,872

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-22 04:00:00	AAPL	Stock	42.6375	42.7125	42.5	42.7	77836.0
2018-02-22 05:00:00	AAPL	Stock	42.7	42.82	42.6925	42.74	5584.0
2018-02-22 06:00:00	AAPL	Stock	42.785	42.9925	42.7025	42.8375	66856.0
2018-02-22 07:00:00	AAPL	Stock	42.8625	43.0	42.8625	42.915	294128.0
2018-02-22 08:00:00	AAPL	Stock	42.9263	43.04	42.845	42.995	509088.0
2018-02-22 09:00:00	AAPL	Stock	42.99	43.3425	42.9	43.1888	17498080.0
2018-02-22 10:00:00	AAPL	Stock	43.195	43.475	43.105	43.37	19293080.0
2018-02-22 11:00:00	AAPL	Stock	43.3665	43.4875	43.2778	43.4538	12603688.0
2018-02-22 12:00:00	AAPL	Stock	43.455	43.4775	43.1825	43.26	10049240.0
2018-02-22 13:00:00	AAPL	Stock	43.2525	43.345	43.0775	43.21	11893944.0
2018-02-22 14:00:00	AAPL	Stock	43.21	43.3375	43.0225	43.06	10502664.0
2018-02-22 15:00:00	AAPL	Stock	43.0625	43.25	42.9525	43.1525	23221332.0
2018-02-22 16:00:00	AAPL	Stock	43.125	43.25	43.125	43.2275	6816276.0
2018-02-22 17:00:00	AAPL	Stock	43.2475	43.2475	43.1875	43.2	21960.0
2018-02-22 18:00:00	AAPL	Stock	43.19	43.22	43.19	43.22	29672.0
2018-02-22 19:00:00	AAPL	Stock	43.22	43.275	43.2075	43.255	74940.0
2018-02-22 04:00:00	MSFT	Stock	91.15	91.17	90.98	91.16	2263.0
2018-02-22 05:00:00	MSFT	Stock	91.24	91.5	91.24	91.26	3830.0
2018-02-22 06:00:00	MSFT	Stock	91.61	91.61	91.6	91.6	3250.0
2018-02-22 07:00:00	MSFT	Stock	91.55	91.9	91.55	91.69	28282.0
2018-02-22 08:00:00	MSFT	Stock	91.76	91.95	91.62	91.85	24356.0
2018-02-22 09:00:00	MSFT	Stock	91.94	92.47	91.78	92.01	2331237.0
2018-02-22 10:00:00	MSFT	Stock	92.01	92.6	91.71	92.35	2638244.0
2018-02-22 11:00:00	MSFT	Stock	92.36	92.69	92.28	92.59	1684661.0
2018-02-22 12:00:00	MSFT	Stock	92.59	92.73	91.6	91.86	2289722.0
2018-02-22 13:00:00	MSFT	Stock	91.86	92.05	91.36	91.8	2081408.0
2018-02-22 14:00:00	MSFT	Stock	91.8	92.22	91.77	91.834	2115475.0
2018-02-22 15:00:00	MSFT	Stock	91.84	92.23	91.44	91.74	4430069.0
2018-02-22 16:00:00	MSFT	Stock	91.73	92.535	91.73	92.05	3913419.0
2018-02-22 17:00:00	MSFT	Stock	91.93	91.93	91.93	91.93	3800.0
2018-02-22 19:00:00	MSFT	Stock	92.07	92.07	92.07	92.07	900.0
2018-02-22 04:00:00	NVDA	Stock	6.0	6.0273	5.992	6.0125	149200.0
2018-02-22 05:00:00	NVDA	Stock	6.015	6.0502	6.0125	6.0502	76000.0
2018-02-22 06:00:00	NVDA	Stock	6.055	6.0688	6.0375	6.0445	173640.0
2018-02-22 07:00:00	NVDA	Stock	6.0498	6.1163	6.0498	6.095	1373080.0
2018-02-22 08:00:00	NVDA	Stock	6.0938	6.1163	6.0438	6.1125	2816800.0
2018-02-22 09:00:00	NVDA	Stock	6.115	6.1368	6.0165	6.0922	107303640.0
2018-02-22 10:00:00	NVDA	Stock	6.0945	6.1408	6.0698	6.0703	72579840.0
2018-02-22 11:00:00	NVDA	Stock	6.0742	6.102	6.0585	6.0903	36629680.0
2018-02-22 12:00:00	NVDA	Stock	6.09	6.1005	6.0348	6.045	33132240.0
2018-02-22 13:00:00	NVDA	Stock	6.044	6.0588	5.9875	6.0322	49571960.0
2018-02-22 14:00:00	NVDA	Stock	6.0324	6.0897	6.0213	6.0546	46578840.0
2018-02-22 15:00:00	NVDA	Stock	6.052	6.0721	6.0244	6.0538	58321640.0
2018-02-22 16:00:00	NVDA	Stock	6.0538	6.0748	6.0538	6.0733	9881200.0
2018-02-22 17:00:00	NVDA	Stock	6.07	6.0748	6.0665	6.0712	253000.0
2018-02-22 18:00:00	NVDA	Stock	6.0748	6.075	6.0688	6.0712	427680.0
2018-02-22 19:00:00	NVDA	Stock	6.075	6.0875	6.0695	6.0875	250640.0
2018-02-22 04:00:00	AMZN	Stock	73.855	73.855	73.8225	73.825	24160.0
2018-02-22 05:00:00	AMZN	Stock	73.9025	74.115	73.9015	74.0825	63520.0
2018-02-22 06:00:00	AMZN	Stock	74.187	74.325	74.15	74.275	29440.0

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

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