PREVIEW / stock_1hour / 2018-03-08

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-03-08.parquet
  size:    1.1 MB
  rows:    49,860
  symbols: 2,867

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-08 04:00:00	AAPL	Stock	43.75	43.77	43.725	43.75	21228.0
2018-03-08 05:00:00	AAPL	Stock	43.75	43.75	43.75	43.75	5968.0
2018-03-08 06:00:00	AAPL	Stock	43.7975	43.87	43.7975	43.825	10800.0
2018-03-08 07:00:00	AAPL	Stock	43.85	43.9225	43.825	43.895	216084.0
2018-03-08 08:00:00	AAPL	Stock	43.845	43.915	43.825	43.825	297364.0
2018-03-08 09:00:00	AAPL	Stock	43.8475	44.0225	43.805	43.835	13321788.0
2018-03-08 10:00:00	AAPL	Stock	43.8325	43.9225	43.7675	43.8725	12934204.0
2018-03-08 11:00:00	AAPL	Stock	43.8725	44.1225	43.8598	44.1025	11193276.0
2018-03-08 12:00:00	AAPL	Stock	44.1075	44.1775	44.015	44.155	8579616.0
2018-03-08 13:00:00	AAPL	Stock	44.155	44.24	44.015	44.16	8652284.0
2018-03-08 14:00:00	AAPL	Stock	44.16	44.275	44.0625	44.2425	8359180.0
2018-03-08 15:00:00	AAPL	Stock	44.24	44.28	44.07	44.2375	14932408.0
2018-03-08 16:00:00	AAPL	Stock	44.235	44.25	44.205	44.205	5577164.0
2018-03-08 17:00:00	AAPL	Stock	44.225	44.2425	44.2	44.2125	119280.0
2018-03-08 18:00:00	AAPL	Stock	44.2	44.25	44.2	44.25	14136.0
2018-03-08 19:00:00	AAPL	Stock	44.2475	44.2675	44.21	44.2675	43064.0
2018-03-08 04:00:00	MSFT	Stock	93.68	93.68	93.68	93.68	100.0
2018-03-08 07:00:00	MSFT	Stock	94.0	94.15	94.0	94.15	8021.0
2018-03-08 08:00:00	MSFT	Stock	94.15	94.16	94.02	94.1	24031.0
2018-03-08 09:00:00	MSFT	Stock	94.14	95.1	94.04	94.685	3606224.0
2018-03-08 10:00:00	MSFT	Stock	94.685	95.03	94.34	94.73	3493562.0
2018-03-08 11:00:00	MSFT	Stock	94.735	95.06	94.574	94.673	2225979.0
2018-03-08 12:00:00	MSFT	Stock	94.67	94.72	94.281	94.35	1785691.0
2018-03-08 13:00:00	MSFT	Stock	94.36	94.46	93.84	94.032	2122091.0
2018-03-08 14:00:00	MSFT	Stock	94.03	94.35	93.82	94.15	2006610.0
2018-03-08 15:00:00	MSFT	Stock	94.16	94.485	93.765	94.43	5048233.0
2018-03-08 16:00:00	MSFT	Stock	94.43	94.48	94.12	94.4	2836635.0
2018-03-08 17:00:00	MSFT	Stock	94.38	94.4	94.33	94.4	2336.0
2018-03-08 18:00:00	MSFT	Stock	94.38	94.5	94.36	94.4	2154.0
2018-03-08 19:00:00	MSFT	Stock	94.41	94.5	94.33	94.5	6995.0
2018-03-08 06:00:00	NVDA	Stock	6.0588	6.0588	6.0588	6.0588	39320.0
2018-03-08 07:00:00	NVDA	Stock	6.0625	6.0723	6.0625	6.069	759680.0
2018-03-08 08:00:00	NVDA	Stock	6.059	6.073	6.0562	6.0575	1771320.0
2018-03-08 09:00:00	NVDA	Stock	6.0625	6.0772	6.024	6.0285	62222280.0
2018-03-08 10:00:00	NVDA	Stock	6.0263	6.0342	5.9848	5.9988	80534560.0
2018-03-08 11:00:00	NVDA	Stock	5.997	6.0435	5.9913	6.0361	48397000.0
2018-03-08 12:00:00	NVDA	Stock	6.0367	6.0571	6.0063	6.0409	48667680.0
2018-03-08 13:00:00	NVDA	Stock	6.042	6.0444	5.9868	6.004	37252880.0
2018-03-08 14:00:00	NVDA	Stock	6.0038	6.025	5.9871	6.0144	30563560.0
2018-03-08 15:00:00	NVDA	Stock	6.0138	6.0365	5.992	6.0292	84056040.0
2018-03-08 16:00:00	NVDA	Stock	6.0295	6.0295	6.0165	6.0188	2560520.0
2018-03-08 17:00:00	NVDA	Stock	6.02	6.0295	6.0175	6.025	1895560.0
2018-03-08 18:00:00	NVDA	Stock	6.0248	6.034	6.0248	6.0312	688960.0
2018-03-08 19:00:00	NVDA	Stock	6.0295	6.037	6.0255	6.037	311440.0
2018-03-08 04:00:00	AMZN	Stock	77.2505	77.275	77.25	77.25	6100.0
2018-03-08 06:00:00	AMZN	Stock	77.32	77.4	77.32	77.35	33800.0
2018-03-08 07:00:00	AMZN	Stock	77.375	77.637	77.375	77.585	277920.0
2018-03-08 08:00:00	AMZN	Stock	77.5875	77.65	77.4	77.5345	393600.0
2018-03-08 09:00:00	AMZN	Stock	77.5345	77.744	77.35	77.5515	10888460.0
2018-03-08 10:00:00	AMZN	Stock	77.545	77.64	77.325	77.5385	7936680.0

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

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