PREVIEW / stock_1hour / 2018-09-04

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-09-04.parquet
  size:    1.1 MB
  rows:    50,220
  symbols: 2,797

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-09-04 04:00:00	AAPL	Stock	57.0625	57.175	57.0625	57.125	49288.0
2018-09-04 05:00:00	AAPL	Stock	57.125	57.125	57.02	57.0775	25820.0
2018-09-04 06:00:00	AAPL	Stock	57.065	57.085	56.99	57.0375	27560.0
2018-09-04 07:00:00	AAPL	Stock	57.0125	57.0825	56.8875	56.995	325868.0
2018-09-04 08:00:00	AAPL	Stock	57.04	57.08	56.8878	57.025	497876.0
2018-09-04 09:00:00	AAPL	Stock	57.045	57.235	56.6575	56.74	19056576.0
2018-09-04 10:00:00	AAPL	Stock	56.74	57.1875	56.73	57.125	16945828.0
2018-09-04 11:00:00	AAPL	Stock	57.1275	57.295	56.9112	56.93	13565560.0
2018-09-04 12:00:00	AAPL	Stock	56.93	57.09	56.7475	57.0268	10222472.0
2018-09-04 13:00:00	AAPL	Stock	57.0262	57.185	57.0175	57.1222	7091920.0
2018-09-04 14:00:00	AAPL	Stock	57.1225	57.145	57.0275	57.0975	5452052.0
2018-09-04 15:00:00	AAPL	Stock	57.105	57.1725	57.03	57.09	10800884.0
2018-09-04 16:00:00	AAPL	Stock	57.09	57.145	57.0625	57.1225	8471196.0
2018-09-04 17:00:00	AAPL	Stock	57.1425	57.1425	57.1125	57.1125	23608.0
2018-09-04 18:00:00	AAPL	Stock	57.09	57.125	57.075	57.125	38908.0
2018-09-04 19:00:00	AAPL	Stock	57.125	57.125	57.09	57.1125	30340.0
2018-09-04 04:00:00	MSFT	Stock	113.0	113.0	112.8	112.8	8840.0
2018-09-04 05:00:00	MSFT	Stock	112.56	112.56	112.5	112.5	425.0
2018-09-04 06:00:00	MSFT	Stock	112.4	112.4	112.35	112.35	1152.0
2018-09-04 07:00:00	MSFT	Stock	112.48	112.48	111.93	111.93	7015.0
2018-09-04 08:00:00	MSFT	Stock	112.1	112.8	111.92	112.33	8172.0
2018-09-04 09:00:00	MSFT	Stock	112.02	112.13	110.22	111.045	4476002.0
2018-09-04 10:00:00	MSFT	Stock	111.05	111.87	111.045	111.785	2829252.0
2018-09-04 11:00:00	MSFT	Stock	111.78	111.955	111.24	111.28	1971743.0
2018-09-04 12:00:00	MSFT	Stock	111.274	111.506	111.06	111.195	1913064.0
2018-09-04 13:00:00	MSFT	Stock	111.19	111.46	111.15	111.26	1325000.0
2018-09-04 14:00:00	MSFT	Stock	111.27	111.73	111.24	111.67	1404365.0
2018-09-04 15:00:00	MSFT	Stock	111.67	111.81	111.52	111.74	3268447.0
2018-09-04 16:00:00	MSFT	Stock	111.71	111.9	110.985	111.87	3184450.0
2018-09-04 17:00:00	MSFT	Stock	111.87	111.89	111.8	111.87	4780.0
2018-09-04 18:00:00	MSFT	Stock	111.8	111.87	111.8	111.87	500.0
2018-09-04 19:00:00	MSFT	Stock	111.75	111.8	111.75	111.76	1369.0
2018-09-04 04:00:00	NVDA	Stock	7.05	7.05	7.05	7.05	4000.0
2018-09-04 05:00:00	NVDA	Stock	7.0625	7.0632	7.0625	7.0632	8000.0
2018-09-04 06:00:00	NVDA	Stock	7.0565	7.0728	7.0528	7.0528	122000.0
2018-09-04 07:00:00	NVDA	Stock	7.044	7.044	7.0025	7.0123	386240.0
2018-09-04 08:00:00	NVDA	Stock	7.021	7.0488	7.0025	7.0258	1349520.0
2018-09-04 09:00:00	NVDA	Stock	7.032	7.048	6.975	6.9912	52785120.0
2018-09-04 10:00:00	NVDA	Stock	6.9938	7.1295	6.9935	7.1227	105927520.0
2018-09-04 11:00:00	NVDA	Stock	7.1235	7.1255	7.0752	7.0858	42770640.0
2018-09-04 12:00:00	NVDA	Stock	7.0838	7.117	7.069	7.1082	29765680.0
2018-09-04 13:00:00	NVDA	Stock	7.109	7.1305	7.0755	7.0955	26515600.0
2018-09-04 14:00:00	NVDA	Stock	7.0942	7.1265	7.0942	7.1218	25533840.0
2018-09-04 15:00:00	NVDA	Stock	7.1213	7.1238	7.085	7.0925	49496280.0
2018-09-04 16:00:00	NVDA	Stock	7.0925	7.105	7.0465	7.1022	3362200.0
2018-09-04 17:00:00	NVDA	Stock	7.0975	7.101	7.094	7.101	83600.0
2018-09-04 18:00:00	NVDA	Stock	7.095	7.095	7.08	7.08	140720.0
2018-09-04 19:00:00	NVDA	Stock	7.0875	7.0912	7.0875	7.0912	8000.0
2018-09-04 04:00:00	AMZN	Stock	101.4	101.8	101.4	101.55	40620.0
2018-09-04 05:00:00	AMZN	Stock	101.5005	101.5005	101.26	101.422	29220.0

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

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