PREVIEW / stock_1hour / 2017-10-25

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-10-25.parquet
  size:    1.1 MB
  rows:    48,265
  symbols: 2,926

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-10-25 04:00:00	AAPL	Stock	39.235	39.2475	39.23	39.23	7960.0
2017-10-25 05:00:00	AAPL	Stock	39.2475	39.31	39.2375	39.2375	8880.0
2017-10-25 06:00:00	AAPL	Stock	39.3225	39.3225	39.25	39.3	7188.0
2017-10-25 07:00:00	AAPL	Stock	39.2775	39.35	39.2775	39.3	31520.0
2017-10-25 08:00:00	AAPL	Stock	39.3	39.3175	39.275	39.3175	92628.0
2017-10-25 09:00:00	AAPL	Stock	39.3025	39.3875	39.1125	39.2125	9076256.0
2017-10-25 10:00:00	AAPL	Stock	39.21	39.3	39.1575	39.215	9553716.0
2017-10-25 11:00:00	AAPL	Stock	39.2175	39.2175	38.9125	39.0375	11148432.0
2017-10-25 12:00:00	AAPL	Stock	39.035	39.0825	38.8175	39.0062	12589896.0
2017-10-25 13:00:00	AAPL	Stock	39.005	39.1	38.96	39.0725	5413512.0
2017-10-25 14:00:00	AAPL	Stock	39.0725	39.1175	38.9825	39.0325	6625360.0
2017-10-25 15:00:00	AAPL	Stock	39.03	39.1375	39.0075	39.1025	9918376.0
2017-10-25 16:00:00	AAPL	Stock	39.105	39.275	39.1	39.1175	8925760.0
2017-10-25 17:00:00	AAPL	Stock	39.1175	39.1375	39.115	39.135	105264.0
2017-10-25 18:00:00	AAPL	Stock	39.125	39.1375	39.125	39.125	58424.0
2017-10-25 19:00:00	AAPL	Stock	39.13	39.1375	39.105	39.1375	36188.0
2017-10-25 04:00:00	MSFT	Stock	78.7	78.7	78.7	78.7	100.0
2017-10-25 05:00:00	MSFT	Stock	78.61	78.89	78.61	78.89	600.0
2017-10-25 07:00:00	MSFT	Stock	78.95	79.37	78.8	78.8	6434.0
2017-10-25 08:00:00	MSFT	Stock	78.8	78.84	78.7	78.7	6862.0
2017-10-25 09:00:00	MSFT	Stock	78.8	79.03	78.53	78.74	1905059.0
2017-10-25 10:00:00	MSFT	Stock	78.73	79.1	78.73	78.815	2383848.0
2017-10-25 11:00:00	MSFT	Stock	78.81	78.82	78.2	78.52	2699761.0
2017-10-25 12:00:00	MSFT	Stock	78.52	78.61	78.01	78.34	2813763.0
2017-10-25 13:00:00	MSFT	Stock	78.34	78.525	78.28	78.375	1645049.0
2017-10-25 14:00:00	MSFT	Stock	78.37	78.576	78.36	78.55	1268620.0
2017-10-25 15:00:00	MSFT	Stock	78.54	78.77	78.476	78.64	2682232.0
2017-10-25 16:00:00	MSFT	Stock	78.63	78.78	78.496	78.74	2425229.0
2017-10-25 17:00:00	MSFT	Stock	78.62	78.72	78.48	78.72	40415.0
2017-10-25 18:00:00	MSFT	Stock	78.77	78.8	78.66	78.73	6433.0
2017-10-25 19:00:00	MSFT	Stock	78.73	78.73	78.65	78.65	1555.0
2017-10-25 04:00:00	NVDA	Stock	4.9263	4.9263	4.9263	4.9263	14000.0
2017-10-25 05:00:00	NVDA	Stock	4.941	4.941	4.941	4.941	4000.0
2017-10-25 06:00:00	NVDA	Stock	4.946	4.95	4.9438	4.95	34280.0
2017-10-25 07:00:00	NVDA	Stock	4.945	4.9488	4.9352	4.94	589720.0
2017-10-25 08:00:00	NVDA	Stock	4.9488	4.9488	4.9362	4.9362	1389880.0
2017-10-25 09:00:00	NVDA	Stock	4.94	4.9805	4.921	4.9358	77350400.0
2017-10-25 10:00:00	NVDA	Stock	4.9361	4.9663	4.9218	4.9448	90585240.0
2017-10-25 11:00:00	NVDA	Stock	4.9448	4.9448	4.802	4.838	201188000.0
2017-10-25 12:00:00	NVDA	Stock	4.839	4.8523	4.7792	4.8252	135020080.0
2017-10-25 13:00:00	NVDA	Stock	4.826	4.8724	4.8238	4.8478	67075800.0
2017-10-25 14:00:00	NVDA	Stock	4.848	4.8888	4.8413	4.855	65332440.0
2017-10-25 15:00:00	NVDA	Stock	4.855	4.8633	4.835	4.841	80861080.0
2017-10-25 16:00:00	NVDA	Stock	4.8415	4.8528	4.8415	4.8525	25780840.0
2017-10-25 17:00:00	NVDA	Stock	4.8475	4.8528	4.8428	4.85	570800.0
2017-10-25 18:00:00	NVDA	Stock	4.85	4.85	4.8458	4.8498	324760.0
2017-10-25 19:00:00	NVDA	Stock	4.8463	4.855	4.8463	4.85	428600.0
2017-10-25 07:00:00	AMZN	Stock	48.85	48.8965	48.85	48.85	8980.0
2017-10-25 08:00:00	AMZN	Stock	48.8645	48.9285	48.811	48.8335	97780.0
2017-10-25 09:00:00	AMZN	Stock	48.85	49.222	48.85	48.9075	7735300.0

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

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