PREVIEW / stock_1hour / 2018-06-11

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-06-11.parquet
  size:    1.1 MB
  rows:    49,673
  symbols: 2,833

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-11 04:00:00	AAPL	Stock	47.9	47.9	47.8675	47.8675	3108.0
2018-06-11 05:00:00	AAPL	Stock	47.875	47.875	47.875	47.875	3904.0
2018-06-11 06:00:00	AAPL	Stock	47.8075	47.825	47.8075	47.825	1824.0
2018-06-11 07:00:00	AAPL	Stock	47.8125	47.9675	47.8125	47.9375	200360.0
2018-06-11 08:00:00	AAPL	Stock	47.8402	47.9675	47.8175	47.8925	151828.0
2018-06-11 09:00:00	AAPL	Stock	47.89	47.9925	47.725	47.78	10696416.0
2018-06-11 10:00:00	AAPL	Stock	47.7775	47.7975	47.5525	47.6312	12539556.0
2018-06-11 11:00:00	AAPL	Stock	47.6325	47.8412	47.6078	47.7962	7906552.0
2018-06-11 12:00:00	AAPL	Stock	47.7975	47.965	47.7875	47.93	7834488.0
2018-06-11 13:00:00	AAPL	Stock	47.9275	47.9475	47.84	47.845	5509280.0
2018-06-11 14:00:00	AAPL	Stock	47.8425	47.88	47.7875	47.8462	5158280.0
2018-06-11 15:00:00	AAPL	Stock	47.8475	47.8725	47.7675	47.815	9132168.0
2018-06-11 16:00:00	AAPL	Stock	47.8075	47.8325	47.7627	47.8075	5582408.0
2018-06-11 17:00:00	AAPL	Stock	47.805	47.8075	47.79	47.8075	15928.0
2018-06-11 18:00:00	AAPL	Stock	47.8	47.8125	47.7525	47.8	113124.0
2018-06-11 19:00:00	AAPL	Stock	47.785	47.815	47.7625	47.7625	29624.0
2018-06-11 04:00:00	MSFT	Stock	101.6	101.6	101.51	101.51	1432.0
2018-06-11 06:00:00	MSFT	Stock	101.67	101.67	101.67	101.67	300.0
2018-06-11 07:00:00	MSFT	Stock	101.63	101.8	101.63	101.79	3613.0
2018-06-11 08:00:00	MSFT	Stock	101.7	101.89	101.5	101.65	12018.0
2018-06-11 09:00:00	MSFT	Stock	101.59	101.69	100.67	101.13	3089058.0
2018-06-11 10:00:00	MSFT	Stock	101.13	101.18	100.82	101.11	2556274.0
2018-06-11 11:00:00	MSFT	Stock	101.11	101.488	100.98	101.47	1395513.0
2018-06-11 12:00:00	MSFT	Stock	101.48	101.54	101.34	101.37	1410386.0
2018-06-11 13:00:00	MSFT	Stock	101.367	101.44	101.2	101.275	1094189.0
2018-06-11 14:00:00	MSFT	Stock	101.27	101.275	101.04	101.18	1513795.0
2018-06-11 15:00:00	MSFT	Stock	101.185	101.34	101.0	101.08	3141918.0
2018-06-11 16:00:00	MSFT	Stock	101.08	101.475	100.91	101.03	6917112.0
2018-06-11 17:00:00	MSFT	Stock	101.0	101.15	101.0	101.15	7252.0
2018-06-11 18:00:00	MSFT	Stock	101.06	101.26	101.06	101.26	2267.0
2018-06-11 19:00:00	MSFT	Stock	101.22	101.22	101.08	101.1	1321.0
2018-06-11 05:00:00	NVDA	Stock	6.5448	6.5448	6.5438	6.5438	16000.0
2018-06-11 06:00:00	NVDA	Stock	6.5275	6.5275	6.5275	6.5275	8000.0
2018-06-11 07:00:00	NVDA	Stock	6.5213	6.5312	6.5165	6.5238	260080.0
2018-06-11 08:00:00	NVDA	Stock	6.525	6.5438	6.517	6.5438	635880.0
2018-06-11 09:00:00	NVDA	Stock	6.5475	6.5862	6.5165	6.554	42835760.0
2018-06-11 10:00:00	NVDA	Stock	6.5525	6.5655	6.5025	6.5185	41314800.0
2018-06-11 11:00:00	NVDA	Stock	6.5198	6.5335	6.5068	6.5272	28092160.0
2018-06-11 12:00:00	NVDA	Stock	6.528	6.5508	6.5248	6.5355	21870800.0
2018-06-11 13:00:00	NVDA	Stock	6.5358	6.5438	6.525	6.5325	16235920.0
2018-06-11 14:00:00	NVDA	Stock	6.5345	6.5438	6.5263	6.5332	17066880.0
2018-06-11 15:00:00	NVDA	Stock	6.534	6.543	6.5138	6.515	53468080.0
2018-06-11 16:00:00	NVDA	Stock	6.5155	6.5222	6.515	6.52	1425080.0
2018-06-11 17:00:00	NVDA	Stock	6.52	6.52	6.5162	6.5162	68480.0
2018-06-11 18:00:00	NVDA	Stock	6.515	6.52	6.515	6.52	135920.0
2018-06-11 19:00:00	NVDA	Stock	6.52	6.52	6.5147	6.515	162360.0
2018-06-11 05:00:00	AMZN	Stock	84.1505	84.1505	84.1505	84.1505	2000.0
2018-06-11 07:00:00	AMZN	Stock	84.2	84.25	84.08	84.08	40120.0
2018-06-11 08:00:00	AMZN	Stock	84.1	84.3	83.95	84.065	162940.0
2018-06-11 09:00:00	AMZN	Stock	84.065	84.7105	84.0295	84.614	8735740.0

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

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