PREVIEW / stock_1hour / 2018-07-09

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-07-09.parquet
  size:    1.1 MB
  rows:    49,937
  symbols: 2,830

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-09 03:00:00	AAPL	Stock	47.225	47.225	47.225	47.225	400.0
2018-07-09 04:00:00	AAPL	Stock	47.25	47.25	47.25	47.25	3908.0
2018-07-09 05:00:00	AAPL	Stock	47.2525	47.2525	47.2	47.2125	31564.0
2018-07-09 06:00:00	AAPL	Stock	47.2175	47.245	47.2175	47.225	2192.0
2018-07-09 07:00:00	AAPL	Stock	47.2475	47.2875	47.215	47.2875	151492.0
2018-07-09 08:00:00	AAPL	Stock	47.2625	47.4375	47.225	47.34	538724.0
2018-07-09 09:00:00	AAPL	Stock	47.34	47.67	47.325	47.5525	14437320.0
2018-07-09 10:00:00	AAPL	Stock	47.555	47.605	47.36	47.52	11781420.0
2018-07-09 11:00:00	AAPL	Stock	47.52	47.61	47.5022	47.5792	6837768.0
2018-07-09 12:00:00	AAPL	Stock	47.5838	47.622	47.4825	47.4925	5532528.0
2018-07-09 13:00:00	AAPL	Stock	47.4975	47.595	47.435	47.57	4771936.0
2018-07-09 14:00:00	AAPL	Stock	47.5725	47.6275	47.5125	47.6112	4743356.0
2018-07-09 15:00:00	AAPL	Stock	47.6125	47.665	47.5625	47.6525	10698980.0
2018-07-09 16:00:00	AAPL	Stock	47.645	47.7125	47.4345	47.685	10095892.0
2018-07-09 17:00:00	AAPL	Stock	47.685	47.775	47.525	47.575	243868.0
2018-07-09 18:00:00	AAPL	Stock	47.5625	47.605	47.475	47.605	95756.0
2018-07-09 19:00:00	AAPL	Stock	47.5875	47.645	47.5875	47.635	64936.0
2018-07-09 03:00:00	MSFT	Stock	101.54	101.54	101.54	101.54	100.0
2018-07-09 04:00:00	MSFT	Stock	101.6	101.6	101.6	101.6	200.0
2018-07-09 05:00:00	MSFT	Stock	101.84	101.84	101.84	101.84	147.0
2018-07-09 06:00:00	MSFT	Stock	102.0	102.0	101.6	101.6	789.0
2018-07-09 07:00:00	MSFT	Stock	101.6	101.89	101.55	101.74	6885.0
2018-07-09 08:00:00	MSFT	Stock	101.74	101.9	101.5	101.7	20520.0
2018-07-09 09:00:00	MSFT	Stock	101.8	102.25	101.39	101.61	3166383.0
2018-07-09 10:00:00	MSFT	Stock	101.609	101.66	101.251	101.54	2291500.0
2018-07-09 11:00:00	MSFT	Stock	101.545	101.85	101.5	101.74	1478989.0
2018-07-09 12:00:00	MSFT	Stock	101.74	101.82	101.58	101.605	1007158.0
2018-07-09 13:00:00	MSFT	Stock	101.605	101.695	101.467	101.63	1035214.0
2018-07-09 14:00:00	MSFT	Stock	101.64	101.68	101.48	101.665	1141700.0
2018-07-09 15:00:00	MSFT	Stock	101.67	101.91	101.54	101.87	2433835.0
2018-07-09 16:00:00	MSFT	Stock	101.85	101.9	101.518	101.9	2377460.0
2018-07-09 17:00:00	MSFT	Stock	101.85	101.9	101.85	101.9	2073.0
2018-07-09 18:00:00	MSFT	Stock	101.87	101.9	101.85	101.85	768058.0
2018-07-09 19:00:00	MSFT	Stock	101.85	102.21	101.85	102.03	11376.0
2018-07-09 04:00:00	NVDA	Stock	6.225	6.225	6.225	6.225	4000.0
2018-07-09 05:00:00	NVDA	Stock	6.2262	6.2375	6.2262	6.2375	67360.0
2018-07-09 06:00:00	NVDA	Stock	6.2375	6.2375	6.2375	6.2375	14000.0
2018-07-09 07:00:00	NVDA	Stock	6.2375	6.2715	6.2312	6.2538	421560.0
2018-07-09 08:00:00	NVDA	Stock	6.2375	6.275	6.2375	6.2525	1286960.0
2018-07-09 09:00:00	NVDA	Stock	6.251	6.2742	6.1925	6.2138	55280200.0
2018-07-09 10:00:00	NVDA	Stock	6.213	6.2208	6.1633	6.1773	48706680.0
2018-07-09 11:00:00	NVDA	Stock	6.1773	6.2374	6.159	6.1668	30107120.0
2018-07-09 12:00:00	NVDA	Stock	6.1663	6.1752	6.1518	6.1598	23559320.0
2018-07-09 13:00:00	NVDA	Stock	6.1608	6.1885	6.1598	6.183	21152400.0
2018-07-09 14:00:00	NVDA	Stock	6.183	6.2205	6.1806	6.2148	24725400.0
2018-07-09 15:00:00	NVDA	Stock	6.2145	6.233	6.2015	6.2312	40518040.0
2018-07-09 16:00:00	NVDA	Stock	6.2312	6.2312	6.2208	6.2288	23032600.0
2018-07-09 17:00:00	NVDA	Stock	6.2312	6.2325	6.2288	6.229	205640.0
2018-07-09 18:00:00	NVDA	Stock	6.2288	6.2388	6.225	6.2388	237480.0
2018-07-09 19:00:00	NVDA	Stock	6.2408	6.2443	6.2375	6.2443	532360.0

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

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