PREVIEW / stock_1hour / 2019-06-26

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-06-26.parquet
  size:    1.1 MB
  rows:    50,245
  symbols: 2,622

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
2019-06-26 04:00:00	AAPL	Stock	49.0325	49.3	48.9725	49.3	10288.0
2019-06-26 05:00:00	AAPL	Stock	49.255	49.6875	49.2525	49.675	51168.0
2019-06-26 06:00:00	AAPL	Stock	49.6925	49.7	49.505	49.5075	41396.0
2019-06-26 07:00:00	AAPL	Stock	49.57	49.615	49.4875	49.545	160556.0
2019-06-26 08:00:00	AAPL	Stock	49.575	49.625	49.2825	49.44	448056.0
2019-06-26 09:00:00	AAPL	Stock	49.4175	50.2375	49.3375	50.2275	18331344.0
2019-06-26 10:00:00	AAPL	Stock	50.2275	50.2475	49.9738	50.057	13487520.0
2019-06-26 11:00:00	AAPL	Stock	50.0525	50.16	49.8825	50.1592	10907792.0
2019-06-26 12:00:00	AAPL	Stock	50.1575	50.23	50.0975	50.13	7227680.0
2019-06-26 13:00:00	AAPL	Stock	50.13	50.1375	49.885	49.9575	6038524.0
2019-06-26 14:00:00	AAPL	Stock	49.955	49.9735	49.8225	49.9125	5966816.0
2019-06-26 15:00:00	AAPL	Stock	49.915	50.05	49.8925	49.95	12028788.0
2019-06-26 16:00:00	AAPL	Stock	49.95	50.0	49.895	49.925	10479592.0
2019-06-26 17:00:00	AAPL	Stock	49.915	49.965	49.915	49.95	41460.0
2019-06-26 18:00:00	AAPL	Stock	49.94	49.965	49.915	49.955	18460.0
2019-06-26 19:00:00	AAPL	Stock	49.95	49.9975	49.95	49.9975	35068.0
2019-06-26 04:00:00	MSFT	Stock	134.0	134.07	133.95	133.95	2925.0
2019-06-26 05:00:00	MSFT	Stock	134.2	135.0	134.2	134.76	5085.0
2019-06-26 06:00:00	MSFT	Stock	134.95	135.0	134.62	134.89	10035.0
2019-06-26 07:00:00	MSFT	Stock	134.65	134.95	134.58	134.77	38677.0
2019-06-26 08:00:00	MSFT	Stock	134.8	134.97	133.76	134.21	77232.0
2019-06-26 09:00:00	MSFT	Stock	134.27	135.74	134.168	135.53	3685222.0
2019-06-26 10:00:00	MSFT	Stock	135.53	135.57	134.73	135.04	2917099.0
2019-06-26 11:00:00	MSFT	Stock	135.03	135.13	134.665	134.9	1853657.0
2019-06-26 12:00:00	MSFT	Stock	134.92	135.08	134.84	135.008	1561053.0
2019-06-26 13:00:00	MSFT	Stock	135.01	135.01	133.92	134.125	1794176.0
2019-06-26 14:00:00	MSFT	Stock	134.12	134.26	133.6	133.845	1503108.0
2019-06-26 15:00:00	MSFT	Stock	133.84	134.225	133.83	133.93	2393689.0
2019-06-26 16:00:00	MSFT	Stock	133.89	134.0	133.7	133.76	4232175.0
2019-06-26 17:00:00	MSFT	Stock	133.76	133.92	133.71	133.85	3334.0
2019-06-26 18:00:00	MSFT	Stock	133.8	133.92	133.74	133.74	2370.0
2019-06-26 19:00:00	MSFT	Stock	133.79	133.95	133.72	133.95	4558.0
2019-06-26 04:00:00	NVDA	Stock	3.8592	3.8592	3.8478	3.8478	90840.0
2019-06-26 05:00:00	NVDA	Stock	3.85	3.8998	3.8498	3.8998	251560.0
2019-06-26 06:00:00	NVDA	Stock	3.9	3.9	3.8815	3.8815	135080.0
2019-06-26 07:00:00	NVDA	Stock	3.8818	3.89	3.8738	3.8892	840760.0
2019-06-26 08:00:00	NVDA	Stock	3.8788	3.8922	3.8668	3.8818	2943960.0
2019-06-26 09:00:00	NVDA	Stock	3.8825	4.027	3.88	4.018	154745280.0
2019-06-26 10:00:00	NVDA	Stock	4.0193	4.0345	3.9715	4.0018	98172120.0
2019-06-26 11:00:00	NVDA	Stock	4.002	4.0402	3.9995	4.0401	64776760.0
2019-06-26 12:00:00	NVDA	Stock	4.0408	4.043	4.0118	4.0123	46711600.0
2019-06-26 13:00:00	NVDA	Stock	4.0123	4.015	3.9858	3.9984	39067320.0
2019-06-26 14:00:00	NVDA	Stock	3.9992	4.0085	3.98	3.9802	34720800.0
2019-06-26 15:00:00	NVDA	Stock	3.98	3.99	3.9758	3.9812	62219120.0
2019-06-26 16:00:00	NVDA	Stock	3.9815	4.0045	3.9762	3.9935	5191600.0
2019-06-26 17:00:00	NVDA	Stock	3.9968	3.9998	3.989	3.9998	290000.0
2019-06-26 18:00:00	NVDA	Stock	3.9992	4.0075	3.9975	4.0045	379160.0
2019-06-26 19:00:00	NVDA	Stock	4.0045	4.025	4.0038	4.025	440120.0
2019-06-26 06:00:00	AMZN	Stock	94.8335	94.8335	94.707	94.707	28180.0
2019-06-26 07:00:00	AMZN	Stock	94.844	94.95	94.75	94.9	187380.0

> showing 50 of 50,245 rows — these rows as CSV

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