PREVIEW / stock_1hour / 2016-02-12

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-02-12.parquet
  size:    1.0 MB
  rows:    48,355
  symbols: 3,341

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-02-12 04:00:00	AAPL	Stock	23.525	23.665	23.525	23.5525	15372.0
2016-02-12 06:00:00	AAPL	Stock	23.55	23.6875	23.55	23.6875	53544.0
2016-02-12 07:00:00	AAPL	Stock	23.665	23.675	23.6025	23.6125	112388.0
2016-02-12 08:00:00	AAPL	Stock	23.6125	23.6425	23.5225	23.5525	406772.0
2016-02-12 09:00:00	AAPL	Stock	23.545	23.6425	23.305	23.3175	19728544.0
2016-02-12 10:00:00	AAPL	Stock	23.3175	23.385	23.2525	23.3075	25766628.0
2016-02-12 11:00:00	AAPL	Stock	23.31	23.565	23.31	23.49	23850732.0
2016-02-12 12:00:00	AAPL	Stock	23.4925	23.51	23.42	23.4375	11235456.0
2016-02-12 13:00:00	AAPL	Stock	23.435	23.445	23.345	23.3625	12792320.0
2016-02-12 14:00:00	AAPL	Stock	23.365	23.505	23.3588	23.4675	16364320.0
2016-02-12 15:00:00	AAPL	Stock	23.4675	23.5525	23.41	23.4975	28067988.0
2016-02-12 16:00:00	AAPL	Stock	23.4975	23.4975	23.4338	23.46	9772536.0
2016-02-12 17:00:00	AAPL	Stock	23.45	23.4625	23.2785	23.455	99224.0
2016-02-12 18:00:00	AAPL	Stock	23.455	23.4625	23.4425	23.4625	34464.0
2016-02-12 19:00:00	AAPL	Stock	23.4625	23.4625	23.4375	23.4625	30508.0
2016-02-12 04:00:00	MSFT	Stock	50.1	50.1	50.1	50.1	2223.0
2016-02-12 05:00:00	MSFT	Stock	50.12	50.12	50.12	50.12	100.0
2016-02-12 06:00:00	MSFT	Stock	50.29	50.29	50.29	50.29	120.0
2016-02-12 07:00:00	MSFT	Stock	50.29	50.3	50.1	50.25	11645.0
2016-02-12 08:00:00	MSFT	Stock	50.1	50.3	50.05	50.24	40371.0
2016-02-12 09:00:00	MSFT	Stock	50.2	50.35	49.81	49.87	3591019.0
2016-02-12 10:00:00	MSFT	Stock	49.87	50.17	49.75	50.09	3409984.0
2016-02-12 11:00:00	MSFT	Stock	50.095	50.68	50.01	50.34	3584663.0
2016-02-12 12:00:00	MSFT	Stock	50.35	50.43	50.19	50.208	2945515.0
2016-02-12 13:00:00	MSFT	Stock	50.2	50.24	49.91	49.98	2366381.0
2016-02-12 14:00:00	MSFT	Stock	49.975	50.52	49.96	50.51	3106689.0
2016-02-12 15:00:00	MSFT	Stock	50.51	50.51	50.265	50.5	7855605.0
2016-02-12 16:00:00	MSFT	Stock	50.5	50.52	50.4	50.5	3809512.0
2016-02-12 17:00:00	MSFT	Stock	49.922	50.48	49.922	50.48	16454.0
2016-02-12 18:00:00	MSFT	Stock	50.49	50.5	50.42	50.42	2695.0
2016-02-12 19:00:00	MSFT	Stock	50.49	50.49	50.49	50.49	3740.0
2016-02-12 09:00:00	NVDA	Stock	0.6458	0.6463	0.6215	0.6221	29858720.0
2016-02-12 10:00:00	NVDA	Stock	0.6221	0.6295	0.6188	0.6278	60280760.0
2016-02-12 11:00:00	NVDA	Stock	0.628	0.643	0.628	0.6405	57622440.0
2016-02-12 12:00:00	NVDA	Stock	0.6405	0.6442	0.64	0.6404	23032080.0
2016-02-12 13:00:00	NVDA	Stock	0.6405	0.6408	0.6355	0.6365	19324680.0
2016-02-12 14:00:00	NVDA	Stock	0.6368	0.6442	0.6362	0.6415	42407000.0
2016-02-12 15:00:00	NVDA	Stock	0.6415	0.6445	0.6401	0.6428	62549480.0
2016-02-12 16:00:00	NVDA	Stock	0.6428	0.6433	0.6428	0.6433	21904640.0
2016-02-12 17:00:00	NVDA	Stock	0.6242	0.6242	0.6242	0.6242	171960.0
2016-02-12 06:00:00	AMZN	Stock	25.537	25.537	25.4625	25.52	19720.0
2016-02-12 07:00:00	AMZN	Stock	25.5085	25.55	25.4245	25.4255	105380.0
2016-02-12 08:00:00	AMZN	Stock	25.55	25.55	25.4	25.525	490000.0
2016-02-12 09:00:00	AMZN	Stock	25.5	25.821	25.437	25.564	20709100.0
2016-02-12 10:00:00	AMZN	Stock	25.5755	25.7235	25.4115	25.6	19683600.0
2016-02-12 11:00:00	AMZN	Stock	25.588	25.8375	25.5771	25.6	16155180.0
2016-02-12 12:00:00	AMZN	Stock	25.603	25.6315	25.2645	25.2774	9938680.0
2016-02-12 13:00:00	AMZN	Stock	25.2771	25.3055	25.0747	25.243	11426580.0
2016-02-12 14:00:00	AMZN	Stock	25.256	25.41	25.191	25.3295	8452640.0
2016-02-12 15:00:00	AMZN	Stock	25.3185	25.485	25.301	25.3475	15705380.0

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

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