PREVIEW / stock_1hour / 2019-02-05

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-02-05.parquet
  size:    1.1 MB
  rows:    49,663
  symbols: 2,686

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-02-05 04:00:00	AAPL	Stock	42.825	42.9375	42.825	42.895	79344.0
2019-02-05 05:00:00	AAPL	Stock	42.9	42.98	42.895	42.98	28444.0
2019-02-05 06:00:00	AAPL	Stock	42.975	43.105	42.975	43.0275	24592.0
2019-02-05 07:00:00	AAPL	Stock	43.0025	43.1325	43.0	43.0875	247164.0
2019-02-05 08:00:00	AAPL	Stock	43.095	43.2425	43.0	43.2025	589784.0
2019-02-05 09:00:00	AAPL	Stock	43.2	43.62	43.0875	43.5513	22760456.0
2019-02-05 10:00:00	AAPL	Stock	43.553	43.75	43.4	43.7032	21999408.0
2019-02-05 11:00:00	AAPL	Stock	43.705	43.77	43.5037	43.6028	16258600.0
2019-02-05 12:00:00	AAPL	Stock	43.6075	43.61	43.2525	43.2912	12734744.0
2019-02-05 13:00:00	AAPL	Stock	43.2925	43.4725	43.1725	43.4492	12872052.0
2019-02-05 14:00:00	AAPL	Stock	43.45	43.61	43.4462	43.5525	11800640.0
2019-02-05 15:00:00	AAPL	Stock	43.5582	43.62	43.4375	43.525	18715832.0
2019-02-05 16:00:00	AAPL	Stock	43.545	43.555	43.4725	43.4775	11778724.0
2019-02-05 17:00:00	AAPL	Stock	43.5225	43.53	43.49	43.525	54952.0
2019-02-05 18:00:00	AAPL	Stock	43.5	43.525	43.49	43.525	36380.0
2019-02-05 19:00:00	AAPL	Stock	43.5175	43.5725	43.505	43.5375	87952.0
2019-02-05 04:00:00	MSFT	Stock	105.52	105.52	105.52	105.52	101.0
2019-02-05 05:00:00	MSFT	Stock	105.69	105.7	105.69	105.7	297.0
2019-02-05 06:00:00	MSFT	Stock	105.75	105.85	105.75	105.85	850.0
2019-02-05 07:00:00	MSFT	Stock	105.91	106.13	105.88	106.13	11450.0
2019-02-05 08:00:00	MSFT	Stock	106.127	106.15	105.79	106.0	23977.0
2019-02-05 09:00:00	MSFT	Stock	106.0	106.86	105.92	106.51	3243274.0
2019-02-05 10:00:00	MSFT	Stock	106.51	107.01	106.17	106.86	3009052.0
2019-02-05 11:00:00	MSFT	Stock	106.86	106.975	106.42	106.936	2497732.0
2019-02-05 12:00:00	MSFT	Stock	106.94	107.015	106.61	106.7	2704463.0
2019-02-05 13:00:00	MSFT	Stock	106.705	107.03	106.56	106.97	1888841.0
2019-02-05 14:00:00	MSFT	Stock	106.97	107.17	106.96	107.085	2018290.0
2019-02-05 15:00:00	MSFT	Stock	107.09	107.27	106.94	107.23	4346453.0
2019-02-05 16:00:00	MSFT	Stock	107.22	107.31	107.02	107.22	5146748.0
2019-02-05 17:00:00	MSFT	Stock	107.22	107.24	107.06	107.12	20870.0
2019-02-05 18:00:00	MSFT	Stock	107.11	107.17	107.01	107.05	11895.0
2019-02-05 19:00:00	MSFT	Stock	107.05	107.13	107.02	107.07	4073.0
2019-02-05 04:00:00	NVDA	Stock	3.7252	3.7252	3.7252	3.7252	4240.0
2019-02-05 05:00:00	NVDA	Stock	3.7295	3.7295	3.7285	3.7288	22840.0
2019-02-05 06:00:00	NVDA	Stock	3.7295	3.7295	3.7295	3.7295	16000.0
2019-02-05 07:00:00	NVDA	Stock	3.7272	3.7375	3.7178	3.7292	365720.0
2019-02-05 08:00:00	NVDA	Stock	3.7325	3.7532	3.72	3.7532	2200920.0
2019-02-05 09:00:00	NVDA	Stock	3.75	3.7858	3.7262	3.7509	79892640.0
2019-02-05 10:00:00	NVDA	Stock	3.752	3.7725	3.73	3.7475	103456760.0
2019-02-05 11:00:00	NVDA	Stock	3.7475	3.7541	3.7128	3.7363	92452520.0
2019-02-05 12:00:00	NVDA	Stock	3.737	3.7378	3.7075	3.7127	54255040.0
2019-02-05 13:00:00	NVDA	Stock	3.7134	3.7588	3.7134	3.753	69757680.0
2019-02-05 14:00:00	NVDA	Stock	3.7542	3.7602	3.7415	3.7432	47955600.0
2019-02-05 15:00:00	NVDA	Stock	3.7438	3.7562	3.7355	3.7488	66704000.0
2019-02-05 16:00:00	NVDA	Stock	3.7488	3.7492	3.7375	3.745	18940640.0
2019-02-05 17:00:00	NVDA	Stock	3.7462	3.7478	3.7425	3.7465	214760.0
2019-02-05 18:00:00	NVDA	Stock	3.745	3.7478	3.7428	3.7478	308120.0
2019-02-05 19:00:00	NVDA	Stock	3.746	3.75	3.7443	3.7443	481760.0
2019-02-05 04:00:00	AMZN	Stock	81.4	81.4	81.4	81.4	2000.0
2019-02-05 05:00:00	AMZN	Stock	81.5	81.5	81.5	81.5	4000.0

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

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