PREVIEW / stock_1hour / 2019-01-25

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-01-25.parquet
  size:    1.1 MB
  rows:    49,205
  symbols: 2,679

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-01-25 04:00:00	AAPL	Stock	38.3875	38.5525	38.3875	38.4375	33432.0
2019-01-25 05:00:00	AAPL	Stock	38.475	38.5	38.415	38.5	7100.0
2019-01-25 06:00:00	AAPL	Stock	38.465	38.4975	38.425	38.445	28364.0
2019-01-25 07:00:00	AAPL	Stock	38.47	38.47	38.3425	38.4575	180960.0
2019-01-25 08:00:00	AAPL	Stock	38.41	38.845	38.275	38.7775	870176.0
2019-01-25 09:00:00	AAPL	Stock	38.7825	39.09	38.58	39.0802	22955664.0
2019-01-25 10:00:00	AAPL	Stock	39.0775	39.3125	39.07	39.29	22444824.0
2019-01-25 11:00:00	AAPL	Stock	39.29	39.3125	39.0575	39.2525	13236632.0
2019-01-25 12:00:00	AAPL	Stock	39.2525	39.305	39.14	39.215	9266608.0
2019-01-25 13:00:00	AAPL	Stock	39.215	39.41	39.155	39.4068	9346832.0
2019-01-25 14:00:00	AAPL	Stock	39.41	39.5325	39.3182	39.4045	13705112.0
2019-01-25 15:00:00	AAPL	Stock	39.4025	39.505	39.305	39.43	19912780.0
2019-01-25 16:00:00	AAPL	Stock	39.44	39.4775	39.203	39.4775	7275916.0
2019-01-25 17:00:00	AAPL	Stock	39.4625	39.475	39.43	39.445	52904.0
2019-01-25 18:00:00	AAPL	Stock	39.45	39.4725	39.425	39.4725	35960.0
2019-01-25 19:00:00	AAPL	Stock	39.47	39.4925	39.455	39.455	70532.0
2019-01-25 04:00:00	MSFT	Stock	106.54	106.6	106.49	106.6	1800.0
2019-01-25 05:00:00	MSFT	Stock	106.6	106.68	106.6	106.6	1558.0
2019-01-25 06:00:00	MSFT	Stock	106.78	106.85	106.5	106.83	4018.0
2019-01-25 07:00:00	MSFT	Stock	106.7	106.88	106.54	106.76	30827.0
2019-01-25 08:00:00	MSFT	Stock	106.89	107.5	106.45	107.3	75796.0
2019-01-25 09:00:00	MSFT	Stock	107.25	107.35	106.59	107.095	3694234.0
2019-01-25 10:00:00	MSFT	Stock	107.09	107.58	106.98	107.565	4277913.0
2019-01-25 11:00:00	MSFT	Stock	107.57	107.82	107.305	107.81	3362173.0
2019-01-25 12:00:00	MSFT	Stock	107.81	107.88	107.24	107.34	2285236.0
2019-01-25 13:00:00	MSFT	Stock	107.33	107.46	107.16	107.25	1899663.0
2019-01-25 14:00:00	MSFT	Stock	107.256	107.335	106.85	107.03	2479647.0
2019-01-25 15:00:00	MSFT	Stock	107.03	107.18	106.8	107.17	5437520.0
2019-01-25 16:00:00	MSFT	Stock	107.17	107.615	106.2	107.07	5095420.0
2019-01-25 17:00:00	MSFT	Stock	107.08	107.15	107.03	107.03	17306.0
2019-01-25 18:00:00	MSFT	Stock	107.15	107.15	107.1	107.1	8350.0
2019-01-25 19:00:00	MSFT	Stock	107.12	107.2	107.05	107.2	5880.0
2019-01-25 04:00:00	NVDA	Stock	3.945	3.95	3.9375	3.9488	41600.0
2019-01-25 05:00:00	NVDA	Stock	3.9448	3.945	3.9438	3.945	24040.0
2019-01-25 06:00:00	NVDA	Stock	3.9448	3.9542	3.9002	3.9002	657160.0
2019-01-25 07:00:00	NVDA	Stock	3.9198	3.9375	3.885	3.8952	1624680.0
2019-01-25 08:00:00	NVDA	Stock	3.9125	3.9398	3.8888	3.9398	4839960.0
2019-01-25 09:00:00	NVDA	Stock	3.9398	3.9498	3.7825	3.866	207302200.0
2019-01-25 10:00:00	NVDA	Stock	3.8653	3.8742	3.8175	3.8468	109466040.0
2019-01-25 11:00:00	NVDA	Stock	3.848	3.909	3.8358	3.8998	76436880.0
2019-01-25 12:00:00	NVDA	Stock	3.8995	3.9875	3.8858	3.9871	137147720.0
2019-01-25 13:00:00	NVDA	Stock	3.9875	4.0182	3.9796	4.004	90705680.0
2019-01-25 14:00:00	NVDA	Stock	4.005	4.022	3.9759	4.0052	77883920.0
2019-01-25 15:00:00	NVDA	Stock	4.0052	4.008	3.988	4.0038	101306440.0
2019-01-25 16:00:00	NVDA	Stock	4.0038	4.011	3.9975	4.004	4598880.0
2019-01-25 17:00:00	NVDA	Stock	4.0052	4.0088	4.0038	4.008	1096160.0
2019-01-25 18:00:00	NVDA	Stock	4.0042	4.008	4.0038	4.0075	303640.0
2019-01-25 19:00:00	NVDA	Stock	4.008	4.008	4.0052	4.0075	484960.0
2019-01-25 06:00:00	AMZN	Stock	83.4965	83.4965	83.4965	83.4965	11080.0
2019-01-25 07:00:00	AMZN	Stock	83.4945	83.4945	83.125	83.2015	289700.0

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

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