PREVIEW / stock_1hour / 2018-03-02

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-03-02.parquet
  size:    1.1 MB
  rows:    49,054
  symbols: 2,863

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
2018-03-02 04:00:00	AAPL	Stock	43.5925	43.5925	43.575	43.575	12276.0
2018-03-02 05:00:00	AAPL	Stock	43.5125	43.5375	43.3875	43.415	56796.0
2018-03-02 06:00:00	AAPL	Stock	43.4	43.4	43.1675	43.3225	173804.0
2018-03-02 07:00:00	AAPL	Stock	43.275	43.375	43.1375	43.15	492028.0
2018-03-02 08:00:00	AAPL	Stock	43.175	43.3425	43.05	43.275	1010076.0
2018-03-02 09:00:00	AAPL	Stock	43.275	43.5775	43.1	43.3907	23240196.0
2018-03-02 10:00:00	AAPL	Stock	43.38	43.8125	43.3215	43.635	25934976.0
2018-03-02 11:00:00	AAPL	Stock	43.6325	43.82	43.5025	43.7725	16321972.0
2018-03-02 12:00:00	AAPL	Stock	43.765	44.0325	43.7175	43.9525	13694128.0
2018-03-02 13:00:00	AAPL	Stock	43.95	43.98	43.53	43.6975	12938872.0
2018-03-02 14:00:00	AAPL	Stock	43.7	43.945	43.6825	43.7575	10958444.0
2018-03-02 15:00:00	AAPL	Stock	43.7625	44.075	43.6525	44.07	24774084.0
2018-03-02 16:00:00	AAPL	Stock	44.0525	44.0525	43.4075	44.025	10574712.0
2018-03-02 17:00:00	AAPL	Stock	44.015	44.035	43.9875	43.9875	78776.0
2018-03-02 18:00:00	AAPL	Stock	43.9975	44.025	43.9975	44.0	18836.0
2018-03-02 19:00:00	AAPL	Stock	44.025	44.025	43.975	44.0125	39804.0
2018-03-02 04:00:00	MSFT	Stock	92.5	92.5	92.5	92.5	100.0
2018-03-02 05:00:00	MSFT	Stock	92.23	92.5	92.22	92.24	4195.0
2018-03-02 06:00:00	MSFT	Stock	92.25	92.25	92.15	92.18	8991.0
2018-03-02 07:00:00	MSFT	Stock	92.29	92.45	91.75	91.9	44329.0
2018-03-02 08:00:00	MSFT	Stock	92.0	92.5	91.82	92.1	67648.0
2018-03-02 09:00:00	MSFT	Stock	92.05	92.06	90.86	91.65	4555257.0
2018-03-02 10:00:00	MSFT	Stock	91.66	92.14	91.21	91.805	4154466.0
2018-03-02 11:00:00	MSFT	Stock	91.8	92.36	91.46	92.354	2843814.0
2018-03-02 12:00:00	MSFT	Stock	92.34	92.5	91.97	92.25	3091522.0
2018-03-02 13:00:00	MSFT	Stock	92.24	92.31	91.35	91.65	2827790.0
2018-03-02 14:00:00	MSFT	Stock	91.66	92.42	91.66	92.13	2311779.0
2018-03-02 15:00:00	MSFT	Stock	92.13	93.15	91.79	93.04	5830207.0
2018-03-02 16:00:00	MSFT	Stock	93.05	93.05	91.718	92.88	4204247.0
2018-03-02 17:00:00	MSFT	Stock	92.88	93.05	92.88	93.0	16696.0
2018-03-02 18:00:00	MSFT	Stock	93.0	93.0	92.97	92.97	5353.0
2018-03-02 19:00:00	MSFT	Stock	93.03	93.03	93.02	93.02	1300.0
2018-03-02 04:00:00	NVDA	Stock	5.8175	5.8175	5.787	5.787	25440.0
2018-03-02 05:00:00	NVDA	Stock	5.7628	5.774	5.7628	5.7688	36000.0
2018-03-02 06:00:00	NVDA	Stock	5.725	5.728	5.7125	5.726	815960.0
2018-03-02 07:00:00	NVDA	Stock	5.7213	5.7338	5.67	5.675	2967440.0
2018-03-02 08:00:00	NVDA	Stock	5.68	5.7312	5.6545	5.7163	5176920.0
2018-03-02 09:00:00	NVDA	Stock	5.7083	5.751	5.5463	5.6805	192494600.0
2018-03-02 10:00:00	NVDA	Stock	5.6778	5.7375	5.6252	5.697	131831880.0
2018-03-02 11:00:00	NVDA	Stock	5.6953	5.7375	5.645	5.7345	108217240.0
2018-03-02 12:00:00	NVDA	Stock	5.735	5.8223	5.699	5.8142	98332240.0
2018-03-02 13:00:00	NVDA	Stock	5.813	5.8192	5.737	5.7894	83725840.0
2018-03-02 14:00:00	NVDA	Stock	5.7892	5.87	5.7872	5.842	95257920.0
2018-03-02 15:00:00	NVDA	Stock	5.842	5.92	5.8229	5.9135	163915440.0
2018-03-02 16:00:00	NVDA	Stock	5.9152	5.92	5.9055	5.9125	3328480.0
2018-03-02 17:00:00	NVDA	Stock	5.9075	5.9083	5.8975	5.9015	7446040.0
2018-03-02 18:00:00	NVDA	Stock	5.9015	5.9115	5.9015	5.905	139080.0
2018-03-02 19:00:00	NVDA	Stock	5.91	5.92	5.91	5.92	691600.0
2018-03-02 04:00:00	AMZN	Stock	74.3125	74.3125	74.1	74.1305	19060.0
2018-03-02 05:00:00	AMZN	Stock	74.1305	74.1305	74.1305	74.1305	6920.0

> showing 50 of 49,054 rows — these rows as CSV

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