PREVIEW / stock_1hour / 2018-06-22

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-06-22.parquet
  size:    1.1 MB
  rows:    49,909
  symbols: 2,818

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-22 04:00:00	AAPL	Stock	46.45	46.4725	46.45	46.4725	2400.0
2018-06-22 05:00:00	AAPL	Stock	46.5125	46.5125	46.5125	46.5125	1200.0
2018-06-22 06:00:00	AAPL	Stock	46.5175	46.55	46.5175	46.55	2516.0
2018-06-22 07:00:00	AAPL	Stock	46.625	46.625	46.5	46.5425	67376.0
2018-06-22 08:00:00	AAPL	Stock	46.55	46.655	46.4825	46.55	156792.0
2018-06-22 09:00:00	AAPL	Stock	46.5625	46.61	46.2775	46.3875	7444304.0
2018-06-22 10:00:00	AAPL	Stock	46.385	46.4675	46.205	46.415	10137724.0
2018-06-22 11:00:00	AAPL	Stock	46.4125	46.4288	46.2925	46.315	6240604.0
2018-06-22 12:00:00	AAPL	Stock	46.3162	46.4238	46.27	46.42	4339800.0
2018-06-22 13:00:00	AAPL	Stock	46.4188	46.49	46.395	46.445	5224704.0
2018-06-22 14:00:00	AAPL	Stock	46.445	46.4675	46.365	46.445	4310168.0
2018-06-22 15:00:00	AAPL	Stock	46.445	46.5	46.175	46.23	13419980.0
2018-06-22 16:00:00	AAPL	Stock	46.23	46.4925	46.23	46.25	27481184.0
2018-06-22 17:00:00	AAPL	Stock	46.255	46.2675	46.23	46.23	17708.0
2018-06-22 18:00:00	AAPL	Stock	46.23	46.2475	46.22	46.225	29604.0
2018-06-22 19:00:00	AAPL	Stock	46.225	46.235	46.2125	46.235	6220.0
2018-06-22 04:00:00	MSFT	Stock	100.95	101.1	100.95	101.1	10953.0
2018-06-22 05:00:00	MSFT	Stock	101.11	101.11	101.04	101.1	1851.0
2018-06-22 06:00:00	MSFT	Stock	100.98	100.98	100.98	100.98	500.0
2018-06-22 07:00:00	MSFT	Stock	100.98	101.09	100.8	100.8	21958.0
2018-06-22 08:00:00	MSFT	Stock	100.9	101.09	100.48	100.7	57264.0
2018-06-22 09:00:00	MSFT	Stock	100.62	100.89	99.625	99.772	4526532.0
2018-06-22 10:00:00	MSFT	Stock	99.775	100.215	99.63	99.84	4223162.0
2018-06-22 11:00:00	MSFT	Stock	99.835	100.196	99.73	100.15	2238852.0
2018-06-22 12:00:00	MSFT	Stock	100.15	100.39	100.07	100.35	1314715.0
2018-06-22 13:00:00	MSFT	Stock	100.345	100.665	100.32	100.565	1410965.0
2018-06-22 14:00:00	MSFT	Stock	100.57	100.64	100.155	100.45	1727776.0
2018-06-22 15:00:00	MSFT	Stock	100.46	100.77	100.15	100.3	4348807.0
2018-06-22 16:00:00	MSFT	Stock	100.41	100.41	100.2	100.25	8796063.0
2018-06-22 17:00:00	MSFT	Stock	100.25	100.38	100.15	100.15	3824.0
2018-06-22 18:00:00	MSFT	Stock	100.15	100.36	100.15	100.16	350.0
2018-06-22 19:00:00	MSFT	Stock	100.2	100.2	100.2	100.2	278.0
2018-06-22 04:00:00	NVDA	Stock	6.4362	6.4442	6.4362	6.4442	46000.0
2018-06-22 07:00:00	NVDA	Stock	6.4625	6.465	6.4585	6.4588	224720.0
2018-06-22 08:00:00	NVDA	Stock	6.4662	6.471	6.45	6.4656	1111280.0
2018-06-22 09:00:00	NVDA	Stock	6.466	6.466	6.3058	6.3173	74477800.0
2018-06-22 10:00:00	NVDA	Stock	6.313	6.337	6.2582	6.299	83924000.0
2018-06-22 11:00:00	NVDA	Stock	6.2998	6.3095	6.2602	6.3035	45141360.0
2018-06-22 12:00:00	NVDA	Stock	6.304	6.316	6.292	6.3135	27709800.0
2018-06-22 13:00:00	NVDA	Stock	6.314	6.3258	6.3023	6.3088	28759840.0
2018-06-22 14:00:00	NVDA	Stock	6.3085	6.3128	6.285	6.2902	25672440.0
2018-06-22 15:00:00	NVDA	Stock	6.2905	6.2978	6.261	6.269	60149720.0
2018-06-22 16:00:00	NVDA	Stock	6.2738	6.2875	6.2552	6.2658	8068560.0
2018-06-22 17:00:00	NVDA	Stock	6.2698	6.2712	6.2662	6.2712	167920.0
2018-06-22 18:00:00	NVDA	Stock	6.2712	6.2712	6.264	6.271	138040.0
2018-06-22 19:00:00	NVDA	Stock	6.2673	6.271	6.2638	6.265	201720.0
2018-06-22 04:00:00	AMZN	Stock	86.65	86.65	86.65	86.65	4080.0
2018-06-22 07:00:00	AMZN	Stock	86.886	86.886	86.7575	86.8235	105040.0
2018-06-22 08:00:00	AMZN	Stock	86.8366	87.2245	86.7525	87.03	631680.0
2018-06-22 09:00:00	AMZN	Stock	87.008	87.15	86.165	86.231	11749980.0

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

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