PREVIEW / stock_1hour / 2017-08-18

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-08-18.parquet
  size:    1.0 MB
  rows:    47,717
  symbols: 2,961

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
2017-08-18 04:00:00	AAPL	Stock	39.45	39.5	39.45	39.5	9472.0
2017-08-18 05:00:00	AAPL	Stock	39.5	39.525	39.5	39.525	3888.0
2017-08-18 06:00:00	AAPL	Stock	39.5625	39.75	39.5625	39.7	66548.0
2017-08-18 07:00:00	AAPL	Stock	39.7075	39.71	39.6	39.6875	84852.0
2017-08-18 08:00:00	AAPL	Stock	39.6975	39.72	39.6125	39.675	374832.0
2017-08-18 09:00:00	AAPL	Stock	39.6625	39.675	39.18	39.2275	20904368.0
2017-08-18 10:00:00	AAPL	Stock	39.2275	39.605	39.2	39.54	16498964.0
2017-08-18 11:00:00	AAPL	Stock	39.54	39.875	39.4075	39.8028	15945812.0
2017-08-18 12:00:00	AAPL	Stock	39.8013	39.855	39.685	39.7875	9391052.0
2017-08-18 13:00:00	AAPL	Stock	39.79	39.8155	39.5475	39.55	8129592.0
2017-08-18 14:00:00	AAPL	Stock	39.5475	39.655	39.5025	39.5188	5973700.0
2017-08-18 15:00:00	AAPL	Stock	39.5225	39.5825	39.355	39.3775	15921808.0
2017-08-18 16:00:00	AAPL	Stock	39.375	39.3825	39.3675	39.3675	4397088.0
2017-08-18 17:00:00	AAPL	Stock	39.38	39.38	39.3275	39.3275	123668.0
2017-08-18 18:00:00	AAPL	Stock	39.3275	39.3475	39.305	39.3225	41924.0
2017-08-18 19:00:00	AAPL	Stock	39.3225	39.3475	39.3125	39.325	53848.0
2017-08-18 06:00:00	MSFT	Stock	72.49	72.49	72.49	72.49	196.0
2017-08-18 07:00:00	MSFT	Stock	72.49	72.65	72.49	72.65	800.0
2017-08-18 08:00:00	MSFT	Stock	72.6	72.72	72.6	72.67	2916.0
2017-08-18 09:00:00	MSFT	Stock	72.6	72.61	71.94	71.94	4298320.0
2017-08-18 10:00:00	MSFT	Stock	71.95	72.39	71.93	72.275	1921480.0
2017-08-18 11:00:00	MSFT	Stock	72.27	72.55	72.01	72.535	1863200.0
2017-08-18 12:00:00	MSFT	Stock	72.54	72.83	72.415	72.73	1483758.0
2017-08-18 13:00:00	MSFT	Stock	72.72	72.84	72.48	72.49	1147880.0
2017-08-18 14:00:00	MSFT	Stock	72.48	72.74	72.48	72.64	1185107.0
2017-08-18 15:00:00	MSFT	Stock	72.645	72.78	72.43	72.5	3699263.0
2017-08-18 16:00:00	MSFT	Stock	72.49	72.51	72.435	72.49	1770201.0
2017-08-18 17:00:00	MSFT	Stock	72.47	72.47	72.47	72.47	1100.0
2017-08-18 18:00:00	MSFT	Stock	72.48	72.48	72.48	72.48	100.0
2017-08-18 19:00:00	MSFT	Stock	72.41	72.41	72.41	72.41	300.0
2017-08-18 04:00:00	NVDA	Stock	4.0413	4.0413	4.0385	4.0388	78640.0
2017-08-18 05:00:00	NVDA	Stock	4.0362	4.0375	4.0325	4.0375	105640.0
2017-08-18 06:00:00	NVDA	Stock	4.0288	4.075	4.0288	4.075	198080.0
2017-08-18 07:00:00	NVDA	Stock	4.075	4.0948	4.065	4.0688	461920.0
2017-08-18 08:00:00	NVDA	Stock	4.0625	4.075	4.0625	4.0725	2460720.0
2017-08-18 09:00:00	NVDA	Stock	4.069	4.0925	3.991	3.9978	111113120.0
2017-08-18 10:00:00	NVDA	Stock	3.9972	4.0722	3.9938	4.065	111011040.0
2017-08-18 11:00:00	NVDA	Stock	4.0658	4.109	4.0455	4.0987	93185200.0
2017-08-18 12:00:00	NVDA	Stock	4.0989	4.1008	4.0792	4.0913	61606400.0
2017-08-18 13:00:00	NVDA	Stock	4.0919	4.0943	4.0432	4.0441	59751160.0
2017-08-18 14:00:00	NVDA	Stock	4.0432	4.0628	4.0432	4.05	45765400.0
2017-08-18 15:00:00	NVDA	Stock	4.0495	4.0625	4.035	4.0395	76187400.0
2017-08-18 16:00:00	NVDA	Stock	4.0395	4.0562	4.0375	4.039	4931680.0
2017-08-18 17:00:00	NVDA	Stock	4.04	4.04	4.0255	4.0262	1067400.0
2017-08-18 18:00:00	NVDA	Stock	4.0262	4.0375	4.0262	4.0375	365400.0
2017-08-18 19:00:00	NVDA	Stock	4.0375	4.0422	4.0282	4.0288	266560.0
2017-08-18 05:00:00	AMZN	Stock	48.05	48.07	48.05	48.07	4880.0
2017-08-18 06:00:00	AMZN	Stock	48.175	48.175	48.175	48.175	4560.0
2017-08-18 07:00:00	AMZN	Stock	48.15	48.225	48.1	48.225	67120.0
2017-08-18 08:00:00	AMZN	Stock	48.175	48.222	48.12	48.144	107580.0

> showing 50 of 47,717 rows — these rows as CSV

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