PREVIEW / stock_1hour / 2017-08-29

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-08-29.parquet
  size:    1.0 MB
  rows:    47,733
  symbols: 2,980

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-29 04:00:00	AAPL	Stock	40.05	40.05	39.8875	39.9125	28216.0
2017-08-29 05:00:00	AAPL	Stock	39.9025	40.0375	39.875	40.025	44288.0
2017-08-29 06:00:00	AAPL	Stock	40.0025	40.09	39.9775	40.09	76632.0
2017-08-29 07:00:00	AAPL	Stock	40.095	40.1	40.0025	40.0375	170220.0
2017-08-29 08:00:00	AAPL	Stock	40.0725	40.0975	39.975	40.045	533804.0
2017-08-29 09:00:00	AAPL	Stock	40.03	40.3625	39.9775	40.3625	16391084.0
2017-08-29 10:00:00	AAPL	Stock	40.36	40.615	40.245	40.5525	20476288.0
2017-08-29 11:00:00	AAPL	Stock	40.5488	40.74	40.5475	40.7125	17071044.0
2017-08-29 12:00:00	AAPL	Stock	40.71	40.72	40.5525	40.5775	10864080.0
2017-08-29 13:00:00	AAPL	Stock	40.5762	40.6625	40.54	40.5925	8598404.0
2017-08-29 14:00:00	AAPL	Stock	40.59	40.7125	40.59	40.7	7446980.0
2017-08-29 15:00:00	AAPL	Stock	40.699	40.78	40.6575	40.73	18857844.0
2017-08-29 16:00:00	AAPL	Stock	40.7425	40.78	40.72	40.7625	7072180.0
2017-08-29 17:00:00	AAPL	Stock	40.7725	40.7725	40.7525	40.7725	68248.0
2017-08-29 18:00:00	AAPL	Stock	40.7725	40.8025	40.755	40.8025	132376.0
2017-08-29 19:00:00	AAPL	Stock	40.805	40.825	40.805	40.825	79252.0
2017-08-29 05:00:00	MSFT	Stock	72.21	72.21	72.21	72.21	100.0
2017-08-29 07:00:00	MSFT	Stock	72.28	72.45	72.28	72.45	533.0
2017-08-29 08:00:00	MSFT	Stock	72.43	72.43	72.2	72.2	6390.0
2017-08-29 09:00:00	MSFT	Stock	72.21	72.696	72.05	72.65	1375651.0
2017-08-29 10:00:00	MSFT	Stock	72.645	72.81	72.48	72.71	1469938.0
2017-08-29 11:00:00	MSFT	Stock	72.713	72.94	72.68	72.87	1201638.0
2017-08-29 12:00:00	MSFT	Stock	72.87	73.0	72.86	72.91	654893.0
2017-08-29 13:00:00	MSFT	Stock	72.91	73.02	72.86	72.98	1026053.0
2017-08-29 14:00:00	MSFT	Stock	72.97	73.15	72.96	73.07	878464.0
2017-08-29 15:00:00	MSFT	Stock	73.08	73.16	73.01	73.06	2184589.0
2017-08-29 16:00:00	MSFT	Stock	73.05	73.11	73.05	73.1	1788363.0
2017-08-29 17:00:00	MSFT	Stock	73.05	73.05	73.05	73.05	100.0
2017-08-29 18:00:00	MSFT	Stock	73.05	73.1	73.05	73.1	1690.0
2017-08-29 19:00:00	MSFT	Stock	73.11	73.11	73.11	73.11	3200.0
2017-08-29 04:00:00	NVDA	Stock	4.075	4.075	4.0328	4.045	231360.0
2017-08-29 05:00:00	NVDA	Stock	4.0422	4.0498	4.0353	4.0498	100040.0
2017-08-29 06:00:00	NVDA	Stock	4.05	4.0625	4.05	4.0505	337240.0
2017-08-29 07:00:00	NVDA	Stock	4.063	4.0737	4.063	4.0712	770280.0
2017-08-29 08:00:00	NVDA	Stock	4.069	4.0737	4.0438	4.0625	1344640.0
2017-08-29 09:00:00	NVDA	Stock	4.0645	4.1002	4.0513	4.0878	62014800.0
2017-08-29 10:00:00	NVDA	Stock	4.0875	4.1325	4.0775	4.1242	64208840.0
2017-08-29 11:00:00	NVDA	Stock	4.124	4.1395	4.115	4.1182	33619760.0
2017-08-29 12:00:00	NVDA	Stock	4.1192	4.127	4.1092	4.122	24796440.0
2017-08-29 13:00:00	NVDA	Stock	4.123	4.1313	4.1105	4.1218	31312400.0
2017-08-29 14:00:00	NVDA	Stock	4.1219	4.1382	4.119	4.135	27321560.0
2017-08-29 15:00:00	NVDA	Stock	4.1343	4.136	4.109	4.1175	54613360.0
2017-08-29 16:00:00	NVDA	Stock	4.116	4.12	4.1125	4.1175	2613560.0
2017-08-29 17:00:00	NVDA	Stock	4.1175	4.1175	4.1162	4.1162	166160.0
2017-08-29 18:00:00	NVDA	Stock	4.1175	4.125	4.1162	4.125	269640.0
2017-08-29 19:00:00	NVDA	Stock	4.125	4.1313	4.123	4.1313	476120.0
2017-08-29 04:00:00	AMZN	Stock	46.75	46.7585	46.7305	46.7305	17440.0
2017-08-29 05:00:00	AMZN	Stock	46.654	46.7765	46.61	46.7765	14580.0
2017-08-29 06:00:00	AMZN	Stock	46.779	46.779	46.779	46.779	2600.0
2017-08-29 07:00:00	AMZN	Stock	46.9295	46.9585	46.925	46.93	20020.0

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

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