PREVIEW / stock_1hour / 2015-12-31

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-12-31.parquet
  size:    1.0 MB
  rows:    49,420
  symbols: 3,441

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-12-31 06:00:00	AAPL	Stock	26.88	26.8875	26.8775	26.88	3700.0
2015-12-31 07:00:00	AAPL	Stock	26.88	26.88	26.81	26.8125	24596.0
2015-12-31 08:00:00	AAPL	Stock	26.82	26.8775	26.75	26.755	118568.0
2015-12-31 09:00:00	AAPL	Stock	26.7725	26.7775	26.4725	26.5452	18956680.0
2015-12-31 10:00:00	AAPL	Stock	26.545	26.585	26.415	26.4675	21510664.0
2015-12-31 11:00:00	AAPL	Stock	26.465	26.5075	26.407	26.445	14530452.0
2015-12-31 12:00:00	AAPL	Stock	26.445	26.5225	26.4125	26.416	14776520.0
2015-12-31 13:00:00	AAPL	Stock	26.4162	26.42	26.335	26.375	16105700.0
2015-12-31 14:00:00	AAPL	Stock	26.375	26.375	26.205	26.305	24356032.0
2015-12-31 15:00:00	AAPL	Stock	26.305	26.385	26.25	26.3075	27500972.0
2015-12-31 16:00:00	AAPL	Stock	26.3075	26.3725	26.2695	26.35	11516204.0
2015-12-31 17:00:00	AAPL	Stock	26.35	26.3675	26.315	26.3675	256576.0
2015-12-31 18:00:00	AAPL	Stock	26.365	26.37	26.35	26.355	25968.0
2015-12-31 19:00:00	AAPL	Stock	26.3575	26.3775	26.34	26.365	43452.0
2015-12-31 08:00:00	MSFT	Stock	55.69	56.48	55.69	56.3	3650.0
2015-12-31 09:00:00	MSFT	Stock	56.2	56.2	55.68	55.79	2583887.0
2015-12-31 10:00:00	MSFT	Stock	55.78	55.834	55.42	55.56	3316184.0
2015-12-31 11:00:00	MSFT	Stock	55.56	55.86	55.52	55.814	3586043.0
2015-12-31 12:00:00	MSFT	Stock	55.82	56.19	55.81	56.05	2310371.0
2015-12-31 13:00:00	MSFT	Stock	56.04	56.08	55.85	55.98	1833495.0
2015-12-31 14:00:00	MSFT	Stock	55.98	56.0	55.575	55.67	2818929.0
2015-12-31 15:00:00	MSFT	Stock	55.67	55.84	55.45	55.45	4625142.0
2015-12-31 16:00:00	MSFT	Stock	55.48	55.65	55.4	55.53	3604497.0
2015-12-31 17:00:00	MSFT	Stock	55.53	55.6	55.48	55.53	35942.0
2015-12-31 18:00:00	MSFT	Stock	55.58	55.58	55.53	55.53	1850.0
2015-12-31 19:00:00	MSFT	Stock	55.58	55.58	55.5	55.55	400.0
2015-12-31 07:00:00	NVDA	Stock	0.8395	0.8395	0.8395	0.8395	60600.0
2015-12-31 09:00:00	NVDA	Stock	0.8338	0.8352	0.829	0.8344	16604080.0
2015-12-31 10:00:00	NVDA	Stock	0.8344	0.8355	0.8312	0.8331	25827720.0
2015-12-31 11:00:00	NVDA	Stock	0.8331	0.8369	0.8328	0.8365	15852760.0
2015-12-31 12:00:00	NVDA	Stock	0.8365	0.8372	0.8332	0.8332	10397640.0
2015-12-31 13:00:00	NVDA	Stock	0.8332	0.8338	0.8298	0.833	12594640.0
2015-12-31 14:00:00	NVDA	Stock	0.833	0.8332	0.8275	0.8292	11768080.0
2015-12-31 15:00:00	NVDA	Stock	0.8292	0.8292	0.824	0.824	36649160.0
2015-12-31 16:00:00	NVDA	Stock	0.824	0.8292	0.8238	0.8292	1350480.0
2015-12-31 07:00:00	AMZN	Stock	34.4625	34.4625	34.4625	34.4625	4000.0
2015-12-31 08:00:00	AMZN	Stock	34.375	34.3945	34.325	34.35	36840.0
2015-12-31 09:00:00	AMZN	Stock	34.35	34.3875	34.15	34.323	7510620.0
2015-12-31 10:00:00	AMZN	Stock	34.3085	34.3545	34.125	34.175	6557340.0
2015-12-31 11:00:00	AMZN	Stock	34.1649	34.3304	34.155	34.3235	4921760.0
2015-12-31 12:00:00	AMZN	Stock	34.32	34.32	34.2385	34.2569	5006600.0
2015-12-31 13:00:00	AMZN	Stock	34.2465	34.259	34.0335	34.128	10918060.0
2015-12-31 14:00:00	AMZN	Stock	34.136	34.139	33.9165	33.975	11104620.0
2015-12-31 15:00:00	AMZN	Stock	33.965	33.9685	33.7965	33.817	18135320.0
2015-12-31 16:00:00	AMZN	Stock	33.7945	33.83	33.79	33.8	1187200.0
2015-12-31 17:00:00	AMZN	Stock	33.7945	33.8005	33.7525	33.7525	152500.0
2015-12-31 18:00:00	AMZN	Stock	33.807	33.8075	33.7875	33.7875	10900.0
2015-12-31 19:00:00	AMZN	Stock	33.815	33.8275	33.815	33.8275	15700.0
2015-12-31 08:00:00	GOOGL	Stock	39.3935	39.44	39.3935	39.44	38000.0
2015-12-31 09:00:00	GOOGL	Stock	39.425	39.425	39.2316	39.3148	2385820.0

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

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