PREVIEW / stock_1hour / 2018-07-10

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-07-10.parquet
  size:    1.1 MB
  rows:    50,045
  symbols: 2,823

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-07-10 04:00:00	AAPL	Stock	47.6425	47.6425	47.565	47.565	2236.0
2018-07-10 05:00:00	AAPL	Stock	47.565	47.6975	47.5625	47.6975	12288.0
2018-07-10 06:00:00	AAPL	Stock	47.66	47.6875	47.65	47.6875	28812.0
2018-07-10 07:00:00	AAPL	Stock	47.685	47.75	47.645	47.695	159884.0
2018-07-10 08:00:00	AAPL	Stock	47.7105	47.735	47.625	47.675	179780.0
2018-07-10 09:00:00	AAPL	Stock	47.665	47.7825	47.555	47.65	8893968.0
2018-07-10 10:00:00	AAPL	Stock	47.6475	47.8	47.5675	47.7425	9572024.0
2018-07-10 11:00:00	AAPL	Stock	47.7475	47.8025	47.69	47.7975	6427144.0
2018-07-10 12:00:00	AAPL	Stock	47.7985	47.82	47.705	47.7175	4666652.0
2018-07-10 13:00:00	AAPL	Stock	47.7175	47.73	47.5675	47.6268	4974488.0
2018-07-10 14:00:00	AAPL	Stock	47.6262	47.665	47.56	47.645	4110396.0
2018-07-10 15:00:00	AAPL	Stock	47.6475	47.7025	47.545	47.5875	8368152.0
2018-07-10 16:00:00	AAPL	Stock	47.5875	47.62	47.3425	47.385	5926900.0
2018-07-10 17:00:00	AAPL	Stock	47.445	47.45	47.2625	47.32	146752.0
2018-07-10 18:00:00	AAPL	Stock	47.345	47.35	47.155	47.1575	197584.0
2018-07-10 19:00:00	AAPL	Stock	47.165	47.2	47.155	47.17	148556.0
2018-07-10 05:00:00	MSFT	Stock	102.2	102.2	102.18	102.2	2051.0
2018-07-10 06:00:00	MSFT	Stock	102.26	102.3	102.26	102.3	948.0
2018-07-10 07:00:00	MSFT	Stock	102.3	102.39	102.1	102.33	5659.0
2018-07-10 08:00:00	MSFT	Stock	102.12	102.4	102.0	102.11	23387.0
2018-07-10 09:00:00	MSFT	Stock	102.02	102.38	101.995	102.02	2518585.0
2018-07-10 10:00:00	MSFT	Stock	102.02	102.37	101.9	102.31	2210280.0
2018-07-10 11:00:00	MSFT	Stock	102.3	102.51	102.01	102.508	1999624.0
2018-07-10 12:00:00	MSFT	Stock	102.51	102.51	102.25	102.41	1498851.0
2018-07-10 13:00:00	MSFT	Stock	102.41	102.46	101.86	101.91	1742465.0
2018-07-10 14:00:00	MSFT	Stock	101.915	102.2	101.91	102.13	1481059.0
2018-07-10 15:00:00	MSFT	Stock	102.13	102.25	101.915	102.06	3200243.0
2018-07-10 16:00:00	MSFT	Stock	102.12	102.25	101.76	101.77	2959739.0
2018-07-10 17:00:00	MSFT	Stock	101.9	102.15	101.6	101.81	72225.0
2018-07-10 18:00:00	MSFT	Stock	101.82	101.82	101.34	101.34	23796.0
2018-07-10 19:00:00	MSFT	Stock	101.26	101.42	101.1	101.4	10097.0
2018-07-10 05:00:00	NVDA	Stock	6.2462	6.2552	6.2462	6.2552	16000.0
2018-07-10 06:00:00	NVDA	Stock	6.2565	6.2718	6.2563	6.2618	76000.0
2018-07-10 07:00:00	NVDA	Stock	6.255	6.275	6.255	6.267	457000.0
2018-07-10 08:00:00	NVDA	Stock	6.2625	6.2875	6.2375	6.2525	605080.0
2018-07-10 09:00:00	NVDA	Stock	6.2453	6.2918	6.203	6.2765	44791160.0
2018-07-10 10:00:00	NVDA	Stock	6.2764	6.332	6.268	6.3132	58317200.0
2018-07-10 11:00:00	NVDA	Stock	6.3148	6.347	6.3	6.3365	53931240.0
2018-07-10 12:00:00	NVDA	Stock	6.3367	6.3535	6.3233	6.3488	31262480.0
2018-07-10 13:00:00	NVDA	Stock	6.349	6.3532	6.2892	6.311	35376360.0
2018-07-10 14:00:00	NVDA	Stock	6.3112	6.3358	6.308	6.3343	23997120.0
2018-07-10 15:00:00	NVDA	Stock	6.335	6.336	6.3108	6.3313	44451600.0
2018-07-10 16:00:00	NVDA	Stock	6.3313	6.3343	6.2998	6.3	5277200.0
2018-07-10 17:00:00	NVDA	Stock	6.2897	6.3125	6.2545	6.2625	752640.0
2018-07-10 18:00:00	NVDA	Stock	6.258	6.279	6.2413	6.2638	1040800.0
2018-07-10 19:00:00	NVDA	Stock	6.264	6.2688	6.2375	6.24	997480.0
2018-07-10 05:00:00	AMZN	Stock	87.1	87.1	87.1	87.1	2000.0
2018-07-10 06:00:00	AMZN	Stock	87.15	87.175	87.15	87.1575	21000.0
2018-07-10 07:00:00	AMZN	Stock	87.1	87.1645	87.025	87.025	154920.0
2018-07-10 08:00:00	AMZN	Stock	87.1215	87.15	86.885	86.96	236720.0

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

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