PREVIEW / stock_1hour / 2018-03-13

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-03-13.parquet
  size:    1.1 MB
  rows:    49,205
  symbols: 2,864

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-13 04:00:00	AAPL	Stock	45.375	45.4	45.375	45.4	5136.0
2018-03-13 05:00:00	AAPL	Stock	45.4	45.4025	45.375	45.4025	18940.0
2018-03-13 06:00:00	AAPL	Stock	45.4125	45.45	45.4125	45.45	30068.0
2018-03-13 07:00:00	AAPL	Stock	45.4625	45.525	45.4625	45.4925	204900.0
2018-03-13 08:00:00	AAPL	Stock	45.475	45.6375	45.4375	45.575	903972.0
2018-03-13 09:00:00	AAPL	Stock	45.5775	45.825	45.535	45.7925	14489964.0
2018-03-13 10:00:00	AAPL	Stock	45.7925	45.875	45.6275	45.675	16238844.0
2018-03-13 11:00:00	AAPL	Stock	45.6825	45.6925	45.335	45.48	19196064.0
2018-03-13 12:00:00	AAPL	Stock	45.48	45.5535	45.2025	45.4975	10684088.0
2018-03-13 13:00:00	AAPL	Stock	45.4975	45.635	45.335	45.355	9159392.0
2018-03-13 14:00:00	AAPL	Stock	45.3575	45.43	45.115	45.2275	12471304.0
2018-03-13 15:00:00	AAPL	Stock	45.2275	45.29	44.81	44.9875	24448060.0
2018-03-13 16:00:00	AAPL	Stock	44.995	45.035	44.9125	44.955	6588208.0
2018-03-13 17:00:00	AAPL	Stock	44.9225	44.9625	44.7525	44.8025	234200.0
2018-03-13 18:00:00	AAPL	Stock	44.8025	45.0	44.775	44.9625	176580.0
2018-03-13 19:00:00	AAPL	Stock	44.93	44.975	44.925	44.955	58328.0
2018-03-13 04:00:00	MSFT	Stock	96.79	96.79	96.79	96.79	540.0
2018-03-13 05:00:00	MSFT	Stock	96.65	96.67	96.65	96.67	5500.0
2018-03-13 07:00:00	MSFT	Stock	96.65	96.78	96.61	96.69	10494.0
2018-03-13 08:00:00	MSFT	Stock	96.69	97.09	96.55	97.0	42741.0
2018-03-13 09:00:00	MSFT	Stock	96.98	97.24	96.64	96.79	2505533.0
2018-03-13 10:00:00	MSFT	Stock	96.79	96.88	96.02	96.14	4681235.0
2018-03-13 11:00:00	MSFT	Stock	96.14	96.16	95.15	95.226	4651179.0
2018-03-13 12:00:00	MSFT	Stock	95.22	95.29	94.57	95.075	2998163.0
2018-03-13 13:00:00	MSFT	Stock	95.075	95.19	94.75	94.775	2732574.0
2018-03-13 14:00:00	MSFT	Stock	94.77	94.95	94.406	94.62	2752599.0
2018-03-13 15:00:00	MSFT	Stock	94.62	94.77	93.97	94.42	8167933.0
2018-03-13 16:00:00	MSFT	Stock	94.41	94.58	94.26	94.29	2926231.0
2018-03-13 17:00:00	MSFT	Stock	94.29	94.4	94.05	94.1	16960.0
2018-03-13 18:00:00	MSFT	Stock	94.06	94.23	94.05	94.1	10859.0
2018-03-13 19:00:00	MSFT	Stock	94.37	94.37	94.25	94.25	3317.0
2018-03-13 04:00:00	NVDA	Stock	6.2673	6.2673	6.2528	6.2528	9680.0
2018-03-13 06:00:00	NVDA	Stock	6.2668	6.273	6.2662	6.2725	30000.0
2018-03-13 07:00:00	NVDA	Stock	6.2812	6.288	6.2575	6.26	994400.0
2018-03-13 08:00:00	NVDA	Stock	6.275	6.2918	6.2542	6.2773	2765000.0
2018-03-13 09:00:00	NVDA	Stock	6.2773	6.3625	6.2665	6.3201	111083560.0
2018-03-13 10:00:00	NVDA	Stock	6.319	6.3488	6.2632	6.2795	106469000.0
2018-03-13 11:00:00	NVDA	Stock	6.2822	6.2825	6.2048	6.2345	109599080.0
2018-03-13 12:00:00	NVDA	Stock	6.2373	6.2572	6.1755	6.2456	69039960.0
2018-03-13 13:00:00	NVDA	Stock	6.2465	6.28	6.227	6.2338	47092640.0
2018-03-13 14:00:00	NVDA	Stock	6.2323	6.2422	6.1822	6.2072	53895360.0
2018-03-13 15:00:00	NVDA	Stock	6.207	6.2178	6.151	6.1928	101601320.0
2018-03-13 16:00:00	NVDA	Stock	6.1928	6.196	6.185	6.1892	2350160.0
2018-03-13 17:00:00	NVDA	Stock	6.1888	6.1923	6.1528	6.1618	958640.0
2018-03-13 18:00:00	NVDA	Stock	6.1625	6.175	6.15	6.175	446240.0
2018-03-13 19:00:00	NVDA	Stock	6.1702	6.175	6.1638	6.175	160400.0
2018-03-13 04:00:00	AMZN	Stock	80.0005	80.153	80.0005	80.153	6020.0
2018-03-13 06:00:00	AMZN	Stock	80.258	80.35	80.25	80.35	27220.0
2018-03-13 07:00:00	AMZN	Stock	80.498	80.525	80.3585	80.414	370100.0
2018-03-13 08:00:00	AMZN	Stock	80.435	80.688	80.1	80.59	1286120.0

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

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