PREVIEW / stock_1hour / 2018-05-29

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-05-29.parquet
  size:    1.1 MB
  rows:    49,901
  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-05-29 04:00:00	AAPL	Stock	47.0775	47.0775	46.6875	46.725	31784.0
2018-05-29 05:00:00	AAPL	Stock	46.695	46.7625	46.675	46.7625	10768.0
2018-05-29 06:00:00	AAPL	Stock	46.7875	46.875	46.7875	46.875	800.0
2018-05-29 07:00:00	AAPL	Stock	46.8375	46.9125	46.75	46.9	190156.0
2018-05-29 08:00:00	AAPL	Stock	46.755	47.0125	46.755	46.975	398016.0
2018-05-29 09:00:00	AAPL	Stock	46.9625	47.1075	46.7175	47.0875	11120832.0
2018-05-29 10:00:00	AAPL	Stock	47.0875	47.1875	46.9575	47.035	11789912.0
2018-05-29 11:00:00	AAPL	Stock	47.035	47.045	46.7575	46.8075	9632228.0
2018-05-29 12:00:00	AAPL	Stock	46.805	46.95	46.735	46.915	8368912.0
2018-05-29 13:00:00	AAPL	Stock	46.9125	46.915	46.7725	46.825	6057292.0
2018-05-29 14:00:00	AAPL	Stock	46.825	46.96	46.75	46.785	7874584.0
2018-05-29 15:00:00	AAPL	Stock	46.785	47.0375	46.7525	46.965	13520112.0
2018-05-29 16:00:00	AAPL	Stock	46.975	47.0175	46.7015	47.0075	11552540.0
2018-05-29 17:00:00	AAPL	Stock	47.01	47.0225	47.0025	47.0175	22412.0
2018-05-29 18:00:00	AAPL	Stock	47.0125	47.0175	46.9925	46.9925	14872.0
2018-05-29 19:00:00	AAPL	Stock	46.9825	46.9825	46.925	46.925	23496.0
2018-05-29 04:00:00	MSFT	Stock	97.99	98.0	97.6	97.6	1136.0
2018-05-29 05:00:00	MSFT	Stock	97.47	97.76	97.47	97.76	526.0
2018-05-29 06:00:00	MSFT	Stock	97.77	97.8	97.77	97.8	600.0
2018-05-29 07:00:00	MSFT	Stock	97.84	97.84	97.73	97.75	2736.0
2018-05-29 08:00:00	MSFT	Stock	97.72	98.06	97.56	98.03	13862.0
2018-05-29 09:00:00	MSFT	Stock	98.03	98.45	97.38	98.32	2511814.0
2018-05-29 10:00:00	MSFT	Stock	98.31	98.88	98.22	98.25	3485594.0
2018-05-29 11:00:00	MSFT	Stock	98.25	98.48	97.53	97.54	3456952.0
2018-05-29 12:00:00	MSFT	Stock	97.545	97.955	97.23	97.9	2682240.0
2018-05-29 13:00:00	MSFT	Stock	97.9	97.97	97.5	97.77	1694029.0
2018-05-29 14:00:00	MSFT	Stock	97.75	97.86	97.36	97.405	2595736.0
2018-05-29 15:00:00	MSFT	Stock	97.41	98.16	97.33	98.01	4587175.0
2018-05-29 16:00:00	MSFT	Stock	98.01	98.22	97.44	98.15	4919144.0
2018-05-29 17:00:00	MSFT	Stock	98.11	98.22	98.1	98.22	6630.0
2018-05-29 18:00:00	MSFT	Stock	98.22	98.22	98.19	98.19	847.0
2018-05-29 19:00:00	MSFT	Stock	98.17	98.17	98.1	98.15	979.0
2018-05-29 04:00:00	NVDA	Stock	6.225	6.225	6.15	6.1725	63320.0
2018-05-29 05:00:00	NVDA	Stock	6.163	6.175	6.163	6.175	12000.0
2018-05-29 06:00:00	NVDA	Stock	6.155	6.1625	6.155	6.1625	12000.0
2018-05-29 07:00:00	NVDA	Stock	6.1562	6.1915	6.1513	6.1875	917120.0
2018-05-29 08:00:00	NVDA	Stock	6.1694	6.22	6.1588	6.213	782360.0
2018-05-29 09:00:00	NVDA	Stock	6.215	6.2835	6.2	6.27	63538320.0
2018-05-29 10:00:00	NVDA	Stock	6.271	6.2805	6.239	6.2585	52485280.0
2018-05-29 11:00:00	NVDA	Stock	6.2599	6.26	6.1928	6.1994	46316040.0
2018-05-29 12:00:00	NVDA	Stock	6.2	6.223	6.1675	6.2193	39476600.0
2018-05-29 13:00:00	NVDA	Stock	6.219	6.2228	6.1973	6.2108	20897760.0
2018-05-29 14:00:00	NVDA	Stock	6.2095	6.2193	6.1862	6.1875	38725640.0
2018-05-29 15:00:00	NVDA	Stock	6.1862	6.225	6.1768	6.2148	45361160.0
2018-05-29 16:00:00	NVDA	Stock	6.2148	6.222	6.1786	6.2163	3186960.0
2018-05-29 17:00:00	NVDA	Stock	6.2188	6.2198	6.2125	6.2125	129640.0
2018-05-29 18:00:00	NVDA	Stock	6.216	6.2245	6.216	6.2245	244000.0
2018-05-29 19:00:00	NVDA	Stock	6.211	6.211	6.2075	6.2075	194680.0
2018-05-29 05:00:00	AMZN	Stock	79.984	79.984	79.984	79.984	2000.0
2018-05-29 06:00:00	AMZN	Stock	80.121	80.18	80.014	80.0645	40000.0

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

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