PREVIEW / stock_1hour / 2016-04-19

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-04-19.parquet
  size:    1.0 MB
  rows:    48,424
  symbols: 3,328

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-04-19 04:00:00	AAPL	Stock	27.045	27.075	27.045	27.045	5636.0
2016-04-19 05:00:00	AAPL	Stock	27.0725	27.0825	27.0725	27.0825	9384.0
2016-04-19 06:00:00	AAPL	Stock	27.0925	27.095	27.01	27.01	44020.0
2016-04-19 07:00:00	AAPL	Stock	27.025	27.0325	26.985	27.025	139772.0
2016-04-19 08:00:00	AAPL	Stock	27.0125	27.0375	26.87	26.99	328520.0
2016-04-19 09:00:00	AAPL	Stock	26.9875	26.9975	26.6378	26.8025	21278412.0
2016-04-19 10:00:00	AAPL	Stock	26.8	26.92	26.735	26.7775	20367132.0
2016-04-19 11:00:00	AAPL	Stock	26.7775	26.8	26.6775	26.685	13042300.0
2016-04-19 12:00:00	AAPL	Stock	26.685	26.7165	26.5575	26.6975	14265184.0
2016-04-19 13:00:00	AAPL	Stock	26.695	26.7825	26.6688	26.7625	10901764.0
2016-04-19 14:00:00	AAPL	Stock	26.7648	26.81	26.72	26.7488	10367508.0
2016-04-19 15:00:00	AAPL	Stock	26.745	27.0	26.6728	26.7375	18760660.0
2016-04-19 16:00:00	AAPL	Stock	26.7275	26.765	26.6615	26.7075	9514104.0
2016-04-19 17:00:00	AAPL	Stock	26.7	26.73	26.7	26.71	80356.0
2016-04-19 18:00:00	AAPL	Stock	26.71	26.72	26.6625	26.6625	65084.0
2016-04-19 19:00:00	AAPL	Stock	26.675	26.6975	26.65	26.67	41520.0
2016-04-19 07:00:00	MSFT	Stock	56.74	56.79	56.7	56.79	16700.0
2016-04-19 08:00:00	MSFT	Stock	56.77	56.8	56.65	56.71	32048.0
2016-04-19 09:00:00	MSFT	Stock	56.75	56.78	55.68	56.01	5884385.0
2016-04-19 10:00:00	MSFT	Stock	56.01	56.28	56.0	56.255	4329331.0
2016-04-19 11:00:00	MSFT	Stock	56.25	56.39	56.0	56.005	2390410.0
2016-04-19 12:00:00	MSFT	Stock	56.01	56.27	56.0	56.245	2276989.0
2016-04-19 13:00:00	MSFT	Stock	56.25	56.385	56.2	56.385	1718903.0
2016-04-19 14:00:00	MSFT	Stock	56.385	56.5	56.29	56.335	2101385.0
2016-04-19 15:00:00	MSFT	Stock	56.339	56.4	56.205	56.4	4024905.0
2016-04-19 16:00:00	MSFT	Stock	56.39	56.44	55.74	55.91	4715987.0
2016-04-19 17:00:00	MSFT	Stock	55.9	55.95	55.88	55.95	17960.0
2016-04-19 18:00:00	MSFT	Stock	55.95	55.95	55.94	55.94	1600.0
2016-04-19 19:00:00	MSFT	Stock	55.94	55.96	55.91	55.91	12918.0
2016-04-19 08:00:00	NVDA	Stock	0.9262	0.9262	0.9262	0.9262	44000.0
2016-04-19 09:00:00	NVDA	Stock	0.9285	0.9295	0.9155	0.9175	17234120.0
2016-04-19 10:00:00	NVDA	Stock	0.9175	0.92	0.9148	0.916	30671600.0
2016-04-19 11:00:00	NVDA	Stock	0.9158	0.9172	0.9078	0.9085	34499000.0
2016-04-19 12:00:00	NVDA	Stock	0.9088	0.9098	0.902	0.9068	52459840.0
2016-04-19 13:00:00	NVDA	Stock	0.9068	0.9125	0.906	0.9124	28576200.0
2016-04-19 14:00:00	NVDA	Stock	0.9125	0.913	0.9078	0.9085	37795920.0
2016-04-19 15:00:00	NVDA	Stock	0.9085	0.91	0.9065	0.9078	74492440.0
2016-04-19 16:00:00	NVDA	Stock	0.9078	0.9078	0.9008	0.9025	4385240.0
2016-04-19 17:00:00	NVDA	Stock	0.9012	0.905	0.9005	0.905	214600.0
2016-04-19 18:00:00	NVDA	Stock	0.9078	0.9098	0.9075	0.9075	144000.0
2016-04-19 04:00:00	AMZN	Stock	31.825	31.85	31.8185	31.85	30680.0
2016-04-19 05:00:00	AMZN	Stock	31.875	31.95	31.875	31.95	6000.0
2016-04-19 06:00:00	AMZN	Stock	31.95	31.973	31.9095	31.9095	42900.0
2016-04-19 07:00:00	AMZN	Stock	31.9095	31.95	31.9095	31.9295	90660.0
2016-04-19 08:00:00	AMZN	Stock	31.93	31.945	31.7165	31.84	188500.0
2016-04-19 09:00:00	AMZN	Stock	31.845	31.9005	31.316	31.4015	17133900.0
2016-04-19 10:00:00	AMZN	Stock	31.43	31.6975	31.378	31.568	11689100.0
2016-04-19 11:00:00	AMZN	Stock	31.573	31.5915	31.295	31.327	6433140.0
2016-04-19 12:00:00	AMZN	Stock	31.3242	31.3415	31.04	31.2455	11126340.0
2016-04-19 13:00:00	AMZN	Stock	31.2475	31.393	31.1376	31.355	6225520.0

> showing 50 of 48,424 rows — these rows as CSV

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