PREVIEW / stock_1hour / 2018-10-19

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-10-19.parquet
  size:    1.1 MB
  rows:    49,574
  symbols: 2,746

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-10-19 04:00:00	AAPL	Stock	54.2975	54.3125	54.17	54.2375	9572.0
2018-10-19 05:00:00	AAPL	Stock	54.35	54.5	54.3475	54.395	31740.0
2018-10-19 06:00:00	AAPL	Stock	54.3725	54.53	54.37	54.4925	92320.0
2018-10-19 07:00:00	AAPL	Stock	54.4625	54.6775	54.4175	54.6375	309480.0
2018-10-19 08:00:00	AAPL	Stock	54.4795	54.785	54.4425	54.6625	767732.0
2018-10-19 09:00:00	AAPL	Stock	54.6625	55.0	54.3775	54.92	21888076.0
2018-10-19 10:00:00	AAPL	Stock	54.92	55.2825	54.89	55.223	16044976.0
2018-10-19 11:00:00	AAPL	Stock	55.2255	55.315	54.725	54.905	11742516.0
2018-10-19 12:00:00	AAPL	Stock	54.9175	54.9718	54.3575	54.77	13009688.0
2018-10-19 13:00:00	AAPL	Stock	54.765	55.035	54.5825	54.7385	9026224.0
2018-10-19 14:00:00	AAPL	Stock	54.735	54.86	54.4625	54.7175	8427400.0
2018-10-19 15:00:00	AAPL	Stock	54.7075	55.0525	54.695	54.825	16030756.0
2018-10-19 16:00:00	AAPL	Stock	54.8275	54.8675	54.7275	54.7675	10293064.0
2018-10-19 17:00:00	AAPL	Stock	54.7675	54.7775	54.6775	54.7475	124840.0
2018-10-19 18:00:00	AAPL	Stock	54.725	54.795	54.725	54.75	32280.0
2018-10-19 19:00:00	AAPL	Stock	54.75	54.785	54.73	54.75	52240.0
2018-10-19 04:00:00	MSFT	Stock	109.24	109.24	108.89	108.89	1400.0
2018-10-19 05:00:00	MSFT	Stock	108.95	109.0	108.89	109.0	1320.0
2018-10-19 06:00:00	MSFT	Stock	109.15	109.25	109.15	109.2	4433.0
2018-10-19 07:00:00	MSFT	Stock	109.22	109.58	109.18	109.58	22976.0
2018-10-19 08:00:00	MSFT	Stock	109.39	109.79	108.86	109.26	69060.0
2018-10-19 09:00:00	MSFT	Stock	109.28	110.47	108.72	110.17	5648334.0
2018-10-19 10:00:00	MSFT	Stock	110.18	110.86	110.05	110.43	3565431.0
2018-10-19 11:00:00	MSFT	Stock	110.46	110.69	109.46	109.87	2421436.0
2018-10-19 12:00:00	MSFT	Stock	109.87	110.09	108.38	109.1	3828171.0
2018-10-19 13:00:00	MSFT	Stock	109.09	109.38	108.53	108.805	2200911.0
2018-10-19 14:00:00	MSFT	Stock	108.81	109.06	108.21	108.68	2591711.0
2018-10-19 15:00:00	MSFT	Stock	108.67	109.27	108.5	108.55	4592613.0
2018-10-19 16:00:00	MSFT	Stock	108.66	108.66	108.19	108.57	3046630.0
2018-10-19 17:00:00	MSFT	Stock	108.47	108.54	108.19	108.19	19441.0
2018-10-19 18:00:00	MSFT	Stock	108.22	108.62	108.22	108.62	2702.0
2018-10-19 19:00:00	MSFT	Stock	108.45	108.5	108.4	108.4	3480.0
2018-10-19 04:00:00	NVDA	Stock	6.0383	6.0383	6.0308	6.0308	10000.0
2018-10-19 05:00:00	NVDA	Stock	6.0175	6.025	6.0132	6.0175	50760.0
2018-10-19 06:00:00	NVDA	Stock	6.0132	6.036	6.0132	6.036	48080.0
2018-10-19 07:00:00	NVDA	Stock	6.0362	6.0575	6.0255	6.0548	454560.0
2018-10-19 08:00:00	NVDA	Stock	6.0375	6.0625	6.03	6.038	1174080.0
2018-10-19 09:00:00	NVDA	Stock	6.041	6.0745	5.9722	5.9823	56777360.0
2018-10-19 10:00:00	NVDA	Stock	5.9808	6.0123	5.9438	5.956	43598320.0
2018-10-19 11:00:00	NVDA	Stock	5.9572	5.9815	5.8125	5.8405	69820800.0
2018-10-19 12:00:00	NVDA	Stock	5.8405	5.8463	5.6925	5.7625	124761040.0
2018-10-19 13:00:00	NVDA	Stock	5.76	5.7828	5.7088	5.735	79283160.0
2018-10-19 14:00:00	NVDA	Stock	5.7358	5.808	5.7205	5.7486	39516720.0
2018-10-19 15:00:00	NVDA	Stock	5.75	5.7775	5.72	5.728	84784440.0
2018-10-19 16:00:00	NVDA	Stock	5.7293	5.7432	5.7149	5.7312	16627320.0
2018-10-19 17:00:00	NVDA	Stock	5.7312	5.7312	5.7145	5.725	392520.0
2018-10-19 18:00:00	NVDA	Stock	5.725	5.7252	5.7145	5.7202	169600.0
2018-10-19 19:00:00	NVDA	Stock	5.732	5.732	5.7193	5.725	117040.0
2018-10-19 04:00:00	AMZN	Stock	88.833	88.909	88.8325	88.85	19320.0
2018-10-19 05:00:00	AMZN	Stock	88.85	88.85	88.85	88.85	6000.0

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

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