PREVIEW / stock_1hour / 2015-01-22

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-01-22.parquet
  size:    1.0 MB
  rows:    49,215
  symbols: 3,528

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-01-22 04:00:00	AAPL	Stock	27.46	27.48	27.4	27.4	8160.0
2015-01-22 05:00:00	AAPL	Stock	27.48	27.48	27.4675	27.4675	2800.0
2015-01-22 06:00:00	AAPL	Stock	27.4375	27.44	27.3	27.3975	27316.0
2015-01-22 07:00:00	AAPL	Stock	27.3975	27.5075	27.35	27.5	236552.0
2015-01-22 08:00:00	AAPL	Stock	27.5	27.6	27.375	27.5075	1152468.0
2015-01-22 09:00:00	AAPL	Stock	27.5225	27.755	27.43	27.5428	31404900.0
2015-01-22 10:00:00	AAPL	Stock	27.545	27.83	27.5375	27.8125	31783252.0
2015-01-22 11:00:00	AAPL	Stock	27.8125	27.9175	27.7475	27.8875	25013868.0
2015-01-22 12:00:00	AAPL	Stock	27.8875	27.9175	27.7825	27.824	15340692.0
2015-01-22 13:00:00	AAPL	Stock	27.8228	27.869	27.7775	27.868	9596472.0
2015-01-22 14:00:00	AAPL	Stock	27.87	27.995	27.84	27.971	16600856.0
2015-01-22 15:00:00	AAPL	Stock	27.9725	28.1175	27.96	28.0975	35440184.0
2015-01-22 16:00:00	AAPL	Stock	28.1	28.1075	27.8098	28.09	23449648.0
2015-01-22 17:00:00	AAPL	Stock	28.0975	28.1	28.0875	28.095	516416.0
2015-01-22 18:00:00	AAPL	Stock	28.0975	28.1	28.025	28.05	90384.0
2015-01-22 19:00:00	AAPL	Stock	28.05	28.07	28.0325	28.0525	107200.0
2015-01-22 04:00:00	MSFT	Stock	46.12	46.25	46.12	46.14	860.0
2015-01-22 06:00:00	MSFT	Stock	46.15	46.15	46.14	46.14	200.0
2015-01-22 07:00:00	MSFT	Stock	46.15	46.24	46.09	46.15	3060.0
2015-01-22 08:00:00	MSFT	Stock	46.1	46.44	46.09	46.2	34250.0
2015-01-22 09:00:00	MSFT	Stock	46.2	46.7	46.08	46.395	6405560.0
2015-01-22 10:00:00	MSFT	Stock	46.4	46.789	46.244	46.77	6089751.0
2015-01-22 11:00:00	MSFT	Stock	46.77	46.99	46.65	46.805	3757043.0
2015-01-22 12:00:00	MSFT	Stock	46.8	46.82	46.61	46.655	2163450.0
2015-01-22 13:00:00	MSFT	Stock	46.656	46.75	46.53	46.64	1853258.0
2015-01-22 14:00:00	MSFT	Stock	46.64	47.04	46.58	46.99	2822078.0
2015-01-22 15:00:00	MSFT	Stock	46.99	47.135	46.95	47.12	5797755.0
2015-01-22 16:00:00	MSFT	Stock	47.13	47.18	46.317	46.712	5915633.0
2015-01-22 17:00:00	MSFT	Stock	47.13	47.13	47.1	47.1	172053.0
2015-01-22 18:00:00	MSFT	Stock	47.1	47.13	47.09	47.11	8023.0
2015-01-22 19:00:00	MSFT	Stock	47.1	47.11	47.1	47.11	650.0
2015-01-22 08:00:00	NVDA	Stock	0.51	0.5102	0.51	0.51	73200.0
2015-01-22 09:00:00	NVDA	Stock	0.51	0.51	0.5032	0.507	23121280.0
2015-01-22 10:00:00	NVDA	Stock	0.507	0.5109	0.506	0.5105	23064200.0
2015-01-22 11:00:00	NVDA	Stock	0.5105	0.5115	0.5098	0.5108	15515680.0
2015-01-22 12:00:00	NVDA	Stock	0.511	0.511	0.5093	0.5102	8373000.0
2015-01-22 13:00:00	NVDA	Stock	0.5104	0.5112	0.5093	0.5105	8277080.0
2015-01-22 14:00:00	NVDA	Stock	0.5108	0.5155	0.5102	0.5152	13784240.0
2015-01-22 15:00:00	NVDA	Stock	0.5155	0.5176	0.5142	0.516	45689920.0
2015-01-22 16:00:00	NVDA	Stock	0.5162	0.5163	0.5062	0.5109	17108480.0
2015-01-22 17:00:00	NVDA	Stock	0.5162	0.5162	0.5162	0.5162	314280.0
2015-01-22 04:00:00	AMZN	Stock	14.875	14.875	14.875	14.875	2380.0
2015-01-22 06:00:00	AMZN	Stock	14.89	14.89	14.89	14.89	2040.0
2015-01-22 07:00:00	AMZN	Stock	14.896	14.896	14.89	14.89	8120.0
2015-01-22 08:00:00	AMZN	Stock	14.905	14.9725	14.876	14.915	109180.0
2015-01-22 09:00:00	AMZN	Stock	14.9245	15.1945	14.9245	15.131	15112440.0
2015-01-22 10:00:00	AMZN	Stock	15.124	15.423	15.114	15.4218	22490080.0
2015-01-22 11:00:00	AMZN	Stock	15.4175	15.469	15.327	15.403	13255940.0
2015-01-22 12:00:00	AMZN	Stock	15.4035	15.4795	15.389	15.44	7773620.0
2015-01-22 13:00:00	AMZN	Stock	15.44	15.465	15.38	15.4	6369680.0

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

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