PREVIEW / stock_1hour / 2018-07-19

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-07-19.parquet
  size:    1.1 MB
  rows:    49,223
  symbols: 2,812

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-19 06:00:00	AAPL	Stock	47.55	47.5525	47.475	47.4875	29356.0
2018-07-19 07:00:00	AAPL	Stock	47.5375	47.625	47.5	47.5	275248.0
2018-07-19 08:00:00	AAPL	Stock	47.5188	47.5975	47.4375	47.4525	153740.0
2018-07-19 09:00:00	AAPL	Stock	47.445	48.045	47.4225	47.8847	11943708.0
2018-07-19 10:00:00	AAPL	Stock	47.885	47.93	47.7525	47.9175	7821108.0
2018-07-19 11:00:00	AAPL	Stock	47.9125	48.1375	47.9075	48.12	10209404.0
2018-07-19 12:00:00	AAPL	Stock	48.1175	48.125	47.92	47.9912	5479500.0
2018-07-19 13:00:00	AAPL	Stock	47.99	48.1325	47.94	48.085	5870716.0
2018-07-19 14:00:00	AAPL	Stock	48.0875	48.125	47.9825	48.0275	5157344.0
2018-07-19 15:00:00	AAPL	Stock	48.0275	48.0775	47.9125	47.9925	9756196.0
2018-07-19 16:00:00	AAPL	Stock	47.99	48.08	47.9375	48.025	11809516.0
2018-07-19 17:00:00	AAPL	Stock	48.05	48.0625	48.005	48.01	52320.0
2018-07-19 18:00:00	AAPL	Stock	48.0375	48.05	47.99	48.0475	105644.0
2018-07-19 19:00:00	AAPL	Stock	48.0375	48.0625	48.0225	48.045	37672.0
2018-07-19 04:00:00	MSFT	Stock	105.4	105.4	104.75	105.15	4084.0
2018-07-19 05:00:00	MSFT	Stock	105.15	105.25	105.15	105.15	2346.0
2018-07-19 06:00:00	MSFT	Stock	105.15	105.15	104.65	104.65	11796.0
2018-07-19 07:00:00	MSFT	Stock	104.88	105.07	104.57	104.65	36971.0
2018-07-19 08:00:00	MSFT	Stock	104.94	105.35	104.56	104.86	47580.0
2018-07-19 09:00:00	MSFT	Stock	104.85	105.31	104.18	104.48	4323496.0
2018-07-19 10:00:00	MSFT	Stock	104.485	105.03	104.28	104.925	3730412.0
2018-07-19 11:00:00	MSFT	Stock	104.94	105.23	104.85	105.125	2919215.0
2018-07-19 12:00:00	MSFT	Stock	105.13	105.17	104.355	104.517	2647861.0
2018-07-19 13:00:00	MSFT	Stock	104.51	104.84	104.39	104.645	2470354.0
2018-07-19 14:00:00	MSFT	Stock	104.646	104.7	104.21	104.24	2912532.0
2018-07-19 15:00:00	MSFT	Stock	104.24	104.77	103.89	104.73	7408319.0
2018-07-19 16:00:00	MSFT	Stock	104.67	106.11	102.35	105.17	5972213.0
2018-07-19 17:00:00	MSFT	Stock	105.17	108.2	105.0	108.19	848549.0
2018-07-19 18:00:00	MSFT	Stock	108.2	109.3	107.61	107.85	975377.0
2018-07-19 19:00:00	MSFT	Stock	107.92	108.0	107.6	107.8	187000.0
2018-07-19 04:00:00	NVDA	Stock	6.2925	6.2925	6.2925	6.2925	15200.0
2018-07-19 05:00:00	NVDA	Stock	6.29	6.29	6.2475	6.2475	165800.0
2018-07-19 07:00:00	NVDA	Stock	6.268	6.268	6.2588	6.2588	37600.0
2018-07-19 08:00:00	NVDA	Stock	6.2588	6.2688	6.25	6.2568	284480.0
2018-07-19 09:00:00	NVDA	Stock	6.2595	6.3348	6.25	6.301	46549280.0
2018-07-19 10:00:00	NVDA	Stock	6.3015	6.3174	6.2582	6.2888	48357560.0
2018-07-19 11:00:00	NVDA	Stock	6.2892	6.322	6.284	6.3058	22920960.0
2018-07-19 12:00:00	NVDA	Stock	6.3072	6.3072	6.2753	6.2826	14706560.0
2018-07-19 13:00:00	NVDA	Stock	6.2826	6.3	6.2738	6.2945	15829200.0
2018-07-19 14:00:00	NVDA	Stock	6.2945	6.307	6.2925	6.3055	15872120.0
2018-07-19 15:00:00	NVDA	Stock	6.3058	6.3154	6.2893	6.3002	42343800.0
2018-07-19 16:00:00	NVDA	Stock	6.3008	6.3048	6.2883	6.2998	10472280.0
2018-07-19 17:00:00	NVDA	Stock	6.2998	6.3088	6.2935	6.3083	137360.0
2018-07-19 18:00:00	NVDA	Stock	6.3038	6.3238	6.3038	6.3125	437880.0
2018-07-19 19:00:00	NVDA	Stock	6.3185	6.3212	6.3155	6.3162	156160.0
2018-07-19 04:00:00	AMZN	Stock	91.96	91.96	91.96	91.96	2000.0
2018-07-19 05:00:00	AMZN	Stock	92.0495	92.05	91.855	91.855	9800.0
2018-07-19 06:00:00	AMZN	Stock	91.871	91.871	91.7565	91.8	12000.0
2018-07-19 07:00:00	AMZN	Stock	91.8335	91.9375	91.825	91.903	18040.0
2018-07-19 08:00:00	AMZN	Stock	91.8005	91.8995	91.3	91.3	384580.0

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

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