PREVIEW / stock_1hour / 2016-11-10

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-11-10.parquet
  size:    1.1 MB
  rows:    49,750
  symbols: 3,198

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-11-10 04:00:00	AAPL	Stock	27.885	28.0	27.885	27.9875	13672.0
2016-11-10 05:00:00	AAPL	Stock	27.9375	27.9675	27.9375	27.9425	4372.0
2016-11-10 06:00:00	AAPL	Stock	27.9625	27.9625	27.8775	27.935	24212.0
2016-11-10 07:00:00	AAPL	Stock	27.935	27.9475	27.7175	27.75	238192.0
2016-11-10 08:00:00	AAPL	Stock	27.7475	27.925	27.7125	27.7425	628572.0
2016-11-10 09:00:00	AAPL	Stock	27.7425	27.8	27.5312	27.5725	20908652.0
2016-11-10 10:00:00	AAPL	Stock	27.5775	27.65	26.4575	26.745	68453580.0
2016-11-10 11:00:00	AAPL	Stock	26.745	27.005	26.6975	26.85	33616096.0
2016-11-10 12:00:00	AAPL	Stock	26.8475	27.0175	26.775	27.0142	19556376.0
2016-11-10 13:00:00	AAPL	Stock	27.015	27.2	26.9538	27.1175	17993352.0
2016-11-10 14:00:00	AAPL	Stock	27.1168	27.1925	27.0475	27.1475	14228436.0
2016-11-10 15:00:00	AAPL	Stock	27.1475	27.17	26.8488	26.9475	27243168.0
2016-11-10 16:00:00	AAPL	Stock	26.9475	27.08	26.885	26.9175	8120772.0
2016-11-10 17:00:00	AAPL	Stock	26.9175	26.9625	26.9	26.94	121784.0
2016-11-10 18:00:00	AAPL	Stock	26.96	26.97	26.915	26.9275	62920.0
2016-11-10 19:00:00	AAPL	Stock	26.9275	26.9475	26.925	26.925	38608.0
2016-11-10 04:00:00	MSFT	Stock	60.87	60.87	60.87	60.87	2075.0
2016-11-10 05:00:00	MSFT	Stock	60.75	60.75	60.75	60.75	100.0
2016-11-10 06:00:00	MSFT	Stock	60.71	60.71	60.71	60.71	794.0
2016-11-10 07:00:00	MSFT	Stock	60.41	60.45	60.41	60.45	503.0
2016-11-10 08:00:00	MSFT	Stock	60.6	60.67	60.4	60.4	7248.0
2016-11-10 09:00:00	MSFT	Stock	60.4	60.5	59.664	59.665	4978156.0
2016-11-10 10:00:00	MSFT	Stock	59.665	59.8	57.63	57.927	14336199.0
2016-11-10 11:00:00	MSFT	Stock	57.92	58.7	57.9	58.335	9223186.0
2016-11-10 12:00:00	MSFT	Stock	58.33	58.77	58.21	58.76	5599420.0
2016-11-10 13:00:00	MSFT	Stock	58.767	59.18	58.67	59.125	5543986.0
2016-11-10 14:00:00	MSFT	Stock	59.125	59.375	59.02	59.355	3916916.0
2016-11-10 15:00:00	MSFT	Stock	59.36	59.38	58.62	58.71	7306476.0
2016-11-10 16:00:00	MSFT	Stock	58.7	58.8	58.6	58.8	2646503.0
2016-11-10 17:00:00	MSFT	Stock	58.7	58.8	58.6	58.78	947967.0
2016-11-10 18:00:00	MSFT	Stock	58.72	58.72	58.72	58.72	1000.0
2016-11-10 19:00:00	MSFT	Stock	58.75	58.75	58.75	58.75	275.0
2016-11-10 05:00:00	NVDA	Stock	1.775	1.775	1.775	1.775	24000.0
2016-11-10 06:00:00	NVDA	Stock	1.775	1.775	1.775	1.775	28000.0
2016-11-10 07:00:00	NVDA	Stock	1.7753	1.786	1.7688	1.7788	290440.0
2016-11-10 08:00:00	NVDA	Stock	1.7818	1.795	1.7778	1.7862	717200.0
2016-11-10 09:00:00	NVDA	Stock	1.7855	1.7888	1.7625	1.7638	62891400.0
2016-11-10 10:00:00	NVDA	Stock	1.7638	1.7698	1.669	1.672	140512920.0
2016-11-10 11:00:00	NVDA	Stock	1.6712	1.718	1.671	1.6954	85969120.0
2016-11-10 12:00:00	NVDA	Stock	1.6952	1.7028	1.6755	1.6885	62184240.0
2016-11-10 13:00:00	NVDA	Stock	1.6885	1.7008	1.6805	1.6968	58737400.0
2016-11-10 14:00:00	NVDA	Stock	1.6962	1.7052	1.6875	1.6928	74887520.0
2016-11-10 15:00:00	NVDA	Stock	1.6929	1.6992	1.6905	1.6942	142839440.0
2016-11-10 16:00:00	NVDA	Stock	1.6942	1.936	1.6925	1.933	115660440.0
2016-11-10 17:00:00	NVDA	Stock	1.9348	1.9663	1.9312	1.9595	33530520.0
2016-11-10 18:00:00	NVDA	Stock	1.9595	1.9612	1.939	1.939	13077880.0
2016-11-10 19:00:00	NVDA	Stock	1.939	1.9512	1.9385	1.9438	9673480.0
2016-11-10 04:00:00	AMZN	Stock	39.05	39.05	38.833	38.95	29340.0
2016-11-10 05:00:00	AMZN	Stock	39.021	39.021	39.0135	39.0135	10740.0
2016-11-10 06:00:00	AMZN	Stock	39.048	39.048	39.043	39.043	5020.0

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

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