PREVIEW / stock_1hour / 2018-10-26

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-10-26.parquet
  size:    1.1 MB
  rows:    49,904
  symbols: 2,748

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-26 04:00:00	AAPL	Stock	54.625	54.625	54.1075	54.1075	89308.0
2018-10-26 05:00:00	AAPL	Stock	54.13	54.1375	53.5	53.725	223684.0
2018-10-26 06:00:00	AAPL	Stock	53.6975	53.9625	53.65	53.8275	231012.0
2018-10-26 07:00:00	AAPL	Stock	53.8125	54.22	53.8125	54.025	596164.0
2018-10-26 08:00:00	AAPL	Stock	53.975	54.24	53.85	54.125	990072.0
2018-10-26 09:00:00	AAPL	Stock	54.12	54.455	53.6875	54.0925	22013628.0
2018-10-26 10:00:00	AAPL	Stock	54.0875	54.14	53.1975	53.2175	31676228.0
2018-10-26 11:00:00	AAPL	Stock	53.2075	54.2225	53.1675	54.0862	20090564.0
2018-10-26 12:00:00	AAPL	Stock	54.09	54.85	54.055	54.7175	15620568.0
2018-10-26 13:00:00	AAPL	Stock	54.71	55.0475	54.19	54.6725	15028968.0
2018-10-26 14:00:00	AAPL	Stock	54.6732	54.7625	53.8575	53.9398	12739512.0
2018-10-26 15:00:00	AAPL	Stock	53.925	54.28	53.6525	54.0075	26999544.0
2018-10-26 16:00:00	AAPL	Stock	54.0075	54.24	53.9725	54.1925	13772376.0
2018-10-26 17:00:00	AAPL	Stock	54.1375	54.1925	54.075	54.075	167632.0
2018-10-26 18:00:00	AAPL	Stock	54.1925	54.2475	54.175	54.24	47800.0
2018-10-26 19:00:00	AAPL	Stock	54.2375	54.27	54.165	54.27	62576.0
2018-10-26 04:00:00	MSFT	Stock	106.59	106.59	105.47	106.0	10885.0
2018-10-26 05:00:00	MSFT	Stock	105.81	105.97	104.51	104.77	46830.0
2018-10-26 06:00:00	MSFT	Stock	104.77	105.3	104.46	104.51	29793.0
2018-10-26 07:00:00	MSFT	Stock	104.88	105.69	104.65	105.17	114506.0
2018-10-26 08:00:00	MSFT	Stock	105.24	105.95	104.8	105.57	257755.0
2018-10-26 09:00:00	MSFT	Stock	105.57	107.545	104.98	106.77	5667691.0
2018-10-26 10:00:00	MSFT	Stock	106.5	106.75	104.76	104.92	7738059.0
2018-10-26 11:00:00	MSFT	Stock	104.91	107.2	104.829	106.86	6045955.0
2018-10-26 12:00:00	MSFT	Stock	106.84	108.73	106.81	108.2	5206730.0
2018-10-26 13:00:00	MSFT	Stock	108.19	108.75	106.67	107.5	4039611.0
2018-10-26 14:00:00	MSFT	Stock	107.5	107.64	106.15	106.4	4430422.0
2018-10-26 15:00:00	MSFT	Stock	106.39	107.64	105.8	106.96	10237212.0
2018-10-26 16:00:00	MSFT	Stock	106.96	107.33	106.1	107.15	6056966.0
2018-10-26 17:00:00	MSFT	Stock	107.13	107.15	106.9	107.03	33636.0
2018-10-26 18:00:00	MSFT	Stock	107.06	107.15	107.04	107.1	3680.0
2018-10-26 19:00:00	MSFT	Stock	107.07	107.18	107.01	107.1	7594.0
2018-10-26 04:00:00	NVDA	Stock	5.0828	5.0828	5.0	5.0075	225880.0
2018-10-26 05:00:00	NVDA	Stock	5.0132	5.0132	4.9228	4.95	387560.0
2018-10-26 06:00:00	NVDA	Stock	4.95	5.0	4.95	4.975	285880.0
2018-10-26 07:00:00	NVDA	Stock	4.9563	5.0248	4.9508	4.957	934200.0
2018-10-26 08:00:00	NVDA	Stock	4.975	5.0425	4.94	5.021	1705960.0
2018-10-26 09:00:00	NVDA	Stock	5.021	5.0875	4.9075	5.0278	66308840.0
2018-10-26 10:00:00	NVDA	Stock	5.025	5.026	4.828	4.8376	112476880.0
2018-10-26 11:00:00	NVDA	Stock	4.838	5.0063	4.8325	4.9994	65649040.0
2018-10-26 12:00:00	NVDA	Stock	4.9995	5.121	4.9865	5.0672	68162160.0
2018-10-26 13:00:00	NVDA	Stock	5.0655	5.1187	5.0028	5.015	47876040.0
2018-10-26 14:00:00	NVDA	Stock	5.014	5.024	4.8928	4.9032	62698120.0
2018-10-26 15:00:00	NVDA	Stock	4.9043	4.962	4.8755	4.9572	102664480.0
2018-10-26 16:00:00	NVDA	Stock	4.9572	4.9875	4.9498	4.975	26435160.0
2018-10-26 17:00:00	NVDA	Stock	4.98	4.9812	4.9572	4.9688	278400.0
2018-10-26 18:00:00	NVDA	Stock	4.9788	4.98	4.9728	4.98	86200.0
2018-10-26 19:00:00	NVDA	Stock	4.9725	4.98	4.9725	4.98	21600.0
2018-10-26 04:00:00	AMZN	Stock	82.1505	82.313	81.995	81.995	147320.0
2018-10-26 05:00:00	AMZN	Stock	81.925	81.925	79.3	79.958	423920.0

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

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