PREVIEW / stock_1hour / 2018-02-14

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-02-14.parquet
  size:    1.1 MB
  rows:    49,962
  symbols: 2,892

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-02-14 04:00:00	AAPL	Stock	41.25	41.25	41.225	41.235	7436.0
2018-02-14 05:00:00	AAPL	Stock	41.2475	41.3075	41.225	41.225	6408.0
2018-02-14 06:00:00	AAPL	Stock	41.2475	41.27	41.2	41.2425	47712.0
2018-02-14 07:00:00	AAPL	Stock	41.2175	41.325	41.1875	41.215	311192.0
2018-02-14 08:00:00	AAPL	Stock	41.225	41.315	40.4475	40.75	1613388.0
2018-02-14 09:00:00	AAPL	Stock	40.7525	41.0775	40.6875	40.9112	22644896.0
2018-02-14 10:00:00	AAPL	Stock	40.9125	41.3875	40.84	41.3398	25975884.0
2018-02-14 11:00:00	AAPL	Stock	41.3352	41.4525	41.235	41.298	17233536.0
2018-02-14 12:00:00	AAPL	Stock	41.3002	41.4938	41.2375	41.4738	11695340.0
2018-02-14 13:00:00	AAPL	Stock	41.475	41.55	41.4112	41.52	12654216.0
2018-02-14 14:00:00	AAPL	Stock	41.5195	41.825	41.5175	41.805	16127620.0
2018-02-14 15:00:00	AAPL	Stock	41.8025	41.885	41.755	41.84	22750652.0
2018-02-14 16:00:00	AAPL	Stock	41.8425	41.97	41.8	41.955	8464112.0
2018-02-14 17:00:00	AAPL	Stock	41.9675	42.115	41.8425	42.1075	959892.0
2018-02-14 18:00:00	AAPL	Stock	42.105	42.22	42.0775	42.1875	183684.0
2018-02-14 19:00:00	AAPL	Stock	42.2	42.2325	42.135	42.2325	222408.0
2018-02-14 04:00:00	MSFT	Stock	90.2	90.45	90.2	90.45	5300.0
2018-02-14 05:00:00	MSFT	Stock	90.18	90.18	90.0	90.0	700.0
2018-02-14 06:00:00	MSFT	Stock	90.0	90.12	90.0	90.05	3859.0
2018-02-14 07:00:00	MSFT	Stock	90.0	90.08	89.82	89.95	11790.0
2018-02-14 08:00:00	MSFT	Stock	89.9	90.0	87.9	88.5	161255.0
2018-02-14 09:00:00	MSFT	Stock	88.48	89.25	88.25	88.6	4809753.0
2018-02-14 10:00:00	MSFT	Stock	88.61	90.0	88.54	89.68	5170607.0
2018-02-14 11:00:00	MSFT	Stock	89.67	90.01	89.56	89.65	3100531.0
2018-02-14 12:00:00	MSFT	Stock	89.67	90.13	89.3	90.05	2535918.0
2018-02-14 13:00:00	MSFT	Stock	90.06	90.33	89.97	90.09	2715283.0
2018-02-14 14:00:00	MSFT	Stock	90.084	90.44	90.08	90.37	2972235.0
2018-02-14 15:00:00	MSFT	Stock	90.38	90.99	90.375	90.83	7478199.0
2018-02-14 16:00:00	MSFT	Stock	90.81	91.0	90.52	90.83	3160484.0
2018-02-14 17:00:00	MSFT	Stock	90.81	90.98	90.7	90.7	29100.0
2018-02-14 19:00:00	MSFT	Stock	90.72	90.8	90.72	90.8	850.0
2018-02-14 04:00:00	NVDA	Stock	5.8625	5.8625	5.8625	5.8625	4000.0
2018-02-14 05:00:00	NVDA	Stock	5.861	5.861	5.8505	5.8505	34480.0
2018-02-14 06:00:00	NVDA	Stock	5.86	5.8675	5.86	5.8648	35600.0
2018-02-14 07:00:00	NVDA	Stock	5.8578	5.8712	5.8468	5.85	637000.0
2018-02-14 08:00:00	NVDA	Stock	5.8548	5.8722	5.75	5.7792	5208760.0
2018-02-14 09:00:00	NVDA	Stock	5.7788	5.9125	5.7602	5.877	106881920.0
2018-02-14 10:00:00	NVDA	Stock	5.8758	5.9585	5.8752	5.9379	124625360.0
2018-02-14 11:00:00	NVDA	Stock	5.941	5.9667	5.9155	5.9556	71318560.0
2018-02-14 12:00:00	NVDA	Stock	5.9563	6.015	5.956	6.013	84076040.0
2018-02-14 13:00:00	NVDA	Stock	6.0153	6.051	6.0095	6.0288	71129280.0
2018-02-14 14:00:00	NVDA	Stock	6.0292	6.0648	6.01	6.013	61570400.0
2018-02-14 15:00:00	NVDA	Stock	6.013	6.05	6.013	6.0355	73171880.0
2018-02-14 16:00:00	NVDA	Stock	6.0355	6.0392	6.025	6.03	15760920.0
2018-02-14 17:00:00	NVDA	Stock	6.0325	6.037	6.03	6.03	804240.0
2018-02-14 18:00:00	NVDA	Stock	6.03	6.03	6.0263	6.0263	353320.0
2018-02-14 19:00:00	NVDA	Stock	6.0312	6.0362	6.0312	6.0338	439040.0
2018-02-14 05:00:00	AMZN	Stock	71.0955	71.0955	71.0955	71.0955	9060.0
2018-02-14 06:00:00	AMZN	Stock	71.15	71.2365	71.1495	71.2	30220.0
2018-02-14 07:00:00	AMZN	Stock	71.2195	71.2885	71.1105	71.15	341460.0

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

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