PREVIEW / stock_1hour / 2018-10-11

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-10-11.parquet
  size:    1.1 MB
  rows:    51,220
  symbols: 2,784

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-10-11 04:00:00	AAPL	Stock	53.5	53.5	53.1	53.1625	126152.0
2018-10-11 05:00:00	AAPL	Stock	53.125	53.3	53.0	53.205	97768.0
2018-10-11 06:00:00	AAPL	Stock	53.2125	53.3075	53.0625	53.2075	84528.0
2018-10-11 07:00:00	AAPL	Stock	53.21	53.415	53.055	53.275	572704.0
2018-10-11 08:00:00	AAPL	Stock	53.175	53.8725	53.055	53.72	1923912.0
2018-10-11 09:00:00	AAPL	Stock	53.73	54.87	53.1925	54.8175	34741908.0
2018-10-11 10:00:00	AAPL	Stock	54.8225	54.875	53.8925	54.0425	24017340.0
2018-10-11 11:00:00	AAPL	Stock	54.055	54.5075	53.4875	54.185	20229560.0
2018-10-11 12:00:00	AAPL	Stock	54.1812	54.6925	54.06	54.24	12705488.0
2018-10-11 13:00:00	AAPL	Stock	54.2325	54.5	53.94	54.2612	10847688.0
2018-10-11 14:00:00	AAPL	Stock	54.2575	54.2725	53.08	53.4675	23541424.0
2018-10-11 15:00:00	AAPL	Stock	53.4525	54.425	53.3125	53.6125	30271784.0
2018-10-11 16:00:00	AAPL	Stock	53.6475	54.0	53.55	53.925	13580684.0
2018-10-11 17:00:00	AAPL	Stock	53.9975	54.0175	53.825	54.015	93340.0
2018-10-11 18:00:00	AAPL	Stock	53.9875	54.1875	53.9625	54.1875	146228.0
2018-10-11 19:00:00	AAPL	Stock	54.1875	54.25	54.1025	54.245	117248.0
2018-10-11 04:00:00	MSFT	Stock	105.0	105.0	104.04	104.75	13632.0
2018-10-11 05:00:00	MSFT	Stock	104.36	104.8	104.15	104.8	11878.0
2018-10-11 06:00:00	MSFT	Stock	104.73	104.75	104.28	104.7	13932.0
2018-10-11 07:00:00	MSFT	Stock	104.53	105.2	104.11	105.14	82017.0
2018-10-11 08:00:00	MSFT	Stock	104.75	106.2	104.18	105.66	215025.0
2018-10-11 09:00:00	MSFT	Stock	105.66	108.24	105.23	108.11	9106713.0
2018-10-11 10:00:00	MSFT	Stock	108.12	108.204	106.34	106.6	7388103.0
2018-10-11 11:00:00	MSFT	Stock	106.62	108.85	105.9	108.2	7141968.0
2018-10-11 12:00:00	MSFT	Stock	108.2	108.93	106.5	107.6	4865419.0
2018-10-11 13:00:00	MSFT	Stock	107.57	107.98	106.64	107.43	3910525.0
2018-10-11 14:00:00	MSFT	Stock	107.43	107.575	104.2	105.83	7760288.0
2018-10-11 15:00:00	MSFT	Stock	105.8	107.67	105.33	105.92	10971872.0
2018-10-11 16:00:00	MSFT	Stock	106.08	107.23	105.91	107.2	4638942.0
2018-10-11 17:00:00	MSFT	Stock	107.17	107.258	106.75	107.258	12929.0
2018-10-11 18:00:00	MSFT	Stock	107.3	107.5	107.0	107.18	23355.0
2018-10-11 19:00:00	MSFT	Stock	107.35	107.5	107.05	107.5	29363.0
2018-10-11 04:00:00	NVDA	Stock	6.1125	6.1125	5.9758	5.979	191320.0
2018-10-11 05:00:00	NVDA	Stock	5.9775	6.0025	5.9625	6.0025	345160.0
2018-10-11 06:00:00	NVDA	Stock	5.9895	6.0125	5.9762	5.9878	168360.0
2018-10-11 07:00:00	NVDA	Stock	5.9913	6.0265	5.9665	6.0173	1139840.0
2018-10-11 08:00:00	NVDA	Stock	6.0	6.1	5.964	6.0913	3196800.0
2018-10-11 09:00:00	NVDA	Stock	6.0913	6.189	5.9715	6.1864	114105240.0
2018-10-11 10:00:00	NVDA	Stock	6.1833	6.1859	5.9935	5.9963	85737920.0
2018-10-11 11:00:00	NVDA	Stock	5.9976	6.0668	5.9	6.0329	106085640.0
2018-10-11 12:00:00	NVDA	Stock	6.0353	6.1235	6.0178	6.0644	52422440.0
2018-10-11 13:00:00	NVDA	Stock	6.0632	6.0742	5.98	6.011	43736000.0
2018-10-11 14:00:00	NVDA	Stock	6.0085	6.021	5.8565	5.8901	84439040.0
2018-10-11 15:00:00	NVDA	Stock	5.8878	6.0093	5.869	5.878	125765600.0
2018-10-11 16:00:00	NVDA	Stock	5.8783	5.9366	5.875	5.9138	19454960.0
2018-10-11 17:00:00	NVDA	Stock	5.925	5.9375	5.9128	5.9375	376000.0
2018-10-11 18:00:00	NVDA	Stock	5.9488	5.9812	5.943	5.9578	777120.0
2018-10-11 19:00:00	NVDA	Stock	5.9578	6.0075	5.9578	6.0063	837840.0
2018-10-11 04:00:00	AMZN	Stock	85.4995	85.899	85.2	85.8	200580.0
2018-10-11 05:00:00	AMZN	Stock	85.75	86.25	85.6	86.2125	126220.0

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

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