PREVIEW / stock_1hour / 2019-12-19

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-12-19.parquet
  size:    1.2 MB
  rows:    50,898
  symbols: 2,501

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-19 04:00:00	AAPL	Stock	69.9	69.9	69.845	69.875	3284.0
2019-12-19 05:00:00	AAPL	Stock	69.895	69.895	69.895	69.895	400.0
2019-12-19 06:00:00	AAPL	Stock	69.9175	69.9175	69.7375	69.8075	47548.0
2019-12-19 07:00:00	AAPL	Stock	69.79	69.8875	69.7625	69.7875	161960.0
2019-12-19 08:00:00	AAPL	Stock	69.8225	69.8875	69.7375	69.8475	281840.0
2019-12-19 09:00:00	AAPL	Stock	69.8475	70.295	69.825	70.115	10833368.0
2019-12-19 10:00:00	AAPL	Stock	70.11	70.137	69.865	69.872	10705184.0
2019-12-19 11:00:00	AAPL	Stock	69.8725	70.0675	69.8725	69.9565	7263148.0
2019-12-19 12:00:00	AAPL	Stock	69.955	69.9875	69.745	69.8688	6112556.0
2019-12-19 13:00:00	AAPL	Stock	69.87	69.9455	69.765	69.7738	5884012.0
2019-12-19 14:00:00	AAPL	Stock	69.774	70.02	69.7375	69.92	7761524.0
2019-12-19 15:00:00	AAPL	Stock	69.9225	70.025	69.825	70.0075	11247700.0
2019-12-19 16:00:00	AAPL	Stock	70.005	70.0625	69.9035	70.045	18978448.0
2019-12-19 17:00:00	AAPL	Stock	70.045	70.045	70.005	70.0425	382940.0
2019-12-19 18:00:00	AAPL	Stock	70.0375	70.0475	70.025	70.04	93536.0
2019-12-19 19:00:00	AAPL	Stock	70.0275	70.0625	70.0275	70.06	39660.0
2019-12-19 04:00:00	MSFT	Stock	154.5	154.5	154.5	154.5	150.0
2019-12-19 05:00:00	MSFT	Stock	154.6	154.6	154.6	154.6	462.0
2019-12-19 06:00:00	MSFT	Stock	154.55	154.55	154.5	154.5	601.0
2019-12-19 07:00:00	MSFT	Stock	154.55	154.56	154.18	154.4	25216.0
2019-12-19 08:00:00	MSFT	Stock	154.44	154.75	154.2	154.32	10628.0
2019-12-19 09:00:00	MSFT	Stock	154.5	154.78	153.75	154.505	1565763.0
2019-12-19 10:00:00	MSFT	Stock	154.51	154.694	154.31	154.47	1543681.0
2019-12-19 11:00:00	MSFT	Stock	154.47	154.96	154.38	154.93	1530343.0
2019-12-19 12:00:00	MSFT	Stock	154.925	155.14	154.92	154.99	1214429.0
2019-12-19 13:00:00	MSFT	Stock	154.98	155.338	154.9	155.3	1579422.0
2019-12-19 14:00:00	MSFT	Stock	155.3	155.75	155.28	155.63	2630884.0
2019-12-19 15:00:00	MSFT	Stock	155.63	155.77	155.34	155.71	4643545.0
2019-12-19 16:00:00	MSFT	Stock	155.71	155.9	155.268	155.87	6612218.0
2019-12-19 17:00:00	MSFT	Stock	155.87	155.89	155.71	155.87	161313.0
2019-12-19 18:00:00	MSFT	Stock	155.82	155.84	155.71	155.77	852208.0
2019-12-19 19:00:00	MSFT	Stock	155.8	155.87	155.8	155.8	3356.0
2019-12-19 04:00:00	NVDA	Stock	5.7763	5.78	5.7763	5.78	19200.0
2019-12-19 05:00:00	NVDA	Stock	5.7858	5.794	5.7858	5.794	23960.0
2019-12-19 06:00:00	NVDA	Stock	5.78	5.78	5.775	5.775	24760.0
2019-12-19 07:00:00	NVDA	Stock	5.7788	5.7938	5.775	5.7792	539040.0
2019-12-19 08:00:00	NVDA	Stock	5.7874	5.7928	5.7235	5.779	934840.0
2019-12-19 09:00:00	NVDA	Stock	5.7803	5.8368	5.7675	5.8334	61007280.0
2019-12-19 10:00:00	NVDA	Stock	5.8338	5.9	5.8173	5.8738	120017800.0
2019-12-19 11:00:00	NVDA	Stock	5.8748	5.8988	5.8682	5.8801	49039520.0
2019-12-19 12:00:00	NVDA	Stock	5.8802	5.889	5.8545	5.8642	32763400.0
2019-12-19 13:00:00	NVDA	Stock	5.864	5.8728	5.8555	5.8708	30698400.0
2019-12-19 14:00:00	NVDA	Stock	5.8709	5.8893	5.8685	5.8825	33322480.0
2019-12-19 15:00:00	NVDA	Stock	5.8825	5.8912	5.8665	5.8875	48255440.0
2019-12-19 16:00:00	NVDA	Stock	5.8865	5.892	5.8838	5.8865	4638400.0
2019-12-19 17:00:00	NVDA	Stock	5.8895	5.8962	5.8865	5.8962	679360.0
2019-12-19 18:00:00	NVDA	Stock	5.895	5.9	5.8865	5.8975	7249240.0
2019-12-19 19:00:00	NVDA	Stock	5.8975	5.898	5.8912	5.8962	486920.0
2019-12-19 06:00:00	AMZN	Stock	89.1	89.1	89.1	89.1	2000.0
2019-12-19 07:00:00	AMZN	Stock	89.15	89.1995	89.128	89.128	34440.0

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

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