PREVIEW / stock_1hour / 2018-03-21

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-03-21.parquet
  size:    1.1 MB
  rows:    48,349
  symbols: 2,873

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-03-21 05:00:00	AAPL	Stock	43.75	43.75	43.75	43.75	1944.0
2018-03-21 06:00:00	AAPL	Stock	43.7475	43.8075	43.7475	43.8075	6516.0
2018-03-21 07:00:00	AAPL	Stock	43.8075	43.8725	43.6375	43.725	186936.0
2018-03-21 08:00:00	AAPL	Stock	43.7125	43.8775	43.7125	43.81	110760.0
2018-03-21 09:00:00	AAPL	Stock	43.81	43.8125	43.5025	43.6078	10226940.0
2018-03-21 10:00:00	AAPL	Stock	43.61	43.645	43.4288	43.5238	14925224.0
2018-03-21 11:00:00	AAPL	Stock	43.525	43.5775	43.4785	43.555	11605700.0
2018-03-21 12:00:00	AAPL	Stock	43.555	43.565	43.47	43.4725	8641596.0
2018-03-21 13:00:00	AAPL	Stock	43.475	43.475	43.265	43.3713	15872200.0
2018-03-21 14:00:00	AAPL	Stock	43.3713	43.55	42.83	42.984	30944804.0
2018-03-21 15:00:00	AAPL	Stock	42.9873	43.145	42.815	42.8175	27401448.0
2018-03-21 16:00:00	AAPL	Stock	42.8625	43.5012	42.8175	42.8575	11903580.0
2018-03-21 17:00:00	AAPL	Stock	42.8575	42.93	42.8575	42.9125	107744.0
2018-03-21 18:00:00	AAPL	Stock	42.9	42.9375	42.895	42.9375	69696.0
2018-03-21 19:00:00	AAPL	Stock	42.94	42.96	42.9075	42.9425	55332.0
2018-03-21 07:00:00	MSFT	Stock	93.04	93.14	92.9	93.0	3592.0
2018-03-21 08:00:00	MSFT	Stock	93.02	93.1	92.97	93.1	7543.0
2018-03-21 09:00:00	MSFT	Stock	93.12	93.28	92.68	93.115	1766394.0
2018-03-21 10:00:00	MSFT	Stock	93.115	93.37	92.58	92.6	2331150.0
2018-03-21 11:00:00	MSFT	Stock	92.61	93.2	92.55	93.04	2128012.0
2018-03-21 12:00:00	MSFT	Stock	93.04	93.2	92.92	93.2	1468450.0
2018-03-21 13:00:00	MSFT	Stock	93.195	93.48	93.14	93.34	1780013.0
2018-03-21 14:00:00	MSFT	Stock	93.35	94.05	92.21	92.55	4732606.0
2018-03-21 15:00:00	MSFT	Stock	92.55	93.21	92.43	92.48	5179087.0
2018-03-21 16:00:00	MSFT	Stock	92.48	92.96	92.4	92.48	2512765.0
2018-03-21 17:00:00	MSFT	Stock	92.57	92.59	92.5	92.57	2154.0
2018-03-21 18:00:00	MSFT	Stock	92.58	92.6	92.58	92.6	1385.0
2018-03-21 19:00:00	MSFT	Stock	92.65	92.65	92.65	92.65	200.0
2018-03-21 05:00:00	NVDA	Stock	6.2053	6.2095	6.2053	6.2085	30200.0
2018-03-21 07:00:00	NVDA	Stock	6.2185	6.235	6.2175	6.23	387240.0
2018-03-21 08:00:00	NVDA	Stock	6.2225	6.2448	6.2125	6.2378	1699600.0
2018-03-21 09:00:00	NVDA	Stock	6.2378	6.2835	6.1833	6.242	73495680.0
2018-03-21 10:00:00	NVDA	Stock	6.2432	6.289	6.2403	6.252	87994440.0
2018-03-21 11:00:00	NVDA	Stock	6.253	6.2875	6.252	6.2725	38445000.0
2018-03-21 12:00:00	NVDA	Stock	6.2722	6.2795	6.2505	6.256	29794280.0
2018-03-21 13:00:00	NVDA	Stock	6.2562	6.258	6.2312	6.2448	27299800.0
2018-03-21 14:00:00	NVDA	Stock	6.2449	6.3	6.1855	6.23	99455560.0
2018-03-21 15:00:00	NVDA	Stock	6.229	6.2628	6.2133	6.2135	66949160.0
2018-03-21 16:00:00	NVDA	Stock	6.2135	6.265	6.202	6.215	4370880.0
2018-03-21 17:00:00	NVDA	Stock	6.215	6.22	6.215	6.2195	107240.0
2018-03-21 18:00:00	NVDA	Stock	6.22	6.2248	6.2188	6.2215	120800.0
2018-03-21 19:00:00	NVDA	Stock	6.2238	6.2238	6.219	6.2195	560480.0
2018-03-21 04:00:00	AMZN	Stock	79.4	79.4	79.231	79.3005	16000.0
2018-03-21 05:00:00	AMZN	Stock	79.3245	79.325	79.3245	79.325	8420.0
2018-03-21 06:00:00	AMZN	Stock	79.3225	79.3285	79.264	79.264	8000.0
2018-03-21 07:00:00	AMZN	Stock	79.3265	79.5305	79.222	79.25	197560.0
2018-03-21 08:00:00	AMZN	Stock	79.525	79.525	79.18	79.374	353900.0
2018-03-21 09:00:00	AMZN	Stock	79.375	79.47	78.617	79.0	10282200.0
2018-03-21 10:00:00	AMZN	Stock	79.034	79.5	78.8145	78.84	11322020.0
2018-03-21 11:00:00	AMZN	Stock	78.824	79.237	78.806	79.0905	5811380.0

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

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