PREVIEW / stock_1hour / 2017-07-07

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-07-07.parquet
  size:    1.0 MB
  rows:    47,655
  symbols: 3,000

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-07-07 04:00:00	AAPL	Stock	35.6	35.6	35.6	35.6	3784.0
2017-07-07 06:00:00	AAPL	Stock	35.7	35.7075	35.7	35.7	7040.0
2017-07-07 07:00:00	AAPL	Stock	35.6625	35.6875	35.6625	35.675	8648.0
2017-07-07 08:00:00	AAPL	Stock	35.665	35.8725	35.665	35.8175	352956.0
2017-07-07 09:00:00	AAPL	Stock	35.8175	36.035	35.725	36.0037	12751904.0
2017-07-07 10:00:00	AAPL	Stock	36.0025	36.0325	35.875	35.959	8870852.0
2017-07-07 11:00:00	AAPL	Stock	35.9575	36.0625	35.92	36.0375	7374548.0
2017-07-07 12:00:00	AAPL	Stock	36.0375	36.0672	35.9825	36.0612	4983368.0
2017-07-07 13:00:00	AAPL	Stock	36.0612	36.1875	36.0475	36.1625	6331020.0
2017-07-07 14:00:00	AAPL	Stock	36.165	36.1675	36.045	36.1275	5794904.0
2017-07-07 15:00:00	AAPL	Stock	36.125	36.1462	36.005	36.0425	12292532.0
2017-07-07 16:00:00	AAPL	Stock	36.045	36.065	36.0375	36.055	7432476.0
2017-07-07 17:00:00	AAPL	Stock	36.055	36.0625	36.05	36.0525	19160.0
2017-07-07 18:00:00	AAPL	Stock	36.065	36.065	36.0525	36.0525	6644.0
2017-07-07 19:00:00	AAPL	Stock	36.065	36.065	36.04	36.065	64436.0
2017-07-07 07:00:00	MSFT	Stock	68.6	68.6	68.6	68.6	195.0
2017-07-07 08:00:00	MSFT	Stock	68.61	68.9	68.6	68.83	3032.0
2017-07-07 09:00:00	MSFT	Stock	68.83	69.2	68.7	69.18	2058496.0
2017-07-07 10:00:00	MSFT	Stock	69.175	69.28	69.03	69.086	1892039.0
2017-07-07 11:00:00	MSFT	Stock	69.09	69.485	69.042	69.44	1766097.0
2017-07-07 12:00:00	MSFT	Stock	69.44	69.545	69.43	69.52	1124391.0
2017-07-07 13:00:00	MSFT	Stock	69.52	69.83	69.513	69.825	1285076.0
2017-07-07 14:00:00	MSFT	Stock	69.83	69.84	69.5	69.51	1525454.0
2017-07-07 15:00:00	MSFT	Stock	69.505	69.54	69.41	69.45	3144429.0
2017-07-07 16:00:00	MSFT	Stock	69.45	69.53	69.45	69.52	1986404.0
2017-07-07 17:00:00	MSFT	Stock	69.52	69.52	69.48	69.5	1050.0
2017-07-07 18:00:00	MSFT	Stock	69.4	69.4	69.4	69.4	100.0
2017-07-07 19:00:00	MSFT	Stock	69.44	69.44	69.44	69.44	344.0
2017-07-07 05:00:00	NVDA	Stock	3.6148	3.6175	3.5938	3.5938	85680.0
2017-07-07 06:00:00	NVDA	Stock	3.603	3.603	3.5978	3.5978	8000.0
2017-07-07 07:00:00	NVDA	Stock	3.6083	3.6088	3.605	3.6062	157200.0
2017-07-07 08:00:00	NVDA	Stock	3.6088	3.6458	3.6062	3.6365	4790320.0
2017-07-07 09:00:00	NVDA	Stock	3.6365	3.6855	3.6212	3.6787	143243920.0
2017-07-07 10:00:00	NVDA	Stock	3.6778	3.6875	3.6631	3.6699	123855320.0
2017-07-07 11:00:00	NVDA	Stock	3.67	3.6798	3.6445	3.651	96004720.0
2017-07-07 12:00:00	NVDA	Stock	3.6518	3.663	3.6382	3.6498	58272320.0
2017-07-07 13:00:00	NVDA	Stock	3.6499	3.6748	3.6499	3.6695	49517200.0
2017-07-07 14:00:00	NVDA	Stock	3.6692	3.67	3.6395	3.653	50509960.0
2017-07-07 15:00:00	NVDA	Stock	3.6532	3.6705	3.6385	3.669	83661000.0
2017-07-07 16:00:00	NVDA	Stock	3.669	3.6692	3.6602	3.668	4061920.0
2017-07-07 17:00:00	NVDA	Stock	3.6668	3.6685	3.664	3.664	222680.0
2017-07-07 18:00:00	NVDA	Stock	3.665	3.6692	3.665	3.6678	190840.0
2017-07-07 19:00:00	NVDA	Stock	3.6688	3.672	3.6665	3.6688	337840.0
2017-07-07 07:00:00	AMZN	Stock	48.3005	48.3005	48.0	48.2	11160.0
2017-07-07 08:00:00	AMZN	Stock	48.25	48.625	48.2	48.4805	292820.0
2017-07-07 09:00:00	AMZN	Stock	48.4775	48.7475	48.425	48.7049	9989840.0
2017-07-07 10:00:00	AMZN	Stock	48.6925	48.7145	48.457	48.6705	6724780.0
2017-07-07 11:00:00	AMZN	Stock	48.663	48.862	48.63	48.8118	6052040.0
2017-07-07 12:00:00	AMZN	Stock	48.8215	48.921	48.8125	48.8962	4327260.0
2017-07-07 13:00:00	AMZN	Stock	48.8955	49.0055	48.8705	48.9945	3839860.0

> showing 50 of 47,655 rows — these rows as CSV

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