PREVIEW / stock_1hour / 2019-02-21

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-02-21.parquet
  size:    1.1 MB
  rows:    49,215
  symbols: 2,653

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
2019-02-21 04:00:00	AAPL	Stock	43.0	43.0075	42.91	42.91	6840.0
2019-02-21 05:00:00	AAPL	Stock	42.9825	42.9825	42.9825	42.9825	1600.0
2019-02-21 06:00:00	AAPL	Stock	43.1	43.1	43.0825	43.0825	3188.0
2019-02-21 07:00:00	AAPL	Stock	43.08	43.08	42.93	42.94	91572.0
2019-02-21 08:00:00	AAPL	Stock	42.94	43.0925	42.9325	43.0175	192100.0
2019-02-21 09:00:00	AAPL	Stock	43.0175	43.0925	42.705	42.8175	11853764.0
2019-02-21 10:00:00	AAPL	Stock	42.815	42.85	42.705	42.7272	11263912.0
2019-02-21 11:00:00	AAPL	Stock	42.7225	42.8593	42.62	42.8325	8470784.0
2019-02-21 12:00:00	AAPL	Stock	42.835	42.925	42.825	42.91	4743508.0
2019-02-21 13:00:00	AAPL	Stock	42.9075	42.9175	42.82	42.8538	3788272.0
2019-02-21 14:00:00	AAPL	Stock	42.855	42.86	42.5875	42.6	6355736.0
2019-02-21 15:00:00	AAPL	Stock	42.6012	42.785	42.575	42.785	9362816.0
2019-02-21 16:00:00	AAPL	Stock	42.765	42.765	42.7375	42.75	4717364.0
2019-02-21 17:00:00	AAPL	Stock	42.75	42.76	42.715	42.725	26112.0
2019-02-21 18:00:00	AAPL	Stock	42.7125	42.7225	42.6925	42.7225	10480.0
2019-02-21 19:00:00	AAPL	Stock	42.7375	42.7475	42.7275	42.7475	9608.0
2019-02-21 04:00:00	MSFT	Stock	107.35	107.35	107.25	107.25	1479.0
2019-02-21 05:00:00	MSFT	Stock	107.27	107.5	107.27	107.5	804.0
2019-02-21 06:00:00	MSFT	Stock	107.35	107.35	107.31	107.31	1004.0
2019-02-21 07:00:00	MSFT	Stock	107.31	107.31	107.14	107.15	7748.0
2019-02-21 08:00:00	MSFT	Stock	107.15	107.25	107.0	107.05	120614.0
2019-02-21 09:00:00	MSFT	Stock	107.05	107.55	106.87	107.19	2658871.0
2019-02-21 10:00:00	MSFT	Stock	107.19	108.57	107.04	108.48	4255884.0
2019-02-21 11:00:00	MSFT	Stock	108.484	109.32	108.435	109.14	5044303.0
2019-02-21 12:00:00	MSFT	Stock	109.14	109.46	108.99	109.447	2528558.0
2019-02-21 13:00:00	MSFT	Stock	109.45	109.48	109.24	109.34	2015837.0
2019-02-21 14:00:00	MSFT	Stock	109.33	109.36	108.65	108.852	2545691.0
2019-02-21 15:00:00	MSFT	Stock	108.85	109.47	108.75	109.44	4374211.0
2019-02-21 16:00:00	MSFT	Stock	109.41	109.48	109.33	109.35	2104495.0
2019-02-21 17:00:00	MSFT	Stock	109.34	109.39	109.25	109.27	14161.0
2019-02-21 18:00:00	MSFT	Stock	109.25	109.3	109.23	109.25	1567.0
2019-02-21 19:00:00	MSFT	Stock	109.27	109.35	109.23	109.35	6148.0
2019-02-21 05:00:00	NVDA	Stock	4.0	4.0	4.0	4.0	4000.0
2019-02-21 06:00:00	NVDA	Stock	3.9978	4.0	3.986	3.986	14280.0
2019-02-21 07:00:00	NVDA	Stock	3.995	4.0	3.97	3.9812	1051240.0
2019-02-21 08:00:00	NVDA	Stock	3.9795	4.0	3.9702	3.986	1521480.0
2019-02-21 09:00:00	NVDA	Stock	3.9825	4.0013	3.9275	3.9492	69263760.0
2019-02-21 10:00:00	NVDA	Stock	3.949	3.9498	3.907	3.9192	75715560.0
2019-02-21 11:00:00	NVDA	Stock	3.921	3.9592	3.9155	3.9522	50071800.0
2019-02-21 12:00:00	NVDA	Stock	3.9525	3.9605	3.9388	3.9418	38875360.0
2019-02-21 13:00:00	NVDA	Stock	3.9412	3.9482	3.9242	3.9285	27920880.0
2019-02-21 14:00:00	NVDA	Stock	3.9285	3.932	3.8795	3.8916	60488440.0
2019-02-21 15:00:00	NVDA	Stock	3.8914	3.9018	3.8808	3.8952	60776320.0
2019-02-21 16:00:00	NVDA	Stock	3.8943	3.8975	3.8875	3.89	26186920.0
2019-02-21 17:00:00	NVDA	Stock	3.89	3.8943	3.889	3.8925	234840.0
2019-02-21 18:00:00	NVDA	Stock	3.89	3.8943	3.89	3.8943	227640.0
2019-02-21 19:00:00	NVDA	Stock	3.8943	3.8943	3.8875	3.8875	263760.0
2019-02-21 07:00:00	AMZN	Stock	81.325	81.45	81.0075	81.158	49240.0
2019-02-21 08:00:00	AMZN	Stock	81.25	81.25	81.0	81.1	53940.0
2019-02-21 09:00:00	AMZN	Stock	81.1	81.1485	80.2	80.3006	8911860.0

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

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