PREVIEW / stock_1hour / 2015-08-28

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-08-28.parquet
  size:    1.0 MB
  rows:    48,850
  symbols: 3,468

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-08-28 04:00:00	AAPL	Stock	28.325	28.325	28.1	28.12	93668.0
2015-08-28 05:00:00	AAPL	Stock	28.1325	28.1825	28.0575	28.1825	47336.0
2015-08-28 06:00:00	AAPL	Stock	28.195	28.2475	28.0425	28.0425	114792.0
2015-08-28 07:00:00	AAPL	Stock	28.0225	28.1175	27.9875	28.065	112740.0
2015-08-28 08:00:00	AAPL	Stock	28.0675	28.1125	27.965	28.0425	703956.0
2015-08-28 09:00:00	AAPL	Stock	28.0375	28.21	27.8125	28.025	29795756.0
2015-08-28 10:00:00	AAPL	Stock	28.025	28.129	27.885	28.0275	32805444.0
2015-08-28 11:00:00	AAPL	Stock	28.0228	28.3175	28.015	28.0925	30691100.0
2015-08-28 12:00:00	AAPL	Stock	28.0925	28.245	28.0675	28.19	17911056.0
2015-08-28 13:00:00	AAPL	Stock	28.1948	28.2175	28.005	28.1	18373068.0
2015-08-28 14:00:00	AAPL	Stock	28.1012	28.27	28.095	28.1925	20297420.0
2015-08-28 15:00:00	AAPL	Stock	28.1925	28.3275	28.055	28.32	37545756.0
2015-08-28 16:00:00	AAPL	Stock	28.32	28.3625	28.0638	28.27	13030740.0
2015-08-28 17:00:00	AAPL	Stock	28.28	28.3275	28.2525	28.3258	197548.0
2015-08-28 18:00:00	AAPL	Stock	28.3275	28.3425	28.3125	28.32	103300.0
2015-08-28 19:00:00	AAPL	Stock	28.3225	28.3425	28.3175	28.3425	111140.0
2015-08-28 04:00:00	MSFT	Stock	43.8	43.8	43.8	43.8	1867.0
2015-08-28 05:00:00	MSFT	Stock	43.49	43.77	43.49	43.77	298.0
2015-08-28 06:00:00	MSFT	Stock	43.77	43.8	43.51	43.77	3525.0
2015-08-28 07:00:00	MSFT	Stock	43.48	43.7	43.48	43.65	600.0
2015-08-28 08:00:00	MSFT	Stock	43.48	43.75	43.48	43.69	3321.0
2015-08-28 09:00:00	MSFT	Stock	43.7	43.86	43.39	43.81	4312786.0
2015-08-28 10:00:00	MSFT	Stock	43.8	43.87	43.52	43.81	3725040.0
2015-08-28 11:00:00	MSFT	Stock	43.81	44.15	43.67	43.73	3218545.0
2015-08-28 12:00:00	MSFT	Stock	43.73	44.0	43.68	43.965	2123917.0
2015-08-28 13:00:00	MSFT	Stock	43.97	43.99	43.68	43.765	2326592.0
2015-08-28 14:00:00	MSFT	Stock	43.77	43.94	43.675	43.9	2070707.0
2015-08-28 15:00:00	MSFT	Stock	43.905	43.98	43.61	43.92	5718170.0
2015-08-28 16:00:00	MSFT	Stock	43.93	43.99	43.9	43.9	3621415.0
2015-08-28 17:00:00	MSFT	Stock	43.977	43.978	43.903	43.903	2620.0
2015-08-28 18:00:00	MSFT	Stock	43.91	43.91	43.91	43.91	100.0
2015-08-28 19:00:00	MSFT	Stock	43.97	43.98	43.94	43.94	900.0
2015-08-28 09:00:00	NVDA	Stock	0.555	0.5718	0.5502	0.5695	32454480.0
2015-08-28 10:00:00	NVDA	Stock	0.5694	0.5697	0.5616	0.5632	63150880.0
2015-08-28 11:00:00	NVDA	Stock	0.5632	0.568	0.5628	0.564	31733680.0
2015-08-28 12:00:00	NVDA	Stock	0.564	0.568	0.5638	0.567	17930840.0
2015-08-28 13:00:00	NVDA	Stock	0.5672	0.5685	0.5645	0.5668	24774920.0
2015-08-28 14:00:00	NVDA	Stock	0.567	0.5694	0.5645	0.5684	34495960.0
2015-08-28 15:00:00	NVDA	Stock	0.5685	0.5695	0.5655	0.5682	91976320.0
2015-08-28 16:00:00	NVDA	Stock	0.5682	0.5685	0.5675	0.5675	12811440.0
2015-08-28 19:00:00	NVDA	Stock	0.5672	0.5672	0.5668	0.5668	20000.0
2015-08-28 04:00:00	AMZN	Stock	25.7865	25.932	25.7865	25.8	70800.0
2015-08-28 05:00:00	AMZN	Stock	25.8	25.8375	25.775	25.8375	23600.0
2015-08-28 06:00:00	AMZN	Stock	25.8	25.8	25.8	25.8	3000.0
2015-08-28 07:00:00	AMZN	Stock	25.7745	25.7875	25.7735	25.7855	32800.0
2015-08-28 08:00:00	AMZN	Stock	25.798	25.832	25.7255	25.8	105900.0
2015-08-28 09:00:00	AMZN	Stock	25.79	25.945	25.6575	25.835	7904740.0
2015-08-28 10:00:00	AMZN	Stock	25.8299	25.8625	25.652	25.784	7109940.0
2015-08-28 11:00:00	AMZN	Stock	25.795	26.075	25.771	25.81	8516720.0
2015-08-28 12:00:00	AMZN	Stock	25.8025	25.879	25.726	25.8209	3659040.0

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

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