PREVIEW / stock_1hour / 2019-07-10

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-07-10.parquet
  size:    1.1 MB
  rows:    50,916
  symbols: 2,594

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-07-10 04:00:00	AAPL	Stock	50.145	50.145	50.125	50.125	1200.0
2019-07-10 05:00:00	AAPL	Stock	50.185	50.3275	50.185	50.185	23656.0
2019-07-10 06:00:00	AAPL	Stock	50.1275	50.145	50.0825	50.1025	1824.0
2019-07-10 07:00:00	AAPL	Stock	50.1675	50.22	50.0625	50.1525	53956.0
2019-07-10 08:00:00	AAPL	Stock	50.1925	50.575	50.0925	50.498	552372.0
2019-07-10 09:00:00	AAPL	Stock	50.4875	50.9325	50.39	50.873	12298956.0
2019-07-10 10:00:00	AAPL	Stock	50.875	50.8975	50.63	50.645	9503352.0
2019-07-10 11:00:00	AAPL	Stock	50.6438	50.8475	50.5425	50.825	7289600.0
2019-07-10 12:00:00	AAPL	Stock	50.83	50.87	50.715	50.7975	4726796.0
2019-07-10 13:00:00	AAPL	Stock	50.7988	50.895	50.7725	50.835	3973400.0
2019-07-10 14:00:00	AAPL	Stock	50.84	50.895	50.6775	50.8025	5556508.0
2019-07-10 15:00:00	AAPL	Stock	50.805	50.8875	50.75	50.8025	9628188.0
2019-07-10 16:00:00	AAPL	Stock	50.8075	50.825	50.8	50.825	6640704.0
2019-07-10 17:00:00	AAPL	Stock	50.82	50.825	50.805	50.805	26648.0
2019-07-10 18:00:00	AAPL	Stock	50.8425	50.85	50.8075	50.85	36616.0
2019-07-10 19:00:00	AAPL	Stock	50.8375	50.855	50.8275	50.8275	11532.0
2019-07-10 04:00:00	MSFT	Stock	136.3	136.3	136.3	136.3	400.0
2019-07-10 05:00:00	MSFT	Stock	136.4	136.6	135.8	135.8	2620.0
2019-07-10 06:00:00	MSFT	Stock	135.7	135.75	135.7	135.75	680.0
2019-07-10 07:00:00	MSFT	Stock	136.2	136.27	135.85	136.05	20326.0
2019-07-10 08:00:00	MSFT	Stock	136.1	137.5	135.96	137.125	93087.0
2019-07-10 09:00:00	MSFT	Stock	137.25	138.37	137.02	138.23	2962968.0
2019-07-10 10:00:00	MSFT	Stock	138.23	138.58	137.55	137.575	3320076.0
2019-07-10 11:00:00	MSFT	Stock	137.575	137.9	137.27	137.843	1937634.0
2019-07-10 12:00:00	MSFT	Stock	137.85	137.875	137.3	137.47	1388361.0
2019-07-10 13:00:00	MSFT	Stock	137.48	137.95	137.47	137.77	1256902.0
2019-07-10 14:00:00	MSFT	Stock	137.77	137.9	137.11	137.35	1578054.0
2019-07-10 15:00:00	MSFT	Stock	137.36	137.96	137.21	137.86	3794054.0
2019-07-10 16:00:00	MSFT	Stock	137.85	138.18	137.82	137.89	4358946.0
2019-07-10 17:00:00	MSFT	Stock	137.85	137.99	137.85	137.96	7972.0
2019-07-10 18:00:00	MSFT	Stock	137.85	137.98	137.85	137.91	11050.0
2019-07-10 19:00:00	MSFT	Stock	137.95	137.95	137.85	137.85	4876.0
2019-07-10 04:00:00	NVDA	Stock	3.95	3.95	3.95	3.95	4000.0
2019-07-10 05:00:00	NVDA	Stock	3.9462	3.9528	3.925	3.9462	24760.0
2019-07-10 06:00:00	NVDA	Stock	3.93	3.93	3.9212	3.9212	45600.0
2019-07-10 07:00:00	NVDA	Stock	3.9348	3.9528	3.9338	3.945	1611000.0
2019-07-10 08:00:00	NVDA	Stock	3.9375	3.979	3.9338	3.9751	4915520.0
2019-07-10 09:00:00	NVDA	Stock	3.9778	4.0592	3.9625	4.0455	109508520.0
2019-07-10 10:00:00	NVDA	Stock	4.0463	4.0495	3.9913	3.9931	83261720.0
2019-07-10 11:00:00	NVDA	Stock	3.9926	4.017	3.9848	4.012	48238720.0
2019-07-10 12:00:00	NVDA	Stock	4.0127	4.0262	4.008	4.0168	39992520.0
2019-07-10 13:00:00	NVDA	Stock	4.0168	4.03	4.013	4.0182	36634280.0
2019-07-10 14:00:00	NVDA	Stock	4.019	4.0242	3.9985	4.0035	35660720.0
2019-07-10 15:00:00	NVDA	Stock	4.0035	4.0093	3.9948	4.0015	39196000.0
2019-07-10 16:00:00	NVDA	Stock	4.0015	4.0055	4.001	4.005	5529800.0
2019-07-10 17:00:00	NVDA	Stock	4.002	4.0112	4.002	4.005	220200.0
2019-07-10 18:00:00	NVDA	Stock	4.005	4.01	4.0015	4.0088	313880.0
2019-07-10 19:00:00	NVDA	Stock	4.0085	4.0123	4.008	4.0118	152000.0
2019-07-10 04:00:00	AMZN	Stock	99.3	99.3	99.3	99.3	2000.0
2019-07-10 05:00:00	AMZN	Stock	99.3025	99.3025	99.15	99.15	13260.0

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

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