PREVIEW / stock_1hour / 2019-01-07

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-01-07.parquet
  size:    1.1 MB
  rows:    50,142
  symbols: 2,698

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-07 04:00:00	AAPL	Stock	37.1625	37.225	37.0375	37.0375	40640.0
2019-01-07 05:00:00	AAPL	Stock	37.05	37.1475	37.0	37.125	69164.0
2019-01-07 06:00:00	AAPL	Stock	37.125	37.125	36.9975	37.0575	31368.0
2019-01-07 07:00:00	AAPL	Stock	37.0525	37.1725	37.0025	37.1	226764.0
2019-01-07 08:00:00	AAPL	Stock	37.1882	37.1882	36.925	37.0	546264.0
2019-01-07 09:00:00	AAPL	Stock	37.025	37.21	36.6075	36.825	26078040.0
2019-01-07 10:00:00	AAPL	Stock	36.815	37.2075	36.675	37.0075	28665120.0
2019-01-07 11:00:00	AAPL	Stock	37.0075	37.0075	36.475	36.8175	36921776.0
2019-01-07 12:00:00	AAPL	Stock	36.8175	36.9712	36.7025	36.92	19270412.0
2019-01-07 13:00:00	AAPL	Stock	36.92	37.03	36.6515	36.7125	19597776.0
2019-01-07 14:00:00	AAPL	Stock	36.7125	36.7975	36.5525	36.748	16283360.0
2019-01-07 15:00:00	AAPL	Stock	36.7475	37.1	36.7375	36.9725	33909548.0
2019-01-07 16:00:00	AAPL	Stock	36.9825	37.0462	36.9325	36.9625	12763708.0
2019-01-07 17:00:00	AAPL	Stock	36.945	36.9825	36.925	36.95	114368.0
2019-01-07 18:00:00	AAPL	Stock	36.9525	36.9725	36.9025	36.9125	49416.0
2019-01-07 19:00:00	AAPL	Stock	36.925	37.015	36.9025	37.015	111292.0
2019-01-07 04:00:00	MSFT	Stock	102.18	102.18	101.7	101.85	4718.0
2019-01-07 05:00:00	MSFT	Stock	102.0	102.0	101.05	101.51	11607.0
2019-01-07 06:00:00	MSFT	Stock	101.7	101.7	100.51	101.4	11847.0
2019-01-07 07:00:00	MSFT	Stock	101.16	101.85	101.16	101.21	47891.0
2019-01-07 08:00:00	MSFT	Stock	101.6	101.66	100.75	101.05	85875.0
2019-01-07 09:00:00	MSFT	Stock	101.17	102.01	101.08	101.609	3949165.0
2019-01-07 10:00:00	MSFT	Stock	101.6	102.54	100.98	102.28	4902522.0
2019-01-07 11:00:00	MSFT	Stock	102.275	103.268	102.159	103.18	4703666.0
2019-01-07 12:00:00	MSFT	Stock	103.18	103.24	102.74	103.07	2320869.0
2019-01-07 13:00:00	MSFT	Stock	103.07	103.24	102.69	102.79	2402628.0
2019-01-07 14:00:00	MSFT	Stock	102.78	102.916	101.97	102.05	2865519.0
2019-01-07 15:00:00	MSFT	Stock	102.04	102.41	102.0	102.06	4819098.0
2019-01-07 16:00:00	MSFT	Stock	102.06	102.265	101.92	102.06	5154456.0
2019-01-07 17:00:00	MSFT	Stock	102.08	102.12	101.99	102.08	8064.0
2019-01-07 18:00:00	MSFT	Stock	102.11	102.11	101.98	101.98	3909.0
2019-01-07 19:00:00	MSFT	Stock	102.1	102.35	102.04	102.16	6348.0
2019-01-07 04:00:00	NVDA	Stock	3.4375	3.4375	3.4125	3.415	86000.0
2019-01-07 05:00:00	NVDA	Stock	3.421	3.4375	3.4028	3.425	81320.0
2019-01-07 06:00:00	NVDA	Stock	3.4255	3.4255	3.4102	3.4125	161560.0
2019-01-07 07:00:00	NVDA	Stock	3.4282	3.4375	3.41	3.4175	769320.0
2019-01-07 08:00:00	NVDA	Stock	3.425	3.4375	3.4125	3.4128	1799560.0
2019-01-07 09:00:00	NVDA	Stock	3.413	3.5046	3.4108	3.4953	110002960.0
2019-01-07 10:00:00	NVDA	Stock	3.4953	3.5225	3.472	3.521	104098280.0
2019-01-07 11:00:00	NVDA	Stock	3.5205	3.5662	3.518	3.56	78646440.0
2019-01-07 12:00:00	NVDA	Stock	3.5575	3.621	3.5517	3.5943	96224720.0
2019-01-07 13:00:00	NVDA	Stock	3.5943	3.6203	3.5806	3.5843	54157600.0
2019-01-07 14:00:00	NVDA	Stock	3.585	3.6153	3.5742	3.5984	53153880.0
2019-01-07 15:00:00	NVDA	Stock	3.5972	3.6222	3.583	3.585	81673800.0
2019-01-07 16:00:00	NVDA	Stock	3.585	3.5968	3.5838	3.5938	26662920.0
2019-01-07 17:00:00	NVDA	Stock	3.5975	3.6142	3.5938	3.6142	481040.0
2019-01-07 18:00:00	NVDA	Stock	3.61	3.6142	3.6045	3.6055	806000.0
2019-01-07 19:00:00	NVDA	Stock	3.6075	3.6112	3.6	3.61	904360.0
2019-01-07 04:00:00	AMZN	Stock	79.4865	79.6875	79.3	79.3	53080.0
2019-01-07 05:00:00	AMZN	Stock	79.589	79.589	79.589	79.589	6280.0

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

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