PREVIEW / stock_1hour / 2015-09-21

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-09-21.parquet
  size:    1.0 MB
  rows:    48,767
  symbols: 3,451

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-09-21 04:00:00	AAPL	Stock	28.3725	28.4	28.2775	28.4	53052.0
2015-09-21 05:00:00	AAPL	Stock	28.4025	28.4525	28.4025	28.4525	6644.0
2015-09-21 06:00:00	AAPL	Stock	28.46	28.475	28.4125	28.4175	5572.0
2015-09-21 07:00:00	AAPL	Stock	28.4475	28.625	28.4475	28.5875	254464.0
2015-09-21 08:00:00	AAPL	Stock	28.5975	28.6125	28.4875	28.53	580824.0
2015-09-21 09:00:00	AAPL	Stock	28.5325	28.64	28.41	28.58	22097284.0
2015-09-21 10:00:00	AAPL	Stock	28.5775	28.71	28.545	28.6738	25580932.0
2015-09-21 11:00:00	AAPL	Stock	28.6725	28.75	28.555	28.57	20205560.0
2015-09-21 12:00:00	AAPL	Stock	28.575	28.585	28.43	28.465	18353012.0
2015-09-21 13:00:00	AAPL	Stock	28.465	28.71	28.453	28.615	20622888.0
2015-09-21 14:00:00	AAPL	Stock	28.6125	28.825	28.6075	28.8122	25042044.0
2015-09-21 15:00:00	AAPL	Stock	28.8125	28.8425	28.6952	28.805	28322888.0
2015-09-21 16:00:00	AAPL	Stock	28.8025	28.8725	28.8025	28.8375	13503584.0
2015-09-21 17:00:00	AAPL	Stock	28.8475	28.85	28.825	28.8275	59060.0
2015-09-21 18:00:00	AAPL	Stock	28.8475	28.875	28.8175	28.82	111064.0
2015-09-21 19:00:00	AAPL	Stock	28.83	28.8475	28.83	28.8375	72936.0
2015-09-21 07:00:00	MSFT	Stock	43.7	43.95	43.7	43.9	4868.0
2015-09-21 08:00:00	MSFT	Stock	43.85	43.9	43.8	43.83	25838.0
2015-09-21 09:00:00	MSFT	Stock	43.86	44.0	43.6	43.9	2626395.0
2015-09-21 10:00:00	MSFT	Stock	43.91	44.47	43.895	44.305	3942656.0
2015-09-21 11:00:00	MSFT	Stock	44.31	44.35	44.09	44.16	2369573.0
2015-09-21 12:00:00	MSFT	Stock	44.16	44.175	43.8	43.905	2402986.0
2015-09-21 13:00:00	MSFT	Stock	43.9	44.25	43.88	44.17	1752390.0
2015-09-21 14:00:00	MSFT	Stock	44.17	44.45	44.09	44.41	2980951.0
2015-09-21 15:00:00	MSFT	Stock	44.4	44.42	44.08	44.13	5333893.0
2015-09-21 16:00:00	MSFT	Stock	44.11	44.28	44.11	44.22	3718117.0
2015-09-21 08:00:00	NVDA	Stock	0.5883	0.5883	0.5875	0.5875	52000.0
2015-09-21 09:00:00	NVDA	Stock	0.5825	0.5848	0.5805	0.5806	23086920.0
2015-09-21 10:00:00	NVDA	Stock	0.5809	0.5888	0.58	0.5886	39136000.0
2015-09-21 11:00:00	NVDA	Stock	0.5888	0.589	0.584	0.585	38715800.0
2015-09-21 12:00:00	NVDA	Stock	0.585	0.585	0.582	0.5825	32429840.0
2015-09-21 13:00:00	NVDA	Stock	0.5825	0.585	0.5824	0.5838	23412560.0
2015-09-21 14:00:00	NVDA	Stock	0.5838	0.5888	0.5838	0.5886	35713440.0
2015-09-21 15:00:00	NVDA	Stock	0.5888	0.5895	0.5855	0.5883	64055760.0
2015-09-21 16:00:00	NVDA	Stock	0.5883	0.5888	0.5875	0.5884	10437760.0
2015-09-21 17:00:00	NVDA	Stock	0.5915	0.5915	0.5915	0.5915	16000.0
2015-09-21 04:00:00	AMZN	Stock	26.9845	27.077	26.9835	27.077	12020.0
2015-09-21 05:00:00	AMZN	Stock	27.11	27.11	27.11	27.11	3580.0
2015-09-21 06:00:00	AMZN	Stock	27.1185	27.1185	27.1185	27.1185	4000.0
2015-09-21 07:00:00	AMZN	Stock	27.1445	27.205	27.1445	27.205	238340.0
2015-09-21 08:00:00	AMZN	Stock	27.2165	27.2165	27.135	27.188	133460.0
2015-09-21 09:00:00	AMZN	Stock	27.1665	27.285	26.9795	27.1315	8245520.0
2015-09-21 10:00:00	AMZN	Stock	27.1435	27.4455	27.0752	27.4195	10509260.0
2015-09-21 11:00:00	AMZN	Stock	27.431	27.4775	27.2805	27.325	7534780.0
2015-09-21 12:00:00	AMZN	Stock	27.3075	27.3075	27.0122	27.0835	6663860.0
2015-09-21 13:00:00	AMZN	Stock	27.0685	27.3195	27.0565	27.222	6176620.0
2015-09-21 14:00:00	AMZN	Stock	27.233	27.4675	27.2125	27.417	5907540.0
2015-09-21 15:00:00	AMZN	Stock	27.426	27.489	27.325	27.4195	11121500.0
2015-09-21 16:00:00	AMZN	Stock	27.4195	27.46	27.4195	27.4315	2563020.0
2015-09-21 17:00:00	AMZN	Stock	27.4195	27.446	27.4195	27.435	215040.0

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

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