PREVIEW / stock_1hour / 2018-07-13

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-07-13.parquet
  size:    1.1 MB
  rows:    48,253
  symbols: 2,796

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-13 04:00:00	AAPL	Stock	47.8	47.8	47.8	47.8	660.0
2018-07-13 05:00:00	AAPL	Stock	47.875	47.875	47.7125	47.7125	3488.0
2018-07-13 06:00:00	AAPL	Stock	47.75	47.7875	47.75	47.7875	9144.0
2018-07-13 07:00:00	AAPL	Stock	47.8	47.87	47.7175	47.7825	98004.0
2018-07-13 08:00:00	AAPL	Stock	47.8525	47.8525	47.7	47.7225	196956.0
2018-07-13 09:00:00	AAPL	Stock	47.7275	47.96	47.725	47.8	7764868.0
2018-07-13 10:00:00	AAPL	Stock	47.7975	47.95	47.7825	47.8525	6716052.0
2018-07-13 11:00:00	AAPL	Stock	47.85	47.9475	47.84	47.925	4856440.0
2018-07-13 12:00:00	AAPL	Stock	47.93	47.9375	47.8478	47.8675	3167824.0
2018-07-13 13:00:00	AAPL	Stock	47.8675	47.8775	47.7525	47.7625	4092272.0
2018-07-13 14:00:00	AAPL	Stock	47.76	47.8975	47.7375	47.8675	4111144.0
2018-07-13 15:00:00	AAPL	Stock	47.87	47.92	47.8237	47.8325	7810144.0
2018-07-13 16:00:00	AAPL	Stock	47.8325	47.8725	47.825	47.85	5839720.0
2018-07-13 17:00:00	AAPL	Stock	47.84	47.845	47.825	47.825	39700.0
2018-07-13 18:00:00	AAPL	Stock	47.8325	47.8375	47.8325	47.835	7148.0
2018-07-13 19:00:00	AAPL	Stock	47.835	47.8425	47.83	47.8425	13052.0
2018-07-13 05:00:00	MSFT	Stock	104.45	104.45	104.25	104.35	2709.0
2018-07-13 06:00:00	MSFT	Stock	104.39	104.44	104.2	104.44	1113.0
2018-07-13 07:00:00	MSFT	Stock	104.35	104.43	104.27	104.27	1778.0
2018-07-13 08:00:00	MSFT	Stock	104.363	104.5	104.25	104.32	34723.0
2018-07-13 09:00:00	MSFT	Stock	104.34	104.608	104.09	104.285	2560469.0
2018-07-13 10:00:00	MSFT	Stock	104.28	105.03	104.27	104.829	4280649.0
2018-07-13 11:00:00	MSFT	Stock	104.82	105.17	104.71	104.9	2375488.0
2018-07-13 12:00:00	MSFT	Stock	104.905	105.08	104.85	104.98	1490374.0
2018-07-13 13:00:00	MSFT	Stock	104.99	105.245	104.98	105.135	2204837.0
2018-07-13 14:00:00	MSFT	Stock	105.135	105.235	104.94	105.16	1450878.0
2018-07-13 15:00:00	MSFT	Stock	105.159	105.6	105.12	105.42	5479877.0
2018-07-13 16:00:00	MSFT	Stock	105.43	105.65	105.203	105.35	2676514.0
2018-07-13 17:00:00	MSFT	Stock	105.45	105.55	105.35	105.42	56946.0
2018-07-13 18:00:00	MSFT	Stock	105.49	105.59	105.46	105.46	16445.0
2018-07-13 19:00:00	MSFT	Stock	105.5	105.55	105.5	105.55	950.0
2018-07-13 07:00:00	NVDA	Stock	6.297	6.308	6.297	6.3018	57480.0
2018-07-13 08:00:00	NVDA	Stock	6.3	6.308	6.2875	6.295	912400.0
2018-07-13 09:00:00	NVDA	Stock	6.2961	6.2995	6.1905	6.2112	51074280.0
2018-07-13 10:00:00	NVDA	Stock	6.2105	6.2525	6.2085	6.24	44952080.0
2018-07-13 11:00:00	NVDA	Stock	6.2413	6.2609	6.2358	6.2413	29046160.0
2018-07-13 12:00:00	NVDA	Stock	6.2408	6.2548	6.2238	6.2242	22969400.0
2018-07-13 13:00:00	NVDA	Stock	6.2243	6.2282	6.2066	6.2123	15697640.0
2018-07-13 14:00:00	NVDA	Stock	6.2126	6.224	6.2085	6.2236	11928720.0
2018-07-13 15:00:00	NVDA	Stock	6.2243	6.2375	6.217	6.233	30908640.0
2018-07-13 16:00:00	NVDA	Stock	6.233	6.233	6.22	6.225	19672880.0
2018-07-13 17:00:00	NVDA	Stock	6.2232	6.225	6.2202	6.225	75440.0
2018-07-13 18:00:00	NVDA	Stock	6.225	6.2288	6.225	6.228	156720.0
2018-07-13 19:00:00	NVDA	Stock	6.228	6.23	6.225	6.23	66840.0
2018-07-13 04:00:00	AMZN	Stock	90.175	90.175	90.175	90.175	2000.0
2018-07-13 05:00:00	AMZN	Stock	90.137	90.15	90.0195	90.0195	16200.0
2018-07-13 06:00:00	AMZN	Stock	90.0195	90.0195	90.0195	90.0195	3400.0
2018-07-13 07:00:00	AMZN	Stock	90.036	90.21	89.99	90.0805	412780.0
2018-07-13 08:00:00	AMZN	Stock	90.06	90.31	90.0	90.15	743740.0
2018-07-13 09:00:00	AMZN	Stock	90.137	90.7595	89.7612	90.149	23206640.0

> showing 50 of 48,253 rows — these rows as CSV

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