PREVIEW / stock_1hour / 2019-12-17

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-12-17.parquet
  size:    1.2 MB
  rows:    51,039
  symbols: 2,524

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-12-17 04:00:00	AAPL	Stock	70.075	70.075	69.8725	69.9125	8448.0
2019-12-17 05:00:00	AAPL	Stock	69.9375	70.03	69.92	69.9675	31444.0
2019-12-17 06:00:00	AAPL	Stock	69.965	70.1475	69.6	69.645	96724.0
2019-12-17 07:00:00	AAPL	Stock	69.67	69.8225	69.625	69.775	295468.0
2019-12-17 08:00:00	AAPL	Stock	69.6875	69.97	69.65	69.9525	471724.0
2019-12-17 09:00:00	AAPL	Stock	69.9525	70.231	69.815	70.045	18131928.0
2019-12-17 10:00:00	AAPL	Stock	70.045	70.4425	69.9875	70.2125	16185596.0
2019-12-17 11:00:00	AAPL	Stock	70.211	70.365	69.7	70.14	14782292.0
2019-12-17 12:00:00	AAPL	Stock	70.143	70.3125	70.14	70.2725	6390512.0
2019-12-17 13:00:00	AAPL	Stock	70.275	70.2775	70.1625	70.2125	4456684.0
2019-12-17 14:00:00	AAPL	Stock	70.215	70.2425	70.0375	70.1798	5407476.0
2019-12-17 15:00:00	AAPL	Stock	70.1775	70.197	70.0425	70.105	10581176.0
2019-12-17 16:00:00	AAPL	Stock	70.1025	70.1325	70.05	70.065	13908888.0
2019-12-17 17:00:00	AAPL	Stock	70.0625	70.075	70.0075	70.0625	61936.0
2019-12-17 18:00:00	AAPL	Stock	70.06	70.0675	70.045	70.05	71716.0
2019-12-17 19:00:00	AAPL	Stock	70.045	70.095	70.045	70.09	71804.0
2019-12-17 04:00:00	MSFT	Stock	155.6	155.6	155.45	155.5	1109.0
2019-12-17 05:00:00	MSFT	Stock	155.55	155.63	155.55	155.57	900.0
2019-12-17 06:00:00	MSFT	Stock	155.46	155.59	155.42	155.59	10560.0
2019-12-17 07:00:00	MSFT	Stock	155.63	155.63	155.32	155.49	13580.0
2019-12-17 08:00:00	MSFT	Stock	155.499	155.81	155.35	155.7	24791.0
2019-12-17 09:00:00	MSFT	Stock	155.7	155.85	154.67	154.79	3031643.0
2019-12-17 10:00:00	MSFT	Stock	154.8	155.43	154.45	155.03	2246631.0
2019-12-17 11:00:00	MSFT	Stock	155.03	155.33	155.03	155.17	1406713.0
2019-12-17 12:00:00	MSFT	Stock	155.18	155.24	154.82	154.855	1315528.0
2019-12-17 13:00:00	MSFT	Stock	154.86	155.02	154.79	154.94	1149705.0
2019-12-17 14:00:00	MSFT	Stock	154.95	154.98	154.48	154.745	1664056.0
2019-12-17 15:00:00	MSFT	Stock	154.74	154.99	154.46	154.79	3236676.0
2019-12-17 16:00:00	MSFT	Stock	154.79	154.884	154.53	154.69	5505667.0
2019-12-17 17:00:00	MSFT	Stock	154.69	154.69	154.3	154.43	24943.0
2019-12-17 18:00:00	MSFT	Stock	154.5	154.55	154.45	154.45	3611.0
2019-12-17 19:00:00	MSFT	Stock	154.52	154.58	154.4	154.45	12048.0
2019-12-17 04:00:00	NVDA	Stock	5.6743	5.6743	5.6438	5.6438	8840.0
2019-12-17 05:00:00	NVDA	Stock	5.6313	5.6315	5.6313	5.6313	53320.0
2019-12-17 06:00:00	NVDA	Stock	5.6358	5.6612	5.6358	5.6612	130240.0
2019-12-17 07:00:00	NVDA	Stock	5.65	5.6605	5.6398	5.6425	454880.0
2019-12-17 08:00:00	NVDA	Stock	5.6612	5.6635	5.6375	5.655	532400.0
2019-12-17 09:00:00	NVDA	Stock	5.6502	5.6975	5.638	5.6672	47420080.0
2019-12-17 10:00:00	NVDA	Stock	5.6665	5.718	5.6644	5.6856	52192960.0
2019-12-17 11:00:00	NVDA	Stock	5.6865	5.6981	5.6774	5.6965	23458080.0
2019-12-17 12:00:00	NVDA	Stock	5.6963	5.7052	5.6838	5.6987	26930400.0
2019-12-17 13:00:00	NVDA	Stock	5.6987	5.7158	5.697	5.7105	28626400.0
2019-12-17 14:00:00	NVDA	Stock	5.7104	5.73	5.7055	5.724	26760840.0
2019-12-17 15:00:00	NVDA	Stock	5.7236	5.7275	5.6988	5.7075	43343800.0
2019-12-17 16:00:00	NVDA	Stock	5.7072	5.7072	5.7	5.7072	18462680.0
2019-12-17 17:00:00	NVDA	Stock	5.7025	5.7068	5.7025	5.7068	16440.0
2019-12-17 18:00:00	NVDA	Stock	5.7033	5.7218	5.6975	5.7218	1444520.0
2019-12-17 19:00:00	NVDA	Stock	5.7198	5.7225	5.7125	5.7135	604600.0
2019-12-17 05:00:00	AMZN	Stock	88.5	88.5	88.5	88.5	4000.0
2019-12-17 07:00:00	AMZN	Stock	88.56	88.673	88.56	88.6	33980.0

> showing 50 of 51,039 rows — these rows as CSV

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