PREVIEW / stock_1hour / 2018-06-01

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-06-01.parquet
  size:    1.1 MB
  rows:    49,927
  symbols: 2,833

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-06-01 04:00:00	AAPL	Stock	46.8825	46.8875	46.855	46.8875	14404.0
2018-06-01 05:00:00	AAPL	Stock	46.8775	46.9	46.85	46.9	20132.0
2018-06-01 06:00:00	AAPL	Stock	46.9	46.985	46.8525	46.95	29616.0
2018-06-01 07:00:00	AAPL	Stock	46.9375	46.9825	46.925	46.9625	95812.0
2018-06-01 08:00:00	AAPL	Stock	46.95	47.035	46.9175	47.03	279116.0
2018-06-01 09:00:00	AAPL	Stock	47.03	47.17	46.9375	47.1175	10158748.0
2018-06-01 10:00:00	AAPL	Stock	47.1225	47.32	46.9843	47.2975	14343224.0
2018-06-01 11:00:00	AAPL	Stock	47.2975	47.475	47.295	47.435	10113268.0
2018-06-01 12:00:00	AAPL	Stock	47.4375	47.5	47.39	47.47	7292492.0
2018-06-01 13:00:00	AAPL	Stock	47.4725	47.5298	47.465	47.5225	9249692.0
2018-06-01 14:00:00	AAPL	Stock	47.525	47.53	47.4325	47.4875	7404868.0
2018-06-01 15:00:00	AAPL	Stock	47.4875	47.565	47.3775	47.5575	17458936.0
2018-06-01 16:00:00	AAPL	Stock	47.5575	47.59	47.535	47.565	7316484.0
2018-06-01 17:00:00	AAPL	Stock	47.5825	47.59	47.55	47.575	110424.0
2018-06-01 18:00:00	AAPL	Stock	47.565	47.58	47.565	47.565	16196.0
2018-06-01 19:00:00	AAPL	Stock	47.5825	47.625	47.575	47.6225	110584.0
2018-06-01 04:00:00	MSFT	Stock	98.99	99.19	98.99	99.15	1300.0
2018-06-01 06:00:00	MSFT	Stock	99.15	99.18	99.1	99.18	3680.0
2018-06-01 07:00:00	MSFT	Stock	99.15	99.18	99.07	99.17	7762.0
2018-06-01 08:00:00	MSFT	Stock	99.06	99.27	98.84	99.27	69767.0
2018-06-01 09:00:00	MSFT	Stock	99.29	99.78	99.13	99.63	2640494.0
2018-06-01 10:00:00	MSFT	Stock	99.63	100.33	99.54	100.205	4812283.0
2018-06-01 11:00:00	MSFT	Stock	100.195	100.74	100.1	100.65	2694085.0
2018-06-01 12:00:00	MSFT	Stock	100.66	100.86	100.38	100.49	2516688.0
2018-06-01 13:00:00	MSFT	Stock	100.496	100.71	100.455	100.57	1774110.0
2018-06-01 14:00:00	MSFT	Stock	100.57	100.63	100.33	100.395	1987385.0
2018-06-01 15:00:00	MSFT	Stock	100.4	100.81	100.19	100.76	4935597.0
2018-06-01 16:00:00	MSFT	Stock	100.79	101.0	100.51	100.85	3707371.0
2018-06-01 17:00:00	MSFT	Stock	100.69	100.82	100.69	100.82	1714.0
2018-06-01 18:00:00	MSFT	Stock	100.82	100.85	100.79	100.79	2209.0
2018-06-01 19:00:00	MSFT	Stock	100.83	100.87	100.8	100.87	4085.0
2018-06-01 05:00:00	NVDA	Stock	6.3218	6.3218	6.3218	6.3218	6000.0
2018-06-01 06:00:00	NVDA	Stock	6.325	6.3398	6.325	6.3398	12000.0
2018-06-01 07:00:00	NVDA	Stock	6.3375	6.3562	6.3375	6.3525	298560.0
2018-06-01 08:00:00	NVDA	Stock	6.3538	6.3608	6.3425	6.3592	1802840.0
2018-06-01 09:00:00	NVDA	Stock	6.3592	6.3935	6.347	6.3843	53410120.0
2018-06-01 10:00:00	NVDA	Stock	6.3836	6.3972	6.3413	6.3913	78534520.0
2018-06-01 11:00:00	NVDA	Stock	6.3915	6.4343	6.3845	6.4263	55838760.0
2018-06-01 12:00:00	NVDA	Stock	6.427	6.4288	6.4075	6.4132	37949520.0
2018-06-01 13:00:00	NVDA	Stock	6.412	6.4295	6.4106	6.4106	32819760.0
2018-06-01 14:00:00	NVDA	Stock	6.4115	6.4248	6.4025	6.4218	28368800.0
2018-06-01 15:00:00	NVDA	Stock	6.4215	6.4468	6.4118	6.4398	75437360.0
2018-06-01 16:00:00	NVDA	Stock	6.4405	6.4405	6.4024	6.4382	19097720.0
2018-06-01 17:00:00	NVDA	Stock	6.435	6.4375	6.43	6.4362	378160.0
2018-06-01 18:00:00	NVDA	Stock	6.436	6.4375	6.4338	6.4375	102680.0
2018-06-01 19:00:00	NVDA	Stock	6.44	6.445	6.4355	6.445	303600.0
2018-06-01 04:00:00	AMZN	Stock	81.5605	81.5605	81.5605	81.5605	10560.0
2018-06-01 05:00:00	AMZN	Stock	81.803	81.803	81.803	81.803	2380.0
2018-06-01 06:00:00	AMZN	Stock	81.803	81.803	81.803	81.803	3000.0
2018-06-01 07:00:00	AMZN	Stock	81.745	81.928	81.745	81.925	193580.0

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

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