PREVIEW / stock_1hour / 2018-12-12

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-12-12.parquet
  size:    1.1 MB
  rows:    49,887
  symbols: 2,742

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-12-12 04:00:00	AAPL	Stock	42.4375	42.725	42.4375	42.7	15492.0
2018-12-12 05:00:00	AAPL	Stock	42.7	42.74	42.65	42.705	14700.0
2018-12-12 06:00:00	AAPL	Stock	42.65	42.715	42.515	42.6075	52508.0
2018-12-12 07:00:00	AAPL	Stock	42.6	42.685	42.505	42.5525	182752.0
2018-12-12 08:00:00	AAPL	Stock	42.525	42.7625	42.3925	42.6125	935756.0
2018-12-12 09:00:00	AAPL	Stock	42.6275	42.6932	42.29	42.624	17355464.0
2018-12-12 10:00:00	AAPL	Stock	42.6175	42.82	42.4425	42.695	19717900.0
2018-12-12 11:00:00	AAPL	Stock	42.6975	42.89	42.6352	42.8275	13734044.0
2018-12-12 12:00:00	AAPL	Stock	42.835	42.87	42.665	42.8365	10010388.0
2018-12-12 13:00:00	AAPL	Stock	42.84	42.98	42.766	42.845	10732468.0
2018-12-12 14:00:00	AAPL	Stock	42.845	42.8675	42.38	42.4975	16544464.0
2018-12-12 15:00:00	AAPL	Stock	42.5	42.5825	42.255	42.2725	20975976.0
2018-12-12 16:00:00	AAPL	Stock	42.275	42.3325	42.22	42.3	11890544.0
2018-12-12 17:00:00	AAPL	Stock	42.31	42.3875	42.28	42.35	184876.0
2018-12-12 18:00:00	AAPL	Stock	42.35	42.3975	42.35	42.375	46920.0
2018-12-12 19:00:00	AAPL	Stock	42.375	42.415	42.325	42.375	77272.0
2018-12-12 04:00:00	MSFT	Stock	109.15	110.16	109.15	110.15	800.0
2018-12-12 05:00:00	MSFT	Stock	110.13	110.23	109.94	109.94	4846.0
2018-12-12 06:00:00	MSFT	Stock	109.95	109.95	109.75	109.91	500.0
2018-12-12 07:00:00	MSFT	Stock	109.85	110.2	109.77	109.93	23941.0
2018-12-12 08:00:00	MSFT	Stock	109.75	110.9	108.59	110.8	179195.0
2018-12-12 09:00:00	MSFT	Stock	110.8	111.18	109.91	110.42	3802944.0
2018-12-12 10:00:00	MSFT	Stock	110.41	111.065	110.32	111.0	4583243.0
2018-12-12 11:00:00	MSFT	Stock	111.01	111.27	110.758	111.06	3688935.0
2018-12-12 12:00:00	MSFT	Stock	111.07	111.22	110.41	110.61	2745711.0
2018-12-12 13:00:00	MSFT	Stock	110.62	110.71	110.22	110.27	2220949.0
2018-12-12 14:00:00	MSFT	Stock	110.275	110.28	109.04	109.62	3537197.0
2018-12-12 15:00:00	MSFT	Stock	109.62	110.08	109.06	109.08	5222517.0
2018-12-12 16:00:00	MSFT	Stock	109.08	109.2	108.85	109.0	6275691.0
2018-12-12 17:00:00	MSFT	Stock	109.08	109.24	109.08	109.24	5770.0
2018-12-12 18:00:00	MSFT	Stock	109.24	109.75	109.15	109.75	5384.0
2018-12-12 19:00:00	MSFT	Stock	109.7	109.7	109.55	109.55	4195.0
2018-12-12 04:00:00	NVDA	Stock	3.7495	3.7498	3.744	3.744	39200.0
2018-12-12 05:00:00	NVDA	Stock	3.766	3.766	3.766	3.766	8000.0
2018-12-12 06:00:00	NVDA	Stock	3.7552	3.7568	3.7425	3.7425	511400.0
2018-12-12 07:00:00	NVDA	Stock	3.75	3.759	3.7373	3.7375	1536160.0
2018-12-12 08:00:00	NVDA	Stock	3.75	3.759	3.6648	3.7062	6004360.0
2018-12-12 09:00:00	NVDA	Stock	3.7075	3.7345	3.6205	3.7078	129367320.0
2018-12-12 10:00:00	NVDA	Stock	3.7062	3.7833	3.686	3.7682	132663720.0
2018-12-12 11:00:00	NVDA	Stock	3.7682	3.8195	3.7592	3.78	65934040.0
2018-12-12 12:00:00	NVDA	Stock	3.7825	3.8175	3.7548	3.8085	52752680.0
2018-12-12 13:00:00	NVDA	Stock	3.8098	3.8118	3.7838	3.7945	39123000.0
2018-12-12 14:00:00	NVDA	Stock	3.7945	3.7945	3.7292	3.7525	57715440.0
2018-12-12 15:00:00	NVDA	Stock	3.7522	3.7695	3.7172	3.7212	60961760.0
2018-12-12 16:00:00	NVDA	Stock	3.7225	3.7307	3.711	3.7228	16298760.0
2018-12-12 17:00:00	NVDA	Stock	3.7292	3.737	3.7212	3.737	297000.0
2018-12-12 18:00:00	NVDA	Stock	3.737	3.7483	3.7325	3.7438	263720.0
2018-12-12 19:00:00	NVDA	Stock	3.742	3.755	3.7405	3.755	286840.0
2018-12-12 04:00:00	AMZN	Stock	82.959	83.1	82.959	83.1	4000.0
2018-12-12 05:00:00	AMZN	Stock	83.4625	83.4625	83.45	83.45	12820.0

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

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