PREVIEW / stock_1hour / 2018-02-05

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-02-05.parquet
  size:    1.1 MB
  rows:    52,458
  symbols: 2,912

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-02-05 04:00:00	AAPL	Stock	40.0	40.175	39.9375	40.125	95320.0
2018-02-05 05:00:00	AAPL	Stock	40.09	40.17	40.0725	40.14	40548.0
2018-02-05 06:00:00	AAPL	Stock	40.1375	40.1375	39.75	39.8875	278356.0
2018-02-05 07:00:00	AAPL	Stock	39.8875	39.9	39.5675	39.6625	1152924.0
2018-02-05 08:00:00	AAPL	Stock	40.0	40.0125	39.57	39.8475	1578776.0
2018-02-05 09:00:00	AAPL	Stock	39.85	40.8	39.5	40.7825	46538568.0
2018-02-05 10:00:00	AAPL	Stock	40.785	40.97	40.6525	40.84	35497564.0
2018-02-05 11:00:00	AAPL	Stock	40.845	40.9625	40.275	40.4112	23079996.0
2018-02-05 12:00:00	AAPL	Stock	40.4075	40.51	40.1675	40.38	19873244.0
2018-02-05 13:00:00	AAPL	Stock	40.375	40.6175	40.1918	40.6095	20694748.0
2018-02-05 14:00:00	AAPL	Stock	40.604	40.62	40.0975	40.1675	22805968.0
2018-02-05 15:00:00	AAPL	Stock	40.1638	40.2725	39.0	39.1225	70313792.0
2018-02-05 16:00:00	AAPL	Stock	39.1225	40.1875	38.9475	39.01	16852928.0
2018-02-05 17:00:00	AAPL	Stock	39.01	39.05	38.9	38.975	328928.0
2018-02-05 18:00:00	AAPL	Stock	39.0	39.125	38.9375	38.965	414672.0
2018-02-05 19:00:00	AAPL	Stock	39.0	39.025	38.8425	38.855	319396.0
2018-02-05 04:00:00	MSFT	Stock	91.25	91.25	91.0	91.2	2249.0
2018-02-05 05:00:00	MSFT	Stock	91.0	91.0	91.0	91.0	100.0
2018-02-05 06:00:00	MSFT	Stock	91.11	91.23	90.82	90.88	8015.0
2018-02-05 07:00:00	MSFT	Stock	90.88	90.88	90.0	90.3	97414.0
2018-02-05 08:00:00	MSFT	Stock	90.345	91.2	90.0	90.98	143177.0
2018-02-05 09:00:00	MSFT	Stock	90.96	91.9	90.25	91.79	5002109.0
2018-02-05 10:00:00	MSFT	Stock	91.792	93.24	91.58	92.72	5313264.0
2018-02-05 11:00:00	MSFT	Stock	92.72	92.9	91.94	92.36	2957813.0
2018-02-05 12:00:00	MSFT	Stock	92.36	92.5	91.77	92.14	2727387.0
2018-02-05 13:00:00	MSFT	Stock	92.13	92.14	91.27	92.069	3896615.0
2018-02-05 14:00:00	MSFT	Stock	92.06	92.11	90.55	90.57	4599320.0
2018-02-05 15:00:00	MSFT	Stock	90.57	90.81	88.0	88.0	15612295.0
2018-02-05 16:00:00	MSFT	Stock	88.0	90.13	87.2	87.65	5990973.0
2018-02-05 17:00:00	MSFT	Stock	87.6	87.7	86.63	87.3	21959.0
2018-02-05 18:00:00	MSFT	Stock	87.2	87.69	87.1	87.16	16363.0
2018-02-05 19:00:00	MSFT	Stock	87.16	87.5	87.1	87.22	11968.0
2018-02-05 04:00:00	NVDA	Stock	5.786	5.786	5.7345	5.748	181600.0
2018-02-05 05:00:00	NVDA	Stock	5.742	5.7453	5.7075	5.7075	110800.0
2018-02-05 06:00:00	NVDA	Stock	5.709	5.7178	5.6878	5.7	257960.0
2018-02-05 07:00:00	NVDA	Stock	5.7025	5.7025	5.625	5.6625	4066360.0
2018-02-05 08:00:00	NVDA	Stock	5.6631	5.85	5.6255	5.7285	6111120.0
2018-02-05 09:00:00	NVDA	Stock	5.7318	5.7498	5.5	5.653	188002840.0
2018-02-05 10:00:00	NVDA	Stock	5.6505	5.8308	5.6408	5.6898	160602760.0
2018-02-05 11:00:00	NVDA	Stock	5.6863	5.708	5.618	5.671	94162720.0
2018-02-05 12:00:00	NVDA	Stock	5.6705	5.6732	5.6023	5.656	54813280.0
2018-02-05 13:00:00	NVDA	Stock	5.653	5.656	5.5813	5.6516	61945840.0
2018-02-05 14:00:00	NVDA	Stock	5.6516	5.6538	5.5333	5.5356	83040400.0
2018-02-05 15:00:00	NVDA	Stock	5.5353	5.5401	5.125	5.3418	284234440.0
2018-02-05 16:00:00	NVDA	Stock	5.3425	5.35	5.25	5.2558	23165160.0
2018-02-05 17:00:00	NVDA	Stock	5.2555	5.29	5.225	5.2563	2047840.0
2018-02-05 18:00:00	NVDA	Stock	5.2625	5.3028	5.2563	5.2875	1349920.0
2018-02-05 19:00:00	NVDA	Stock	5.2865	5.2865	5.225	5.225	1259400.0
2018-02-05 04:00:00	AMZN	Stock	71.05	71.05	70.6155	70.7135	52560.0
2018-02-05 05:00:00	AMZN	Stock	70.8315	70.9115	70.8315	70.9	65660.0

> showing 50 of 52,458 rows — these rows as CSV

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