PREVIEW / stock_1hour / 2017-10-24

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-10-24.parquet
  size:    1.1 MB
  rows:    48,705
  symbols: 2,936

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-24 04:00:00	AAPL	Stock	38.825	39.1875	38.825	39.1125	36088.0
2017-10-24 05:00:00	AAPL	Stock	39.1125	39.1875	38.775	38.775	86344.0
2017-10-24 06:00:00	AAPL	Stock	38.7625	38.9325	38.7325	38.9325	96900.0
2017-10-24 07:00:00	AAPL	Stock	38.925	39.04	38.925	39.0125	238372.0
2017-10-24 08:00:00	AAPL	Stock	39.02	39.1975	38.9162	39.155	635964.0
2017-10-24 09:00:00	AAPL	Stock	39.145	39.2375	39.05	39.2	12521256.0
2017-10-24 10:00:00	AAPL	Stock	39.1995	39.355	39.1975	39.2275	12331216.0
2017-10-24 11:00:00	AAPL	Stock	39.2275	39.3125	39.2125	39.24	7882152.0
2017-10-24 12:00:00	AAPL	Stock	39.24	39.295	39.215	39.255	4377012.0
2017-10-24 13:00:00	AAPL	Stock	39.255	39.3225	39.2175	39.28	4337132.0
2017-10-24 14:00:00	AAPL	Stock	39.2825	39.2925	39.1825	39.191	4583048.0
2017-10-24 15:00:00	AAPL	Stock	39.19	39.275	39.1325	39.2725	10337988.0
2017-10-24 16:00:00	AAPL	Stock	39.2725	39.275	39.2125	39.215	4402996.0
2017-10-24 17:00:00	AAPL	Stock	39.22	39.2625	39.215	39.2625	20156.0
2017-10-24 18:00:00	AAPL	Stock	39.275	39.275	39.215	39.215	423788.0
2017-10-24 19:00:00	AAPL	Stock	39.2025	39.225	39.175	39.175	27380.0
2017-10-24 04:00:00	MSFT	Stock	78.92	78.92	78.9	78.9	605.0
2017-10-24 07:00:00	MSFT	Stock	78.93	78.93	78.93	78.93	267.0
2017-10-24 08:00:00	MSFT	Stock	78.84	79.1	78.84	79.0	7462.0
2017-10-24 09:00:00	MSFT	Stock	79.01	79.07	78.46	78.635	3255475.0
2017-10-24 10:00:00	MSFT	Stock	78.64	78.94	78.63	78.92	1920149.0
2017-10-24 11:00:00	MSFT	Stock	78.912	79.2	78.91	79.155	1629412.0
2017-10-24 12:00:00	MSFT	Stock	79.15	79.19	79.07	79.105	1026732.0
2017-10-24 13:00:00	MSFT	Stock	79.11	79.2	79.06	79.11	944200.0
2017-10-24 14:00:00	MSFT	Stock	79.105	79.18	78.935	78.96	1303955.0
2017-10-24 15:00:00	MSFT	Stock	78.96	79.0	78.71	78.86	3325598.0
2017-10-24 16:00:00	MSFT	Stock	78.86	78.89	78.77	78.83	1493726.0
2017-10-24 17:00:00	MSFT	Stock	78.86	78.86	78.83	78.85	850.0
2017-10-24 18:00:00	MSFT	Stock	78.86	78.86	78.81	78.81	149518.0
2017-10-24 19:00:00	MSFT	Stock	78.74	78.85	78.74	78.8	2195.0
2017-10-24 04:00:00	NVDA	Stock	4.9	4.9	4.9	4.9	9600.0
2017-10-24 06:00:00	NVDA	Stock	4.9288	4.9288	4.9278	4.9278	40000.0
2017-10-24 07:00:00	NVDA	Stock	4.93	4.9325	4.9225	4.927	200720.0
2017-10-24 08:00:00	NVDA	Stock	4.93	4.9358	4.9228	4.9298	1096080.0
2017-10-24 09:00:00	NVDA	Stock	4.9298	4.9375	4.8985	4.9205	62218720.0
2017-10-24 10:00:00	NVDA	Stock	4.9185	4.9468	4.916	4.9424	76101680.0
2017-10-24 11:00:00	NVDA	Stock	4.9424	4.9672	4.9388	4.9562	66940600.0
2017-10-24 12:00:00	NVDA	Stock	4.9558	4.959	4.9465	4.95	22787000.0
2017-10-24 13:00:00	NVDA	Stock	4.9499	4.961	4.937	4.9548	40858840.0
2017-10-24 14:00:00	NVDA	Stock	4.9542	4.9675	4.9518	4.9548	27411280.0
2017-10-24 15:00:00	NVDA	Stock	4.9553	4.9685	4.9513	4.9668	51670200.0
2017-10-24 16:00:00	NVDA	Stock	4.9688	4.973	4.9375	4.9378	15555560.0
2017-10-24 17:00:00	NVDA	Stock	4.9398	4.9485	4.9303	4.9338	1310720.0
2017-10-24 18:00:00	NVDA	Stock	4.9373	4.967	4.9315	4.9445	1557920.0
2017-10-24 19:00:00	NVDA	Stock	4.9462	4.948	4.943	4.945	845680.0
2017-10-24 05:00:00	AMZN	Stock	48.405	48.405	48.405	48.405	3140.0
2017-10-24 06:00:00	AMZN	Stock	48.4945	48.4945	48.44	48.44	4960.0
2017-10-24 07:00:00	AMZN	Stock	48.414	48.5065	48.4105	48.5065	54460.0
2017-10-24 08:00:00	AMZN	Stock	48.41	48.55	48.405	48.522	162800.0
2017-10-24 09:00:00	AMZN	Stock	48.49	48.744	48.25	48.6631	11738500.0

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

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