PREVIEW / stock_1hour / 2014-10-09

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-10-09.parquet
  size:    1.0 MB
  rows:    48,812
  symbols: 3,545

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
2014-10-09 04:00:00	AAPL	Stock	25.235	25.2825	25.225	25.2625	24956.0
2014-10-09 05:00:00	AAPL	Stock	25.23	25.2375	25.21	25.225	14200.0
2014-10-09 06:00:00	AAPL	Stock	25.255	25.3775	25.2375	25.3025	147256.0
2014-10-09 07:00:00	AAPL	Stock	25.355	25.3575	25.13	25.1675	538956.0
2014-10-09 08:00:00	AAPL	Stock	25.175	25.47	25.125	25.425	5096640.0
2014-10-09 09:00:00	AAPL	Stock	25.425	25.4925	25.32	25.44	42732548.0
2014-10-09 10:00:00	AAPL	Stock	25.4412	25.47	25.3275	25.4425	38237160.0
2014-10-09 11:00:00	AAPL	Stock	25.44	25.595	25.38	25.4278	52930824.0
2014-10-09 12:00:00	AAPL	Stock	25.4225	25.47	25.24	25.3565	42276980.0
2014-10-09 13:00:00	AAPL	Stock	25.3575	25.36	25.1525	25.2025	31848904.0
2014-10-09 14:00:00	AAPL	Stock	25.2025	25.3275	25.165	25.265	25577296.0
2014-10-09 15:00:00	AAPL	Stock	25.2642	25.4025	25.2525	25.255	40226428.0
2014-10-09 16:00:00	AAPL	Stock	25.255	25.468	25.13	25.1725	8781284.0
2014-10-09 17:00:00	AAPL	Stock	25.255	25.3588	25.13	25.195	1262636.0
2014-10-09 18:00:00	AAPL	Stock	25.1825	25.22	25.1625	25.1975	130428.0
2014-10-09 19:00:00	AAPL	Stock	25.1925	25.255	25.185	25.1875	180084.0
2014-10-09 04:00:00	MSFT	Stock	46.84	46.84	46.84	46.84	200.0
2014-10-09 06:00:00	MSFT	Stock	46.8	46.8	46.8	46.8	600.0
2014-10-09 07:00:00	MSFT	Stock	46.63	46.63	46.61	46.61	3124.0
2014-10-09 08:00:00	MSFT	Stock	46.6	46.65	46.57	46.57	7409.0
2014-10-09 09:00:00	MSFT	Stock	46.57	46.8	46.49	46.59	2848565.0
2014-10-09 10:00:00	MSFT	Stock	46.595	46.66	46.37	46.6	3116752.0
2014-10-09 11:00:00	MSFT	Stock	46.6	46.79	46.225	46.31	3492647.0
2014-10-09 12:00:00	MSFT	Stock	46.3	46.35	45.97	46.045	3926236.0
2014-10-09 13:00:00	MSFT	Stock	46.05	46.06	45.78	45.86	3758872.0
2014-10-09 14:00:00	MSFT	Stock	45.86	46.025	45.74	45.9	4890018.0
2014-10-09 15:00:00	MSFT	Stock	45.91	46.12	45.82	45.85	7652118.0
2014-10-09 16:00:00	MSFT	Stock	45.85	46.78	45.81	45.81	2134265.0
2014-10-09 17:00:00	MSFT	Stock	45.85	46.143	45.75	45.8	422698.0
2014-10-09 18:00:00	MSFT	Stock	45.8	45.8	45.76	45.8	1600.0
2014-10-09 19:00:00	MSFT	Stock	45.8	45.8	45.76	45.8	2500.0
2014-10-09 09:00:00	NVDA	Stock	0.454	0.4549	0.4495	0.4508	22308040.0
2014-10-09 10:00:00	NVDA	Stock	0.451	0.4535	0.4506	0.4535	25633640.0
2014-10-09 11:00:00	NVDA	Stock	0.4535	0.4545	0.448	0.4492	26027200.0
2014-10-09 12:00:00	NVDA	Stock	0.449	0.4495	0.447	0.449	34465800.0
2014-10-09 13:00:00	NVDA	Stock	0.449	0.4502	0.4465	0.4475	23257520.0
2014-10-09 14:00:00	NVDA	Stock	0.4472	0.4478	0.445	0.4455	27173640.0
2014-10-09 15:00:00	NVDA	Stock	0.4452	0.4498	0.444	0.448	126832720.0
2014-10-09 16:00:00	NVDA	Stock	0.4478	0.448	0.4476	0.4477	1660560.0
2014-10-09 17:00:00	NVDA	Stock	0.4452	0.4494	0.4452	0.4494	1171960.0
2014-10-09 19:00:00	NVDA	Stock	0.4442	0.4442	0.4425	0.4425	42400.0
2014-10-09 08:00:00	AMZN	Stock	16.135	16.135	16.0255	16.075	61920.0
2014-10-09 09:00:00	AMZN	Stock	16.076	16.1136	15.9625	16.0041	6487060.0
2014-10-09 10:00:00	AMZN	Stock	16.011	16.1	15.981	16.0725	6302240.0
2014-10-09 11:00:00	AMZN	Stock	16.0695	16.1095	15.926	15.9705	7716020.0
2014-10-09 12:00:00	AMZN	Stock	15.9625	15.982	15.8171	15.901	6830900.0
2014-10-09 13:00:00	AMZN	Stock	15.8985	15.9545	15.8	15.865	5782740.0
2014-10-09 14:00:00	AMZN	Stock	15.8585	15.866	15.7565	15.8075	10148840.0
2014-10-09 15:00:00	AMZN	Stock	15.801	15.8335	15.726	15.7685	17277700.0
2014-10-09 16:00:00	AMZN	Stock	15.7685	15.8931	15.741	15.8931	2642720.0

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

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