PREVIEW / stock_1hour / 2017-10-20

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-10-20.parquet
  size:    1.1 MB
  rows:    49,522
  symbols: 2,948

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-10-20 04:00:00	AAPL	Stock	39.05	39.1875	39.05	39.15	6832.0
2017-10-20 05:00:00	AAPL	Stock	39.1625	39.1625	39.125	39.125	6488.0
2017-10-20 06:00:00	AAPL	Stock	39.175	39.185	39.15	39.1525	18832.0
2017-10-20 07:00:00	AAPL	Stock	39.175	39.1875	39.0775	39.1375	158900.0
2017-10-20 08:00:00	AAPL	Stock	39.175	39.175	39.0875	39.15	333612.0
2017-10-20 09:00:00	AAPL	Stock	39.15	39.3	39.1325	39.2075	14842320.0
2017-10-20 10:00:00	AAPL	Stock	39.21	39.4375	39.205	39.33	15251996.0
2017-10-20 11:00:00	AAPL	Stock	39.33	39.38	39.1775	39.369	11492600.0
2017-10-20 12:00:00	AAPL	Stock	39.3675	39.375	39.2975	39.36	5431940.0
2017-10-20 13:00:00	AAPL	Stock	39.355	39.3675	39.2925	39.3	4021560.0
2017-10-20 14:00:00	AAPL	Stock	39.3	39.3125	39.1875	39.2	6934432.0
2017-10-20 15:00:00	AAPL	Stock	39.2	39.2175	38.99	39.0625	16517804.0
2017-10-20 16:00:00	AAPL	Stock	39.055	39.065	39.0275	39.05	12687192.0
2017-10-20 17:00:00	AAPL	Stock	39.0525	39.0725	39.0325	39.0375	82820.0
2017-10-20 18:00:00	AAPL	Stock	39.06	39.06	39.04	39.06	22928.0
2017-10-20 19:00:00	AAPL	Stock	39.0575	39.0625	39.045	39.06	28520.0
2017-10-20 07:00:00	MSFT	Stock	78.06	78.15	78.06	78.15	893.0
2017-10-20 08:00:00	MSFT	Stock	78.15	78.36	78.11	78.36	4297.0
2017-10-20 09:00:00	MSFT	Stock	78.25	78.52	78.21	78.51	3266360.0
2017-10-20 10:00:00	MSFT	Stock	78.505	78.57	78.315	78.395	2080575.0
2017-10-20 11:00:00	MSFT	Stock	78.4	78.76	78.395	78.72	1848301.0
2017-10-20 12:00:00	MSFT	Stock	78.73	78.9	78.71	78.9	1499195.0
2017-10-20 13:00:00	MSFT	Stock	78.9	78.93	78.78	78.91	1429061.0
2017-10-20 14:00:00	MSFT	Stock	78.905	78.97	78.77	78.815	1377605.0
2017-10-20 15:00:00	MSFT	Stock	78.81	78.84	78.68	78.8	3679938.0
2017-10-20 16:00:00	MSFT	Stock	78.81	78.82	78.75	78.82	5845433.0
2017-10-20 17:00:00	MSFT	Stock	78.82	78.82	78.75	78.76	10707.0
2017-10-20 18:00:00	MSFT	Stock	78.81	78.81	78.8	78.8	1884.0
2017-10-20 19:00:00	MSFT	Stock	78.8	78.81	78.77	78.81	1463.0
2017-10-20 04:00:00	NVDA	Stock	4.95	4.9725	4.95	4.9705	290640.0
2017-10-20 05:00:00	NVDA	Stock	4.9698	4.9775	4.9675	4.9775	343000.0
2017-10-20 06:00:00	NVDA	Stock	4.9773	4.9875	4.9702	4.9762	347760.0
2017-10-20 07:00:00	NVDA	Stock	4.9762	4.98	4.97	4.975	588360.0
2017-10-20 08:00:00	NVDA	Stock	4.9756	4.98	4.9635	4.9743	2451600.0
2017-10-20 09:00:00	NVDA	Stock	4.97	4.9898	4.9378	4.9556	96207000.0
2017-10-20 10:00:00	NVDA	Stock	4.9548	4.9693	4.9265	4.9275	68396000.0
2017-10-20 11:00:00	NVDA	Stock	4.9278	4.9545	4.9255	4.9458	48707240.0
2017-10-20 12:00:00	NVDA	Stock	4.9457	4.9722	4.9453	4.962	43242440.0
2017-10-20 13:00:00	NVDA	Stock	4.9625	4.9663	4.9438	4.945	24314200.0
2017-10-20 14:00:00	NVDA	Stock	4.945	4.955	4.935	4.9365	30481600.0
2017-10-20 15:00:00	NVDA	Stock	4.937	4.9414	4.9135	4.9215	67792240.0
2017-10-20 16:00:00	NVDA	Stock	4.9225	4.9225	4.9	4.9	21966960.0
2017-10-20 17:00:00	NVDA	Stock	4.9	4.9072	4.8923	4.9058	1262440.0
2017-10-20 18:00:00	NVDA	Stock	4.906	4.918	4.906	4.9163	461640.0
2017-10-20 19:00:00	NVDA	Stock	4.9163	4.9178	4.9075	4.9075	535120.0
2017-10-20 06:00:00	AMZN	Stock	49.5875	49.5875	49.5875	49.5875	2000.0
2017-10-20 07:00:00	AMZN	Stock	49.669	49.7145	49.631	49.7125	85200.0
2017-10-20 08:00:00	AMZN	Stock	49.6775	49.7495	49.625	49.65	253020.0
2017-10-20 09:00:00	AMZN	Stock	49.65	49.731	49.477	49.6315	7825540.0
2017-10-20 10:00:00	AMZN	Stock	49.6448	49.6905	49.4065	49.4118	3870500.0

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

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