PREVIEW / stock_1hour / 2017-05-09

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-05-09.parquet
  size:    1.0 MB
  rows:    48,466
  symbols: 3,032

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-05-09 04:00:00	AAPL	Stock	38.3125	38.375	38.3	38.375	26816.0
2017-05-09 05:00:00	AAPL	Stock	38.37	38.4375	38.35	38.425	31880.0
2017-05-09 06:00:00	AAPL	Stock	38.42	38.42	38.355	38.37	40876.0
2017-05-09 07:00:00	AAPL	Stock	38.3675	38.385	38.3325	38.345	91604.0
2017-05-09 08:00:00	AAPL	Stock	38.3375	38.48	38.1675	38.48	1291580.0
2017-05-09 09:00:00	AAPL	Stock	38.4825	38.67	38.3775	38.52	33710980.0
2017-05-09 10:00:00	AAPL	Stock	38.52	38.72	38.515	38.644	25702412.0
2017-05-09 11:00:00	AAPL	Stock	38.6428	38.6475	38.429	38.485	17943832.0
2017-05-09 12:00:00	AAPL	Stock	38.4868	38.6325	38.4825	38.5875	11271192.0
2017-05-09 13:00:00	AAPL	Stock	38.5865	38.6125	38.435	38.47	9212508.0
2017-05-09 14:00:00	AAPL	Stock	38.4725	38.4875	38.3625	38.4325	10609644.0
2017-05-09 15:00:00	AAPL	Stock	38.4312	38.525	38.405	38.495	16602892.0
2017-05-09 16:00:00	AAPL	Stock	38.4925	38.5225	38.465	38.4925	11714448.0
2017-05-09 17:00:00	AAPL	Stock	38.4925	38.52	38.4825	38.4875	581040.0
2017-05-09 18:00:00	AAPL	Stock	38.47	38.4875	38.375	38.375	112072.0
2017-05-09 19:00:00	AAPL	Stock	38.395	38.4	38.325	38.325	180684.0
2017-05-09 04:00:00	MSFT	Stock	68.97	68.97	68.97	68.97	200.0
2017-05-09 06:00:00	MSFT	Stock	68.97	68.97	68.97	68.97	135.0
2017-05-09 07:00:00	MSFT	Stock	68.98	69.01	68.98	69.01	4435.0
2017-05-09 08:00:00	MSFT	Stock	69.04	69.04	68.94	68.94	3650.0
2017-05-09 09:00:00	MSFT	Stock	68.95	69.07	68.68	69.07	2300168.0
2017-05-09 10:00:00	MSFT	Stock	69.07	69.28	69.06	69.125	3365710.0
2017-05-09 11:00:00	MSFT	Stock	69.125	69.15	68.93	68.97	1952091.0
2017-05-09 12:00:00	MSFT	Stock	68.97	69.005	68.88	68.95	1055807.0
2017-05-09 13:00:00	MSFT	Stock	68.95	68.97	68.88	68.915	1289216.0
2017-05-09 14:00:00	MSFT	Stock	68.92	69.07	68.86	69.005	2553966.0
2017-05-09 15:00:00	MSFT	Stock	69.01	69.07	68.9	69.03	4345830.0
2017-05-09 16:00:00	MSFT	Stock	69.04	69.09	69.04	69.09	3255597.0
2017-05-09 17:00:00	MSFT	Stock	69.1	69.1	68.97	69.04	431522.0
2017-05-09 18:00:00	MSFT	Stock	69.01	69.01	68.96	68.96	1800.0
2017-05-09 19:00:00	MSFT	Stock	68.96	68.96	68.96	68.96	500.0
2017-05-09 06:00:00	NVDA	Stock	2.563	2.563	2.5628	2.5628	15800.0
2017-05-09 07:00:00	NVDA	Stock	2.57	2.5712	2.57	2.5712	35000.0
2017-05-09 08:00:00	NVDA	Stock	2.5712	2.574	2.5675	2.5725	326280.0
2017-05-09 09:00:00	NVDA	Stock	2.5725	2.6005	2.5665	2.5915	70633040.0
2017-05-09 10:00:00	NVDA	Stock	2.5915	2.611	2.5915	2.6025	66717960.0
2017-05-09 11:00:00	NVDA	Stock	2.6028	2.6223	2.5845	2.596	87697400.0
2017-05-09 12:00:00	NVDA	Stock	2.5962	2.6233	2.596	2.6143	62489880.0
2017-05-09 13:00:00	NVDA	Stock	2.6145	2.6168	2.5944	2.602	48641880.0
2017-05-09 14:00:00	NVDA	Stock	2.602	2.608	2.6001	2.6003	49794640.0
2017-05-09 15:00:00	NVDA	Stock	2.6005	2.602	2.5718	2.5723	119790840.0
2017-05-09 16:00:00	NVDA	Stock	2.571	2.9412	2.5	2.9238	162147320.0
2017-05-09 17:00:00	NVDA	Stock	2.9245	2.9612	2.5735	2.9462	82296040.0
2017-05-09 18:00:00	NVDA	Stock	2.9462	2.95	2.8465	2.8508	33733640.0
2017-05-09 19:00:00	NVDA	Stock	2.855	2.882	2.82	2.844	23728360.0
2017-05-09 04:00:00	AMZN	Stock	47.525	47.525	47.525	47.525	5000.0
2017-05-09 05:00:00	AMZN	Stock	47.5	47.5	47.5	47.5	2000.0
2017-05-09 06:00:00	AMZN	Stock	47.5415	47.5415	47.5415	47.5415	2420.0
2017-05-09 07:00:00	AMZN	Stock	47.5	47.5495	47.5	47.545	189280.0
2017-05-09 08:00:00	AMZN	Stock	47.531	47.6645	47.517	47.6195	669220.0

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

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