PREVIEW / stock_1hour / 2019-08-12

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-08-12.parquet
  size:    1.1 MB
  rows:    51,142
  symbols: 2,534

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-08-12 04:00:00	AAPL	Stock	50.6225	50.6225	50.0125	50.0875	31604.0
2019-08-12 05:00:00	AAPL	Stock	50.05	50.055	49.9425	49.955	28596.0
2019-08-12 06:00:00	AAPL	Stock	49.945	49.945	49.7575	49.865	61364.0
2019-08-12 07:00:00	AAPL	Stock	49.875	49.995	49.725	49.8	138256.0
2019-08-12 08:00:00	AAPL	Stock	49.9625	50.0325	49.6975	49.925	240596.0
2019-08-12 09:00:00	AAPL	Stock	49.95	50.375	49.8375	50.375	12004464.0
2019-08-12 10:00:00	AAPL	Stock	50.3725	50.49	50.089	50.38	13450220.0
2019-08-12 11:00:00	AAPL	Stock	50.3775	50.4325	50.0725	50.38	9426316.0
2019-08-12 12:00:00	AAPL	Stock	50.3815	50.513	50.29	50.4225	6894196.0
2019-08-12 13:00:00	AAPL	Stock	50.4175	50.495	50.2875	50.3225	5216744.0
2019-08-12 14:00:00	AAPL	Stock	50.32	50.3725	49.7875	49.8425	8840832.0
2019-08-12 15:00:00	AAPL	Stock	49.84	50.19	49.82	50.125	11500004.0
2019-08-12 16:00:00	AAPL	Stock	50.12	50.1885	50.0375	50.0525	8336228.0
2019-08-12 17:00:00	AAPL	Stock	50.055	50.15	50.055	50.1025	34584.0
2019-08-12 18:00:00	AAPL	Stock	50.075	50.125	50.0625	50.125	13524.0
2019-08-12 19:00:00	AAPL	Stock	50.1325	50.175	50.1025	50.15	14684.0
2019-08-12 04:00:00	MSFT	Stock	138.22	138.5	136.92	137.31	3209.0
2019-08-12 05:00:00	MSFT	Stock	137.02	137.58	136.97	137.2	2066.0
2019-08-12 06:00:00	MSFT	Stock	136.97	136.97	136.7	136.95	2260.0
2019-08-12 07:00:00	MSFT	Stock	136.94	137.06	136.48	136.6	23920.0
2019-08-12 08:00:00	MSFT	Stock	137.0	137.08	136.48	137.0	31083.0
2019-08-12 09:00:00	MSFT	Stock	136.95	137.86	136.41	136.81	1905860.0
2019-08-12 10:00:00	MSFT	Stock	136.82	137.34	136.51	137.04	1879517.0
2019-08-12 11:00:00	MSFT	Stock	137.046	137.21	136.3	137.08	1715826.0
2019-08-12 12:00:00	MSFT	Stock	137.07	137.37	136.68	136.84	1258322.0
2019-08-12 13:00:00	MSFT	Stock	136.83	136.89	136.424	136.46	1140582.0
2019-08-12 14:00:00	MSFT	Stock	136.455	136.6	135.24	135.45	2132835.0
2019-08-12 15:00:00	MSFT	Stock	135.45	135.95	135.39	135.81	3037436.0
2019-08-12 16:00:00	MSFT	Stock	135.79	136.096	135.65	135.7	4088916.0
2019-08-12 17:00:00	MSFT	Stock	135.71	135.79	135.71	135.73	3200.0
2019-08-12 18:00:00	MSFT	Stock	135.71	135.79	135.71	135.76	3384.0
2019-08-12 19:00:00	MSFT	Stock	135.79	135.95	135.79	135.94	4409.0
2019-08-12 04:00:00	NVDA	Stock	3.869	3.869	3.845	3.845	32280.0
2019-08-12 05:00:00	NVDA	Stock	3.8348	3.8348	3.8348	3.8348	4000.0
2019-08-12 06:00:00	NVDA	Stock	3.8125	3.8125	3.7988	3.7988	25560.0
2019-08-12 07:00:00	NVDA	Stock	3.8125	3.8298	3.8028	3.8153	600160.0
2019-08-12 08:00:00	NVDA	Stock	3.8125	3.8248	3.805	3.814	1215480.0
2019-08-12 09:00:00	NVDA	Stock	3.8125	3.8545	3.7878	3.835	39388360.0
2019-08-12 10:00:00	NVDA	Stock	3.833	3.8448	3.8078	3.8178	35030120.0
2019-08-12 11:00:00	NVDA	Stock	3.8172	3.8242	3.7968	3.8095	22056640.0
2019-08-12 12:00:00	NVDA	Stock	3.8083	3.814	3.7952	3.8005	22508200.0
2019-08-12 13:00:00	NVDA	Stock	3.8002	3.805	3.7892	3.798	15076560.0
2019-08-12 14:00:00	NVDA	Stock	3.7978	3.8042	3.7642	3.769	20858640.0
2019-08-12 15:00:00	NVDA	Stock	3.7685	3.7935	3.7653	3.7862	45627200.0
2019-08-12 16:00:00	NVDA	Stock	3.7862	3.7912	3.78	3.7875	39007200.0
2019-08-12 17:00:00	NVDA	Stock	3.785	3.79	3.785	3.79	75840.0
2019-08-12 18:00:00	NVDA	Stock	3.7862	3.7918	3.7828	3.7875	109360.0
2019-08-12 19:00:00	NVDA	Stock	3.7862	3.7875	3.7828	3.7875	284080.0
2019-08-12 04:00:00	AMZN	Stock	90.99	90.99	90.99	90.99	14620.0
2019-08-12 05:00:00	AMZN	Stock	89.9875	90.05	89.9875	90.05	4440.0

> showing 50 of 51,142 rows — these rows as CSV

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