PREVIEW / stock_1hour / 2016-11-09

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-11-09.parquet
  size:    1.1 MB
  rows:    50,597
  symbols: 3,179

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
2016-11-09 04:00:00	AAPL	Stock	26.9975	27.3175	26.925	27.275	531892.0
2016-11-09 05:00:00	AAPL	Stock	27.25	27.315	27.1875	27.2275	221476.0
2016-11-09 06:00:00	AAPL	Stock	27.25	27.25	27.0775	27.14	465512.0
2016-11-09 07:00:00	AAPL	Stock	27.1625	27.55	27.125	27.55	1120068.0
2016-11-09 08:00:00	AAPL	Stock	27.545	27.675	27.075	27.55	3196840.0
2016-11-09 09:00:00	AAPL	Stock	27.55	27.8125	27.0125	27.3125	60445548.0
2016-11-09 10:00:00	AAPL	Stock	27.3125	27.3575	27.11	27.2575	33830720.0
2016-11-09 11:00:00	AAPL	Stock	27.255	27.5475	27.21	27.4475	29646940.0
2016-11-09 12:00:00	AAPL	Stock	27.45	27.51	27.285	27.4988	16092116.0
2016-11-09 13:00:00	AAPL	Stock	27.4992	27.54	27.2975	27.4012	13933504.0
2016-11-09 14:00:00	AAPL	Stock	27.4025	27.745	27.3675	27.65	18971112.0
2016-11-09 15:00:00	AAPL	Stock	27.65	27.83	27.6175	27.72	25403608.0
2016-11-09 16:00:00	AAPL	Stock	27.72	27.785	27.447	27.72	11644044.0
2016-11-09 17:00:00	AAPL	Stock	27.7725	27.7875	27.765	27.7675	37720.0
2016-11-09 18:00:00	AAPL	Stock	27.7675	27.7675	27.72	27.75	26840.0
2016-11-09 19:00:00	AAPL	Stock	27.7675	27.775	27.735	27.75	21564.0
2016-11-09 04:00:00	MSFT	Stock	59.5	59.5	59.0	59.05	3896.0
2016-11-09 05:00:00	MSFT	Stock	59.15	59.29	59.15	59.28	3975.0
2016-11-09 06:00:00	MSFT	Stock	59.2	59.2	58.8	59.09	40691.0
2016-11-09 07:00:00	MSFT	Stock	59.17	60.3	59.17	60.0	118243.0
2016-11-09 08:00:00	MSFT	Stock	60.0	60.29	58.51	59.64	191954.0
2016-11-09 09:00:00	MSFT	Stock	59.63	60.59	59.2	60.068	10169045.0
2016-11-09 10:00:00	MSFT	Stock	60.07	60.11	59.52	59.81	6717522.0
2016-11-09 11:00:00	MSFT	Stock	59.81	60.44	59.69	60.295	6519529.0
2016-11-09 12:00:00	MSFT	Stock	60.3	60.51	60.12	60.485	4138314.0
2016-11-09 13:00:00	MSFT	Stock	60.48	60.495	59.805	59.83	3324918.0
2016-11-09 14:00:00	MSFT	Stock	59.83	60.09	59.76	59.795	3975063.0
2016-11-09 15:00:00	MSFT	Stock	59.79	60.19	59.79	60.17	7017805.0
2016-11-09 16:00:00	MSFT	Stock	60.17	60.24	60.07	60.13	4961392.0
2016-11-09 17:00:00	MSFT	Stock	60.13	60.19	60.05	60.19	665.0
2016-11-09 18:00:00	MSFT	Stock	60.06	60.06	60.06	60.06	298.0
2016-11-09 19:00:00	MSFT	Stock	60.15	60.15	60.15	60.15	200.0
2016-11-09 04:00:00	NVDA	Stock	1.6745	1.725	1.6678	1.72	417000.0
2016-11-09 05:00:00	NVDA	Stock	1.7125	1.725	1.7125	1.725	315600.0
2016-11-09 06:00:00	NVDA	Stock	1.725	1.725	1.7078	1.7078	347520.0
2016-11-09 07:00:00	NVDA	Stock	1.7138	1.7642	1.7138	1.7525	503960.0
2016-11-09 08:00:00	NVDA	Stock	1.7525	1.7625	1.7078	1.7495	2364960.0
2016-11-09 09:00:00	NVDA	Stock	1.7475	1.767	1.718	1.7473	95221840.0
2016-11-09 10:00:00	NVDA	Stock	1.7472	1.7535	1.72	1.745	83795440.0
2016-11-09 11:00:00	NVDA	Stock	1.745	1.7725	1.7413	1.7675	54618760.0
2016-11-09 12:00:00	NVDA	Stock	1.7678	1.771	1.749	1.7628	34330280.0
2016-11-09 13:00:00	NVDA	Stock	1.7628	1.7645	1.7398	1.7402	35531680.0
2016-11-09 14:00:00	NVDA	Stock	1.7402	1.753	1.739	1.7428	32652720.0
2016-11-09 15:00:00	NVDA	Stock	1.743	1.7545	1.742	1.7488	71742440.0
2016-11-09 16:00:00	NVDA	Stock	1.7488	1.7525	1.7485	1.7525	12377240.0
2016-11-09 17:00:00	NVDA	Stock	1.7525	1.7622	1.7503	1.7622	263040.0
2016-11-09 18:00:00	NVDA	Stock	1.7588	1.7613	1.7542	1.7613	78440.0
2016-11-09 19:00:00	NVDA	Stock	1.761	1.7622	1.7575	1.7582	57800.0
2016-11-09 04:00:00	AMZN	Stock	38.3	38.721	38.2	38.7	254240.0
2016-11-09 05:00:00	AMZN	Stock	38.59	38.6795	38.5	38.575	146060.0

> showing 50 of 50,597 rows — these rows as CSV

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