PREVIEW / stock_1hour / 2015-10-02

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-10-02.parquet
  size:    1.0 MB
  rows:    48,332
  symbols: 3,431

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
2015-10-02 04:00:00	AAPL	Stock	27.4875	27.565	27.4875	27.51	23812.0
2015-10-02 05:00:00	AAPL	Stock	27.51	27.55	27.5	27.545	18192.0
2015-10-02 06:00:00	AAPL	Stock	27.555	27.6125	27.53	27.5925	81492.0
2015-10-02 07:00:00	AAPL	Stock	27.5825	27.5825	27.5125	27.5275	152296.0
2015-10-02 08:00:00	AAPL	Stock	27.54	27.595	27.0	27.0675	2001424.0
2015-10-02 09:00:00	AAPL	Stock	27.07	27.125	26.9175	27.0488	29725276.0
2015-10-02 10:00:00	AAPL	Stock	27.04	27.2225	26.8875	27.2175	31966332.0
2015-10-02 11:00:00	AAPL	Stock	27.215	27.3225	27.1225	27.26	28299800.0
2015-10-02 12:00:00	AAPL	Stock	27.2575	27.4925	27.255	27.45	23376760.0
2015-10-02 13:00:00	AAPL	Stock	27.4475	27.5425	27.365	27.39	19796792.0
2015-10-02 14:00:00	AAPL	Stock	27.39	27.625	27.385	27.485	22212836.0
2015-10-02 15:00:00	AAPL	Stock	27.485	27.7535	27.4825	27.57	49603088.0
2015-10-02 16:00:00	AAPL	Stock	27.595	27.595	27.5525	27.575	8175356.0
2015-10-02 17:00:00	AAPL	Stock	27.5775	27.595	27.5625	27.5825	619976.0
2015-10-02 18:00:00	AAPL	Stock	27.585	27.5975	27.58	27.59	71528.0
2015-10-02 19:00:00	AAPL	Stock	27.5875	27.6	27.5825	27.6	59232.0
2015-10-02 04:00:00	MSFT	Stock	44.83	44.83	44.83	44.83	500.0
2015-10-02 05:00:00	MSFT	Stock	44.89	45.04	44.85	45.0	4442.0
2015-10-02 06:00:00	MSFT	Stock	45.06	45.06	45.0	45.0	1400.0
2015-10-02 07:00:00	MSFT	Stock	44.95	44.98	44.85	44.95	15480.0
2015-10-02 08:00:00	MSFT	Stock	44.96	44.98	44.2	44.3	100181.0
2015-10-02 09:00:00	MSFT	Stock	44.3	44.35	43.92	44.28	4317160.0
2015-10-02 10:00:00	MSFT	Stock	44.29	44.42	44.05	44.39	4545782.0
2015-10-02 11:00:00	MSFT	Stock	44.39	44.53	44.3	44.47	3095553.0
2015-10-02 12:00:00	MSFT	Stock	44.48	45.09	44.42	44.98	5230436.0
2015-10-02 13:00:00	MSFT	Stock	44.985	45.22	44.92	45.03	4258315.0
2015-10-02 14:00:00	MSFT	Stock	45.025	45.14	44.94	44.945	3664690.0
2015-10-02 15:00:00	MSFT	Stock	44.945	45.57	44.92	45.57	10596219.0
2015-10-02 16:00:00	MSFT	Stock	45.57	45.57	44.876	45.54	3775564.0
2015-10-02 17:00:00	MSFT	Stock	45.5	45.5	45.47	45.5	1112.0
2015-10-02 18:00:00	MSFT	Stock	45.51	45.51	45.51	45.51	797.0
2015-10-02 19:00:00	MSFT	Stock	45.5	45.56	45.5	45.56	2552.0
2015-10-02 09:00:00	NVDA	Stock	0.5925	0.602	0.5925	0.5984	28562080.0
2015-10-02 10:00:00	NVDA	Stock	0.5983	0.6048	0.5948	0.6048	46201880.0
2015-10-02 11:00:00	NVDA	Stock	0.6048	0.6066	0.6013	0.606	38090840.0
2015-10-02 12:00:00	NVDA	Stock	0.6063	0.612	0.6056	0.6113	49412800.0
2015-10-02 13:00:00	NVDA	Stock	0.6115	0.6154	0.6093	0.6113	37863120.0
2015-10-02 14:00:00	NVDA	Stock	0.6113	0.6156	0.611	0.6135	49991920.0
2015-10-02 15:00:00	NVDA	Stock	0.6135	0.62	0.6128	0.62	74234640.0
2015-10-02 16:00:00	NVDA	Stock	0.62	0.62	0.62	0.62	968200.0
2015-10-02 17:00:00	NVDA	Stock	0.62	0.62	0.62	0.62	51960.0
2015-10-02 04:00:00	AMZN	Stock	26.1055	26.135	26.1055	26.135	4200.0
2015-10-02 05:00:00	AMZN	Stock	26.135	26.135	26.135	26.135	2100.0
2015-10-02 06:00:00	AMZN	Stock	26.124	26.124	26.1065	26.1065	6200.0
2015-10-02 07:00:00	AMZN	Stock	26.171	26.2	26.159	26.159	30700.0
2015-10-02 08:00:00	AMZN	Stock	26.2125	26.2125	25.62	25.728	417960.0
2015-10-02 09:00:00	AMZN	Stock	25.71	25.7115	25.405	25.635	10951480.0
2015-10-02 10:00:00	AMZN	Stock	25.627	25.9395	25.53	25.9225	12549140.0
2015-10-02 11:00:00	AMZN	Stock	25.929	26.0	25.8035	25.976	9099680.0
2015-10-02 12:00:00	AMZN	Stock	25.9575	26.308	25.8945	26.261	9629960.0

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

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