PREVIEW / stock_1hour / 2015-10-16

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-10-16.parquet
  size:    1.0 MB
  rows:    48,276
  symbols: 3,419

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
2015-10-16 04:00:00	AAPL	Stock	27.9775	27.99	27.9775	27.99	800.0
2015-10-16 05:00:00	AAPL	Stock	28.0025	28.0025	27.985	27.985	2400.0
2015-10-16 06:00:00	AAPL	Stock	27.9575	27.9575	27.91	27.925	13484.0
2015-10-16 07:00:00	AAPL	Stock	27.9075	27.9075	27.875	27.9	37184.0
2015-10-16 08:00:00	AAPL	Stock	27.9075	27.9625	27.8375	27.8575	573248.0
2015-10-16 09:00:00	AAPL	Stock	27.875	28.0	27.7875	27.8865	27969312.0
2015-10-16 10:00:00	AAPL	Stock	27.8875	27.97	27.7675	27.8675	24462636.0
2015-10-16 11:00:00	AAPL	Stock	27.8675	27.9375	27.805	27.8925	16066620.0
2015-10-16 12:00:00	AAPL	Stock	27.8925	27.8975	27.6875	27.7652	17409804.0
2015-10-16 13:00:00	AAPL	Stock	27.7675	27.7875	27.6675	27.6738	11840860.0
2015-10-16 14:00:00	AAPL	Stock	27.675	27.725	27.6325	27.6875	15165272.0
2015-10-16 15:00:00	AAPL	Stock	27.6888	27.7775	27.6888	27.755	24267896.0
2015-10-16 16:00:00	AAPL	Stock	27.76	27.775	27.74	27.7525	6773620.0
2015-10-16 17:00:00	AAPL	Stock	27.75	27.76	27.745	27.745	1442600.0
2015-10-16 18:00:00	AAPL	Stock	27.75	27.755	27.74	27.7525	33496.0
2015-10-16 19:00:00	AAPL	Stock	27.7425	27.7575	27.7375	27.74	34548.0
2015-10-16 04:00:00	MSFT	Stock	47.12	47.12	47.12	47.12	1700.0
2015-10-16 07:00:00	MSFT	Stock	47.01	47.01	47.01	47.01	400.0
2015-10-16 08:00:00	MSFT	Stock	47.01	47.1	47.01	47.1	2000.0
2015-10-16 09:00:00	MSFT	Stock	47.09	47.3	46.897	47.07	5538794.0
2015-10-16 10:00:00	MSFT	Stock	47.07	47.33	47.01	47.269	2570760.0
2015-10-16 11:00:00	MSFT	Stock	47.27	47.38	47.12	47.235	2255525.0
2015-10-16 12:00:00	MSFT	Stock	47.23	47.24	47.08	47.15	1441686.0
2015-10-16 13:00:00	MSFT	Stock	47.156	47.19	47.1	47.11	1061560.0
2015-10-16 14:00:00	MSFT	Stock	47.115	47.337	47.04	47.224	2204134.0
2015-10-16 15:00:00	MSFT	Stock	47.225	47.54	47.22	47.5	5831448.0
2015-10-16 16:00:00	MSFT	Stock	47.49	47.51	47.35	47.43	3885436.0
2015-10-16 17:00:00	MSFT	Stock	47.47	47.53	47.47	47.53	9501.0
2015-10-16 18:00:00	MSFT	Stock	47.53	47.54	47.51	47.54	591650.0
2015-10-16 19:00:00	MSFT	Stock	47.51	47.53	47.51	47.53	2873.0
2015-10-16 09:00:00	NVDA	Stock	0.6878	0.692	0.6865	0.689	34671840.0
2015-10-16 10:00:00	NVDA	Stock	0.6888	0.6978	0.6862	0.6968	77998120.0
2015-10-16 11:00:00	NVDA	Stock	0.6968	0.7	0.694	0.7	48094720.0
2015-10-16 12:00:00	NVDA	Stock	0.6999	0.7011	0.697	0.6999	36494000.0
2015-10-16 13:00:00	NVDA	Stock	0.6999	0.703	0.6958	0.6969	41651600.0
2015-10-16 14:00:00	NVDA	Stock	0.6969	0.6972	0.6919	0.6925	72350160.0
2015-10-16 15:00:00	NVDA	Stock	0.6925	0.6965	0.6921	0.6965	84363200.0
2015-10-16 16:00:00	NVDA	Stock	0.6965	0.6982	0.6955	0.698	3405640.0
2015-10-16 17:00:00	NVDA	Stock	0.6918	0.6918	0.69	0.69	17080.0
2015-10-16 19:00:00	NVDA	Stock	0.6965	0.6965	0.6965	0.6965	9760.0
2015-10-16 04:00:00	AMZN	Stock	28.19	28.19	28.176	28.176	6000.0
2015-10-16 06:00:00	AMZN	Stock	28.2375	28.24	28.15	28.15	20260.0
2015-10-16 07:00:00	AMZN	Stock	28.118	28.192	28.104	28.1895	57500.0
2015-10-16 08:00:00	AMZN	Stock	28.198	28.2325	28.1485	28.1825	191580.0
2015-10-16 09:00:00	AMZN	Stock	28.199	28.3672	28.0155	28.271	16290900.0
2015-10-16 10:00:00	AMZN	Stock	28.289	28.3815	28.1	28.211	11549660.0
2015-10-16 11:00:00	AMZN	Stock	28.2126	28.45	28.2	28.4325	7035140.0
2015-10-16 12:00:00	AMZN	Stock	28.4332	28.447	28.2535	28.3502	6715100.0
2015-10-16 13:00:00	AMZN	Stock	28.3527	28.4365	28.285	28.285	3950100.0
2015-10-16 14:00:00	AMZN	Stock	28.282	28.4729	28.256	28.4175	7097620.0

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

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