PREVIEW / stock_1hour / 2018-07-11

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-07-11.parquet
  size:    1.1 MB
  rows:    49,150
  symbols: 2,816

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-11 04:00:00	AAPL	Stock	47.15	47.15	47.0025	47.0025	21960.0
2018-07-11 05:00:00	AAPL	Stock	47.0075	47.0625	47.0075	47.0625	16040.0
2018-07-11 06:00:00	AAPL	Stock	47.1175	47.1725	47.1175	47.1375	16016.0
2018-07-11 07:00:00	AAPL	Stock	47.1475	47.235	47.1375	47.1875	114424.0
2018-07-11 08:00:00	AAPL	Stock	47.2072	47.2875	47.1125	47.13	700636.0
2018-07-11 09:00:00	AAPL	Stock	47.1375	47.445	47.075	47.2375	9380252.0
2018-07-11 10:00:00	AAPL	Stock	47.2375	47.35	47.1575	47.24	9273936.0
2018-07-11 11:00:00	AAPL	Stock	47.2418	47.2745	46.98	46.9925	8602080.0
2018-07-11 12:00:00	AAPL	Stock	46.9918	47.1088	46.945	46.9988	5699724.0
2018-07-11 13:00:00	AAPL	Stock	47.0025	47.1425	46.955	47.035	4491908.0
2018-07-11 14:00:00	AAPL	Stock	47.0325	47.0925	46.9625	47.0525	4377396.0
2018-07-11 15:00:00	AAPL	Stock	47.0525	47.095	46.9025	46.9825	13189648.0
2018-07-11 16:00:00	AAPL	Stock	46.97	47.03	46.97	47.0	10462820.0
2018-07-11 17:00:00	AAPL	Stock	47.0025	47.015	46.955	46.9725	46732.0
2018-07-11 18:00:00	AAPL	Stock	46.965	46.985	46.95	46.975	54360.0
2018-07-11 19:00:00	AAPL	Stock	46.9875	47.0025	46.9775	47.0	21540.0
2018-07-11 04:00:00	MSFT	Stock	101.25	101.25	101.25	101.25	100.0
2018-07-11 06:00:00	MSFT	Stock	101.35	101.35	101.35	101.35	100.0
2018-07-11 07:00:00	MSFT	Stock	101.35	101.5	101.35	101.5	2251.0
2018-07-11 08:00:00	MSFT	Stock	101.4	101.69	101.24	101.37	12101.0
2018-07-11 09:00:00	MSFT	Stock	101.5	101.8	101.1	101.64	1962541.0
2018-07-11 10:00:00	MSFT	Stock	101.64	102.25	101.6	102.12	2793312.0
2018-07-11 11:00:00	MSFT	Stock	102.13	102.34	101.7	101.795	2265245.0
2018-07-11 12:00:00	MSFT	Stock	101.81	102.02	101.58	101.92	1260918.0
2018-07-11 13:00:00	MSFT	Stock	101.92	102.27	101.821	101.93	1574079.0
2018-07-11 14:00:00	MSFT	Stock	101.93	102.22	101.7	102.11	1348639.0
2018-07-11 15:00:00	MSFT	Stock	102.105	102.135	101.82	102.02	3384571.0
2018-07-11 16:00:00	MSFT	Stock	101.98	102.1	101.75	101.9	2650013.0
2018-07-11 17:00:00	MSFT	Stock	101.86	101.98	101.83	101.98	1741.0
2018-07-11 18:00:00	MSFT	Stock	101.99	102.04	101.8	101.98	342363.0
2018-07-11 19:00:00	MSFT	Stock	101.82	102.0	101.81	102.0	1415.0
2018-07-11 04:00:00	NVDA	Stock	6.2213	6.225	6.2213	6.225	30720.0
2018-07-11 05:00:00	NVDA	Stock	6.225	6.225	6.2175	6.2175	23000.0
2018-07-11 06:00:00	NVDA	Stock	6.2325	6.239	6.225	6.225	86680.0
2018-07-11 07:00:00	NVDA	Stock	6.23	6.2812	6.23	6.2425	721560.0
2018-07-11 08:00:00	NVDA	Stock	6.2475	6.2712	6.23	6.253	1638320.0
2018-07-11 09:00:00	NVDA	Stock	6.2438	6.2725	6.2096	6.221	62772520.0
2018-07-11 10:00:00	NVDA	Stock	6.2213	6.2585	6.216	6.2284	69877920.0
2018-07-11 11:00:00	NVDA	Stock	6.2283	6.2386	6.1775	6.1973	60725760.0
2018-07-11 12:00:00	NVDA	Stock	6.198	6.2142	6.1788	6.2028	29932840.0
2018-07-11 13:00:00	NVDA	Stock	6.204	6.22	6.1882	6.191	19677960.0
2018-07-11 14:00:00	NVDA	Stock	6.1903	6.2065	6.1838	6.1973	20158680.0
2018-07-11 15:00:00	NVDA	Stock	6.196	6.212	6.185	6.1868	38745000.0
2018-07-11 16:00:00	NVDA	Stock	6.1882	6.1962	6.1825	6.1875	26782760.0
2018-07-11 17:00:00	NVDA	Stock	6.1875	6.1875	6.1828	6.1828	101200.0
2018-07-11 18:00:00	NVDA	Stock	6.1852	6.1945	6.1828	6.1828	360480.0
2018-07-11 19:00:00	NVDA	Stock	6.185	6.185	6.1775	6.18	444600.0
2018-07-11 04:00:00	AMZN	Stock	86.25	86.25	86.25	86.25	24760.0
2018-07-11 06:00:00	AMZN	Stock	86.45	86.45	86.45	86.45	3780.0
2018-07-11 07:00:00	AMZN	Stock	86.6	86.65	86.5	86.598	168060.0

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

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