PREVIEW / stock_1hour / 2019-05-17

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-05-17.parquet
  size:    1.1 MB
  rows:    49,372
  symbols: 2,609

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-05-17 04:00:00	AAPL	Stock	47.375	47.375	47.0625	47.07	119284.0
2019-05-17 05:00:00	AAPL	Stock	47.095	47.265	47.0875	47.235	17960.0
2019-05-17 06:00:00	AAPL	Stock	47.2025	47.2025	46.905	47.0025	26836.0
2019-05-17 07:00:00	AAPL	Stock	47.05	47.1125	46.8	46.86	302760.0
2019-05-17 08:00:00	AAPL	Stock	47.086	47.6375	46.595	46.725	571168.0
2019-05-17 09:00:00	AAPL	Stock	46.705	47.085	46.6275	46.921	16840512.0
2019-05-17 10:00:00	AAPL	Stock	46.9175	47.5375	46.7025	47.4825	19256364.0
2019-05-17 11:00:00	AAPL	Stock	47.48	47.725	47.1425	47.3138	12836492.0
2019-05-17 12:00:00	AAPL	Stock	47.3125	47.555	47.145	47.4875	9271912.0
2019-05-17 13:00:00	AAPL	Stock	47.4875	47.555	47.3375	47.4875	7775740.0
2019-05-17 14:00:00	AAPL	Stock	47.4875	47.5325	47.34	47.4843	7713744.0
2019-05-17 15:00:00	AAPL	Stock	47.4825	47.49	47.0	47.245	22729972.0
2019-05-17 16:00:00	AAPL	Stock	47.2412	47.2625	46.9202	47.175	9963404.0
2019-05-17 17:00:00	AAPL	Stock	47.1775	47.2375	47.175	47.1875	27296.0
2019-05-17 18:00:00	AAPL	Stock	47.1775	47.22	47.175	47.175	5444.0
2019-05-17 19:00:00	AAPL	Stock	47.2225	47.3375	47.1775	47.25	27504.0
2019-05-17 04:00:00	MSFT	Stock	128.76	128.77	128.03	128.13	5231.0
2019-05-17 05:00:00	MSFT	Stock	128.07	128.62	127.91	128.54	3150.0
2019-05-17 06:00:00	MSFT	Stock	128.5	128.5	128.21	128.3	2088.0
2019-05-17 07:00:00	MSFT	Stock	128.27	128.27	128.01	128.1	23278.0
2019-05-17 08:00:00	MSFT	Stock	128.15	129.25	127.75	128.013	51480.0
2019-05-17 09:00:00	MSFT	Stock	128.05	129.06	127.88	128.56	3305009.0
2019-05-17 10:00:00	MSFT	Stock	128.55	130.03	128.375	129.96	3831836.0
2019-05-17 11:00:00	MSFT	Stock	129.95	130.46	129.13	129.27	3260867.0
2019-05-17 12:00:00	MSFT	Stock	129.27	129.3	128.824	129.11	1746333.0
2019-05-17 13:00:00	MSFT	Stock	129.11	129.383	128.87	129.35	1552815.0
2019-05-17 14:00:00	MSFT	Stock	129.36	129.5	128.98	129.11	1539525.0
2019-05-17 15:00:00	MSFT	Stock	129.11	129.14	127.92	128.07	4711477.0
2019-05-17 16:00:00	MSFT	Stock	128.07	128.19	127.91	128.0	2436883.0
2019-05-17 17:00:00	MSFT	Stock	128.0	128.05	127.81	128.0	16459.0
2019-05-17 18:00:00	MSFT	Stock	128.0	128.0	127.94	127.94	800.0
2019-05-17 19:00:00	MSFT	Stock	127.94	128.15	127.94	128.07	5274.0
2019-05-17 04:00:00	NVDA	Stock	4.0888	4.105	4.065	4.0678	1314440.0
2019-05-17 05:00:00	NVDA	Stock	4.075	4.0788	4.0662	4.0788	416640.0
2019-05-17 06:00:00	NVDA	Stock	4.068	4.0742	4.0508	4.0588	210640.0
2019-05-17 07:00:00	NVDA	Stock	4.0625	4.0725	3.9565	3.9725	7903800.0
2019-05-17 08:00:00	NVDA	Stock	3.9838	4.05	3.9562	3.9782	12843960.0
2019-05-17 09:00:00	NVDA	Stock	3.9782	4.0928	3.9268	4.059	237564520.0
2019-05-17 10:00:00	NVDA	Stock	4.061	4.078	3.9945	4.0535	160038000.0
2019-05-17 11:00:00	NVDA	Stock	4.0532	4.0725	3.978	3.9878	102930520.0
2019-05-17 12:00:00	NVDA	Stock	3.9875	4.0112	3.9715	4.003	63839560.0
2019-05-17 13:00:00	NVDA	Stock	4.0038	4.021	3.98	3.9945	62212040.0
2019-05-17 14:00:00	NVDA	Stock	3.9937	4.0048	3.9583	3.968	61400080.0
2019-05-17 15:00:00	NVDA	Stock	3.9678	3.9698	3.8735	3.9134	193077200.0
2019-05-17 16:00:00	NVDA	Stock	3.9135	3.9182	3.8838	3.9138	33468280.0
2019-05-17 17:00:00	NVDA	Stock	3.9138	3.9162	3.9088	3.913	1590640.0
2019-05-17 18:00:00	NVDA	Stock	3.9092	3.9355	3.9092	3.9202	1653720.0
2019-05-17 19:00:00	NVDA	Stock	3.9242	3.9328	3.9188	3.925	821360.0
2019-05-17 04:00:00	AMZN	Stock	95.3425	95.3425	94.8005	94.8005	21220.0
2019-05-17 05:00:00	AMZN	Stock	94.6955	94.8855	94.6955	94.8855	15620.0

> showing 50 of 49,372 rows — these rows as CSV

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