PREVIEW / stock_1hour / 2017-10-10

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-10-10.parquet
  size:    1.0 MB
  rows:    48,153
  symbols: 2,947

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
2017-10-10 04:00:00	AAPL	Stock	38.93	38.99	38.93	38.99	1968.0
2017-10-10 05:00:00	AAPL	Stock	38.9925	39.025	38.9925	39.025	9600.0
2017-10-10 06:00:00	AAPL	Stock	39.0325	39.0325	38.975	38.975	13604.0
2017-10-10 07:00:00	AAPL	Stock	38.995	39.015	38.9	38.95	153032.0
2017-10-10 08:00:00	AAPL	Stock	38.95	39.0375	38.9375	39.025	196780.0
2017-10-10 09:00:00	AAPL	Stock	39.025	39.5	38.9775	39.025	10827900.0
2017-10-10 10:00:00	AAPL	Stock	39.0325	39.0462	38.775	38.8992	11609384.0
2017-10-10 11:00:00	AAPL	Stock	38.8988	38.955	38.82	38.8675	5688496.0
2017-10-10 12:00:00	AAPL	Stock	38.8612	39.005	38.8125	38.995	5949600.0
2017-10-10 13:00:00	AAPL	Stock	38.9925	39.045	38.945	38.9575	5549736.0
2017-10-10 14:00:00	AAPL	Stock	38.9525	38.9825	38.9125	38.9475	3493132.0
2017-10-10 15:00:00	AAPL	Stock	38.9475	38.985	38.905	38.975	7612104.0
2017-10-10 16:00:00	AAPL	Stock	38.975	38.975	38.9275	38.96	5418928.0
2017-10-10 17:00:00	AAPL	Stock	38.9575	38.96	38.9375	38.9375	6500.0
2017-10-10 18:00:00	AAPL	Stock	38.9375	38.9675	38.9375	38.965	6628.0
2017-10-10 19:00:00	AAPL	Stock	38.955	38.97	38.9325	38.9325	22424.0
2017-10-10 07:00:00	MSFT	Stock	76.53	76.53	76.53	76.53	100.0
2017-10-10 08:00:00	MSFT	Stock	76.54	76.54	76.43	76.5	2830.0
2017-10-10 09:00:00	MSFT	Stock	76.48	76.63	76.29	76.59	1945931.0
2017-10-10 10:00:00	MSFT	Stock	76.6	76.63	76.35	76.51	1827384.0
2017-10-10 11:00:00	MSFT	Stock	76.51	76.59	76.255	76.31	1345768.0
2017-10-10 12:00:00	MSFT	Stock	76.31	76.34	76.15	76.3	1171099.0
2017-10-10 13:00:00	MSFT	Stock	76.3	76.44	76.28	76.29	877694.0
2017-10-10 14:00:00	MSFT	Stock	76.295	76.34	76.23	76.278	1011438.0
2017-10-10 15:00:00	MSFT	Stock	76.275	76.35	76.14	76.31	2395030.0
2017-10-10 16:00:00	MSFT	Stock	76.31	76.38	76.21	76.21	2112307.0
2017-10-10 17:00:00	MSFT	Stock	76.34	76.34	76.34	76.34	120.0
2017-10-10 18:00:00	MSFT	Stock	76.34	76.34	76.25	76.25	1791.0
2017-10-10 19:00:00	MSFT	Stock	76.34	76.34	76.26	76.34	1206.0
2017-10-10 04:00:00	NVDA	Stock	4.6667	4.6725	4.6645	4.6725	159600.0
2017-10-10 06:00:00	NVDA	Stock	4.6945	4.775	4.6942	4.7502	1344520.0
2017-10-10 07:00:00	NVDA	Stock	4.7502	4.85	4.75	4.8125	9490920.0
2017-10-10 08:00:00	NVDA	Stock	4.8235	4.8438	4.7	4.7975	12943040.0
2017-10-10 09:00:00	NVDA	Stock	4.7952	4.8238	4.7438	4.761	259080160.0
2017-10-10 10:00:00	NVDA	Stock	4.7612	4.7625	4.7053	4.732	213127600.0
2017-10-10 11:00:00	NVDA	Stock	4.733	4.7432	4.7013	4.7324	120758200.0
2017-10-10 12:00:00	NVDA	Stock	4.7319	4.7382	4.6815	4.7076	96546760.0
2017-10-10 13:00:00	NVDA	Stock	4.7076	4.7252	4.7062	4.7172	63782920.0
2017-10-10 14:00:00	NVDA	Stock	4.718	4.7375	4.7155	4.7362	53978520.0
2017-10-10 15:00:00	NVDA	Stock	4.736	4.747	4.7163	4.7235	121727680.0
2017-10-10 16:00:00	NVDA	Stock	4.7232	4.7245	4.716	4.721	7475600.0
2017-10-10 17:00:00	NVDA	Stock	4.7213	4.7243	4.7195	4.72	758760.0
2017-10-10 18:00:00	NVDA	Stock	4.7188	4.7198	4.7165	4.7172	1003760.0
2017-10-10 19:00:00	NVDA	Stock	4.7188	4.7198	4.7083	4.7158	853520.0
2017-10-10 05:00:00	AMZN	Stock	49.645	49.65	49.645	49.65	4000.0
2017-10-10 07:00:00	AMZN	Stock	49.65	49.65	49.65	49.65	2000.0
2017-10-10 08:00:00	AMZN	Stock	49.675	49.7665	49.675	49.7665	79580.0
2017-10-10 09:00:00	AMZN	Stock	49.765	49.8975	49.2788	49.3625	12048560.0
2017-10-10 10:00:00	AMZN	Stock	49.3796	49.475	49.05	49.2905	12646900.0
2017-10-10 11:00:00	AMZN	Stock	49.2745	49.3695	49.005	49.0604	8293240.0

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

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