PREVIEW / stock_1hour / 2019-01-28

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-01-28.parquet
  size:    1.1 MB
  rows:    49,802
  symbols: 2,693

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-28 04:00:00	AAPL	Stock	39.3225	39.345	39.25	39.3	56184.0
2019-01-28 05:00:00	AAPL	Stock	39.3	39.3	39.275	39.2775	3432.0
2019-01-28 06:00:00	AAPL	Stock	39.3	39.3125	39.27	39.27	6284.0
2019-01-28 07:00:00	AAPL	Stock	39.2875	39.3425	39.05	39.1	316788.0
2019-01-28 08:00:00	AAPL	Stock	39.275	39.5375	39.01	39.1	472268.0
2019-01-28 09:00:00	AAPL	Stock	39.1	39.1225	38.415	38.6425	18686532.0
2019-01-28 10:00:00	AAPL	Stock	38.6425	38.9175	38.58	38.5925	15399840.0
2019-01-28 11:00:00	AAPL	Stock	38.5875	38.794	38.5625	38.615	10465872.0
2019-01-28 12:00:00	AAPL	Stock	38.615	38.785	38.5925	38.7075	6261268.0
2019-01-28 13:00:00	AAPL	Stock	38.71	39.005	38.695	38.935	8144792.0
2019-01-28 14:00:00	AAPL	Stock	38.9375	39.07	38.8825	39.005	8607524.0
2019-01-28 15:00:00	AAPL	Stock	39.005	39.0825	38.9175	39.075	13314112.0
2019-01-28 16:00:00	AAPL	Stock	39.075	39.09	38.975	39.0	11556132.0
2019-01-28 17:00:00	AAPL	Stock	39.0	39.0	38.9575	38.9925	56920.0
2019-01-28 18:00:00	AAPL	Stock	38.975	38.9925	38.94	38.945	38556.0
2019-01-28 19:00:00	AAPL	Stock	38.935	38.9425	38.8525	38.9	74844.0
2019-01-28 04:00:00	MSFT	Stock	106.97	106.97	106.5	106.5	1631.0
2019-01-28 05:00:00	MSFT	Stock	106.64	106.7	106.64	106.7	998.0
2019-01-28 06:00:00	MSFT	Stock	106.59	106.66	106.51	106.51	4969.0
2019-01-28 07:00:00	MSFT	Stock	106.57	107.1	106.5	106.99	104855.0
2019-01-28 08:00:00	MSFT	Stock	106.58	107.45	106.53	106.85	52584.0
2019-01-28 09:00:00	MSFT	Stock	106.89	106.98	104.86	105.295	4277222.0
2019-01-28 10:00:00	MSFT	Stock	105.295	105.43	104.82	104.94	4518040.0
2019-01-28 11:00:00	MSFT	Stock	104.945	105.24	104.71	104.86	3396346.0
2019-01-28 12:00:00	MSFT	Stock	104.85	105.06	104.695	104.75	2631141.0
2019-01-28 13:00:00	MSFT	Stock	104.75	105.11	104.66	105.005	1822739.0
2019-01-28 14:00:00	MSFT	Stock	105.02	105.23	104.84	104.975	2285381.0
2019-01-28 15:00:00	MSFT	Stock	104.97	105.15	104.82	105.09	4697808.0
2019-01-28 16:00:00	MSFT	Stock	105.08	105.16	104.97	105.0	2413175.0
2019-01-28 17:00:00	MSFT	Stock	105.0	105.0	104.81	104.82	9412.0
2019-01-28 18:00:00	MSFT	Stock	104.85	104.85	104.75	104.85	5197.0
2019-01-28 19:00:00	MSFT	Stock	104.8	104.8	104.64	104.66	2888.0
2019-01-28 04:00:00	NVDA	Stock	3.9975	3.9975	3.9538	3.9775	28400.0
2019-01-28 06:00:00	NVDA	Stock	4.0028	4.0028	3.982	3.982	46600.0
2019-01-28 07:00:00	NVDA	Stock	3.9988	4.0022	3.9565	3.9575	799600.0
2019-01-28 08:00:00	NVDA	Stock	3.955	4.0138	3.9482	3.9628	2888280.0
2019-01-28 09:00:00	NVDA	Stock	3.9612	3.9663	3.275	3.3968	619970960.0
2019-01-28 10:00:00	NVDA	Stock	3.3965	3.541	3.3642	3.4903	597461360.0
2019-01-28 11:00:00	NVDA	Stock	3.491	3.5242	3.413	3.4275	347365400.0
2019-01-28 12:00:00	NVDA	Stock	3.428	3.4732	3.4045	3.41	195479720.0
2019-01-28 13:00:00	NVDA	Stock	3.4098	3.415	3.3765	3.3862	189277240.0
2019-01-28 14:00:00	NVDA	Stock	3.3861	3.437	3.3782	3.4242	177169680.0
2019-01-28 15:00:00	NVDA	Stock	3.4234	3.4615	3.419	3.449	270683880.0
2019-01-28 16:00:00	NVDA	Stock	3.4502	3.4635	3.4398	3.44	31875160.0
2019-01-28 17:00:00	NVDA	Stock	3.4403	3.4502	3.4288	3.4375	4063520.0
2019-01-28 18:00:00	NVDA	Stock	3.4395	3.4412	3.4375	3.4375	704720.0
2019-01-28 19:00:00	NVDA	Stock	3.4375	3.4375	3.426	3.4275	1178320.0
2019-01-28 05:00:00	AMZN	Stock	83.0295	83.0295	83.0295	83.0295	2000.0
2019-01-28 06:00:00	AMZN	Stock	83.0235	83.0645	83.0235	83.0305	17460.0
2019-01-28 07:00:00	AMZN	Stock	82.925	83.144	82.7775	82.85	210160.0

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

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