PREVIEW / stock_1hour / 2019-08-13

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-08-13.parquet
  size:    1.1 MB
  rows:    50,025
  symbols: 2,571

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-08-13 04:00:00	AAPL	Stock	50.015	50.0675	50.015	50.0675	1148.0
2019-08-13 05:00:00	AAPL	Stock	50.0	50.0	49.7625	49.83	35732.0
2019-08-13 06:00:00	AAPL	Stock	49.8525	50.03	49.74	50.03	37696.0
2019-08-13 07:00:00	AAPL	Stock	50.0	50.25	50.0	50.18	230484.0
2019-08-13 08:00:00	AAPL	Stock	50.1175	50.2125	49.9825	50.08	183492.0
2019-08-13 09:00:00	AAPL	Stock	50.08	53.035	50.03	53.0175	40216468.0
2019-08-13 10:00:00	AAPL	Stock	53.0112	53.0165	52.145	52.1625	35594660.0
2019-08-13 11:00:00	AAPL	Stock	52.1638	52.2775	51.8775	52.195	24099088.0
2019-08-13 12:00:00	AAPL	Stock	52.1987	52.245	52.0075	52.1075	9962444.0
2019-08-13 13:00:00	AAPL	Stock	52.11	52.41	52.0725	52.3575	10488084.0
2019-08-13 14:00:00	AAPL	Stock	52.3575	52.5	52.3375	52.4175	9653904.0
2019-08-13 15:00:00	AAPL	Stock	52.415	52.45	52.205	52.245	20457664.0
2019-08-13 16:00:00	AAPL	Stock	52.245	52.3	50.12	52.2275	12440444.0
2019-08-13 17:00:00	AAPL	Stock	52.2275	52.2575	52.192	52.2575	73684.0
2019-08-13 18:00:00	AAPL	Stock	52.2725	52.35	52.23	52.35	109816.0
2019-08-13 19:00:00	AAPL	Stock	52.36	52.4425	52.35	52.375	155972.0
2019-08-13 04:00:00	MSFT	Stock	135.6	135.65	135.11	135.65	642.0
2019-08-13 05:00:00	MSFT	Stock	135.56	135.56	134.7	134.99	3580.0
2019-08-13 06:00:00	MSFT	Stock	134.75	135.48	134.71	135.48	550.0
2019-08-13 07:00:00	MSFT	Stock	135.58	135.58	135.27	135.35	10121.0
2019-08-13 08:00:00	MSFT	Stock	135.52	135.59	135.15	135.3	25051.0
2019-08-13 09:00:00	MSFT	Stock	135.3	138.8	135.0	138.55	3769159.0
2019-08-13 10:00:00	MSFT	Stock	138.52	138.76	137.82	137.95	3812006.0
2019-08-13 11:00:00	MSFT	Stock	137.92	138.44	137.39	138.34	2352362.0
2019-08-13 12:00:00	MSFT	Stock	138.35	138.475	138.05	138.22	1527620.0
2019-08-13 13:00:00	MSFT	Stock	138.23	138.4	137.73	138.31	1720762.0
2019-08-13 14:00:00	MSFT	Stock	138.31	138.73	138.2	138.562	1906943.0
2019-08-13 15:00:00	MSFT	Stock	138.56	138.67	138.19	138.6	3784596.0
2019-08-13 16:00:00	MSFT	Stock	138.6	138.84	138.46	138.66	2886989.0
2019-08-13 17:00:00	MSFT	Stock	138.67	138.75	138.66	138.7	7026.0
2019-08-13 18:00:00	MSFT	Stock	138.63	138.76	138.53	138.75	6438.0
2019-08-13 19:00:00	MSFT	Stock	138.8	138.89	138.75	138.89	11205.0
2019-08-13 05:00:00	NVDA	Stock	3.7815	3.786	3.7375	3.7375	40560.0
2019-08-13 06:00:00	NVDA	Stock	3.7653	3.7722	3.7653	3.7722	8000.0
2019-08-13 07:00:00	NVDA	Stock	3.7722	3.7775	3.7628	3.7628	253760.0
2019-08-13 08:00:00	NVDA	Stock	3.7744	3.7833	3.763	3.7668	505440.0
2019-08-13 09:00:00	NVDA	Stock	3.7725	3.9238	3.7455	3.9188	78701040.0
2019-08-13 10:00:00	NVDA	Stock	3.9188	3.9475	3.8825	3.9112	57710800.0
2019-08-13 11:00:00	NVDA	Stock	3.911	3.9213	3.8842	3.9172	35593440.0
2019-08-13 12:00:00	NVDA	Stock	3.9185	3.9365	3.8978	3.9045	23771040.0
2019-08-13 13:00:00	NVDA	Stock	3.9058	3.9206	3.8975	3.9105	19850680.0
2019-08-13 14:00:00	NVDA	Stock	3.9108	3.9239	3.9042	3.9142	15685360.0
2019-08-13 15:00:00	NVDA	Stock	3.9138	3.9152	3.8943	3.902	38646240.0
2019-08-13 16:00:00	NVDA	Stock	3.9013	3.9225	3.9013	3.9175	21589120.0
2019-08-13 17:00:00	NVDA	Stock	3.9175	3.92	3.91	3.915	289920.0
2019-08-13 18:00:00	NVDA	Stock	3.915	3.9225	3.9135	3.9225	147360.0
2019-08-13 19:00:00	NVDA	Stock	3.9245	3.925	3.9188	3.925	187160.0
2019-08-13 04:00:00	AMZN	Stock	89.0	89.0	89.0	89.0	3180.0
2019-08-13 05:00:00	AMZN	Stock	88.9755	88.9755	88.6295	88.6295	10960.0
2019-08-13 06:00:00	AMZN	Stock	88.9925	88.9925	88.9925	88.9925	2000.0

> showing 50 of 50,025 rows — these rows as CSV

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