PREVIEW / stock_1hour / 2019-08-27

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-08-27.parquet
  size:    1.1 MB
  rows:    50,213
  symbols: 2,575

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-27 04:00:00	AAPL	Stock	51.47	51.5	51.4275	51.5	2800.0
2019-08-27 05:00:00	AAPL	Stock	51.495	51.6725	51.495	51.6725	19436.0
2019-08-27 06:00:00	AAPL	Stock	51.6225	51.7225	51.6225	51.71	6540.0
2019-08-27 07:00:00	AAPL	Stock	51.715	51.8375	51.6375	51.775	90816.0
2019-08-27 08:00:00	AAPL	Stock	51.7325	51.9875	51.6525	51.9625	416776.0
2019-08-27 09:00:00	AAPL	Stock	51.9625	52.1375	51.6675	51.7325	11574516.0
2019-08-27 10:00:00	AAPL	Stock	51.7312	51.795	51.37	51.4125	10451492.0
2019-08-27 11:00:00	AAPL	Stock	51.415	51.4725	51.0585	51.1975	9347396.0
2019-08-27 12:00:00	AAPL	Stock	51.195	51.2725	50.92	50.9362	7459712.0
2019-08-27 13:00:00	AAPL	Stock	50.93	51.32	50.8825	51.283	6873520.0
2019-08-27 14:00:00	AAPL	Stock	51.28	51.3925	51.0988	51.3668	5911748.0
2019-08-27 15:00:00	AAPL	Stock	51.37	51.5	51.0125	51.035	14527612.0
2019-08-27 16:00:00	AAPL	Stock	51.0325	51.0925	50.995	51.085	19575236.0
2019-08-27 17:00:00	AAPL	Stock	51.0875	51.1425	51.05	51.075	40968.0
2019-08-27 18:00:00	AAPL	Stock	51.085	51.2625	51.085	51.195	60456.0
2019-08-27 19:00:00	AAPL	Stock	51.18	51.24	51.1625	51.24	33092.0
2019-08-27 04:00:00	MSFT	Stock	135.47	135.47	135.0	135.11	1100.0
2019-08-27 06:00:00	MSFT	Stock	135.69	135.7	135.65	135.65	518.0
2019-08-27 07:00:00	MSFT	Stock	135.84	135.93	135.47	135.65	34972.0
2019-08-27 08:00:00	MSFT	Stock	135.7	136.25	135.54	136.1	54406.0
2019-08-27 09:00:00	MSFT	Stock	136.1	136.715	136.08	136.52	2291583.0
2019-08-27 10:00:00	MSFT	Stock	136.53	136.72	136.03	136.07	1831576.0
2019-08-27 11:00:00	MSFT	Stock	136.09	136.255	135.23	135.66	1763474.0
2019-08-27 12:00:00	MSFT	Stock	135.67	135.8	134.78	134.83	1596334.0
2019-08-27 13:00:00	MSFT	Stock	134.8	135.83	134.66	135.825	1544411.0
2019-08-27 14:00:00	MSFT	Stock	135.825	136.12	135.36	136.026	1252762.0
2019-08-27 15:00:00	MSFT	Stock	136.04	136.32	135.15	135.75	3342571.0
2019-08-27 16:00:00	MSFT	Stock	135.7	136.0	135.55	135.74	3846898.0
2019-08-27 17:00:00	MSFT	Stock	135.7	135.72	135.62	135.62	7090.0
2019-08-27 18:00:00	MSFT	Stock	135.8	136.1	135.68	136.0	8823.0
2019-08-27 19:00:00	MSFT	Stock	135.82	136.08	135.82	136.04	5872.0
2019-08-27 05:00:00	NVDA	Stock	4.1245	4.1358	4.1245	4.1358	20000.0
2019-08-27 06:00:00	NVDA	Stock	4.1478	4.1478	4.1478	4.1478	4000.0
2019-08-27 07:00:00	NVDA	Stock	4.1403	4.153	4.1358	4.1525	208320.0
2019-08-27 08:00:00	NVDA	Stock	4.1421	4.1715	4.1355	4.1715	518560.0
2019-08-27 09:00:00	NVDA	Stock	4.171	4.1815	4.1382	4.1528	34622800.0
2019-08-27 10:00:00	NVDA	Stock	4.154	4.1595	4.1015	4.1042	28335120.0
2019-08-27 11:00:00	NVDA	Stock	4.1041	4.1083	4.044	4.0525	39030680.0
2019-08-27 12:00:00	NVDA	Stock	4.0515	4.0569	4.0228	4.0322	30341080.0
2019-08-27 13:00:00	NVDA	Stock	4.0305	4.0521	4.0155	4.0443	27342120.0
2019-08-27 14:00:00	NVDA	Stock	4.0437	4.0521	4.0252	4.0395	20507240.0
2019-08-27 15:00:00	NVDA	Stock	4.0408	4.056	4.0322	4.0452	37109760.0
2019-08-27 16:00:00	NVDA	Stock	4.0447	4.045	4.0375	4.045	22200400.0
2019-08-27 17:00:00	NVDA	Stock	4.0413	4.0413	4.0375	4.0375	55760.0
2019-08-27 18:00:00	NVDA	Stock	4.0388	4.0488	4.0388	4.0462	301360.0
2019-08-27 19:00:00	NVDA	Stock	4.045	4.0542	4.045	4.0542	227560.0
2019-08-27 04:00:00	AMZN	Stock	88.25	88.25	88.25	88.25	7080.0
2019-08-27 05:00:00	AMZN	Stock	88.367	88.367	88.367	88.367	7960.0
2019-08-27 06:00:00	AMZN	Stock	88.5375	88.5375	88.5375	88.5375	2000.0
2019-08-27 07:00:00	AMZN	Stock	88.625	88.625	88.508	88.508	9660.0

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

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